hbd199444. Swaps Daily Review
Updated 2022-09-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with swap_data as (select
case
when block_number < '15537351' then 'Before The Merge'
when block_number >= '15537351' then 'After The Merge' end as date_status,*
FROM ethereum.core.ez_dex_swaps
where block_timestamp >= '2022-09-05')
select
date(block_timestamp) as date,
date_status,
count(*) as swap_count,
count(distinct ORIGIN_FROM_ADDRESS) as swapper_count
from swap_data
group by 1,2
Run a query to Download Data