SELECT

tx_hash,

block_timestamp,

from_address AS user

FROM kaia.core.fact_transactions

),

hourly_activity AS (

SELECT

EXTRACT(hour FROM block_timestamp) AS tx_hour,

COUNT(tx_hash) AS tx_count

FROM main

GROUP BY tx_hour

tx_hour,

tx_count,

CASE

WHEN tx_hour BETWEEN 0 AND 5 THEN 'Late Night'

WHEN tx_hour BETWEEN 6 AND 11 THEN 'Morning'

WHEN tx_hour BETWEEN 12 AND 17 THEN 'Afternoon'

WHEN tx_hour BETWEEN 18 AND 23 THEN 'Evening'

END AS time_of_day

FROM hourly_activity

ORDER BY tx_count DESC