Eman-RazTotal NFT Sales
Updated 2023-04-13Copy Reference Fork
9
1
2
3
4
5
6
›
⌄
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