PREVIEW / stock_5min / 2004-06-16
file: by_date/stock_5min/2004/2004-06-16.parquet size: 2.4 MB rows: 177,068 symbols: 1,786
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-16 08:40:00 | AAPL | Stock | 0.5507 | 0.5516 | 0.5498 | 0.5498 | 33600.0 |
| 2004-06-16 08:45:00 | AAPL | Stock | 0.5489 | 0.5489 | 0.5489 | 0.5489 | 28000.0 |
| 2004-06-16 09:15:00 | AAPL | Stock | 0.5479 | 0.5479 | 0.5479 | 0.5479 | 5600.0 |
| 2004-06-16 09:25:00 | AAPL | Stock | 0.548 | 0.548 | 0.5466 | 0.5466 | 89600.0 |
| 2004-06-16 09:30:00 | AAPL | Stock | 0.5468 | 0.548 | 0.5457 | 0.5464 | 3568712.0 |
| 2004-06-16 09:35:00 | AAPL | Stock | 0.5464 | 0.5479 | 0.5452 | 0.5457 | 2657984.0 |
| 2004-06-16 09:40:00 | AAPL | Stock | 0.5459 | 0.5482 | 0.5454 | 0.5482 | 1447880.0 |
| 2004-06-16 09:45:00 | AAPL | Stock | 0.5484 | 0.5498 | 0.5464 | 0.5482 | 4443152.0 |
| 2004-06-16 09:50:00 | AAPL | Stock | 0.5482 | 0.5505 | 0.5482 | 0.5504 | 4599952.0 |
| 2004-06-16 09:55:00 | AAPL | Stock | 0.5505 | 0.5509 | 0.5491 | 0.5505 | 3327464.0 |
| 2004-06-16 10:00:00 | AAPL | Stock | 0.5505 | 0.5541 | 0.5504 | 0.5541 | 9940560.0 |
| 2004-06-16 10:05:00 | AAPL | Stock | 0.5541 | 0.5557 | 0.5532 | 0.5554 | 11567640.0 |
| 2004-06-16 10:10:00 | AAPL | Stock | 0.5555 | 0.5573 | 0.5548 | 0.5569 | 6295632.0 |
| 2004-06-16 10:15:00 | AAPL | Stock | 0.5566 | 0.5579 | 0.5561 | 0.557 | 5241152.0 |
| 2004-06-16 10:20:00 | AAPL | Stock | 0.5571 | 0.5589 | 0.5571 | 0.5575 | 13011992.0 |
| 2004-06-16 10:25:00 | AAPL | Stock | 0.5573 | 0.5588 | 0.5571 | 0.5582 | 4313848.0 |
| 2004-06-16 10:30:00 | AAPL | Stock | 0.5584 | 0.5586 | 0.5566 | 0.5575 | 4360160.0 |
| 2004-06-16 10:35:00 | AAPL | Stock | 0.5575 | 0.5589 | 0.5571 | 0.5588 | 3979080.0 |
| 2004-06-16 10:40:00 | AAPL | Stock | 0.5588 | 0.5609 | 0.5582 | 0.5602 | 7813680.0 |
| 2004-06-16 10:45:00 | AAPL | Stock | 0.5602 | 0.562 | 0.5596 | 0.5611 | 7106736.0 |
| 2004-06-16 10:50:00 | AAPL | Stock | 0.5607 | 0.5618 | 0.5602 | 0.5609 | 12168912.0 |
| 2004-06-16 10:55:00 | AAPL | Stock | 0.5609 | 0.562 | 0.5609 | 0.5616 | 4653712.0 |
| 2004-06-16 11:00:00 | AAPL | Stock | 0.5618 | 0.5618 | 0.5605 | 0.5616 | 5279736.0 |
| 2004-06-16 11:05:00 | AAPL | Stock | 0.5618 | 0.5625 | 0.5613 | 0.5613 | 9902984.0 |
| 2004-06-16 11:10:00 | AAPL | Stock | 0.5618 | 0.5623 | 0.5618 | 0.5623 | 5357576.0 |
| 2004-06-16 11:15:00 | AAPL | Stock | 0.5623 | 0.563 | 0.5618 | 0.5625 | 6803888.0 |
| 2004-06-16 11:20:00 | AAPL | Stock | 0.5625 | 0.5638 | 0.562 | 0.5623 | 7680232.0 |
| 2004-06-16 11:25:00 | AAPL | Stock | 0.5625 | 0.5627 | 0.562 | 0.5621 | 6056176.0 |
| 2004-06-16 11:30:00 | AAPL | Stock | 0.5621 | 0.5625 | 0.5613 | 0.5613 | 11114768.0 |
| 2004-06-16 11:35:00 | AAPL | Stock | 0.5613 | 0.562 | 0.5609 | 0.5614 | 6227368.0 |
| 2004-06-16 11:40:00 | AAPL | Stock | 0.5613 | 0.5614 | 0.5593 | 0.5598 | 4182360.0 |
| 2004-06-16 11:45:00 | AAPL | Stock | 0.5595 | 0.5595 | 0.5584 | 0.5588 | 7060536.0 |
| 2004-06-16 11:50:00 | AAPL | Stock | 0.5589 | 0.56 | 0.5588 | 0.5593 | 4465720.0 |
| 2004-06-16 11:55:00 | AAPL | Stock | 0.5593 | 0.5609 | 0.5591 | 0.5607 | 6449184.0 |
| 2004-06-16 12:00:00 | AAPL | Stock | 0.5609 | 0.5611 | 0.5598 | 0.5605 | 3017000.0 |
| 2004-06-16 12:05:00 | AAPL | Stock | 0.5605 | 0.5609 | 0.5604 | 0.5607 | 1715896.0 |
| 2004-06-16 12:10:00 | AAPL | Stock | 0.5607 | 0.5609 | 0.5604 | 0.5605 | 1169672.0 |
| 2004-06-16 12:15:00 | AAPL | Stock | 0.5604 | 0.5609 | 0.5604 | 0.5607 | 2118760.0 |
| 2004-06-16 12:20:00 | AAPL | Stock | 0.5607 | 0.5616 | 0.5607 | 0.5616 | 2707040.0 |
| 2004-06-16 12:25:00 | AAPL | Stock | 0.5614 | 0.5614 | 0.5609 | 0.5614 | 2380840.0 |
| 2004-06-16 12:30:00 | AAPL | Stock | 0.5616 | 0.5625 | 0.5614 | 0.5625 | 7537096.0 |
| 2004-06-16 12:35:00 | AAPL | Stock | 0.5621 | 0.5623 | 0.562 | 0.5623 | 1774360.0 |
| 2004-06-16 12:40:00 | AAPL | Stock | 0.5623 | 0.5625 | 0.5614 | 0.5622 | 2469600.0 |
| 2004-06-16 12:45:00 | AAPL | Stock | 0.5625 | 0.5629 | 0.5623 | 0.5625 | 2649080.0 |
| 2004-06-16 12:50:00 | AAPL | Stock | 0.5627 | 0.5638 | 0.5625 | 0.5636 | 3211824.0 |
| 2004-06-16 12:55:00 | AAPL | Stock | 0.5636 | 0.5657 | 0.5636 | 0.565 | 9476824.0 |
| 2004-06-16 13:00:00 | AAPL | Stock | 0.5652 | 0.5655 | 0.5642 | 0.5655 | 5836824.0 |
| 2004-06-16 13:05:00 | AAPL | Stock | 0.5657 | 0.5657 | 0.5638 | 0.5643 | 3798816.0 |
| 2004-06-16 13:10:00 | AAPL | Stock | 0.5641 | 0.5643 | 0.5627 | 0.5636 | 8598632.0 |
| 2004-06-16 13:15:00 | AAPL | Stock | 0.5636 | 0.5638 | 0.5629 | 0.5634 | 1736000.0 |
> showing 50 of 177,068 rows — these rows as CSV