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

crosschain.olas.ez_olas_bonding

GROUP BY

EXTRACT(

DOW

FROM

block_timestamp

)

ORDER BY

total_stakes DESC,

total_volume DESC;