-- forked from ROUTERS SHARE - ETH (hourly) @ https://flipsidecrypto.xyz/edit/queries/70738542-4be7-444c-af32-3bcc1e637bb7

WITH routers AS (

SELECT *

FROM VALUES

--update 2023-02-24

('optimism', 'Slingshot Finance', 'Swap', '#N/A', '0x00c0184c0b5d42fba6b7ca914b31239b419ab80b'),

('optimism', 'SushiSwap', 'SushiXSwap', 'Router', '0x8b396ddf906d552b2f98a8e7d743dd58cd0d920f'),

('optimism', 'Uniswap', 'SwapRouter', 'Router', '0xe592427a0aece92de3edee1f18e0157c05861564'),

('optimism', 'Uniswap', 'SwapRouter02', 'Router', '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45'),

('optimism', '1inch', 'AggregationRouterV4', 'Aggregator', '0x1111111254760f7ab3f16433eea9304126dcd199'),

('optimism', '1inch', 'AggregationRouterV3', 'Aggregator', '0x11111112542d85b3ef69ae05771c2dccff4faa26'),

('optimism', '1inch', 'AggregationRouterV5', 'Aggregator', '0x1111111254eeb25477b68fb85ed929f73a960582'),

('optimism', 'ZeroEx', 'ExchangeProxy', 'Aggregator', '0xdef1abe32c034e558cdd535791643c58a13acc10'),

('optimism', 'Clipper', 'ClipperPackedVerifiedExchange', 'Router', '0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40'),

('optimism', 'Stargate', 'Router', 'Router', '0xb0d502e938ed5f4df2e681fe6e419ff29631d62b'),

('optimism', 'Velodrome', 'Router', 'Router', '0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9'),

('optimism', 'Velodrome', 'Router', 'Router', '0x9c12939390052919af3155f41bf4160fd3666a6f'),

('optimism', 'Socket', 'Registry', 'Aggregator of Aggregators', '0xc30141b657f4216252dc59af2e7cdb9d8792e1b0'),

('optimism', 'Odos', 'OdosRouter', 'Aggregator', '0x69dd38645f7457be13571a847ffd905f9acbaf6d'),

('optimism', 'WooFi', 'WooRouter', 'Router', '0xeaf1ac8e89ea0ae13e0f03634a4ff23502527024'),

('optimism', 'LiFi', 'LiFiDiamond_v2', 'Aggregator of Aggregators', '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'),

('optimism', 'Via router', 'ViaRouter', 'Aggregator of Aggregators', '0x777777773fdd8b28bb03377d10fcea75ad9768da')

AS data(blockchain, project, router_name, contract_type, address)

),

incorrect_tokens AS (

SELECT *

FROM VALUES

('')

AS date(token_address)