Eman-RazTop 5 Collections Count Based on Sales Count
    Updated 2023-04-13
    select CONTRACT_ADDRESS as "Collection", sum(sales_amount)/pow(10,6) as "Sales Volume", count(distinct purchaser) as "Purchaser Count",
    count(distinct seller) as "Sellers Count", count(distinct tx_id) as "Sales Count"
    from terra.core.fact_nft_sales
    where tx_succeeded='TRUE' and block_timestamp::date>='2023-01-01' and currency='uluna'
    group by 1
    order by 5 desc
    limit 5
    Run a query to Download Data