eferTransfers per Token
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH variables AS (
SELECT '0x903e2f5d42ee23156d548dd46bb84b7873789e44' AS godmode
), transfers AS (
SELECT
*
FROM ethereum.core.ez_nft_transfers
WHERE NFT_ADDRESS=(SELECT godmode FROM variables)
), last_transfers AS (
SELECT
TOKENID,
COUNT(EVENT_INDEX) AS transfers,
MAX(BLOCK_TIMESTAMP) AS last_transfer,
MAX(EVENT_INDEX) AS last_event
FROM ethereum.core.ez_nft_transfers
WHERE NFT_ADDRESS=(SELECT godmode FROM variables)
GROUP BY TOKENID
)
SELECT * FROM last_transfers
ORDER BY CAST(TOKENID AS INT)
Run a query to Download Data