flipside

    SOL_Token_Specific_Address
    clayopSOL_Token_Specific_Address
    Updated 2023-03-09
    SELECT
    TX_FROM AS FROM_ADDRESS,
    TX_TO AS TO_ADDRESS,
    SUM(AMOUNT) AS TOTAL_AMOUNT
    FROM
    solana.core.fact_transfers
    WHERE
    MINT = '5tB5D6DGJMxxHYmNkfJNG237x6pZGEwTzGpUUh62yQJ7'
    AND TX_TO in
    (SELECT
    TX_FROM
    FROM
    solana.core.fact_transfers
    WHERE
    MINT = '5tB5D6DGJMxxHYmNkfJNG237x6pZGEwTzGpUUh62yQJ7'
    AND TX_TO = 'HWAZftMPQKDjhCpa4n1ZC1v7WdbHZsoXBecie4qxtKqX'
    )
    GROUP BY
    1,
    2
    -- HAVING TOTAL_AMOUNT <= 400
    ORDER BY
    TOTAL_AMOUNT DESC
    Run a query to Download Data