PREVIEW / stock_5min / 2006-08-25
file: by_date/stock_5min/2006/2006-08-25.parquet size: 2.9 MB rows: 215,213 symbols: 2,322
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-25 05:20:00 | AAPL | Stock | 2.4196 | 2.4196 | 2.4196 | 2.4196 | 2800.0 |
| 2006-08-25 05:50:00 | AAPL | Stock | 2.4214 | 2.4214 | 2.4196 | 2.4214 | 21000.0 |
| 2006-08-25 05:55:00 | AAPL | Stock | 2.4214 | 2.4214 | 2.4214 | 2.4214 | 2800.0 |
| 2006-08-25 08:00:00 | AAPL | Stock | 2.4254 | 2.4257 | 2.4232 | 2.4232 | 73080.0 |
| 2006-08-25 08:05:00 | AAPL | Stock | 2.4232 | 2.4257 | 2.4232 | 2.4232 | 34720.0 |
| 2006-08-25 08:10:00 | AAPL | Stock | 2.4261 | 2.4261 | 2.4261 | 2.4261 | 14000.0 |
| 2006-08-25 08:15:00 | AAPL | Stock | 2.4264 | 2.4264 | 2.4261 | 2.4261 | 7000.0 |
| 2006-08-25 08:20:00 | AAPL | Stock | 2.4236 | 2.4264 | 2.4236 | 2.425 | 28000.0 |
| 2006-08-25 08:25:00 | AAPL | Stock | 2.4232 | 2.4232 | 2.4214 | 2.4214 | 41300.0 |
| 2006-08-25 08:30:00 | AAPL | Stock | 2.4261 | 2.4261 | 2.4261 | 2.4261 | 14000.0 |
| 2006-08-25 08:35:00 | AAPL | Stock | 2.4261 | 2.4261 | 2.4261 | 2.4261 | 2800.0 |
| 2006-08-25 08:40:00 | AAPL | Stock | 2.425 | 2.425 | 2.425 | 2.425 | 11536.0 |
| 2006-08-25 08:45:00 | AAPL | Stock | 2.425 | 2.4261 | 2.425 | 2.4261 | 21224.0 |
| 2006-08-25 08:55:00 | AAPL | Stock | 2.425 | 2.425 | 2.425 | 2.425 | 9576.0 |
| 2006-08-25 09:00:00 | AAPL | Stock | 2.4239 | 2.4239 | 2.4239 | 2.4239 | 5600.0 |
| 2006-08-25 09:05:00 | AAPL | Stock | 2.4236 | 2.4236 | 2.4196 | 2.4196 | 69020.0 |
| 2006-08-25 09:10:00 | AAPL | Stock | 2.4204 | 2.4204 | 2.4196 | 2.4196 | 190400.0 |
| 2006-08-25 09:20:00 | AAPL | Stock | 2.42 | 2.42 | 2.4196 | 2.4196 | 44520.0 |
| 2006-08-25 09:25:00 | AAPL | Stock | 2.4193 | 2.4193 | 2.4004 | 2.4029 | 1314740.0 |
| 2006-08-25 09:30:00 | AAPL | Stock | 2.4055 | 2.4214 | 2.4039 | 2.4057 | 15896132.0 |
| 2006-08-25 09:35:00 | AAPL | Stock | 2.4068 | 2.4186 | 2.4061 | 2.4146 | 9190496.0 |
| 2006-08-25 09:40:00 | AAPL | Stock | 2.4146 | 2.4232 | 2.4125 | 2.4196 | 10129588.0 |
| 2006-08-25 09:45:00 | AAPL | Stock | 2.4196 | 2.425 | 2.4179 | 2.4211 | 9484804.0 |
| 2006-08-25 09:50:00 | AAPL | Stock | 2.4211 | 2.4282 | 2.4182 | 2.4275 | 8803760.0 |
| 2006-08-25 09:55:00 | AAPL | Stock | 2.4275 | 2.4318 | 2.425 | 2.4264 | 14660912.0 |
| 2006-08-25 10:00:00 | AAPL | Stock | 2.4261 | 2.4489 | 2.4246 | 2.4446 | 26082728.0 |
| 2006-08-25 10:05:00 | AAPL | Stock | 2.445 | 2.46 | 2.4414 | 2.4489 | 37663584.0 |
| 2006-08-25 10:10:00 | AAPL | Stock | 2.4493 | 2.4554 | 2.4471 | 2.45 | 16993424.0 |
| 2006-08-25 10:15:00 | AAPL | Stock | 2.45 | 2.4546 | 2.4414 | 2.4457 | 11883088.0 |
| 2006-08-25 10:20:00 | AAPL | Stock | 2.4461 | 2.4486 | 2.4407 | 2.4417 | 13486228.0 |
| 2006-08-25 10:25:00 | AAPL | Stock | 2.4416 | 2.4443 | 2.4396 | 2.4426 | 7390432.0 |
| 2006-08-25 10:30:00 | AAPL | Stock | 2.4429 | 2.4446 | 2.4332 | 2.4364 | 10667552.0 |
| 2006-08-25 10:35:00 | AAPL | Stock | 2.4364 | 2.4446 | 2.435 | 2.4361 | 6485920.0 |
| 2006-08-25 10:40:00 | AAPL | Stock | 2.4364 | 2.4414 | 2.4329 | 2.4404 | 7504588.0 |
| 2006-08-25 10:45:00 | AAPL | Stock | 2.4407 | 2.4411 | 2.4346 | 2.4379 | 5170228.0 |
| 2006-08-25 10:50:00 | AAPL | Stock | 2.4377 | 2.4421 | 2.4364 | 2.4371 | 5820444.0 |
| 2006-08-25 10:55:00 | AAPL | Stock | 2.4364 | 2.4382 | 2.4275 | 2.4296 | 9381288.0 |
| 2006-08-25 11:00:00 | AAPL | Stock | 2.4293 | 2.4314 | 2.4254 | 2.4293 | 7998508.0 |
| 2006-08-25 11:05:00 | AAPL | Stock | 2.4296 | 2.4336 | 2.4264 | 2.4329 | 6534388.0 |
| 2006-08-25 11:10:00 | AAPL | Stock | 2.4325 | 2.4386 | 2.4304 | 2.435 | 6197212.0 |
| 2006-08-25 11:15:00 | AAPL | Stock | 2.4354 | 2.4364 | 2.4311 | 2.4332 | 3035508.0 |
| 2006-08-25 11:20:00 | AAPL | Stock | 2.4332 | 2.4357 | 2.4325 | 2.4354 | 2232888.0 |
| 2006-08-25 11:25:00 | AAPL | Stock | 2.4354 | 2.4393 | 2.4321 | 2.4361 | 5200832.0 |
| 2006-08-25 11:30:00 | AAPL | Stock | 2.4364 | 2.4364 | 2.4307 | 2.4325 | 7472332.0 |
| 2006-08-25 11:35:00 | AAPL | Stock | 2.4325 | 2.4329 | 2.4286 | 2.4302 | 6356056.0 |
| 2006-08-25 11:40:00 | AAPL | Stock | 2.43 | 2.4343 | 2.43 | 2.4311 | 3821076.0 |
| 2006-08-25 11:45:00 | AAPL | Stock | 2.4314 | 2.4346 | 2.4307 | 2.4329 | 3135104.0 |
| 2006-08-25 11:50:00 | AAPL | Stock | 2.4329 | 2.435 | 2.4286 | 2.4332 | 5574128.0 |
| 2006-08-25 11:55:00 | AAPL | Stock | 2.4332 | 2.4364 | 2.4321 | 2.4343 | 3251948.0 |
| 2006-08-25 12:00:00 | AAPL | Stock | 2.4339 | 2.4339 | 2.4289 | 2.4304 | 2427572.0 |
> showing 50 of 215,213 rows — these rows as CSV