date_trunc('week', block_timestamp) purchase_week,

CASE WHEN price < 0.01 THEN 'a Below 0.01 ETH'

WHEN price < 0.1 THEN 'b Between 0.01 - 0.1 ETH'

WHEN price < 1 THEN 'c Between 0.1 - 1 ETH'

WHEN price < 5 THEN 'd Between 1 - 5 ETH'

WHEN price < 10 THEN 'e Between 5 - 10 ETH'

ELSE 'f Over 10 ETH' END sale_price,

count(DISTINCT tx_hash) as sales_events,

sum(price) as sales_volume,

median(price) as median_price

FROM optimism.core.ez_nft_sales

WHERE currency_symbol LIKE 'ETH'

GROUP BY 1,2