block_timestamp::date as date,

CASE

WHEN block_timestamp::date >= '2022-10-11' THEN 'Post hack' ELSE 'Pre hack'

END as period,

count(DISTINCT tx_id) as sales_cnt,

count(DISTINCT seller) as sellers,

count(DISTINCT PURCHASER) as buyers,

sum(sales_amount) as volume

FROM solana.core.fact_nft_sales

where block_timestamp >= '2022-10-01'

and block_timestamp::date <= CURRENT_DATE - 1

GROUP BY 1, 2