select block_timestamp::date as date,

case when block_timestamp::Date >= '2022-12-24' and block_timestamp::Date < '2023-01-04' then 'Holidays'

else 'Other Days' end as timespan,

avg (current_bal_usd) as Average_balance

from ethereum.core.ez_balance_deltas

where block_timestamp::Date >= '2022-12-17'

and current_bal_usd > 0 and current_bal_usd < 1e9

group by 1,2