CASE DAYOFWEEK(BLOCK_TIMESTAMP)

WHEN 1 THEN 'Sunday'

WHEN 2 THEN 'Monday'

WHEN 3 THEN 'Tuesday'

WHEN 4 THEN 'Wednesday'

WHEN 5 THEN 'Thursday'

WHEN 6 THEN 'Friday'

WHEN 7 THEN 'Saturday'

END AS day_of_week,

COUNT(*) AS bond_events

FROM thorchain.defi.fact_bond_events

GROUP BY CASE DAYOFWEEK(BLOCK_TIMESTAMP)

WHEN 1 THEN 'Sunday'

WHEN 2 THEN 'Monday'

WHEN 3 THEN 'Tuesday'

WHEN 4 THEN 'Wednesday'

WHEN 5 THEN 'Thursday'

WHEN 6 THEN 'Friday'

WHEN 7 THEN 'Saturday'

END

ORDER BY day_of_week desc;