PREVIEW / stock_1hour / 2025-10-01
file: by_date/stock_1hour/2025/2025-10-01.parquet size: 1.5 MB rows: 64,323 symbols: 292
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-01 04:00:00 | AAPL | Stock | 253.38 | 253.38 | 251.51 | 252.52 | 13639.0 |
| 2025-10-01 05:00:00 | AAPL | Stock | 252.47 | 253.06 | 252.41 | 253.01 | 14703.0 |
| 2025-10-01 06:00:00 | AAPL | Stock | 253.13 | 253.93 | 253.13 | 253.5 | 14122.0 |
| 2025-10-01 07:00:00 | AAPL | Stock | 253.46 | 254.12 | 253.4 | 253.97 | 22182.0 |
| 2025-10-01 08:00:00 | AAPL | Stock | 253.53 | 255.8999 | 251.11 | 255.19 | 200521.0 |
| 2025-10-01 09:00:00 | AAPL | Stock | 255.1 | 258.79 | 254.32 | 256.505 | 7807393.0 |
| 2025-10-01 10:00:00 | AAPL | Stock | 256.515 | 257.33 | 255.4 | 255.53 | 4745096.0 |
| 2025-10-01 11:00:00 | AAPL | Stock | 255.53 | 256.12 | 255.1 | 256.11 | 2867109.0 |
| 2025-10-01 12:00:00 | AAPL | Stock | 256.1 | 256.93 | 255.9376 | 256.4532 | 2401275.0 |
| 2025-10-01 13:00:00 | AAPL | Stock | 256.46 | 256.8298 | 255.855 | 256.4561 | 1780595.0 |
| 2025-10-01 14:00:00 | AAPL | Stock | 256.4512 | 256.75 | 256.235 | 256.74 | 1627257.0 |
| 2025-10-01 15:00:00 | AAPL | Stock | 256.73 | 256.94 | 255.28 | 255.41 | 4457592.0 |
| 2025-10-01 16:00:00 | AAPL | Stock | 255.45 | 256.1134 | 255.1312 | 255.4 | 11540566.0 |
| 2025-10-01 17:00:00 | AAPL | Stock | 255.38 | 255.5 | 255.26 | 255.4 | 12295.0 |
| 2025-10-01 18:00:00 | AAPL | Stock | 255.4 | 255.48 | 255.3195 | 255.34 | 20919.0 |
| 2025-10-01 19:00:00 | AAPL | Stock | 255.35 | 255.4 | 255.2201 | 255.28 | 19354.0 |
| 2025-10-01 04:00:00 | MSFT | Stock | 512.95 | 513.59 | 512.0 | 513.5 | 3896.0 |
| 2025-10-01 05:00:00 | MSFT | Stock | 513.5 | 513.88 | 513.5 | 513.88 | 2265.0 |
| 2025-10-01 06:00:00 | MSFT | Stock | 513.8 | 514.06 | 513.25 | 513.69 | 5583.0 |
| 2025-10-01 07:00:00 | MSFT | Stock | 513.5 | 514.5 | 513.38 | 514.15 | 9629.0 |
| 2025-10-01 08:00:00 | MSFT | Stock | 513.5 | 517.95 | 512.15 | 514.15 | 54006.0 |
| 2025-10-01 09:00:00 | MSFT | Stock | 514.4 | 517.25 | 512.1001 | 512.63 | 1769296.0 |
| 2025-10-01 10:00:00 | MSFT | Stock | 512.67 | 514.25 | 511.69 | 514.22 | 1256573.0 |
| 2025-10-01 11:00:00 | MSFT | Stock | 514.25 | 515.4 | 513.36 | 513.905 | 879722.0 |
| 2025-10-01 12:00:00 | MSFT | Stock | 513.91 | 517.06 | 513.81 | 517.005 | 921639.0 |
| 2025-10-01 13:00:00 | MSFT | Stock | 517.0 | 519.51 | 516.635 | 517.66 | 898211.0 |
| 2025-10-01 14:00:00 | MSFT | Stock | 517.61 | 519.87 | 517.46 | 519.36 | 734731.0 |
| 2025-10-01 15:00:00 | MSFT | Stock | 519.34 | 520.505 | 518.26 | 519.6 | 1715956.0 |
| 2025-10-01 16:00:00 | MSFT | Stock | 519.71 | 519.71 | 518.67 | 518.68 | 5443558.0 |
| 2025-10-01 17:00:00 | MSFT | Stock | 518.68 | 518.95 | 518.5 | 518.8099 | 10014.0 |
| 2025-10-01 18:00:00 | MSFT | Stock | 518.92 | 519.71 | 518.7 | 519.1 | 4755.0 |
| 2025-10-01 19:00:00 | MSFT | Stock | 519.0 | 519.6 | 518.6504 | 519.13 | 4835.0 |
| 2025-10-01 04:00:00 | NVDA | Stock | 184.3 | 185.63 | 184.1 | 185.13 | 396593.0 |
| 2025-10-01 05:00:00 | NVDA | Stock | 185.11 | 185.74 | 184.98 | 185.4 | 238448.0 |
| 2025-10-01 06:00:00 | NVDA | Stock | 185.41 | 185.56 | 185.12 | 185.17 | 150977.0 |
| 2025-10-01 07:00:00 | NVDA | Stock | 185.16 | 185.77 | 185.12 | 185.55 | 386421.0 |
| 2025-10-01 08:00:00 | NVDA | Stock | 185.21 | 185.98 | 183.98 | 184.91 | 1835474.0 |
| 2025-10-01 09:00:00 | NVDA | Stock | 184.93 | 186.1 | 183.9 | 184.207 | 22485601.0 |
| 2025-10-01 10:00:00 | NVDA | Stock | 184.19 | 187.865 | 184.02 | 187.21 | 29252887.0 |
| 2025-10-01 11:00:00 | NVDA | Stock | 187.2 | 187.86 | 186.42 | 187.2699 | 15705118.0 |
| 2025-10-01 12:00:00 | NVDA | Stock | 187.27 | 187.53 | 186.48 | 187.0856 | 10006396.0 |
| 2025-10-01 13:00:00 | NVDA | Stock | 187.085 | 188.14 | 187.02 | 187.525 | 14399132.0 |
| 2025-10-01 14:00:00 | NVDA | Stock | 187.52 | 187.9 | 187.3 | 187.4093 | 7670729.0 |
| 2025-10-01 15:00:00 | NVDA | Stock | 187.405 | 187.605 | 186.36 | 187.17 | 16706856.0 |
| 2025-10-01 16:00:00 | NVDA | Stock | 187.16 | 187.4 | 186.86 | 186.88 | 16833378.0 |
| 2025-10-01 17:00:00 | NVDA | Stock | 186.88 | 187.24 | 186.77 | 186.8299 | 190647.0 |
| 2025-10-01 18:00:00 | NVDA | Stock | 186.83 | 187.09 | 186.8001 | 187.04 | 154231.0 |
| 2025-10-01 19:00:00 | NVDA | Stock | 187.03 | 187.16 | 186.91 | 186.9497 | 191929.0 |
| 2025-10-01 04:00:00 | AMZN | Stock | 218.56 | 218.56 | 217.34 | 218.01 | 20593.0 |
| 2025-10-01 05:00:00 | AMZN | Stock | 218.09 | 218.35 | 218.05 | 218.25 | 11980.0 |
> showing 50 of 64,323 rows — these rows as CSV