PREVIEW / stock_1hour / 2000-11-15
file: by_date/stock_1hour/2000/2000-11-15.parquet size: 306 KB rows: 15,744 symbols: 1,235
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-15 08:00:00 | AAPL | Stock | 0.3599 | 0.3616 | 0.3594 | 0.3616 | 1052800.0 |
| 2000-11-15 09:00:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3549 | 0.3549 | 27115200.0 |
| 2000-11-15 10:00:00 | AAPL | Stock | 0.3549 | 0.3583 | 0.3516 | 0.3571 | 35179200.0 |
| 2000-11-15 11:00:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3538 | 0.3571 | 30004800.0 |
| 2000-11-15 12:00:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3538 | 0.3555 | 16116800.0 |
| 2000-11-15 13:00:00 | AAPL | Stock | 0.356 | 0.3571 | 0.3544 | 0.356 | 29288000.0 |
| 2000-11-15 14:00:00 | AAPL | Stock | 0.356 | 0.3571 | 0.3438 | 0.346 | 64472800.0 |
| 2000-11-15 15:00:00 | AAPL | Stock | 0.3482 | 0.3571 | 0.346 | 0.356 | 60356800.0 |
| 2000-11-15 16:00:00 | AAPL | Stock | 0.3549 | 0.3594 | 0.3438 | 0.3549 | 4933600.0 |
| 2000-11-15 17:00:00 | AAPL | Stock | 0.3577 | 0.3583 | 0.3571 | 0.3571 | 84000.0 |
| 2000-11-15 18:00:00 | AAPL | Stock | 0.3571 | 0.3577 | 0.3571 | 0.3577 | 72800.0 |
| 2000-11-15 08:00:00 | MSFT | Stock | 34.5 | 35.0 | 34.5 | 34.5625 | 16400.0 |
| 2000-11-15 09:00:00 | MSFT | Stock | 34.5312 | 34.875 | 34.3438 | 34.3438 | 6707600.0 |
| 2000-11-15 10:00:00 | MSFT | Stock | 34.4062 | 34.8438 | 34.375 | 34.75 | 5876400.0 |
| 2000-11-15 11:00:00 | MSFT | Stock | 34.7812 | 35.1875 | 34.6875 | 35.125 | 7689600.0 |
| 2000-11-15 12:00:00 | MSFT | Stock | 35.0938 | 35.25 | 34.9375 | 35.2188 | 5685200.0 |
| 2000-11-15 13:00:00 | MSFT | Stock | 35.1875 | 35.4375 | 35.125 | 35.25 | 7215800.0 |
| 2000-11-15 14:00:00 | MSFT | Stock | 35.25 | 35.4062 | 34.5 | 34.5938 | 11592600.0 |
| 2000-11-15 15:00:00 | MSFT | Stock | 34.5625 | 35.1094 | 34.375 | 35.0625 | 9938600.0 |
| 2000-11-15 16:00:00 | MSFT | Stock | 35.0625 | 35.125 | 34.7812 | 35.0156 | 2397400.0 |
| 2000-11-15 17:00:00 | MSFT | Stock | 34.9375 | 35.0312 | 34.9062 | 34.9062 | 235000.0 |
| 2000-11-15 18:00:00 | MSFT | Stock | 34.9688 | 34.9688 | 34.9688 | 34.9688 | 1200.0 |
| 2000-11-15 09:00:00 | NVDA | Stock | 0.2833 | 0.2892 | 0.2792 | 0.2802 | 37512000.0 |
| 2000-11-15 10:00:00 | NVDA | Stock | 0.2805 | 0.287 | 0.2742 | 0.2835 | 46656000.0 |
| 2000-11-15 11:00:00 | NVDA | Stock | 0.2844 | 0.2878 | 0.2823 | 0.2833 | 14592000.0 |
| 2000-11-15 12:00:00 | NVDA | Stock | 0.2839 | 0.2906 | 0.2836 | 0.2898 | 26832000.0 |
| 2000-11-15 13:00:00 | NVDA | Stock | 0.2898 | 0.2951 | 0.287 | 0.293 | 50520000.0 |
| 2000-11-15 14:00:00 | NVDA | Stock | 0.293 | 0.2935 | 0.2833 | 0.2846 | 70800000.0 |
| 2000-11-15 15:00:00 | NVDA | Stock | 0.2846 | 0.2896 | 0.276 | 0.288 | 151488000.0 |
| 2000-11-15 16:00:00 | NVDA | Stock | 0.2872 | 0.288 | 0.2865 | 0.2875 | 6696000.0 |
| 2000-11-15 17:00:00 | NVDA | Stock | 0.2872 | 0.2872 | 0.2872 | 0.2872 | 1632000.0 |
| 2000-11-15 08:00:00 | AMZN | Stock | 1.4125 | 1.4625 | 1.4125 | 1.4594 | 32000.0 |
| 2000-11-15 09:00:00 | AMZN | Stock | 1.4594 | 1.5125 | 1.4219 | 1.4688 | 16242000.0 |
| 2000-11-15 10:00:00 | AMZN | Stock | 1.4688 | 1.5031 | 1.4531 | 1.4938 | 10580000.0 |
| 2000-11-15 11:00:00 | AMZN | Stock | 1.4969 | 1.5062 | 1.4813 | 1.4938 | 7484000.0 |
| 2000-11-15 12:00:00 | AMZN | Stock | 1.4938 | 1.5062 | 1.4906 | 1.5031 | 5098000.0 |
| 2000-11-15 13:00:00 | AMZN | Stock | 1.5031 | 1.5406 | 1.5 | 1.5156 | 12232000.0 |
| 2000-11-15 14:00:00 | AMZN | Stock | 1.5125 | 1.5375 | 1.475 | 1.4875 | 18066000.0 |
| 2000-11-15 15:00:00 | AMZN | Stock | 1.4875 | 1.4938 | 1.4406 | 1.4719 | 28586000.0 |
| 2000-11-15 16:00:00 | AMZN | Stock | 1.4781 | 1.4813 | 1.4438 | 1.4813 | 2106000.0 |
| 2000-11-15 17:00:00 | AMZN | Stock | 1.4813 | 1.4875 | 1.4531 | 1.4781 | 54000.0 |
| 2000-11-15 18:00:00 | AMZN | Stock | 1.475 | 1.475 | 1.4688 | 1.4688 | 4000.0 |
| 2000-11-15 09:00:00 | CL | Stock | 29.75 | 29.775 | 29.575 | 29.625 | 154000.0 |
| 2000-11-15 10:00:00 | CL | Stock | 29.685 | 29.75 | 29.475 | 29.68 | 417400.0 |
| 2000-11-15 11:00:00 | CL | Stock | 29.68 | 29.89 | 29.555 | 29.8 | 381200.0 |
| 2000-11-15 12:00:00 | CL | Stock | 29.8 | 29.925 | 29.63 | 29.65 | 274400.0 |
| 2000-11-15 13:00:00 | CL | Stock | 29.665 | 29.675 | 29.565 | 29.65 | 366400.0 |
| 2000-11-15 14:00:00 | CL | Stock | 29.66 | 29.825 | 29.625 | 29.7 | 241800.0 |
| 2000-11-15 15:00:00 | CL | Stock | 29.72 | 29.9 | 29.575 | 29.81 | 589000.0 |
| 2000-11-15 16:00:00 | CL | Stock | 29.805 | 29.81 | 29.715 | 29.715 | 134400.0 |
> showing 50 of 15,744 rows — these rows as CSV