2,648 answered market questions

SELECT
    toString(date)                                                                                AS session_date,
    concat(monthName(date), ' ', toString(toDayOfMonth(date)), ', ', toString(toYear(date)))      AS move_label,
    if(move_pct >= 0, 'higher', 'lower')                                                          AS direction,
    abs(move_pct)                                                                                 AS abs_move_pct,
    round(abs(move_pct) * 2, 2)                                                                   AS trade_2x_pct_of_assets,
    round(abs(move_pct) * 6, 2)                                                                   AS trade_3x_pct_of_assets
FROM
(
    SELECT
        date,
        round(100 * (close_px / lagInFrame(close_px)
              OVER (ORDER BY date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) - 1), 2)          AS move_pct
    FROM
    (
        SELECT
            date,
            max(toFloat64(close)) AS close_px
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'QQQ'
          AND date >= '2024-12-16'
          AND date <= '2025-12-31'
        GROUP BY date
    )
)
WHERE date >= '2025-01-02'
ORDER BY abs_move_pct DESC
LIMIT 12