rw2023Sharx 30 days buyers
    Updated 2024-03-02
    -- forked from Sharx 7 days buyers @ https://flipsidecrypto.xyz/edit/queries/0e0343fd-f9a0-49fb-9ae8-d684d11cb6f2

    -- forked from Sharx holders ranking @ https://flipsidecrypto.xyz/edit/queries/5cee8f85-a2f8-492a-8905-f8b58234998c

    WITH nft_mint_addresses AS (
    SELECT
    address AS mint
    FROM
    solana.core.dim_labels
    WHERE
    label = 'sharx by sharky.fi'
    ),

    tx_combined AS (
    SELECT
    tx_to AS whale,
    SUM(amount) AS sharx_in,
    0 AS sharx_out
    FROM solana.core.fact_transfers
    WHERE mint IN (SELECT mint FROM nft_mint_addresses)
    AND block_timestamp > CURRENT_DATE - INTERVAL '30 days'
    GROUP BY whale
    UNION ALL
    SELECT
    tx_from AS whale,
    0 AS sharx_in,
    SUM(-amount) AS sharx_out
    FROM solana.core.fact_transfers
    WHERE mint IN (SELECT mint FROM nft_mint_addresses)
    AND block_timestamp > CURRENT_DATE - INTERVAL '30 days'
    GROUP BY whale
    ),

    balance AS (
    SELECT
    whale,
    QueryRunArchived: QueryRun has been archived