PREVIEW / stock_5min / 2007-10-17
file: by_date/stock_5min/2007/2007-10-17.parquet size: 4.3 MB rows: 308,393 symbols: 3,160
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-17 04:15:00 | AAPL | Stock | 6.0729 | 6.1375 | 6.0729 | 6.1375 | 5600.0 |
| 2007-10-17 04:55:00 | AAPL | Stock | 6.1218 | 6.1218 | 6.1218 | 6.1218 | 8400.0 |
| 2007-10-17 06:45:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 2800.0 |
| 2007-10-17 06:50:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 9800.0 |
| 2007-10-17 07:00:00 | AAPL | Stock | 6.1071 | 6.125 | 6.1071 | 6.125 | 32200.0 |
| 2007-10-17 07:05:00 | AAPL | Stock | 6.125 | 6.1304 | 6.125 | 6.1304 | 36400.0 |
| 2007-10-17 07:10:00 | AAPL | Stock | 6.1304 | 6.1321 | 6.1304 | 6.1321 | 28000.0 |
| 2007-10-17 07:15:00 | AAPL | Stock | 6.1339 | 6.1339 | 6.1339 | 6.1339 | 8400.0 |
| 2007-10-17 07:20:00 | AAPL | Stock | 6.1411 | 6.1464 | 6.1296 | 6.1464 | 103460.0 |
| 2007-10-17 07:25:00 | AAPL | Stock | 6.1571 | 6.1607 | 6.15 | 6.1607 | 85456.0 |
| 2007-10-17 07:30:00 | AAPL | Stock | 6.1686 | 6.1836 | 6.1589 | 6.1782 | 328944.0 |
| 2007-10-17 07:35:00 | AAPL | Stock | 6.1696 | 6.1782 | 6.1607 | 6.1782 | 189700.0 |
| 2007-10-17 07:40:00 | AAPL | Stock | 6.1836 | 6.1964 | 6.1786 | 6.1832 | 414400.0 |
| 2007-10-17 07:45:00 | AAPL | Stock | 6.1696 | 6.1786 | 6.1696 | 6.17 | 92204.0 |
| 2007-10-17 07:50:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.17 | 6.1714 | 230440.0 |
| 2007-10-17 07:55:00 | AAPL | Stock | 6.1782 | 6.1786 | 6.1739 | 6.1779 | 446880.0 |
| 2007-10-17 08:00:00 | AAPL | Stock | 6.1739 | 6.1964 | 6.17 | 6.1768 | 1428952.0 |
| 2007-10-17 08:05:00 | AAPL | Stock | 6.1771 | 6.1786 | 6.1629 | 6.1693 | 1218868.0 |
| 2007-10-17 08:10:00 | AAPL | Stock | 6.1661 | 6.1686 | 6.1482 | 6.1539 | 1364048.0 |
| 2007-10-17 08:15:00 | AAPL | Stock | 6.1564 | 6.1607 | 6.1304 | 6.1607 | 671636.0 |
| 2007-10-17 08:20:00 | AAPL | Stock | 6.1607 | 6.1607 | 6.1554 | 6.1593 | 379036.0 |
| 2007-10-17 08:25:00 | AAPL | Stock | 6.1596 | 6.1596 | 6.1554 | 6.1571 | 424032.0 |
| 2007-10-17 08:30:00 | AAPL | Stock | 6.1568 | 6.165 | 6.1539 | 6.165 | 1140216.0 |
| 2007-10-17 08:35:00 | AAPL | Stock | 6.1632 | 6.1704 | 6.1589 | 6.1679 | 569912.0 |
| 2007-10-17 08:40:00 | AAPL | Stock | 6.1664 | 6.1675 | 6.1536 | 6.1571 | 805728.0 |
| 2007-10-17 08:45:00 | AAPL | Stock | 6.1571 | 6.1586 | 6.15 | 6.15 | 371980.0 |
| 2007-10-17 08:50:00 | AAPL | Stock | 6.15 | 6.1536 | 6.1411 | 6.1439 | 1263668.0 |
| 2007-10-17 08:55:00 | AAPL | Stock | 6.1446 | 6.1571 | 6.1432 | 6.1554 | 1000216.0 |
| 2007-10-17 09:00:00 | AAPL | Stock | 6.155 | 6.1607 | 6.155 | 6.1607 | 449820.0 |
| 2007-10-17 09:05:00 | AAPL | Stock | 6.1593 | 6.17 | 6.1589 | 6.1614 | 575680.0 |
| 2007-10-17 09:10:00 | AAPL | Stock | 6.1636 | 6.1679 | 6.1571 | 6.1586 | 389424.0 |
| 2007-10-17 09:15:00 | AAPL | Stock | 6.1586 | 6.1607 | 6.1475 | 6.1539 | 198016.0 |
| 2007-10-17 09:20:00 | AAPL | Stock | 6.155 | 6.1554 | 6.1489 | 6.1546 | 1708812.0 |
| 2007-10-17 09:25:00 | AAPL | Stock | 6.1536 | 6.1675 | 6.1536 | 6.1675 | 999320.0 |
| 2007-10-17 09:30:00 | AAPL | Stock | 6.1675 | 6.18 | 6.1386 | 6.1414 | 41427092.0 |
| 2007-10-17 09:35:00 | AAPL | Stock | 6.1411 | 6.1582 | 6.135 | 6.1398 | 26208980.0 |
| 2007-10-17 09:40:00 | AAPL | Stock | 6.1404 | 6.1536 | 6.1389 | 6.1425 | 20149976.0 |
| 2007-10-17 09:45:00 | AAPL | Stock | 6.1425 | 6.1532 | 6.13 | 6.1396 | 21812448.0 |
| 2007-10-17 09:50:00 | AAPL | Stock | 6.1396 | 6.1446 | 6.1339 | 6.1407 | 16671480.0 |
| 2007-10-17 09:55:00 | AAPL | Stock | 6.1407 | 6.1464 | 6.125 | 6.1328 | 18463452.0 |
| 2007-10-17 10:00:00 | AAPL | Stock | 6.1336 | 6.1393 | 6.1196 | 6.1371 | 15471204.0 |
| 2007-10-17 10:05:00 | AAPL | Stock | 6.1371 | 6.1414 | 6.1264 | 6.1375 | 12584236.0 |
| 2007-10-17 10:10:00 | AAPL | Stock | 6.1379 | 6.1407 | 6.1275 | 6.135 | 10603320.0 |
| 2007-10-17 10:15:00 | AAPL | Stock | 6.1354 | 6.1446 | 6.1304 | 6.1439 | 13572804.0 |
| 2007-10-17 10:20:00 | AAPL | Stock | 6.1439 | 6.1479 | 6.135 | 6.1429 | 14798084.0 |
| 2007-10-17 10:25:00 | AAPL | Stock | 6.1429 | 6.1432 | 6.1282 | 6.135 | 12344136.0 |
| 2007-10-17 10:30:00 | AAPL | Stock | 6.1339 | 6.1411 | 6.1304 | 6.1375 | 10104640.0 |
| 2007-10-17 10:35:00 | AAPL | Stock | 6.1375 | 6.1386 | 6.1204 | 6.1204 | 14523936.0 |
| 2007-10-17 10:40:00 | AAPL | Stock | 6.1207 | 6.1257 | 6.0946 | 6.1082 | 28528332.0 |
| 2007-10-17 10:45:00 | AAPL | Stock | 6.1086 | 6.115 | 6.1021 | 6.1114 | 11374496.0 |
> showing 50 of 308,393 rows — these rows as CSV