PREVIEW / stock_1hour / 2000-11-14
file: by_date/stock_1hour/2000/2000-11-14.parquet size: 308 KB rows: 15,989 symbols: 1,241
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-11-14 08:00:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3488 | 0.3504 | 336000.0 |
| 2000-11-14 09:00:00 | AAPL | Stock | 0.3527 | 0.3605 | 0.3493 | 0.3594 | 49291200.0 |
| 2000-11-14 10:00:00 | AAPL | Stock | 0.3599 | 0.3638 | 0.3571 | 0.3616 | 75644800.0 |
| 2000-11-14 11:00:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3516 | 0.3549 | 39709600.0 |
| 2000-11-14 12:00:00 | AAPL | Stock | 0.3549 | 0.3616 | 0.3527 | 0.3594 | 31651200.0 |
| 2000-11-14 13:00:00 | AAPL | Stock | 0.3594 | 0.3605 | 0.3549 | 0.3583 | 28593600.0 |
| 2000-11-14 14:00:00 | AAPL | Stock | 0.3571 | 0.365 | 0.3571 | 0.3583 | 57965600.0 |
| 2000-11-14 15:00:00 | AAPL | Stock | 0.3583 | 0.3661 | 0.3583 | 0.3594 | 79559200.0 |
| 2000-11-14 16:00:00 | AAPL | Stock | 0.3616 | 0.3638 | 0.3588 | 0.3616 | 16648800.0 |
| 2000-11-14 17:00:00 | AAPL | Stock | 0.3616 | 0.365 | 0.3616 | 0.365 | 268800.0 |
| 2000-11-14 08:00:00 | MSFT | Stock | 33.2344 | 33.8125 | 33.2344 | 33.7812 | 596800.0 |
| 2000-11-14 09:00:00 | MSFT | Stock | 33.8125 | 34.1875 | 33.75 | 33.8438 | 10561800.0 |
| 2000-11-14 10:00:00 | MSFT | Stock | 33.8125 | 34.2812 | 33.7188 | 34.1875 | 9353200.0 |
| 2000-11-14 11:00:00 | MSFT | Stock | 34.1875 | 34.25 | 33.6562 | 33.875 | 7500400.0 |
| 2000-11-14 12:00:00 | MSFT | Stock | 33.875 | 34.6875 | 33.8438 | 34.2812 | 8970400.0 |
| 2000-11-14 13:00:00 | MSFT | Stock | 34.2812 | 34.875 | 34.1875 | 34.7188 | 10566200.0 |
| 2000-11-14 14:00:00 | MSFT | Stock | 34.7188 | 34.9062 | 34.625 | 34.8125 | 10016400.0 |
| 2000-11-14 15:00:00 | MSFT | Stock | 34.8125 | 34.9062 | 34.1562 | 34.4062 | 16132400.0 |
| 2000-11-14 16:00:00 | MSFT | Stock | 34.4062 | 34.75 | 34.4062 | 34.625 | 2247600.0 |
| 2000-11-14 17:00:00 | MSFT | Stock | 34.6875 | 34.8125 | 34.625 | 34.625 | 10800.0 |
| 2000-11-14 18:00:00 | MSFT | Stock | 34.75 | 34.75 | 34.7188 | 34.75 | 2400.0 |
| 2000-11-14 08:00:00 | NVDA | Stock | 0.2542 | 0.2563 | 0.2542 | 0.2563 | 240000.0 |
| 2000-11-14 09:00:00 | NVDA | Stock | 0.2667 | 0.2701 | 0.2568 | 0.2664 | 54624000.0 |
| 2000-11-14 10:00:00 | NVDA | Stock | 0.2651 | 0.275 | 0.2646 | 0.2714 | 95376000.0 |
| 2000-11-14 11:00:00 | NVDA | Stock | 0.2711 | 0.2727 | 0.268 | 0.2701 | 48312000.0 |
| 2000-11-14 12:00:00 | NVDA | Stock | 0.2701 | 0.2771 | 0.2695 | 0.2714 | 41376000.0 |
| 2000-11-14 13:00:00 | NVDA | Stock | 0.2714 | 0.2755 | 0.2706 | 0.275 | 33816000.0 |
| 2000-11-14 14:00:00 | NVDA | Stock | 0.2759 | 0.2844 | 0.274 | 0.2833 | 60768000.0 |
| 2000-11-14 15:00:00 | NVDA | Stock | 0.2823 | 0.2932 | 0.2773 | 0.2911 | 96240000.0 |
| 2000-11-14 16:00:00 | NVDA | Stock | 0.2909 | 0.2911 | 0.2875 | 0.2911 | 5208000.0 |
| 2000-11-14 17:00:00 | NVDA | Stock | 0.2917 | 0.2917 | 0.2917 | 0.2917 | 72000.0 |
| 2000-11-14 08:00:00 | AMZN | Stock | 1.3938 | 1.425 | 1.3594 | 1.425 | 696000.0 |
| 2000-11-14 09:00:00 | AMZN | Stock | 1.425 | 1.4562 | 1.2875 | 1.3531 | 32110000.0 |
| 2000-11-14 10:00:00 | AMZN | Stock | 1.3563 | 1.4656 | 1.35 | 1.4531 | 35600000.0 |
| 2000-11-14 11:00:00 | AMZN | Stock | 1.45 | 1.4594 | 1.4031 | 1.4156 | 16080000.0 |
| 2000-11-14 12:00:00 | AMZN | Stock | 1.4156 | 1.4406 | 1.4062 | 1.4188 | 11382000.0 |
| 2000-11-14 13:00:00 | AMZN | Stock | 1.4219 | 1.4406 | 1.4 | 1.4406 | 7706000.0 |
| 2000-11-14 14:00:00 | AMZN | Stock | 1.4375 | 1.4938 | 1.4375 | 1.45 | 17622000.0 |
| 2000-11-14 15:00:00 | AMZN | Stock | 1.4531 | 1.4594 | 1.4313 | 1.45 | 17966000.0 |
| 2000-11-14 16:00:00 | AMZN | Stock | 1.45 | 1.4781 | 1.4406 | 1.4469 | 2502000.0 |
| 2000-11-14 17:00:00 | AMZN | Stock | 1.45 | 1.45 | 1.4484 | 1.4484 | 48000.0 |
| 2000-11-14 18:00:00 | AMZN | Stock | 1.45 | 1.4625 | 1.45 | 1.4625 | 28000.0 |
| 2000-11-14 09:00:00 | CL | Stock | 29.5 | 29.5 | 29.095 | 29.095 | 390400.0 |
| 2000-11-14 10:00:00 | CL | Stock | 29.09 | 29.15 | 28.69 | 28.77 | 575600.0 |
| 2000-11-14 11:00:00 | CL | Stock | 28.77 | 29.15 | 28.675 | 29.115 | 533400.0 |
| 2000-11-14 12:00:00 | CL | Stock | 29.115 | 29.275 | 29.085 | 29.175 | 331200.0 |
| 2000-11-14 13:00:00 | CL | Stock | 29.17 | 29.32 | 29.14 | 29.3 | 324600.0 |
| 2000-11-14 14:00:00 | CL | Stock | 29.325 | 29.625 | 29.275 | 29.5 | 723200.0 |
| 2000-11-14 15:00:00 | CL | Stock | 29.475 | 29.525 | 29.35 | 29.43 | 491800.0 |
| 2000-11-14 16:00:00 | CL | Stock | 29.43 | 29.435 | 29.42 | 29.42 | 159000.0 |
> showing 50 of 15,989 rows — these rows as CSV