PromotedPawn0. Single token_Final
Updated 2024-10-24Copy Reference Fork
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
›
⌄
-- forked from 0. Single token @ https://flipsidecrypto.xyz/studio/queries/271cff0e-469c-47ed-8402-6d7e3c78a6b4
WITH transaction_counts AS (
SELECT
ak.value:pubkey AS buyer_address,
tb.value:mint AS token_id,
COUNT(*) AS transaction_count
FROM
solana.core.fact_transactions t,
LATERAL FLATTEN(input => t.POST_TOKEN_BALANCES) AS tb,
LATERAL FLATTEN(input => t.ACCOUNT_KEYS) AS ak
WHERE
-- tb.value:mint = 'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump' AND --GOAT
-- t.BLOCK_TIMESTAMP BETWEEN '2024-10-10 23:00:00' AND '2024-10-12 21:00:00'
-- tb.value:mint = 'FskzSqy7Pi1f3nWorr4WhhQboxzyv8fv6Q2e8xyDpump' AND --MORUD
-- t.BLOCK_TIMESTAMP BETWEEN '2024-10-10 23:00:00' AND '2024-10-12 21:00:00'
-- tb.value:mint = 'BoAQaykj3LtkM2Brevc7cQcRAzpqcsP47nJ2rkyopump' AND --FOREST
-- t.BLOCK_TIMESTAMP BETWEEN '2024-10-15 23:25:00' AND '2024-10-16 05:30:00'
-- tb.value:mint = 'A17gzfib2UaxteKXzMK37G4AtVqYKRqRLT54aDjYpump' AND --EREBUS
-- t.BLOCK_TIMESTAMP BETWEEN '2024-10-18 10:00:00' AND '2024-10-19 09:30:00'
tb.value:mint = '8wZvGcGePvWEa8tKQUYctMXFSkqS39scozVU9xBVrUjY' AND --REMILIA
t.BLOCK_TIMESTAMP BETWEEN '2024-10-16 22:20:00' AND '2024-10-17 01:00:00'
GROUP BY
ak.value:pubkey, tb.value:mint
)
SELECT
buyer_address,
token_id,
transaction_count
FROM
transaction_counts
WHERE
transaction_count < 20
QueryRunArchived: QueryRun has been archived