PREVIEW / stock_1hour / 2000-06-05
file: by_date/stock_1hour/2000/2000-06-05.parquet size: 287 KB rows: 15,213 symbols: 1,177
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-06-05 08:00:00 | AAPL | Stock | 0.8125 | 0.8158 | 0.8103 | 0.8147 | 145600.0 |
| 2000-06-05 09:00:00 | AAPL | Stock | 0.8214 | 0.8449 | 0.8214 | 0.8415 | 52438400.0 |
| 2000-06-05 10:00:00 | AAPL | Stock | 0.8415 | 0.8504 | 0.8343 | 0.8471 | 70336000.0 |
| 2000-06-05 11:00:00 | AAPL | Stock | 0.8477 | 0.8482 | 0.8114 | 0.817 | 51486400.0 |
| 2000-06-05 12:00:00 | AAPL | Stock | 0.8178 | 0.8337 | 0.8175 | 0.827 | 15142400.0 |
| 2000-06-05 13:00:00 | AAPL | Stock | 0.8242 | 0.827 | 0.8069 | 0.81 | 34372800.0 |
| 2000-06-05 14:00:00 | AAPL | Stock | 0.8103 | 0.8164 | 0.8025 | 0.8164 | 34451200.0 |
| 2000-06-05 15:00:00 | AAPL | Stock | 0.817 | 0.8198 | 0.8008 | 0.8147 | 41148800.0 |
| 2000-06-05 16:00:00 | AAPL | Stock | 0.8147 | 0.8212 | 0.8147 | 0.817 | 3561600.0 |
| 2000-06-05 17:00:00 | AAPL | Stock | 0.8145 | 0.817 | 0.8142 | 0.8142 | 772800.0 |
| 2000-06-05 08:00:00 | MSFT | Stock | 33.1875 | 33.9375 | 33.0 | 33.0625 | 51000.0 |
| 2000-06-05 09:00:00 | MSFT | Stock | 33.0625 | 33.6562 | 32.9375 | 33.5625 | 8732200.0 |
| 2000-06-05 10:00:00 | MSFT | Stock | 33.5625 | 34.0 | 33.4375 | 33.875 | 10797800.0 |
| 2000-06-05 11:00:00 | MSFT | Stock | 33.875 | 33.9062 | 33.7188 | 33.8438 | 6255000.0 |
| 2000-06-05 12:00:00 | MSFT | Stock | 33.875 | 34.1875 | 33.7812 | 34.0625 | 9312800.0 |
| 2000-06-05 13:00:00 | MSFT | Stock | 34.0625 | 34.1562 | 33.8125 | 33.875 | 6016600.0 |
| 2000-06-05 14:00:00 | MSFT | Stock | 33.8438 | 33.9375 | 33.375 | 33.5938 | 9936000.0 |
| 2000-06-05 15:00:00 | MSFT | Stock | 33.5938 | 33.625 | 33.0 | 33.4375 | 11036800.0 |
| 2000-06-05 16:00:00 | MSFT | Stock | 33.4062 | 33.6719 | 33.375 | 33.4375 | 1027000.0 |
| 2000-06-05 17:00:00 | MSFT | Stock | 33.3906 | 33.4688 | 33.3438 | 33.375 | 76000.0 |
| 2000-06-05 18:00:00 | MSFT | Stock | 33.4688 | 33.4688 | 33.4688 | 33.4688 | 400.0 |
| 2000-06-05 08:00:00 | NVDA | Stock | 0.2714 | 0.2714 | 0.2708 | 0.2708 | 96000.0 |
| 2000-06-05 09:00:00 | NVDA | Stock | 0.2743 | 0.2802 | 0.2628 | 0.2802 | 54624000.0 |
| 2000-06-05 10:00:00 | NVDA | Stock | 0.2798 | 0.2937 | 0.2798 | 0.2906 | 141408000.0 |
| 2000-06-05 11:00:00 | NVDA | Stock | 0.2906 | 0.291 | 0.2823 | 0.2833 | 124128000.0 |
| 2000-06-05 12:00:00 | NVDA | Stock | 0.2833 | 0.2883 | 0.2833 | 0.2849 | 49824000.0 |
| 2000-06-05 13:00:00 | NVDA | Stock | 0.2852 | 0.2885 | 0.2833 | 0.2859 | 21408000.0 |
| 2000-06-05 14:00:00 | NVDA | Stock | 0.2865 | 0.2876 | 0.2828 | 0.2857 | 38112000.0 |
| 2000-06-05 15:00:00 | NVDA | Stock | 0.2857 | 0.2865 | 0.2771 | 0.2802 | 37872000.0 |
| 2000-06-05 16:00:00 | NVDA | Stock | 0.2802 | 0.2855 | 0.2799 | 0.2799 | 14832000.0 |
| 2000-06-05 08:00:00 | AMZN | Stock | 2.75 | 2.7812 | 2.725 | 2.7562 | 744000.0 |
| 2000-06-05 09:00:00 | AMZN | Stock | 2.7625 | 2.8125 | 2.75 | 2.7906 | 20370000.0 |
| 2000-06-05 10:00:00 | AMZN | Stock | 2.7906 | 2.8063 | 2.7188 | 2.75 | 25100000.0 |
| 2000-06-05 11:00:00 | AMZN | Stock | 2.75 | 2.7562 | 2.7125 | 2.725 | 11880000.0 |
| 2000-06-05 12:00:00 | AMZN | Stock | 2.7219 | 2.7281 | 2.6875 | 2.6875 | 7924000.0 |
| 2000-06-05 13:00:00 | AMZN | Stock | 2.6875 | 2.7094 | 2.6562 | 2.6875 | 6856000.0 |
| 2000-06-05 14:00:00 | AMZN | Stock | 2.6875 | 2.6969 | 2.6375 | 2.6594 | 21546000.0 |
| 2000-06-05 15:00:00 | AMZN | Stock | 2.6625 | 2.7375 | 2.625 | 2.725 | 35708000.0 |
| 2000-06-05 16:00:00 | AMZN | Stock | 2.7188 | 2.75 | 2.7 | 2.7219 | 3640000.0 |
| 2000-06-05 17:00:00 | AMZN | Stock | 2.7188 | 2.7359 | 2.7125 | 2.7312 | 128000.0 |
| 2000-06-05 18:00:00 | AMZN | Stock | 2.7125 | 2.7125 | 2.7125 | 2.7125 | 6000.0 |
| 2000-06-05 09:00:00 | CL | Stock | 27.3125 | 27.3125 | 27.0312 | 27.0625 | 250400.0 |
| 2000-06-05 10:00:00 | CL | Stock | 27.0625 | 27.2188 | 27.0312 | 27.125 | 376600.0 |
| 2000-06-05 11:00:00 | CL | Stock | 27.125 | 27.25 | 27.0938 | 27.1562 | 339000.0 |
| 2000-06-05 12:00:00 | CL | Stock | 27.1562 | 27.3125 | 27.0 | 27.0312 | 261000.0 |
| 2000-06-05 13:00:00 | CL | Stock | 27.0 | 27.0625 | 26.8125 | 26.8125 | 115000.0 |
| 2000-06-05 14:00:00 | CL | Stock | 26.8125 | 27.125 | 26.8125 | 26.9062 | 146200.0 |
| 2000-06-05 15:00:00 | CL | Stock | 26.9062 | 26.9375 | 26.5312 | 26.5625 | 580200.0 |
| 2000-06-05 16:00:00 | CL | Stock | 26.625 | 26.625 | 26.5312 | 26.5312 | 43800.0 |
> showing 49 of 15,213 rows — these rows as CSV