One venue's bad week made Ethereum the top DEX chain of the summer

-- Both series come from saved queries maintained by the Dune team; the SQL is
-- reproduced here so the committed JSON can be traced to its source.

-- 1. Weekly volume by chain (Dune query 5959322, https://dune.com/queries/5959322)
WITH weekly_volume AS (
  SELECT DATE_TRUNC('week', block_date) AS "Date", blockchain AS "Chain", SUM(amount_usd) AS "USD Volume"
  FROM dex.trades
  WHERE block_date > CURRENT_DATE - INTERVAL '180' DAY
  GROUP BY 1, 2
  UNION ALL
  SELECT DATE_TRUNC('week', block_date) AS "Date", 'Solana' AS "Chain", SUM(amount_usd) AS "USD Volume"
  FROM dex_solana.trades
  WHERE block_date > CURRENT_DATE - INTERVAL '180' DAY
  GROUP BY 1, 2
)
SELECT "Date", "Chain", "USD Volume" FROM weekly_volume ORDER BY "Date" DESC, "USD Volume" DESC;

-- 2. Weekly volume by venue, EVM chains only (Dune query 4323, https://dune.com/queries/4323)
SELECT project, DATE_TRUNC('week', block_time), SUM(CAST(amount_usd AS DOUBLE)) AS usd_volume
FROM dex."trades" AS t
WHERE block_time > NOW() - INTERVAL '365' day
GROUP BY 1, 2;

-- 3. The check that would settle the cause, not run here (needs query execution credits):
-- distribution of Balancer trades on Ethereum in the week of 2026-08-31 by pool and by
-- transaction, to see whether $206B is a few mispriced swaps or thousands of real ones.
SELECT project_contract_address AS pool, token_pair,
       COUNT(*) AS trades, SUM(amount_usd) AS usd_volume, MAX(amount_usd) AS largest_trade_usd
FROM dex.trades
WHERE blockchain = 'ethereum' AND project = 'balancer'
  AND block_date >= DATE '2026-08-31' AND block_date < DATE '2026-09-07'
GROUP BY 1, 2
ORDER BY usd_volume DESC
LIMIT 20;