SELECT

CASE DATE_PART('dow', 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 trader) AS active_users

FROM

arbitrum.vertex.ez_perp_trades

WHERE

trader != '0x0000000000000000000000000000000000000000'

AND subaccount != '0x0000000000000000000000000000000000000000000000000000000000000001'

GROUP BY

DATE_PART('dow', block_timestamp)

SELECT

day_of_week,

active_users

FROM

user_activity

ORDER BY

CASE

WHEN day_of_week = 'Sunday' THEN 0

WHEN day_of_week = 'Monday' THEN 1

WHEN day_of_week = 'Tuesday' THEN 2

WHEN day_of_week = 'Wednesday' THEN 3

WHEN day_of_week = 'Thursday' THEN 4

WHEN day_of_week = 'Friday' THEN 5

WHEN day_of_week = 'Saturday' THEN 6

END;