PREVIEW / stock_1hour / 2002-03-22
file: by_date/stock_1hour/2002/2002-03-22.parquet size: 394 KB rows: 18,659 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-03-22 08:00:00 | AAPL | Stock | 0.4337 | 0.4339 | 0.433 | 0.4338 | 2475200.0 |
| 2002-03-22 09:00:00 | AAPL | Stock | 0.4332 | 0.437 | 0.4293 | 0.4341 | 33521600.0 |
| 2002-03-22 10:00:00 | AAPL | Stock | 0.4336 | 0.4354 | 0.4277 | 0.4288 | 30413600.0 |
| 2002-03-22 11:00:00 | AAPL | Stock | 0.4291 | 0.4302 | 0.4263 | 0.4268 | 18888800.0 |
| 2002-03-22 12:00:00 | AAPL | Stock | 0.4268 | 0.4386 | 0.4268 | 0.4341 | 28884800.0 |
| 2002-03-22 13:00:00 | AAPL | Stock | 0.4341 | 0.4363 | 0.4327 | 0.4348 | 13389600.0 |
| 2002-03-22 14:00:00 | AAPL | Stock | 0.435 | 0.435 | 0.4288 | 0.4314 | 19510400.0 |
| 2002-03-22 15:00:00 | AAPL | Stock | 0.4318 | 0.4318 | 0.4266 | 0.4302 | 37324000.0 |
| 2002-03-22 16:00:00 | AAPL | Stock | 0.43 | 0.4315 | 0.43 | 0.4304 | 6059200.0 |
| 2002-03-22 17:00:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4302 | 0.4302 | 95200.0 |
| 2002-03-22 08:00:00 | MSFT | Stock | 30.505 | 30.71 | 30.505 | 30.68 | 161400.0 |
| 2002-03-22 09:00:00 | MSFT | Stock | 30.6 | 30.68 | 30.285 | 30.47 | 4223000.0 |
| 2002-03-22 10:00:00 | MSFT | Stock | 30.485 | 30.495 | 30.1495 | 30.355 | 6495600.0 |
| 2002-03-22 11:00:00 | MSFT | Stock | 30.355 | 30.405 | 30.185 | 30.24 | 4810000.0 |
| 2002-03-22 12:00:00 | MSFT | Stock | 30.245 | 30.3895 | 30.185 | 30.29 | 3921400.0 |
| 2002-03-22 13:00:00 | MSFT | Stock | 30.2855 | 30.335 | 30.175 | 30.245 | 2764200.0 |
| 2002-03-22 14:00:00 | MSFT | Stock | 30.25 | 30.37 | 30.11 | 30.35 | 5994200.0 |
| 2002-03-22 15:00:00 | MSFT | Stock | 30.35 | 30.35 | 30.17 | 30.225 | 6404600.0 |
| 2002-03-22 16:00:00 | MSFT | Stock | 30.22 | 30.345 | 30.2005 | 30.225 | 2114600.0 |
| 2002-03-22 17:00:00 | MSFT | Stock | 30.2985 | 30.3101 | 30.225 | 30.3101 | 189400.0 |
| 2002-03-22 08:00:00 | NVDA | Stock | 0.4183 | 0.4216 | 0.4071 | 0.4142 | 5628000.0 |
| 2002-03-22 09:00:00 | NVDA | Stock | 0.4142 | 0.4171 | 0.4042 | 0.4082 | 257232000.0 |
| 2002-03-22 10:00:00 | NVDA | Stock | 0.4082 | 0.4104 | 0.4017 | 0.4086 | 264600000.0 |
| 2002-03-22 11:00:00 | NVDA | Stock | 0.4086 | 0.4119 | 0.4052 | 0.4081 | 135588000.0 |
| 2002-03-22 12:00:00 | NVDA | Stock | 0.4081 | 0.4155 | 0.4075 | 0.4108 | 162552000.0 |
| 2002-03-22 13:00:00 | NVDA | Stock | 0.4108 | 0.4134 | 0.4093 | 0.4113 | 83280000.0 |
| 2002-03-22 14:00:00 | NVDA | Stock | 0.4112 | 0.4132 | 0.4077 | 0.4111 | 108192000.0 |
| 2002-03-22 15:00:00 | NVDA | Stock | 0.4111 | 0.4112 | 0.4047 | 0.4047 | 151284000.0 |
| 2002-03-22 16:00:00 | NVDA | Stock | 0.4047 | 0.4104 | 0.4047 | 0.4092 | 18252000.0 |
| 2002-03-22 17:00:00 | NVDA | Stock | 0.4058 | 0.4058 | 0.4047 | 0.4054 | 144000.0 |
| 2002-03-22 18:00:00 | NVDA | Stock | 0.4055 | 0.4055 | 0.4055 | 0.4055 | 24000.0 |
| 2002-03-22 08:00:00 | AMZN | Stock | 0.7625 | 0.7725 | 0.761 | 0.77 | 28000.0 |
| 2002-03-22 09:00:00 | AMZN | Stock | 0.7635 | 0.775 | 0.7555 | 0.77 | 14522000.0 |
| 2002-03-22 10:00:00 | AMZN | Stock | 0.77 | 0.78 | 0.7655 | 0.776 | 18836000.0 |
| 2002-03-22 11:00:00 | AMZN | Stock | 0.7765 | 0.78 | 0.7705 | 0.773 | 12334000.0 |
| 2002-03-22 12:00:00 | AMZN | Stock | 0.7725 | 0.779 | 0.769 | 0.777 | 12948000.0 |
| 2002-03-22 13:00:00 | AMZN | Stock | 0.779 | 0.78 | 0.77 | 0.775 | 9802000.0 |
| 2002-03-22 14:00:00 | AMZN | Stock | 0.7755 | 0.779 | 0.77 | 0.776 | 7558000.0 |
| 2002-03-22 15:00:00 | AMZN | Stock | 0.776 | 0.7802 | 0.7715 | 0.7765 | 19570000.0 |
| 2002-03-22 16:00:00 | AMZN | Stock | 0.775 | 0.7815 | 0.7736 | 0.7755 | 2136000.0 |
| 2002-03-22 17:00:00 | AMZN | Stock | 0.7765 | 0.7765 | 0.7765 | 0.7765 | 4000.0 |
| 2002-03-22 09:00:00 | CL | Stock | 28.2 | 28.425 | 28.155 | 28.35 | 236800.0 |
| 2002-03-22 10:00:00 | CL | Stock | 28.34 | 28.5 | 28.275 | 28.47 | 441600.0 |
| 2002-03-22 11:00:00 | CL | Stock | 28.455 | 28.495 | 28.405 | 28.41 | 238200.0 |
| 2002-03-22 12:00:00 | CL | Stock | 28.4 | 28.56 | 28.4 | 28.53 | 276000.0 |
| 2002-03-22 13:00:00 | CL | Stock | 28.53 | 28.55 | 28.435 | 28.51 | 195800.0 |
| 2002-03-22 14:00:00 | CL | Stock | 28.51 | 28.545 | 28.43 | 28.515 | 335000.0 |
| 2002-03-22 15:00:00 | CL | Stock | 28.51 | 28.53 | 28.4 | 28.455 | 499200.0 |
| 2002-03-22 16:00:00 | CL | Stock | 28.45 | 28.45 | 28.44 | 28.44 | 71000.0 |
| 2002-03-22 17:00:00 | CL | Stock | 28.44 | 28.45 | 28.44 | 28.45 | 82400.0 |
> showing 50 of 18,659 rows — these rows as CSV