kgmm2019holders qa test_acc
Updated 2024-12-21
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
›
⌄
-- forked from holders qa copy copy @ https://flipsidecrypto.xyz/studio/queries/435fa24a-5950-45f3-b484-e88da2b500e9
-- forked from holders qa copy @ https://flipsidecrypto.xyz/studio/queries/65e57c52-180e-4c16-96a3-7fac5a030b60
-- forked from holders qa @ https://flipsidecrypto.xyz/studio/queries/8be6e7be-d0fb-46ca-ac96-a420c4805c80
WITH cte AS (
SELECT
dateadd(HOUR,-5,block_timestamp) AS ts,
CASE
WHEN pre_balance = 0 AND balance > 0 THEN 1
WHEN pre_balance > 0 THEN
CASE WHEN balance / pre_balance - 1 < -0.97 THEN -1 ELSE 0 END
END AS action,
CASE
WHEN pre_balance = 0 AND balance > 0 THEN 1
WHEN pre_balance > 0 AND balance = 0 THEN -1 ELSE 0
END AS action_orig,
CASE
WHEN pre_balance = 0 AND balance > 0 THEN 1 ELSE 0
END AS buys,
CASE
WHEN pre_balance > 0 AND balance = 0 THEN 1 ELSE 0
END AS sells,
pre_balance,
balance,
balance - pre_balance AS net,
owner,
tx_id,
mint
FROM solana.core.fact_token_balances
WHERE lower(mint) = lower('G6ge1jWUyD3kDPHnXYKz2qDpL3VgHQCLZLfmzPFtSoLM')
AND BLOCK_TIMESTAMP > '2024-12-17 00:00'
AND BLOCK_TIMESTAMP < '2024-12-18 23:59'
),
cte2 AS (
QueryRunArchived: QueryRun has been archived