DATE,

case when DATE>='2023-05-24' then 'After upgrade' else 'Before upgrade' end as period,

DEPOSIT_TXS as no_deposits,

WITHDRAW_TXS as no_withdraw,

DEPOSIT_USD as deposit_volume,

WITHDRAW_USD as withdraw_volume,

DEPOSIT_USD-WITHDRAW_USD as tvl,

withdraw_volume/no_withdraw as avg_withdraw,

deposit_volume/no_deposits as avg_deposit

from external.defillama.fact_bridge_volume

where BRIDGE_NAME ilike '%Multichain%'

and DATE>='2023-05-01'