c.pool_name AS pool_name,

COUNT(c.tx_id) AS n_txn,

sum(c.amount_in_usd) AS volume_in_USD

FROM

(SELECT

date_trunc('day', a.block_timestamp) AS date, a.tx_id AS tx_id, b.symbol AS symbol, b.amount_usd AS amount_in_usd, a.pool_name as pool_name

FROM ethereum.dex_swaps a

RIGHT JOIN ethereum.udm_events b

ON a.tx_id = b.tx_id

WHERE a.platform = 'sushiswap'

AND date > '2021-08-01'

AND date < '2021-10-01'

AND b.amount_usd != 0

AND b.symbol = 'EDEN'

)c

GROUP BY pool_name--, date

order BY volume_in_USD DESC

limit 10