MLDZMNNDA2
    Updated 2023-01-24
    select
    date_trunc('week',b.BLOCK_TIMESTAMP) as date,
    count(distinct b.TX_RECEIVER) as no_contract,
    sum(no_contract) over (order by date) as total_contracts

    FROM near.core.fact_actions_events_function_call a
    INNER JOIN near.core.fact_transactions b
    ON a.TX_HASH = b.TX_HASH
    INNER JOIN near.core.fact_receipts as c
    ON a.TX_HASH=c.TX_HASH
    WHERE ACTION_NAME = 'FunctionCall'
    AND METHOD_NAME <> 'new'
    group by 1
    Run a query to Download Data