DATE | ADDRESS | AMOUNT | |
|---|---|---|---|
1 | 2024-07-07 00:00:00.000 | wrongpDtP8oMtw7iDT6FPvcVSS4qcKiqzD2DNSeVyKc | -374.1 |
2 | 2024-07-07 00:00:00.000 | DSN3j1ykL3obAVNv7ZX49VsFCPe4LqzxHnmtLiPwY6xg | -17.3 |
3 | 2024-07-07 00:00:00.000 | ob2htHLoCu2P6tX7RrNVtiG1mYTas8NGJEVLaFEUngk | -10604.5 |
4 | 2024-07-07 00:00:00.000 | wHZroY9PhEMrRZMKAp4MaHbMPqDDjGQ3vUXFWYTGYU8 | -381.893606 |
5 | 2024-07-07 00:00:00.000 | 2LGJ5fd3ByN3PwgnKbSHatJKSsDSc4RhrbS9kizYsxsS | -99808.5 |
6 | 2024-07-07 00:00:00.000 | AcTRjdD3x4ZHzKGaApVo2RdJ7Rm7f2kaheCiDEjSr1xe | 0 |
7 | 2024-07-07 00:00:00.000 | 2LGJ5fd3ByN3PwgnKbSHatJKSsDSc4RhrbS9kizYsxsS | -147.1 |
8 | 2024-07-07 00:00:00.000 | 7A1R3L7AxcxuZHMJjFgskKGeBR5Rwst3Ai5bv5uAWZFG | 0 |
9 | 2024-07-07 00:00:00.000 | AiMZS5U3JMvpdvsr1KeaMiS354Z1DeSg5XjA4yYRxtFf | 0 |
10 | 2024-07-07 00:00:00.000 | 2LGJ5fd3ByN3PwgnKbSHatJKSsDSc4RhrbS9kizYsxsS | -100076.7 |
Kruys-Collinsmental-indigo
Updated 2025-02-18
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
›
⌄
-- forked from holders trend @ https://flipsidecrypto.xyz/studio/queries/d8787ff1-28be-4cc6-9a22-855827d2a4a8
WITH daily_transfers AS (
SELECT
DATE_TRUNC('{{timespan}}', block_timestamp) AS date,
TX_FROM AS address,
-1 * amount as amount
FROM
solana.core.fact_transfers
WHERE
MINT = '{{token_address}}'
UNION
ALL
SELECT
DATE_TRUNC('{{timespan}}', block_timestamp) AS date,
TX_TO AS address,
amount
FROM
solana.core.fact_transfers
WHERE
mint = '{{token_address}}'
)
SELECT
COUNT(address) as Holders
FROM daily_transfers
where amount > 0
Last run: 2 months ago
10
814B
14s