Date_Trunc('Day',Block_Timestamp) as date,

Count(DISTINCT Tx_hash) as Transactions,

Count(DISTINCT SELLER_ADDRESS) as Sellers,

Count(DISTINCT BUYER_ADDRESS) as Buyers,

Count(Distinct TOKENID) as Nft_sale,

Count(DISTINCT NFT_ADDRESS) as Unique_Nft_Sold,

Sum(PRICE_USD) as Volume,

Avg(PRICE_USD) as Avg_volume,

Sum(TOTAL_FEES) as Overall_Fee,

Concat(buyers +sellers) as Users

From base.nft.ez_nft_sales

Where PLATFORM_NAME = 'element'

Group by date

Order by date,Volume DESC