PREVIEW / stock_5min / 2007-09-04
file: by_date/stock_5min/2007/2007-09-04.parquet size: 4.0 MB rows: 297,480 symbols: 3,105
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-04 09:30:00 | AAPL | Stock | 4.9979 | 5.0714 | 4.9943 | 5.0621 | 55362188.0 |
| 2007-09-04 09:35:00 | AAPL | Stock | 5.0614 | 5.0875 | 5.045 | 5.0771 | 51762788.0 |
| 2007-09-04 09:40:00 | AAPL | Stock | 5.0775 | 5.0821 | 5.0554 | 5.07 | 29138340.0 |
| 2007-09-04 09:45:00 | AAPL | Stock | 5.07 | 5.0821 | 5.0596 | 5.0704 | 27877388.0 |
| 2007-09-04 09:50:00 | AAPL | Stock | 5.0714 | 5.0829 | 5.0629 | 5.0682 | 21484820.0 |
| 2007-09-04 09:55:00 | AAPL | Stock | 5.0682 | 5.0875 | 5.0625 | 5.0723 | 26300960.0 |
| 2007-09-04 10:00:00 | AAPL | Stock | 5.0729 | 5.0929 | 5.0679 | 5.0825 | 26941656.0 |
| 2007-09-04 10:05:00 | AAPL | Stock | 5.0825 | 5.0911 | 5.0721 | 5.0739 | 19858748.0 |
| 2007-09-04 10:10:00 | AAPL | Stock | 5.0743 | 5.085 | 5.0682 | 5.0814 | 17336368.0 |
| 2007-09-04 10:15:00 | AAPL | Stock | 5.0821 | 5.0829 | 5.0707 | 5.0779 | 14263508.0 |
| 2007-09-04 10:20:00 | AAPL | Stock | 5.0786 | 5.0875 | 5.0743 | 5.0789 | 16373308.0 |
| 2007-09-04 10:25:00 | AAPL | Stock | 5.0782 | 5.105 | 5.0779 | 5.0986 | 28087472.0 |
| 2007-09-04 10:30:00 | AAPL | Stock | 5.0986 | 5.1071 | 5.0971 | 5.0993 | 23316020.0 |
| 2007-09-04 10:35:00 | AAPL | Stock | 5.0993 | 5.1169 | 5.0993 | 5.1129 | 24962728.0 |
| 2007-09-04 10:40:00 | AAPL | Stock | 5.1129 | 5.1161 | 5.1043 | 5.1068 | 18204144.0 |
| 2007-09-04 10:45:00 | AAPL | Stock | 5.1068 | 5.1125 | 5.0714 | 5.1029 | 17851176.0 |
| 2007-09-04 10:50:00 | AAPL | Stock | 5.1029 | 5.1107 | 5.1007 | 5.1018 | 12033448.0 |
| 2007-09-04 10:55:00 | AAPL | Stock | 5.1018 | 5.1021 | 5.0946 | 5.0968 | 15915592.0 |
| 2007-09-04 11:00:00 | AAPL | Stock | 5.0968 | 5.0986 | 5.0906 | 5.0957 | 14010052.0 |
| 2007-09-04 11:05:00 | AAPL | Stock | 5.0957 | 5.1107 | 5.095 | 5.1054 | 13609008.0 |
| 2007-09-04 11:10:00 | AAPL | Stock | 5.1054 | 5.1057 | 5.0993 | 5.1018 | 8625456.0 |
| 2007-09-04 11:15:00 | AAPL | Stock | 5.1021 | 5.1064 | 5.1007 | 5.1025 | 7610932.0 |
| 2007-09-04 11:20:00 | AAPL | Stock | 5.1029 | 5.1071 | 5.0986 | 5.1052 | 12471340.0 |
| 2007-09-04 11:25:00 | AAPL | Stock | 5.1039 | 5.1057 | 5.0982 | 5.1039 | 8296008.0 |
| 2007-09-04 11:30:00 | AAPL | Stock | 5.1043 | 5.105 | 5.1021 | 5.1036 | 6190296.0 |
| 2007-09-04 11:35:00 | AAPL | Stock | 5.1036 | 5.1071 | 5.1032 | 5.1068 | 7140280.0 |
| 2007-09-04 11:40:00 | AAPL | Stock | 5.1068 | 5.1089 | 5.0996 | 5.1029 | 11171468.0 |
| 2007-09-04 11:45:00 | AAPL | Stock | 5.1025 | 5.1046 | 5.0954 | 5.0964 | 7626248.0 |
| 2007-09-04 11:50:00 | AAPL | Stock | 5.0961 | 5.1043 | 5.0961 | 5.1036 | 5443060.0 |
| 2007-09-04 11:55:00 | AAPL | Stock | 5.1036 | 5.1043 | 5.0989 | 5.1032 | 4562124.0 |
| 2007-09-04 12:00:00 | AAPL | Stock | 5.1032 | 5.1086 | 5.0979 | 5.0993 | 9324028.0 |
| 2007-09-04 12:05:00 | AAPL | Stock | 5.0986 | 5.1018 | 5.0925 | 5.1014 | 11654384.0 |
| 2007-09-04 12:10:00 | AAPL | Stock | 5.1014 | 5.1032 | 5.0979 | 5.0992 | 7990920.0 |
| 2007-09-04 12:15:00 | AAPL | Stock | 5.0989 | 5.1014 | 5.0957 | 5.0993 | 7446432.0 |
| 2007-09-04 12:20:00 | AAPL | Stock | 5.0993 | 5.1046 | 5.0968 | 5.1021 | 5610332.0 |
| 2007-09-04 12:25:00 | AAPL | Stock | 5.1018 | 5.1054 | 5.1011 | 5.1021 | 5168884.0 |
| 2007-09-04 12:30:00 | AAPL | Stock | 5.1025 | 5.1161 | 5.1014 | 5.115 | 11270196.0 |
| 2007-09-04 12:35:00 | AAPL | Stock | 5.1146 | 5.1207 | 5.1129 | 5.1135 | 12867316.0 |
| 2007-09-04 12:40:00 | AAPL | Stock | 5.1136 | 5.1179 | 5.1114 | 5.1164 | 6102292.0 |
| 2007-09-04 12:45:00 | AAPL | Stock | 5.1168 | 5.1211 | 5.1136 | 5.1157 | 8666532.0 |
| 2007-09-04 12:50:00 | AAPL | Stock | 5.1157 | 5.12 | 5.1143 | 5.1155 | 4060392.0 |
| 2007-09-04 12:55:00 | AAPL | Stock | 5.115 | 5.1157 | 5.1111 | 5.1125 | 6134660.0 |
| 2007-09-04 13:00:00 | AAPL | Stock | 5.1129 | 5.1139 | 5.1089 | 5.1125 | 4580968.0 |
| 2007-09-04 13:05:00 | AAPL | Stock | 5.1125 | 5.1143 | 5.1079 | 5.1118 | 4184684.0 |
| 2007-09-04 13:10:00 | AAPL | Stock | 5.1118 | 5.1193 | 5.1086 | 5.1157 | 8144696.0 |
| 2007-09-04 13:15:00 | AAPL | Stock | 5.1157 | 5.1186 | 5.1129 | 5.1136 | 7383572.0 |
| 2007-09-04 13:20:00 | AAPL | Stock | 5.1129 | 5.1243 | 5.1129 | 5.1214 | 11756808.0 |
| 2007-09-04 13:25:00 | AAPL | Stock | 5.1211 | 5.1304 | 5.1179 | 5.129 | 12471200.0 |
| 2007-09-04 13:30:00 | AAPL | Stock | 5.129 | 5.1346 | 5.1232 | 5.1307 | 11845568.0 |
| 2007-09-04 13:35:00 | AAPL | Stock | 5.1307 | 5.1346 | 5.1261 | 5.1293 | 9867144.0 |
> showing 50 of 297,480 rows — these rows as CSV