larrypenguinContracts-Optimism
    Updated 2023-03-29
    SELECT
    CONTRACT_ADDRESS,
    trunc(BLOCK_TIMESTAMP,'day') as time,
    COUNT(DISTINCT TX_HASH) as transactions
    FROM
    optimism.core.fact_event_logs
    -- WHERE
    -- time = '2023-03-22' -- `YYYY-MM-DD`
    GROUP BY
    CONTRACT_ADDRESS,
    time
    ORDER BY
    transactions DESC
    LIMIT
    1;

    Run a query to Download Data