Eman-RazTotal NFT Sales
    Updated 2023-04-13
    select count(distinct contract_address) as "Total Collections Count",
    count(distinct purchaser) as "Total Purchasers Count", count(distinct seller) as "Total Sellers Count", count(distinct token_id) as "Total NFTs Count",
    count(distinct tx_id) as "Total Sales Count", sum(sales_amount)/pow(10,6) as "Total Sales Volume"
    from terra.core.fact_nft_sales
    where tx_succeeded='TRUE' and block_timestamp::date>='2023-01-01' and currency='uluna'

    Run a query to Download Data