shreexMost Popular Collections By Sale Numbers
    Updated 2023-04-13
    with collections as (
    select
    ADDRESS_NAME as collection,
    ADDRESS as m_ad
    from solana.core.dim_labels
    )
    select
    collection,
    count(distinct tx_id) as sales_count,
    sum(sales_amount) as volume,
    avg(sales_amount) as average_nft_price,
    count(distinct mint) as nfts,
    count(distinct purchaser) as unique_buyers,
    count(distinct seller) as unique_sellers
    from solana.core.fact_nft_sales s,collections
    where marketplace='hadeswap'
    and SUCCEEDED = 'TRUE' and block_timestamp >= CURRENT_DATE - 7 AND m_ad=s.mint
    GROUP BY collection
    ORDER BY sales_count DESC
    LIMIT 10