drone-mostafaUntitled Query
Updated 2022-08-03Copy Reference Fork
9
1
2
3
4
5
6
7
8
›
⌄
with smart as ( select a.tx_receiver as "Txn of Contracts", min(a.block_timestamp) as minimum
from near.core.fact_actions_events b join near.core.fact_transactions a on b.tx_hash = a.tx_hash
and b.action_name = 'DeployContract' group by "Txn of Contracts" )
select date_trunc('day',minimum) as dayly,
count(distinct "Txn of Contracts") as "Total Contracts",sum("Total Contracts") over (order by dayly) as cumulative
from smart
where dayly >= CURRENT_DATE -30
group by 1
Run a query to Download Data