kidaOsmo sold by hour
    Updated 2022-07-07
    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
    Run a query to Download Data