freemartianETH Volume - Native bridges
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select sum(amount) as eth_volume, date_trunc('week', block_timestamp::date) as TIME,
case when origin_to_address = '0xa0c68c638235ee32657e8f720a23cec1bfc77c77' then 'Polygon'
when origin_to_address = '0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef' then 'Arbitrum'
when origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' then 'Optimism'
end as native_bridge
from ethereum.core.ez_eth_transfers
where origin_to_address in (
'0xa0c68c638235ee32657e8f720a23cec1bfc77c77',
'0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef',
'0x99c9fc46f92e8a1c0dec1b1747d010903e884be1')
and block_timestamp > CURRENT_DATE -180
group by TIME, native_bridge
Run a query to Download Data