DATE_TRUNC ('day' ,BLOCK_TIMESTAMP) AS day,

iff(BLOCK_TIMESTAMP::date ilike '2022%', '2022', '2023') as type,

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

from terra.core.fact_blocks

where BLOCK_TIMESTAMP::date >= '2022-01-01'

GROUP BY 1,2