mz0111inflow outflow 6
Updated 2023-01-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
date_trunc(day,BLOCK_TIMESTAMP) as date ,
case when ORIGIN_TO_ADDRESS ='0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' then 'Ethereum to Optimistm'
when ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1' then 'Optimism to Ethereum'
end as bridge_type ,
count (DISTINCT tx_hash) num_bridges_ ,
count (DISTINCT ETH_FROM_ADDRESS ) num_wallets_,
sum (amount ) volume ,
sum (AMOUNT_USD) volume_usd ,
sum (volume) over (partition by bridge_type order by date ) cum_volume ,
sum (volume_usd) over (partition by bridge_type order by date ) cum_volume_usd
from ethereum.core.ez_eth_transfers
WHERE DATE >= CURRENT_DATE - 30
group by 1,2
having bridge_type is not NULL
Run a query to Download Data