PREVIEW / stock_5min / 2006-07-18
file: by_date/stock_5min/2006/2006-07-18.parquet size: 3.1 MB rows: 225,429 symbols: 2,312
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-18 07:15:00 | AAPL | Stock | 1.8768 | 1.8768 | 1.8768 | 1.8768 | 64400.0 |
| 2006-07-18 07:30:00 | AAPL | Stock | 1.8786 | 1.8786 | 1.8786 | 1.8786 | 2800.0 |
| 2006-07-18 07:35:00 | AAPL | Stock | 1.8839 | 1.8839 | 1.8818 | 1.8818 | 61600.0 |
| 2006-07-18 07:50:00 | AAPL | Stock | 1.8839 | 1.8839 | 1.8839 | 1.8839 | 2800.0 |
| 2006-07-18 07:55:00 | AAPL | Stock | 1.8839 | 1.8893 | 1.8839 | 1.8893 | 30800.0 |
| 2006-07-18 08:00:00 | AAPL | Stock | 1.8896 | 1.9036 | 1.8896 | 1.8929 | 917784.0 |
| 2006-07-18 08:05:00 | AAPL | Stock | 1.8929 | 1.8961 | 1.8911 | 1.8914 | 150164.0 |
| 2006-07-18 08:10:00 | AAPL | Stock | 1.8914 | 1.8914 | 1.8864 | 1.8868 | 203896.0 |
| 2006-07-18 08:15:00 | AAPL | Stock | 1.8868 | 1.8893 | 1.8864 | 1.8882 | 95116.0 |
| 2006-07-18 08:20:00 | AAPL | Stock | 1.8864 | 1.89 | 1.8864 | 1.8893 | 34720.0 |
| 2006-07-18 08:25:00 | AAPL | Stock | 1.89 | 1.8921 | 1.8889 | 1.8921 | 260596.0 |
| 2006-07-18 08:30:00 | AAPL | Stock | 1.89 | 1.89 | 1.8839 | 1.8875 | 275828.0 |
| 2006-07-18 08:35:00 | AAPL | Stock | 1.8846 | 1.89 | 1.8825 | 1.89 | 195720.0 |
| 2006-07-18 08:40:00 | AAPL | Stock | 1.8893 | 1.8921 | 1.8875 | 1.89 | 182000.0 |
| 2006-07-18 08:45:00 | AAPL | Stock | 1.8868 | 1.8893 | 1.8857 | 1.8879 | 148820.0 |
| 2006-07-18 08:50:00 | AAPL | Stock | 1.8857 | 1.8879 | 1.8839 | 1.8854 | 276360.0 |
| 2006-07-18 08:55:00 | AAPL | Stock | 1.8857 | 1.8868 | 1.8854 | 1.8854 | 117600.0 |
| 2006-07-18 09:00:00 | AAPL | Stock | 1.8839 | 1.8839 | 1.8821 | 1.8836 | 223636.0 |
| 2006-07-18 09:05:00 | AAPL | Stock | 1.8821 | 1.8868 | 1.8821 | 1.8843 | 891660.0 |
| 2006-07-18 09:10:00 | AAPL | Stock | 1.8854 | 1.8911 | 1.8854 | 1.8911 | 432600.0 |
| 2006-07-18 09:15:00 | AAPL | Stock | 1.8896 | 1.8932 | 1.8889 | 1.8918 | 594160.0 |
| 2006-07-18 09:20:00 | AAPL | Stock | 1.8911 | 1.8943 | 1.8907 | 1.8907 | 883960.0 |
| 2006-07-18 09:25:00 | AAPL | Stock | 1.8907 | 1.9018 | 1.89 | 1.8996 | 2305660.0 |
| 2006-07-18 09:30:00 | AAPL | Stock | 1.8986 | 1.9175 | 1.8929 | 1.9114 | 54282340.0 |
| 2006-07-18 09:35:00 | AAPL | Stock | 1.9111 | 1.9232 | 1.9093 | 1.9171 | 40939080.0 |
| 2006-07-18 09:40:00 | AAPL | Stock | 1.9171 | 1.9175 | 1.9018 | 1.9071 | 25751572.0 |
| 2006-07-18 09:45:00 | AAPL | Stock | 1.9075 | 1.9121 | 1.9036 | 1.9071 | 20464808.0 |
| 2006-07-18 09:50:00 | AAPL | Stock | 1.9071 | 1.9082 | 1.8957 | 1.9046 | 23579556.0 |
| 2006-07-18 09:55:00 | AAPL | Stock | 1.9046 | 1.9086 | 1.9039 | 1.9053 | 17449348.0 |
| 2006-07-18 10:00:00 | AAPL | Stock | 1.9043 | 1.905 | 1.8871 | 1.8904 | 22287216.0 |
| 2006-07-18 10:05:00 | AAPL | Stock | 1.89 | 1.8929 | 1.8864 | 1.8893 | 14527940.0 |
| 2006-07-18 10:10:00 | AAPL | Stock | 1.8893 | 1.8954 | 1.8846 | 1.8943 | 17851456.0 |
| 2006-07-18 10:15:00 | AAPL | Stock | 1.8943 | 1.8964 | 1.8871 | 1.8911 | 14918596.0 |
| 2006-07-18 10:20:00 | AAPL | Stock | 1.8911 | 1.9036 | 1.8886 | 1.8982 | 19818120.0 |
| 2006-07-18 10:25:00 | AAPL | Stock | 1.8971 | 1.9014 | 1.8936 | 1.8964 | 10386152.0 |
| 2006-07-18 10:30:00 | AAPL | Stock | 1.8957 | 1.9021 | 1.8936 | 1.8964 | 16234624.0 |
| 2006-07-18 10:35:00 | AAPL | Stock | 1.8964 | 1.8982 | 1.8896 | 1.8932 | 13146700.0 |
| 2006-07-18 10:40:00 | AAPL | Stock | 1.8932 | 1.8968 | 1.8875 | 1.8918 | 13213536.0 |
| 2006-07-18 10:45:00 | AAPL | Stock | 1.8918 | 1.8975 | 1.8893 | 1.8911 | 8163288.0 |
| 2006-07-18 10:50:00 | AAPL | Stock | 1.8911 | 1.8911 | 1.8864 | 1.8904 | 7475468.0 |
| 2006-07-18 10:55:00 | AAPL | Stock | 1.8904 | 1.8918 | 1.8864 | 1.8896 | 11160828.0 |
| 2006-07-18 11:00:00 | AAPL | Stock | 1.8896 | 1.8907 | 1.8796 | 1.8839 | 16615592.0 |
| 2006-07-18 11:05:00 | AAPL | Stock | 1.8839 | 1.8868 | 1.88 | 1.8846 | 9538620.0 |
| 2006-07-18 11:10:00 | AAPL | Stock | 1.8843 | 1.8864 | 1.88 | 1.8818 | 5683748.0 |
| 2006-07-18 11:15:00 | AAPL | Stock | 1.8818 | 1.8857 | 1.8786 | 1.8846 | 7299068.0 |
| 2006-07-18 11:20:00 | AAPL | Stock | 1.8846 | 1.8868 | 1.8807 | 1.8814 | 7430360.0 |
| 2006-07-18 11:25:00 | AAPL | Stock | 1.8811 | 1.8893 | 1.8811 | 1.8861 | 9260328.0 |
| 2006-07-18 11:30:00 | AAPL | Stock | 1.8864 | 1.8929 | 1.8861 | 1.8921 | 10593940.0 |
| 2006-07-18 11:35:00 | AAPL | Stock | 1.8925 | 1.8936 | 1.8893 | 1.8932 | 9997120.0 |
| 2006-07-18 11:40:00 | AAPL | Stock | 1.8932 | 1.8946 | 1.8907 | 1.8936 | 7633864.0 |
> showing 50 of 225,429 rows — these rows as CSV