NavidUntitled Query
    Updated 2022-10-19
    select
    date(block_timestamp) as day,
    count(distinct tx_hash) as "Number of Daily Transactions",
    sum("Number of Daily Transactions") over (order by day asc) as "Cumulative Number of Daily Transactions",
    avg("Number of Daily Transactions") over (order by day asc rows between 14 preceding and current row) as "Moving Average"
    from
    near.core.fact_transactions
    where day > CURRENT_DATE-90
    group by
    day
    Run a query to Download Data