DATE_TRUNC('month', block_timestamp) AS month,

platform,

COUNT(DISTINCT CASE WHEN amount_in_usd > 100000 THEN swapper END) AS whale_wallets,

SUM(CASE WHEN amount_in_usd > 100000 THEN amount_in_usd ELSE 0 END) AS whale_volume_usd

FROM

aptos.defi.ez_dex_swaps

WHERE

block_timestamp >= '2024-10-01'

AND block_timestamp < CURRENT_DATE

GROUP BY

1, 2

ORDER BY 1 ASC