PREVIEW / stock_5min / 2005-09-21
file: by_date/stock_5min/2005/2005-09-21.parquet size: 2.9 MB rows: 208,024 symbols: 2,071
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-09-21 08:05:00 | AAPL | Stock | 1.9 | 1.9004 | 1.9 | 1.9 | 145600.0 |
| 2005-09-21 08:10:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 14000.0 |
| 2005-09-21 08:15:00 | AAPL | Stock | 1.9 | 1.9 | 1.8996 | 1.9 | 117600.0 |
| 2005-09-21 08:20:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 25200.0 |
| 2005-09-21 08:25:00 | AAPL | Stock | 1.9 | 1.9 | 1.8929 | 1.8929 | 169400.0 |
| 2005-09-21 08:30:00 | AAPL | Stock | 1.8975 | 1.8975 | 1.8918 | 1.8929 | 155344.0 |
| 2005-09-21 08:35:00 | AAPL | Stock | 1.8929 | 1.8932 | 1.8929 | 1.8929 | 61600.0 |
| 2005-09-21 08:40:00 | AAPL | Stock | 1.8932 | 1.8946 | 1.8929 | 1.8936 | 16800.0 |
| 2005-09-21 08:45:00 | AAPL | Stock | 1.8893 | 1.8929 | 1.8893 | 1.8929 | 5600.0 |
| 2005-09-21 08:50:00 | AAPL | Stock | 1.8871 | 1.8871 | 1.8871 | 1.8871 | 2800.0 |
| 2005-09-21 08:55:00 | AAPL | Stock | 1.8893 | 1.8911 | 1.8893 | 1.8911 | 15400.0 |
| 2005-09-21 09:00:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8893 | 1.8893 | 5600.0 |
| 2005-09-21 09:05:00 | AAPL | Stock | 1.8879 | 1.8904 | 1.8879 | 1.8893 | 103600.0 |
| 2005-09-21 09:10:00 | AAPL | Stock | 1.8893 | 1.8904 | 1.8893 | 1.89 | 39200.0 |
| 2005-09-21 09:15:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8893 | 1.8893 | 35952.0 |
| 2005-09-21 09:20:00 | AAPL | Stock | 1.8911 | 1.8911 | 1.89 | 1.8911 | 44800.0 |
| 2005-09-21 09:25:00 | AAPL | Stock | 1.8943 | 1.8943 | 1.8893 | 1.8925 | 215432.0 |
| 2005-09-21 09:30:00 | AAPL | Stock | 1.8914 | 1.8946 | 1.8768 | 1.8775 | 19480720.0 |
| 2005-09-21 09:35:00 | AAPL | Stock | 1.8768 | 1.8857 | 1.8711 | 1.8836 | 17748248.0 |
| 2005-09-21 09:40:00 | AAPL | Stock | 1.8839 | 1.8843 | 1.8714 | 1.8725 | 10886064.0 |
| 2005-09-21 09:45:00 | AAPL | Stock | 1.8725 | 1.8825 | 1.8707 | 1.8793 | 6902336.0 |
| 2005-09-21 09:50:00 | AAPL | Stock | 1.879 | 1.8871 | 1.8786 | 1.8871 | 9668624.0 |
| 2005-09-21 09:55:00 | AAPL | Stock | 1.8864 | 1.8929 | 1.8861 | 1.8879 | 8891204.0 |
| 2005-09-21 10:00:00 | AAPL | Stock | 1.8875 | 1.8889 | 1.8854 | 1.8875 | 5774328.0 |
| 2005-09-21 10:05:00 | AAPL | Stock | 1.8871 | 1.8875 | 1.8821 | 1.8821 | 5762904.0 |
| 2005-09-21 10:10:00 | AAPL | Stock | 1.8821 | 1.8832 | 1.88 | 1.8829 | 10143028.0 |
| 2005-09-21 10:15:00 | AAPL | Stock | 1.8829 | 1.8893 | 1.8825 | 1.8864 | 5959800.0 |
| 2005-09-21 10:20:00 | AAPL | Stock | 1.8864 | 1.8893 | 1.8846 | 1.8871 | 3552024.0 |
| 2005-09-21 10:25:00 | AAPL | Stock | 1.8871 | 1.8871 | 1.8825 | 1.8846 | 3530744.0 |
| 2005-09-21 10:30:00 | AAPL | Stock | 1.8846 | 1.8914 | 1.8825 | 1.8893 | 6206788.0 |
| 2005-09-21 10:35:00 | AAPL | Stock | 1.8896 | 1.8907 | 1.8871 | 1.8896 | 5842984.0 |
| 2005-09-21 10:40:00 | AAPL | Stock | 1.8893 | 1.8925 | 1.8882 | 1.8921 | 5164684.0 |
| 2005-09-21 10:45:00 | AAPL | Stock | 1.8921 | 1.8925 | 1.8893 | 1.8904 | 3469340.0 |
| 2005-09-21 10:50:00 | AAPL | Stock | 1.89 | 1.8925 | 1.8893 | 1.8918 | 4564448.0 |
| 2005-09-21 10:55:00 | AAPL | Stock | 1.8914 | 1.8939 | 1.8879 | 1.8886 | 9004296.0 |
| 2005-09-21 11:00:00 | AAPL | Stock | 1.8886 | 1.8893 | 1.8804 | 1.8814 | 7377020.0 |
| 2005-09-21 11:05:00 | AAPL | Stock | 1.8811 | 1.8843 | 1.8811 | 1.8825 | 4795140.0 |
| 2005-09-21 11:10:00 | AAPL | Stock | 1.8825 | 1.8836 | 1.8804 | 1.8832 | 3357312.0 |
| 2005-09-21 11:15:00 | AAPL | Stock | 1.8829 | 1.8832 | 1.8754 | 1.8754 | 5807676.0 |
| 2005-09-21 11:20:00 | AAPL | Stock | 1.8757 | 1.8779 | 1.8721 | 1.8757 | 6621104.0 |
| 2005-09-21 11:25:00 | AAPL | Stock | 1.8754 | 1.8757 | 1.8714 | 1.8729 | 4475828.0 |
| 2005-09-21 11:30:00 | AAPL | Stock | 1.8729 | 1.8746 | 1.8721 | 1.8746 | 3176012.0 |
| 2005-09-21 11:35:00 | AAPL | Stock | 1.8743 | 1.875 | 1.8689 | 1.8693 | 5136628.0 |
| 2005-09-21 11:40:00 | AAPL | Stock | 1.8689 | 1.8725 | 1.8689 | 1.8707 | 5142984.0 |
| 2005-09-21 11:45:00 | AAPL | Stock | 1.8707 | 1.8714 | 1.8632 | 1.8661 | 11562516.0 |
| 2005-09-21 11:50:00 | AAPL | Stock | 1.8661 | 1.8661 | 1.8579 | 1.8589 | 6200656.0 |
| 2005-09-21 11:55:00 | AAPL | Stock | 1.8589 | 1.8602 | 1.8546 | 1.8557 | 11028976.0 |
| 2005-09-21 12:00:00 | AAPL | Stock | 1.856 | 1.8564 | 1.8521 | 1.8557 | 6632808.0 |
| 2005-09-21 12:05:00 | AAPL | Stock | 1.8561 | 1.8621 | 1.8554 | 1.86 | 8166508.0 |
| 2005-09-21 12:10:00 | AAPL | Stock | 1.86 | 1.865 | 1.86 | 1.8639 | 4428732.0 |
> showing 50 of 208,024 rows — these rows as CSV