SELECT
DATE_PART(hour, block_timestamp) as hour,
SUM(IFF(from_currency = 'uosmo', from_amount, -to_amount)) / 1e6 as osmo_sold
FROM osmosis.core.fact_swaps
WHERE (from_currency = 'uosmo' OR to_currency = 'uosmo') AND tx_status = 'SUCCEEDED'
GROUP BY hour
ORDER BY hour
LIMIT 10000