DATE_TRUNC ('day' ,BLOCK_TIMESTAMP) AS day,

iff(BLOCK_TIMESTAMP::date >= '2023-01-14', 'After Announce', ' Before Announce') as type ,

sum(TX_COUNT)/(24*3600) AS TPS,

100*(TPS-lag(TPS,1)over(order by day))/lag(TPS,1)over(order by day) "TPS change %"

from terra.core.fact_blocks

where BLOCK_TIMESTAMP::date ilike '2023%'

GROUP BY 1,2