Updated 2023-11-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
--- 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
sales.tokenid as token_no,
metadata.token_name,
sales.buyer_address as wallet_address,
sales.price as price_eth,
sales.block_timestamp as transaction_date
from
ethereum.nft.ez_nft_sales as sales
join ethereum.nft.dim_nft_metadata as metadata ON sales.tokenid = metadata.token_id
where
metadata.token_name LIKE '%bored ape yacht club%'
order by
sales.price DESC
limit
5;
Run a query to Download Data