MLDZMNrace3
    Updated 2022-10-23
    select--flow nft
    date_trunc('week',block_timestamp) as week,
    count(distinct SELLER) as sellers,
    count(distinct buyer) as buyer_no,
    sum(price) as volume_sale,
    count(tx_id) as sale_no,
    avg(price) as average_sale_price
    from flow.core.fact_nft_sales
    where TX_SUCCEEDED='TRUE' and CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'
    and NFT_COLLECTION='A.329feb3ab062d289.RaceDay_NFT'
    group by 1
    order by 1

    Run a query to Download Data