B09Fidenza-1
Updated 2023-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- FidenzaTokens
WITH FidenzaTokens AS (
SELECT TOKENID
FROM ethereum.nft.dim_nft_collection_metadata
WHERE NFT_ADDRESS = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
AND TOKENID_NAME LIKE 'Fidenza%'
)
--1. Identify the wallet that purchased the highest-priced fidenza (in eth terms) and list the wallet address, token #, price, and date of the transaction.
SELECT BUYER_ADDRESS, TOKENID, PRICE, BLOCK_TIMESTAMP
FROM ethereum.nft.ez_nft_sales
WHERE TOKENID IN (SELECT TOKENID FROM FidenzaTokens)
AND CURRENCY_SYMBOL = 'ETH'
ORDER BY PRICE DESC
LIMIT 5;
-- TOKENID 78000313
Run a query to Download Data