PREVIEW / stock_5min / 2007-10-18
file: by_date/stock_5min/2007/2007-10-18.parquet size: 4.2 MB rows: 307,743 symbols: 3,124
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-18 06:55:00 | AAPL | Stock | 6.1539 | 6.1539 | 6.1539 | 6.1539 | 8400.0 |
| 2007-10-18 07:00:00 | AAPL | Stock | 6.1661 | 6.1661 | 6.1661 | 6.1661 | 28000.0 |
| 2007-10-18 07:05:00 | AAPL | Stock | 6.1875 | 6.1875 | 6.1875 | 6.1875 | 5600.0 |
| 2007-10-18 07:10:00 | AAPL | Stock | 6.1775 | 6.1775 | 6.1536 | 6.1536 | 40600.0 |
| 2007-10-18 07:15:00 | AAPL | Stock | 6.145 | 6.145 | 6.145 | 6.145 | 5600.0 |
| 2007-10-18 07:25:00 | AAPL | Stock | 6.145 | 6.145 | 6.1254 | 6.1254 | 30800.0 |
| 2007-10-18 07:30:00 | AAPL | Stock | 6.1296 | 6.1296 | 6.1254 | 6.1254 | 28000.0 |
| 2007-10-18 07:50:00 | AAPL | Stock | 6.1336 | 6.1336 | 6.1336 | 6.1336 | 7700.0 |
| 2007-10-18 07:55:00 | AAPL | Stock | 6.1232 | 6.1232 | 6.1232 | 6.1232 | 16800.0 |
| 2007-10-18 08:00:00 | AAPL | Stock | 6.1304 | 6.1339 | 6.1107 | 6.115 | 528220.0 |
| 2007-10-18 08:05:00 | AAPL | Stock | 6.1146 | 6.1246 | 6.1146 | 6.1214 | 373576.0 |
| 2007-10-18 08:10:00 | AAPL | Stock | 6.1214 | 6.1214 | 6.1039 | 6.1071 | 349440.0 |
| 2007-10-18 08:15:00 | AAPL | Stock | 6.0989 | 6.1107 | 6.0957 | 6.1107 | 156100.0 |
| 2007-10-18 08:20:00 | AAPL | Stock | 6.1107 | 6.1175 | 6.1107 | 6.1175 | 97888.0 |
| 2007-10-18 08:25:00 | AAPL | Stock | 6.1179 | 6.1207 | 6.1129 | 6.1129 | 60844.0 |
| 2007-10-18 08:30:00 | AAPL | Stock | 6.1146 | 6.1196 | 6.1032 | 6.1071 | 259980.0 |
| 2007-10-18 08:35:00 | AAPL | Stock | 6.1071 | 6.1136 | 6.1036 | 6.1036 | 261716.0 |
| 2007-10-18 08:40:00 | AAPL | Stock | 6.1046 | 6.1114 | 6.1021 | 6.1089 | 181804.0 |
| 2007-10-18 08:45:00 | AAPL | Stock | 6.1125 | 6.1143 | 6.1089 | 6.1143 | 283220.0 |
| 2007-10-18 08:50:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1107 | 6.1143 | 126812.0 |
| 2007-10-18 08:55:00 | AAPL | Stock | 6.1161 | 6.1304 | 6.1143 | 6.1286 | 268940.0 |
| 2007-10-18 09:00:00 | AAPL | Stock | 6.1286 | 6.1286 | 6.1179 | 6.1211 | 199640.0 |
| 2007-10-18 09:05:00 | AAPL | Stock | 6.1179 | 6.1179 | 6.1179 | 6.1179 | 40180.0 |
| 2007-10-18 09:10:00 | AAPL | Stock | 6.1179 | 6.125 | 6.1179 | 6.1243 | 171864.0 |
| 2007-10-18 09:15:00 | AAPL | Stock | 6.1243 | 6.1243 | 6.1204 | 6.1204 | 175140.0 |
| 2007-10-18 09:20:00 | AAPL | Stock | 6.1204 | 6.1214 | 6.1161 | 6.1179 | 206080.0 |
| 2007-10-18 09:25:00 | AAPL | Stock | 6.1161 | 6.1368 | 6.1161 | 6.1243 | 938840.0 |
| 2007-10-18 09:30:00 | AAPL | Stock | 6.1239 | 6.1518 | 6.1121 | 6.1443 | 30802436.0 |
| 2007-10-18 09:35:00 | AAPL | Stock | 6.1443 | 6.1486 | 6.1214 | 6.1302 | 18814488.0 |
| 2007-10-18 09:40:00 | AAPL | Stock | 6.1305 | 6.1482 | 6.1089 | 6.1464 | 24469648.0 |
| 2007-10-18 09:45:00 | AAPL | Stock | 6.1464 | 6.1539 | 6.1357 | 6.1518 | 19555872.0 |
| 2007-10-18 09:50:00 | AAPL | Stock | 6.1507 | 6.1518 | 6.1214 | 6.1339 | 18188968.0 |
| 2007-10-18 09:55:00 | AAPL | Stock | 6.1339 | 6.1486 | 6.1323 | 6.1364 | 12078556.0 |
| 2007-10-18 10:00:00 | AAPL | Stock | 6.1361 | 6.1414 | 6.1146 | 6.1218 | 17612924.0 |
| 2007-10-18 10:05:00 | AAPL | Stock | 6.1218 | 6.1343 | 6.1161 | 6.1314 | 9999080.0 |
| 2007-10-18 10:10:00 | AAPL | Stock | 6.1316 | 6.1461 | 6.1261 | 6.1457 | 13239044.0 |
| 2007-10-18 10:15:00 | AAPL | Stock | 6.1457 | 6.1575 | 6.1396 | 6.1532 | 15204672.0 |
| 2007-10-18 10:20:00 | AAPL | Stock | 6.1532 | 6.1618 | 6.1446 | 6.1529 | 14222964.0 |
| 2007-10-18 10:25:00 | AAPL | Stock | 6.1536 | 6.1675 | 6.1475 | 6.165 | 13371932.0 |
| 2007-10-18 10:30:00 | AAPL | Stock | 6.1657 | 6.1661 | 6.1504 | 6.1543 | 12325320.0 |
| 2007-10-18 10:35:00 | AAPL | Stock | 6.1536 | 6.1564 | 6.1464 | 6.1532 | 7352744.0 |
| 2007-10-18 10:40:00 | AAPL | Stock | 6.1521 | 6.1596 | 6.1471 | 6.15 | 7430584.0 |
| 2007-10-18 10:45:00 | AAPL | Stock | 6.15 | 6.1554 | 6.1479 | 6.1504 | 5768280.0 |
| 2007-10-18 10:50:00 | AAPL | Stock | 6.1507 | 6.1586 | 6.15 | 6.1557 | 7702744.0 |
| 2007-10-18 10:55:00 | AAPL | Stock | 6.1554 | 6.1589 | 6.1514 | 6.1543 | 4078396.0 |
| 2007-10-18 11:00:00 | AAPL | Stock | 6.1541 | 6.1589 | 6.15 | 6.155 | 4519648.0 |
| 2007-10-18 11:05:00 | AAPL | Stock | 6.1554 | 6.1625 | 6.1545 | 6.1568 | 6958448.0 |
| 2007-10-18 11:10:00 | AAPL | Stock | 6.1568 | 6.1607 | 6.15 | 6.1525 | 10315060.0 |
| 2007-10-18 11:15:00 | AAPL | Stock | 6.1514 | 6.1589 | 6.1504 | 6.1518 | 7640668.0 |
| 2007-10-18 11:20:00 | AAPL | Stock | 6.1518 | 6.1525 | 6.1393 | 6.1443 | 15608376.0 |
> showing 50 of 307,743 rows — these rows as CSV