PREVIEW / stock_5min / 2006-09-01
file: by_date/stock_5min/2006/2006-09-01.parquet size: 3.0 MB rows: 224,271 symbols: 2,349
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-09-01 07:35:00 | AAPL | Stock | 2.4339 | 2.4339 | 2.4339 | 2.4339 | 2800.0 |
| 2006-09-01 08:00:00 | AAPL | Stock | 2.4304 | 2.4307 | 2.4304 | 2.4307 | 98000.0 |
| 2006-09-01 08:05:00 | AAPL | Stock | 2.4304 | 2.4393 | 2.4304 | 2.4375 | 219576.0 |
| 2006-09-01 08:10:00 | AAPL | Stock | 2.4371 | 2.4393 | 2.4357 | 2.4393 | 471800.0 |
| 2006-09-01 08:15:00 | AAPL | Stock | 2.4393 | 2.4393 | 2.4357 | 2.4375 | 120400.0 |
| 2006-09-01 08:20:00 | AAPL | Stock | 2.4357 | 2.4357 | 2.4232 | 2.4343 | 70000.0 |
| 2006-09-01 08:25:00 | AAPL | Stock | 2.4354 | 2.4386 | 2.4232 | 2.4386 | 400400.0 |
| 2006-09-01 08:30:00 | AAPL | Stock | 2.4386 | 2.4457 | 2.4361 | 2.4361 | 526176.0 |
| 2006-09-01 08:35:00 | AAPL | Stock | 2.4411 | 2.4429 | 2.4389 | 2.4418 | 210000.0 |
| 2006-09-01 08:40:00 | AAPL | Stock | 2.4425 | 2.4429 | 2.4232 | 2.4393 | 658224.0 |
| 2006-09-01 08:45:00 | AAPL | Stock | 2.4393 | 2.4411 | 2.4232 | 2.4407 | 765800.0 |
| 2006-09-01 08:50:00 | AAPL | Stock | 2.4411 | 2.4411 | 2.4339 | 2.4343 | 458024.0 |
| 2006-09-01 08:55:00 | AAPL | Stock | 2.4343 | 2.4346 | 2.4329 | 2.4346 | 433300.0 |
| 2006-09-01 09:00:00 | AAPL | Stock | 2.4357 | 2.4393 | 2.4357 | 2.4375 | 429100.0 |
| 2006-09-01 09:05:00 | AAPL | Stock | 2.4375 | 2.4393 | 2.4375 | 2.4389 | 397600.0 |
| 2006-09-01 09:10:00 | AAPL | Stock | 2.4393 | 2.44 | 2.4375 | 2.4379 | 526400.0 |
| 2006-09-01 09:15:00 | AAPL | Stock | 2.4361 | 2.4396 | 2.4357 | 2.4393 | 84000.0 |
| 2006-09-01 09:20:00 | AAPL | Stock | 2.4389 | 2.4393 | 2.4357 | 2.4375 | 417200.0 |
| 2006-09-01 09:25:00 | AAPL | Stock | 2.4375 | 2.4482 | 2.4357 | 2.445 | 1590428.0 |
| 2006-09-01 09:30:00 | AAPL | Stock | 2.4457 | 2.4464 | 2.4411 | 2.4454 | 18176648.0 |
| 2006-09-01 09:35:00 | AAPL | Stock | 2.4454 | 2.4493 | 2.4418 | 2.4468 | 14598780.0 |
| 2006-09-01 09:40:00 | AAPL | Stock | 2.4461 | 2.4464 | 2.4371 | 2.4386 | 10024196.0 |
| 2006-09-01 09:45:00 | AAPL | Stock | 2.4386 | 2.445 | 2.4379 | 2.4418 | 9455516.0 |
| 2006-09-01 09:50:00 | AAPL | Stock | 2.4418 | 2.4457 | 2.4396 | 2.4457 | 6938708.0 |
| 2006-09-01 09:55:00 | AAPL | Stock | 2.4457 | 2.4518 | 2.4454 | 2.4493 | 13585068.0 |
| 2006-09-01 10:00:00 | AAPL | Stock | 2.4493 | 2.4496 | 2.4404 | 2.4404 | 7890232.0 |
| 2006-09-01 10:05:00 | AAPL | Stock | 2.4404 | 2.4418 | 2.4321 | 2.4386 | 12305160.0 |
| 2006-09-01 10:10:00 | AAPL | Stock | 2.4393 | 2.4393 | 2.4268 | 2.4332 | 13748616.0 |
| 2006-09-01 10:15:00 | AAPL | Stock | 2.4332 | 2.4393 | 2.4321 | 2.4393 | 9103696.0 |
| 2006-09-01 10:20:00 | AAPL | Stock | 2.4393 | 2.4407 | 2.4332 | 2.4346 | 7532924.0 |
| 2006-09-01 10:25:00 | AAPL | Stock | 2.435 | 2.4375 | 2.4336 | 2.4368 | 4713548.0 |
| 2006-09-01 10:30:00 | AAPL | Stock | 2.4368 | 2.4396 | 2.4368 | 2.4379 | 4328604.0 |
| 2006-09-01 10:35:00 | AAPL | Stock | 2.4379 | 2.4386 | 2.435 | 2.4368 | 4222792.0 |
| 2006-09-01 10:40:00 | AAPL | Stock | 2.4368 | 2.4375 | 2.4343 | 2.4357 | 3327212.0 |
| 2006-09-01 10:45:00 | AAPL | Stock | 2.4354 | 2.4375 | 2.4314 | 2.4332 | 7255976.0 |
| 2006-09-01 10:50:00 | AAPL | Stock | 2.4332 | 2.4343 | 2.4275 | 2.43 | 9535932.0 |
| 2006-09-01 10:55:00 | AAPL | Stock | 2.4304 | 2.4321 | 2.4279 | 2.4296 | 5131560.0 |
| 2006-09-01 11:00:00 | AAPL | Stock | 2.43 | 2.4332 | 2.4286 | 2.4289 | 6244504.0 |
| 2006-09-01 11:05:00 | AAPL | Stock | 2.4293 | 2.4304 | 2.4243 | 2.4275 | 10891160.0 |
| 2006-09-01 11:10:00 | AAPL | Stock | 2.4275 | 2.4282 | 2.4239 | 2.4243 | 5114340.0 |
| 2006-09-01 11:15:00 | AAPL | Stock | 2.4243 | 2.4268 | 2.4232 | 2.4232 | 5675992.0 |
| 2006-09-01 11:20:00 | AAPL | Stock | 2.4236 | 2.4311 | 2.4221 | 2.4296 | 8164632.0 |
| 2006-09-01 11:25:00 | AAPL | Stock | 2.4296 | 2.4332 | 2.4296 | 2.4307 | 5861408.0 |
| 2006-09-01 11:30:00 | AAPL | Stock | 2.4307 | 2.4329 | 2.4254 | 2.4261 | 5139876.0 |
| 2006-09-01 11:35:00 | AAPL | Stock | 2.4261 | 2.4271 | 2.425 | 2.4268 | 2710596.0 |
| 2006-09-01 11:40:00 | AAPL | Stock | 2.4268 | 2.4304 | 2.4254 | 2.4292 | 3274152.0 |
| 2006-09-01 11:45:00 | AAPL | Stock | 2.4296 | 2.4321 | 2.425 | 2.4314 | 4672332.0 |
| 2006-09-01 11:50:00 | AAPL | Stock | 2.4318 | 2.4368 | 2.4307 | 2.4339 | 8518132.0 |
| 2006-09-01 11:55:00 | AAPL | Stock | 2.4339 | 2.4361 | 2.4336 | 2.4354 | 5588380.0 |
| 2006-09-01 12:00:00 | AAPL | Stock | 2.4354 | 2.4354 | 2.4304 | 2.4307 | 4058460.0 |
> showing 50 of 224,271 rows — these rows as CSV