gigiokoba2024-07-17 02:17 PM
Updated 2024-08-07
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
›
⌄
⌄
----- Query from Ario Popcat Analysis(but modified)
WITH change AS (
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS Week,
ACCOUNT_ADDRESS AS user_address,
SUM(BALANCE - PRE_BALANCE) AS balance_change
FROM solana.core.fact_token_balances
WHERE MINT = 'FU1q8vJpZNUrmqsciSjp8bAKKidGsLmouB8CBdf8TKQv'
GROUP BY 1, 2
/*
UNION ALL
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS Week,
TX_TO AS user_address,
SUM(amount) AS balance_change
FROM
solana.core.fact_transfersUpdate
WHERE
MINT = 'FU1q8vJpZNUrmqsciSjp8bAKKidGsLmouB8CBdf8TKQv'
GROUP BY 1, 2
UNION ALL
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS Week,
tx_from AS user_address,
SUM(-amount) AS balance_change
FROM
solana.core.fact_transfersUpdate
WHERE
MINT = 'FU1q8vJpZNUrmqsciSjp8bAKKidGsLmouB8CBdf8TKQv'
GROUP BY 1, 2
*/
),
holders_dates AS (
SELECT
DATE_TRUNC('week', DATE_DAY) AS DATE_DAY,
QueryRunArchived: QueryRun has been archived