lagandispenserTop $PAC Holders 2 copy
Updated 2024-05-20
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
›
⌄
-- forked from mamad-5XN3k3 / Top $PAC Holders 2 @ https://flipsidecrypto.xyz/mamad-5XN3k3/q/lSpoSM3SRuKT/top-pac-holders-2
select
'1000000000' as total_supply, --1B
sum(balance) as circulating,
sum(balance)*100/1000000000 as ratio,
round(max(balance),2) as max_holding,
--min(balance) as min_holding,
round(avg(balance),2) as avg_holding,
round(median(balance),2) as med_holding,
count(distinct user) as holders
from(
select
distinct user,
--ADDRESS_name,
sum(vol) as balance
from (
select
to_address as user,
sum(amount) as vol
from blast.core.ez_token_transfers
where contract_address='0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06'
and amount is not null
group by 1
UNION
select
from_address as user,
-1 * sum(amount) as vol
from blast.core.ez_token_transfers
where contract_address='0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06'
and amount is not null
group by 1
)
where user != '0x1dd4fb074e9f28ca9d21c93e0aa915b487893b1c'
QueryRunArchived: QueryRun has been archived