Query editor
with routers as (select * from (values('ethereum', 'Aave Frontend', 'Aave Router', 'InitializableImmutableAdminUpgradeabilityProxy', '', 0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2, ''),('ethereum', 'InstaDapp Frontend', 'InstaDapp Router', 'InstaAccountV2', '', 0x01d1f55d94a53a9517c07f793f35320faa0d2dcf, ''),('ethereum', 'InstaDapp Frontend', 'InstaDapp Router', 'InstaAccountV2', '', 0x9e6e443d582585f55f6fca49edc5a6a94f47e8e8, ''),('ethereum', 'Gravity Frontend', 'Gravity Router', 'Gravity', '', 0x69592e6f9d21989a043646fe8225da2600e5a0f7, ''),('ethereum', 'OlympusDAO: DAO Funds', 'OlympusDAO Router', '', '', 0x245cc372c84b3645bf0ffe6538620b04a217988b, ''),('ethereum', 'Frax Finance Frontend', 'Frax Finance Router', '', '', 0xb1748c79709f4ba2dd82834b8c82d4a505003f27, ''),('ethereum', 'Hashflow Frontend', 'Hashflow Router', '', 'Aggregator', 0xf6a94dfd0e6ea9ddfdffe4762ad4236576136613, ''),-- ('ethereum', '1inch: Exchange 2', 'AggregationRouterV2', 'Aggregator', 0x11111254369792b2ca5d084ab5eea397ca8fa48b, ''),('ethereum', '1inch Integrators', '1inch Router', 'AggregationRouterV2', 'Aggregator', 0x111111125434b319222cdbf8c261674adb56f3ae, ''),('ethereum', '1inch Integrators', '1inch Router', 'AggregationRouterV5', 'Aggregator', 0x1111111254eeb25477b68fb85ed929f73a960582, '1inch wallet + dapp frontend users that choose legacy aggressive option & 1inch API users'),('ethereum', '1inch Integrators', '1inch Router', 'AggregationRouterV4', 'Aggregator', 0x1111111254fb6c44bac0bed2854e76f90643097d, 'used by external project frontends eg oasis'),('ethereum', '1inch Integrators', '1inch Router', 'AggregationRouterV3', 'Aggregator', 0x11111112542d85b3ef69ae05771c2dccff4faa26, ''),('ethereum', '1inch Integrators', '1inch Router', 'AggregationRouterV6', 'Aggregator', 0x111111125421ca6dc452d289314280a0f8842a65, ''),-- ('ethereum', '1inch Integrators', '1inch Fusion', '1inch: Settlement', 'Aggregator', 0xa88800cd213da5ae406ce248380802bd53b47647, ''),-- ('ethereum', '1inch Website: Default', '1inch Fusion', 'The T', 'Solver', 0xa88800cd213da5ae406ce248380802bd53b47647, '1inch fusion volume comes from 1inch frontend'),-- ('ethereum', '1inch Website: Default', '1inch Fusion', 'Arctic Bastion', 'Solver', 0x0B8a49d816Cc709B6Eadb09498030AE3416b66Dc, ''),-- ('ethereum', '1inch Website: Default', '1inch Fusion', '1inch Labs', 'Solver', 0xad3b67bca8935cb510c8d18bd45f0b94f54a968f, ''),-- ('ethereum', '1inch Website: Default', '1inch Fusion', '1inch Labs', 'Solver', 0x55dcad916750c19c4ec69d65ff0317767b36ce90, ''),-- -- ('ethereum', '1inch Fusion', 'Alpha', 'Solver', 0x165d98de005d2818176b99b1a93b9325dbe58181, ''),-- ('ethereum', '1inch Website: Default', '1inch Fusion', 'Seawise', 'Solver', 0xd1742b3c4fbb096990c8950fa635aec75b30781a, ''),-- ('ethereum', '1inch Website: Default', '1inch Fusion', 'Rizzolver', 'Solver', 0x8571c129f335832f6bbc76d49414ad2b8371a422, ''),('ethereum', 'Trust Wallet', 'Trust Wallet Router', 'Swapper', 'Wallet', 0x3c11F6265Ddec22f4d049Dde480615735f451646, ''),('ethereum', 'Unknown: Uniswap V3 Router 2', 'Uniswap V3 Router 2', 'Router 02', 'DEX', 0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45, 'unknown external project frontends'),('ethereum', 'Unknown: Uniswap V3 Router 1', 'Uniswap V3 Router 1', 'Router', 'DEX', 0xe592427a0aece92de3edee1f18e0157c05861564, 'unknown external project frontends'),('ethereum', 'Unknown: Uniswap V2 Router', 'Uniswap V2 Router', 'Router 02', 'DEX', 0x7a250d5630b4cf539739df2c5dacb4c659f2488d, 'advanced long tail token projects'),('base', 'Unknown: Uniswap V2 Router', 'Uniswap V2 Router', 'Uniswap: V2 Router02', 'DEX', 0x4752ba5DBc23f44D87826276BF6Fd6b1C372aD24, ''),('base', 'Unknown: Uniswap V3 Router', 'Uniswap V3 Router', 'Uniswap: V3 Router02', 'DEX', 0x2626664c2603336e57b271c5c0b26f421741e481, ''),('ethereum', 'Unknown: Uniswap Old Universal Router', 'Uniswap Old Universal Router', 'Old Universal Router', 'DEX', 0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b, 'from uniswap swap widget used by external projects eg opensea since June 2023'), -- Uniswap frontends upgraded to V1_2 the week of June 4('ethereum', 'Uniswap Website & Wallet: Default', 'Uniswap Universal Router', 'Universal Router', 'DEX', 0x3fC91A3afd70395Cd496C647d5a6CC9D4B2b7FAD, 'uniswap wallet + dapp frontend'),('ethereum', 'Uniswap Website & Wallet: Default', 'Uniswap Universal Router', 'Uniswap V4: Universal Router', 'DEX', 0x66a9893cc07d91d95644aedd05d03f95e1dba8af, 'uniswap wallet + dapp frontend'),('base', 'Uniswap Website & Wallet: Default', 'Uniswap Universal Router', 'Uniswap V4: Universal Router', 'DEX', 0x6ff5693b99212da76ad316178a184ab56d299b43, 'uniswap wallet + dapp frontend'),('ethereum', 'Coinbase Wallet', 'Coinbase Swaps Router', '0x: Coinbase Wallet Proxy', 'Wallet', 0xe66b31678d6c16e9ebf358268a790b763c133750, ''),('ethereum', 'Crocswap Frontend', 'Crocswap Router', 'CrocSwapDex', 'AMM', 0xAaAaAAAaA24eEeb8d57D431224f73832bC34f688, ''),('ethereum', 'Bebop Frontend', 'Bebop Router', 'BebopAggregationContract', 'Aggregator', 0xbeb09beb09e95e6febf0d6eeb1d0d46d1013cc3c, ''),('ethereum', 'Bebop Frontend', 'Bebop Router', 'Bebop: Settlement', 'Aggregator', 0xbeb09000fa59627dc02bb55448ac1893eaa501a5, ''),('ethereum', '0x API Integrators', '0x API Router', '0x: Exchange Proxy', 'Aggregator', 0xdef1c0ded9bec7f1a1670819833240f027b25eff, ''),('base', '0x API Integrators', '0x API Router', '0x (Allowance Holder)', 'Aggregator', 0x0000000000001ff3684f28c67538d4d072c22734, ''),('ethereum', 'Matcha', '0x API Router', '0x: Exchange Proxy', 'Aggregator', 0x1291C02D288de3De7dC25353459489073D11E1Ae, 'meta-tx module'),('ethereum', 'Matcha', '0x API Router', '0x: Settler V1.6', 'Aggregator', 0x70bf6634ee8cb27d04478f184b9b8bb13e5f4710, 'meta-tx module'),('ethereum', 'MetaMask Swaps', 'MetaMask: Swap Router', 'MetaMask Router', 'Meta-aggregator', 0x881d40237659c251811cec9c364ef91dc08d300c, ''),('base', 'MetaMask Swaps', 'MetaMask: Swap Router', 'MetaMask Router', 'Meta-aggregator', 0x9dDA6Ef3D919c9bC8885D5560999A3640431e8e6, ''),('ethereum', 'Paraswap Integrators', 'Paraswap Router', 'ParaSwap P4', 'Aggregator', 0x1bd435f3c054b6e901b7b108a0ab7617c808677b, ''),('ethereum', 'Paraswap Integrators', 'Paraswap Router', 'ParaSwap: Augustus V6.2', 'Aggregator', 0x6a000f20005980200259b80c5102003040001068, ''),('ethereum', 'Paraswap Integrators', 'Paraswap Router', 'AugustusSwapper v5', 'Aggregator', 0xdef171fe48cf0115b1d80b88dc8eab59176fee57, ''),('ethereum', 'Paraswap Integrators', 'Paraswap Router', 'ParaswapSwapper', 'Aggregator', 0xe1c3ddf10d05fadf0cbf7baad920c3dcbcfa10d8, ''),('ethereum', 'Paraswap Integrators', 'Paraswap Router', 'Aave: Swap Collateral Adapter V3', 'Aggregator', 0xadc0a53095a0af87f3aa29fe0715b5c28016364e, ''),('ethereum', 'Paraswap Integrators', 'Paraswap Router', 'ParaSwapDebtSwapAdapterV3GHO', 'Aggregator', 0xd7852e139a7097e119623de0751ae53a61efb442, ''),('ethereum', 'Paraswap Integrators', 'Paraswap Router', 'Aave: ParaSwapRepayAdapter', 'Aggregator', 0x35bb522b102326ea3f1141661df4626c87000e3e, ''),-- ('ethereum', 'CoWSwap', 'CoW Protocol', 'GPv2Settlement', 'Meta-aggregator', 0x9008d19f58aabd9ed0d60971565aa8510560ab41, ''),('ethereum', 'Rainbow Wallet', 'Rainbow Router', 'RainbowRouter', 'Wallet', 0x00000000009726632680fb29d3f7a9734e3010e2, ''),('ethereum', 'Tokenlon Integrators', 'Tokenlon Router', 'Tokenlon', 'Aggregator', 0x03f34be1bf910116595db1b11e9d1b2ca5d59659, 'used primarily by imtoken wallet'),('ethereum', 'Openocean Integrators', 'Openocean Router','OpenOceanExchangeProxy', 'Aggregator', 0x6352a56caadc4f1e25cd6c75970fa768a3304e64, ''),('ethereum', 'Kyber Integrators', 'Kyber Router', 'MetaAggregationRouterV2', 'Meta-Aggregator', 0x6131b5fae19ea4f9d964eac0408e4408b66337b5, ''),('ethereum', 'Curvefi Frontend', 'Curvefi Router', 'Router', 'DEX', 0xf0d4c12a5768d806021f80a262b4d39d26c58b8d, ''),('ethereum', 'Curvefi Frontend', 'Curvefi Router', 'swap_router', 'DEX', 0x99a58482bd75cbab83b27ec03ca68ff489b5788f, ''),('ethereum', 'Curvefi Frontend', 'Curvefi Router', 'threepool_swap', 'Router', 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7, ''),('ethereum', 'Curvefi Frontend', 'Curvefi Router', 'steth_swap', 'Router', 0xdc24316b9ae028f1497c275eb9192a3ea0f67022, ''),