PREVIEW / stock_5min / 2004-07-27
file: by_date/stock_5min/2004/2004-07-27.parquet size: 2.4 MB rows: 178,880 symbols: 1,810
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-07-27 08:00:00 | AAPL | Stock | 0.5657 | 0.5661 | 0.5657 | 0.5661 | 56000.0 |
| 2004-07-27 08:05:00 | AAPL | Stock | 0.57 | 0.57 | 0.57 | 0.57 | 56000.0 |
| 2004-07-27 08:15:00 | AAPL | Stock | 0.5696 | 0.5714 | 0.5668 | 0.5668 | 501200.0 |
| 2004-07-27 08:20:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5705 | 0.5714 | 330400.0 |
| 2004-07-27 08:25:00 | AAPL | Stock | 0.5716 | 0.5741 | 0.5714 | 0.5741 | 67368.0 |
| 2004-07-27 08:30:00 | AAPL | Stock | 0.5739 | 0.5739 | 0.5714 | 0.5714 | 151200.0 |
| 2004-07-27 08:35:00 | AAPL | Stock | 0.5705 | 0.5705 | 0.5705 | 0.5705 | 56000.0 |
| 2004-07-27 08:40:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 61600.0 |
| 2004-07-27 08:45:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 33600.0 |
| 2004-07-27 08:50:00 | AAPL | Stock | 0.5675 | 0.5675 | 0.5675 | 0.5675 | 22400.0 |
| 2004-07-27 08:55:00 | AAPL | Stock | 0.5709 | 0.5709 | 0.5709 | 0.5709 | 5600.0 |
| 2004-07-27 09:15:00 | AAPL | Stock | 0.5705 | 0.5705 | 0.5705 | 0.5705 | 184800.0 |
| 2004-07-27 09:20:00 | AAPL | Stock | 0.5704 | 0.5707 | 0.57 | 0.57 | 151368.0 |
| 2004-07-27 09:25:00 | AAPL | Stock | 0.5696 | 0.5696 | 0.5671 | 0.5679 | 291424.0 |
| 2004-07-27 09:30:00 | AAPL | Stock | 0.567 | 0.5684 | 0.5657 | 0.5661 | 10169040.0 |
| 2004-07-27 09:35:00 | AAPL | Stock | 0.5657 | 0.5659 | 0.5638 | 0.5639 | 3330712.0 |
| 2004-07-27 09:40:00 | AAPL | Stock | 0.5639 | 0.5661 | 0.5639 | 0.5655 | 5060104.0 |
| 2004-07-27 09:45:00 | AAPL | Stock | 0.5654 | 0.5688 | 0.5654 | 0.5675 | 4384520.0 |
| 2004-07-27 09:50:00 | AAPL | Stock | 0.5675 | 0.5675 | 0.5654 | 0.5661 | 4958744.0 |
| 2004-07-27 09:55:00 | AAPL | Stock | 0.5661 | 0.5664 | 0.5648 | 0.5654 | 3407712.0 |
| 2004-07-27 10:00:00 | AAPL | Stock | 0.565 | 0.5688 | 0.565 | 0.5684 | 11256224.0 |
| 2004-07-27 10:05:00 | AAPL | Stock | 0.5686 | 0.5727 | 0.568 | 0.5725 | 15453704.0 |
| 2004-07-27 10:10:00 | AAPL | Stock | 0.5727 | 0.5743 | 0.5721 | 0.5739 | 12088608.0 |
| 2004-07-27 10:15:00 | AAPL | Stock | 0.5739 | 0.575 | 0.5729 | 0.5738 | 8070328.0 |
| 2004-07-27 10:20:00 | AAPL | Stock | 0.5736 | 0.5757 | 0.5732 | 0.575 | 10544968.0 |
| 2004-07-27 10:25:00 | AAPL | Stock | 0.575 | 0.5752 | 0.5734 | 0.5748 | 6730976.0 |
| 2004-07-27 10:30:00 | AAPL | Stock | 0.5748 | 0.5748 | 0.5707 | 0.5711 | 10585512.0 |
| 2004-07-27 10:35:00 | AAPL | Stock | 0.5714 | 0.5723 | 0.5679 | 0.5696 | 10786216.0 |
| 2004-07-27 10:40:00 | AAPL | Stock | 0.5698 | 0.5739 | 0.5696 | 0.5739 | 7687736.0 |
| 2004-07-27 10:45:00 | AAPL | Stock | 0.5738 | 0.5738 | 0.5698 | 0.5698 | 7445144.0 |
| 2004-07-27 10:50:00 | AAPL | Stock | 0.5698 | 0.57 | 0.5688 | 0.5689 | 4174072.0 |
| 2004-07-27 10:55:00 | AAPL | Stock | 0.5689 | 0.5705 | 0.5688 | 0.5705 | 5653872.0 |
| 2004-07-27 11:00:00 | AAPL | Stock | 0.5705 | 0.5716 | 0.5688 | 0.5709 | 6933808.0 |
| 2004-07-27 11:05:00 | AAPL | Stock | 0.5711 | 0.5727 | 0.5709 | 0.5723 | 4758656.0 |
| 2004-07-27 11:10:00 | AAPL | Stock | 0.5725 | 0.5729 | 0.5718 | 0.5723 | 3112088.0 |
| 2004-07-27 11:15:00 | AAPL | Stock | 0.5723 | 0.5725 | 0.572 | 0.5725 | 3638600.0 |
| 2004-07-27 11:20:00 | AAPL | Stock | 0.5723 | 0.5729 | 0.5718 | 0.5723 | 7681856.0 |
| 2004-07-27 11:25:00 | AAPL | Stock | 0.5723 | 0.5725 | 0.5718 | 0.5721 | 2897384.0 |
| 2004-07-27 11:30:00 | AAPL | Stock | 0.5723 | 0.5725 | 0.5714 | 0.572 | 2170392.0 |
| 2004-07-27 11:35:00 | AAPL | Stock | 0.5718 | 0.5746 | 0.5716 | 0.5746 | 8395464.0 |
| 2004-07-27 11:40:00 | AAPL | Stock | 0.5743 | 0.5743 | 0.5725 | 0.5727 | 1447768.0 |
| 2004-07-27 11:45:00 | AAPL | Stock | 0.5727 | 0.5736 | 0.5716 | 0.5732 | 2632056.0 |
| 2004-07-27 11:50:00 | AAPL | Stock | 0.5732 | 0.5741 | 0.5727 | 0.5741 | 1519840.0 |
| 2004-07-27 11:55:00 | AAPL | Stock | 0.5738 | 0.5759 | 0.5729 | 0.5752 | 4175304.0 |
| 2004-07-27 12:00:00 | AAPL | Stock | 0.5754 | 0.5779 | 0.5752 | 0.5768 | 4940152.0 |
| 2004-07-27 12:05:00 | AAPL | Stock | 0.5768 | 0.5771 | 0.5763 | 0.577 | 1978480.0 |
| 2004-07-27 12:10:00 | AAPL | Stock | 0.5768 | 0.577 | 0.5761 | 0.5764 | 845544.0 |
| 2004-07-27 12:15:00 | AAPL | Stock | 0.5763 | 0.5773 | 0.5757 | 0.5773 | 3147648.0 |
| 2004-07-27 12:20:00 | AAPL | Stock | 0.5773 | 0.5777 | 0.5768 | 0.5773 | 1425928.0 |
| 2004-07-27 12:25:00 | AAPL | Stock | 0.5772 | 0.5782 | 0.5768 | 0.5775 | 1693384.0 |
> showing 50 of 178,880 rows — these rows as CSV