PREVIEW / stock_5min / 2006-11-21
file: by_date/stock_5min/2006/2006-11-21.parquet size: 3.3 MB rows: 237,205 symbols: 2,456
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-11-21 06:35:00 | AAPL | Stock | 3.0907 | 3.0907 | 3.0907 | 3.0907 | 5600.0 |
| 2006-11-21 07:05:00 | AAPL | Stock | 3.0904 | 3.0904 | 3.0904 | 3.0904 | 2800.0 |
| 2006-11-21 07:15:00 | AAPL | Stock | 3.0907 | 3.0907 | 3.0907 | 3.0907 | 8400.0 |
| 2006-11-21 07:55:00 | AAPL | Stock | 3.0946 | 3.0946 | 3.0946 | 3.0946 | 2800.0 |
| 2006-11-21 08:00:00 | AAPL | Stock | 3.0957 | 3.1321 | 3.0946 | 3.1261 | 948220.0 |
| 2006-11-21 08:05:00 | AAPL | Stock | 3.1261 | 3.1271 | 3.1179 | 3.1214 | 394660.0 |
| 2006-11-21 08:10:00 | AAPL | Stock | 3.1189 | 3.125 | 3.1179 | 3.1239 | 460712.0 |
| 2006-11-21 08:15:00 | AAPL | Stock | 3.125 | 3.1371 | 3.125 | 3.1357 | 749364.0 |
| 2006-11-21 08:20:00 | AAPL | Stock | 3.1361 | 3.1446 | 3.1357 | 3.1393 | 1734600.0 |
| 2006-11-21 08:25:00 | AAPL | Stock | 3.1386 | 3.1393 | 3.1286 | 3.1321 | 582876.0 |
| 2006-11-21 08:30:00 | AAPL | Stock | 3.135 | 3.1361 | 3.1325 | 3.1339 | 279300.0 |
| 2006-11-21 08:35:00 | AAPL | Stock | 3.1325 | 3.1325 | 3.1279 | 3.1307 | 454580.0 |
| 2006-11-21 08:40:00 | AAPL | Stock | 3.1318 | 3.1321 | 3.1275 | 3.1286 | 303800.0 |
| 2006-11-21 08:45:00 | AAPL | Stock | 3.1286 | 3.1304 | 3.1268 | 3.1282 | 204204.0 |
| 2006-11-21 08:50:00 | AAPL | Stock | 3.1279 | 3.1286 | 3.125 | 3.125 | 658140.0 |
| 2006-11-21 08:55:00 | AAPL | Stock | 3.125 | 3.1264 | 3.1239 | 3.125 | 140000.0 |
| 2006-11-21 09:00:00 | AAPL | Stock | 3.1264 | 3.1286 | 3.1264 | 3.1286 | 623448.0 |
| 2006-11-21 09:05:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.1268 | 3.1279 | 265244.0 |
| 2006-11-21 09:10:00 | AAPL | Stock | 3.1282 | 3.1286 | 3.1275 | 3.1286 | 611436.0 |
| 2006-11-21 09:15:00 | AAPL | Stock | 3.1279 | 3.1286 | 3.1261 | 3.1268 | 320852.0 |
| 2006-11-21 09:20:00 | AAPL | Stock | 3.1268 | 3.1271 | 3.125 | 3.1271 | 201600.0 |
| 2006-11-21 09:25:00 | AAPL | Stock | 3.1268 | 3.1275 | 3.1186 | 3.1221 | 870968.0 |
| 2006-11-21 09:30:00 | AAPL | Stock | 3.1221 | 3.125 | 3.1121 | 3.1139 | 22825488.0 |
| 2006-11-21 09:35:00 | AAPL | Stock | 3.1139 | 3.1236 | 3.1111 | 3.1196 | 18325552.0 |
| 2006-11-21 09:40:00 | AAPL | Stock | 3.1193 | 3.13 | 3.1193 | 3.1207 | 23944368.0 |
| 2006-11-21 09:45:00 | AAPL | Stock | 3.1211 | 3.1279 | 3.1196 | 3.1207 | 10940720.0 |
| 2006-11-21 09:50:00 | AAPL | Stock | 3.1211 | 3.1286 | 3.1196 | 3.1282 | 12218724.0 |
| 2006-11-21 09:55:00 | AAPL | Stock | 3.1279 | 3.1286 | 3.1196 | 3.1214 | 11493328.0 |
| 2006-11-21 10:00:00 | AAPL | Stock | 3.1218 | 3.1264 | 3.1196 | 3.1246 | 12141528.0 |
| 2006-11-21 10:05:00 | AAPL | Stock | 3.1246 | 3.125 | 3.1218 | 3.1239 | 10199672.0 |
| 2006-11-21 10:10:00 | AAPL | Stock | 3.1239 | 3.1271 | 3.1232 | 3.1261 | 7919156.0 |
| 2006-11-21 10:15:00 | AAPL | Stock | 3.1261 | 3.1379 | 3.1261 | 3.1371 | 16189908.0 |
| 2006-11-21 10:20:00 | AAPL | Stock | 3.1371 | 3.1386 | 3.1332 | 3.1336 | 10473764.0 |
| 2006-11-21 10:25:00 | AAPL | Stock | 3.1336 | 3.1411 | 3.1332 | 3.1371 | 12141276.0 |
| 2006-11-21 10:30:00 | AAPL | Stock | 3.1371 | 3.1411 | 3.1371 | 3.1381 | 8086764.0 |
| 2006-11-21 10:35:00 | AAPL | Stock | 3.1379 | 3.1386 | 3.1314 | 3.1332 | 11938696.0 |
| 2006-11-21 10:40:00 | AAPL | Stock | 3.1332 | 3.1343 | 3.1314 | 3.1336 | 11718308.0 |
| 2006-11-21 10:45:00 | AAPL | Stock | 3.1336 | 3.1343 | 3.1243 | 3.1306 | 15269996.0 |
| 2006-11-21 10:50:00 | AAPL | Stock | 3.1307 | 3.135 | 3.1293 | 3.135 | 5334476.0 |
| 2006-11-21 10:55:00 | AAPL | Stock | 3.135 | 3.1368 | 3.1304 | 3.1343 | 7028028.0 |
| 2006-11-21 11:00:00 | AAPL | Stock | 3.1343 | 3.1346 | 3.1318 | 3.1343 | 4736004.0 |
| 2006-11-21 11:05:00 | AAPL | Stock | 3.1343 | 3.1343 | 3.1304 | 3.1307 | 6877332.0 |
| 2006-11-21 11:10:00 | AAPL | Stock | 3.1307 | 3.1314 | 3.1293 | 3.1304 | 11799536.0 |
| 2006-11-21 11:15:00 | AAPL | Stock | 3.1304 | 3.1307 | 3.1275 | 3.1282 | 9572612.0 |
| 2006-11-21 11:20:00 | AAPL | Stock | 3.1282 | 3.1286 | 3.1232 | 3.1275 | 11172224.0 |
| 2006-11-21 11:25:00 | AAPL | Stock | 3.1275 | 3.1296 | 3.1261 | 3.1296 | 4603956.0 |
| 2006-11-21 11:30:00 | AAPL | Stock | 3.1296 | 3.1296 | 3.1257 | 3.1279 | 5784940.0 |
| 2006-11-21 11:35:00 | AAPL | Stock | 3.1282 | 3.1311 | 3.1282 | 3.1307 | 3693648.0 |
| 2006-11-21 11:40:00 | AAPL | Stock | 3.1304 | 3.135 | 3.1304 | 3.1336 | 6466432.0 |
| 2006-11-21 11:45:00 | AAPL | Stock | 3.1336 | 3.1339 | 3.1321 | 3.1335 | 4255048.0 |
> showing 50 of 237,205 rows — these rows as CSV