Ali3NDaily Number of Swaps on Terra Around New Year 2023
    Updated 2023-01-06
    select date_trunc (day,block_timestamp) as date,
    case when block_timestamp::date >= '2022-12-24' then 'Holidays and New Year'
    else 'Other' end as timespan,
    count (distinct tx_id) as TX_Count,
    count (distinct trader) as Users_Count
    from terra.core.ez_swaps
    where tx_succeeded = 'TRUE'
    and block_timestamp >= '2022-12-01'
    group by 1,2
    order by 1
    Run a query to Download Data