WITH eth_from AS (
SELECT symbol_out, COUNT(*) as num_swaps,
COUNT(DISTINCT sender) as num_distinct_swappers,
SUM(amount_in_usd) as swap_vol_usd
FROM ethereum.core.ez_dex_swaps
WHERE token_in = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
AND block_timestamp BETWEEN '2022-09-15' AND current_date - 2
GROUP BY symbol_out
)
SELECT *
FROM eth_from
WHERE swap_vol_usd IS NOT NULL
AND symbol_out IS NOT NULL
ORDER BY num_distinct_swappers DESC
LIMIT 5