maybeyonasens_claim_dist
    Updated 2021-12-19
    with claims as (
    select block_timestamp,origin_address as claimer, tx_id, amount/pow(10,18) as ens_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'
    )
    )
    )

    select
    case
    when ens_claimed > 100000 then '100000+'
    when ens_claimed > 50000 then '50000+'
    when ens_claimed > 10000 then '10000+'
    when ens_claimed > 5000 then '5000+'
    when ens_claimed > 1000 then '1000+'
    when ens_claimed > 500 then '500+'
    when ens_claimed > 100 then '100+'
    when ens_claimed > 50 then '50+'
    when ens_claimed > 10 then '10+'
    else '0' end as ens_claim_bracket,
    count(tx_id) as claims,
    sum(ens_claimed) as amt_claimed
    from claims
    group by 1
    limit 100

    * 100000+
    Run a query to Download Data