Current Price (USD) | Current Token Holders | Total Supply | Market Cap (USD) | |
|---|---|---|---|---|
1 | 10.4 | 642627 | 1000143995.93075 | 10401497557.6798 |
defi__joshPrice, Holders, Supply and Market cap
Updated 3 days ago
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
›
⌄
WITH token_contract_addresses AS (
SELECT '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' as address
)
, price AS (
SELECT price
FROM solana.price.ez_prices_hourly p
WHERE token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
ORDER BY hour DESC
LIMIT 1
)
, latest_balances AS (
SELECT
mint as token_mint_address,
owner as token_balance_owner,
balance as token_balance,
ROW_NUMBER() OVER (PARTITION BY owner ORDER BY block_timestamp DESC) as rn
FROM solana.core.fact_token_balances
WHERE mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
QUALIFY rn = 1
)
SELECT
p.price as "Current Price (USD)",
COUNT(DISTINCT CASE WHEN lb.token_balance > 0 THEN lb.token_balance_owner END) as "Current Token Holders",
SUM(lb.token_balance) as "Total Supply",
p.price * SUM(lb.token_balance) as "Market Cap (USD)"
FROM latest_balances lb
CROSS JOIN price p
WHERE token_balance > 0
GROUP BY 1;
Last run: 3 days ago
1
49B
122s