carsonbrownNFT's Held
    Updated 2022-10-11
    WITH trades AS (
    SELECT *
    FROM ethereum.core.ez_nft_transfers
    WHERE NFT_TO_ADDRESS = LOWER('0x7032C9A9a3c0c09a35c3D07C38f99B008E8D7F88')
    ORDER BY BLOCK_NUMBER DESC
    ),

    transfers AS (
    SELECT t.*
    FROM ethereum.core.ez_nft_transfers trans
    JOIN trades t ON t.NFT_ADDRESS = trans.NFT_ADDRESS
    AND t.TOKENID = trans.TOKENID
    QUALIFY ROW_NUMBER() OVER (PARTITION BY trans.NFT_ADDRESS, trans.TOKENID ORDER BY trans.BLOCK_NUMBER DESC) = 1
    )

    SELECT *
    FROM transfers
    WHERE NFT_TO_ADDRESS = LOWER('0x7032C9A9a3c0c09a35c3D07C38f99B008E8D7F88')
    Run a query to Download Data