PREVIEW / stock_1hour / 2002-03-01
file: by_date/stock_1hour/2002/2002-03-01.parquet size: 395 KB rows: 18,818 symbols: 1,395
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-03-01 08:00:00 | AAPL | Stock | 0.3875 | 0.3904 | 0.3875 | 0.3902 | 89600.0 |
| 2002-03-01 09:00:00 | AAPL | Stock | 0.3895 | 0.4 | 0.3893 | 0.3941 | 52903200.0 |
| 2002-03-01 10:00:00 | AAPL | Stock | 0.3941 | 0.4089 | 0.3941 | 0.4039 | 68964000.0 |
| 2002-03-01 11:00:00 | AAPL | Stock | 0.4041 | 0.4111 | 0.403 | 0.407 | 40045600.0 |
| 2002-03-01 12:00:00 | AAPL | Stock | 0.407 | 0.408 | 0.4036 | 0.4079 | 17869600.0 |
| 2002-03-01 13:00:00 | AAPL | Stock | 0.4079 | 0.4148 | 0.4066 | 0.4132 | 22064000.0 |
| 2002-03-01 14:00:00 | AAPL | Stock | 0.4134 | 0.4157 | 0.4098 | 0.412 | 45466400.0 |
| 2002-03-01 15:00:00 | AAPL | Stock | 0.4123 | 0.4196 | 0.4111 | 0.4189 | 71932000.0 |
| 2002-03-01 16:00:00 | AAPL | Stock | 0.4191 | 0.4196 | 0.4067 | 0.4067 | 11614400.0 |
| 2002-03-01 17:00:00 | AAPL | Stock | 0.4161 | 0.4188 | 0.4161 | 0.4188 | 4754400.0 |
| 2002-03-01 18:00:00 | AAPL | Stock | 0.4188 | 0.4188 | 0.4141 | 0.4141 | 2391200.0 |
| 2002-03-01 08:00:00 | MSFT | Stock | 29.205 | 29.45 | 29.17 | 29.375 | 17000.0 |
| 2002-03-01 09:00:00 | MSFT | Stock | 29.375 | 29.64 | 29.045 | 29.51 | 6192200.0 |
| 2002-03-01 10:00:00 | MSFT | Stock | 29.525 | 30.025 | 29.5 | 29.95 | 11216400.0 |
| 2002-03-01 11:00:00 | MSFT | Stock | 29.94 | 30.22 | 29.925 | 30.0949 | 9502200.0 |
| 2002-03-01 12:00:00 | MSFT | Stock | 30.0901 | 30.35 | 29.99 | 30.275 | 5309200.0 |
| 2002-03-01 13:00:00 | MSFT | Stock | 30.275 | 30.475 | 30.16 | 30.405 | 6098800.0 |
| 2002-03-01 14:00:00 | MSFT | Stock | 30.395 | 30.49 | 30.275 | 30.42 | 5678400.0 |
| 2002-03-01 15:00:00 | MSFT | Stock | 30.42 | 30.71 | 30.2245 | 30.685 | 13538000.0 |
| 2002-03-01 16:00:00 | MSFT | Stock | 30.68 | 30.75 | 30.1293 | 30.685 | 2593400.0 |
| 2002-03-01 17:00:00 | MSFT | Stock | 30.455 | 30.75 | 30.225 | 30.315 | 764200.0 |
| 2002-03-01 18:00:00 | MSFT | Stock | 30.35 | 30.685 | 30.335 | 30.335 | 342600.0 |
| 2002-03-01 08:00:00 | NVDA | Stock | 0.4227 | 0.4312 | 0.4222 | 0.4279 | 1404000.0 |
| 2002-03-01 09:00:00 | NVDA | Stock | 0.4275 | 0.4376 | 0.4273 | 0.4361 | 122964000.0 |
| 2002-03-01 10:00:00 | NVDA | Stock | 0.4361 | 0.4466 | 0.4354 | 0.4456 | 260664000.0 |
| 2002-03-01 11:00:00 | NVDA | Stock | 0.4451 | 0.4542 | 0.445 | 0.4531 | 203760000.0 |
| 2002-03-01 12:00:00 | NVDA | Stock | 0.453 | 0.4574 | 0.4504 | 0.4537 | 133632000.0 |
| 2002-03-01 13:00:00 | NVDA | Stock | 0.4537 | 0.4623 | 0.4533 | 0.4597 | 137832000.0 |
| 2002-03-01 14:00:00 | NVDA | Stock | 0.4594 | 0.4621 | 0.4559 | 0.4606 | 146100000.0 |
| 2002-03-01 15:00:00 | NVDA | Stock | 0.4607 | 0.4667 | 0.4575 | 0.4662 | 245868000.0 |
| 2002-03-01 16:00:00 | NVDA | Stock | 0.4662 | 0.4707 | 0.4647 | 0.47 | 21036000.0 |
| 2002-03-01 17:00:00 | NVDA | Stock | 0.4694 | 0.4696 | 0.4646 | 0.4667 | 5244000.0 |
| 2002-03-01 18:00:00 | NVDA | Stock | 0.4648 | 0.4662 | 0.4634 | 0.465 | 1956000.0 |
| 2002-03-01 08:00:00 | AMZN | Stock | 0.7075 | 0.725 | 0.7 | 0.715 | 114000.0 |
| 2002-03-01 09:00:00 | AMZN | Stock | 0.7125 | 0.7235 | 0.705 | 0.717 | 18368000.0 |
| 2002-03-01 10:00:00 | AMZN | Stock | 0.718 | 0.739 | 0.7155 | 0.739 | 31540000.0 |
| 2002-03-01 11:00:00 | AMZN | Stock | 0.739 | 0.7476 | 0.7325 | 0.743 | 28078000.0 |
| 2002-03-01 12:00:00 | AMZN | Stock | 0.7426 | 0.748 | 0.7375 | 0.7432 | 14484000.0 |
| 2002-03-01 13:00:00 | AMZN | Stock | 0.744 | 0.7545 | 0.7431 | 0.7471 | 28242000.0 |
| 2002-03-01 14:00:00 | AMZN | Stock | 0.7475 | 0.754 | 0.745 | 0.75 | 14986000.0 |
| 2002-03-01 15:00:00 | AMZN | Stock | 0.75 | 0.77 | 0.749 | 0.7685 | 45878000.0 |
| 2002-03-01 16:00:00 | AMZN | Stock | 0.7695 | 0.7725 | 0.7438 | 0.7625 | 7460000.0 |
| 2002-03-01 17:00:00 | AMZN | Stock | 0.7655 | 0.7695 | 0.761 | 0.766 | 970000.0 |
| 2002-03-01 18:00:00 | AMZN | Stock | 0.7625 | 0.7695 | 0.761 | 0.761 | 478000.0 |
| 2002-03-01 09:00:00 | CL | Stock | 28.1 | 28.155 | 28.025 | 28.15 | 280800.0 |
| 2002-03-01 10:00:00 | CL | Stock | 28.15 | 28.285 | 28.1 | 28.275 | 345600.0 |
| 2002-03-01 11:00:00 | CL | Stock | 28.275 | 28.45 | 28.24 | 28.445 | 386800.0 |
| 2002-03-01 12:00:00 | CL | Stock | 28.445 | 28.45 | 28.35 | 28.44 | 226400.0 |
| 2002-03-01 13:00:00 | CL | Stock | 28.415 | 28.44 | 28.3 | 28.325 | 182400.0 |
| 2002-03-01 14:00:00 | CL | Stock | 28.3 | 28.365 | 28.255 | 28.35 | 288400.0 |
> showing 50 of 18,818 rows — these rows as CSV