SELECT 'DODO' AS dex, PARSE_JSON('["Polygon", "Boba", "BSC", "Moonriver", "Ethereum", "Avalanche", "Aurora"]') AS lifi_chains UNION ALL

SELECT 'ParaSwap', PARSE_JSON('["Ethereum", "Optimism", "Polygon zkEVM"]') UNION ALL

SELECT 'Enso', PARSE_JSON('["Optimism", "Polygon", "BSC", "xDAI", "Ethereum", "Arbitrum"]') UNION ALL

SELECT 'Odos', PARSE_JSON('["ZKsync Era", "Mantle", "Base", "Mode", "Linea", "Fantom", "Avalanche", "Scroll"]') UNION ALL

SELECT '1inch', PARSE_JSON('["Optimism", "ZKsync Era", "Polygon", "BSC", "xDAI", "Base", "Ethereum", "Fantom", "Avalanche", "Aurora", "Arbitrum"]') UNION ALL

SELECT 'OpenOcean', PARSE_JSON('["Sei", "Moonriver", "Ethereum", "Avalanche", "ZKsync Era", "Gravity", "Mantle", "Blast", "Mode", "Metis", "Polygon zkEVM", "Rootstock", "Arbitrum", "Polygon", "BSC", "Linea", "Celo", "Fantom", "Scroll", "Aurora", "Optimism", "xDAI", "Base", "Cronos"]') UNION ALL

SELECT '0x', PARSE_JSON('["Optimism", "Polygon", "BSC", "Blast", "Base", "Linea", "Ethereum", "Avalanche", "Scroll", "Arbitrum"]') UNION ALL

SELECT 'Stable AMM', PARSE_JSON('["Moonbeam"]') UNION ALL

SELECT 'Kyberswap', PARSE_JSON('["Optimism", "ZKsync Era", "Polygon", "Mantle", "BSC", "Blast", "Base", "Linea", "Polygon zkEVM", "Ethereum", "Fantom", "Avalanche", "Scroll", "Arbitrum"]') UNION ALL

SELECT 'LI.FI DEX Aggregator', PARSE_JSON('["Fuse", "Sei", "Moonriver", "Ethereum", "Avalanche", "Blast", "Metis", "Polygon zkEVM", "Rootstock", "Polygon", "BSC", "Moonbeam", "Linea", "Celo", "Fraxtal", "Fantom", "Aurora", "Optimism", "Taiko", "Base", "Immutable zkEVM"]')UNION ALL

SELECT 'Jupiter', PARSE_JSON('["Solana"]') UNION ALL

SELECT 'SushiSwap Aggregator', PARSE_JSON('["Cronos", "Optimism", "Fuse", "Polygon", "BSC", "xDAI", "Blast", "Base", "Metis", "Linea", "Rootstock", "Polygon zkEVM", "Celo", "Ethereum", "Fantom", "Avalanche", "Arbitrum"]') UNION ALL

SELECT 'Bebop', PARSE_JSON('["Optimism", "Taiko", "BSC", "Base", "Ethereum", "Arbitrum"]') UNION ALL

SELECT 'PancakeSwap AMM', PARSE_JSON('["BSC"]') UNION ALL

SELECT 'ApeSwap AMM', PARSE_JSON('["BSC", "Polygon", "Arbitrum"]') UNION ALL

SELECT 'Quickswap Dex', PARSE_JSON('["Polygon"]') UNION ALL

SELECT 'Honeyswap', PARSE_JSON('["xDAI", "Polygon"]') UNION ALL

SELECT 'SpookySwap', PARSE_JSON('["FANTOM"]')

),

defillama AS (

SELECT

dex,

dex_id,

chains.value::string AS chain_name

FROM

external.defillama.dim_dexes,

LATERAL FLATTEN(input => chains) AS chains

,

volume AS (

SELECT