MLDZMNsandsale2
    Updated 2023-08-12
    --0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38
    --sandbox's lands

    select
    count(distinct tx_hash) as sale_no,
    count(distinct BUYER_ADDRESS) as buyer_no,
    count(distinct SELLER_ADDRESS) as seller_no,
    count(distinct TOKENID) as no_nfts,
    sum(price_usd) as volume,
    sum(CREATOR_FEE_USD) as Royalty_fee,
    sum(PLATFORM_FEE_USD) as plat_fee,
    avg(price_usd) as avg_volume,
    min(price_usd) as floor_price,
    max(price_usd) as highest_price,
    buyer_no/count(distinct date_trunc(day, block_timestamp)) as average_buyer_day,
    volume/count(distinct date_trunc(day, block_timestamp)) as average_volume_day
    from ethereum.core.ez_nft_sales
    where NFT_ADDRESS='0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'
    and price_usd>0

    Run a query to Download Data