AlishHow Many Times was Hop used? Daily total bridges
    Updated 2022-12-05
    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