Monitize AIPirate 2 copy
Updated 2024-07-14
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
›
⌄
select
150 as airdrop_amt, -- 150,000,000
1 as total_supply, -- 1,000,000,000
count(distinct TO_ADDRESS) as claimers ,
sum(amount) as volume ,
round(avg(amount),0) as avg_volume,
max(amount) as max_volume,
min(amount) as min_volume,
median(amount) as median_volume,
150000000 - volume as unclaimed_amount,
(volume * 100)/150000000 as claimed_percentage,
(150000000*100)/1000000000 as ratio
from(
select
distinct TO_ADDRESS,
sum(amount) as amount
from ethereum.core.ez_token_transfers
where contract_address = lower('0x7613c48e0cd50e42dd9bf0f6c235063145f6f8dc')
and FROM_ADDRESS = lower('0x543ba3e063197b3025a4b2751e9b4b6a2489fa07')
group by 1
)
group by 1,2
QueryRunArchived: QueryRun has been archived