freemartianChain Specific Stablecoin Bridge - Number of Users
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select count(origin_from_address) as Bridge_users, date_trunc('week', block_timestamp::date) as TIME,
case when event_inputs:chainId = '10' then 'Optimism'
when event_inputs:chainId = '100' then 'Gnosis'
when event_inputs:chainId = '137' then 'Polygon'
when event_inputs:chainId = '42161' then 'arbitrum'
end as chain,
case when origin_to_address = lower('0x3666f603cc164936c1b87e207f36beba4ac5f18a') then 'USDC'
when origin_to_address = lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6') then 'USDT'
when origin_to_address = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1') then 'DAI'
end as asset
from ethereum.core.fact_event_logs
where origin_to_address in (lower('0x3666f603cc164936c1b87e207f36beba4ac5f18a'),
lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6'),
lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1'))
and event_name = 'TransferSentToL2'
and block_timestamp > CURRENT_DATE - 180
group by TIME, chain, asset
Run a query to Download Data