PREVIEW / stock_1hour / 2000-10-26
file: by_date/stock_1hour/2000/2000-10-26.parquet size: 306 KB rows: 15,593 symbols: 1,229
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 |
|---|---|---|---|---|---|---|---|
| 2000-10-26 08:00:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3304 | 0.3348 | 1265600.0 |
| 2000-10-26 09:00:00 | AAPL | Stock | 0.3348 | 0.3371 | 0.3304 | 0.3359 | 53502400.0 |
| 2000-10-26 10:00:00 | AAPL | Stock | 0.3348 | 0.3371 | 0.3248 | 0.3259 | 87365600.0 |
| 2000-10-26 11:00:00 | AAPL | Stock | 0.3259 | 0.3292 | 0.3214 | 0.3225 | 111143200.0 |
| 2000-10-26 12:00:00 | AAPL | Stock | 0.3237 | 0.3292 | 0.3225 | 0.3237 | 50416800.0 |
| 2000-10-26 13:00:00 | AAPL | Stock | 0.3237 | 0.3248 | 0.3136 | 0.3147 | 117717600.0 |
| 2000-10-26 14:00:00 | AAPL | Stock | 0.3158 | 0.3237 | 0.3125 | 0.3214 | 115780000.0 |
| 2000-10-26 15:00:00 | AAPL | Stock | 0.3203 | 0.3315 | 0.3192 | 0.3315 | 122231200.0 |
| 2000-10-26 16:00:00 | AAPL | Stock | 0.3315 | 0.3549 | 0.322 | 0.3348 | 11642400.0 |
| 2000-10-26 17:00:00 | AAPL | Stock | 0.3337 | 0.3348 | 0.3315 | 0.3348 | 280000.0 |
| 2000-10-26 18:00:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3315 | 0.3348 | 218400.0 |
| 2000-10-26 08:00:00 | MSFT | Stock | 31.0 | 31.0 | 30.5625 | 30.625 | 325600.0 |
| 2000-10-26 09:00:00 | MSFT | Stock | 30.625 | 31.0312 | 30.4062 | 31.0 | 10139800.0 |
| 2000-10-26 10:00:00 | MSFT | Stock | 31.0 | 31.4375 | 30.8594 | 31.3125 | 12831600.0 |
| 2000-10-26 11:00:00 | MSFT | Stock | 31.2812 | 31.5625 | 31.0 | 31.5625 | 13299800.0 |
| 2000-10-26 12:00:00 | MSFT | Stock | 31.5312 | 32.0 | 31.5 | 31.8125 | 15451000.0 |
| 2000-10-26 13:00:00 | MSFT | Stock | 31.8125 | 31.875 | 31.4062 | 31.6875 | 9551000.0 |
| 2000-10-26 14:00:00 | MSFT | Stock | 31.6562 | 32.4688 | 31.5312 | 32.3438 | 18402800.0 |
| 2000-10-26 15:00:00 | MSFT | Stock | 32.3438 | 32.5312 | 32.125 | 32.25 | 24022200.0 |
| 2000-10-26 16:00:00 | MSFT | Stock | 32.25 | 32.5 | 31.0625 | 32.3125 | 5160800.0 |
| 2000-10-26 17:00:00 | MSFT | Stock | 32.3125 | 32.5 | 31.4531 | 32.5 | 33400.0 |
| 2000-10-26 18:00:00 | MSFT | Stock | 32.5 | 32.7344 | 32.5 | 32.6562 | 14600.0 |
| 2000-10-26 08:00:00 | NVDA | Stock | 0.2504 | 0.2504 | 0.2504 | 0.2504 | 480000.0 |
| 2000-10-26 09:00:00 | NVDA | Stock | 0.2542 | 0.2542 | 0.2458 | 0.2477 | 18144000.0 |
| 2000-10-26 10:00:00 | NVDA | Stock | 0.2492 | 0.2708 | 0.2458 | 0.2521 | 41160000.0 |
| 2000-10-26 11:00:00 | NVDA | Stock | 0.2521 | 0.2544 | 0.2443 | 0.2443 | 24840000.0 |
| 2000-10-26 12:00:00 | NVDA | Stock | 0.2443 | 0.25 | 0.2424 | 0.2461 | 18552000.0 |
| 2000-10-26 13:00:00 | NVDA | Stock | 0.2474 | 0.2484 | 0.2354 | 0.2393 | 34416000.0 |
| 2000-10-26 14:00:00 | NVDA | Stock | 0.2396 | 0.25 | 0.2344 | 0.2477 | 33072000.0 |
| 2000-10-26 15:00:00 | NVDA | Stock | 0.2484 | 0.2625 | 0.243 | 0.2612 | 54360000.0 |
| 2000-10-26 16:00:00 | NVDA | Stock | 0.2612 | 0.2612 | 0.2471 | 0.2612 | 4056000.0 |
| 2000-10-26 17:00:00 | NVDA | Stock | 0.2603 | 0.2603 | 0.2603 | 0.2603 | 24000.0 |
| 2000-10-26 08:00:00 | AMZN | Stock | 1.6125 | 1.65 | 1.5969 | 1.6031 | 688000.0 |
| 2000-10-26 09:00:00 | AMZN | Stock | 1.6063 | 1.6859 | 1.55 | 1.6656 | 30184000.0 |
| 2000-10-26 10:00:00 | AMZN | Stock | 1.6656 | 1.7375 | 1.6625 | 1.675 | 53588000.0 |
| 2000-10-26 11:00:00 | AMZN | Stock | 1.6719 | 1.6938 | 1.6375 | 1.6781 | 34252000.0 |
| 2000-10-26 12:00:00 | AMZN | Stock | 1.675 | 1.7031 | 1.6438 | 1.6594 | 26930000.0 |
| 2000-10-26 13:00:00 | AMZN | Stock | 1.6594 | 1.6812 | 1.5594 | 1.5656 | 40268000.0 |
| 2000-10-26 14:00:00 | AMZN | Stock | 1.5688 | 1.7141 | 1.5594 | 1.7031 | 55616000.0 |
| 2000-10-26 15:00:00 | AMZN | Stock | 1.7062 | 1.8625 | 1.6938 | 1.8438 | 65414000.0 |
| 2000-10-26 16:00:00 | AMZN | Stock | 1.8484 | 1.9 | 1.7 | 1.8 | 11380000.0 |
| 2000-10-26 17:00:00 | AMZN | Stock | 1.8 | 1.825 | 1.5859 | 1.8125 | 346000.0 |
| 2000-10-26 18:00:00 | AMZN | Stock | 1.8125 | 1.8188 | 1.7969 | 1.7984 | 66000.0 |
| 2000-10-26 09:00:00 | CL | Stock | 27.755 | 27.875 | 27.725 | 27.745 | 462000.0 |
| 2000-10-26 10:00:00 | CL | Stock | 27.75 | 28.0 | 27.375 | 27.975 | 618800.0 |
| 2000-10-26 11:00:00 | CL | Stock | 27.95 | 28.44 | 27.9 | 28.3 | 737800.0 |
| 2000-10-26 12:00:00 | CL | Stock | 28.275 | 28.435 | 27.96 | 28.055 | 788600.0 |
| 2000-10-26 13:00:00 | CL | Stock | 28.025 | 28.105 | 27.95 | 27.95 | 465800.0 |
| 2000-10-26 14:00:00 | CL | Stock | 27.955 | 27.99 | 27.65 | 27.7 | 836600.0 |
| 2000-10-26 15:00:00 | CL | Stock | 27.675 | 27.8 | 27.675 | 27.755 | 996000.0 |
> showing 50 of 15,593 rows — these rows as CSV