shreexComprasions
    Updated 2023-03-13
    SELECT
    split_part(nft_collection, '.', -1) as nft_collection,
    sum(price) as sales_volume,
    max(price) as max_sale_price,
    min(price) as min_sale_price,
    avg(price) as avg_sale_price,
    median(price) as median_sale_price,
    count(distinct buyer) as unique_buyers,
    count(distinct seller) as unique_sellers,
    count(tx_id) as total_sales
    from flow.core.ez_nft_sales
    where nft_collection in ('A.e4cf4bdc1751c65d.AllDay','A.0b2a3299cc857e29.TopShot') and currency='A.ead892083b3e2c6c.DapperUtilityCoin' and block_timestamp>='2022-01-01' and tx_succeeded='TRUE'
    GROUP BY nft_collection
    ORDER BY sales_volume
    Run a query to Download Data