feyikemiGME Holders
Updated 2024-05-15
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
›
⌄
--Credits to Pine Analytics - https://flipsidecrypto.xyz/pine/q/JhQExZyJbdIr/gme-holders
WITH tab1 AS (
SELECT
tx_to AS user,
amount
FROM solana.core.fact_transfers
WHERE mint = '8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB'
UNION ALL
SELECT
tx_from AS user,
-amount AS amount
FROM solana.core.fact_transfers
WHERE mint = '8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB'
AND block_timestamp > '2024-01-01'
),
balances AS (
SELECT
user,
SUM(amount) AS balance
FROM tab1
GROUP BY user
),
total_holders AS (
SELECT
COUNT(*) AS total_holders
FROM balances
WHERE balance > 0
)
SELECT * FROM total_holders;
QueryRunArchived: QueryRun has been archived