PREVIEW / stock_5min / 2005-01-03
file: by_date/stock_5min/2005/2005-01-03.parquet size: 2.8 MB rows: 198,478 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 |
|---|---|---|---|---|---|---|---|
| 2005-01-03 08:00:00 | AAPL | Stock | 1.1607 | 1.1661 | 1.1518 | 1.1661 | 521864.0 |
| 2005-01-03 08:05:00 | AAPL | Stock | 1.1645 | 1.1645 | 1.1634 | 1.1643 | 184800.0 |
| 2005-01-03 08:10:00 | AAPL | Stock | 1.1634 | 1.1634 | 1.1625 | 1.1625 | 123200.0 |
| 2005-01-03 08:15:00 | AAPL | Stock | 1.1625 | 1.1625 | 1.1623 | 1.1625 | 336000.0 |
| 2005-01-03 08:20:00 | AAPL | Stock | 1.1629 | 1.1643 | 1.1625 | 1.1641 | 292320.0 |
| 2005-01-03 08:25:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.1625 | 1.1625 | 253232.0 |
| 2005-01-03 08:30:00 | AAPL | Stock | 1.1625 | 1.1643 | 1.1625 | 1.1643 | 561400.0 |
| 2005-01-03 08:35:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.1627 | 1.1634 | 369600.0 |
| 2005-01-03 08:40:00 | AAPL | Stock | 1.1634 | 1.1643 | 1.1634 | 1.1643 | 2615200.0 |
| 2005-01-03 08:45:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.1625 | 1.1625 | 463960.0 |
| 2005-01-03 08:50:00 | AAPL | Stock | 1.1625 | 1.1634 | 1.1611 | 1.1611 | 103600.0 |
| 2005-01-03 08:55:00 | AAPL | Stock | 1.1611 | 1.1611 | 1.1607 | 1.1607 | 85400.0 |
| 2005-01-03 09:00:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1607 | 1.1607 | 61600.0 |
| 2005-01-03 09:05:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1607 | 1.1607 | 64400.0 |
| 2005-01-03 09:15:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1607 | 1.1607 | 56000.0 |
| 2005-01-03 09:20:00 | AAPL | Stock | 1.1571 | 1.1571 | 1.1571 | 1.1571 | 43792.0 |
| 2005-01-03 09:25:00 | AAPL | Stock | 1.152 | 1.1616 | 1.152 | 1.157 | 1203496.0 |
| 2005-01-03 09:30:00 | AAPL | Stock | 1.1568 | 1.1627 | 1.153 | 1.1536 | 36529248.0 |
| 2005-01-03 09:35:00 | AAPL | Stock | 1.1536 | 1.1559 | 1.1318 | 1.1348 | 43858248.0 |
| 2005-01-03 09:40:00 | AAPL | Stock | 1.1352 | 1.1391 | 1.1305 | 1.1352 | 39877040.0 |
| 2005-01-03 09:45:00 | AAPL | Stock | 1.1357 | 1.1388 | 1.1346 | 1.138 | 17175200.0 |
| 2005-01-03 09:50:00 | AAPL | Stock | 1.1371 | 1.1382 | 1.1318 | 1.1325 | 13466152.0 |
| 2005-01-03 09:55:00 | AAPL | Stock | 1.1327 | 1.1359 | 1.1277 | 1.1357 | 30821336.0 |
| 2005-01-03 10:00:00 | AAPL | Stock | 1.1361 | 1.1384 | 1.1307 | 1.133 | 18129104.0 |
| 2005-01-03 10:05:00 | AAPL | Stock | 1.1329 | 1.1345 | 1.1298 | 1.1345 | 10406256.0 |
| 2005-01-03 10:10:00 | AAPL | Stock | 1.1346 | 1.1371 | 1.1332 | 1.1346 | 8768144.0 |
| 2005-01-03 10:15:00 | AAPL | Stock | 1.1348 | 1.1348 | 1.1293 | 1.1296 | 12504800.0 |
| 2005-01-03 10:20:00 | AAPL | Stock | 1.1296 | 1.1321 | 1.1277 | 1.1288 | 15232840.0 |
| 2005-01-03 10:25:00 | AAPL | Stock | 1.1286 | 1.1291 | 1.1205 | 1.1255 | 28337064.0 |
| 2005-01-03 10:30:00 | AAPL | Stock | 1.1255 | 1.1257 | 1.1209 | 1.1214 | 15382024.0 |
| 2005-01-03 10:35:00 | AAPL | Stock | 1.1213 | 1.1223 | 1.1179 | 1.1198 | 18895128.0 |
| 2005-01-03 10:40:00 | AAPL | Stock | 1.1198 | 1.123 | 1.1186 | 1.1213 | 11945416.0 |
| 2005-01-03 10:45:00 | AAPL | Stock | 1.1213 | 1.1255 | 1.1193 | 1.1248 | 11372648.0 |
| 2005-01-03 10:50:00 | AAPL | Stock | 1.1248 | 1.1271 | 1.1225 | 1.1259 | 15171408.0 |
| 2005-01-03 10:55:00 | AAPL | Stock | 1.1261 | 1.1279 | 1.125 | 1.1266 | 14790160.0 |
| 2005-01-03 11:00:00 | AAPL | Stock | 1.1263 | 1.1266 | 1.1214 | 1.1218 | 12435416.0 |
| 2005-01-03 11:05:00 | AAPL | Stock | 1.1218 | 1.1238 | 1.1216 | 1.1236 | 6967296.0 |
| 2005-01-03 11:10:00 | AAPL | Stock | 1.1238 | 1.127 | 1.1234 | 1.1255 | 8698088.0 |
| 2005-01-03 11:15:00 | AAPL | Stock | 1.1255 | 1.1261 | 1.1248 | 1.1257 | 6153616.0 |
| 2005-01-03 11:20:00 | AAPL | Stock | 1.1259 | 1.1286 | 1.1257 | 1.1277 | 5357128.0 |
| 2005-01-03 11:25:00 | AAPL | Stock | 1.1277 | 1.1293 | 1.1264 | 1.1293 | 4161864.0 |
| 2005-01-03 11:30:00 | AAPL | Stock | 1.1292 | 1.1307 | 1.1275 | 1.1307 | 5325768.0 |
| 2005-01-03 11:35:00 | AAPL | Stock | 1.1305 | 1.132 | 1.1286 | 1.13 | 8143240.0 |
| 2005-01-03 11:40:00 | AAPL | Stock | 1.1298 | 1.1327 | 1.1298 | 1.1327 | 5616184.0 |
| 2005-01-03 11:45:00 | AAPL | Stock | 1.1327 | 1.1334 | 1.1318 | 1.1334 | 6325312.0 |
| 2005-01-03 11:50:00 | AAPL | Stock | 1.1334 | 1.1348 | 1.1329 | 1.133 | 4898208.0 |
| 2005-01-03 11:55:00 | AAPL | Stock | 1.1329 | 1.133 | 1.13 | 1.1314 | 6081656.0 |
| 2005-01-03 12:00:00 | AAPL | Stock | 1.1314 | 1.1318 | 1.1298 | 1.1304 | 3589992.0 |
| 2005-01-03 12:05:00 | AAPL | Stock | 1.1304 | 1.1339 | 1.13 | 1.1327 | 2588656.0 |
| 2005-01-03 12:10:00 | AAPL | Stock | 1.1329 | 1.1329 | 1.1309 | 1.1314 | 1722728.0 |
> showing 50 of 198,478 rows — these rows as CSV