block_timestamp::date as date,

address_name,

sum(sales_amount) as sol_volume,

sum(sol_volume) over (Partition BY address_name ORDER BY date) as cum_sol_volume,

avg(sales_amount) as avg_price,

count(distinct tx_id) as sales_count,

sum(sales_count) over (partition by address_name order by date) as cum_sales_count,

count(distinct purchaser) as buyer_count,

case when date >= '2022-11-08' then 'After FTX Collapse'

else 'Before FTX Collapse' end as Period

from solana.core.fact_nft_sales sale

join solana.core.dim_labels lab on sale.mint = lab.address

where address_name ilike 'Aurory'

and date >= '2022-10-24' and Date<='2022-11-23'

group by 1,2

order by 1