date_trunc('day', block_timestamp),

Case

when block_timestamp between '2022-11-06' and '2022-12-15'

then 'Sudden Drop/Slow Climb Period'

else 'Normal'

END as Drop_Period,

count(*),

count(distinct from_address)

from optimism.core.fact_transactions

group by 1, 2