PromotedPawn0. Single token_Final
    Updated 2024-10-24
    -- 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