gigiokobaonly-white
Updated 2025-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH supply AS (
SELECT
'199999995'::NUMERIC AS circulating_supply,
'1000000000'::NUMERIC AS maximum_supply,
price
FROM solana.price.ez_prices_hourly
WHERE token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
ORDER BY hour DESC
LIMIT 1
)
SELECT
circulating_supply * price AS market_cap,
maximum_supply * price AS fdv
FROM supply;
QueryRunArchived: QueryRun has been archived