angel09-SK3z3aVolume of $ETH Bridges per day
Updated 2022-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with eth_to_optimism_daily as (select sum(amount) as eth_value , block_timestamp::date as date
from ethereum.core.ez_eth_transfers
where amount>0 and eth_to_address in ('0x10e6593cdda8c58a1d0f14c5164b376352a55f2f','0x99c9fc46f92e8a1c0dec1b1747d010903e884be1','0xaba2c5f108f7e820c049d5af70b16ac266c8f128','0xf20c38fcddf0c790319fd7431d17ea0c2bc9959c')
group by date)
, eth_to_optimism_monthly as (select sum(amount) as eth_value , date_trunc('month', block_timestamp) as date
from ethereum.core.ez_eth_transfers
where amount>0 and eth_to_address in ('0x10e6593cdda8c58a1d0f14c5164b376352a55f2f','0x99c9fc46f92e8a1c0dec1b1747d010903e884be1','0xaba2c5f108f7e820c049d5af70b16ac266c8f128','0xf20c38fcddf0c790319fd7431d17ea0c2bc9959c')
group by date)
,optimism_to_eth_daily as (select sum(amount) as eth_value , block_timestamp::date as date
from ethereum.core.ez_eth_transfers
where amount>0 and eth_from_address in ('0x10e6593cdda8c58a1d0f14c5164b376352a55f2f','0x99c9fc46f92e8a1c0dec1b1747d010903e884be1','0xaba2c5f108f7e820c049d5af70b16ac266c8f128','0xf20c38fcddf0c790319fd7431d17ea0c2bc9959c')
group by date)
,optimism_to_eth_monthly as (select sum(amount) as eth_value , date_trunc('month', block_timestamp) as date
from ethereum.core.ez_eth_transfers
where amount>0 and eth_from_address in ('0x10e6593cdda8c58a1d0f14c5164b376352a55f2f','0x99c9fc46f92e8a1c0dec1b1747d010903e884be1','0xaba2c5f108f7e820c049d5af70b16ac266c8f128','0xf20c38fcddf0c790319fd7431d17ea0c2bc9959c')
group by date)
select 'eth to optimism',* from eth_to_optimism_daily
UNION
select 'optimism to eth',* from optimism_to_eth_daily
Run a query to Download Data