SELECT
DATE_TRUNC('month', block_timestamp) AS date,
project,
COUNT(DISTINCT transaction_from_address) AS "Sandwich Attackers",
ROUND(SUM(COALESCE(usd_amount, 0)), 2) AS "USD Volume"
FROM
ethereum.dex.sandwich_trades
GROUP BY
ALL
ORDER BY
date DESC,
"USD Volume" DESC
LIMIT
500000
2024-10-01T00:00:00
uniswap
2024-10-01T00:00:00
balancer