Ali3NDaily ETH Swapping By Miners
Updated 2022-09-28
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select case when block_timestamp >= '2022-07-15' 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) as Volume
from ethereum.core.ez_dex_swaps
where timespan is not null and symbol_in in ('WETH','ETH','aETH','aWETH','cETH','cbETH','fETH','iETH','ibETH','icETH','pETH','rETH','sETH','stETH','stkETH','vETH','wstETH')
and origin_from_address in (select miner from ethereum.core.fact_blocks)
group by 1,2
Run a query to Download Data