NavidUntitled Query
Updated 2022-10-19Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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