select date,
case when date < '2023-02-23' then 'Before Base Announcement'
when date = '2023-02-23' then 'Base Announcement'
when date > '2023-02-23' then 'After Base Announcement' end as timespan,
deposit_txs as Deposits_Count,
withdraw_txs as Withdrawals_Count,
deposit_usd as Deposits_Volume,
withdraw_usd*-1 as Withdrawal_Volume,
deposit_usd - withdraw_usd as Net_Volume
from external.defillama.fact_bridge_volume
where bridge ilike '%optimism%'
and date >= '2023-02-01'
order by 1