sum(AMOUNT) as volume,

count(*) as number,ACTION, date_trunc('day',BLOCK_TIMESTAMP ) as date,

case

when BLOCK_TIMESTAMP>CURRENT_DATE-14 then 'holidays' else 'other days' end as type, avg(AMOUNT) as average_volume

from terra.core.ez_staking

group by 3,4,5