SELECT
DATE AS dt,
SUM(
CASE
WHEN CHAIN = 'arbitrum' THEN VOLUME
ELSE 0
END
) AS arbitrum_volume,
SUM(
CASE
WHEN CHAIN = 'ethereum' THEN VOLUME
ELSE 0
END
) AS ethereum_volume,
SUM(
CASE
WHEN CHAIN = 'optimism' THEN VOLUME
ELSE 0
END
) AS optimism_volume,
arbitrum_volume / ethereum_volume * 100 AS arbitrum_of_ethereum,
optimism_volume / ethereum_volume * 100 AS optimism_of_ethereum
FROM
external.defillama.fact_dex_volume
WHERE
CHAIN IN ('arbitrum', 'ethereum', 'optimism')
AND DATE = CURRENT_DATE - INTERVAL '1 DAY'
GROUP BY
dt
ORDER BY
dt;