flipside

    Query 1
    Team 6Query 1
    Updated 2023-11-19
    --- 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 '%fidenza%'
    AND sales.CURRENCY_SYMBOL = 'ETH'
    order by
    sales.price DESC
    limit
    1;
    Run a query to Download Data