boomer77tx count by tokens hop
Updated 2022-04-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date(block_timestamp) as dt, contract_address, sum(event_inputs:amount/1e18) as volume, case
when contract_address = '0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2' then 'matic'
when contract_address = '0x3666f603cc164936c1b87e207f36beba4ac5f18a' then 'usdc'
when contract_address = '0x3e4a3a4796d16c0cd582c382691998f7c06420b6' then 'usdt'
when contract_address = '0xb8901acb165ed027e32754e0ffe830802919727f' then 'eth'
when contract_address = '0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1' then 'dai'
else null end as currency,
count(distinct event_inputs:recipient::string) as sender_count, count(distinct tx_hash) as tx_count
from ethereum_core.fact_event_logs
where contract_address in ('0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2', '0x3666f603cc164936c1b87e207f36beba4ac5f18a', '0x3e4a3a4796d16c0cd582c382691998f7c06420b6',
'0xb8901acb165ed027e32754e0ffe830802919727f', '0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1')
and event_name = 'TransferSentToL2' and year(block_timestamp) = '2022'
group by 1,2
Run a query to Download Data