avg (price_usd) as AlgoPrice

from algorand.core.ez_price_pool_balances

group by 1

)

select nft_marketplace,

count (distinct tx_group_id) as Sales,

count (distinct purchaser) as Purchasers,

count (distinct collection_name) as Collections,

count (distinct nft_asset_id) as NFTs,

sum (total_sales_amount) as ALGO_Volume,

sum (total_sales_amount*AlgoPrice) as USD_Volume,

avg (total_sales_amount) as Average_ALGO_Volume,

avg (total_sales_amount*AlgoPrice) as Average_USD_Volume,

min (total_sales_amount) as Minimum_ALGO_price,

min (total_sales_amount*AlgoPrice) as Minimum_USD_price,

max (total_sales_amount) as Maximum_ALGO_price,

max (total_sales_amount*AlgoPrice) as Maximum_USD_price

from algorand.nft.ez_nft_sales t1 join price t2 on t1.block_timestamp::date = t2.day

and total_sales_amount > 0

group by 1