kasadeghUntitled Query
    Updated 2022-11-30
    select 'Across' as bridge_name,
    date_trunc(day,block_timestamp) as date,
    avg (current_bal_usd) as TVL
    from ethereum.core.ez_balance_deltas
    where user_address = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')
    group by 1,2

    union ALL

    select 'Hop' as bridge_name,
    date_trunc(day,block_timestamp) as date,
    avg (current_bal_usd) as TVL
    from ethereum.core.ez_balance_deltas
    where user_address in ('0xb8901acb165ed027e32754e0ffe830802919727f','0x3666f603cc164936c1b87e207f36beba4ac5f18a','0x3e4a3a4796d16c0cd582c382691998f7c06420b6','0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1','0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2')
    group by 1,2
    union ALL

    select 'Synapse' as bridge_name,
    date_trunc(day,block_timestamp) as date,
    avg (current_bal_usd) as TVL
    from ethereum.core.ez_balance_deltas
    where user_address = lower('0x2796317b0ff8538f253012862c06787adfb8ceb6')
    group by 1,2
    Run a query to Download Data