PREVIEW / stock_1hour / 2000-11-08
file: by_date/stock_1hour/2000/2000-11-08.parquet size: 303 KB rows: 15,439 symbols: 1,230
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-08 08:00:00 | AAPL | Stock | 0.375 | 0.3806 | 0.3705 | 0.3806 | 336000.0 |
| 2000-11-08 09:00:00 | AAPL | Stock | 0.3806 | 0.3828 | 0.3717 | 0.3739 | 37094400.0 |
| 2000-11-08 10:00:00 | AAPL | Stock | 0.3739 | 0.375 | 0.3571 | 0.3605 | 107620800.0 |
| 2000-11-08 11:00:00 | AAPL | Stock | 0.3594 | 0.3638 | 0.356 | 0.3616 | 65536800.0 |
| 2000-11-08 12:00:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.356 | 0.3571 | 39732000.0 |
| 2000-11-08 13:00:00 | AAPL | Stock | 0.356 | 0.3605 | 0.3538 | 0.3605 | 48311200.0 |
| 2000-11-08 14:00:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3549 | 0.3583 | 38780000.0 |
| 2000-11-08 15:00:00 | AAPL | Stock | 0.3583 | 0.3605 | 0.3538 | 0.3571 | 55983200.0 |
| 2000-11-08 16:00:00 | AAPL | Stock | 0.3571 | 0.3655 | 0.3504 | 0.3583 | 8030400.0 |
| 2000-11-08 17:00:00 | AAPL | Stock | 0.356 | 0.3583 | 0.3538 | 0.3549 | 268800.0 |
| 2000-11-08 18:00:00 | AAPL | Stock | 0.356 | 0.356 | 0.3549 | 0.3549 | 16800.0 |
| 2000-11-08 08:00:00 | MSFT | Stock | 36.4688 | 36.5 | 35.2656 | 35.9062 | 1020800.0 |
| 2000-11-08 09:00:00 | MSFT | Stock | 35.875 | 36.4375 | 35.375 | 35.75 | 35511800.0 |
| 2000-11-08 10:00:00 | MSFT | Stock | 35.75 | 35.8438 | 35.125 | 35.5625 | 29012600.0 |
| 2000-11-08 11:00:00 | MSFT | Stock | 35.5312 | 35.75 | 35.1875 | 35.4688 | 18158800.0 |
| 2000-11-08 12:00:00 | MSFT | Stock | 35.4688 | 35.5 | 34.9375 | 34.9375 | 13516600.0 |
| 2000-11-08 13:00:00 | MSFT | Stock | 34.9375 | 35.25 | 34.5 | 34.5625 | 19310400.0 |
| 2000-11-08 14:00:00 | MSFT | Stock | 34.5625 | 34.625 | 34.0 | 34.4688 | 22113400.0 |
| 2000-11-08 15:00:00 | MSFT | Stock | 34.4688 | 34.9688 | 34.0 | 34.75 | 19252000.0 |
| 2000-11-08 16:00:00 | MSFT | Stock | 34.75 | 36.1875 | 34.1562 | 34.5625 | 7191600.0 |
| 2000-11-08 17:00:00 | MSFT | Stock | 34.5625 | 35.1719 | 34.5 | 34.5625 | 174200.0 |
| 2000-11-08 18:00:00 | MSFT | Stock | 34.5312 | 34.625 | 34.5312 | 34.5625 | 4600.0 |
| 2000-11-08 08:00:00 | NVDA | Stock | 0.2983 | 0.2983 | 0.2983 | 0.2983 | 912000.0 |
| 2000-11-08 09:00:00 | NVDA | Stock | 0.3021 | 0.3021 | 0.2891 | 0.2891 | 14592000.0 |
| 2000-11-08 10:00:00 | NVDA | Stock | 0.2893 | 0.2964 | 0.288 | 0.2917 | 21696000.0 |
| 2000-11-08 11:00:00 | NVDA | Stock | 0.2914 | 0.2932 | 0.2849 | 0.2914 | 24192000.0 |
| 2000-11-08 12:00:00 | NVDA | Stock | 0.2917 | 0.2932 | 0.2901 | 0.2901 | 15480000.0 |
| 2000-11-08 13:00:00 | NVDA | Stock | 0.2904 | 0.2906 | 0.2862 | 0.2891 | 25800000.0 |
| 2000-11-08 14:00:00 | NVDA | Stock | 0.2893 | 0.2927 | 0.288 | 0.2915 | 33648000.0 |
| 2000-11-08 15:00:00 | NVDA | Stock | 0.2914 | 0.2927 | 0.288 | 0.2893 | 37392000.0 |
| 2000-11-08 16:00:00 | NVDA | Stock | 0.2891 | 0.2893 | 0.2891 | 0.2893 | 936000.0 |
| 2000-11-08 08:00:00 | AMZN | Stock | 1.8 | 1.8422 | 1.7531 | 1.8062 | 522000.0 |
| 2000-11-08 09:00:00 | AMZN | Stock | 1.8 | 1.85 | 1.7781 | 1.8188 | 11388000.0 |
| 2000-11-08 10:00:00 | AMZN | Stock | 1.8188 | 1.8312 | 1.775 | 1.7969 | 12770000.0 |
| 2000-11-08 11:00:00 | AMZN | Stock | 1.8 | 1.8 | 1.7562 | 1.7844 | 10938000.0 |
| 2000-11-08 12:00:00 | AMZN | Stock | 1.7844 | 1.7969 | 1.7594 | 1.7641 | 9706000.0 |
| 2000-11-08 13:00:00 | AMZN | Stock | 1.7641 | 1.7656 | 1.7281 | 1.7344 | 14234000.0 |
| 2000-11-08 14:00:00 | AMZN | Stock | 1.7375 | 1.7406 | 1.6625 | 1.6859 | 31096000.0 |
| 2000-11-08 15:00:00 | AMZN | Stock | 1.6938 | 1.7281 | 1.6781 | 1.6969 | 17560000.0 |
| 2000-11-08 16:00:00 | AMZN | Stock | 1.6969 | 1.7219 | 1.6938 | 1.7031 | 2010000.0 |
| 2000-11-08 17:00:00 | AMZN | Stock | 1.6938 | 1.7031 | 1.6875 | 1.7 | 234000.0 |
| 2000-11-08 18:00:00 | AMZN | Stock | 1.7031 | 1.7062 | 1.675 | 1.7062 | 64000.0 |
| 2000-11-08 09:00:00 | CL | Stock | 29.75 | 29.75 | 29.3 | 29.385 | 343800.0 |
| 2000-11-08 10:00:00 | CL | Stock | 29.425 | 29.745 | 29.3 | 29.685 | 288400.0 |
| 2000-11-08 11:00:00 | CL | Stock | 29.655 | 29.68 | 29.475 | 29.59 | 234200.0 |
| 2000-11-08 12:00:00 | CL | Stock | 29.59 | 29.595 | 29.3 | 29.305 | 205600.0 |
| 2000-11-08 13:00:00 | CL | Stock | 29.3 | 29.325 | 29.14 | 29.14 | 134000.0 |
| 2000-11-08 14:00:00 | CL | Stock | 29.145 | 29.7 | 29.14 | 29.61 | 451000.0 |
| 2000-11-08 15:00:00 | CL | Stock | 29.625 | 29.725 | 29.345 | 29.375 | 488200.0 |
| 2000-11-08 16:00:00 | CL | Stock | 29.37 | 29.555 | 29.34 | 29.555 | 67200.0 |
> showing 50 of 15,439 rows — these rows as CSV