TRADER,

sum(to_amount/power(10, To_DECIMAL))

FROM osmosis.core.fact_swaps

WHERE TO_CURRENCY like 'uosmo'

AND BLOCK_TIMESTAMP BETWEEN '2022-10-25' AND '2022-10-29'

GROUP BY 1

ORDER BY 2 DESC

LIMIT 20