select

date_trunc('month',block_timestamp) as fecha,

platform_name as marketplace,

sum(price_usd) as volume_usd,

count(distinct tx_hash) as txs,

count(distinct seller_address) as monthly_unique_sellers,

count(distinct buyer_address) as monthly_unique_buyers

from ethereum.core.ez_nft_sales

where block_timestamp >= '2021-01-01'

and price_usd < 1e7

group by 1,2

order by fecha desc

select *

from eth_nft_metrics_monthly