PREVIEW / stock_5min / 2005-07-29
file: by_date/stock_5min/2005/2005-07-29.parquet size: 2.7 MB rows: 200,284 symbols: 2,044
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-29 08:15:00 | AAPL | Stock | 1.5611 | 1.5611 | 1.5607 | 1.5607 | 33600.0 |
| 2005-07-29 08:30:00 | AAPL | Stock | 1.5536 | 1.5589 | 1.5536 | 1.5589 | 56028.0 |
| 2005-07-29 08:35:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 8428.0 |
| 2005-07-29 08:40:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.5607 | 1.5607 | 33600.0 |
| 2005-07-29 08:45:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 9212.0 |
| 2005-07-29 08:55:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 5600.0 |
| 2005-07-29 09:00:00 | AAPL | Stock | 1.5586 | 1.5586 | 1.5554 | 1.5554 | 61600.0 |
| 2005-07-29 09:05:00 | AAPL | Stock | 1.5571 | 1.5571 | 1.5571 | 1.5571 | 2800.0 |
| 2005-07-29 09:10:00 | AAPL | Stock | 1.5557 | 1.5557 | 1.5557 | 1.5557 | 8400.0 |
| 2005-07-29 09:15:00 | AAPL | Stock | 1.5571 | 1.5589 | 1.5571 | 1.5589 | 14000.0 |
| 2005-07-29 09:20:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 28000.0 |
| 2005-07-29 09:25:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5557 | 1.5557 | 112000.0 |
| 2005-07-29 09:30:00 | AAPL | Stock | 1.5557 | 1.56 | 1.5518 | 1.5571 | 8858528.0 |
| 2005-07-29 09:35:00 | AAPL | Stock | 1.5575 | 1.5596 | 1.5539 | 1.5564 | 4628596.0 |
| 2005-07-29 09:40:00 | AAPL | Stock | 1.5564 | 1.5629 | 1.5564 | 1.5629 | 3874024.0 |
| 2005-07-29 09:45:00 | AAPL | Stock | 1.5632 | 1.5707 | 1.5621 | 1.5693 | 8680840.0 |
| 2005-07-29 09:50:00 | AAPL | Stock | 1.5693 | 1.5696 | 1.5664 | 1.5668 | 6750940.0 |
| 2005-07-29 09:55:00 | AAPL | Stock | 1.5668 | 1.5807 | 1.5668 | 1.5807 | 23450616.0 |
| 2005-07-29 10:00:00 | AAPL | Stock | 1.5807 | 1.585 | 1.5725 | 1.5732 | 24783500.0 |
| 2005-07-29 10:05:00 | AAPL | Stock | 1.5732 | 1.5743 | 1.5661 | 1.5675 | 11558260.0 |
| 2005-07-29 10:10:00 | AAPL | Stock | 1.5671 | 1.5714 | 1.5504 | 1.5539 | 16041368.0 |
| 2005-07-29 10:15:00 | AAPL | Stock | 1.5536 | 1.5614 | 1.5407 | 1.5411 | 20997816.0 |
| 2005-07-29 10:20:00 | AAPL | Stock | 1.5411 | 1.5543 | 1.54 | 1.5521 | 10278436.0 |
| 2005-07-29 10:25:00 | AAPL | Stock | 1.5518 | 1.5571 | 1.5486 | 1.55 | 6290340.0 |
| 2005-07-29 10:30:00 | AAPL | Stock | 1.5504 | 1.5536 | 1.5468 | 1.5529 | 4036424.0 |
| 2005-07-29 10:35:00 | AAPL | Stock | 1.5539 | 1.5564 | 1.55 | 1.5504 | 5135452.0 |
| 2005-07-29 10:40:00 | AAPL | Stock | 1.5504 | 1.5504 | 1.5421 | 1.5464 | 8243592.0 |
| 2005-07-29 10:45:00 | AAPL | Stock | 1.5461 | 1.5468 | 1.5418 | 1.5439 | 5339740.0 |
| 2005-07-29 10:50:00 | AAPL | Stock | 1.5439 | 1.5454 | 1.5375 | 1.5429 | 5964448.0 |
| 2005-07-29 10:55:00 | AAPL | Stock | 1.5429 | 1.545 | 1.5411 | 1.5439 | 2676520.0 |
| 2005-07-29 11:00:00 | AAPL | Stock | 1.5439 | 1.5439 | 1.5404 | 1.5407 | 3592428.0 |
| 2005-07-29 11:05:00 | AAPL | Stock | 1.5407 | 1.5411 | 1.5357 | 1.5364 | 10214428.0 |
| 2005-07-29 11:10:00 | AAPL | Stock | 1.5364 | 1.54 | 1.5361 | 1.5393 | 4668748.0 |
| 2005-07-29 11:15:00 | AAPL | Stock | 1.5389 | 1.5436 | 1.5386 | 1.5418 | 4531688.0 |
| 2005-07-29 11:20:00 | AAPL | Stock | 1.5418 | 1.5461 | 1.5407 | 1.5454 | 4388524.0 |
| 2005-07-29 11:25:00 | AAPL | Stock | 1.5457 | 1.5471 | 1.5429 | 1.5439 | 4469276.0 |
| 2005-07-29 11:30:00 | AAPL | Stock | 1.5439 | 1.5471 | 1.5432 | 1.5461 | 3514476.0 |
| 2005-07-29 11:35:00 | AAPL | Stock | 1.5457 | 1.5464 | 1.5393 | 1.5404 | 6208328.0 |
| 2005-07-29 11:40:00 | AAPL | Stock | 1.5407 | 1.5421 | 1.5368 | 1.5375 | 3767232.0 |
| 2005-07-29 11:45:00 | AAPL | Stock | 1.5371 | 1.5389 | 1.535 | 1.5357 | 5215840.0 |
| 2005-07-29 11:50:00 | AAPL | Stock | 1.5357 | 1.5375 | 1.5307 | 1.5371 | 9118004.0 |
| 2005-07-29 11:55:00 | AAPL | Stock | 1.5368 | 1.5393 | 1.5364 | 1.5382 | 3723020.0 |
| 2005-07-29 12:00:00 | AAPL | Stock | 1.5379 | 1.5386 | 1.5361 | 1.5364 | 2767156.0 |
| 2005-07-29 12:05:00 | AAPL | Stock | 1.5364 | 1.5379 | 1.5336 | 1.5368 | 2747276.0 |
| 2005-07-29 12:10:00 | AAPL | Stock | 1.5368 | 1.5371 | 1.5339 | 1.5357 | 1681792.0 |
| 2005-07-29 12:15:00 | AAPL | Stock | 1.5357 | 1.5375 | 1.5354 | 1.5368 | 1758428.0 |
| 2005-07-29 12:20:00 | AAPL | Stock | 1.5368 | 1.5389 | 1.5361 | 1.5361 | 1947932.0 |
| 2005-07-29 12:25:00 | AAPL | Stock | 1.5361 | 1.5379 | 1.5357 | 1.5361 | 1426824.0 |
| 2005-07-29 12:30:00 | AAPL | Stock | 1.5364 | 1.5386 | 1.5357 | 1.5375 | 1835400.0 |
| 2005-07-29 12:35:00 | AAPL | Stock | 1.5379 | 1.5404 | 1.5375 | 1.54 | 1567048.0 |
> showing 50 of 200,284 rows — these rows as CSV