PREVIEW / stock_5min / 2004-07-01
file: by_date/stock_5min/2004/2004-07-01.parquet size: 2.5 MB rows: 181,521 symbols: 1,798
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-01 08:00:00 | AAPL | Stock | 0.5732 | 0.5732 | 0.5732 | 0.5732 | 11200.0 |
| 2004-07-01 08:05:00 | AAPL | Stock | 0.5732 | 0.5732 | 0.5732 | 0.5732 | 5600.0 |
| 2004-07-01 08:20:00 | AAPL | Stock | 0.5811 | 0.5811 | 0.5811 | 0.5811 | 179200.0 |
| 2004-07-01 08:35:00 | AAPL | Stock | 0.5789 | 0.5789 | 0.5789 | 0.5789 | 22400.0 |
| 2004-07-01 08:40:00 | AAPL | Stock | 0.5789 | 0.5793 | 0.5789 | 0.5793 | 28000.0 |
| 2004-07-01 09:05:00 | AAPL | Stock | 0.5811 | 0.5811 | 0.5811 | 0.5811 | 156800.0 |
| 2004-07-01 09:10:00 | AAPL | Stock | 0.5811 | 0.5811 | 0.5811 | 0.5811 | 5600.0 |
| 2004-07-01 09:20:00 | AAPL | Stock | 0.5763 | 0.5763 | 0.5763 | 0.5763 | 16800.0 |
| 2004-07-01 09:25:00 | AAPL | Stock | 0.577 | 0.5779 | 0.5739 | 0.5739 | 1039248.0 |
| 2004-07-01 09:30:00 | AAPL | Stock | 0.5729 | 0.5763 | 0.572 | 0.573 | 20046544.0 |
| 2004-07-01 09:35:00 | AAPL | Stock | 0.573 | 0.5743 | 0.572 | 0.5734 | 12248264.0 |
| 2004-07-01 09:40:00 | AAPL | Stock | 0.5736 | 0.5736 | 0.5698 | 0.5704 | 8013432.0 |
| 2004-07-01 09:45:00 | AAPL | Stock | 0.5704 | 0.5714 | 0.5696 | 0.5714 | 6990536.0 |
| 2004-07-01 09:50:00 | AAPL | Stock | 0.5713 | 0.5725 | 0.5713 | 0.572 | 7138600.0 |
| 2004-07-01 09:55:00 | AAPL | Stock | 0.5721 | 0.5741 | 0.5721 | 0.5736 | 4595080.0 |
| 2004-07-01 10:00:00 | AAPL | Stock | 0.5736 | 0.5771 | 0.5736 | 0.5768 | 5551504.0 |
| 2004-07-01 10:05:00 | AAPL | Stock | 0.577 | 0.5786 | 0.5763 | 0.5786 | 7139496.0 |
| 2004-07-01 10:10:00 | AAPL | Stock | 0.5784 | 0.5789 | 0.5766 | 0.5766 | 3474072.0 |
| 2004-07-01 10:15:00 | AAPL | Stock | 0.5766 | 0.5775 | 0.5763 | 0.5775 | 3403064.0 |
| 2004-07-01 10:20:00 | AAPL | Stock | 0.5775 | 0.5777 | 0.5768 | 0.5771 | 3067064.0 |
| 2004-07-01 10:25:00 | AAPL | Stock | 0.5771 | 0.5788 | 0.5771 | 0.5786 | 4816840.0 |
| 2004-07-01 10:30:00 | AAPL | Stock | 0.5786 | 0.5791 | 0.578 | 0.5791 | 5927936.0 |
| 2004-07-01 10:35:00 | AAPL | Stock | 0.5791 | 0.58 | 0.5789 | 0.5789 | 3958472.0 |
| 2004-07-01 10:40:00 | AAPL | Stock | 0.5791 | 0.5795 | 0.5784 | 0.5789 | 2837968.0 |
| 2004-07-01 10:45:00 | AAPL | Stock | 0.5789 | 0.5796 | 0.5789 | 0.5793 | 2020648.0 |
| 2004-07-01 10:50:00 | AAPL | Stock | 0.5793 | 0.58 | 0.5779 | 0.5779 | 3120936.0 |
| 2004-07-01 10:55:00 | AAPL | Stock | 0.5779 | 0.5789 | 0.5775 | 0.5775 | 4006128.0 |
| 2004-07-01 11:00:00 | AAPL | Stock | 0.5775 | 0.5775 | 0.5746 | 0.5752 | 5990208.0 |
| 2004-07-01 11:05:00 | AAPL | Stock | 0.5752 | 0.5755 | 0.5732 | 0.5738 | 5471928.0 |
| 2004-07-01 11:10:00 | AAPL | Stock | 0.5738 | 0.5754 | 0.5727 | 0.5752 | 8036672.0 |
| 2004-07-01 11:15:00 | AAPL | Stock | 0.575 | 0.5761 | 0.5745 | 0.5759 | 6494768.0 |
| 2004-07-01 11:20:00 | AAPL | Stock | 0.5759 | 0.5761 | 0.5748 | 0.5752 | 7211400.0 |
| 2004-07-01 11:25:00 | AAPL | Stock | 0.575 | 0.5761 | 0.5748 | 0.5761 | 3376744.0 |
| 2004-07-01 11:30:00 | AAPL | Stock | 0.5761 | 0.5761 | 0.5748 | 0.5748 | 1970528.0 |
| 2004-07-01 11:35:00 | AAPL | Stock | 0.575 | 0.575 | 0.5739 | 0.5741 | 1888656.0 |
| 2004-07-01 11:40:00 | AAPL | Stock | 0.5741 | 0.5741 | 0.5729 | 0.5736 | 3217088.0 |
| 2004-07-01 11:45:00 | AAPL | Stock | 0.5734 | 0.5734 | 0.5718 | 0.5725 | 1398712.0 |
| 2004-07-01 11:50:00 | AAPL | Stock | 0.5727 | 0.573 | 0.5714 | 0.572 | 3861704.0 |
| 2004-07-01 11:55:00 | AAPL | Stock | 0.572 | 0.5738 | 0.5714 | 0.5727 | 4864608.0 |
| 2004-07-01 12:00:00 | AAPL | Stock | 0.573 | 0.5738 | 0.5727 | 0.5732 | 4975376.0 |
| 2004-07-01 12:05:00 | AAPL | Stock | 0.5734 | 0.5738 | 0.572 | 0.5723 | 3700312.0 |
| 2004-07-01 12:10:00 | AAPL | Stock | 0.5723 | 0.573 | 0.572 | 0.573 | 3851512.0 |
| 2004-07-01 12:15:00 | AAPL | Stock | 0.5729 | 0.5732 | 0.5725 | 0.5732 | 2163448.0 |
| 2004-07-01 12:20:00 | AAPL | Stock | 0.5732 | 0.5736 | 0.573 | 0.5734 | 3702888.0 |
| 2004-07-01 12:25:00 | AAPL | Stock | 0.5736 | 0.5736 | 0.5734 | 0.5734 | 660968.0 |
| 2004-07-01 12:30:00 | AAPL | Stock | 0.5734 | 0.5741 | 0.5734 | 0.5739 | 1750616.0 |
| 2004-07-01 12:35:00 | AAPL | Stock | 0.5741 | 0.5755 | 0.5739 | 0.5755 | 2442832.0 |
| 2004-07-01 12:40:00 | AAPL | Stock | 0.5755 | 0.5755 | 0.5743 | 0.5754 | 1442840.0 |
| 2004-07-01 12:45:00 | AAPL | Stock | 0.5754 | 0.5755 | 0.5754 | 0.5755 | 1019200.0 |
| 2004-07-01 12:50:00 | AAPL | Stock | 0.5754 | 0.5761 | 0.575 | 0.5759 | 2107000.0 |
> showing 50 of 181,521 rows — these rows as CSV