PREVIEW / stock_5min / 2009-06-09
file: by_date/stock_5min/2009/2009-06-09.parquet size: 4.6 MB rows: 317,230 symbols: 3,357
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-09 04:35:00 | AAPL | Stock | 5.1679 | 5.1679 | 5.1679 | 5.1679 | 2800.0 |
| 2009-06-09 06:05:00 | AAPL | Stock | 5.13 | 5.13 | 5.13 | 5.13 | 2800.0 |
| 2009-06-09 06:25:00 | AAPL | Stock | 5.1564 | 5.1564 | 5.1564 | 5.1564 | 14000.0 |
| 2009-06-09 07:00:00 | AAPL | Stock | 5.1461 | 5.15 | 5.1461 | 5.15 | 14000.0 |
| 2009-06-09 07:05:00 | AAPL | Stock | 5.1464 | 5.1464 | 5.1464 | 5.1464 | 2800.0 |
| 2009-06-09 07:10:00 | AAPL | Stock | 5.1464 | 5.1464 | 5.1464 | 5.1464 | 2800.0 |
| 2009-06-09 07:15:00 | AAPL | Stock | 5.1493 | 5.15 | 5.1489 | 5.15 | 70000.0 |
| 2009-06-09 07:20:00 | AAPL | Stock | 5.1521 | 5.1571 | 5.1521 | 5.1571 | 5600.0 |
| 2009-06-09 07:25:00 | AAPL | Stock | 5.1554 | 5.1554 | 5.1554 | 5.1554 | 11200.0 |
| 2009-06-09 07:30:00 | AAPL | Stock | 5.1604 | 5.1604 | 5.1604 | 5.1604 | 11900.0 |
| 2009-06-09 07:35:00 | AAPL | Stock | 5.1511 | 5.1564 | 5.1511 | 5.1564 | 8400.0 |
| 2009-06-09 07:40:00 | AAPL | Stock | 5.1561 | 5.1561 | 5.1561 | 5.1561 | 5600.0 |
| 2009-06-09 07:45:00 | AAPL | Stock | 5.1554 | 5.1564 | 5.1554 | 5.1564 | 56000.0 |
| 2009-06-09 07:50:00 | AAPL | Stock | 5.1604 | 5.1643 | 5.1604 | 5.1607 | 199836.0 |
| 2009-06-09 07:55:00 | AAPL | Stock | 5.1643 | 5.1654 | 5.1643 | 5.1654 | 112728.0 |
| 2009-06-09 08:00:00 | AAPL | Stock | 5.1654 | 5.1696 | 5.1529 | 5.1571 | 154756.0 |
| 2009-06-09 08:05:00 | AAPL | Stock | 5.1532 | 5.16 | 5.15 | 5.1511 | 71568.0 |
| 2009-06-09 08:10:00 | AAPL | Stock | 5.15 | 5.15 | 5.1357 | 5.1357 | 251160.0 |
| 2009-06-09 08:15:00 | AAPL | Stock | 5.1361 | 5.1407 | 5.1339 | 5.1375 | 102340.0 |
| 2009-06-09 08:20:00 | AAPL | Stock | 5.1375 | 5.1425 | 5.1375 | 5.1425 | 209300.0 |
| 2009-06-09 08:25:00 | AAPL | Stock | 5.1425 | 5.1425 | 5.1379 | 5.1379 | 33880.0 |
| 2009-06-09 08:30:00 | AAPL | Stock | 5.14 | 5.14 | 5.1346 | 5.1346 | 113120.0 |
| 2009-06-09 08:35:00 | AAPL | Stock | 5.1354 | 5.1357 | 5.1321 | 5.1357 | 66080.0 |
| 2009-06-09 08:40:00 | AAPL | Stock | 5.1332 | 5.1389 | 5.1332 | 5.1371 | 72800.0 |
| 2009-06-09 08:45:00 | AAPL | Stock | 5.1371 | 5.1436 | 5.1371 | 5.1429 | 303968.0 |
| 2009-06-09 08:50:00 | AAPL | Stock | 5.1429 | 5.1436 | 5.1425 | 5.1436 | 198688.0 |
| 2009-06-09 08:55:00 | AAPL | Stock | 5.1429 | 5.1521 | 5.1429 | 5.1521 | 444136.0 |
| 2009-06-09 09:00:00 | AAPL | Stock | 5.1521 | 5.1607 | 5.1486 | 5.15 | 438676.0 |
| 2009-06-09 09:05:00 | AAPL | Stock | 5.1482 | 5.1482 | 5.1357 | 5.1414 | 277676.0 |
| 2009-06-09 09:10:00 | AAPL | Stock | 5.1414 | 5.1504 | 5.1414 | 5.1468 | 192332.0 |
| 2009-06-09 09:15:00 | AAPL | Stock | 5.1468 | 5.1529 | 5.1468 | 5.15 | 288708.0 |
| 2009-06-09 09:20:00 | AAPL | Stock | 5.1493 | 5.1493 | 5.1421 | 5.1421 | 164248.0 |
| 2009-06-09 09:25:00 | AAPL | Stock | 5.1418 | 5.1418 | 5.1271 | 5.1357 | 985740.0 |
| 2009-06-09 09:30:00 | AAPL | Stock | 5.1361 | 5.1411 | 5.0714 | 5.0961 | 26791072.0 |
| 2009-06-09 09:35:00 | AAPL | Stock | 5.0961 | 5.11 | 5.0804 | 5.0882 | 20481580.0 |
| 2009-06-09 09:40:00 | AAPL | Stock | 5.0889 | 5.1125 | 5.075 | 5.0964 | 22793260.0 |
| 2009-06-09 09:45:00 | AAPL | Stock | 5.0971 | 5.1232 | 5.0904 | 5.115 | 15958908.0 |
| 2009-06-09 09:50:00 | AAPL | Stock | 5.1154 | 5.1314 | 5.1004 | 5.1282 | 15695232.0 |
| 2009-06-09 09:55:00 | AAPL | Stock | 5.1279 | 5.15 | 5.1279 | 5.1443 | 19668264.0 |
| 2009-06-09 10:00:00 | AAPL | Stock | 5.1443 | 5.1629 | 5.1421 | 5.1539 | 18882108.0 |
| 2009-06-09 10:05:00 | AAPL | Stock | 5.1539 | 5.1586 | 5.1429 | 5.1532 | 11621092.0 |
| 2009-06-09 10:10:00 | AAPL | Stock | 5.1532 | 5.1554 | 5.1304 | 5.1355 | 11685128.0 |
| 2009-06-09 10:15:00 | AAPL | Stock | 5.1361 | 5.1371 | 5.1132 | 5.1214 | 14549808.0 |
| 2009-06-09 10:20:00 | AAPL | Stock | 5.1221 | 5.1225 | 5.0971 | 5.105 | 13741420.0 |
| 2009-06-09 10:25:00 | AAPL | Stock | 5.1053 | 5.1111 | 5.0964 | 5.1004 | 9976036.0 |
| 2009-06-09 10:30:00 | AAPL | Stock | 5.1 | 5.1104 | 5.0693 | 5.1095 | 7089992.0 |
| 2009-06-09 10:35:00 | AAPL | Stock | 5.1089 | 5.1093 | 5.0964 | 5.1011 | 7205632.0 |
| 2009-06-09 10:40:00 | AAPL | Stock | 5.1007 | 5.1054 | 5.0757 | 5.0779 | 13343624.0 |
| 2009-06-09 10:45:00 | AAPL | Stock | 5.0775 | 5.0846 | 5.0543 | 5.0554 | 14305872.0 |
| 2009-06-09 10:50:00 | AAPL | Stock | 5.0546 | 5.0613 | 5.0407 | 5.0613 | 15249640.0 |
> showing 50 of 317,230 rows — these rows as CSV