flipside

    highs and lows
    datavortexhighs and lows
    Updated 2024-10-01
    WITH filtered_data AS (
    SELECT
    asset_id,
    hour,
    open,
    high,
    low,
    close,
    provider
    FROM solana.price.fact_prices_ohlc_hourly
    WHERE asset_id = 'wrapped-solana'
    AND hour >= '2024-07-01 00:00:00'
    AND hour < '2024-10-01 00:00:00'
    )
    SELECT
    hour,
    MAX(open) AS open_price,
    MAX(high) AS high_price,
    MIN(low) AS low_price,
    MAX(close) AS close_price
    FROM filtered_data
    GROUP BY hour
    ORDER BY hour ASC;

    QueryRunArchived: QueryRun has been archived