kellen1inch Airdrop - Unique Addresses by Day
    Updated 2021-08-05
    SELECT DATE_TRUNC(day, block_timestamp) AS date
    , COUNT(DISTINCT to_address) AS n_addys
    , SUM(amount) AS n_tokens
    FROM ethereum.udm_events
    WHERE contract_address = '0x111111111117dc0aa78b770fa6a738034120c302'
    AND origin_function_name = 'claim'
    AND from_address IN ( '0xe295ad71242373c37c5fda7b57f26f9ea1088afe', '0x4ee7c0f5480eb1edd8902a5e8b991ed52992d5f5' )
    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data