SELECT
CASE
EXTRACT(
DOW
FROM
block_timestamp
)
WHEN 0 THEN 'Sunday'
WHEN 1 THEN 'Monday'
WHEN 2 THEN 'Tuesday'
WHEN 3 THEN 'Wednesday'
WHEN 4 THEN 'Thursday'
WHEN 5 THEN 'Friday'
WHEN 6 THEN 'Saturday'
END AS day_of_week,
COUNT(DISTINCT tx_hash) AS total_stakes,
SUM(olas_amount_usd) AS total_volume
FROM
crosschain.olas.ez_olas_bonding
GROUP BY
EXTRACT(
DOW
FROM
block_timestamp
)
ORDER BY
total_stakes DESC,
total_volume DESC;