angel09-SK3z3aVolume of $DAI Bridges per month
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
›
⌄
with eth_to_optimism_daily as (select sum(amount) as eth_value , block_timestamp::date as date
from ethereum.core.ez_token_transfers
where amount>0 and symbol='DAI' and to_address in (select address from ethereum.core.dim_labels where label='optimism')
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_token_transfers
where amount>0 and symbol='DAI' and to_address in (select address from ethereum.core.dim_labels where label='optimism')
group by date)
,optimism_to_eth_daily as (select sum(amount) as eth_value , block_timestamp::date as date
from ethereum.core.ez_token_transfers
where amount>0 and symbol='DAI' and from_address in (select address from ethereum.core.dim_labels where label='optimism')
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_token_transfers
where amount>0 and symbol='DAI' and from_address in (select address from ethereum.core.dim_labels where label='optimism')
group by date)
select 'eth to optimism',* from eth_to_optimism_monthly
UNION
select 'optimism to eth',* from optimism_to_eth_monthly
Run a query to Download Data