Holders | Circulating Supply | Total Supply | Price | MarketCap | FDV | All Time High Price | ATH_PRICE_CHANGE | CURRENT_CHANGE | Percentage Change Since Last ATH | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 682149 | 200000000 | 1000000000 | 24.8 | 4960000000 | 24800000000 | 72.92 | 1163.778162912 | 329.809358752 | -65.990126166 |
i_dan$TRUMP: Total Holders & Price
Updated 2025-02-01
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'
--LIMIT 1000
),
balances AS (
SELECT
owner AS address
, mint AS CA
, balance AS token_balances
FROM latest_balances
WHERE rank = 1
AND balance > 0
),
Trump_Price as (
SELECT
hour AS recorded_Hour
, price AS t_price
FROM solana.price.ez_prices_hourly
WHERE
token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
),
atl as (
SELECT
MIN(t_price) as Min_Price
FROM Trump_Price
Last run: about 1 month ago
1
108B
242s