zakkisyed1. Addresses who claimed the ENS airdrop
    Updated 2021-12-13
    select T1.addresses_claimed, T2.price, T1.days

    from
    (
    SELECT count (distinct(origin_address)) as addresses_claimed, date_trunc('day', block_timestamp) as days
    --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-11-01'
    and event_name = 'Claim'
    group by 2

    ) as T1

    INNER JOIN
    ethereum.token_prices_hourly as T2
    ON T1.days = T2.(date_trunc('day', hour))

    group by 3
    Run a query to Download Data