Ali3NCamelot Exchange Swap Pairs (Ordering By Swap Pair Alphabetical)
    Updated 2023-06-30
    with pairs1 as (
    select event_inputs:token0 as Token0_Address,
    case when token0_address = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' then 'WETH'
    when token0_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'DAI'
    when token0_address = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' then 'USDC'
    when token0_address = '0x9277b5e9ff9a94f4af522eb66f4a268756a73a86' then 'KTES222'
    when token0_address = '0xe2b9562005c9f8b5c921d6ddb94193521633dcac' then 'KTES4444'
    when token0_address = '0x3fda994d9366651c7bf114f83b155452c61087bd' then 'PARALLEL'
    when token0_address = '0xa809e08db0b03e43e342b85710c57ec5298e733a' then 'DSX'
    when token0_address = '0xc0af0891549a678d3e5588ec1cc99c6713845f7d' then 'TDEF'
    when token0_address = '0xe19cfd416bdb40125e9bae583fb9dd5d0bfc0fb8' then 'TKN'
    when token0_address = '0x20aa7fcd549d8b3eb96f6540352dfc947903392a' then 'TTAI'
    when token0_address = '0x34d0921b435b57f50415806f060dc5326f33938b' then 'CMLT-LP'
    when token0_address = '0x686312523854a76d85160c78fdaeecd2a353b31b' then 'BMA'
    when token0_address = '0x809a2f07f22be412c24c69185723286d43a33a59' then 'MAKIS'
    when token0_address = '0x74ac3746308fee41612a21cb695497124330f8f4' then 'KTEST1'
    when token0_address = '0xa4dadeeb8ede703e7a41cee94cfd7d75cf262c2c' then 'RAMEN'
    when token0_address = '0x827e2e6efc2ce7f7e14e65c4dc74ff5512cfd565' then 'FCTR'
    else coalesce(t4.symbol,t2.address_name) end as Token0_Name,
    case when token0_address = '0x9277b5e9ff9a94f4af522eb66f4a268756a73a86' then '18'
    when token0_address = '0xc0af0891549a678d3e5588ec1cc99c6713845f7d' then '18'
    when token0_address = '0x3fda994d9366651c7bf114f83b155452c61087bd' then '18'
    when token0_address = '0xa809e08db0b03e43e342b85710c57ec5298e733a' then '18'
    when token0_address = '0x34d0921b435b57f50415806f060dc5326f33938b' then '18'
    when token0_address = '0x686312523854a76d85160c78fdaeecd2a353b31b' then '10'
    when token0_address = '0x809a2f07f22be412c24c69185723286d43a33a59' then '18'
    when token0_address = '0x20aa7fcd549d8b3eb96f6540352dfc947903392a' then '18'
    when token0_address = '0x74ac3746308fee41612a21cb695497124330f8f4' then '18'
    when token0_address = '0xa4dadeeb8ede703e7a41cee94cfd7d75cf262c2c' then '9'
    when token0_address = '0x827e2e6efc2ce7f7e14e65c4dc74ff5512cfd565' then '9'
    when token0_address = '0xe19cfd416bdb40125e9bae583fb9dd5d0bfc0fb8' then '18'
    when token0_address = '0xe2b9562005c9f8b5c921d6ddb94193521633dcac' then '18'
    else t4.decimals end as token0_Decimal,
    event_inputs:token1 as Token1_Address,
    case when token1_address = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' then 'WETH'
    when token1_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'DAI'
    Run a query to Download Data