PREVIEW / stock_5min / 2005-10-06
file: by_date/stock_5min/2005/2005-10-06.parquet size: 2.9 MB rows: 209,522 symbols: 2,087
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-10-06 07:55:00 | AAPL | Stock | 1.8929 | 1.8929 | 1.8929 | 1.8929 | 42000.0 |
| 2005-10-06 08:00:00 | AAPL | Stock | 1.8929 | 1.9018 | 1.8929 | 1.9018 | 561120.0 |
| 2005-10-06 08:05:00 | AAPL | Stock | 1.9064 | 1.9071 | 1.9018 | 1.9036 | 412300.0 |
| 2005-10-06 08:10:00 | AAPL | Stock | 1.9036 | 1.9036 | 1.8979 | 1.9029 | 205800.0 |
| 2005-10-06 08:15:00 | AAPL | Stock | 1.9029 | 1.9029 | 1.8964 | 1.8964 | 119448.0 |
| 2005-10-06 08:20:00 | AAPL | Stock | 1.9036 | 1.9054 | 1.8979 | 1.9 | 155848.0 |
| 2005-10-06 08:25:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.9018 | 1.9018 | 2800.0 |
| 2005-10-06 08:30:00 | AAPL | Stock | 1.9007 | 1.9018 | 1.9 | 1.9007 | 109200.0 |
| 2005-10-06 08:35:00 | AAPL | Stock | 1.9007 | 1.9018 | 1.9 | 1.9 | 147896.0 |
| 2005-10-06 08:40:00 | AAPL | Stock | 1.9 | 1.9014 | 1.8975 | 1.8982 | 69748.0 |
| 2005-10-06 08:45:00 | AAPL | Stock | 1.8982 | 1.8989 | 1.8975 | 1.8982 | 57652.0 |
| 2005-10-06 08:50:00 | AAPL | Stock | 1.9 | 1.9007 | 1.9 | 1.9007 | 55860.0 |
| 2005-10-06 08:55:00 | AAPL | Stock | 1.9 | 1.9018 | 1.8964 | 1.9018 | 69916.0 |
| 2005-10-06 09:00:00 | AAPL | Stock | 1.8982 | 1.9 | 1.8979 | 1.8979 | 1234884.0 |
| 2005-10-06 09:05:00 | AAPL | Stock | 1.8982 | 1.9 | 1.8982 | 1.9 | 44800.0 |
| 2005-10-06 09:10:00 | AAPL | Stock | 1.9 | 1.9018 | 1.9 | 1.9018 | 36876.0 |
| 2005-10-06 09:15:00 | AAPL | Stock | 1.9 | 1.9018 | 1.9 | 1.9018 | 104636.0 |
| 2005-10-06 09:20:00 | AAPL | Stock | 1.9011 | 1.9018 | 1.9004 | 1.9018 | 161924.0 |
| 2005-10-06 09:25:00 | AAPL | Stock | 1.9004 | 1.9068 | 1.9 | 1.9018 | 971824.0 |
| 2005-10-06 09:30:00 | AAPL | Stock | 1.9 | 1.9104 | 1.9 | 1.9057 | 15640604.0 |
| 2005-10-06 09:35:00 | AAPL | Stock | 1.9032 | 1.9057 | 1.9 | 1.9018 | 10225656.0 |
| 2005-10-06 09:40:00 | AAPL | Stock | 1.9014 | 1.9061 | 1.9007 | 1.9029 | 10116428.0 |
| 2005-10-06 09:45:00 | AAPL | Stock | 1.9029 | 1.9029 | 1.8929 | 1.8936 | 13100108.0 |
| 2005-10-06 09:50:00 | AAPL | Stock | 1.8936 | 1.9011 | 1.8871 | 1.9 | 17290588.0 |
| 2005-10-06 09:55:00 | AAPL | Stock | 1.9004 | 1.905 | 1.8968 | 1.8975 | 8078448.0 |
| 2005-10-06 10:00:00 | AAPL | Stock | 1.8975 | 1.9014 | 1.8957 | 1.8996 | 8512336.0 |
| 2005-10-06 10:05:00 | AAPL | Stock | 1.9 | 1.9 | 1.8911 | 1.8911 | 7784336.0 |
| 2005-10-06 10:10:00 | AAPL | Stock | 1.8914 | 1.8925 | 1.8875 | 1.8904 | 9366224.0 |
| 2005-10-06 10:15:00 | AAPL | Stock | 1.8904 | 1.8907 | 1.8686 | 1.8739 | 18455444.0 |
| 2005-10-06 10:20:00 | AAPL | Stock | 1.8743 | 1.8807 | 1.8721 | 1.8807 | 16996504.0 |
| 2005-10-06 10:25:00 | AAPL | Stock | 1.8804 | 1.8839 | 1.8746 | 1.8811 | 13292524.0 |
| 2005-10-06 10:30:00 | AAPL | Stock | 1.8814 | 1.8911 | 1.8807 | 1.8854 | 14201068.0 |
| 2005-10-06 10:35:00 | AAPL | Stock | 1.885 | 1.8882 | 1.8814 | 1.8836 | 8143856.0 |
| 2005-10-06 10:40:00 | AAPL | Stock | 1.8832 | 1.8964 | 1.8829 | 1.8957 | 9409484.0 |
| 2005-10-06 10:45:00 | AAPL | Stock | 1.895 | 1.8964 | 1.8911 | 1.8936 | 9174256.0 |
| 2005-10-06 10:50:00 | AAPL | Stock | 1.8936 | 1.8946 | 1.8714 | 1.8886 | 5167932.0 |
| 2005-10-06 10:55:00 | AAPL | Stock | 1.8886 | 1.8929 | 1.8846 | 1.8921 | 7846692.0 |
| 2005-10-06 11:00:00 | AAPL | Stock | 1.8918 | 1.8943 | 1.8893 | 1.8907 | 4129552.0 |
| 2005-10-06 11:05:00 | AAPL | Stock | 1.8907 | 1.8982 | 1.8875 | 1.8971 | 7644672.0 |
| 2005-10-06 11:10:00 | AAPL | Stock | 1.8971 | 1.9043 | 1.8929 | 1.9032 | 10114300.0 |
| 2005-10-06 11:15:00 | AAPL | Stock | 1.9032 | 1.9075 | 1.8929 | 1.9075 | 10169264.0 |
| 2005-10-06 11:20:00 | AAPL | Stock | 1.9071 | 1.9079 | 1.8929 | 1.905 | 5928076.0 |
| 2005-10-06 11:25:00 | AAPL | Stock | 1.9054 | 1.9054 | 1.8968 | 1.8968 | 8089536.0 |
| 2005-10-06 11:30:00 | AAPL | Stock | 1.8975 | 1.9014 | 1.8961 | 1.8989 | 2935464.0 |
| 2005-10-06 11:35:00 | AAPL | Stock | 1.8993 | 1.9 | 1.8932 | 1.8954 | 5311012.0 |
| 2005-10-06 11:40:00 | AAPL | Stock | 1.8954 | 1.8968 | 1.8918 | 1.895 | 8385524.0 |
| 2005-10-06 11:45:00 | AAPL | Stock | 1.8946 | 1.8957 | 1.8911 | 1.8932 | 3442740.0 |
| 2005-10-06 11:50:00 | AAPL | Stock | 1.8932 | 1.8932 | 1.8893 | 1.8921 | 2984436.0 |
| 2005-10-06 11:55:00 | AAPL | Stock | 1.8921 | 1.8939 | 1.8886 | 1.8907 | 4345768.0 |
| 2005-10-06 12:00:00 | AAPL | Stock | 1.8904 | 1.896 | 1.8904 | 1.8954 | 2637040.0 |
> showing 50 of 209,522 rows — these rows as CSV