PREVIEW / stock_5min / 2007-12-26
file: by_date/stock_5min/2007/2007-12-26.parquet size: 4.3 MB rows: 322,067 symbols: 3,250
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-26 07:15:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1071 | 7.1071 | 2800.0 |
| 2007-12-26 07:20:00 | AAPL | Stock | 7.1307 | 7.1307 | 7.1268 | 7.1268 | 67200.0 |
| 2007-12-26 07:25:00 | AAPL | Stock | 7.1214 | 7.1286 | 7.1214 | 7.1286 | 33600.0 |
| 2007-12-26 07:30:00 | AAPL | Stock | 7.1379 | 7.1429 | 7.1379 | 7.1393 | 121800.0 |
| 2007-12-26 07:35:00 | AAPL | Stock | 7.1396 | 7.1429 | 7.1393 | 7.1429 | 99232.0 |
| 2007-12-26 07:40:00 | AAPL | Stock | 7.1429 | 7.1464 | 7.1321 | 7.1321 | 155960.0 |
| 2007-12-26 07:50:00 | AAPL | Stock | 7.1196 | 7.1196 | 7.1196 | 7.1196 | 5600.0 |
| 2007-12-26 07:55:00 | AAPL | Stock | 7.1221 | 7.1221 | 7.1146 | 7.1146 | 28000.0 |
| 2007-12-26 08:00:00 | AAPL | Stock | 7.1214 | 7.15 | 7.1214 | 7.1446 | 1523228.0 |
| 2007-12-26 08:05:00 | AAPL | Stock | 7.1464 | 7.1468 | 7.135 | 7.1429 | 1385440.0 |
| 2007-12-26 08:10:00 | AAPL | Stock | 7.1464 | 7.1768 | 7.1454 | 7.1679 | 878388.0 |
| 2007-12-26 08:15:00 | AAPL | Stock | 7.1657 | 7.1711 | 7.1536 | 7.1536 | 761208.0 |
| 2007-12-26 08:20:00 | AAPL | Stock | 7.1521 | 7.1575 | 7.15 | 7.1514 | 481180.0 |
| 2007-12-26 08:25:00 | AAPL | Stock | 7.1536 | 7.1543 | 7.1482 | 7.1521 | 281372.0 |
| 2007-12-26 08:30:00 | AAPL | Stock | 7.1525 | 7.1543 | 7.1386 | 7.1482 | 687176.0 |
| 2007-12-26 08:35:00 | AAPL | Stock | 7.1464 | 7.1529 | 7.1454 | 7.1454 | 210532.0 |
| 2007-12-26 08:40:00 | AAPL | Stock | 7.1432 | 7.1439 | 7.1346 | 7.1393 | 698712.0 |
| 2007-12-26 08:45:00 | AAPL | Stock | 7.1393 | 7.1393 | 7.135 | 7.135 | 314160.0 |
| 2007-12-26 08:50:00 | AAPL | Stock | 7.135 | 7.1371 | 7.1286 | 7.1357 | 538664.0 |
| 2007-12-26 08:55:00 | AAPL | Stock | 7.1379 | 7.1393 | 7.1321 | 7.1321 | 783440.0 |
| 2007-12-26 09:00:00 | AAPL | Stock | 7.1321 | 7.1325 | 7.1107 | 7.1246 | 968408.0 |
| 2007-12-26 09:05:00 | AAPL | Stock | 7.125 | 7.1268 | 7.1143 | 7.1189 | 672868.0 |
| 2007-12-26 09:10:00 | AAPL | Stock | 7.1225 | 7.1236 | 7.1011 | 7.1071 | 1452136.0 |
| 2007-12-26 09:15:00 | AAPL | Stock | 7.1068 | 7.1179 | 7.1054 | 7.1054 | 299460.0 |
| 2007-12-26 09:20:00 | AAPL | Stock | 7.1054 | 7.1214 | 7.1029 | 7.1204 | 573888.0 |
| 2007-12-26 09:25:00 | AAPL | Stock | 7.12 | 7.1207 | 7.1046 | 7.1079 | 1050700.0 |
| 2007-12-26 09:30:00 | AAPL | Stock | 7.1075 | 7.1125 | 7.0643 | 7.0714 | 28582036.0 |
| 2007-12-26 09:35:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0293 | 7.0461 | 28714588.0 |
| 2007-12-26 09:40:00 | AAPL | Stock | 7.0464 | 7.0868 | 7.0396 | 7.0768 | 17470684.0 |
| 2007-12-26 09:45:00 | AAPL | Stock | 7.0768 | 7.0771 | 7.055 | 7.0589 | 10329676.0 |
| 2007-12-26 09:50:00 | AAPL | Stock | 7.06 | 7.0671 | 7.0554 | 7.0596 | 6398140.0 |
| 2007-12-26 09:55:00 | AAPL | Stock | 7.0596 | 7.0596 | 7.0375 | 7.0525 | 11145904.0 |
| 2007-12-26 10:00:00 | AAPL | Stock | 7.0525 | 7.06 | 7.0425 | 7.0525 | 7033208.0 |
| 2007-12-26 10:05:00 | AAPL | Stock | 7.0525 | 7.0568 | 7.0393 | 7.0561 | 8041236.0 |
| 2007-12-26 10:10:00 | AAPL | Stock | 7.055 | 7.0671 | 7.0536 | 7.0596 | 7742868.0 |
| 2007-12-26 10:15:00 | AAPL | Stock | 7.06 | 7.0871 | 7.0571 | 7.0868 | 9225748.0 |
| 2007-12-26 10:20:00 | AAPL | Stock | 7.085 | 7.1036 | 7.0839 | 7.0979 | 11308388.0 |
| 2007-12-26 10:25:00 | AAPL | Stock | 7.0989 | 7.1118 | 7.0964 | 7.1007 | 12495924.0 |
| 2007-12-26 10:30:00 | AAPL | Stock | 7.1011 | 7.1064 | 7.0943 | 7.1046 | 7106288.0 |
| 2007-12-26 10:35:00 | AAPL | Stock | 7.1043 | 7.1046 | 7.0779 | 7.0818 | 7387072.0 |
| 2007-12-26 10:40:00 | AAPL | Stock | 7.0814 | 7.0836 | 7.0643 | 7.0782 | 8331400.0 |
| 2007-12-26 10:45:00 | AAPL | Stock | 7.0782 | 7.1018 | 7.0768 | 7.1007 | 6753404.0 |
| 2007-12-26 10:50:00 | AAPL | Stock | 7.1018 | 7.1225 | 7.0971 | 7.1159 | 11739644.0 |
| 2007-12-26 10:55:00 | AAPL | Stock | 7.1161 | 7.1168 | 7.1021 | 7.1089 | 6638856.0 |
| 2007-12-26 11:00:00 | AAPL | Stock | 7.11 | 7.1311 | 7.1046 | 7.1304 | 10698912.0 |
| 2007-12-26 11:05:00 | AAPL | Stock | 7.13 | 7.1375 | 7.1232 | 7.1304 | 12043836.0 |
| 2007-12-26 11:10:00 | AAPL | Stock | 7.13 | 7.1418 | 7.1293 | 7.1325 | 11163600.0 |
| 2007-12-26 11:15:00 | AAPL | Stock | 7.1321 | 7.1393 | 7.1286 | 7.1389 | 7564452.0 |
| 2007-12-26 11:20:00 | AAPL | Stock | 7.1375 | 7.1411 | 7.1329 | 7.1343 | 5794964.0 |
| 2007-12-26 11:25:00 | AAPL | Stock | 7.1343 | 7.1346 | 7.0975 | 7.1004 | 17196060.0 |
> showing 50 of 322,067 rows — these rows as CSV