Monitize AIBlast 2 copy
Updated 2024-12-09
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
›
⌄
-- forked from Blast 2 @ https://flipsidecrypto.xyz/edit/queries/a6ce0420-d33d-4fa7-8fb8-0bef470d15d4
select
17 as airdrop_amt, -- 17,000,000,000
100 as total_supply, -- 100,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,
17000000000 - volume as unclaimed_amount,
(volume * 100)/17000000000 as claimed_percentage,
(17000000000*100)/100000000000 as ratio
from(
select
distinct TO_ADDRESS,
sum(amount) as amount
from blast.core.ez_token_transfers
where contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')
and FROM_ADDRESS = lower('0xf7be503166828fe8565c520d66645ac6a06bbdd7')
and ORIGIN_FUNCTION_SIGNATURE = '0xcd9829d9'
and TO_ADDRESS != '0xa4bd562c37c19c569c5b4418d12d35fa9964931f'
and amount > 0
group by 1
)
group by 1,2
QueryRunArchived: QueryRun has been archived