PREVIEW / stock_1hour / 2002-02-26
file: by_date/stock_1hour/2002/2002-02-26.parquet size: 383 KB rows: 18,339 symbols: 1,399
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 |
|---|---|---|---|---|---|---|---|
| 2002-02-26 09:00:00 | AAPL | Stock | 0.4271 | 0.4352 | 0.4261 | 0.4339 | 42011200.0 |
| 2002-02-26 10:00:00 | AAPL | Stock | 0.4339 | 0.4341 | 0.4207 | 0.4275 | 62692000.0 |
| 2002-02-26 11:00:00 | AAPL | Stock | 0.4275 | 0.4286 | 0.4171 | 0.4196 | 26006400.0 |
| 2002-02-26 12:00:00 | AAPL | Stock | 0.4196 | 0.4241 | 0.4179 | 0.4207 | 20417600.0 |
| 2002-02-26 13:00:00 | AAPL | Stock | 0.4211 | 0.4241 | 0.4195 | 0.4195 | 13445600.0 |
| 2002-02-26 14:00:00 | AAPL | Stock | 0.4196 | 0.4277 | 0.4152 | 0.4275 | 34288800.0 |
| 2002-02-26 15:00:00 | AAPL | Stock | 0.4277 | 0.4305 | 0.4223 | 0.4225 | 49677600.0 |
| 2002-02-26 16:00:00 | AAPL | Stock | 0.4225 | 0.4246 | 0.4223 | 0.4227 | 4211200.0 |
| 2002-02-26 08:00:00 | MSFT | Stock | 29.65 | 29.7005 | 29.56 | 29.675 | 83600.0 |
| 2002-02-26 09:00:00 | MSFT | Stock | 29.675 | 30.0 | 29.45 | 29.97 | 6821600.0 |
| 2002-02-26 10:00:00 | MSFT | Stock | 29.9355 | 29.965 | 29.225 | 29.54 | 15184600.0 |
| 2002-02-26 11:00:00 | MSFT | Stock | 29.545 | 29.555 | 29.0 | 29.025 | 7995000.0 |
| 2002-02-26 12:00:00 | MSFT | Stock | 29.025 | 29.34 | 29.0 | 29.2545 | 6444200.0 |
| 2002-02-26 13:00:00 | MSFT | Stock | 29.25 | 29.35 | 29.07 | 29.09 | 4000400.0 |
| 2002-02-26 14:00:00 | MSFT | Stock | 29.09 | 29.265 | 28.95 | 29.255 | 7857600.0 |
| 2002-02-26 15:00:00 | MSFT | Stock | 29.255 | 29.665 | 29.215 | 29.275 | 11218200.0 |
| 2002-02-26 16:00:00 | MSFT | Stock | 29.28 | 29.7182 | 29.265 | 29.275 | 1948000.0 |
| 2002-02-26 17:00:00 | MSFT | Stock | 29.265 | 29.325 | 29.26 | 29.28 | 3000.0 |
| 2002-02-26 18:00:00 | MSFT | Stock | 29.275 | 29.31 | 29.275 | 29.28 | 2600.0 |
| 2002-02-26 08:00:00 | NVDA | Stock | 0.4525 | 0.4549 | 0.4508 | 0.4525 | 1308000.0 |
| 2002-02-26 09:00:00 | NVDA | Stock | 0.4537 | 0.4625 | 0.4512 | 0.4578 | 358908000.0 |
| 2002-02-26 10:00:00 | NVDA | Stock | 0.4577 | 0.4662 | 0.4462 | 0.4621 | 550104000.0 |
| 2002-02-26 11:00:00 | NVDA | Stock | 0.4621 | 0.4625 | 0.4529 | 0.4532 | 253236000.0 |
| 2002-02-26 12:00:00 | NVDA | Stock | 0.4532 | 0.4602 | 0.4522 | 0.4575 | 150396000.0 |
| 2002-02-26 13:00:00 | NVDA | Stock | 0.4572 | 0.4611 | 0.4543 | 0.4583 | 135432000.0 |
| 2002-02-26 14:00:00 | NVDA | Stock | 0.4584 | 0.4608 | 0.455 | 0.4603 | 135960000.0 |
| 2002-02-26 15:00:00 | NVDA | Stock | 0.4604 | 0.4638 | 0.4562 | 0.4584 | 223320000.0 |
| 2002-02-26 16:00:00 | NVDA | Stock | 0.4585 | 0.4591 | 0.4571 | 0.4577 | 19788000.0 |
| 2002-02-26 17:00:00 | NVDA | Stock | 0.4572 | 0.4579 | 0.4572 | 0.4577 | 384000.0 |
| 2002-02-26 18:00:00 | NVDA | Stock | 0.4576 | 0.4583 | 0.4572 | 0.4583 | 468000.0 |
| 2002-02-26 08:00:00 | AMZN | Stock | 0.696 | 0.696 | 0.686 | 0.686 | 152000.0 |
| 2002-02-26 09:00:00 | AMZN | Stock | 0.6885 | 0.7025 | 0.6705 | 0.694 | 25046000.0 |
| 2002-02-26 10:00:00 | AMZN | Stock | 0.6945 | 0.6985 | 0.6725 | 0.693 | 26602000.0 |
| 2002-02-26 11:00:00 | AMZN | Stock | 0.692 | 0.6965 | 0.6875 | 0.695 | 10800000.0 |
| 2002-02-26 12:00:00 | AMZN | Stock | 0.695 | 0.704 | 0.69 | 0.6965 | 15810000.0 |
| 2002-02-26 13:00:00 | AMZN | Stock | 0.698 | 0.7045 | 0.6945 | 0.7025 | 10092000.0 |
| 2002-02-26 14:00:00 | AMZN | Stock | 0.7 | 0.702 | 0.694 | 0.701 | 17392000.0 |
| 2002-02-26 15:00:00 | AMZN | Stock | 0.702 | 0.7245 | 0.699 | 0.7245 | 52508000.0 |
| 2002-02-26 16:00:00 | AMZN | Stock | 0.7195 | 0.725 | 0.7055 | 0.717 | 4506000.0 |
| 2002-02-26 17:00:00 | AMZN | Stock | 0.72 | 0.72 | 0.7185 | 0.7185 | 82000.0 |
| 2002-02-26 18:00:00 | AMZN | Stock | 0.7175 | 0.7175 | 0.7175 | 0.7175 | 20000.0 |
| 2002-02-26 09:00:00 | CL | Stock | 28.475 | 28.48 | 28.26 | 28.29 | 272600.0 |
| 2002-02-26 10:00:00 | CL | Stock | 28.29 | 28.375 | 28.11 | 28.205 | 323400.0 |
| 2002-02-26 11:00:00 | CL | Stock | 28.205 | 28.295 | 28.05 | 28.215 | 244200.0 |
| 2002-02-26 12:00:00 | CL | Stock | 28.2 | 28.265 | 28.055 | 28.08 | 409000.0 |
| 2002-02-26 13:00:00 | CL | Stock | 28.08 | 28.27 | 28.02 | 28.25 | 428800.0 |
| 2002-02-26 14:00:00 | CL | Stock | 28.25 | 28.375 | 28.19 | 28.35 | 272400.0 |
| 2002-02-26 15:00:00 | CL | Stock | 28.35 | 28.435 | 28.295 | 28.315 | 591200.0 |
| 2002-02-26 16:00:00 | CL | Stock | 28.325 | 28.325 | 28.235 | 28.235 | 323800.0 |
> showing 49 of 18,339 rows — these rows as CSV