PREVIEW / stock_5min / 2005-07-21
file: by_date/stock_5min/2005/2005-07-21.parquet size: 2.8 MB rows: 200,056 symbols: 2,027
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-21 07:55:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5714 | 1.5714 | 12600.0 |
| 2005-07-21 08:00:00 | AAPL | Stock | 1.5625 | 1.5654 | 1.5625 | 1.5654 | 18200.0 |
| 2005-07-21 08:05:00 | AAPL | Stock | 1.5643 | 1.5671 | 1.5643 | 1.5671 | 35000.0 |
| 2005-07-21 08:10:00 | AAPL | Stock | 1.5704 | 1.5721 | 1.5625 | 1.5625 | 63896.0 |
| 2005-07-21 08:15:00 | AAPL | Stock | 1.5696 | 1.5696 | 1.5682 | 1.5696 | 30800.0 |
| 2005-07-21 08:20:00 | AAPL | Stock | 1.5629 | 1.5671 | 1.5589 | 1.56 | 457800.0 |
| 2005-07-21 08:25:00 | AAPL | Stock | 1.5593 | 1.5625 | 1.5593 | 1.5625 | 102144.0 |
| 2005-07-21 08:30:00 | AAPL | Stock | 1.5636 | 1.5636 | 1.5625 | 1.5625 | 56000.0 |
| 2005-07-21 08:35:00 | AAPL | Stock | 1.5618 | 1.5668 | 1.5589 | 1.5607 | 176400.0 |
| 2005-07-21 08:40:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.5536 | 1.5557 | 470540.0 |
| 2005-07-21 08:45:00 | AAPL | Stock | 1.5571 | 1.5571 | 1.5571 | 1.5571 | 27664.0 |
| 2005-07-21 08:50:00 | AAPL | Stock | 1.5582 | 1.5582 | 1.5571 | 1.5582 | 89264.0 |
| 2005-07-21 08:55:00 | AAPL | Stock | 1.5582 | 1.5586 | 1.5582 | 1.5586 | 58800.0 |
| 2005-07-21 09:00:00 | AAPL | Stock | 1.5604 | 1.5629 | 1.5604 | 1.5625 | 140000.0 |
| 2005-07-21 09:05:00 | AAPL | Stock | 1.5625 | 1.5625 | 1.5611 | 1.5611 | 8400.0 |
| 2005-07-21 09:10:00 | AAPL | Stock | 1.5625 | 1.5625 | 1.5625 | 1.5625 | 23520.0 |
| 2005-07-21 09:15:00 | AAPL | Stock | 1.5625 | 1.5625 | 1.5625 | 1.5625 | 7280.0 |
| 2005-07-21 09:20:00 | AAPL | Stock | 1.5607 | 1.5611 | 1.5546 | 1.5546 | 131236.0 |
| 2005-07-21 09:25:00 | AAPL | Stock | 1.5586 | 1.5679 | 1.5564 | 1.5564 | 1581580.0 |
| 2005-07-21 09:30:00 | AAPL | Stock | 1.5607 | 1.5682 | 1.5561 | 1.5621 | 21446768.0 |
| 2005-07-21 09:35:00 | AAPL | Stock | 1.5621 | 1.5639 | 1.5557 | 1.5571 | 10383212.0 |
| 2005-07-21 09:40:00 | AAPL | Stock | 1.5571 | 1.5589 | 1.555 | 1.5582 | 7451696.0 |
| 2005-07-21 09:45:00 | AAPL | Stock | 1.5582 | 1.5714 | 1.5571 | 1.57 | 19906656.0 |
| 2005-07-21 09:50:00 | AAPL | Stock | 1.57 | 1.5714 | 1.5661 | 1.57 | 10710616.0 |
| 2005-07-21 09:55:00 | AAPL | Stock | 1.57 | 1.5729 | 1.5671 | 1.5675 | 8265516.0 |
| 2005-07-21 10:00:00 | AAPL | Stock | 1.5675 | 1.5696 | 1.5643 | 1.5668 | 5961452.0 |
| 2005-07-21 10:05:00 | AAPL | Stock | 1.5668 | 1.5679 | 1.5646 | 1.5679 | 4068680.0 |
| 2005-07-21 10:10:00 | AAPL | Stock | 1.5679 | 1.5679 | 1.5632 | 1.5639 | 4726092.0 |
| 2005-07-21 10:15:00 | AAPL | Stock | 1.5639 | 1.5646 | 1.5564 | 1.5575 | 12406072.0 |
| 2005-07-21 10:20:00 | AAPL | Stock | 1.5571 | 1.5579 | 1.5464 | 1.5554 | 9837324.0 |
| 2005-07-21 10:25:00 | AAPL | Stock | 1.5564 | 1.56 | 1.5557 | 1.5589 | 7742896.0 |
| 2005-07-21 10:30:00 | AAPL | Stock | 1.5586 | 1.5586 | 1.555 | 1.5568 | 3040576.0 |
| 2005-07-21 10:35:00 | AAPL | Stock | 1.5568 | 1.5582 | 1.5482 | 1.5482 | 5705140.0 |
| 2005-07-21 10:40:00 | AAPL | Stock | 1.5482 | 1.55 | 1.5432 | 1.5493 | 7281540.0 |
| 2005-07-21 10:45:00 | AAPL | Stock | 1.5493 | 1.5518 | 1.5479 | 1.5511 | 6127800.0 |
| 2005-07-21 10:50:00 | AAPL | Stock | 1.5507 | 1.5525 | 1.5464 | 1.5493 | 4724272.0 |
| 2005-07-21 10:55:00 | AAPL | Stock | 1.5493 | 1.55 | 1.5454 | 1.5468 | 2727676.0 |
| 2005-07-21 11:00:00 | AAPL | Stock | 1.5471 | 1.5496 | 1.5464 | 1.5468 | 5202540.0 |
| 2005-07-21 11:05:00 | AAPL | Stock | 1.5464 | 1.5518 | 1.5464 | 1.55 | 5436676.0 |
| 2005-07-21 11:10:00 | AAPL | Stock | 1.55 | 1.5571 | 1.55 | 1.5561 | 6538140.0 |
| 2005-07-21 11:15:00 | AAPL | Stock | 1.5557 | 1.5611 | 1.5554 | 1.5589 | 6022856.0 |
| 2005-07-21 11:20:00 | AAPL | Stock | 1.5589 | 1.5629 | 1.5586 | 1.5621 | 3939264.0 |
| 2005-07-21 11:25:00 | AAPL | Stock | 1.5621 | 1.5625 | 1.5564 | 1.5568 | 2339652.0 |
| 2005-07-21 11:30:00 | AAPL | Stock | 1.5568 | 1.5614 | 1.5532 | 1.5614 | 3880716.0 |
| 2005-07-21 11:35:00 | AAPL | Stock | 1.5611 | 1.5614 | 1.5564 | 1.5575 | 2825144.0 |
| 2005-07-21 11:40:00 | AAPL | Stock | 1.5579 | 1.5593 | 1.5568 | 1.5582 | 2456468.0 |
| 2005-07-21 11:45:00 | AAPL | Stock | 1.5582 | 1.5582 | 1.5546 | 1.5554 | 3716608.0 |
| 2005-07-21 11:50:00 | AAPL | Stock | 1.5554 | 1.5554 | 1.5536 | 1.5543 | 4290244.0 |
| 2005-07-21 11:55:00 | AAPL | Stock | 1.5554 | 1.5554 | 1.5321 | 1.5521 | 4558036.0 |
| 2005-07-21 12:00:00 | AAPL | Stock | 1.5521 | 1.5536 | 1.5475 | 1.5489 | 6142192.0 |
> showing 50 of 200,056 rows — these rows as CSV