PREVIEW / stock_5min / 2009-07-01
file: by_date/stock_5min/2009/2009-07-01.parquet size: 4.6 MB rows: 322,009 symbols: 3,306
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-07-01 07:05:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 14000.0 |
| 2009-07-01 07:20:00 | AAPL | Stock | 5.1114 | 5.1114 | 5.1114 | 5.1114 | 8400.0 |
| 2009-07-01 07:30:00 | AAPL | Stock | 5.1118 | 5.1118 | 5.1118 | 5.1118 | 4200.0 |
| 2009-07-01 07:35:00 | AAPL | Stock | 5.1143 | 5.1143 | 5.1143 | 5.1143 | 5600.0 |
| 2009-07-01 07:50:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1161 | 5.1161 | 2800.0 |
| 2009-07-01 08:00:00 | AAPL | Stock | 5.1086 | 5.1161 | 5.1071 | 5.1086 | 39760.0 |
| 2009-07-01 08:05:00 | AAPL | Stock | 5.1143 | 5.1161 | 5.1139 | 5.1143 | 91448.0 |
| 2009-07-01 08:10:00 | AAPL | Stock | 5.1136 | 5.1143 | 5.1136 | 5.1143 | 30800.0 |
| 2009-07-01 08:15:00 | AAPL | Stock | 5.1093 | 5.1093 | 5.1014 | 5.1014 | 95116.0 |
| 2009-07-01 08:20:00 | AAPL | Stock | 5.1004 | 5.1057 | 5.1004 | 5.1057 | 14000.0 |
| 2009-07-01 08:25:00 | AAPL | Stock | 5.1061 | 5.1068 | 5.0868 | 5.1068 | 330876.0 |
| 2009-07-01 08:30:00 | AAPL | Stock | 5.1107 | 5.1107 | 5.1075 | 5.1075 | 42000.0 |
| 2009-07-01 08:35:00 | AAPL | Stock | 5.1104 | 5.1125 | 5.1068 | 5.1071 | 62720.0 |
| 2009-07-01 08:40:00 | AAPL | Stock | 5.1029 | 5.1029 | 5.0868 | 5.1014 | 228032.0 |
| 2009-07-01 08:45:00 | AAPL | Stock | 5.1018 | 5.1018 | 5.0943 | 5.0943 | 47320.0 |
| 2009-07-01 08:50:00 | AAPL | Stock | 5.0968 | 5.0996 | 5.0868 | 5.0996 | 573020.0 |
| 2009-07-01 08:55:00 | AAPL | Stock | 5.1 | 5.1029 | 5.1 | 5.1029 | 125384.0 |
| 2009-07-01 09:00:00 | AAPL | Stock | 5.1046 | 5.1104 | 5.1046 | 5.1068 | 51800.0 |
| 2009-07-01 09:05:00 | AAPL | Stock | 5.1068 | 5.1089 | 5.1068 | 5.1089 | 95200.0 |
| 2009-07-01 09:10:00 | AAPL | Stock | 5.1104 | 5.1143 | 5.1104 | 5.1129 | 107240.0 |
| 2009-07-01 09:15:00 | AAPL | Stock | 5.1107 | 5.1107 | 5.1046 | 5.1071 | 14000.0 |
| 2009-07-01 09:20:00 | AAPL | Stock | 5.1107 | 5.1161 | 5.1107 | 5.1161 | 131040.0 |
| 2009-07-01 09:25:00 | AAPL | Stock | 5.1111 | 5.1289 | 5.1107 | 5.1286 | 925904.0 |
| 2009-07-01 09:30:00 | AAPL | Stock | 5.1246 | 5.1393 | 5.1214 | 5.1286 | 18676700.0 |
| 2009-07-01 09:35:00 | AAPL | Stock | 5.1279 | 5.1296 | 5.0989 | 5.1068 | 12516504.0 |
| 2009-07-01 09:40:00 | AAPL | Stock | 5.1071 | 5.1157 | 5.1014 | 5.1136 | 9678452.0 |
| 2009-07-01 09:45:00 | AAPL | Stock | 5.1129 | 5.1275 | 5.1096 | 5.1268 | 8712312.0 |
| 2009-07-01 09:50:00 | AAPL | Stock | 5.1268 | 5.1375 | 5.1261 | 5.1364 | 9580816.0 |
| 2009-07-01 09:55:00 | AAPL | Stock | 5.1362 | 5.1489 | 5.1361 | 5.1475 | 17556868.0 |
| 2009-07-01 10:00:00 | AAPL | Stock | 5.1464 | 5.1486 | 5.1336 | 5.1368 | 15396416.0 |
| 2009-07-01 10:05:00 | AAPL | Stock | 5.1368 | 5.1468 | 5.1354 | 5.1421 | 7845572.0 |
| 2009-07-01 10:10:00 | AAPL | Stock | 5.1421 | 5.1443 | 5.1318 | 5.1364 | 6469428.0 |
| 2009-07-01 10:15:00 | AAPL | Stock | 5.1364 | 5.1607 | 5.1354 | 5.1589 | 17378984.0 |
| 2009-07-01 10:20:00 | AAPL | Stock | 5.1589 | 5.1607 | 5.1536 | 5.155 | 7545580.0 |
| 2009-07-01 10:25:00 | AAPL | Stock | 5.1546 | 5.1643 | 5.1536 | 5.1643 | 9614528.0 |
| 2009-07-01 10:30:00 | AAPL | Stock | 5.1636 | 5.1664 | 5.1571 | 5.1596 | 6500144.0 |
| 2009-07-01 10:35:00 | AAPL | Stock | 5.1593 | 5.1625 | 5.1536 | 5.1541 | 4894596.0 |
| 2009-07-01 10:40:00 | AAPL | Stock | 5.1546 | 5.1607 | 5.1518 | 5.1607 | 3616760.0 |
| 2009-07-01 10:45:00 | AAPL | Stock | 5.16 | 5.16 | 5.15 | 5.1519 | 3864588.0 |
| 2009-07-01 10:50:00 | AAPL | Stock | 5.1518 | 5.1554 | 5.1443 | 5.1471 | 6026048.0 |
| 2009-07-01 10:55:00 | AAPL | Stock | 5.1465 | 5.1536 | 5.1439 | 5.1518 | 4512228.0 |
| 2009-07-01 11:00:00 | AAPL | Stock | 5.1516 | 5.1554 | 5.1464 | 5.1479 | 3526348.0 |
| 2009-07-01 11:05:00 | AAPL | Stock | 5.1486 | 5.15 | 5.1443 | 5.1461 | 2944704.0 |
| 2009-07-01 11:10:00 | AAPL | Stock | 5.1461 | 5.1482 | 5.1393 | 5.1457 | 5288360.0 |
| 2009-07-01 11:15:00 | AAPL | Stock | 5.145 | 5.1493 | 5.14 | 5.1411 | 2740864.0 |
| 2009-07-01 11:20:00 | AAPL | Stock | 5.1407 | 5.1411 | 5.1321 | 5.1354 | 4883312.0 |
| 2009-07-01 11:25:00 | AAPL | Stock | 5.1354 | 5.1439 | 5.135 | 5.1396 | 4005876.0 |
| 2009-07-01 11:30:00 | AAPL | Stock | 5.1386 | 5.1493 | 5.1386 | 5.1493 | 3789156.0 |
| 2009-07-01 11:35:00 | AAPL | Stock | 5.1493 | 5.1564 | 5.1486 | 5.1554 | 3226132.0 |
| 2009-07-01 11:40:00 | AAPL | Stock | 5.1557 | 5.1571 | 5.1489 | 5.1501 | 3392900.0 |
> showing 50 of 322,009 rows — these rows as CSV