OneDataAnalystDaily Number of delegate Transactions of Airdrop Claimers
    Updated 2022-11-16
    WITH t1 AS (
    SELECT DISTINCT origin_from_address as claimers
    FROM optimism.core.fact_event_logs
    WHERE origin_to_address = LOWER('0xFeDFAF1A10335448b7FA0268F56D2B44DBD357de')
    AND event_name = 'Claimed' )


    SELECT Date_trunc('day',BLOCK_TIMESTAMP) AS Date, COUNT(*)
    FROM optimism.core.fact_event_logs
    WHERE event_name = 'DelegateVotesChanged'
    AND origin_to_address = '0x4200000000000000000000000000000000000042'
    AND origin_from_address IN (SELECT claimers FROM t1)
    GROUP BY 1
    Run a query to Download Data