flipside

    SMI where to_address is NULL
    fantasySMI where to_address is NULL
    Updated 2025-02-14
    SELECT
    DATE_TRUNC('day', block_timestamp) AS transaction_date,
    COUNT(from_address) AS daily_smart_contract_interactions
    FROM
    optimism.core.fact_transactions
    WHERE
    to_address IS NULL
    GROUP BY
    1
    ORDER BY
    1 DESC;
    QueryRunArchived: QueryRun has been archived