datavortexDaily Holders
Updated 2025-01-10
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 token_transfers AS (
SELECT
tx_from AS holder,
- amount AS amt,
block_timestamp :: date AS transaction_date
FROM
solana.core.fact_transfers
WHERE
mint = 'GxdTh6udNstGmLLk9ztBb6bkrms7oLbrJp5yzUaVpump'
UNION
ALL
SELECT
tx_to AS holder,
amount AS amt,
block_timestamp :: date AS transaction_date
FROM
solana.core.fact_transfers
WHERE
mint = 'GxdTh6udNstGmLLk9ztBb6bkrms7oLbrJp5yzUaVpump'
),
holder_balances AS (
SELECT
holder,
SUM(amt) AS total_balance,
transaction_date
FROM
token_transfers
GROUP BY
holder,
transaction_date
HAVING
SUM(amt) > 0.01
)
SELECT
transaction_date,
COUNT(DISTINCT holder) AS daily_holders
QueryRunArchived: QueryRun has been archived