0xHaM-dTop 3 collections
    Updated 2022-07-03
    select
    contract_name as nft_collections,
    count(*) as sales_count,
    count(distinct buyer) as buyers_aount,
    count(distinct seller) as selers_cpunt,
    sum(price) as amount
    from flow.core.fact_nft_sales join flow.core.dim_contract_labels on event_contract = nft_collection
    where TX_SUCCEEDED = 'TRUE'
    group by 1
    order by 5 desc
    limit 3
    Run a query to Download Data