misaghlbThe Law Offices of NEAR
Updated 2022-07-31
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT date(created_date) as date, COUNT(*) as contracts_count, sum(contracts_count) over (order by date asc) cumulative_count
from (
SELECT
RECEIVER_ID, min(a.BLOCK_TIMESTAMP) as created_date
from near.core.fact_actions_events a
join near.core.fact_receipts b on a.TX_HASH = b.TX_HASH
where ACTION_NAME= 'DeployContract'
-- where TX_HASH = '7SepTbpq3yQkgynvytEoWzkQLJQG3STtB9fE7WXpi1Yr' -- sample deploy
GROUP by RECEIVER_ID
)
GROUP by date
Run a query to Download Data