flipside

    Query 2
    Team 6Query 2
    Updated 2023-11-19
    --- For the Fidenza NFT you found in the first query, find out
    --- all previous(past) sales and list them with the price of
    --- each sale(in eth and in USD) along with the token# and the dates.
    select
    sales.tokenid as token_no,
    meta.token_name as token_name,
    sales.price as price_eth,
    ROUND(sales.price_usd,2),
    sales.block_timestamp as transaction_date
    from
    ethereum.nft.ez_nft_sales sales
    join ethereum.nft.dim_nft_metadata as meta on sales.tokenid = meta.token_id
    where
    meta.token_name LIKE 'fidenza #313';
    Run a query to Download Data