with dextable as (select pool_address from ethereum.defi.dim_dex_liquidity_pools where symbols:token0 LIKE 'TUSD' OR symbols:token1 LIKE 'TUSD' )

select date_trunc (hour,block_timestamp) as date,

case when block_timestamp <= '2024-01-15 06:00:00.000' then 'Before Depeg' else 'After Depeg' end as timespan,

avg (current_bal) as Average_Balance,

sum (current_bal) as Balance

from ethereum.core.ez_balance_deltas

where symbol in ('TUSD')

and block_timestamp >= '2024-01-13 00:00:00.000' and block_timestamp <= '2024-01-17 00:00:00.000'

and current_bal < 3e9

and user_address in (select pool_address from dextable)

group by 1,2

order by 1