PREVIEW / stock_5min / 2006-12-18
file: by_date/stock_5min/2006/2006-12-18.parquet size: 3.4 MB rows: 245,466 symbols: 2,494
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-12-18 06:55:00 | AAPL | Stock | 3.1368 | 3.1368 | 3.1368 | 3.1368 | 5600.0 |
| 2006-12-18 07:00:00 | AAPL | Stock | 3.1411 | 3.1525 | 3.1411 | 3.1525 | 47600.0 |
| 2006-12-18 07:20:00 | AAPL | Stock | 3.1571 | 3.1571 | 3.1571 | 3.1571 | 2800.0 |
| 2006-12-18 07:25:00 | AAPL | Stock | 3.1525 | 3.1525 | 3.1525 | 3.1525 | 2800.0 |
| 2006-12-18 07:35:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1482 | 3.1482 | 28000.0 |
| 2006-12-18 07:45:00 | AAPL | Stock | 3.1514 | 3.1607 | 3.1514 | 3.1607 | 50400.0 |
| 2006-12-18 07:50:00 | AAPL | Stock | 3.1629 | 3.1661 | 3.1629 | 3.1661 | 105000.0 |
| 2006-12-18 07:55:00 | AAPL | Stock | 3.165 | 3.165 | 3.1611 | 3.1611 | 8400.0 |
| 2006-12-18 08:00:00 | AAPL | Stock | 3.1657 | 3.1668 | 3.1536 | 3.1536 | 303688.0 |
| 2006-12-18 08:05:00 | AAPL | Stock | 3.1536 | 3.1543 | 3.1486 | 3.1536 | 193060.0 |
| 2006-12-18 08:10:00 | AAPL | Stock | 3.1536 | 3.1557 | 3.1507 | 3.1557 | 312172.0 |
| 2006-12-18 08:15:00 | AAPL | Stock | 3.1564 | 3.1571 | 3.1536 | 3.1571 | 247408.0 |
| 2006-12-18 08:20:00 | AAPL | Stock | 3.1571 | 3.1575 | 3.1539 | 3.1539 | 93800.0 |
| 2006-12-18 08:25:00 | AAPL | Stock | 3.1529 | 3.1529 | 3.1511 | 3.1518 | 235844.0 |
| 2006-12-18 08:30:00 | AAPL | Stock | 3.1511 | 3.1511 | 3.1489 | 3.1489 | 67340.0 |
| 2006-12-18 08:35:00 | AAPL | Stock | 3.1489 | 3.1493 | 3.1446 | 3.1493 | 213696.0 |
| 2006-12-18 08:40:00 | AAPL | Stock | 3.1464 | 3.15 | 3.1464 | 3.15 | 89180.0 |
| 2006-12-18 08:45:00 | AAPL | Stock | 3.15 | 3.1514 | 3.1443 | 3.1443 | 184800.0 |
| 2006-12-18 08:50:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1479 | 3.1482 | 66052.0 |
| 2006-12-18 08:55:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1464 | 3.1471 | 45080.0 |
| 2006-12-18 09:00:00 | AAPL | Stock | 3.145 | 3.145 | 3.1425 | 3.1429 | 302540.0 |
| 2006-12-18 09:05:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1332 | 3.1357 | 404600.0 |
| 2006-12-18 09:10:00 | AAPL | Stock | 3.1357 | 3.1375 | 3.1321 | 3.1321 | 314916.0 |
| 2006-12-18 09:15:00 | AAPL | Stock | 3.1296 | 3.1329 | 3.1286 | 3.1321 | 172368.0 |
| 2006-12-18 09:20:00 | AAPL | Stock | 3.1321 | 3.1436 | 3.1321 | 3.1396 | 320264.0 |
| 2006-12-18 09:25:00 | AAPL | Stock | 3.1396 | 3.1429 | 3.1271 | 3.1271 | 843444.0 |
| 2006-12-18 09:30:00 | AAPL | Stock | 3.1295 | 3.1429 | 3.1207 | 3.1237 | 19658744.0 |
| 2006-12-18 09:35:00 | AAPL | Stock | 3.1246 | 3.1264 | 3.1018 | 3.1079 | 20559476.0 |
| 2006-12-18 09:40:00 | AAPL | Stock | 3.1077 | 3.125 | 3.1075 | 3.1236 | 11609444.0 |
| 2006-12-18 09:45:00 | AAPL | Stock | 3.1234 | 3.1261 | 3.1104 | 3.1136 | 10441116.0 |
| 2006-12-18 09:50:00 | AAPL | Stock | 3.1129 | 3.1314 | 3.1121 | 3.1268 | 10692920.0 |
| 2006-12-18 09:55:00 | AAPL | Stock | 3.1268 | 3.135 | 3.1254 | 3.1301 | 10269084.0 |
| 2006-12-18 10:00:00 | AAPL | Stock | 3.1304 | 3.1371 | 3.13 | 3.1321 | 10768072.0 |
| 2006-12-18 10:05:00 | AAPL | Stock | 3.1325 | 3.1325 | 3.1193 | 3.1221 | 8892940.0 |
| 2006-12-18 10:10:00 | AAPL | Stock | 3.1218 | 3.1271 | 3.1182 | 3.1236 | 8365252.0 |
| 2006-12-18 10:15:00 | AAPL | Stock | 3.1239 | 3.1321 | 3.1236 | 3.1293 | 5868156.0 |
| 2006-12-18 10:20:00 | AAPL | Stock | 3.1293 | 3.13 | 3.1229 | 3.125 | 4690980.0 |
| 2006-12-18 10:25:00 | AAPL | Stock | 3.1246 | 3.1257 | 3.1154 | 3.1154 | 7404096.0 |
| 2006-12-18 10:30:00 | AAPL | Stock | 3.1154 | 3.1179 | 3.1114 | 3.1161 | 9097872.0 |
| 2006-12-18 10:35:00 | AAPL | Stock | 3.1161 | 3.1161 | 3.1107 | 3.1114 | 6876324.0 |
| 2006-12-18 10:40:00 | AAPL | Stock | 3.1111 | 3.1132 | 3.1046 | 3.1074 | 11518892.0 |
| 2006-12-18 10:45:00 | AAPL | Stock | 3.1075 | 3.1075 | 3.0954 | 3.0979 | 13355524.0 |
| 2006-12-18 10:50:00 | AAPL | Stock | 3.0979 | 3.1054 | 3.0964 | 3.1043 | 9463496.0 |
| 2006-12-18 10:55:00 | AAPL | Stock | 3.1043 | 3.1096 | 3.1032 | 3.1054 | 9453332.0 |
| 2006-12-18 11:00:00 | AAPL | Stock | 3.1054 | 3.1086 | 3.0971 | 3.0979 | 8057336.0 |
| 2006-12-18 11:05:00 | AAPL | Stock | 3.0975 | 3.1018 | 3.0918 | 3.1007 | 10778852.0 |
| 2006-12-18 11:10:00 | AAPL | Stock | 3.1007 | 3.1068 | 3.0971 | 3.1064 | 5658100.0 |
| 2006-12-18 11:15:00 | AAPL | Stock | 3.1064 | 3.1075 | 3.1007 | 3.1011 | 5455408.0 |
| 2006-12-18 11:20:00 | AAPL | Stock | 3.1011 | 3.1064 | 3.0975 | 3.1057 | 5108768.0 |
| 2006-12-18 11:25:00 | AAPL | Stock | 3.1059 | 3.1063 | 3.0993 | 3.1006 | 4423692.0 |
> showing 50 of 245,466 rows — these rows as CSV