kaibladeSmart contract deployments
    Updated 2023-04-13
    -- SELECT DATE_TRUNC('day', block_timestamp) AS "Days", AVG(tx_fee)
    -- FROM ethereum.core.fact_transactions
    -- WHERE block_timestamp::date >= CURRENT_DATE() - INTERVAL '24 month'
    -- GROUP BY "Days"

    WITH raw_data AS
    (SELECT *
    FROM ethereum.core.fact_event_logs
    WHERE event_name ='OwnershipTransferred'
    AND event_inputs:previousOwner = '0x0000000000000000000000000000000000000000'
    AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '24 month')

    SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
    COUNT(DISTINCT tx_hash) AS "Deployments"

    FROM raw_data

    GROUP BY "Days"
    Run a query to Download Data