PREVIEW / stock_1hour / 2025-10-28
file: by_date/stock_1hour/2025/2025-10-28.parquet size: 1.5 MB rows: 64,407 symbols: 222
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-10-28 04:00:00 | AAPL | Stock | 268.51 | 268.76 | 268.36 | 268.36 | 8845.0 |
| 2025-10-28 05:00:00 | AAPL | Stock | 268.51 | 268.68 | 268.33 | 268.41 | 7860.0 |
| 2025-10-28 06:00:00 | AAPL | Stock | 268.26 | 268.42 | 268.13 | 268.3 | 8403.0 |
| 2025-10-28 07:00:00 | AAPL | Stock | 268.28 | 268.73 | 268.24 | 268.57 | 27673.0 |
| 2025-10-28 08:00:00 | AAPL | Stock | 268.69 | 268.85 | 268.05 | 268.4201 | 113301.0 |
| 2025-10-28 09:00:00 | AAPL | Stock | 268.43 | 269.87 | 267.82 | 268.99 | 6191829.0 |
| 2025-10-28 10:00:00 | AAPL | Stock | 268.98 | 269.14 | 268.15 | 268.82 | 3829721.0 |
| 2025-10-28 11:00:00 | AAPL | Stock | 268.87 | 269.0758 | 268.31 | 268.91 | 2368450.0 |
| 2025-10-28 12:00:00 | AAPL | Stock | 268.9119 | 269.89 | 268.66 | 269.59 | 2364199.0 |
| 2025-10-28 13:00:00 | AAPL | Stock | 269.6 | 269.74 | 268.8 | 268.92 | 2282535.0 |
| 2025-10-28 14:00:00 | AAPL | Stock | 268.9034 | 269.3 | 268.78 | 269.115 | 2390673.0 |
| 2025-10-28 15:00:00 | AAPL | Stock | 269.115 | 269.44 | 268.6 | 269.03 | 6043530.0 |
| 2025-10-28 16:00:00 | AAPL | Stock | 269.04 | 269.39 | 268.6 | 268.6143 | 5089734.0 |
| 2025-10-28 17:00:00 | AAPL | Stock | 268.77 | 269.0 | 268.61 | 268.6844 | 31592.0 |
| 2025-10-28 18:00:00 | AAPL | Stock | 268.61 | 268.6856 | 268.36 | 268.4 | 24140.0 |
| 2025-10-28 19:00:00 | AAPL | Stock | 268.4 | 269.0 | 268.35 | 268.35 | 35132.0 |
| 2025-10-28 04:00:00 | MSFT | Stock | 533.23 | 533.36 | 532.06 | 532.48 | 3434.0 |
| 2025-10-28 05:00:00 | MSFT | Stock | 532.02 | 532.88 | 531.85 | 532.88 | 2028.0 |
| 2025-10-28 06:00:00 | MSFT | Stock | 532.76 | 533.06 | 532.64 | 532.64 | 1317.0 |
| 2025-10-28 07:00:00 | MSFT | Stock | 532.91 | 533.0 | 532.55 | 532.6 | 9808.0 |
| 2025-10-28 08:00:00 | MSFT | Stock | 533.0 | 533.9 | 532.0 | 533.75 | 49811.0 |
| 2025-10-28 09:00:00 | MSFT | Stock | 533.78 | 557.5 | 533.78 | 546.32 | 5642402.0 |
| 2025-10-28 10:00:00 | MSFT | Stock | 546.335 | 547.5899 | 542.18 | 542.47 | 2404121.0 |
| 2025-10-28 11:00:00 | MSFT | Stock | 542.45 | 544.85 | 540.77 | 541.3051 | 1629255.0 |
| 2025-10-28 12:00:00 | MSFT | Stock | 541.3151 | 543.514 | 541.08 | 542.5312 | 1438906.0 |
| 2025-10-28 13:00:00 | MSFT | Stock | 542.55 | 543.48 | 541.93 | 542.4495 | 876393.0 |
| 2025-10-28 14:00:00 | MSFT | Stock | 542.46 | 545.5 | 542.0 | 545.1483 | 1152381.0 |
| 2025-10-28 15:00:00 | MSFT | Stock | 545.13 | 545.36 | 541.31 | 542.01 | 1988754.0 |
| 2025-10-28 16:00:00 | MSFT | Stock | 542.15 | 544.0 | 541.88 | 542.5 | 2868728.0 |
| 2025-10-28 17:00:00 | MSFT | Stock | 542.3 | 543.87 | 542.3 | 543.12 | 21420.0 |
| 2025-10-28 18:00:00 | MSFT | Stock | 543.1 | 544.7443 | 543.01 | 544.7149 | 19593.0 |
| 2025-10-28 19:00:00 | MSFT | Stock | 544.68 | 544.7 | 542.07 | 544.5 | 32062.0 |
| 2025-10-28 04:00:00 | NVDA | Stock | 191.2 | 191.47 | 190.6 | 191.15 | 137675.0 |
| 2025-10-28 05:00:00 | NVDA | Stock | 191.16 | 191.61 | 191.07 | 191.44 | 157388.0 |
| 2025-10-28 06:00:00 | NVDA | Stock | 191.43 | 191.58 | 191.3 | 191.33 | 152704.0 |
| 2025-10-28 07:00:00 | NVDA | Stock | 191.33 | 192.67 | 191.3 | 192.63 | 476317.0 |
| 2025-10-28 08:00:00 | NVDA | Stock | 191.27 | 193.36 | 190.62 | 193.1287 | 1849398.0 |
| 2025-10-28 09:00:00 | NVDA | Stock | 193.1295 | 195.469 | 192.65 | 193.82 | 24310675.0 |
| 2025-10-28 10:00:00 | NVDA | Stock | 193.87 | 193.97 | 192.2 | 193.18 | 16414560.0 |
| 2025-10-28 11:00:00 | NVDA | Stock | 193.185 | 193.34 | 191.91 | 193.33 | 12729199.0 |
| 2025-10-28 12:00:00 | NVDA | Stock | 193.34 | 195.55 | 193.3 | 193.875 | 20490676.0 |
| 2025-10-28 13:00:00 | NVDA | Stock | 193.875 | 198.47 | 193.2682 | 198.0401 | 45264549.0 |
| 2025-10-28 14:00:00 | NVDA | Stock | 198.045 | 200.0 | 197.48 | 199.985 | 37967990.0 |
| 2025-10-28 15:00:00 | NVDA | Stock | 199.985 | 203.15 | 199.57 | 201.03 | 61843623.0 |
| 2025-10-28 16:00:00 | NVDA | Stock | 201.035 | 204.75 | 200.6 | 204.6 | 16436162.0 |
| 2025-10-28 17:00:00 | NVDA | Stock | 204.6 | 204.85 | 201.03 | 204.14 | 2652570.0 |
| 2025-10-28 18:00:00 | NVDA | Stock | 204.1 | 204.15 | 203.1 | 203.27 | 1050357.0 |
| 2025-10-28 19:00:00 | NVDA | Stock | 203.28 | 204.44 | 203.16 | 204.43 | 1064611.0 |
| 2025-10-28 04:00:00 | AMZN | Stock | 227.6 | 227.81 | 227.01 | 227.6 | 16276.0 |
| 2025-10-28 05:00:00 | AMZN | Stock | 227.63 | 228.42 | 227.61 | 228.4 | 25463.0 |
> showing 50 of 64,407 rows — these rows as CSV