date_trunc('day', block_timestamp) as date,

CASE

when date < '2023-01-01' then 'Before'

when date >= '2023-01-01' then 'After'

end as new_year,

count(distinct TX_HASH) as sales,

count(distinct seller_address) as sellers,

count(distinct buyer_address ) as buyers,

sum(PRICE_USD) as USD

from ethereum.core.ez_nft_sales

where event_type = 'sale'

and date between'2022-12-17' and '2023-01-13'

and CURRENCY_SYMBOL ilike 'ETH'

group by 1,2

order by 1 asc