AnalyticSagesACS-daily-holders
Updated 2023-12-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH base_txns AS (
SELECT
block_timestamp :: date as date,
COALESCE(tx_to, tx_from) as holder
FROM
solana.core.fact_transfers
WHERE
mint = '5MAYDfq5yxtudAhtfyuMBuHZjgAbaS9tbEyEQYAhDS5y'
AND block_timestamp :: date >= '2023-02-15' -- token lauch date
GROUP BY
1, 2
)
SELECT
date,
COUNT(DISTINCT holder) as "Token Holders"
FROM
base_txns
GROUP BY 1
ORDER BY 1
Run a query to Download Data