Alir3zaUntitled Query
    Updated 2022-08-03
    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