mz0111near1 open
    Updated 2023-05-10
    select
    date_trunc('week',day) as date,
    count( distinct tx_hash) as txs,
    count(DISTINCT(trader)) as users,
    txs/users as tra_number_per_user,
    sum(txs) over (order by date asc) as cum_txs,
    sum(users) over (order by date asc) as cum_users
    from(
    select
    block_timestamp:: date as day,
    tx_hash,
    trader,
    token_out,
    token_in ,
    token_in_contract,
    TOKEN_OUT_CONTRACT,
    concat(token_in,'-->',token_out) as pair
    from near.core.ez_dex_swaps
    where PLATFORM = 'v2.ref-finance.near'
    and block_timestamp::date >= current_date - {{period}}
    )
    group by 1

    Run a query to Download Data