maybeyonasens_airdrop_claims
    Updated 2021-12-06
    select
    count(origin_address) as no_of_claims,
    count(origin_address)*100/137000 as percen_of_claims,
    sum(amount/pow(10,18)) as ens_airdrop_claimed,
    sum(amount/pow(10,18))*100/(0.25*100000000) as percent_airdrop_claimed
    from (
    select distinct * from (
    select * from ethereum.udm_events
    where
    tx_id in (
    select tx_id from ethereum.udm_events
    where
    contract_address='0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
    and event_name = 'Claim'
    )
    and event_type = 'erc20_transfer'
    )
    )
    limit 100

    Run a query to Download Data