freemartianPopular Assets To Bridge
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select count(distinct origin_from_address) as distinct_users, date_trunc('day', block_timestamp::date) as TIME,
case when origin_to_address = lower('0xb8901acB165ed027E32754E0FFe830802919727f') then 'ETH'
when origin_to_address = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1') then 'DAI'
when origin_to_address = lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6') then 'USDT'
when origin_to_address = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a') then 'USDC'
when origin_to_address = lower('0xb98454270065A31D71Bf635F6F7Ee6A518dFb849') then 'WBTC'
when origin_to_address = lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2') then 'Matic'
end as asset
from ethereum.core.fact_event_logs
where origin_to_address in (lower('0xb8901acB165ed027E32754E0FFe830802919727f'), lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1'),
lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6'), lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a'),
lower('0xb98454270065A31D71Bf635F6F7Ee6A518dFb849'), lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2'))
and block_timestamp > CURRENT_DATE - 180
and event_name = 'TransferSentToL2'
group by TIME, asset
Run a query to Download Data