Afonso_DiazOvertime (stable pools)
    Updated 2024-07-30
    with t as (
    select
    tx_hash,
    block_timestamp,
    b.amount_usd as amount0_usd,
    b.amount as amount0,
    b.symbol as symbol0,
    c.amount_usd as amount1_usd,
    c.amount as amount1,
    c.symbol as symbol1,
    event_name as action,
    a.origin_from_address as user,
    iff(symbol0 > symbol1, symbol0 || ' - ' || symbol1, symbol1 || ' - ' || symbol0) as swap_pair,
    case
    when swap_pair in ('DAI+ - DAI', 'USDR - USDC', 'pETH - WETH', 'USDt - USDC', 'mWETH - WETH', 'gmdUSDC - DAI', 'WETH - ETH', 'weETH - WETH',
    'USDS - USDC', 'USDC - EUROs', 'rWETH - WETH', 'jEUR - EURS', 'fxUSD - USDs', 'senUSD - USDC', 'wstETH - swETH', 'TUSD - DAI', 'USDT - USDC',
    'frxETH - WETH', 'dUSDC - USDC', 'USDT - EURT', 'USDT - USDN', 'arUSD - USDs', 'USDD - USDC', 'USDT - FRAX', 'tBTC - WBTC', 'WETH.e - WETH',
    'gUSDC - gDAI', 'ezETH - WETH', 'fUSDC - USDC', 'WBTC - SolvBTC', 'iUSD - USDT', 'USDx - USDC', 'USDO - USDC', 'USDLR - USDC',
    'fxEUR - USDC', 'fUSDC - LUSD', 'rtETH - WETH', 'cbETH - WETH', 'wstETH - ankrETH', 'zGND - GND', 'USDC - EUROe', 'USDT - DAI', 'USDT - LUSD',
    'agEUR - EUROe', 'pxGMX - GMX', 'wUSD+ - USDC', 'gmUSD - gDAI', 'uBTC - BTC.b', 'gmUSDC - USDC', 'USDC - EUROC', 'hUSDT - USDT', 'gUSDC - USDC',
    'fDAI - DAI', 'USDE - DAI', 'gBRC - BRC', 'hETH - WETH', 'wstETH - gETH', 'rARB - ARB', 'vWETH - WETH', 'DUSD - DAI', 'ribUSDC - USDC', 'WETH - RWETH',
    'tUSDC - USDC', 'USDT - USDE', 'USDV - USDT', 'WETH - SLETH', 'wstETH - rETH', 'wstETH - WETH', 'WETH - ETH', 'roeUSDC - USDC',
    'sfrxETH - WETH', 'USDV - USD+', 'USDbC - USDC', 'aArbARB - ARB', 'cbETH - GETH', 'WBTC - BTC.b', 'USDN - USDC', 'USDE - USDC', 'gmUSD - USDC',
    'wstETH - rsETH', 'esVELA - VELA', 'geUSDC - USDC', 'USDT - TUSD', 'sSPELL - SPELL', 'nETH - WETH', 'gDAI - USDC', 'ankrETH - WETH', 'geWBTC - WBTC',
    'nUSD - USDC', 'geWETH - WETH', 'xARC - ARC', 'gmdETH - WETH', 'renBTC - WBTC', 'dEth - WETH', 'WBTC - BTCBR', 'hyETH - WETH', 'USDC - LUSD',
    'USDs - USDC', 'USDC - DUSD', 'USSD - USDT', 'gmUSD - USDT', 'LUSD - DAI', 'USDC - MIM', 'goARB - ARB', 'fUSDT - fUSDC', 'aArbWETH - WETH',
    'USDT - USD+', 'USDC - DAI', 'axlUSDC - USDC', 'fUSDT - USDT', 'rsETH - WETH', 'rETH - WETH', 'glpUSDC - USDC', 'apBoop - Boop', 'USDC - USD+',
    'gmdUSDC - gmUSD', 'crvUSD - LUSD', 'wUSDR - USDC', 'USDe - USDC', 'USDs - DAI', 'USDC - GUSD', 'WMATIC - MATIC', 'crvUSD - USDT', 'hUSDC - USDC',
    'wstETH - sfrxETH', 'USDC - TUSD', 'fUSDC - USDT', 'wstETH - ezETH', 'FRAX - DAI', 'miweETH - WETH', 'USDV - USDC', 'USDe - USDT', 'aArbUSDC - USDC',
    'peUSD - USDC', 'weETH - rETH', 'gDAI - DAI', 'apPEAS - PEAS', 'gDAI - USDs', 'eUSD - USDC', 'fxUSD - USDC', 'gETH - WETH') then 'Stable Pools' else 'Volatile Pools'
    end as pair_type,
    iff(block_timestamp::date < '2024-03-14', 'Before fee changes', 'After fee changes') as timespan
    from arbitrum.core.ez_decoded_event_logs a
    join arbitrum.core.ez_token_transfers b
    using (tx_hash, block_timestamp)
    join arbitrum.core.ez_token_transfers c
    QueryRunArchived: QueryRun has been archived