boomer77hop protocol matic
Updated 2022-04-28
9
1
2
3
4
5
6
7
›
⌄
select date(block_timestamp) as dt, contract_address, sum(event_inputs:amount/1e18) as volume,
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 = '0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2' and event_name = 'TransferSentToL2' and year(block_timestamp) = '2022'
group by 1,2
--0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2 matic, 0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a usdc
Run a query to Download Data