PREVIEW / stock_5min / 2005-09-20
file: by_date/stock_5min/2005/2005-09-20.parquet size: 2.8 MB rows: 205,686 symbols: 2,068
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-20 07:45:00 | AAPL | Stock | 1.8929 | 1.8929 | 1.8929 | 1.8929 | 142800.0 |
| 2005-09-20 08:00:00 | AAPL | Stock | 1.8929 | 1.9036 | 1.8875 | 1.9007 | 781536.0 |
| 2005-09-20 08:05:00 | AAPL | Stock | 1.9004 | 1.9036 | 1.9 | 1.9029 | 741804.0 |
| 2005-09-20 08:10:00 | AAPL | Stock | 1.9021 | 1.9029 | 1.9018 | 1.9025 | 798308.0 |
| 2005-09-20 08:15:00 | AAPL | Stock | 1.9032 | 1.9068 | 1.9032 | 1.9064 | 693336.0 |
| 2005-09-20 08:20:00 | AAPL | Stock | 1.9068 | 1.9068 | 1.9021 | 1.9021 | 453824.0 |
| 2005-09-20 08:25:00 | AAPL | Stock | 1.9021 | 1.9036 | 1.9011 | 1.9036 | 307160.0 |
| 2005-09-20 08:30:00 | AAPL | Stock | 1.9029 | 1.9036 | 1.9018 | 1.9018 | 131096.0 |
| 2005-09-20 08:35:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.9007 | 1.9018 | 117600.0 |
| 2005-09-20 08:40:00 | AAPL | Stock | 1.9004 | 1.9004 | 1.8982 | 1.8993 | 580944.0 |
| 2005-09-20 08:45:00 | AAPL | Stock | 1.8993 | 1.8993 | 1.8982 | 1.8993 | 81200.0 |
| 2005-09-20 08:50:00 | AAPL | Stock | 1.8993 | 1.9029 | 1.8993 | 1.9 | 257600.0 |
| 2005-09-20 08:55:00 | AAPL | Stock | 1.9 | 1.9011 | 1.8993 | 1.8996 | 236152.0 |
| 2005-09-20 09:00:00 | AAPL | Stock | 1.8993 | 1.9 | 1.8982 | 1.9 | 249200.0 |
| 2005-09-20 09:05:00 | AAPL | Stock | 1.9011 | 1.9025 | 1.9004 | 1.9018 | 230216.0 |
| 2005-09-20 09:10:00 | AAPL | Stock | 1.9025 | 1.9025 | 1.8993 | 1.8993 | 399700.0 |
| 2005-09-20 09:15:00 | AAPL | Stock | 1.8979 | 1.8986 | 1.8918 | 1.895 | 499380.0 |
| 2005-09-20 09:20:00 | AAPL | Stock | 1.8936 | 1.8943 | 1.88 | 1.8921 | 396172.0 |
| 2005-09-20 09:25:00 | AAPL | Stock | 1.8882 | 1.8961 | 1.8868 | 1.8925 | 875924.0 |
| 2005-09-20 09:30:00 | AAPL | Stock | 1.8925 | 1.9068 | 1.8914 | 1.9043 | 33756968.0 |
| 2005-09-20 09:35:00 | AAPL | Stock | 1.9036 | 1.9046 | 1.8961 | 1.9004 | 16169440.0 |
| 2005-09-20 09:40:00 | AAPL | Stock | 1.8996 | 1.9004 | 1.8925 | 1.8968 | 14875056.0 |
| 2005-09-20 09:45:00 | AAPL | Stock | 1.8971 | 1.9032 | 1.8943 | 1.9029 | 11562488.0 |
| 2005-09-20 09:50:00 | AAPL | Stock | 1.9025 | 1.9039 | 1.8979 | 1.8996 | 9668344.0 |
| 2005-09-20 09:55:00 | AAPL | Stock | 1.8989 | 1.9021 | 1.8975 | 1.9 | 10728228.0 |
| 2005-09-20 10:00:00 | AAPL | Stock | 1.9 | 1.9057 | 1.8982 | 1.9 | 13657672.0 |
| 2005-09-20 10:05:00 | AAPL | Stock | 1.8996 | 1.9014 | 1.8964 | 1.8986 | 13674108.0 |
| 2005-09-20 10:10:00 | AAPL | Stock | 1.8986 | 1.9071 | 1.8979 | 1.9061 | 18570272.0 |
| 2005-09-20 10:15:00 | AAPL | Stock | 1.9061 | 1.9136 | 1.9057 | 1.9114 | 28597212.0 |
| 2005-09-20 10:20:00 | AAPL | Stock | 1.9114 | 1.9139 | 1.9079 | 1.9129 | 8845956.0 |
| 2005-09-20 10:25:00 | AAPL | Stock | 1.9136 | 1.9164 | 1.9107 | 1.9139 | 11478292.0 |
| 2005-09-20 10:30:00 | AAPL | Stock | 1.9136 | 1.9168 | 1.9132 | 1.9168 | 12957028.0 |
| 2005-09-20 10:35:00 | AAPL | Stock | 1.9164 | 1.9218 | 1.9157 | 1.9186 | 10655988.0 |
| 2005-09-20 10:40:00 | AAPL | Stock | 1.9186 | 1.9204 | 1.9125 | 1.9143 | 10822280.0 |
| 2005-09-20 10:45:00 | AAPL | Stock | 1.9146 | 1.9168 | 1.9136 | 1.9157 | 7516824.0 |
| 2005-09-20 10:50:00 | AAPL | Stock | 1.9157 | 1.9193 | 1.9154 | 1.9189 | 9034116.0 |
| 2005-09-20 10:55:00 | AAPL | Stock | 1.9189 | 1.9193 | 1.9139 | 1.9146 | 8362956.0 |
| 2005-09-20 11:00:00 | AAPL | Stock | 1.9146 | 1.9146 | 1.9093 | 1.9111 | 10851400.0 |
| 2005-09-20 11:05:00 | AAPL | Stock | 1.9118 | 1.9154 | 1.9111 | 1.9129 | 4478768.0 |
| 2005-09-20 11:10:00 | AAPL | Stock | 1.9139 | 1.9154 | 1.9129 | 1.915 | 2285192.0 |
| 2005-09-20 11:15:00 | AAPL | Stock | 1.9143 | 1.9204 | 1.9143 | 1.9193 | 9338392.0 |
| 2005-09-20 11:20:00 | AAPL | Stock | 1.9189 | 1.9193 | 1.9125 | 1.9164 | 3774064.0 |
| 2005-09-20 11:25:00 | AAPL | Stock | 1.9168 | 1.9182 | 1.9161 | 1.9182 | 2361184.0 |
| 2005-09-20 11:30:00 | AAPL | Stock | 1.9182 | 1.9207 | 1.9175 | 1.92 | 5049996.0 |
| 2005-09-20 11:35:00 | AAPL | Stock | 1.9204 | 1.9204 | 1.9171 | 1.9175 | 2932496.0 |
| 2005-09-20 11:40:00 | AAPL | Stock | 1.9182 | 1.9204 | 1.9175 | 1.92 | 2409708.0 |
| 2005-09-20 11:45:00 | AAPL | Stock | 1.92 | 1.9207 | 1.9175 | 1.9179 | 5455968.0 |
| 2005-09-20 11:50:00 | AAPL | Stock | 1.9179 | 1.9189 | 1.9164 | 1.9182 | 2109296.0 |
| 2005-09-20 11:55:00 | AAPL | Stock | 1.9182 | 1.9186 | 1.9161 | 1.9161 | 2452184.0 |
| 2005-09-20 12:00:00 | AAPL | Stock | 1.9161 | 1.9164 | 1.9136 | 1.915 | 5224548.0 |
> showing 50 of 205,686 rows — these rows as CSV