metadata.tokenid_name AS NFT,

sales.buyer_address AS WALLET_ADDRESS,

metadata.TOKENID AS TOKEN_NUM,

sales.price AS PRICE_ETH,

sales.price_USD AS PRICE_USD,

sales.BLOCK_TIMESTAMP AS TRANSACTION_DATE

ETHEREUM.nft.ez_nft_sales AS sales

INNER JOIN ethereum.nft.dim_nft_collection_metadata AS metadata on sales.tokenid = metadata.TOKENID

sales.currency_symbol = 'ETH'

AND metadata.tokenid_name LIKE '%fidenza%'

ORDER BY

sales.price DESC

1;