PREVIEW / stock_1hour / 2025-11-18
file: by_date/stock_1hour/2025/2025-11-18.parquet size: 1.4 MB rows: 60,560 symbols: 211
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2025-11-18 04:00:00 | AAPL | Stock | 266.7 | 268.8 | 266.7 | 268.59 | 24449.0 |
| 2025-11-18 05:00:00 | AAPL | Stock | 268.58 | 269.7 | 268.2 | 269.3 | 29726.0 |
| 2025-11-18 06:00:00 | AAPL | Stock | 269.43 | 269.58 | 268.8 | 268.97 | 10146.0 |
| 2025-11-18 07:00:00 | AAPL | Stock | 269.0 | 269.1 | 267.95 | 268.08 | 28371.0 |
| 2025-11-18 08:00:00 | AAPL | Stock | 268.9209 | 269.49 | 266.1 | 268.38 | 107593.0 |
| 2025-11-18 09:00:00 | AAPL | Stock | 268.55 | 270.71 | 266.45 | 266.73 | 4616443.0 |
| 2025-11-18 10:00:00 | AAPL | Stock | 266.725 | 268.13 | 265.32 | 266.55 | 4525760.0 |
| 2025-11-18 11:00:00 | AAPL | Stock | 266.55 | 268.338 | 266.028 | 267.7 | 3234936.0 |
| 2025-11-18 12:00:00 | AAPL | Stock | 267.7 | 268.79 | 266.43 | 268.56 | 2039479.0 |
| 2025-11-18 13:00:00 | AAPL | Stock | 268.5786 | 269.22 | 268.02 | 268.27 | 1890670.0 |
| 2025-11-18 14:00:00 | AAPL | Stock | 268.27 | 268.8 | 267.68 | 268.795 | 1902527.0 |
| 2025-11-18 15:00:00 | AAPL | Stock | 268.79 | 268.93 | 267.33 | 267.43 | 3668167.0 |
| 2025-11-18 16:00:00 | AAPL | Stock | 267.4098 | 267.95 | 266.69 | 266.9982 | 8366215.0 |
| 2025-11-18 17:00:00 | AAPL | Stock | 266.8052 | 267.08 | 266.77 | 266.9 | 8552.0 |
| 2025-11-18 18:00:00 | AAPL | Stock | 266.95 | 268.05 | 266.95 | 267.55 | 18003.0 |
| 2025-11-18 19:00:00 | AAPL | Stock | 267.78 | 267.78 | 266.55 | 267.29 | 18559.0 |
| 2025-11-18 04:00:00 | MSFT | Stock | 503.8 | 504.56 | 503.0 | 503.65 | 17928.0 |
| 2025-11-18 05:00:00 | MSFT | Stock | 503.65 | 503.66 | 501.02 | 501.86 | 15812.0 |
| 2025-11-18 06:00:00 | MSFT | Stock | 501.78 | 502.25 | 500.22 | 500.82 | 19350.0 |
| 2025-11-18 07:00:00 | MSFT | Stock | 501.09 | 501.14 | 498.28 | 498.5 | 37101.0 |
| 2025-11-18 08:00:00 | MSFT | Stock | 504.23 | 505.42 | 496.25 | 497.1 | 195485.0 |
| 2025-11-18 09:00:00 | MSFT | Stock | 497.28 | 501.01 | 493.06 | 493.99 | 3404001.0 |
| 2025-11-18 10:00:00 | MSFT | Stock | 493.93 | 502.98 | 489.0 | 489.4 | 5026928.0 |
| 2025-11-18 11:00:00 | MSFT | Stock | 489.395 | 494.44 | 486.78 | 491.4395 | 3278910.0 |
| 2025-11-18 12:00:00 | MSFT | Stock | 491.48 | 492.7648 | 487.9 | 492.55 | 1907715.0 |
| 2025-11-18 13:00:00 | MSFT | Stock | 492.6 | 493.33 | 491.605 | 492.12 | 1197067.0 |
| 2025-11-18 14:00:00 | MSFT | Stock | 492.19 | 495.25 | 491.99 | 494.825 | 1295576.0 |
| 2025-11-18 15:00:00 | MSFT | Stock | 494.79 | 495.7399 | 492.95 | 493.79 | 3088180.0 |
| 2025-11-18 16:00:00 | MSFT | Stock | 493.79 | 493.97 | 491.0 | 492.074 | 5970095.0 |
| 2025-11-18 17:00:00 | MSFT | Stock | 491.93 | 492.36 | 491.12 | 491.61 | 25281.0 |
| 2025-11-18 18:00:00 | MSFT | Stock | 491.6 | 493.55 | 491.6 | 493.2 | 15981.0 |
| 2025-11-18 19:00:00 | MSFT | Stock | 493.1615 | 493.44 | 491.5 | 492.5153 | 9376.0 |
| 2025-11-18 04:00:00 | NVDA | Stock | 185.3 | 185.82 | 184.52 | 185.24 | 137187.0 |
| 2025-11-18 05:00:00 | NVDA | Stock | 185.22 | 185.32 | 184.45 | 185.11 | 111299.0 |
| 2025-11-18 06:00:00 | NVDA | Stock | 185.05 | 185.21 | 183.88 | 185.02 | 272514.0 |
| 2025-11-18 07:00:00 | NVDA | Stock | 185.0 | 185.29 | 184.01 | 184.39 | 545658.0 |
| 2025-11-18 08:00:00 | NVDA | Stock | 185.06 | 186.17 | 182.45 | 184.0 | 1790630.0 |
| 2025-11-18 09:00:00 | NVDA | Stock | 183.95 | 184.36 | 180.13 | 180.425 | 24764207.0 |
| 2025-11-18 10:00:00 | NVDA | Stock | 180.39 | 182.67 | 179.65 | 181.1 | 31685893.0 |
| 2025-11-18 11:00:00 | NVDA | Stock | 181.1 | 183.635 | 180.1701 | 183.1201 | 21913569.0 |
| 2025-11-18 12:00:00 | NVDA | Stock | 183.12 | 184.8 | 181.4 | 184.295 | 16329283.0 |
| 2025-11-18 13:00:00 | NVDA | Stock | 184.3 | 184.5 | 183.13 | 183.48 | 12592500.0 |
| 2025-11-18 14:00:00 | NVDA | Stock | 183.47 | 184.65 | 183.015 | 184.005 | 12457400.0 |
| 2025-11-18 15:00:00 | NVDA | Stock | 184.01 | 184.22 | 181.06 | 181.37 | 19793680.0 |
| 2025-11-18 16:00:00 | NVDA | Stock | 181.37 | 182.342 | 180.52 | 181.17 | 17399407.0 |
| 2025-11-18 17:00:00 | NVDA | Stock | 181.12 | 181.17 | 180.66 | 180.8501 | 366774.0 |
| 2025-11-18 18:00:00 | NVDA | Stock | 180.85 | 181.5 | 180.85 | 181.15 | 538310.0 |
| 2025-11-18 19:00:00 | NVDA | Stock | 181.13 | 181.2 | 180.65 | 180.7197 | 534166.0 |
| 2025-11-18 04:00:00 | AMZN | Stock | 229.79 | 230.4 | 229.53 | 230.28 | 24885.0 |
| 2025-11-18 05:00:00 | AMZN | Stock | 230.32 | 230.7 | 229.76 | 230.45 | 9875.0 |
> showing 50 of 60,560 rows — these rows as CSV