maybeyonasens_claim_dist
Updated 2021-12-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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