-- 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

('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

('')

AS date(token_address)

SELECT

DATE_TRUNC('hour', block_timestamp) AS time,