kaibladeDaily Stake Count
    Updated 2022-12-21
    WITH staked_tx AS
    (SELECT *
    FROM optimism.core.fact_event_logs
    WHERE event_name = 'Staked'
    AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '2 months')

    SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
    COUNT(tx_hash) AS "Stake Count"
    FROM staked_tx
    GROUP BY "Days"

    Run a query to Download Data