LittlerDataEthereum Swaps since June 2022
    Updated 2023-01-20
    select
    date_trunc('day',block_timestamp) as day
    ,count(tx_hash) as swaps
    ,case
    when block_timestamp between '2023-01-01 06:00:00' and '2023-01-16 14:00:00' then 'During Pump'
    else 'Rest of the year'
    end as Period
    from ethereum.core.ez_dex_swaps
    where block_timestamp > '2022-06-01'
    group by 1, 3

    Run a query to Download Data