flipside

    Optimism Delegation Activity 3
    jackguyOptimism Delegation Activity 3
    Updated 2023-02-17
    SELECT
    -- date_trunc('day', BLOCK_TIMESTAMP) as day,
    DELEGATION_TYPE,
    count(DISTINCT tx_hash) as events,
    count(DISTINCT delegator) as delegator,
    count(DISTINCT to_delegate) as DELEGATE
    -- count(*)
    FROM optimism.core.fact_delegations
    GROUP BY 1
    Run a query to Download Data