mlhUntitled Query
    Updated 2022-08-02
    SELECT date(dates) as date,
    COUNT(*) as number_of_contracts,
    sum(number_of_contracts) over (order by date asc) as cum_number_of_contracts
    from (SELECT min(a.BLOCK_TIMESTAMP) as dates,
    RECEIVER_ID as contract
    from near.core.fact_actions_events a
    join near.core.fact_receipts b on a.TX_HASH = b.TX_HASH
    where ACTION_NAME= 'DeployContract'
    GROUP by 2
    )
    GROUP by 1
    Run a query to Download Data