select

DATE_TRUNC('day', BLOCK_TIMESTAMP_HOUR) as "Date",

case when month("Date") <= 3 then 'Q1'

when month("Date") between 3 and 6 then 'Q2'

when month("Date") between 6 and 9 then 'Q3'

when month("Date") between 9 and 12 then 'Q4'

end as "Quarter",

case when year("Date") = 2022 then '2022'

when year("Date") = 2023 then '2023'

when year("Date") = 2024 then '2024'

when year("Date") = 2025 then '2025'

end as "Year",

sum(TRANSACTION_COUNT) as "Transactions"

from aptos.stats.ez_core_metrics_hourly

group by 1,2,3