PREVIEW / stock_5min / 2007-09-21
file: by_date/stock_5min/2007/2007-09-21.parquet size: 4.1 MB rows: 299,957 symbols: 3,120
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-09-21 09:30:00 | AAPL | Stock | 5.0407 | 5.0446 | 5.0221 | 5.034 | 19976348.0 |
| 2007-09-21 09:35:00 | AAPL | Stock | 5.0339 | 5.0461 | 5.0239 | 5.035 | 15865808.0 |
| 2007-09-21 09:40:00 | AAPL | Stock | 5.0354 | 5.0482 | 5.0325 | 5.0468 | 15685012.0 |
| 2007-09-21 09:45:00 | AAPL | Stock | 5.0468 | 5.05 | 5.0357 | 5.0361 | 11201708.0 |
| 2007-09-21 09:50:00 | AAPL | Stock | 5.0364 | 5.0429 | 5.0357 | 5.0407 | 11557448.0 |
| 2007-09-21 09:55:00 | AAPL | Stock | 5.0407 | 5.0439 | 5.0357 | 5.0407 | 8028580.0 |
| 2007-09-21 10:00:00 | AAPL | Stock | 5.0404 | 5.05 | 5.0371 | 5.05 | 11628680.0 |
| 2007-09-21 10:05:00 | AAPL | Stock | 5.0482 | 5.0707 | 5.0482 | 5.0571 | 19746748.0 |
| 2007-09-21 10:10:00 | AAPL | Stock | 5.0579 | 5.0675 | 5.0546 | 5.065 | 9145836.0 |
| 2007-09-21 10:15:00 | AAPL | Stock | 5.065 | 5.0657 | 5.0518 | 5.0554 | 8576988.0 |
| 2007-09-21 10:20:00 | AAPL | Stock | 5.0554 | 5.0589 | 5.0543 | 5.0557 | 4319140.0 |
| 2007-09-21 10:25:00 | AAPL | Stock | 5.0557 | 5.0789 | 5.0543 | 5.0714 | 25766664.0 |
| 2007-09-21 10:30:00 | AAPL | Stock | 5.0714 | 5.0725 | 5.0625 | 5.07 | 9102548.0 |
| 2007-09-21 10:35:00 | AAPL | Stock | 5.07 | 5.0904 | 5.0692 | 5.085 | 31004120.0 |
| 2007-09-21 10:40:00 | AAPL | Stock | 5.0857 | 5.1089 | 5.0839 | 5.1029 | 33421444.0 |
| 2007-09-21 10:45:00 | AAPL | Stock | 5.1029 | 5.1032 | 5.0943 | 5.1021 | 10945872.0 |
| 2007-09-21 10:50:00 | AAPL | Stock | 5.1018 | 5.1054 | 5.0946 | 5.1039 | 8637636.0 |
| 2007-09-21 10:55:00 | AAPL | Stock | 5.1039 | 5.1086 | 5.0982 | 5.1018 | 13358688.0 |
| 2007-09-21 11:00:00 | AAPL | Stock | 5.1014 | 5.1193 | 5.1011 | 5.1135 | 18430916.0 |
| 2007-09-21 11:05:00 | AAPL | Stock | 5.1132 | 5.1214 | 5.1125 | 5.1132 | 12555648.0 |
| 2007-09-21 11:10:00 | AAPL | Stock | 5.1139 | 5.1168 | 5.1093 | 5.1143 | 10216472.0 |
| 2007-09-21 11:15:00 | AAPL | Stock | 5.1146 | 5.1232 | 5.1143 | 5.1232 | 10059504.0 |
| 2007-09-21 11:20:00 | AAPL | Stock | 5.1232 | 5.1307 | 5.1189 | 5.125 | 15261008.0 |
| 2007-09-21 11:25:00 | AAPL | Stock | 5.125 | 5.1375 | 5.1236 | 5.1371 | 14299320.0 |
| 2007-09-21 11:30:00 | AAPL | Stock | 5.1371 | 5.1375 | 5.1214 | 5.1296 | 16384676.0 |
| 2007-09-21 11:35:00 | AAPL | Stock | 5.1303 | 5.1321 | 5.1243 | 5.1243 | 9053548.0 |
| 2007-09-21 11:40:00 | AAPL | Stock | 5.1239 | 5.1286 | 5.1157 | 5.1257 | 11897928.0 |
| 2007-09-21 11:45:00 | AAPL | Stock | 5.1254 | 5.1332 | 5.1246 | 5.1332 | 6906900.0 |
| 2007-09-21 11:50:00 | AAPL | Stock | 5.1336 | 5.1429 | 5.1329 | 5.1421 | 15384096.0 |
| 2007-09-21 11:55:00 | AAPL | Stock | 5.1418 | 5.1429 | 5.135 | 5.1407 | 11472216.0 |
| 2007-09-21 12:00:00 | AAPL | Stock | 5.1407 | 5.1407 | 5.1336 | 5.1386 | 9924544.0 |
| 2007-09-21 12:05:00 | AAPL | Stock | 5.1382 | 5.1475 | 5.1364 | 5.1436 | 15208704.0 |
| 2007-09-21 12:10:00 | AAPL | Stock | 5.1443 | 5.1443 | 5.1357 | 5.1396 | 6641992.0 |
| 2007-09-21 12:15:00 | AAPL | Stock | 5.1393 | 5.14 | 5.1329 | 5.135 | 5321708.0 |
| 2007-09-21 12:20:00 | AAPL | Stock | 5.135 | 5.1407 | 5.1339 | 5.1354 | 5301660.0 |
| 2007-09-21 12:25:00 | AAPL | Stock | 5.1354 | 5.1393 | 5.1329 | 5.1388 | 5098408.0 |
| 2007-09-21 12:30:00 | AAPL | Stock | 5.1382 | 5.1446 | 5.1382 | 5.1404 | 7888160.0 |
| 2007-09-21 12:35:00 | AAPL | Stock | 5.1403 | 5.1404 | 5.1375 | 5.1393 | 3577420.0 |
| 2007-09-21 12:40:00 | AAPL | Stock | 5.1389 | 5.1407 | 5.1361 | 5.1396 | 4652872.0 |
| 2007-09-21 12:45:00 | AAPL | Stock | 5.1404 | 5.1439 | 5.1382 | 5.1414 | 5333832.0 |
| 2007-09-21 12:50:00 | AAPL | Stock | 5.1414 | 5.1425 | 5.1346 | 5.1357 | 4762156.0 |
| 2007-09-21 12:55:00 | AAPL | Stock | 5.1357 | 5.1386 | 5.1339 | 5.1368 | 4254348.0 |
| 2007-09-21 13:00:00 | AAPL | Stock | 5.1371 | 5.1393 | 5.1357 | 5.1382 | 3018960.0 |
| 2007-09-21 13:05:00 | AAPL | Stock | 5.1375 | 5.1379 | 5.1286 | 5.1307 | 9025660.0 |
| 2007-09-21 13:10:00 | AAPL | Stock | 5.1307 | 5.1318 | 5.1181 | 5.1181 | 13404020.0 |
| 2007-09-21 13:15:00 | AAPL | Stock | 5.1189 | 5.125 | 5.1164 | 5.1211 | 7796908.0 |
| 2007-09-21 13:20:00 | AAPL | Stock | 5.1214 | 5.1264 | 5.12 | 5.125 | 6296808.0 |
| 2007-09-21 13:25:00 | AAPL | Stock | 5.1246 | 5.1264 | 5.1207 | 5.1254 | 5304320.0 |
| 2007-09-21 13:30:00 | AAPL | Stock | 5.1257 | 5.1314 | 5.1211 | 5.1229 | 9121224.0 |
| 2007-09-21 13:35:00 | AAPL | Stock | 5.1229 | 5.1268 | 5.1179 | 5.1239 | 5836796.0 |
> showing 50 of 299,957 rows — these rows as CSV