Ali3NOptimism Bridging Activity Around Base Announcement
    Updated 2023-03-04
    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
    Run a query to Download Data