afonsoTotal Polygon Swap Numbers Before and After Christmas
    Updated 2023-01-14
    select
    iff(year(block_timestamp) = 2022, 'Before Christmas', 'After Christmas') as timespan,
    count(distinct tx_hash) as swaps_count,
    count(distinct sender) as senders_count,
    sum(amount_in_usd) as total_volume_usd,
    avg(amount_in_usd) as average_swap_amount
    from polygon.sushi.ez_swaps
    where block_timestamp between date('2023-01-01') - interval '1 weeks' and date('2023-01-01') + interval '1 weeks'
    group by timespan
    order by timespan
    Run a query to Download Data