kgmm2019holders qa_base_unique_owner
Updated 2024-12-27
999
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_base @ 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('3C1AECix6LcVxB7gdrYAZWXHaADv4KmPCkwpDUwwpump')
AND BLOCK_TIMESTAMP > '2024-12-17 00:00'
AND BLOCK_TIMESTAMP < '2024-12-18 23:59'
),
cte_1 as (
select row_number() over(partition by owner order by ts asc) as rn,
* from cte
),
QueryRunArchived: QueryRun has been archived