cum_dex_vols.sql

SELECT
  blockchain,
  project,
  version,
  SUM(amount_usd) AS cumvol
FROM dex.trades
WHERE
  block_date > CURRENT_TIMESTAMP - INTERVAL '12' month
GROUP BY
  blockchain,
  project,
  version
ORDER BY
  cumvol DESC

cum_perp_vols.sql

SELECT
  blockchain,
  project,
  SUM(volume_usd) AS cumvol
FROM perpetual.trades
WHERE
  block_date > CURRENT_TIMESTAMP - INTERVAL '12' month
GROUP BY
  blockchain,
  project
ORDER BY
  cumvol DESC

top_flashbots_arbitrageurs.sql

SELECT 
  block_number,
  profit_amount,
  account_address,
  protocols
FROM flashbots.arbitrages
WHERE error IS NULL
ORDER BY profit_amount DESC;