Updated 2022-09-22
9
1
2
3
4
5
6
7
8
9
›
⌄
select case when block_timestamp >= '2022-08-01' and block_timestamp < '2022-09-15' then 'Before Merge'
when block_timestamp >= '2022-09-15' then 'Post Merge' else null end as timespan,
block_timestamp::date as date,
count (distinct tx_hash) as tx_count,
count (distinct origin_from_address) as Users_Count,
sum (amount_in_usd) as Volume
from ethereum.core.ez_dex_swaps
where timespan is not null and symbol_in = 'WETH'
group by 1,2
Run a query to Download Data