zakkisyedAddresses who were eligible/claimed for the ENS airdrop
    Updated 2021-12-06
    select count (distinct(A1.addresses_eligible)) as addresses_eligible, count(distinct(A2.addresses_claimed)) as addresses_claimed

    from
    (
    SELECT origin_address as addresses_eligible, block_timestamp
    --as Total_amount_in_USD, sum(amount) as Total_tokens_claimed
    --event_name, event_type, block_timestamp

    from
    ethereum.udm_events

    where
    --symbol = 'ENS'
    --and
    contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
    --and block_timestamp > '2021-10-31' -- airdrop snapshot date
    --and event_name = 'Claim'
    ) as A1

    INNER JOIN
    (
    SELECT origin_address as addresses_claimed, block_timestamp
    --as Total_amount_in_USD, sum(amount) as Total_tokens_claimed
    --event_name, event_type, block_timestamp

    from
    ethereum.udm_events

    where --symbol = 'ENS'
    --and
    contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
    Run a query to Download Data