count(tx_hash) as number_of_nfts_sold,

sum(price) as eth_volume,

count(distinct nft_address) as number_of_projects,

median(price) as median_price,

count(distinct BUYER_ADDRESS) as number_of_buyers

from optimism.core.ez_nft_sales

where 1=1

and block_timestamp > current_date - interval ' {{number_of_months}} months'

and currency_symbol in ('WETH','ETH')

limit 1