crypto_edgar2023-10-22 08:04 PM
    Updated 2023-11-02
    -- SELECT *
    -- FROM solana.core.fact_transfers
    -- WHERE DATE_TRUNC('Day', BLOCK_TIMESTAMP) = '2023-10-12'
    -- AND TX_ID = '5iaXL93kMno9enXwXP9U2qS3JAzhKtit5zTZtXnrJGQRRhP9GZzLgQz6JvpaF5ZGHyNbNU8NxT2VPaQX1TjLfVF8'
    -- -- GROUP BY TX_ID, MINT
    -- -- HAVING INDEX = MAX(INDEX)
    -- WITH MaxIndexCTE AS (
    -- SELECT
    -- TX_ID,
    -- -- Replace with your actual unique identifier column
    -- INDEX,
    -- ROW_NUMBER() OVER (
    -- PARTITION BY TX_ID
    -- ORDER BY
    -- INDEX DESC
    -- ) AS RowNum
    -- FROM
    -- solana.core.fact_transfers -- Replace with the actual table name
    -- WHERE
    -- BLOCK_TIMESTAMP >= '2023-10-20'
    -- AND MINT = '63D7r8VRZkSa8U3BEn6EF5wozHFXd9DCMQjCWm3qGhdc'
    -- )
    -- SELECT
    -- t.*,
    -- m.RowNum
    -- FROM
    -- solana.core.fact_transfers t
    -- JOIN MaxIndexCTE m ON t.TX_ID = m.TX_ID
    -- WHERE
    -- m.RowNum = 1
    -- AND BLOCK_TIMESTAMP >= '2023-10-20'
    -- AND MINT = '63D7r8VRZkSa8U3BEn6EF5wozHFXd9DCMQjCWm3qGhdc' -- SELECT *
    -- -- FROM MaxIndexCTE
    SELECT
    DISTINCT TX_ID,
    MINT,
    Run a query to Download Data