SELECT

dayofweek(block_timestamp) as day_of_week,

HOUR(block_timestamp) as hour_of_day,

sum(AMOUNT) as token_amount

from ethereum.core.ez_token_transfers

where TO_ADDRESS='0x4da27a545c0c5b758a6ba100e3a049001de870f5'

and ORIGIN_TO_ADDRESS='0x4da27a545c0c5b758a6ba100e3a049001de870f5'

and SYMBOL='AAVE'

GROUP BY day_of_week,hour_of_day)

SELECT *,

CASE

WHEN day_of_week = 0 THEN '7_Sunday'

WHEN day_of_week = 1 THEN '6_Monday'

WHEN day_of_week = 2 THEN '5_Tuesday'

WHEN day_of_week = 3 THEN '4_Wednesday'

WHEN day_of_week = 4 THEN '3_Thursday'

WHEN day_of_week = 5 THEN '2_Friday'

WHEN day_of_week = 6 THEN '1_Saturday'

END as day_of_week,

hour_of_day

FROM day_of_week