PREVIEW / stock_5min / 2006-07-21
file: by_date/stock_5min/2006/2006-07-21.parquet size: 3.1 MB rows: 223,800 symbols: 2,297
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-07-21 04:05:00 | AAPL | Stock | 2.1679 | 2.1679 | 2.1679 | 2.1679 | 29400.0 |
| 2006-07-21 04:10:00 | AAPL | Stock | 2.1643 | 2.1643 | 2.1643 | 2.1643 | 39200.0 |
| 2006-07-21 04:25:00 | AAPL | Stock | 2.1625 | 2.1625 | 2.1625 | 2.1625 | 8400.0 |
| 2006-07-21 04:45:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1571 | 2.1571 | 36400.0 |
| 2006-07-21 04:55:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1571 | 2.1571 | 28000.0 |
| 2006-07-21 07:30:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1571 | 2.1571 | 19376.0 |
| 2006-07-21 07:40:00 | AAPL | Stock | 2.1536 | 2.1536 | 2.1536 | 2.1536 | 28000.0 |
| 2006-07-21 07:45:00 | AAPL | Stock | 2.1518 | 2.1518 | 2.1504 | 2.1504 | 22988.0 |
| 2006-07-21 07:50:00 | AAPL | Stock | 2.1504 | 2.1504 | 2.1429 | 2.1429 | 33012.0 |
| 2006-07-21 08:00:00 | AAPL | Stock | 2.1536 | 2.1564 | 2.1429 | 2.1432 | 1327032.0 |
| 2006-07-21 08:05:00 | AAPL | Stock | 2.1432 | 2.1432 | 2.1375 | 2.1393 | 422492.0 |
| 2006-07-21 08:10:00 | AAPL | Stock | 2.1411 | 2.1429 | 2.1318 | 2.1318 | 545496.0 |
| 2006-07-21 08:15:00 | AAPL | Stock | 2.1289 | 2.1321 | 2.1257 | 2.1286 | 562940.0 |
| 2006-07-21 08:20:00 | AAPL | Stock | 2.1271 | 2.1343 | 2.1268 | 2.1329 | 393680.0 |
| 2006-07-21 08:25:00 | AAPL | Stock | 2.1339 | 2.135 | 2.1321 | 2.1321 | 76160.0 |
| 2006-07-21 08:30:00 | AAPL | Stock | 2.1321 | 2.1357 | 2.1321 | 2.135 | 124600.0 |
| 2006-07-21 08:35:00 | AAPL | Stock | 2.1332 | 2.1361 | 2.1321 | 2.1339 | 262976.0 |
| 2006-07-21 08:40:00 | AAPL | Stock | 2.1329 | 2.1329 | 2.1289 | 2.1321 | 287980.0 |
| 2006-07-21 08:45:00 | AAPL | Stock | 2.1321 | 2.1375 | 2.1321 | 2.135 | 218400.0 |
| 2006-07-21 08:50:00 | AAPL | Stock | 2.135 | 2.1371 | 2.1343 | 2.1371 | 28392.0 |
| 2006-07-21 08:55:00 | AAPL | Stock | 2.1371 | 2.1375 | 2.1357 | 2.1357 | 265720.0 |
| 2006-07-21 09:00:00 | AAPL | Stock | 2.1364 | 2.1364 | 2.1293 | 2.1293 | 749084.0 |
| 2006-07-21 09:05:00 | AAPL | Stock | 2.1293 | 2.1332 | 2.1293 | 2.1332 | 185080.0 |
| 2006-07-21 09:10:00 | AAPL | Stock | 2.1346 | 2.1393 | 2.1343 | 2.1382 | 516460.0 |
| 2006-07-21 09:15:00 | AAPL | Stock | 2.1382 | 2.1393 | 2.1332 | 2.1354 | 391636.0 |
| 2006-07-21 09:20:00 | AAPL | Stock | 2.1357 | 2.1375 | 2.1357 | 2.1375 | 63672.0 |
| 2006-07-21 09:25:00 | AAPL | Stock | 2.1389 | 2.1411 | 2.1332 | 2.1332 | 4517632.0 |
| 2006-07-21 09:30:00 | AAPL | Stock | 2.1364 | 2.1475 | 2.13 | 2.1464 | 58814168.0 |
| 2006-07-21 09:35:00 | AAPL | Stock | 2.1464 | 2.1543 | 2.1418 | 2.1468 | 22821960.0 |
| 2006-07-21 09:40:00 | AAPL | Stock | 2.1471 | 2.1564 | 2.1414 | 2.1518 | 17696476.0 |
| 2006-07-21 09:45:00 | AAPL | Stock | 2.1514 | 2.1579 | 2.1504 | 2.1539 | 17588312.0 |
| 2006-07-21 09:50:00 | AAPL | Stock | 2.1536 | 2.1571 | 2.1421 | 2.1479 | 24696840.0 |
| 2006-07-21 09:55:00 | AAPL | Stock | 2.1479 | 2.1529 | 2.1464 | 2.1475 | 14519540.0 |
| 2006-07-21 10:00:00 | AAPL | Stock | 2.1471 | 2.1507 | 2.1393 | 2.145 | 18547984.0 |
| 2006-07-21 10:05:00 | AAPL | Stock | 2.145 | 2.1561 | 2.1439 | 2.1554 | 13286560.0 |
| 2006-07-21 10:10:00 | AAPL | Stock | 2.1554 | 2.1557 | 2.1429 | 2.1446 | 19722808.0 |
| 2006-07-21 10:15:00 | AAPL | Stock | 2.1446 | 2.1482 | 2.1436 | 2.1454 | 17865792.0 |
| 2006-07-21 10:20:00 | AAPL | Stock | 2.1454 | 2.15 | 2.1446 | 2.1489 | 11314352.0 |
| 2006-07-21 10:25:00 | AAPL | Stock | 2.1486 | 2.1543 | 2.1479 | 2.1521 | 9974720.0 |
| 2006-07-21 10:30:00 | AAPL | Stock | 2.1518 | 2.1557 | 2.1468 | 2.1529 | 12331228.0 |
| 2006-07-21 10:35:00 | AAPL | Stock | 2.1532 | 2.1639 | 2.1529 | 2.1632 | 23236444.0 |
| 2006-07-21 10:40:00 | AAPL | Stock | 2.1629 | 2.1704 | 2.1589 | 2.1686 | 22096928.0 |
| 2006-07-21 10:45:00 | AAPL | Stock | 2.1682 | 2.1689 | 2.1632 | 2.1654 | 11043424.0 |
| 2006-07-21 10:50:00 | AAPL | Stock | 2.165 | 2.1732 | 2.1614 | 2.1732 | 14937160.0 |
| 2006-07-21 10:55:00 | AAPL | Stock | 2.1736 | 2.1782 | 2.1718 | 2.1725 | 16123828.0 |
| 2006-07-21 11:00:00 | AAPL | Stock | 2.1725 | 2.18 | 2.1714 | 2.1754 | 15546300.0 |
| 2006-07-21 11:05:00 | AAPL | Stock | 2.175 | 2.1775 | 2.1704 | 2.1746 | 12625480.0 |
| 2006-07-21 11:10:00 | AAPL | Stock | 2.1743 | 2.1764 | 2.1679 | 2.1729 | 9256968.0 |
| 2006-07-21 11:15:00 | AAPL | Stock | 2.1725 | 2.1754 | 2.17 | 2.1718 | 7712432.0 |
| 2006-07-21 11:20:00 | AAPL | Stock | 2.1718 | 2.1746 | 2.1632 | 2.1704 | 5893188.0 |
> showing 50 of 223,800 rows — these rows as CSV