namanasync2024-05-02 01:13 PM
    SELECT Block_Timestamp::DATE AS DAYS, COUNT(DISTINCT(EVENT_INPUTS:recipient)) "Number of users who claimed airdrop",
    SUM("Number of users who claimed airdrop") OVER (ORDER by DAYS ASC ROWS BETWEEN unbounded preceding AND CURRENT ROW) "Total number of users who claimed airdrop"
    FROM optimism.core.fact_event_logs
    WHERE ORIGIN_TO_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' AND Contract_Address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
    AND EVENT_NAME = 'Claimed' AND ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef' AND BLOCK_TIMESTAMP::DATE < CURRENT_DATE AND TX_STATUS = 'SUCCESS'
    GROUP BY DAYS
    Run a query to Download Data