flipside

    The number of new smart contracts deployed on NEAR in the last 90 days
    nimasadjadiThe number of new smart contracts deployed on NEAR in the last 90 days
    Updated 2022-08-02
    SELECT
    date_trunc ('day', block_timestamp :: DATE) AS DAY_,
    COUNT (DISTINCT tx_hash) AS DEPLOYED_CONTRACTS_DAILY
    FROM near.core.fact_actions_events
    WHERE (action_name = 'DeployContract' or action_name = '%DeployContract' or action_name = 'DeployContract%') and
    block_timestamp > '2022-05-02'
    GROUP BY DAY_
    ORDER BY DAY_

    Run a query to Download Data