mlhUntitled Query
Updated 2022-08-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT date(dates) as date,
COUNT(*) as number_of_contracts,
sum(number_of_contracts) over (order by date asc) as cum_number_of_contracts
from (SELECT min(a.BLOCK_TIMESTAMP) as dates,
RECEIVER_ID as contract
from near.core.fact_actions_events a
join near.core.fact_receipts b on a.TX_HASH = b.TX_HASH
where ACTION_NAME= 'DeployContract'
GROUP by 2
)
GROUP by 1
Run a query to Download Data