PREVIEW / stock_1hour / 2025-09-19
file: by_date/stock_1hour/2025/2025-09-19.parquet size: 1.5 MB rows: 64,530 symbols: 313
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-09-19 04:00:00 | AAPL | Stock | 238.25 | 238.64 | 238.0 | 238.42 | 21305.0 |
| 2025-09-19 05:00:00 | AAPL | Stock | 238.43 | 240.42 | 238.4 | 239.62 | 96935.0 |
| 2025-09-19 06:00:00 | AAPL | Stock | 239.62 | 239.78 | 239.13 | 239.36 | 20735.0 |
| 2025-09-19 07:00:00 | AAPL | Stock | 239.49 | 240.8 | 239.34 | 240.65 | 122544.0 |
| 2025-09-19 08:00:00 | AAPL | Stock | 239.43 | 241.07 | 237.92 | 240.22 | 497983.0 |
| 2025-09-19 09:00:00 | AAPL | Stock | 240.25 | 242.7 | 239.8 | 240.885 | 18172873.0 |
| 2025-09-19 10:00:00 | AAPL | Stock | 240.885 | 243.16 | 240.2106 | 242.84 | 8783299.0 |
| 2025-09-19 11:00:00 | AAPL | Stock | 242.85 | 243.39 | 241.8 | 243.29 | 5705788.0 |
| 2025-09-19 12:00:00 | AAPL | Stock | 243.27 | 245.92 | 243.17 | 245.155 | 9279363.0 |
| 2025-09-19 13:00:00 | AAPL | Stock | 245.16 | 245.95 | 244.9 | 245.4 | 5123283.0 |
| 2025-09-19 14:00:00 | AAPL | Stock | 245.405 | 246.2699 | 244.95 | 245.51 | 6156123.0 |
| 2025-09-19 15:00:00 | AAPL | Stock | 245.5 | 246.3 | 244.74 | 245.28 | 13412674.0 |
| 2025-09-19 16:00:00 | AAPL | Stock | 245.5 | 245.8 | 245.0 | 245.49 | 54575628.0 |
| 2025-09-19 17:00:00 | AAPL | Stock | 245.4894 | 245.69 | 245.47 | 245.49 | 91311.0 |
| 2025-09-19 18:00:00 | AAPL | Stock | 245.5 | 245.7 | 245.5 | 245.65 | 38819.0 |
| 2025-09-19 19:00:00 | AAPL | Stock | 245.66 | 245.75 | 245.64 | 245.69 | 43071.0 |
| 2025-09-19 04:00:00 | MSFT | Stock | 508.96 | 509.46 | 508.96 | 509.38 | 1109.0 |
| 2025-09-19 05:00:00 | MSFT | Stock | 509.35 | 509.8 | 509.35 | 509.8 | 1470.0 |
| 2025-09-19 06:00:00 | MSFT | Stock | 509.4 | 509.4 | 508.5 | 508.5 | 2629.0 |
| 2025-09-19 07:00:00 | MSFT | Stock | 508.69 | 509.7 | 508.69 | 509.65 | 3277.0 |
| 2025-09-19 08:00:00 | MSFT | Stock | 509.2 | 509.8981 | 508.45 | 509.24 | 23303.0 |
| 2025-09-19 09:00:00 | MSFT | Stock | 509.26 | 514.88 | 509.2131 | 514.325 | 6532688.0 |
| 2025-09-19 10:00:00 | MSFT | Stock | 514.38 | 514.625 | 511.95 | 513.69 | 1256103.0 |
| 2025-09-19 11:00:00 | MSFT | Stock | 513.73 | 513.955 | 511.32 | 511.88 | 1180149.0 |
| 2025-09-19 12:00:00 | MSFT | Stock | 511.92 | 513.36 | 511.89 | 512.335 | 774660.0 |
| 2025-09-19 13:00:00 | MSFT | Stock | 512.335 | 512.645 | 510.95 | 511.405 | 757186.0 |
| 2025-09-19 14:00:00 | MSFT | Stock | 511.405 | 511.88 | 510.35 | 511.46 | 988417.0 |
| 2025-09-19 15:00:00 | MSFT | Stock | 511.445 | 519.3 | 510.825 | 518.0 | 5692524.0 |
| 2025-09-19 16:00:00 | MSFT | Stock | 517.93 | 518.0698 | 516.31 | 517.4499 | 18042776.0 |
| 2025-09-19 17:00:00 | MSFT | Stock | 517.35 | 517.93 | 517.0829 | 517.12 | 42596.0 |
| 2025-09-19 18:00:00 | MSFT | Stock | 517.93 | 517.93 | 517.06 | 517.06 | 60039.0 |
| 2025-09-19 19:00:00 | MSFT | Stock | 517.37 | 517.69 | 517.06 | 517.4 | 21544.0 |
| 2025-09-19 04:00:00 | NVDA | Stock | 175.75 | 176.11 | 175.5 | 175.59 | 153925.0 |
| 2025-09-19 05:00:00 | NVDA | Stock | 175.57 | 175.79 | 175.37 | 175.56 | 120531.0 |
| 2025-09-19 06:00:00 | NVDA | Stock | 175.56 | 176.04 | 175.5 | 175.81 | 91928.0 |
| 2025-09-19 07:00:00 | NVDA | Stock | 175.83 | 175.9 | 175.55 | 175.72 | 200962.0 |
| 2025-09-19 08:00:00 | NVDA | Stock | 175.68 | 176.18 | 175.41 | 175.64 | 1308855.0 |
| 2025-09-19 09:00:00 | NVDA | Stock | 175.62 | 177.02 | 175.18 | 176.6099 | 32743585.0 |
| 2025-09-19 10:00:00 | NVDA | Stock | 176.61 | 178.08 | 176.52 | 177.155 | 21612985.0 |
| 2025-09-19 11:00:00 | NVDA | Stock | 177.155 | 177.275 | 175.8 | 176.385 | 15770390.0 |
| 2025-09-19 12:00:00 | NVDA | Stock | 176.3854 | 176.47 | 175.715 | 175.79 | 9798851.0 |
| 2025-09-19 13:00:00 | NVDA | Stock | 175.79 | 176.225 | 175.56 | 175.78 | 9630960.0 |
| 2025-09-19 14:00:00 | NVDA | Stock | 175.78 | 176.21 | 175.55 | 176.11 | 9605997.0 |
| 2025-09-19 15:00:00 | NVDA | Stock | 176.105 | 178.0 | 175.55 | 176.51 | 21180469.0 |
| 2025-09-19 16:00:00 | NVDA | Stock | 176.67 | 176.7177 | 176.3146 | 176.42 | 59640006.0 |
| 2025-09-19 17:00:00 | NVDA | Stock | 176.41 | 176.42 | 176.06 | 176.2125 | 139272.0 |
| 2025-09-19 18:00:00 | NVDA | Stock | 176.2199 | 176.3499 | 176.09 | 176.14 | 109960.0 |
| 2025-09-19 19:00:00 | NVDA | Stock | 176.14 | 176.2 | 176.0 | 176.0 | 152663.0 |
| 2025-09-19 04:00:00 | AMZN | Stock | 231.51 | 231.84 | 231.2 | 231.65 | 11877.0 |
| 2025-09-19 05:00:00 | AMZN | Stock | 231.71 | 232.17 | 231.71 | 232.06 | 8596.0 |
> showing 50 of 64,530 rows — these rows as CSV