PREVIEW / stock_1hour / 2002-04-08
file: by_date/stock_1hour/2002/2002-04-08.parquet size: 401 KB rows: 18,745 symbols: 1,401
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-04-08 08:00:00 | AAPL | Stock | 0.4377 | 0.4377 | 0.4377 | 0.4377 | 11200.0 |
| 2002-04-08 09:00:00 | AAPL | Stock | 0.4336 | 0.4348 | 0.4259 | 0.4275 | 30559200.0 |
| 2002-04-08 10:00:00 | AAPL | Stock | 0.4275 | 0.4346 | 0.4246 | 0.4293 | 47381600.0 |
| 2002-04-08 11:00:00 | AAPL | Stock | 0.4295 | 0.4304 | 0.4259 | 0.4259 | 21481600.0 |
| 2002-04-08 12:00:00 | AAPL | Stock | 0.4261 | 0.4277 | 0.4246 | 0.4261 | 23279200.0 |
| 2002-04-08 13:00:00 | AAPL | Stock | 0.4264 | 0.4395 | 0.4264 | 0.4321 | 39720800.0 |
| 2002-04-08 14:00:00 | AAPL | Stock | 0.4321 | 0.4368 | 0.4321 | 0.4365 | 23749600.0 |
| 2002-04-08 15:00:00 | AAPL | Stock | 0.4364 | 0.4407 | 0.4334 | 0.4388 | 43444800.0 |
| 2002-04-08 16:00:00 | AAPL | Stock | 0.4389 | 0.4455 | 0.4271 | 0.442 | 6714400.0 |
| 2002-04-08 17:00:00 | AAPL | Stock | 0.4386 | 0.442 | 0.435 | 0.4386 | 2228800.0 |
| 2002-04-08 18:00:00 | AAPL | Stock | 0.442 | 0.442 | 0.442 | 0.442 | 112000.0 |
| 2002-04-08 08:00:00 | MSFT | Stock | 27.9475 | 28.075 | 26.625 | 27.075 | 307400.0 |
| 2002-04-08 09:00:00 | MSFT | Stock | 27.07 | 27.465 | 26.9 | 27.4605 | 10569200.0 |
| 2002-04-08 10:00:00 | MSFT | Stock | 27.46 | 27.49 | 27.1895 | 27.275 | 13252000.0 |
| 2002-04-08 11:00:00 | MSFT | Stock | 27.275 | 27.485 | 27.225 | 27.485 | 4732000.0 |
| 2002-04-08 12:00:00 | MSFT | Stock | 27.475 | 27.555 | 27.375 | 27.54 | 5205600.0 |
| 2002-04-08 13:00:00 | MSFT | Stock | 27.54 | 28.08 | 27.535 | 28.08 | 10334000.0 |
| 2002-04-08 14:00:00 | MSFT | Stock | 28.08 | 28.495 | 28.055 | 28.41 | 10318800.0 |
| 2002-04-08 15:00:00 | MSFT | Stock | 28.41 | 28.656 | 28.325 | 28.62 | 12493800.0 |
| 2002-04-08 16:00:00 | MSFT | Stock | 28.605 | 28.685 | 27.19 | 28.67 | 1510800.0 |
| 2002-04-08 17:00:00 | MSFT | Stock | 28.65 | 28.7 | 27.155 | 28.66 | 317800.0 |
| 2002-04-08 18:00:00 | MSFT | Stock | 28.685 | 28.685 | 28.64 | 28.64 | 2400.0 |
| 2002-04-08 08:00:00 | NVDA | Stock | 0.3493 | 0.3499 | 0.3352 | 0.3375 | 3408000.0 |
| 2002-04-08 09:00:00 | NVDA | Stock | 0.3375 | 0.3445 | 0.3345 | 0.3402 | 173028000.0 |
| 2002-04-08 10:00:00 | NVDA | Stock | 0.3402 | 0.3441 | 0.3378 | 0.3432 | 140604000.0 |
| 2002-04-08 11:00:00 | NVDA | Stock | 0.3433 | 0.3541 | 0.3427 | 0.3529 | 175680000.0 |
| 2002-04-08 12:00:00 | NVDA | Stock | 0.3527 | 0.3537 | 0.3482 | 0.3521 | 105996000.0 |
| 2002-04-08 13:00:00 | NVDA | Stock | 0.3517 | 0.3583 | 0.3517 | 0.3566 | 125220000.0 |
| 2002-04-08 14:00:00 | NVDA | Stock | 0.3566 | 0.3625 | 0.3544 | 0.3567 | 188844000.0 |
| 2002-04-08 15:00:00 | NVDA | Stock | 0.3567 | 0.3626 | 0.3536 | 0.3622 | 162252000.0 |
| 2002-04-08 16:00:00 | NVDA | Stock | 0.3625 | 0.3632 | 0.3546 | 0.3631 | 19608000.0 |
| 2002-04-08 17:00:00 | NVDA | Stock | 0.3346 | 0.3636 | 0.3346 | 0.3636 | 1656000.0 |
| 2002-04-08 18:00:00 | NVDA | Stock | 0.3637 | 0.3642 | 0.3637 | 0.3642 | 300000.0 |
| 2002-04-08 08:00:00 | AMZN | Stock | 0.6695 | 0.67 | 0.6555 | 0.6555 | 40000.0 |
| 2002-04-08 09:00:00 | AMZN | Stock | 0.6585 | 0.6695 | 0.6475 | 0.663 | 15250000.0 |
| 2002-04-08 10:00:00 | AMZN | Stock | 0.663 | 0.665 | 0.6545 | 0.657 | 17864000.0 |
| 2002-04-08 11:00:00 | AMZN | Stock | 0.6575 | 0.6665 | 0.655 | 0.6645 | 11120000.0 |
| 2002-04-08 12:00:00 | AMZN | Stock | 0.664 | 0.675 | 0.6596 | 0.671 | 8386000.0 |
| 2002-04-08 13:00:00 | AMZN | Stock | 0.671 | 0.6825 | 0.6701 | 0.681 | 11880000.0 |
| 2002-04-08 14:00:00 | AMZN | Stock | 0.6815 | 0.6865 | 0.681 | 0.686 | 11456000.0 |
| 2002-04-08 15:00:00 | AMZN | Stock | 0.685 | 0.698 | 0.6807 | 0.698 | 19134000.0 |
| 2002-04-08 16:00:00 | AMZN | Stock | 0.6951 | 0.699 | 0.6945 | 0.698 | 4266000.0 |
| 2002-04-08 17:00:00 | AMZN | Stock | 0.684 | 0.698 | 0.684 | 0.6975 | 534000.0 |
| 2002-04-08 18:00:00 | AMZN | Stock | 0.698 | 0.698 | 0.685 | 0.6875 | 826000.0 |
| 2002-04-08 09:00:00 | CL | Stock | 28.575 | 28.725 | 28.53 | 28.675 | 138400.0 |
| 2002-04-08 10:00:00 | CL | Stock | 28.68 | 28.8 | 28.67 | 28.775 | 409600.0 |
| 2002-04-08 11:00:00 | CL | Stock | 28.76 | 28.8 | 28.74 | 28.785 | 216200.0 |
| 2002-04-08 12:00:00 | CL | Stock | 28.795 | 28.795 | 28.625 | 28.67 | 182600.0 |
| 2002-04-08 13:00:00 | CL | Stock | 28.7 | 28.725 | 28.56 | 28.635 | 152400.0 |
| 2002-04-08 14:00:00 | CL | Stock | 28.64 | 28.715 | 28.6 | 28.615 | 184600.0 |
> showing 50 of 18,745 rows — these rows as CSV