i_dan$TRUMP: Top Holders & Value
Updated 2025-02-03
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_balances AS (
SELECT
block_timestamp
, owner
, mint
, balance
, row_number() OVER(PARTITION BY owner, mint ORDER BY block_timestamp DESC) AS rank
FROM solana.core.fact_token_balances bl
WHERE mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
AND owner != '2RH6rUTPBJ9rUDPpuV9b8z1YL56k1tYU6Uk5ZoaEFFSK'
),
labels AS (
SELECT
address
, address_name
, label
FROM solana.core.dim_labels
),
Prices AS (
SELECT
price
, token_address
FROM solana.price.ez_prices_hourly
WHERE token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
AND hour IN (SELECT
MAX(hour)
FROM solana.price.ez_prices_hourly
WHERE token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN')
)
SELECT
CASE WHEN owner = address THEN address_name ELSE owner END AS "Address"
, balance AS "Token Balance"
, '💲'|| price * balance AS "Holding Value"
FROM latest_balances b
LEFT JOIN labels l ON l.address = b.owner