StangFAST06 - NEAR redux
    Updated 2023-04-11


    SELECT
    date_trunc( 'week' , a.block_timestamp ) AS date01
    , count( DISTINCT a.tx_hash ) AS swap_count
    , count( DISTINCT a.trader ) AS unique_swapper

    FROM
    near.core.ez_dex_swaps a

    WHERE
    a.block_timestamp::date < current_date
    AND a.platform = 'v2.ref-finance.near'
    AND ( a.token_in = 'wNEAR' OR a.token_out = 'wNEAR' )

    GROUP BY
    date01

    ORDER BY
    date01 DESC

    Run a query to Download Data