PREVIEW / stock_5min / 2007-12-31
file: by_date/stock_5min/2007/2007-12-31.parquet size: 4.5 MB rows: 335,974 symbols: 3,282
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-12-31 07:25:00 | AAPL | Stock | 7.1379 | 7.1379 | 7.1379 | 7.1379 | 2800.0 |
| 2007-12-31 07:55:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 28000.0 |
| 2007-12-31 08:00:00 | AAPL | Stock | 7.1429 | 7.1696 | 7.1429 | 7.1679 | 1042888.0 |
| 2007-12-31 08:05:00 | AAPL | Stock | 7.1679 | 7.1679 | 7.1607 | 7.1607 | 308812.0 |
| 2007-12-31 08:10:00 | AAPL | Stock | 7.1625 | 7.1654 | 7.1607 | 7.1625 | 228200.0 |
| 2007-12-31 08:15:00 | AAPL | Stock | 7.1625 | 7.1625 | 7.1554 | 7.1607 | 164920.0 |
| 2007-12-31 08:20:00 | AAPL | Stock | 7.1582 | 7.1639 | 7.1582 | 7.1625 | 456344.0 |
| 2007-12-31 08:25:00 | AAPL | Stock | 7.1607 | 7.1621 | 7.1554 | 7.1607 | 357896.0 |
| 2007-12-31 08:30:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1429 | 7.1539 | 398048.0 |
| 2007-12-31 08:35:00 | AAPL | Stock | 7.1482 | 7.1511 | 7.1446 | 7.1511 | 80920.0 |
| 2007-12-31 08:40:00 | AAPL | Stock | 7.15 | 7.1504 | 7.1479 | 7.1479 | 61488.0 |
| 2007-12-31 08:45:00 | AAPL | Stock | 7.15 | 7.1514 | 7.1468 | 7.1468 | 88340.0 |
| 2007-12-31 08:50:00 | AAPL | Stock | 7.1468 | 7.15 | 7.1432 | 7.1482 | 99624.0 |
| 2007-12-31 08:55:00 | AAPL | Stock | 7.1482 | 7.15 | 7.1464 | 7.15 | 166880.0 |
| 2007-12-31 09:00:00 | AAPL | Stock | 7.15 | 7.15 | 7.1436 | 7.1436 | 70560.0 |
| 2007-12-31 09:05:00 | AAPL | Stock | 7.1446 | 7.1525 | 7.1396 | 7.1525 | 708204.0 |
| 2007-12-31 09:10:00 | AAPL | Stock | 7.145 | 7.145 | 7.1368 | 7.1375 | 340116.0 |
| 2007-12-31 09:15:00 | AAPL | Stock | 7.1368 | 7.1425 | 7.1357 | 7.1375 | 80668.0 |
| 2007-12-31 09:20:00 | AAPL | Stock | 7.1375 | 7.1375 | 7.1339 | 7.1357 | 146580.0 |
| 2007-12-31 09:25:00 | AAPL | Stock | 7.1343 | 7.1357 | 7.1236 | 7.1275 | 419048.0 |
| 2007-12-31 09:30:00 | AAPL | Stock | 7.1236 | 7.1411 | 7.0786 | 7.0961 | 17906784.0 |
| 2007-12-31 09:35:00 | AAPL | Stock | 7.0957 | 7.0957 | 7.0729 | 7.0832 | 14165704.0 |
| 2007-12-31 09:40:00 | AAPL | Stock | 7.0842 | 7.1114 | 7.0704 | 7.0943 | 15272712.0 |
| 2007-12-31 09:45:00 | AAPL | Stock | 7.0943 | 7.1186 | 7.0921 | 7.1104 | 11158504.0 |
| 2007-12-31 09:50:00 | AAPL | Stock | 7.1104 | 7.1361 | 7.1104 | 7.1257 | 11638060.0 |
| 2007-12-31 09:55:00 | AAPL | Stock | 7.1257 | 7.1268 | 7.1002 | 7.1036 | 8337532.0 |
| 2007-12-31 10:00:00 | AAPL | Stock | 7.1029 | 7.1111 | 7.0939 | 7.1068 | 11600316.0 |
| 2007-12-31 10:05:00 | AAPL | Stock | 7.1068 | 7.1236 | 7.0921 | 7.1168 | 9258760.0 |
| 2007-12-31 10:10:00 | AAPL | Stock | 7.1168 | 7.1361 | 7.1114 | 7.1314 | 8944740.0 |
| 2007-12-31 10:15:00 | AAPL | Stock | 7.1314 | 7.1371 | 7.1221 | 7.1318 | 6402872.0 |
| 2007-12-31 10:20:00 | AAPL | Stock | 7.1307 | 7.1339 | 7.1107 | 7.1196 | 6248424.0 |
| 2007-12-31 10:25:00 | AAPL | Stock | 7.1182 | 7.1293 | 7.1157 | 7.1196 | 4549384.0 |
| 2007-12-31 10:30:00 | AAPL | Stock | 7.1196 | 7.1281 | 7.1157 | 7.12 | 3781176.0 |
| 2007-12-31 10:35:00 | AAPL | Stock | 7.12 | 7.1225 | 7.1071 | 7.1179 | 6108676.0 |
| 2007-12-31 10:40:00 | AAPL | Stock | 7.1175 | 7.1186 | 7.1046 | 7.1065 | 4432540.0 |
| 2007-12-31 10:45:00 | AAPL | Stock | 7.1068 | 7.1093 | 7.0936 | 7.1071 | 7300468.0 |
| 2007-12-31 10:50:00 | AAPL | Stock | 7.1071 | 7.1154 | 7.1046 | 7.1114 | 4229652.0 |
| 2007-12-31 10:55:00 | AAPL | Stock | 7.1125 | 7.1211 | 7.1111 | 7.1182 | 3401076.0 |
| 2007-12-31 11:00:00 | AAPL | Stock | 7.1182 | 7.1196 | 7.1114 | 7.1125 | 2892876.0 |
| 2007-12-31 11:05:00 | AAPL | Stock | 7.1132 | 7.1189 | 7.1089 | 7.1179 | 3214484.0 |
| 2007-12-31 11:10:00 | AAPL | Stock | 7.1179 | 7.1336 | 7.1136 | 7.1314 | 8439732.0 |
| 2007-12-31 11:15:00 | AAPL | Stock | 7.1314 | 7.1321 | 7.1175 | 7.1218 | 5560436.0 |
| 2007-12-31 11:20:00 | AAPL | Stock | 7.1236 | 7.1286 | 7.1171 | 7.1254 | 5495784.0 |
| 2007-12-31 11:25:00 | AAPL | Stock | 7.125 | 7.1393 | 7.125 | 7.1339 | 7941612.0 |
| 2007-12-31 11:30:00 | AAPL | Stock | 7.1339 | 7.1411 | 7.1326 | 7.1346 | 6588792.0 |
| 2007-12-31 11:35:00 | AAPL | Stock | 7.1354 | 7.1482 | 7.1304 | 7.1479 | 9059036.0 |
| 2007-12-31 11:40:00 | AAPL | Stock | 7.1479 | 7.1589 | 7.145 | 7.1504 | 10500000.0 |
| 2007-12-31 11:45:00 | AAPL | Stock | 7.1493 | 7.1607 | 7.1457 | 7.155 | 5269768.0 |
| 2007-12-31 11:50:00 | AAPL | Stock | 7.155 | 7.1604 | 7.1379 | 7.1414 | 6650224.0 |
| 2007-12-31 11:55:00 | AAPL | Stock | 7.1411 | 7.1464 | 7.1393 | 7.1461 | 3078628.0 |
> showing 50 of 335,974 rows — these rows as CSV