flipside

    swappers count on daily basis since the beginning of 2023 and swap count on daily basis since the beginning of 2023
    superflyswappers count on daily basis since the beginning of 2023 and swap count on daily basis since the beginning of 2023
    Updated 2023-01-11
    with final_data as (
    select *
    from (
    select to_date(block_timestamp) as date,
    count(distinct tx_hash) as tx_hash_swap_count,
    count(distinct trader) as traders_count
    from near.core.ez_dex_swaps
    where date >= '2023-01-01'
    -- and date <= '2022-12-31'
    group by date)
    )
    select * from final_data
    Run a query to Download Data