nitsContrACTS created
Updated 2022-08-04
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT date(block_timestamp) as day, count(DISTINCT tx_hash) as total_txs,
sum(total_txs) over (order by day) as cum_txs
from near.core.fact_actions_events
where action_name ilike 'deploycontract' and day >= CURRENT_DATE -90
GROUP by 1
limit 100
-- action_name = DeployContract or method_name=deploy_contract_code
Run a query to Download Data