kasadeghUntitled Query
Updated 2022-11-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
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