sum(AMOUNT) as volume, avg(AMOUNT) as aver,

date_trunc('week',BLOCK_TIMESTAMP) as date,

CASE

when date> CURRENT_DATE-21 then 'Holidays'

else 'others' end as type

from

flow.core.ez_token_transfers a

left join flow.core.dim_contract_labels b

on a.TOKEN_CONTRACT=b.EVENT_CONTRACT

GROUP by date, type