dannyamahmSOL Holders Analysis
Updated 2025-02-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 Latest_Transactions AS (
SELECT
owner,
balance,
ROW_NUMBER() OVER (PARTITION BY owner ORDER BY BLOCK_TIMESTAMP DESC) AS rn
FROM solana.core.fact_token_balances
WHERE MINT = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
),
price AS (
SELECT
price
FROM crosschain.price.ez_prices_hourly
WHERE token_address = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
ORDER BY hour DESC
LIMIT 1
)
SELECT
usd_value_range,
COUNT(*) AS holder_count
FROM (
SELECT
owner,
round(balance, 6) AS amount,
(amount * p.price) AS amount_usd,
CASE
WHEN (amount * p.price) BETWEEN 1 AND 10 THEN '1 - $10'
WHEN (amount * p.price) BETWEEN 10 AND 100 THEN '$10 - $100'
WHEN (amount * p.price) BETWEEN 100 AND 1000 THEN '$100 - $1,000'
WHEN (amount * p.price) BETWEEN 1000 AND 10000 THEN '$1,000 - $10,000'
WHEN (amount * p.price) BETWEEN 10000 AND 100000 THEN '$10,000 - $100,000'
ELSE 'Above $100,000'
END AS usd_value_range
FROM Latest_Transactions
CROSS JOIN price p
WHERE rn = 1
QueryRunArchived: QueryRun has been archived