when day_name = 'Sun' then '01. Sun'

when day_name = 'Mon' then '02. Mon'

when day_name = 'Tue' then '03. Tue'

when day_name = 'Wed' then '04. Wed'

when day_name = 'Thu' then '05. Thu'

when day_name = 'Fri' then '06. Fri'

when day_name = 'Sat' then '07. Sat'

end as day_name,

hour_time,

case

when tx_cnt > 1000000 then 1000000

else tx_cnt

end as tx_cnt

(select dayname(date(block_timestamp)) as day_name,

hour(block_timestamp) as hour_time,

count(distinct tx_hash) as tx_cnt

from monad.testnet.fact_transactions

group by 1,2

)

order by day_name, hour_time