-- forked from Arbitrum big transactions @ https://flipsidecrypto.xyz/edit/queries/d9069020-0e7a-4169-b59f-479eae9da886

-- forked from Polygon big transactions @ https://flipsidecrypto.xyz/edit/queries/285400ef-8baf-4442-97a3-185455110dcb

-- forked from BSC big transactions @ https://flipsidecrypto.xyz/edit/queries/3464771a-76e2-4fca-9f40-1a2f8afcb13c

-- forked from BSC daily test @ https://flipsidecrypto.xyz/edit/queries/548821d0-92c0-48d8-9e65-77e1a9b7deba

WITH routers AS (

SELECT *

FROM VALUES

--update 2023-02-24

('avalanche', 'Trader Joe', 'JoeRouter02', 'Router', '0x60ae616a2155ee3d9a68541ba4544862310933d4'),

('avalanche', 'Trader Joe', 'SwapLogic', 'Router', '0x079c68167f85cb06ed550149cce250e06dc3c52d'),

('avalanche', 'Trader Joe', 'JoePair', 'Router', '0xed8cbd9f0ce3c6986b22002f03c6475ceb7a6256'),

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

('avalanche', '1inch', 'AggregationRouterV4', 'Aggregator', '0x1111111254fb6c44bac0bed2854e76f90643097d'),

('avalanche', 'MetaMask', '', 'Aggregator of Aggregators', '0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31'),

('avalanche', 'SushiSwap', 'SushiSwapRouter', 'Router', '0x1b02da8cb0d097eb8d57a175b88c7d8b47997506'),

('avalanche', 'SushiSwap', 'SushiXSwap', 'Router', '0x2c8c987c4777ab740d20cb581f5d381be95a4a4a'),

('avalanche', 'Bogged Finance', '', 'Aggregator', '0xb099ed146fad4d0daa31e3810591fc0554af62bb'),

('avalanche', 'AnySwap', '', 'Router', '0xb0731d50c681c45856bfc3f7539d5f61d4be81d8'),

('avalanche', 'Pangolin Exchange', 'PangolinRouter', 'Router', '0xe54ca86531e17ef3616d22ca28b0d458b6c89106'),

('avalanche', 'Socket', 'Registry', 'Aggregator of Aggregators', '0x2b42affd4b7c14d9b7c2579229495c052672ccd3'),

('avalanche', 'Odos', '', 'Aggregator', '0xfe7ce93ac0f78826cd81d506b07fe9f459c00214'),

('avalanche', 'GMX', 'Router', 'Router', '0x5f719c2f1095f7b9fc68a68e35b51194f4b6abe8'),

('avalanche', 'WooFi', 'WooCrossChainRouter', 'Router', '0xdf37f7a85d4563f39a78494568824b4df8669b7a'),

('avalanche', 'WooFi', 'WooRouterV2', 'Router', '0x5aa6a4e96a9129562e2fc06660d07feddaaf7854')

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

),

incorrect_tokens AS (

SELECT *

FROM VALUES