Alir3zaUntitled Query
Updated 2022-08-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with con as (
select
a.tx_receiver as contracts,
min(a.block_timestamp) as mindate
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 1
)
select
date_trunc('day',mindate) as d_date,
date_trunc('week', mindate) as w_date,
count(distinct contracts) as num_contracts
from con
where d_date >= '2022-01-01'
group by 1,2
Run a query to Download Data