SELECT
DATE_TRUNC('week', block_timestamp) AS date,
COALESCE(frontend, 'Others') AS frontend,
COUNT(DISTINCT swapper) AS user_count,
SUM(usd_volume) AS usd_volume
FROM
ethereum.dex.orderflow_beta
GROUP BY
ALL
ORDER BY
1 DESC,
usd_volume DESC
LIMIT
500000
2024-09-16T00:00:00
Others
2024-09-16T00:00:00
mev-bot
2024-09-16T00:00:00
uniswap