maybeyonasens_airdrop_claims
Updated 2021-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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