PREVIEW / stock_1hour / 2001-11-28
file: by_date/stock_1hour/2001/2001-11-28.parquet size: 376 KB rows: 17,867 symbols: 1,355
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-11-28 08:00:00 | AAPL | Stock | 0.3751 | 0.3751 | 0.3741 | 0.3741 | 481600.0 |
| 2001-11-28 09:00:00 | AAPL | Stock | 0.3732 | 0.3755 | 0.368 | 0.3709 | 26605600.0 |
| 2001-11-28 10:00:00 | AAPL | Stock | 0.3709 | 0.3745 | 0.3671 | 0.3689 | 46748800.0 |
| 2001-11-28 11:00:00 | AAPL | Stock | 0.3686 | 0.3727 | 0.3673 | 0.372 | 16060800.0 |
| 2001-11-28 12:00:00 | AAPL | Stock | 0.3721 | 0.3788 | 0.372 | 0.3721 | 52617600.0 |
| 2001-11-28 13:00:00 | AAPL | Stock | 0.3721 | 0.375 | 0.3704 | 0.3704 | 20798400.0 |
| 2001-11-28 14:00:00 | AAPL | Stock | 0.3702 | 0.3707 | 0.3655 | 0.3659 | 35128800.0 |
| 2001-11-28 15:00:00 | AAPL | Stock | 0.3657 | 0.3705 | 0.3645 | 0.3666 | 39496800.0 |
| 2001-11-28 16:00:00 | AAPL | Stock | 0.3668 | 0.3669 | 0.3646 | 0.3669 | 5213600.0 |
| 2001-11-28 17:00:00 | AAPL | Stock | 0.3655 | 0.3699 | 0.3646 | 0.3646 | 3500000.0 |
| 2001-11-28 08:00:00 | MSFT | Stock | 31.625 | 31.8725 | 31.5 | 31.585 | 81000.0 |
| 2001-11-28 09:00:00 | MSFT | Stock | 31.615 | 31.87 | 31.525 | 31.62 | 6482600.0 |
| 2001-11-28 10:00:00 | MSFT | Stock | 31.62 | 31.915 | 31.405 | 31.4805 | 10216800.0 |
| 2001-11-28 11:00:00 | MSFT | Stock | 31.485 | 32.06 | 31.47 | 31.9 | 9176000.0 |
| 2001-11-28 12:00:00 | MSFT | Stock | 31.9 | 32.03 | 31.715 | 31.805 | 4178600.0 |
| 2001-11-28 13:00:00 | MSFT | Stock | 31.7865 | 31.9255 | 31.53 | 31.64 | 5174400.0 |
| 2001-11-28 14:00:00 | MSFT | Stock | 31.655 | 31.775 | 31.435 | 31.5195 | 7030600.0 |
| 2001-11-28 15:00:00 | MSFT | Stock | 31.52 | 31.8195 | 31.365 | 31.415 | 8308200.0 |
| 2001-11-28 16:00:00 | MSFT | Stock | 31.4 | 31.6931 | 31.37 | 31.395 | 2274000.0 |
| 2001-11-28 17:00:00 | MSFT | Stock | 31.385 | 31.6836 | 31.325 | 31.35 | 1095000.0 |
| 2001-11-28 18:00:00 | MSFT | Stock | 31.305 | 31.4 | 31.305 | 31.315 | 18400.0 |
| 2001-11-28 08:00:00 | NVDA | Stock | 0.4458 | 0.45 | 0.4458 | 0.4491 | 660000.0 |
| 2001-11-28 09:00:00 | NVDA | Stock | 0.4496 | 0.4523 | 0.4433 | 0.4467 | 86976000.0 |
| 2001-11-28 10:00:00 | NVDA | Stock | 0.4456 | 0.4524 | 0.4405 | 0.4412 | 139656000.0 |
| 2001-11-28 11:00:00 | NVDA | Stock | 0.4412 | 0.4471 | 0.4408 | 0.4442 | 61776000.0 |
| 2001-11-28 12:00:00 | NVDA | Stock | 0.4445 | 0.4477 | 0.4434 | 0.444 | 48516000.0 |
| 2001-11-28 13:00:00 | NVDA | Stock | 0.4438 | 0.4442 | 0.4371 | 0.4386 | 73140000.0 |
| 2001-11-28 14:00:00 | NVDA | Stock | 0.4378 | 0.4387 | 0.427 | 0.4274 | 154440000.0 |
| 2001-11-28 15:00:00 | NVDA | Stock | 0.4274 | 0.4371 | 0.4271 | 0.428 | 133920000.0 |
| 2001-11-28 16:00:00 | NVDA | Stock | 0.428 | 0.4395 | 0.4275 | 0.4292 | 23268000.0 |
| 2001-11-28 17:00:00 | NVDA | Stock | 0.428 | 0.4667 | 0.428 | 0.4612 | 66372000.0 |
| 2001-11-28 18:00:00 | NVDA | Stock | 0.4613 | 0.4633 | 0.4592 | 0.4592 | 11988000.0 |
| 2001-11-28 08:00:00 | AMZN | Stock | 0.572 | 0.572 | 0.56 | 0.564 | 1956000.0 |
| 2001-11-28 09:00:00 | AMZN | Stock | 0.56 | 0.6176 | 0.559 | 0.615 | 98556000.0 |
| 2001-11-28 10:00:00 | AMZN | Stock | 0.6175 | 0.6175 | 0.59 | 0.591 | 166864000.0 |
| 2001-11-28 11:00:00 | AMZN | Stock | 0.59 | 0.614 | 0.59 | 0.61 | 103990000.0 |
| 2001-11-28 12:00:00 | AMZN | Stock | 0.611 | 0.6145 | 0.602 | 0.61 | 89364000.0 |
| 2001-11-28 13:00:00 | AMZN | Stock | 0.61 | 0.62 | 0.607 | 0.615 | 225598000.0 |
| 2001-11-28 14:00:00 | AMZN | Stock | 0.6145 | 0.6145 | 0.586 | 0.5865 | 81448000.0 |
| 2001-11-28 15:00:00 | AMZN | Stock | 0.587 | 0.5975 | 0.572 | 0.5792 | 75544000.0 |
| 2001-11-28 16:00:00 | AMZN | Stock | 0.5785 | 0.6035 | 0.5745 | 0.5745 | 8212000.0 |
| 2001-11-28 17:00:00 | AMZN | Stock | 0.575 | 0.5795 | 0.57 | 0.57 | 1228000.0 |
| 2001-11-28 18:00:00 | AMZN | Stock | 0.5725 | 0.5795 | 0.5725 | 0.5795 | 168000.0 |
| 2001-11-28 09:00:00 | CL | Stock | 28.895 | 28.965 | 28.81 | 28.965 | 158000.0 |
| 2001-11-28 10:00:00 | CL | Stock | 28.975 | 28.975 | 28.725 | 28.76 | 229600.0 |
| 2001-11-28 11:00:00 | CL | Stock | 28.76 | 28.945 | 28.75 | 28.905 | 133800.0 |
| 2001-11-28 12:00:00 | CL | Stock | 28.915 | 29.1 | 28.905 | 29.015 | 271400.0 |
| 2001-11-28 13:00:00 | CL | Stock | 29.01 | 29.09 | 28.975 | 29.06 | 306600.0 |
| 2001-11-28 14:00:00 | CL | Stock | 29.06 | 29.22 | 29.025 | 29.15 | 366400.0 |
| 2001-11-28 15:00:00 | CL | Stock | 29.165 | 29.235 | 28.975 | 29.0 | 453000.0 |
> showing 50 of 17,867 rows — these rows as CSV