PREVIEW / stock_5min / 2004-12-28
file: by_date/stock_5min/2004/2004-12-28.parquet size: 2.6 MB rows: 187,602 symbols: 1,913
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-28 08:20:00 | AAPL | Stock | 1.1279 | 1.1279 | 1.1279 | 1.1279 | 12320.0 |
| 2004-12-28 08:45:00 | AAPL | Stock | 1.1288 | 1.1288 | 1.1288 | 1.1288 | 26880.0 |
| 2004-12-28 08:50:00 | AAPL | Stock | 1.1286 | 1.1286 | 1.1286 | 1.1286 | 50400.0 |
| 2004-12-28 08:55:00 | AAPL | Stock | 1.1293 | 1.1293 | 1.1293 | 1.1293 | 28000.0 |
| 2004-12-28 09:00:00 | AAPL | Stock | 1.1286 | 1.1286 | 1.1286 | 1.1286 | 28000.0 |
| 2004-12-28 09:05:00 | AAPL | Stock | 1.1289 | 1.1289 | 1.1289 | 1.1289 | 28000.0 |
| 2004-12-28 09:10:00 | AAPL | Stock | 1.1286 | 1.1295 | 1.1286 | 1.1295 | 33600.0 |
| 2004-12-28 09:20:00 | AAPL | Stock | 1.1313 | 1.1313 | 1.1277 | 1.1277 | 65408.0 |
| 2004-12-28 09:25:00 | AAPL | Stock | 1.1277 | 1.1313 | 1.1275 | 1.1313 | 386288.0 |
| 2004-12-28 09:30:00 | AAPL | Stock | 1.1304 | 1.1318 | 1.1232 | 1.1243 | 12340272.0 |
| 2004-12-28 09:35:00 | AAPL | Stock | 1.1243 | 1.1252 | 1.1204 | 1.1225 | 13394528.0 |
| 2004-12-28 09:40:00 | AAPL | Stock | 1.1225 | 1.1265 | 1.1218 | 1.1241 | 7734216.0 |
| 2004-12-28 09:45:00 | AAPL | Stock | 1.1239 | 1.1243 | 1.1216 | 1.1227 | 5025720.0 |
| 2004-12-28 09:50:00 | AAPL | Stock | 1.1225 | 1.1229 | 1.1161 | 1.1184 | 13686176.0 |
| 2004-12-28 09:55:00 | AAPL | Stock | 1.1184 | 1.1196 | 1.1134 | 1.1152 | 18848536.0 |
| 2004-12-28 10:00:00 | AAPL | Stock | 1.1149 | 1.1182 | 1.1143 | 1.117 | 14829024.0 |
| 2004-12-28 10:05:00 | AAPL | Stock | 1.1173 | 1.1179 | 1.1116 | 1.112 | 19381040.0 |
| 2004-12-28 10:10:00 | AAPL | Stock | 1.1118 | 1.1159 | 1.108 | 1.1154 | 23358048.0 |
| 2004-12-28 10:15:00 | AAPL | Stock | 1.1155 | 1.1177 | 1.1141 | 1.1152 | 19748792.0 |
| 2004-12-28 10:20:00 | AAPL | Stock | 1.115 | 1.1163 | 1.1121 | 1.1139 | 11845904.0 |
| 2004-12-28 10:25:00 | AAPL | Stock | 1.1139 | 1.1152 | 1.1125 | 1.1129 | 8984360.0 |
| 2004-12-28 10:30:00 | AAPL | Stock | 1.1132 | 1.1161 | 1.1127 | 1.1152 | 9734368.0 |
| 2004-12-28 10:35:00 | AAPL | Stock | 1.1154 | 1.1171 | 1.1138 | 1.1141 | 8138760.0 |
| 2004-12-28 10:40:00 | AAPL | Stock | 1.1143 | 1.117 | 1.1139 | 1.1166 | 7687848.0 |
| 2004-12-28 10:45:00 | AAPL | Stock | 1.1166 | 1.1168 | 1.1146 | 1.1152 | 6390496.0 |
| 2004-12-28 10:50:00 | AAPL | Stock | 1.1152 | 1.1161 | 1.1141 | 1.1159 | 5616576.0 |
| 2004-12-28 10:55:00 | AAPL | Stock | 1.1159 | 1.1205 | 1.1154 | 1.1198 | 11756024.0 |
| 2004-12-28 11:00:00 | AAPL | Stock | 1.1196 | 1.1205 | 1.118 | 1.1195 | 10944304.0 |
| 2004-12-28 11:05:00 | AAPL | Stock | 1.1189 | 1.1191 | 1.1173 | 1.1173 | 3653552.0 |
| 2004-12-28 11:10:00 | AAPL | Stock | 1.1175 | 1.1195 | 1.117 | 1.1193 | 3011344.0 |
| 2004-12-28 11:15:00 | AAPL | Stock | 1.1189 | 1.1196 | 1.1188 | 1.1189 | 3627960.0 |
| 2004-12-28 11:20:00 | AAPL | Stock | 1.1189 | 1.1209 | 1.1188 | 1.1209 | 5464984.0 |
| 2004-12-28 11:25:00 | AAPL | Stock | 1.1209 | 1.1209 | 1.1177 | 1.1189 | 4953760.0 |
| 2004-12-28 11:30:00 | AAPL | Stock | 1.1188 | 1.1196 | 1.1179 | 1.1179 | 2904776.0 |
| 2004-12-28 11:35:00 | AAPL | Stock | 1.118 | 1.1196 | 1.1161 | 1.1168 | 6145496.0 |
| 2004-12-28 11:40:00 | AAPL | Stock | 1.1166 | 1.118 | 1.1166 | 1.1179 | 1554728.0 |
| 2004-12-28 11:45:00 | AAPL | Stock | 1.1179 | 1.1184 | 1.1172 | 1.1179 | 1783040.0 |
| 2004-12-28 11:50:00 | AAPL | Stock | 1.1177 | 1.1184 | 1.1166 | 1.1168 | 5917744.0 |
| 2004-12-28 11:55:00 | AAPL | Stock | 1.1168 | 1.1188 | 1.1168 | 1.1188 | 7002128.0 |
| 2004-12-28 12:00:00 | AAPL | Stock | 1.1188 | 1.1193 | 1.1182 | 1.1189 | 3959536.0 |
| 2004-12-28 12:05:00 | AAPL | Stock | 1.1189 | 1.1202 | 1.118 | 1.1196 | 4657184.0 |
| 2004-12-28 12:10:00 | AAPL | Stock | 1.1193 | 1.1207 | 1.1182 | 1.1207 | 4302704.0 |
| 2004-12-28 12:15:00 | AAPL | Stock | 1.1204 | 1.1223 | 1.1196 | 1.1223 | 2958536.0 |
| 2004-12-28 12:20:00 | AAPL | Stock | 1.1223 | 1.1246 | 1.1223 | 1.1238 | 9104872.0 |
| 2004-12-28 12:25:00 | AAPL | Stock | 1.1239 | 1.128 | 1.1232 | 1.127 | 8980608.0 |
| 2004-12-28 12:30:00 | AAPL | Stock | 1.1268 | 1.1336 | 1.1264 | 1.133 | 14236152.0 |
| 2004-12-28 12:35:00 | AAPL | Stock | 1.133 | 1.1377 | 1.1325 | 1.137 | 17872680.0 |
| 2004-12-28 12:40:00 | AAPL | Stock | 1.137 | 1.1371 | 1.1338 | 1.1339 | 10098928.0 |
| 2004-12-28 12:45:00 | AAPL | Stock | 1.1343 | 1.1363 | 1.1334 | 1.1363 | 7738864.0 |
| 2004-12-28 12:50:00 | AAPL | Stock | 1.1363 | 1.137 | 1.1334 | 1.1349 | 7280560.0 |
> showing 50 of 187,602 rows — these rows as CSV