PREVIEW / stock_5min / 2004-12-06
file: by_date/stock_5min/2004/2004-12-06.parquet size: 2.6 MB rows: 188,946 symbols: 1,887
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-06 08:00:00 | AAPL | Stock | 1.1355 | 1.1454 | 1.1289 | 1.1427 | 7164640.0 |
| 2004-12-06 08:05:00 | AAPL | Stock | 1.1429 | 1.1464 | 1.1393 | 1.142 | 2255904.0 |
| 2004-12-06 08:10:00 | AAPL | Stock | 1.1423 | 1.1446 | 1.1404 | 1.1421 | 719992.0 |
| 2004-12-06 08:15:00 | AAPL | Stock | 1.1411 | 1.1411 | 1.1375 | 1.1375 | 1285760.0 |
| 2004-12-06 08:20:00 | AAPL | Stock | 1.1379 | 1.1389 | 1.1379 | 1.1388 | 221200.0 |
| 2004-12-06 08:25:00 | AAPL | Stock | 1.1389 | 1.1393 | 1.1339 | 1.1339 | 1511720.0 |
| 2004-12-06 08:30:00 | AAPL | Stock | 1.1339 | 1.1398 | 1.1338 | 1.1393 | 497112.0 |
| 2004-12-06 08:35:00 | AAPL | Stock | 1.1393 | 1.1402 | 1.1382 | 1.1391 | 851480.0 |
| 2004-12-06 08:40:00 | AAPL | Stock | 1.1391 | 1.1393 | 1.133 | 1.1375 | 474488.0 |
| 2004-12-06 08:45:00 | AAPL | Stock | 1.1375 | 1.1377 | 1.1359 | 1.137 | 184520.0 |
| 2004-12-06 08:50:00 | AAPL | Stock | 1.137 | 1.1389 | 1.137 | 1.1384 | 198520.0 |
| 2004-12-06 08:55:00 | AAPL | Stock | 1.1382 | 1.1404 | 1.1382 | 1.1382 | 541240.0 |
| 2004-12-06 09:00:00 | AAPL | Stock | 1.1382 | 1.1393 | 1.1371 | 1.1393 | 748944.0 |
| 2004-12-06 09:05:00 | AAPL | Stock | 1.1395 | 1.142 | 1.1221 | 1.1411 | 1729336.0 |
| 2004-12-06 09:10:00 | AAPL | Stock | 1.1411 | 1.1464 | 1.1411 | 1.1459 | 2728880.0 |
| 2004-12-06 09:15:00 | AAPL | Stock | 1.1452 | 1.1464 | 1.1359 | 1.1446 | 1070720.0 |
| 2004-12-06 09:20:00 | AAPL | Stock | 1.1438 | 1.1446 | 1.1429 | 1.1446 | 901320.0 |
| 2004-12-06 09:25:00 | AAPL | Stock | 1.125 | 1.1493 | 1.125 | 1.1488 | 7880152.0 |
| 2004-12-06 09:30:00 | AAPL | Stock | 1.1473 | 1.1545 | 1.1452 | 1.1509 | 74292008.0 |
| 2004-12-06 09:35:00 | AAPL | Stock | 1.1507 | 1.1518 | 1.1402 | 1.1455 | 45892448.0 |
| 2004-12-06 09:40:00 | AAPL | Stock | 1.1455 | 1.1486 | 1.1445 | 1.1461 | 28894936.0 |
| 2004-12-06 09:45:00 | AAPL | Stock | 1.1463 | 1.1464 | 1.1382 | 1.1389 | 25347728.0 |
| 2004-12-06 09:50:00 | AAPL | Stock | 1.1386 | 1.1414 | 1.1348 | 1.1373 | 26238968.0 |
| 2004-12-06 09:55:00 | AAPL | Stock | 1.137 | 1.1411 | 1.1366 | 1.1405 | 21182952.0 |
| 2004-12-06 10:00:00 | AAPL | Stock | 1.1407 | 1.1439 | 1.1402 | 1.1414 | 17697848.0 |
| 2004-12-06 10:05:00 | AAPL | Stock | 1.1416 | 1.1436 | 1.1373 | 1.1393 | 20008632.0 |
| 2004-12-06 10:10:00 | AAPL | Stock | 1.1393 | 1.1407 | 1.1354 | 1.1391 | 16709056.0 |
| 2004-12-06 10:15:00 | AAPL | Stock | 1.1391 | 1.1402 | 1.1348 | 1.1382 | 21531664.0 |
| 2004-12-06 10:20:00 | AAPL | Stock | 1.1384 | 1.14 | 1.1368 | 1.137 | 10570280.0 |
| 2004-12-06 10:25:00 | AAPL | Stock | 1.1371 | 1.1402 | 1.1368 | 1.1391 | 8845816.0 |
| 2004-12-06 10:30:00 | AAPL | Stock | 1.1391 | 1.1421 | 1.1379 | 1.1393 | 18157720.0 |
| 2004-12-06 10:35:00 | AAPL | Stock | 1.1393 | 1.1398 | 1.1364 | 1.1364 | 10939544.0 |
| 2004-12-06 10:40:00 | AAPL | Stock | 1.1363 | 1.1368 | 1.1289 | 1.133 | 28221424.0 |
| 2004-12-06 10:45:00 | AAPL | Stock | 1.133 | 1.1339 | 1.1305 | 1.1316 | 13121416.0 |
| 2004-12-06 10:50:00 | AAPL | Stock | 1.1316 | 1.132 | 1.1241 | 1.1295 | 30146312.0 |
| 2004-12-06 10:55:00 | AAPL | Stock | 1.1268 | 1.1305 | 1.1268 | 1.1293 | 10058496.0 |
| 2004-12-06 11:00:00 | AAPL | Stock | 1.1293 | 1.1302 | 1.1245 | 1.1246 | 12534536.0 |
| 2004-12-06 11:05:00 | AAPL | Stock | 1.1246 | 1.1296 | 1.1246 | 1.1282 | 13228096.0 |
| 2004-12-06 11:10:00 | AAPL | Stock | 1.128 | 1.1323 | 1.128 | 1.1311 | 11671688.0 |
| 2004-12-06 11:15:00 | AAPL | Stock | 1.1311 | 1.1366 | 1.1304 | 1.1364 | 16716392.0 |
| 2004-12-06 11:20:00 | AAPL | Stock | 1.1364 | 1.1382 | 1.1339 | 1.1341 | 15464568.0 |
| 2004-12-06 11:25:00 | AAPL | Stock | 1.1341 | 1.1375 | 1.1341 | 1.1361 | 5490296.0 |
| 2004-12-06 11:30:00 | AAPL | Stock | 1.1361 | 1.1379 | 1.1357 | 1.1366 | 5634608.0 |
| 2004-12-06 11:35:00 | AAPL | Stock | 1.1368 | 1.1375 | 1.1361 | 1.137 | 3473960.0 |
| 2004-12-06 11:40:00 | AAPL | Stock | 1.1371 | 1.1407 | 1.137 | 1.14 | 16736384.0 |
| 2004-12-06 11:45:00 | AAPL | Stock | 1.1393 | 1.1396 | 1.1366 | 1.1368 | 5275984.0 |
| 2004-12-06 11:50:00 | AAPL | Stock | 1.137 | 1.1393 | 1.1366 | 1.1386 | 3186848.0 |
| 2004-12-06 11:55:00 | AAPL | Stock | 1.1384 | 1.1384 | 1.137 | 1.137 | 2278136.0 |
| 2004-12-06 12:00:00 | AAPL | Stock | 1.137 | 1.1377 | 1.1348 | 1.1355 | 5143600.0 |
| 2004-12-06 12:05:00 | AAPL | Stock | 1.1355 | 1.1363 | 1.1348 | 1.1361 | 4255328.0 |
> showing 50 of 188,946 rows — these rows as CSV