select

date_trunc('month',block_timestamp) as fecha,

marketplace,

sum(sales_amount) as volume,

count(distinct tx_id) as txs,

count(distinct seller) as monthly_unique_sellers,

count(distinct purchaser) as monthly_unique_buyers

from solana.core.fact_nft_sales

where block_timestamp >= '2021-01-01'

--and price_usd < 1e7

group by 1,2

order by fecha desc

select *

from solana_nft_metrics_monthly