jkhuhnke11Total Contracts Deployed
    Updated 2023-03-10
    WITH date_range AS(
    SELECT
    DISTINCT date_trunc('day', date)::date AS metric_date
    FROM gold.near_daily_balances LIMIT 365)

    SELECT metric_date,
    sum(address) OVER (ORDER BY metric_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS metric_value
    FROM
    (
    SELECT date_trunc('day', start_date) AS date,
    count(distinct event_to) AS address
    FROM
    (SELECT event_to,
    min(block_timestamp) AS start_date
    FROM gold.near_events
    WHERE event_type = 'DeployContract'
    GROUP BY 1)si
    GROUP BY 1)se
    RIGHT OUTER JOIN date_range on
    date = metric_date
    ORDER BY 1 DESC
    Run a query to Download Data