with routers as (

SELECT *

FROM VALUES

--update 2023-02-24

('arbitrum', '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45', 'UniSwap', 'UniSwap', 'UniSwap', 'SwapRouter02', 'app.uniswap.org/#/swap', 'Router', 1, 1),

('arbitrum', '0x1b02da8cb0d097eb8d57a175b88c7d8b47997506', 'SushiSwap', 'SushiSwap', 'SushiSwap', 'UniswapV2Router02', 'https://sushi.com/', 'Router', 3, 1),

('arbitrum', '0xdd94018f54e565dbfc939f7c44a16e163faab331', 'Odos', 'Odos', 'Odos', 'OdosRouter', 'https://odos.xyz', 'Aggregator', 5, 1),

('arbitrum', '0x1111111254eeb25477b68fb85ed929f73a960582', '1inch', '1inch', '1inch', 'AggregationRouterV5', '1inch.io', 'Aggregator', 1, 2),

('arbitrum', '0x1111111254fb6c44bac0bed2854e76f90643097d', '1inch', '1inch', '1inch', 'AggregationRouterV4', '1inch.io', 'Aggregator', 1, 2),

('arbitrum', '0x11111112542d85b3ef69ae05771c2dccff4faa26', '1inch', '1inch', '1inch', 'AggregationRouterV3', '1inch.io', 'Aggregator', 1, 2),

('arbitrum', '0xba12222222228d8ba445958a75a0704d566bf2c8', 'Other', 'Balancer', 'Balancer', 'Vault', 'https://balancer.fi/', 'Router', 11, 5),

('arbitrum', '0x5543550d65813c1fa76242227cbba0a28a297771', 'Other', 'Slingshot Finance', 'Slingshot Finance', '', 'https://slingshot.finance/', 'Aggregator', 12, 4),

('arbitrum', '0xe8c97bf6d084880de38aec1a56d97ed9fdfa0c9b', 'Other', 'Slingshot Finance', 'Slingshot Finance', 'Swap', 'https://slingshot.finance/', '#N/A', 12, 4),

('arbitrum', '0x3d6ba331e3d9702c5e8a8d254e5d8a285f223aba', 'Other', 'GMX', 'GMX', 'PositionRouter', 'https://gmx.io/#/', '#N/A', 11, 3),

('arbitrum', '0xabbc5f99639c9b6bcb58544ddf04efa6802f4064', 'Other', 'GMX', 'GMX', 'Router', 'https://gmx.io/#/', 'Router', 11, 3),

('arbitrum', '0x53bf833a5d6c4dda888f69c22c88c9f356a41614', 'Other', 'Other', 'Stargate', 'Router', 'https://stargate.finance/', 'Router', 16, 8),

('arbitrum', '0xc30141b657f4216252dc59af2e7cdb9d8792e1b0', 'Other', 'Socket', 'Socket', 'Registry', 'https://bungee.exchange/', 'Aggregator of Aggregators', 10, 5),

('arbitrum', '0xdef1c0ded9bec7f1a1670819833240f027b25eff', 'ZeroEx', 'ZeroEx', 'ZeroEx', 'ExchangeProxy', 'https://www.0x.org/', 'Aggregator', 5, 4),

('arbitrum', '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae', 'Other', 'Other', 'LiFi', 'LiFiDiamond_v2', 'li.fi/', 'Aggregator of Aggregators', 18, 9),

('arbitrum', '0x3b6067d4caa8a14c63fdbe6318f27a0bbc9f9237', 'Other', 'Other', 'DODO', 'DODORouteProxy', 'https://dodoex.io/', 'Aggregator', 25, 11),

('arbitrum', '0x777777773fdd8b28bb03377d10fcea75ad9768da', 'Other', 'Other', 'Via router', 'ViaRouter', 'https://router.via.exchange/', 'Aggregator of Aggregators', 30, 12),

('avalanche_c', '0x60ae616a2155ee3d9a68541ba4544862310933d4', 'Other', 'Trader Joe', 'Trader Joe', 'JoeRouter02', 'https://traderjoexyz.com/home#/', 'Router', 10, 1),

('avalanche_c', '0x079c68167f85cb06ed550149cce250e06dc3c52d', 'Other', 'Trader Joe', 'Trader Joe', 'SwapLogic', 'https://traderjoexyz.com/home#/', 'Router', 10, 1),

('avalanche_c', '0xed8cbd9f0ce3c6986b22002f03c6475ceb7a6256', 'Other', 'Trader Joe', 'Trader Joe', 'JoePair', 'https://traderjoexyz.com/home#/', 'Router', 10, 1),

('avalanche_c', '0xe54ca86531e17ef3616d22ca28b0d458b6c89106', 'Other', 'Pangolin Exchange', 'Pangolin Exchange', 'PangolinRouter', 'https://pangolin.exchange/', 'Router', 19, 2),

('avalanche_c', '0x1111111254eeb25477b68fb85ed929f73a960582', '1inch', '1inch', '1inch', 'AggregationRouterV5', '1inch.io', 'Aggregator', 1, 1),

('avalanche_c', '0x1111111254fb6c44bac0bed2854e76f90643097d', '1inch', '1inch', '1inch', 'AggregationRouterV4', '1inch.io', 'Aggregator', 1, 1),

('avalanche_c', '0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31', 'MetaMask', 'MetaMask', 'MetaMask', '', 'https://metamask.io/', 'Aggregator of Aggregators', 4, 4),

('avalanche_c', '0xb099ed146fad4d0daa31e3810591fc0554af62bb', 'Other', 'Bogged Finance', 'Bogged Finance', '', 'https://app.bogged.finance/avax/dashboard', 'Aggregator', 23, 5),

('avalanche_c', '0xb0731d50c681c45856bfc3f7539d5f61d4be81d8', 'Other', 'AnySwap', 'AnySwap', '', 'https://anyswap.exchange/#/router', 'Router', 36, 5),

('avalanche_c', '0xfe7ce93ac0f78826cd81d506b07fe9f459c00214', 'Odos', 'Other', 'Odos', '', 'https://odos.xyz', 'Aggregator', 5, 6),

('avalanche_c', '0x1b02da8cb0d097eb8d57a175b88c7d8b47997506', 'SushiSwap', 'Other', 'SushiSwap', 'SushiSwapRouter', 'https://sushi.com/', 'Router', 3, 8),

('avalanche_c', '0x2c8c987c4777ab740d20cb581f5d381be95a4a4a', 'SushiSwap', 'Other', 'SushiSwap', 'SushiXSwap', 'https://sushi.com/', 'Router', 3, 8),

('avalanche_c', '0x2b42affd4b7c14d9b7c2579229495c052672ccd3', 'Other', 'Other', 'Socket', 'Registry', 'https://bungee.exchange/', 'Aggregator of Aggregators', 10, 6),

('avalanche_c', '0x5f719c2f1095f7b9fc68a68e35b51194f4b6abe8', 'Other', 'GMX', 'GMX', 'Router', 'https://gmx.io/#/', 'Router', 11, 2),