PREVIEW / stock_1hour / 2025-11-07
file: by_date/stock_1hour/2025/2025-11-07.parquet size: 1.4 MB rows: 63,927 symbols: 215
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-07 04:00:00 | AAPL | Stock | 269.58 | 269.7 | 269.24 | 269.42 | 7724.0 |
| 2025-11-07 05:00:00 | AAPL | Stock | 269.28 | 269.6 | 269.18 | 269.41 | 4111.0 |
| 2025-11-07 06:00:00 | AAPL | Stock | 269.43 | 269.77 | 268.67 | 269.77 | 12563.0 |
| 2025-11-07 07:00:00 | AAPL | Stock | 269.5 | 269.91 | 268.74 | 269.04 | 13920.0 |
| 2025-11-07 08:00:00 | AAPL | Stock | 269.75 | 270.11 | 268.67 | 269.68 | 93458.0 |
| 2025-11-07 09:00:00 | AAPL | Stock | 269.66 | 270.5 | 267.27 | 270.0 | 4495857.0 |
| 2025-11-07 10:00:00 | AAPL | Stock | 269.93 | 272.29 | 269.8133 | 270.68 | 4989172.0 |
| 2025-11-07 11:00:00 | AAPL | Stock | 270.655 | 271.21 | 268.56 | 268.895 | 3491214.0 |
| 2025-11-07 12:00:00 | AAPL | Stock | 268.88 | 269.47 | 268.27 | 268.7913 | 2930603.0 |
| 2025-11-07 13:00:00 | AAPL | Stock | 268.8 | 269.045 | 267.6349 | 268.105 | 1959146.0 |
| 2025-11-07 14:00:00 | AAPL | Stock | 268.13 | 268.5 | 267.095 | 267.6232 | 2936775.0 |
| 2025-11-07 15:00:00 | AAPL | Stock | 267.6 | 268.5899 | 266.77 | 268.54 | 5455259.0 |
| 2025-11-07 16:00:00 | AAPL | Stock | 268.46 | 268.7 | 268.3018 | 268.4636 | 7132851.0 |
| 2025-11-07 17:00:00 | AAPL | Stock | 268.53 | 268.61 | 268.47 | 268.55 | 25443.0 |
| 2025-11-07 18:00:00 | AAPL | Stock | 268.54 | 268.7 | 268.52 | 268.68 | 12664.0 |
| 2025-11-07 19:00:00 | AAPL | Stock | 268.69 | 268.69 | 268.63 | 268.689 | 6849.0 |
| 2025-11-07 04:00:00 | MSFT | Stock | 497.94 | 498.08 | 496.5 | 496.5 | 10472.0 |
| 2025-11-07 05:00:00 | MSFT | Stock | 496.53 | 497.15 | 495.98 | 496.49 | 7337.0 |
| 2025-11-07 06:00:00 | MSFT | Stock | 496.31 | 496.31 | 494.23 | 495.75 | 20027.0 |
| 2025-11-07 07:00:00 | MSFT | Stock | 495.99 | 496.27 | 494.4 | 494.9 | 22612.0 |
| 2025-11-07 08:00:00 | MSFT | Stock | 498.0 | 498.76 | 494.247 | 496.6865 | 109128.0 |
| 2025-11-07 09:00:00 | MSFT | Stock | 496.6562 | 499.377 | 494.41 | 495.63 | 2530158.0 |
| 2025-11-07 10:00:00 | MSFT | Stock | 495.49 | 496.98 | 493.25 | 495.175 | 1952066.0 |
| 2025-11-07 11:00:00 | MSFT | Stock | 495.1112 | 495.85 | 493.87 | 495.02 | 1415501.0 |
| 2025-11-07 12:00:00 | MSFT | Stock | 495.04 | 495.69 | 493.61 | 494.71 | 1209881.0 |
| 2025-11-07 13:00:00 | MSFT | Stock | 494.725 | 496.64 | 494.13 | 494.915 | 1069045.0 |
| 2025-11-07 14:00:00 | MSFT | Stock | 494.96 | 497.46 | 494.68 | 495.97 | 1431600.0 |
| 2025-11-07 15:00:00 | MSFT | Stock | 495.98 | 498.3 | 495.15 | 496.92 | 3519935.0 |
| 2025-11-07 16:00:00 | MSFT | Stock | 496.93 | 497.89 | 496.39 | 497.65 | 4062395.0 |
| 2025-11-07 17:00:00 | MSFT | Stock | 497.64 | 497.9 | 496.82 | 497.8 | 31138.0 |
| 2025-11-07 18:00:00 | MSFT | Stock | 497.74 | 497.9 | 497.55 | 497.8428 | 13337.0 |
| 2025-11-07 19:00:00 | MSFT | Stock | 497.77 | 497.9 | 497.77 | 497.86 | 19291.0 |
| 2025-11-07 04:00:00 | NVDA | Stock | 189.39 | 189.45 | 188.12 | 188.45 | 181432.0 |
| 2025-11-07 05:00:00 | NVDA | Stock | 188.37 | 188.55 | 186.91 | 187.16 | 180520.0 |
| 2025-11-07 06:00:00 | NVDA | Stock | 187.17 | 187.17 | 185.47 | 186.72 | 427410.0 |
| 2025-11-07 07:00:00 | NVDA | Stock | 186.79 | 186.98 | 185.03 | 185.66 | 667086.0 |
| 2025-11-07 08:00:00 | NVDA | Stock | 185.66 | 189.67 | 184.58 | 184.92 | 2515518.0 |
| 2025-11-07 09:00:00 | NVDA | Stock | 184.92 | 185.7 | 182.09 | 183.11 | 26035796.0 |
| 2025-11-07 10:00:00 | NVDA | Stock | 183.085 | 183.69 | 180.49 | 180.5003 | 28225426.0 |
| 2025-11-07 11:00:00 | NVDA | Stock | 180.51 | 180.985 | 178.91 | 180.26 | 27389877.0 |
| 2025-11-07 12:00:00 | NVDA | Stock | 180.25 | 182.95 | 179.98 | 182.875 | 19279463.0 |
| 2025-11-07 13:00:00 | NVDA | Stock | 182.885 | 185.1599 | 182.5701 | 184.48 | 19733748.0 |
| 2025-11-07 14:00:00 | NVDA | Stock | 184.47 | 187.15 | 184.15 | 187.1 | 20710418.0 |
| 2025-11-07 15:00:00 | NVDA | Stock | 187.08 | 188.32 | 185.64 | 188.26 | 24474557.0 |
| 2025-11-07 16:00:00 | NVDA | Stock | 188.227 | 189.94 | 188.15 | 189.8964 | 16962682.0 |
| 2025-11-07 17:00:00 | NVDA | Stock | 189.86 | 189.9 | 189.46 | 189.78 | 526157.0 |
| 2025-11-07 18:00:00 | NVDA | Stock | 189.78 | 190.0 | 189.7 | 189.985 | 325165.0 |
| 2025-11-07 19:00:00 | NVDA | Stock | 189.99 | 190.2 | 189.94 | 190.2 | 333045.0 |
| 2025-11-07 04:00:00 | AMZN | Stock | 243.31 | 244.22 | 243.2 | 243.51 | 15892.0 |
| 2025-11-07 05:00:00 | AMZN | Stock | 243.5 | 243.79 | 242.41 | 242.66 | 15558.0 |
> showing 50 of 63,927 rows — these rows as CSV