PREVIEW / stock_1hour / 2001-12-05
file: by_date/stock_1hour/2001/2001-12-05.parquet size: 392 KB rows: 18,860 symbols: 1,366
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-05 08:00:00 | AAPL | Stock | 0.4 | 0.4009 | 0.4 | 0.4009 | 369600.0 |
| 2001-12-05 09:00:00 | AAPL | Stock | 0.4002 | 0.4063 | 0.3959 | 0.4022 | 59343200.0 |
| 2001-12-05 10:00:00 | AAPL | Stock | 0.402 | 0.4148 | 0.4011 | 0.4116 | 90171200.0 |
| 2001-12-05 11:00:00 | AAPL | Stock | 0.4114 | 0.4207 | 0.4113 | 0.4148 | 71528800.0 |
| 2001-12-05 12:00:00 | AAPL | Stock | 0.415 | 0.4238 | 0.415 | 0.423 | 77134400.0 |
| 2001-12-05 13:00:00 | AAPL | Stock | 0.423 | 0.4241 | 0.417 | 0.4175 | 68504800.0 |
| 2001-12-05 14:00:00 | AAPL | Stock | 0.4173 | 0.4254 | 0.4161 | 0.425 | 45175200.0 |
| 2001-12-05 15:00:00 | AAPL | Stock | 0.4245 | 0.4286 | 0.4196 | 0.4241 | 95519200.0 |
| 2001-12-05 16:00:00 | AAPL | Stock | 0.4241 | 0.4246 | 0.4196 | 0.4245 | 24276000.0 |
| 2001-12-05 17:00:00 | AAPL | Stock | 0.4252 | 0.4252 | 0.4214 | 0.4214 | 151200.0 |
| 2001-12-05 08:00:00 | MSFT | Stock | 33.125 | 33.495 | 32.97 | 33.375 | 168800.0 |
| 2001-12-05 09:00:00 | MSFT | Stock | 33.385 | 33.52 | 33.1055 | 33.465 | 8887400.0 |
| 2001-12-05 10:00:00 | MSFT | Stock | 33.47 | 33.875 | 33.41 | 33.8245 | 14131200.0 |
| 2001-12-05 11:00:00 | MSFT | Stock | 33.825 | 33.93 | 33.65 | 33.835 | 9406800.0 |
| 2001-12-05 12:00:00 | MSFT | Stock | 33.84 | 33.995 | 33.83 | 33.845 | 5274600.0 |
| 2001-12-05 13:00:00 | MSFT | Stock | 33.85 | 33.935 | 33.63 | 33.6545 | 5043800.0 |
| 2001-12-05 14:00:00 | MSFT | Stock | 33.65 | 34.02 | 33.54 | 33.95 | 7886800.0 |
| 2001-12-05 15:00:00 | MSFT | Stock | 33.95 | 34.085 | 33.855 | 34.05 | 16624400.0 |
| 2001-12-05 16:00:00 | MSFT | Stock | 34.05 | 34.145 | 33.25 | 34.085 | 5764200.0 |
| 2001-12-05 17:00:00 | MSFT | Stock | 34.075 | 34.085 | 33.25 | 34.06 | 27000.0 |
| 2001-12-05 18:00:00 | MSFT | Stock | 34.06 | 34.06 | 34.04 | 34.04 | 7400.0 |
| 2001-12-05 08:00:00 | NVDA | Stock | 0.4842 | 0.4917 | 0.4842 | 0.49 | 4056000.0 |
| 2001-12-05 09:00:00 | NVDA | Stock | 0.4908 | 0.4964 | 0.4852 | 0.4926 | 327312000.0 |
| 2001-12-05 10:00:00 | NVDA | Stock | 0.4921 | 0.5017 | 0.4921 | 0.5003 | 388476000.0 |
| 2001-12-05 11:00:00 | NVDA | Stock | 0.5004 | 0.5083 | 0.4988 | 0.5055 | 173724000.0 |
| 2001-12-05 12:00:00 | NVDA | Stock | 0.5055 | 0.5179 | 0.5055 | 0.5132 | 224184000.0 |
| 2001-12-05 13:00:00 | NVDA | Stock | 0.5132 | 0.5161 | 0.5116 | 0.5135 | 90624000.0 |
| 2001-12-05 14:00:00 | NVDA | Stock | 0.5141 | 0.5197 | 0.509 | 0.5171 | 145968000.0 |
| 2001-12-05 15:00:00 | NVDA | Stock | 0.5172 | 0.5246 | 0.5142 | 0.5236 | 253632000.0 |
| 2001-12-05 16:00:00 | NVDA | Stock | 0.5235 | 0.525 | 0.5055 | 0.5229 | 60996000.0 |
| 2001-12-05 17:00:00 | NVDA | Stock | 0.5234 | 0.5237 | 0.5227 | 0.5233 | 528000.0 |
| 2001-12-05 18:00:00 | NVDA | Stock | 0.5233 | 0.5233 | 0.5229 | 0.5233 | 96000.0 |
| 2001-12-05 08:00:00 | AMZN | Stock | 0.5995 | 0.6225 | 0.5995 | 0.6205 | 2118000.0 |
| 2001-12-05 09:00:00 | AMZN | Stock | 0.621 | 0.64 | 0.6175 | 0.6225 | 143680000.0 |
| 2001-12-05 10:00:00 | AMZN | Stock | 0.6235 | 0.636 | 0.6205 | 0.6255 | 81300000.0 |
| 2001-12-05 11:00:00 | AMZN | Stock | 0.6255 | 0.632 | 0.611 | 0.6175 | 47662000.0 |
| 2001-12-05 12:00:00 | AMZN | Stock | 0.6155 | 0.626 | 0.6135 | 0.6155 | 32568000.0 |
| 2001-12-05 13:00:00 | AMZN | Stock | 0.615 | 0.6185 | 0.5975 | 0.6015 | 34090000.0 |
| 2001-12-05 14:00:00 | AMZN | Stock | 0.6005 | 0.6116 | 0.5945 | 0.609 | 44822000.0 |
| 2001-12-05 15:00:00 | AMZN | Stock | 0.609 | 0.6101 | 0.5875 | 0.588 | 44344000.0 |
| 2001-12-05 16:00:00 | AMZN | Stock | 0.5884 | 0.5944 | 0.58 | 0.585 | 11366000.0 |
| 2001-12-05 17:00:00 | AMZN | Stock | 0.58 | 0.588 | 0.5765 | 0.5785 | 844000.0 |
| 2001-12-05 18:00:00 | AMZN | Stock | 0.579 | 0.5825 | 0.579 | 0.5825 | 146000.0 |
| 2001-12-05 09:00:00 | CL | Stock | 29.01 | 29.125 | 29.0 | 29.125 | 344400.0 |
| 2001-12-05 10:00:00 | CL | Stock | 29.125 | 29.325 | 29.075 | 29.2 | 391200.0 |
| 2001-12-05 11:00:00 | CL | Stock | 29.18 | 29.4 | 29.06 | 29.11 | 504000.0 |
| 2001-12-05 12:00:00 | CL | Stock | 29.085 | 29.175 | 29.005 | 29.025 | 369600.0 |
| 2001-12-05 13:00:00 | CL | Stock | 29.025 | 29.05 | 28.9 | 28.94 | 387200.0 |
| 2001-12-05 14:00:00 | CL | Stock | 28.935 | 29.0 | 28.9 | 28.91 | 402000.0 |
| 2001-12-05 15:00:00 | CL | Stock | 28.91 | 29.025 | 28.875 | 28.97 | 874200.0 |
> showing 50 of 18,860 rows — these rows as CSV