/*
WITH dolphin_traders AS (
SELECT
DISTINCT s.trader,
s.platform,
s.amount_in_usd AS volume_in_usd
FROM
near.defi.ez_dex_swaps s
WHERE
s.amount_in_usd BETWEEN 10000 AND 99999 -- Dolphin size (between 10k to 99k)
AND s.block_timestamp >= '2024-01-01' -- Focus on 2024 swaps
)
SELECT
platform,
COUNT(DISTINCT trader) AS total_dolphins
FROM
dolphin_traders
GROUP BY
platform
ORDER BY
total_dolphins DESC;
*/
SELECT DISTINCT platform From near.defi.ez_dex_swaps