PREVIEW / stock_5min / 2005-11-08
file: by_date/stock_5min/2005/2005-11-08.parquet size: 2.8 MB rows: 203,501 symbols: 2,110
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-08 07:15:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1536 | 2.1536 | 5600.0 |
| 2005-11-08 07:40:00 | AAPL | Stock | 2.1518 | 2.1518 | 2.1511 | 2.1511 | 16800.0 |
| 2005-11-08 08:00:00 | AAPL | Stock | 2.1536 | 2.1536 | 2.15 | 2.1507 | 269780.0 |
| 2005-11-08 08:05:00 | AAPL | Stock | 2.1521 | 2.1521 | 2.15 | 2.15 | 56000.0 |
| 2005-11-08 08:10:00 | AAPL | Stock | 2.1511 | 2.1511 | 2.15 | 2.15 | 112280.0 |
| 2005-11-08 08:15:00 | AAPL | Stock | 2.15 | 2.15 | 2.15 | 2.15 | 5600.0 |
| 2005-11-08 08:20:00 | AAPL | Stock | 2.15 | 2.15 | 2.1464 | 2.1471 | 28000.0 |
| 2005-11-08 08:25:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1454 | 2.1454 | 114800.0 |
| 2005-11-08 08:30:00 | AAPL | Stock | 2.1436 | 2.1446 | 2.1411 | 2.1429 | 222236.0 |
| 2005-11-08 08:35:00 | AAPL | Stock | 2.1446 | 2.1446 | 2.1429 | 2.1429 | 174300.0 |
| 2005-11-08 08:40:00 | AAPL | Stock | 2.1429 | 2.1429 | 2.1414 | 2.1414 | 20384.0 |
| 2005-11-08 08:45:00 | AAPL | Stock | 2.1429 | 2.1429 | 2.1414 | 2.1429 | 214900.0 |
| 2005-11-08 08:50:00 | AAPL | Stock | 2.1429 | 2.1429 | 2.1386 | 2.1393 | 187208.0 |
| 2005-11-08 08:55:00 | AAPL | Stock | 2.1393 | 2.1393 | 2.1393 | 2.1393 | 47992.0 |
| 2005-11-08 09:00:00 | AAPL | Stock | 2.1393 | 2.1393 | 2.1361 | 2.1371 | 114884.0 |
| 2005-11-08 09:05:00 | AAPL | Stock | 2.1371 | 2.1389 | 2.1371 | 2.1389 | 10584.0 |
| 2005-11-08 09:10:00 | AAPL | Stock | 2.1382 | 2.1393 | 2.1375 | 2.1389 | 75600.0 |
| 2005-11-08 09:15:00 | AAPL | Stock | 2.1407 | 2.1411 | 2.1389 | 2.1411 | 756280.0 |
| 2005-11-08 09:20:00 | AAPL | Stock | 2.1407 | 2.1407 | 2.1375 | 2.1375 | 107800.0 |
| 2005-11-08 09:25:00 | AAPL | Stock | 2.1418 | 2.1418 | 2.1375 | 2.1379 | 979776.0 |
| 2005-11-08 09:30:00 | AAPL | Stock | 2.1411 | 2.1425 | 2.1161 | 2.1239 | 28207900.0 |
| 2005-11-08 09:35:00 | AAPL | Stock | 2.1239 | 2.1257 | 2.115 | 2.1157 | 17777452.0 |
| 2005-11-08 09:40:00 | AAPL | Stock | 2.1154 | 2.125 | 2.1154 | 2.1186 | 16147740.0 |
| 2005-11-08 09:45:00 | AAPL | Stock | 2.1182 | 2.1232 | 2.1161 | 2.1182 | 12459888.0 |
| 2005-11-08 09:50:00 | AAPL | Stock | 2.1182 | 2.1189 | 2.1107 | 2.1143 | 13346900.0 |
| 2005-11-08 09:55:00 | AAPL | Stock | 2.115 | 2.12 | 2.1136 | 2.1189 | 8117732.0 |
| 2005-11-08 10:00:00 | AAPL | Stock | 2.1193 | 2.1243 | 2.1175 | 2.1204 | 10747800.0 |
| 2005-11-08 10:05:00 | AAPL | Stock | 2.121 | 2.1229 | 2.1182 | 2.1186 | 7243348.0 |
| 2005-11-08 10:10:00 | AAPL | Stock | 2.1186 | 2.1211 | 2.1125 | 2.1182 | 11295564.0 |
| 2005-11-08 10:15:00 | AAPL | Stock | 2.1186 | 2.1218 | 2.1171 | 2.119 | 6167952.0 |
| 2005-11-08 10:20:00 | AAPL | Stock | 2.1189 | 2.1214 | 2.1171 | 2.1182 | 3885756.0 |
| 2005-11-08 10:25:00 | AAPL | Stock | 2.1182 | 2.1214 | 2.1164 | 2.1214 | 5397392.0 |
| 2005-11-08 10:30:00 | AAPL | Stock | 2.1214 | 2.1314 | 2.1211 | 2.1257 | 11740764.0 |
| 2005-11-08 10:35:00 | AAPL | Stock | 2.1261 | 2.1286 | 2.1225 | 2.125 | 7030576.0 |
| 2005-11-08 10:40:00 | AAPL | Stock | 2.125 | 2.1282 | 2.1204 | 2.1214 | 5485116.0 |
| 2005-11-08 10:45:00 | AAPL | Stock | 2.1211 | 2.1221 | 2.1179 | 2.1221 | 5070296.0 |
| 2005-11-08 10:50:00 | AAPL | Stock | 2.1221 | 2.1268 | 2.1214 | 2.1257 | 4107292.0 |
| 2005-11-08 10:55:00 | AAPL | Stock | 2.1254 | 2.1257 | 2.1196 | 2.1246 | 3838072.0 |
| 2005-11-08 11:00:00 | AAPL | Stock | 2.1246 | 2.1268 | 2.1225 | 2.1229 | 3753344.0 |
| 2005-11-08 11:05:00 | AAPL | Stock | 2.1229 | 2.1239 | 2.1211 | 2.1236 | 4579344.0 |
| 2005-11-08 11:10:00 | AAPL | Stock | 2.1239 | 2.1257 | 2.1196 | 2.1214 | 4690140.0 |
| 2005-11-08 11:15:00 | AAPL | Stock | 2.1214 | 2.1232 | 2.12 | 2.1229 | 3525144.0 |
| 2005-11-08 11:20:00 | AAPL | Stock | 2.1225 | 2.1307 | 2.1225 | 2.13 | 7746172.0 |
| 2005-11-08 11:25:00 | AAPL | Stock | 2.1296 | 2.1311 | 2.1261 | 2.1271 | 4279016.0 |
| 2005-11-08 11:30:00 | AAPL | Stock | 2.1268 | 2.1293 | 2.1236 | 2.1254 | 3959592.0 |
| 2005-11-08 11:35:00 | AAPL | Stock | 2.1257 | 2.1279 | 2.125 | 2.1271 | 2476152.0 |
| 2005-11-08 11:40:00 | AAPL | Stock | 2.1275 | 2.1293 | 2.1264 | 2.1293 | 2492476.0 |
| 2005-11-08 11:45:00 | AAPL | Stock | 2.1293 | 2.1357 | 2.1286 | 2.1357 | 8728496.0 |
| 2005-11-08 11:50:00 | AAPL | Stock | 2.1357 | 2.145 | 2.1318 | 2.1436 | 14510076.0 |
| 2005-11-08 11:55:00 | AAPL | Stock | 2.1436 | 2.1496 | 2.1418 | 2.1464 | 11785284.0 |
> showing 50 of 203,501 rows — these rows as CSV