with steth_out AS (
select distinct tx_hash
from ethereum_core.ez_dex_swaps
where token_out = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
),
source AS (
SELECT pool_name, sum(amount_in_usd) AS amount, symbol_in, count(tx_hash)
FROM ethereum_core.ez_dex_swaps
WHERE tx_hash IN (SELECT tx_hash FROM steth_Out)
GROUP BY pool_name, symbol_in
ORDER BY amount DESC
)
SELECT *
FROM source
WHERE amount IS NOT NULL