PREVIEW / stock_1hour / 2000-01-03
file: by_date/stock_1hour/2000/2000-01-03.parquet size: 279 KB rows: 14,448 symbols: 1,125
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-01-03 09:00:00 | AAPL | Stock | 0.9364 | 0.9408 | 0.9208 | 0.9238 | 74244800.0 |
| 2000-01-03 10:00:00 | AAPL | Stock | 0.9235 | 0.9464 | 0.9079 | 0.9096 | 78500800.0 |
| 2000-01-03 11:00:00 | AAPL | Stock | 0.9118 | 0.9308 | 0.9107 | 0.928 | 41126400.0 |
| 2000-01-03 12:00:00 | AAPL | Stock | 0.9286 | 0.9414 | 0.9252 | 0.9397 | 42504000.0 |
| 2000-01-03 13:00:00 | AAPL | Stock | 0.9403 | 0.9961 | 0.9397 | 0.9771 | 110611200.0 |
| 2000-01-03 14:00:00 | AAPL | Stock | 0.9777 | 0.9894 | 0.9715 | 0.9799 | 52774400.0 |
| 2000-01-03 15:00:00 | AAPL | Stock | 0.9799 | 1.0045 | 0.9665 | 1.0 | 99545600.0 |
| 2000-01-03 16:00:00 | AAPL | Stock | 0.9994 | 1.0 | 0.9989 | 0.9994 | 1556800.0 |
| 2000-01-03 09:00:00 | MSFT | Stock | 58.6875 | 59.3125 | 58.4688 | 59.125 | 9675200.0 |
| 2000-01-03 10:00:00 | MSFT | Stock | 59.125 | 59.2812 | 57.0625 | 57.25 | 11356600.0 |
| 2000-01-03 11:00:00 | MSFT | Stock | 57.25 | 57.5625 | 56.0 | 57.5312 | 10088000.0 |
| 2000-01-03 12:00:00 | MSFT | Stock | 57.5312 | 57.625 | 57.125 | 57.3438 | 3735200.0 |
| 2000-01-03 13:00:00 | MSFT | Stock | 57.3438 | 57.9688 | 57.1875 | 57.8594 | 4026400.0 |
| 2000-01-03 14:00:00 | MSFT | Stock | 57.8438 | 57.9375 | 57.2188 | 57.5 | 4265000.0 |
| 2000-01-03 15:00:00 | MSFT | Stock | 57.4688 | 58.3438 | 57.4375 | 58.25 | 5833600.0 |
| 2000-01-03 16:00:00 | MSFT | Stock | 58.2812 | 58.2812 | 58.25 | 58.2812 | 534600.0 |
| 2000-01-03 09:00:00 | NVDA | Stock | 0.0984 | 0.099 | 0.0947 | 0.0957 | 28224000.0 |
| 2000-01-03 10:00:00 | NVDA | Stock | 0.0949 | 0.0958 | 0.0919 | 0.0928 | 53232000.0 |
| 2000-01-03 11:00:00 | NVDA | Stock | 0.0934 | 0.0947 | 0.0923 | 0.0947 | 22224000.0 |
| 2000-01-03 12:00:00 | NVDA | Stock | 0.094 | 0.0964 | 0.094 | 0.0949 | 29232000.0 |
| 2000-01-03 13:00:00 | NVDA | Stock | 0.0956 | 0.0958 | 0.0949 | 0.0951 | 6720000.0 |
| 2000-01-03 14:00:00 | NVDA | Stock | 0.0953 | 0.0979 | 0.0953 | 0.0966 | 31440000.0 |
| 2000-01-03 15:00:00 | NVDA | Stock | 0.0969 | 0.0978 | 0.0961 | 0.0975 | 80208000.0 |
| 2000-01-03 16:00:00 | NVDA | Stock | 0.0975 | 0.0975 | 0.0975 | 0.0975 | 336000.0 |
| 2000-01-03 09:00:00 | AMZN | Stock | 4.075 | 4.1344 | 4.025 | 4.0391 | 47446000.0 |
| 2000-01-03 10:00:00 | AMZN | Stock | 4.0406 | 4.0812 | 3.975 | 3.9875 | 54402000.0 |
| 2000-01-03 11:00:00 | AMZN | Stock | 3.9844 | 4.0625 | 3.975 | 4.0438 | 31394000.0 |
| 2000-01-03 12:00:00 | AMZN | Stock | 4.0375 | 4.05 | 4.0031 | 4.0375 | 14254000.0 |
| 2000-01-03 13:00:00 | AMZN | Stock | 4.0375 | 4.1844 | 4.025 | 4.1469 | 37160000.0 |
| 2000-01-03 14:00:00 | AMZN | Stock | 4.1406 | 4.25 | 4.1313 | 4.1625 | 29256000.0 |
| 2000-01-03 15:00:00 | AMZN | Stock | 4.1625 | 4.4781 | 4.1438 | 4.4688 | 74702000.0 |
| 2000-01-03 16:00:00 | AMZN | Stock | 4.4719 | 4.4734 | 4.4656 | 4.4688 | 666000.0 |
| 2000-01-03 09:00:00 | CL | Stock | 32.0 | 32.0 | 31.625 | 31.7188 | 330000.0 |
| 2000-01-03 10:00:00 | CL | Stock | 31.625 | 31.875 | 31.0 | 31.1875 | 592800.0 |
| 2000-01-03 11:00:00 | CL | Stock | 31.1875 | 31.2812 | 31.0 | 31.125 | 271800.0 |
| 2000-01-03 12:00:00 | CL | Stock | 31.125 | 31.3125 | 31.0312 | 31.1875 | 218400.0 |
| 2000-01-03 13:00:00 | CL | Stock | 31.2188 | 31.2188 | 31.0 | 31.0 | 119200.0 |
| 2000-01-03 14:00:00 | CL | Stock | 31.0 | 31.4688 | 31.0 | 31.4688 | 431000.0 |
| 2000-01-03 15:00:00 | CL | Stock | 31.4688 | 31.4688 | 31.0 | 31.0938 | 392000.0 |
| 2000-01-03 16:00:00 | CL | Stock | 31.0938 | 31.125 | 31.0938 | 31.125 | 43800.0 |
> showing 40 of 14,448 rows — these rows as CSV