PREVIEW / stock_1hour / 2000-10-30
file: by_date/stock_1hour/2000/2000-10-30.parquet size: 311 KB rows: 16,020 symbols: 1,247
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-30 08:00:00 | AAPL | Stock | 0.3393 | 0.3454 | 0.3309 | 0.3371 | 2844800.0 |
| 2000-10-30 09:00:00 | AAPL | Stock | 0.3348 | 0.3482 | 0.3348 | 0.3449 | 99484000.0 |
| 2000-10-30 10:00:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3359 | 0.3393 | 108640000.0 |
| 2000-10-30 11:00:00 | AAPL | Stock | 0.3393 | 0.3438 | 0.3382 | 0.3393 | 58178400.0 |
| 2000-10-30 12:00:00 | AAPL | Stock | 0.3382 | 0.3426 | 0.3359 | 0.3415 | 44861600.0 |
| 2000-10-30 13:00:00 | AAPL | Stock | 0.3426 | 0.3516 | 0.3415 | 0.3516 | 77184800.0 |
| 2000-10-30 14:00:00 | AAPL | Stock | 0.3516 | 0.3538 | 0.3482 | 0.3504 | 99192800.0 |
| 2000-10-30 15:00:00 | AAPL | Stock | 0.3516 | 0.356 | 0.3438 | 0.3449 | 95916800.0 |
| 2000-10-30 16:00:00 | AAPL | Stock | 0.3438 | 0.3504 | 0.3415 | 0.3471 | 30788800.0 |
| 2000-10-30 17:00:00 | AAPL | Stock | 0.3471 | 0.3482 | 0.346 | 0.346 | 190400.0 |
| 2000-10-30 18:00:00 | AAPL | Stock | 0.346 | 0.346 | 0.346 | 0.346 | 28000.0 |
| 2000-10-30 08:00:00 | MSFT | Stock | 33.5 | 33.8438 | 33.375 | 33.6875 | 76000.0 |
| 2000-10-30 09:00:00 | MSFT | Stock | 33.625 | 34.875 | 33.2812 | 34.625 | 13739200.0 |
| 2000-10-30 10:00:00 | MSFT | Stock | 34.625 | 34.8438 | 34.4375 | 34.75 | 14702600.0 |
| 2000-10-30 11:00:00 | MSFT | Stock | 34.7812 | 35.0625 | 34.6875 | 34.7188 | 19941800.0 |
| 2000-10-30 12:00:00 | MSFT | Stock | 34.7188 | 34.75 | 34.3438 | 34.4375 | 14075000.0 |
| 2000-10-30 13:00:00 | MSFT | Stock | 34.4062 | 34.5625 | 34.25 | 34.5312 | 9827800.0 |
| 2000-10-30 14:00:00 | MSFT | Stock | 34.5312 | 34.9375 | 34.5312 | 34.6875 | 14678400.0 |
| 2000-10-30 15:00:00 | MSFT | Stock | 34.6875 | 34.75 | 34.4375 | 34.5312 | 13380000.0 |
| 2000-10-30 16:00:00 | MSFT | Stock | 34.5312 | 34.7969 | 34.4375 | 34.625 | 2998600.0 |
| 2000-10-30 17:00:00 | MSFT | Stock | 34.8125 | 34.8125 | 34.5 | 34.625 | 29800.0 |
| 2000-10-30 18:00:00 | MSFT | Stock | 34.625 | 34.6875 | 34.625 | 34.6875 | 5600.0 |
| 2000-10-30 09:00:00 | NVDA | Stock | 0.251 | 0.2557 | 0.2432 | 0.2484 | 22584000.0 |
| 2000-10-30 10:00:00 | NVDA | Stock | 0.2487 | 0.2542 | 0.2438 | 0.2458 | 20232000.0 |
| 2000-10-30 11:00:00 | NVDA | Stock | 0.2461 | 0.2479 | 0.2417 | 0.2417 | 18456000.0 |
| 2000-10-30 12:00:00 | NVDA | Stock | 0.2417 | 0.2458 | 0.2401 | 0.2411 | 24888000.0 |
| 2000-10-30 13:00:00 | NVDA | Stock | 0.2419 | 0.2445 | 0.2409 | 0.243 | 14712000.0 |
| 2000-10-30 14:00:00 | NVDA | Stock | 0.243 | 0.2438 | 0.237 | 0.2411 | 25992000.0 |
| 2000-10-30 15:00:00 | NVDA | Stock | 0.2411 | 0.2448 | 0.2375 | 0.2375 | 45744000.0 |
| 2000-10-30 16:00:00 | NVDA | Stock | 0.2372 | 0.2398 | 0.237 | 0.2385 | 6120000.0 |
| 2000-10-30 18:00:00 | NVDA | Stock | 0.2375 | 0.2375 | 0.2375 | 0.2375 | 168000.0 |
| 2000-10-30 08:00:00 | AMZN | Stock | 1.7 | 1.7188 | 1.6562 | 1.6875 | 2190000.0 |
| 2000-10-30 09:00:00 | AMZN | Stock | 1.6812 | 1.7125 | 1.625 | 1.6938 | 43408000.0 |
| 2000-10-30 10:00:00 | AMZN | Stock | 1.6938 | 1.7188 | 1.65 | 1.6531 | 35760000.0 |
| 2000-10-30 11:00:00 | AMZN | Stock | 1.6531 | 1.6625 | 1.5719 | 1.5812 | 38584000.0 |
| 2000-10-30 12:00:00 | AMZN | Stock | 1.5812 | 1.625 | 1.5125 | 1.6156 | 36220000.0 |
| 2000-10-30 13:00:00 | AMZN | Stock | 1.6094 | 1.6969 | 1.5688 | 1.6906 | 35194000.0 |
| 2000-10-30 14:00:00 | AMZN | Stock | 1.6906 | 1.7 | 1.6344 | 1.6438 | 21708000.0 |
| 2000-10-30 15:00:00 | AMZN | Stock | 1.6438 | 1.7 | 1.6375 | 1.6469 | 24638000.0 |
| 2000-10-30 16:00:00 | AMZN | Stock | 1.6469 | 1.6656 | 1.5688 | 1.6625 | 2284000.0 |
| 2000-10-30 17:00:00 | AMZN | Stock | 1.6656 | 1.6688 | 1.6625 | 1.6688 | 30000.0 |
| 2000-10-30 18:00:00 | AMZN | Stock | 1.6625 | 1.6625 | 1.6625 | 1.6625 | 16000.0 |
| 2000-10-30 09:00:00 | CL | Stock | 28.9 | 28.945 | 28.78 | 28.92 | 384800.0 |
| 2000-10-30 10:00:00 | CL | Stock | 28.925 | 28.925 | 28.525 | 28.65 | 694800.0 |
| 2000-10-30 11:00:00 | CL | Stock | 28.65 | 28.75 | 28.625 | 28.675 | 460200.0 |
| 2000-10-30 12:00:00 | CL | Stock | 28.695 | 28.765 | 28.655 | 28.725 | 275200.0 |
| 2000-10-30 13:00:00 | CL | Stock | 28.725 | 28.85 | 28.7 | 28.75 | 476400.0 |
| 2000-10-30 14:00:00 | CL | Stock | 28.75 | 29.05 | 28.73 | 29.025 | 573200.0 |
| 2000-10-30 15:00:00 | CL | Stock | 29.025 | 29.5 | 29.005 | 29.455 | 733800.0 |
| 2000-10-30 16:00:00 | CL | Stock | 29.47 | 29.495 | 28.9 | 28.9 | 284000.0 |
> showing 50 of 16,020 rows — these rows as CSV