MostafaUntitled Query
    Updated 2022-09-29
    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