sixahi6066probable-violet
    Updated 2024-09-19
    WITH transfer_data AS (
    SELECT
    tx_to,
    mint,
    tx_id,
    block_timestamp,
    amount,
    ROW_NUMBER() OVER (PARTITION BY tx_to, mint ORDER BY block_timestamp) AS rn
    FROM solana.core.fact_transfers
    WHERE mint IN ('FJ1DHFFHvW4UFNELFu6VonuAvaMK3Ch58LUMqsNqLnwk', '69SEPKGCzFzJLoSawb3xPfcqnZdiVm21Xu28AWZB5pzk')
    ),
    first_transfers AS (
    SELECT
    tx_to,
    mint,
    tx_id AS first_tx_id,
    block_timestamp AS first_block_timestamp
    FROM transfer_data
    WHERE rn = 1
    ),
    total_inflows AS (
    SELECT
    tx_to,
    mint,
    SUM(amount) AS total_inflow
    FROM transfer_data
    GROUP BY tx_to, mint
    ),
    filtered_receivers AS (
    SELECT tx_to
    FROM first_transfers
    GROUP BY tx_to
    HAVING
    COUNT(DISTINCT mint) = 2
    AND MAX(CASE WHEN mint = 'FJ1DHFFHvW4UFNELFu6VonuAvaMK3Ch58LUMqsNqLnwk' THEN first_block_timestamp END) < '2024-04-18 09:54'
    AND MAX(CASE WHEN mint = '69SEPKGCzFzJLoSawb3xPfcqnZdiVm21Xu28AWZB5pzk' THEN first_block_timestamp END) < '2024-04-01 07:26'
    QueryRunArchived: QueryRun has been archived