PREVIEW / stock_5min / 2004-08-05
file: by_date/stock_5min/2004/2004-08-05.parquet size: 2.4 MB rows: 175,672 symbols: 1,811
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-08-05 09:10:00 | AAPL | Stock | 0.5677 | 0.5677 | 0.5677 | 0.5677 | 4334400.0 |
| 2004-08-05 09:15:00 | AAPL | Stock | 0.5677 | 0.5677 | 0.5677 | 0.5677 | 4334400.0 |
| 2004-08-05 09:25:00 | AAPL | Stock | 0.5684 | 0.5684 | 0.5679 | 0.5679 | 72800.0 |
| 2004-08-05 09:30:00 | AAPL | Stock | 0.567 | 0.5714 | 0.5661 | 0.5714 | 5478536.0 |
| 2004-08-05 09:35:00 | AAPL | Stock | 0.5716 | 0.5768 | 0.5714 | 0.5755 | 10510528.0 |
| 2004-08-05 09:40:00 | AAPL | Stock | 0.5755 | 0.5759 | 0.5738 | 0.5745 | 2293312.0 |
| 2004-08-05 09:45:00 | AAPL | Stock | 0.5743 | 0.5757 | 0.5741 | 0.575 | 6696816.0 |
| 2004-08-05 09:50:00 | AAPL | Stock | 0.575 | 0.5754 | 0.5741 | 0.5745 | 3266368.0 |
| 2004-08-05 09:55:00 | AAPL | Stock | 0.5746 | 0.5757 | 0.5745 | 0.5755 | 2478000.0 |
| 2004-08-05 10:00:00 | AAPL | Stock | 0.5755 | 0.5768 | 0.5748 | 0.5761 | 8640128.0 |
| 2004-08-05 10:05:00 | AAPL | Stock | 0.5761 | 0.5764 | 0.5757 | 0.5759 | 3385480.0 |
| 2004-08-05 10:10:00 | AAPL | Stock | 0.5759 | 0.5759 | 0.5734 | 0.575 | 3485832.0 |
| 2004-08-05 10:15:00 | AAPL | Stock | 0.5748 | 0.5759 | 0.5739 | 0.5741 | 2323888.0 |
| 2004-08-05 10:20:00 | AAPL | Stock | 0.5745 | 0.5757 | 0.5743 | 0.5752 | 1900192.0 |
| 2004-08-05 10:25:00 | AAPL | Stock | 0.575 | 0.5757 | 0.5746 | 0.5746 | 3728592.0 |
| 2004-08-05 10:30:00 | AAPL | Stock | 0.5745 | 0.5745 | 0.573 | 0.573 | 2502416.0 |
| 2004-08-05 10:35:00 | AAPL | Stock | 0.5729 | 0.5738 | 0.5723 | 0.5729 | 1866704.0 |
| 2004-08-05 10:40:00 | AAPL | Stock | 0.5732 | 0.5752 | 0.5732 | 0.575 | 2638104.0 |
| 2004-08-05 10:45:00 | AAPL | Stock | 0.575 | 0.5757 | 0.5743 | 0.5748 | 2558360.0 |
| 2004-08-05 10:50:00 | AAPL | Stock | 0.575 | 0.5755 | 0.5746 | 0.5746 | 4546360.0 |
| 2004-08-05 10:55:00 | AAPL | Stock | 0.5746 | 0.5748 | 0.5734 | 0.5736 | 1519840.0 |
| 2004-08-05 11:00:00 | AAPL | Stock | 0.5738 | 0.5745 | 0.5736 | 0.5743 | 721840.0 |
| 2004-08-05 11:05:00 | AAPL | Stock | 0.5743 | 0.575 | 0.5743 | 0.5746 | 2213120.0 |
| 2004-08-05 11:10:00 | AAPL | Stock | 0.5745 | 0.5752 | 0.5745 | 0.575 | 2201416.0 |
| 2004-08-05 11:15:00 | AAPL | Stock | 0.5746 | 0.5748 | 0.5743 | 0.5745 | 369600.0 |
| 2004-08-05 11:20:00 | AAPL | Stock | 0.5745 | 0.5746 | 0.5741 | 0.5743 | 1237824.0 |
| 2004-08-05 11:25:00 | AAPL | Stock | 0.5743 | 0.5748 | 0.5741 | 0.5746 | 1549128.0 |
| 2004-08-05 11:30:00 | AAPL | Stock | 0.5746 | 0.5746 | 0.5739 | 0.5741 | 3143280.0 |
| 2004-08-05 11:35:00 | AAPL | Stock | 0.5741 | 0.5741 | 0.5734 | 0.5736 | 1812328.0 |
| 2004-08-05 11:40:00 | AAPL | Stock | 0.5736 | 0.5739 | 0.573 | 0.573 | 3065776.0 |
| 2004-08-05 11:45:00 | AAPL | Stock | 0.573 | 0.575 | 0.5725 | 0.575 | 6951784.0 |
| 2004-08-05 11:50:00 | AAPL | Stock | 0.5746 | 0.5752 | 0.5743 | 0.575 | 2721600.0 |
| 2004-08-05 11:55:00 | AAPL | Stock | 0.575 | 0.5752 | 0.5741 | 0.5741 | 1098328.0 |
| 2004-08-05 12:00:00 | AAPL | Stock | 0.5741 | 0.5748 | 0.5732 | 0.5734 | 3162488.0 |
| 2004-08-05 12:05:00 | AAPL | Stock | 0.5734 | 0.5734 | 0.5714 | 0.5716 | 4786824.0 |
| 2004-08-05 12:10:00 | AAPL | Stock | 0.5716 | 0.5716 | 0.5696 | 0.5696 | 3994088.0 |
| 2004-08-05 12:15:00 | AAPL | Stock | 0.5696 | 0.5718 | 0.5695 | 0.5716 | 3566920.0 |
| 2004-08-05 12:20:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5702 | 0.5702 | 1860432.0 |
| 2004-08-05 12:25:00 | AAPL | Stock | 0.5702 | 0.5705 | 0.5695 | 0.5696 | 1123976.0 |
| 2004-08-05 12:30:00 | AAPL | Stock | 0.5696 | 0.5698 | 0.5689 | 0.5693 | 1803144.0 |
| 2004-08-05 12:35:00 | AAPL | Stock | 0.5693 | 0.5698 | 0.5693 | 0.5695 | 1152648.0 |
| 2004-08-05 12:40:00 | AAPL | Stock | 0.5695 | 0.5695 | 0.5677 | 0.5679 | 2816128.0 |
| 2004-08-05 12:45:00 | AAPL | Stock | 0.5679 | 0.5682 | 0.5677 | 0.5682 | 1372112.0 |
| 2004-08-05 12:50:00 | AAPL | Stock | 0.568 | 0.5689 | 0.568 | 0.5686 | 845600.0 |
| 2004-08-05 12:55:00 | AAPL | Stock | 0.5684 | 0.5691 | 0.5666 | 0.5668 | 6215776.0 |
| 2004-08-05 13:00:00 | AAPL | Stock | 0.5668 | 0.5673 | 0.5668 | 0.5673 | 1853600.0 |
| 2004-08-05 13:05:00 | AAPL | Stock | 0.5671 | 0.5686 | 0.567 | 0.5686 | 2519720.0 |
| 2004-08-05 13:10:00 | AAPL | Stock | 0.568 | 0.5682 | 0.567 | 0.567 | 907200.0 |
| 2004-08-05 13:15:00 | AAPL | Stock | 0.567 | 0.5671 | 0.5668 | 0.5668 | 1108128.0 |
| 2004-08-05 13:20:00 | AAPL | Stock | 0.5668 | 0.567 | 0.5657 | 0.5657 | 2813272.0 |
> showing 50 of 175,672 rows — these rows as CSV