MostafaUntitled Query
Updated 2022-09-29Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
CASE
when block_timestamp::date >= '2022-08-01' and block_timestamp::date <'2022-09-15' then 'Before Merge'
when block_timestamp::date >= '2022-09-15' then 'After Merge' else null end as timeline,
date_trunc('day', block_timestamp) as date,
count(DISTINCT tx_hash) as swaps,
count(DISTINCT origin_from_address) as swappers,
sum (amount_out_usd) as Volume
FROM ethereum.core.ez_dex_swaps
where timeline is not NULL
GROUP BY 1,2
Run a query to Download Data