carsonbrownNFT's Held
Updated 2022-10-11Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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