AN8 - Mini Project 2Query 2
Updated 2023-11-15
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT sales.TOKENID,
meta.TOKEN_NAME, sales.BLOCK_TIMESTAMP AS Transaction_Date,
sales.PRICE, ROUND(sales.price_usd)
FROM ethereum.nft.ez_nft_sales AS sales INNER JOIN ethereum.nft.dim_nft_metadata AS meta
ON sales.tokenid=meta.token_id
WHERE meta.token_name LIKE '%fidenza%'
AND sales.currency_symbol = 'ETH'
AND sales.EVENT_TYPE= 'sale'
AND sales.tokenid= '78000313'
ORDER BY sales.BLOCK_TIMESTAMP DESC
Run a query to Download Data