Updated 2023-11-15
    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