PREVIEW / stock_5min / 2006-12-08
file: by_date/stock_5min/2006/2006-12-08.parquet size: 3.2 MB rows: 234,037 symbols: 2,454
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-12-08 04:15:00 | AAPL | Stock | 3.1064 | 3.1064 | 3.1064 | 3.1064 | 2800.0 |
| 2006-12-08 07:25:00 | AAPL | Stock | 3.1064 | 3.1064 | 3.1046 | 3.1046 | 19600.0 |
| 2006-12-08 07:30:00 | AAPL | Stock | 3.1064 | 3.1064 | 3.1064 | 3.1064 | 5740.0 |
| 2006-12-08 07:35:00 | AAPL | Stock | 3.1036 | 3.1036 | 3.1036 | 3.1036 | 3808.0 |
| 2006-12-08 07:40:00 | AAPL | Stock | 3.1036 | 3.1036 | 3.1036 | 3.1036 | 2800.0 |
| 2006-12-08 07:50:00 | AAPL | Stock | 3.1032 | 3.1032 | 3.1032 | 3.1032 | 2800.0 |
| 2006-12-08 08:00:00 | AAPL | Stock | 3.1036 | 3.115 | 3.1 | 3.115 | 195132.0 |
| 2006-12-08 08:05:00 | AAPL | Stock | 3.1107 | 3.1114 | 3.1071 | 3.1107 | 343000.0 |
| 2006-12-08 08:10:00 | AAPL | Stock | 3.1107 | 3.1143 | 3.1071 | 3.1121 | 332780.0 |
| 2006-12-08 08:15:00 | AAPL | Stock | 3.1071 | 3.1121 | 3.1071 | 3.1121 | 108780.0 |
| 2006-12-08 08:20:00 | AAPL | Stock | 3.11 | 3.1114 | 3.1086 | 3.1104 | 192668.0 |
| 2006-12-08 08:25:00 | AAPL | Stock | 3.1104 | 3.1136 | 3.1029 | 3.1054 | 396956.0 |
| 2006-12-08 08:30:00 | AAPL | Stock | 3.1071 | 3.1246 | 3.1071 | 3.1221 | 2209424.0 |
| 2006-12-08 08:35:00 | AAPL | Stock | 3.1232 | 3.1304 | 3.1225 | 3.1293 | 1056580.0 |
| 2006-12-08 08:40:00 | AAPL | Stock | 3.1293 | 3.1332 | 3.125 | 3.1321 | 1150156.0 |
| 2006-12-08 08:45:00 | AAPL | Stock | 3.1311 | 3.1311 | 3.1264 | 3.1304 | 387660.0 |
| 2006-12-08 08:50:00 | AAPL | Stock | 3.1304 | 3.1314 | 3.1271 | 3.1311 | 269948.0 |
| 2006-12-08 08:55:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.125 | 3.125 | 387548.0 |
| 2006-12-08 09:00:00 | AAPL | Stock | 3.1232 | 3.1271 | 3.1214 | 3.1239 | 193228.0 |
| 2006-12-08 09:05:00 | AAPL | Stock | 3.1225 | 3.1225 | 3.1125 | 3.1125 | 703976.0 |
| 2006-12-08 09:10:00 | AAPL | Stock | 3.1114 | 3.1161 | 3.1111 | 3.1136 | 545356.0 |
| 2006-12-08 09:15:00 | AAPL | Stock | 3.1136 | 3.1193 | 3.1136 | 3.1175 | 108892.0 |
| 2006-12-08 09:20:00 | AAPL | Stock | 3.1179 | 3.1196 | 3.1157 | 3.1161 | 45724.0 |
| 2006-12-08 09:25:00 | AAPL | Stock | 3.1182 | 3.1182 | 3.1079 | 3.1129 | 181776.0 |
| 2006-12-08 09:30:00 | AAPL | Stock | 3.1154 | 3.1275 | 3.1071 | 3.1275 | 26223400.0 |
| 2006-12-08 09:35:00 | AAPL | Stock | 3.1279 | 3.1521 | 3.125 | 3.1471 | 39336500.0 |
| 2006-12-08 09:40:00 | AAPL | Stock | 3.1471 | 3.1643 | 3.1461 | 3.1596 | 29751176.0 |
| 2006-12-08 09:45:00 | AAPL | Stock | 3.1596 | 3.1614 | 3.1443 | 3.1454 | 24082884.0 |
| 2006-12-08 09:50:00 | AAPL | Stock | 3.1457 | 3.1464 | 3.1346 | 3.1371 | 21360976.0 |
| 2006-12-08 09:55:00 | AAPL | Stock | 3.1375 | 3.1389 | 3.1214 | 3.1236 | 19621364.0 |
| 2006-12-08 10:00:00 | AAPL | Stock | 3.1236 | 3.1289 | 3.1093 | 3.128 | 26934096.0 |
| 2006-12-08 10:05:00 | AAPL | Stock | 3.1279 | 3.1286 | 3.1111 | 3.1218 | 14094948.0 |
| 2006-12-08 10:10:00 | AAPL | Stock | 3.122 | 3.1321 | 3.1214 | 3.1261 | 13689648.0 |
| 2006-12-08 10:15:00 | AAPL | Stock | 3.1261 | 3.1286 | 3.1168 | 3.1232 | 10759392.0 |
| 2006-12-08 10:20:00 | AAPL | Stock | 3.1232 | 3.1325 | 3.1214 | 3.1289 | 9988664.0 |
| 2006-12-08 10:25:00 | AAPL | Stock | 3.1289 | 3.1429 | 3.1279 | 3.14 | 16138332.0 |
| 2006-12-08 10:30:00 | AAPL | Stock | 3.14 | 3.1421 | 3.1329 | 3.1393 | 11283412.0 |
| 2006-12-08 10:35:00 | AAPL | Stock | 3.1396 | 3.1411 | 3.1336 | 3.1411 | 9130044.0 |
| 2006-12-08 10:40:00 | AAPL | Stock | 3.1411 | 3.1582 | 3.1411 | 3.1532 | 17361960.0 |
| 2006-12-08 10:45:00 | AAPL | Stock | 3.1532 | 3.1589 | 3.1479 | 3.1554 | 9653616.0 |
| 2006-12-08 10:50:00 | AAPL | Stock | 3.1554 | 3.1614 | 3.1536 | 3.1575 | 13170248.0 |
| 2006-12-08 10:55:00 | AAPL | Stock | 3.1575 | 3.1607 | 3.1568 | 3.1593 | 10881640.0 |
| 2006-12-08 11:00:00 | AAPL | Stock | 3.1589 | 3.1611 | 3.155 | 3.1607 | 13529264.0 |
| 2006-12-08 11:05:00 | AAPL | Stock | 3.1607 | 3.1711 | 3.1596 | 3.1686 | 16073988.0 |
| 2006-12-08 11:10:00 | AAPL | Stock | 3.1686 | 3.1725 | 3.1657 | 3.1704 | 11634000.0 |
| 2006-12-08 11:15:00 | AAPL | Stock | 3.17 | 3.1832 | 3.1692 | 3.1811 | 20236300.0 |
| 2006-12-08 11:20:00 | AAPL | Stock | 3.1804 | 3.1896 | 3.1775 | 3.1846 | 19319692.0 |
| 2006-12-08 11:25:00 | AAPL | Stock | 3.185 | 3.1925 | 3.1814 | 3.1836 | 15400056.0 |
| 2006-12-08 11:30:00 | AAPL | Stock | 3.1839 | 3.1879 | 3.1764 | 3.1789 | 16386048.0 |
| 2006-12-08 11:35:00 | AAPL | Stock | 3.1789 | 3.1832 | 3.1754 | 3.1779 | 9102576.0 |
> showing 50 of 234,037 rows — these rows as CSV