Updated 2023-01-07
    with transfers as (select count(distinct tx_hash) as transfer_count ,count(distinct tx_signer) as users_count , sum(deposit/1e18) as trasnfer_amount
    , block_timestamp::date as dt
    from near.core.fact_transfers
    group by dt)

    select min(transfer_count) , max(transfer_count) , avg(transfer_count) , median(transfer_count) from transfers where dt>= '2022-12-01' and dt!=CURRENT_DATE



    Run a query to Download Data