binhachon5. [Easy] Was the ENS airdrop a secret? weekly chart
    Updated 2021-12-15
    with ens_registration as(
    select
    distinct block_timestamp,
    tx_id,
    origin_address,
    row_number() over (
    partition by origin_address
    order by
    block_timestamp
    ) as rownumber
    from
    ethereum.udm_events
    where
    contract_address = '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5'
    and origin_function_name ilike '%register%'
    )
    select
    date_trunc('week', block_timestamp) as blocktime,
    count(tx_id) as number_of_registrations,
    count_if(rownumber = 1) as daily_new_unique_address,
    daily_new_unique_address / number_of_registrations * 100 as percentage
    from
    ens_registration
    where
    block_timestamp > '2021-07-10T00:00:00Z'
    and block_timestamp < '2021-11-9T00:00:00Z'
    group by
    blocktime

    Run a query to Download Data