NavidUntitled Query
    Updated 2022-11-17
    with trades as (
    select
    date(block_timestamp) as day,
    sum(deposit/1e24) as amt,
    count(distinct tx_hash) as trades_cnt,
    count(distinct tx_signer) as sellers_cnt,
    count(distinct tx_receiver) as buyers_cnt
    from
    near.core.fact_transfers
    where
    block_timestamp > '2022-11-01'
    group by 1
    )
    select
    day,
    amt as "Daily Volume",
    avg("Daily Volume") over (order by day asc rows between 7 preceding and current row) as "7-Day Moving Average",
    buyers_cnt/sellers_cnt as ratio
    from
    trades
    order by
    day asc

    Run a query to Download Data