shadilHop bridge volume
    Updated 2022-04-19
    with first_query as
    (select sum(event_inputs:value)/pow(10,18) as total_volume,
    count(distinct event_inputs:from) as total_wallets,
    date(block_timestamp) as date_time
    from ethereum_core.fact_event_logs
    where date(block_timestamp) >= '2022-01-01'
    and event_name = 'Transfer'
    and lower(contract_address) = lower('0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0')
    and lower(event_inputs:to::String) = lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2')
    group by date_time)

    select total_volume,
    total_wallets,
    date_time
    from first_query
    Run a query to Download Data