AlishHow Many Times was Hop used? Daily total bridges
Updated 2022-12-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with bridge as (
select
date(block_timestamp) as date , contract_address , tx_hash , EVENT_INPUTS:amount / pow(10,9)/1000000000 as total_amount
from ethereum_core.fact_event_logs
where event_name = 'TransferSentToL2'
and date >= '2022-01-01')
select date, case when contract_address = lower('0xb8901acb165ed027e32754e0ffe830802919727f') then 'ETHEREUM'
when contract_address = lower('0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2') then 'MATIC'
when contract_address = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a') then 'USDC'
when contract_address = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1') then 'DAI'
when contract_address = lower('0x3e4a3a4796d16c0cd582c382691998f7c06420b6') then 'USDT'
end as contracts, count(tx_hash) as total_bridge ,
sum(total_amount) as total_amount
from bridge
where contracts is not null and contracts != 'WBTC'
group by 1,2
order by 1
Run a query to Download Data