PREVIEW / stock_5min / 2008-01-02
file: by_date/stock_5min/2008/2008-01-02.parquet size: 4.5 MB rows: 328,075 symbols: 3,257
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-02 05:55:00 | AAPL | Stock | 7.1239 | 7.125 | 7.1239 | 7.125 | 56000.0 |
| 2008-01-02 06:00:00 | AAPL | Stock | 7.1246 | 7.1246 | 7.1246 | 7.1246 | 2800.0 |
| 2008-01-02 06:05:00 | AAPL | Stock | 7.1246 | 7.1246 | 7.1246 | 7.1246 | 22400.0 |
| 2008-01-02 06:15:00 | AAPL | Stock | 7.1246 | 7.1246 | 7.1246 | 7.1246 | 2800.0 |
| 2008-01-02 06:20:00 | AAPL | Stock | 7.1246 | 7.1246 | 7.1246 | 7.1246 | 12880.0 |
| 2008-01-02 06:50:00 | AAPL | Stock | 7.1286 | 7.1364 | 7.1286 | 7.1364 | 78400.0 |
| 2008-01-02 07:00:00 | AAPL | Stock | 7.1364 | 7.1364 | 7.1296 | 7.1307 | 11200.0 |
| 2008-01-02 07:05:00 | AAPL | Stock | 7.1311 | 7.135 | 7.1286 | 7.1286 | 14000.0 |
| 2008-01-02 07:10:00 | AAPL | Stock | 7.1329 | 7.1329 | 7.125 | 7.125 | 8400.0 |
| 2008-01-02 07:15:00 | AAPL | Stock | 7.1232 | 7.1232 | 7.1179 | 7.1179 | 16800.0 |
| 2008-01-02 07:20:00 | AAPL | Stock | 7.1179 | 7.1232 | 7.1179 | 7.1179 | 9800.0 |
| 2008-01-02 07:25:00 | AAPL | Stock | 7.13 | 7.13 | 7.13 | 7.13 | 2800.0 |
| 2008-01-02 07:30:00 | AAPL | Stock | 7.1304 | 7.14 | 7.1304 | 7.1357 | 64400.0 |
| 2008-01-02 07:35:00 | AAPL | Stock | 7.1371 | 7.1379 | 7.1318 | 7.1379 | 126000.0 |
| 2008-01-02 07:40:00 | AAPL | Stock | 7.1371 | 7.1404 | 7.1371 | 7.1404 | 5600.0 |
| 2008-01-02 07:45:00 | AAPL | Stock | 7.1389 | 7.1389 | 7.135 | 7.1389 | 29400.0 |
| 2008-01-02 07:50:00 | AAPL | Stock | 7.1357 | 7.1389 | 7.1321 | 7.1321 | 84000.0 |
| 2008-01-02 07:55:00 | AAPL | Stock | 7.1321 | 7.1321 | 7.1286 | 7.1304 | 70000.0 |
| 2008-01-02 08:00:00 | AAPL | Stock | 7.1318 | 7.1382 | 7.0743 | 7.1239 | 3025792.0 |
| 2008-01-02 08:05:00 | AAPL | Stock | 7.1207 | 7.1239 | 7.1179 | 7.1179 | 405272.0 |
| 2008-01-02 08:10:00 | AAPL | Stock | 7.1179 | 7.1214 | 7.1036 | 7.1071 | 562520.0 |
| 2008-01-02 08:15:00 | AAPL | Stock | 7.1071 | 7.1114 | 7.1021 | 7.1054 | 269276.0 |
| 2008-01-02 08:20:00 | AAPL | Stock | 7.1071 | 7.1114 | 7.0975 | 7.1071 | 546812.0 |
| 2008-01-02 08:25:00 | AAPL | Stock | 7.1079 | 7.1079 | 7.1021 | 7.1064 | 120120.0 |
| 2008-01-02 08:30:00 | AAPL | Stock | 7.1043 | 7.1093 | 7.1 | 7.1079 | 331800.0 |
| 2008-01-02 08:35:00 | AAPL | Stock | 7.1093 | 7.1096 | 7.1071 | 7.1071 | 61040.0 |
| 2008-01-02 08:40:00 | AAPL | Stock | 7.1086 | 7.1114 | 7.1071 | 7.1071 | 82320.0 |
| 2008-01-02 08:45:00 | AAPL | Stock | 7.1068 | 7.1104 | 7.1018 | 7.1036 | 224196.0 |
| 2008-01-02 08:50:00 | AAPL | Stock | 7.1036 | 7.1036 | 7.1018 | 7.1036 | 169624.0 |
| 2008-01-02 08:55:00 | AAPL | Stock | 7.1021 | 7.1036 | 7.0964 | 7.0964 | 311360.0 |
| 2008-01-02 09:00:00 | AAPL | Stock | 7.0982 | 7.1032 | 7.0982 | 7.1014 | 96544.0 |
| 2008-01-02 09:05:00 | AAPL | Stock | 7.1025 | 7.11 | 7.1014 | 7.1071 | 222768.0 |
| 2008-01-02 09:10:00 | AAPL | Stock | 7.1061 | 7.1064 | 7.1046 | 7.1046 | 31500.0 |
| 2008-01-02 09:15:00 | AAPL | Stock | 7.1011 | 7.1011 | 7.0743 | 7.0921 | 426440.0 |
| 2008-01-02 09:20:00 | AAPL | Stock | 7.095 | 7.0971 | 7.0889 | 7.0971 | 273700.0 |
| 2008-01-02 09:25:00 | AAPL | Stock | 7.0961 | 7.1357 | 7.0825 | 7.1196 | 2022020.0 |
| 2008-01-02 09:30:00 | AAPL | Stock | 7.1179 | 7.1286 | 7.0993 | 7.1207 | 23584288.0 |
| 2008-01-02 09:35:00 | AAPL | Stock | 7.12 | 7.1246 | 7.0911 | 7.1068 | 19271056.0 |
| 2008-01-02 09:40:00 | AAPL | Stock | 7.1057 | 7.1464 | 7.1054 | 7.1307 | 25934944.0 |
| 2008-01-02 09:45:00 | AAPL | Stock | 7.1304 | 7.1318 | 7.1189 | 7.1254 | 12018272.0 |
| 2008-01-02 09:50:00 | AAPL | Stock | 7.1254 | 7.1464 | 7.1214 | 7.1379 | 13470772.0 |
| 2008-01-02 09:55:00 | AAPL | Stock | 7.1382 | 7.1504 | 7.1257 | 7.1486 | 14702016.0 |
| 2008-01-02 10:00:00 | AAPL | Stock | 7.1493 | 7.1493 | 7.1032 | 7.1179 | 23635472.0 |
| 2008-01-02 10:05:00 | AAPL | Stock | 7.1175 | 7.1286 | 7.1043 | 7.1107 | 17846584.0 |
| 2008-01-02 10:10:00 | AAPL | Stock | 7.1107 | 7.1229 | 7.1032 | 7.1171 | 12051536.0 |
| 2008-01-02 10:15:00 | AAPL | Stock | 7.1175 | 7.1368 | 7.1125 | 7.1346 | 14681408.0 |
| 2008-01-02 10:20:00 | AAPL | Stock | 7.1354 | 7.1521 | 7.1293 | 7.1364 | 16588376.0 |
| 2008-01-02 10:25:00 | AAPL | Stock | 7.1371 | 7.1445 | 7.1321 | 7.1393 | 8627724.0 |
| 2008-01-02 10:30:00 | AAPL | Stock | 7.1379 | 7.1464 | 7.1289 | 7.1361 | 13145132.0 |
| 2008-01-02 10:35:00 | AAPL | Stock | 7.1364 | 7.1407 | 7.1157 | 7.1157 | 8161244.0 |
> showing 50 of 328,075 rows — these rows as CSV