MLDZMNNDA2
Updated 2023-01-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('week',b.BLOCK_TIMESTAMP) as date,
count(distinct b.TX_RECEIVER) as no_contract,
sum(no_contract) over (order by date) as total_contracts
FROM near.core.fact_actions_events_function_call a
INNER JOIN near.core.fact_transactions b
ON a.TX_HASH = b.TX_HASH
INNER JOIN near.core.fact_receipts as c
ON a.TX_HASH=c.TX_HASH
WHERE ACTION_NAME = 'FunctionCall'
AND METHOD_NAME <> 'new'
group by 1
Run a query to Download Data