PREVIEW / stock_5min / 2000-03-21
file: by_date/stock_5min/2000/2000-03-21.parquet size: 1.2 MB rows: 87,899 symbols: 1,148
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-21 09:30:00 | AAPL | Stock | 1.0943 | 1.0982 | 1.0915 | 1.0971 | 4558400.0 |
| 2000-03-21 09:35:00 | AAPL | Stock | 1.0938 | 1.0982 | 1.0932 | 1.0943 | 2139200.0 |
| 2000-03-21 09:40:00 | AAPL | Stock | 1.0943 | 1.0971 | 1.0893 | 1.0893 | 1881600.0 |
| 2000-03-21 09:45:00 | AAPL | Stock | 1.0893 | 1.0938 | 1.0859 | 1.0898 | 1702400.0 |
| 2000-03-21 09:50:00 | AAPL | Stock | 1.0871 | 1.0932 | 1.0865 | 1.0871 | 2430400.0 |
| 2000-03-21 09:55:00 | AAPL | Stock | 1.0859 | 1.0938 | 1.0859 | 1.0915 | 3427200.0 |
| 2000-03-21 10:00:00 | AAPL | Stock | 1.0938 | 1.1049 | 1.0904 | 1.1038 | 3404800.0 |
| 2000-03-21 10:05:00 | AAPL | Stock | 1.1021 | 1.1116 | 1.0971 | 1.1071 | 4188800.0 |
| 2000-03-21 10:10:00 | AAPL | Stock | 1.1071 | 1.1261 | 1.1038 | 1.1256 | 6036800.0 |
| 2000-03-21 10:15:00 | AAPL | Stock | 1.1258 | 1.1339 | 1.125 | 1.1328 | 7011200.0 |
| 2000-03-21 10:20:00 | AAPL | Stock | 1.1311 | 1.1339 | 1.1272 | 1.1328 | 3416000.0 |
| 2000-03-21 10:25:00 | AAPL | Stock | 1.1337 | 1.1429 | 1.1317 | 1.1429 | 11121600.0 |
| 2000-03-21 10:30:00 | AAPL | Stock | 1.1429 | 1.1429 | 1.1328 | 1.1334 | 6552000.0 |
| 2000-03-21 10:35:00 | AAPL | Stock | 1.1334 | 1.1429 | 1.1334 | 1.1373 | 4984000.0 |
| 2000-03-21 10:40:00 | AAPL | Stock | 1.1384 | 1.1401 | 1.1295 | 1.1317 | 2688000.0 |
| 2000-03-21 10:45:00 | AAPL | Stock | 1.1311 | 1.1384 | 1.13 | 1.1311 | 3416000.0 |
| 2000-03-21 10:50:00 | AAPL | Stock | 1.1328 | 1.1384 | 1.1328 | 1.137 | 1971200.0 |
| 2000-03-21 10:55:00 | AAPL | Stock | 1.137 | 1.1445 | 1.137 | 1.1406 | 5051200.0 |
| 2000-03-21 11:00:00 | AAPL | Stock | 1.1417 | 1.1417 | 1.1373 | 1.1373 | 4278400.0 |
| 2000-03-21 11:05:00 | AAPL | Stock | 1.1384 | 1.1473 | 1.1384 | 1.1473 | 2464000.0 |
| 2000-03-21 11:10:00 | AAPL | Stock | 1.1473 | 1.1523 | 1.1429 | 1.1431 | 10841600.0 |
| 2000-03-21 11:15:00 | AAPL | Stock | 1.1412 | 1.1507 | 1.1384 | 1.1392 | 4939200.0 |
| 2000-03-21 11:20:00 | AAPL | Stock | 1.1401 | 1.1423 | 1.1384 | 1.1401 | 2788800.0 |
| 2000-03-21 11:25:00 | AAPL | Stock | 1.1401 | 1.1429 | 1.1384 | 1.1423 | 9396800.0 |
| 2000-03-21 11:30:00 | AAPL | Stock | 1.1406 | 1.1473 | 1.1406 | 1.1468 | 5622400.0 |
| 2000-03-21 11:35:00 | AAPL | Stock | 1.1468 | 1.1496 | 1.1401 | 1.1401 | 3718400.0 |
| 2000-03-21 11:40:00 | AAPL | Stock | 1.1401 | 1.1462 | 1.1395 | 1.1429 | 2262400.0 |
| 2000-03-21 11:45:00 | AAPL | Stock | 1.144 | 1.1468 | 1.1434 | 1.1451 | 3684800.0 |
| 2000-03-21 11:50:00 | AAPL | Stock | 1.1434 | 1.1462 | 1.1434 | 1.1451 | 1612800.0 |
| 2000-03-21 11:55:00 | AAPL | Stock | 1.1468 | 1.1479 | 1.1429 | 1.1468 | 4345600.0 |
| 2000-03-21 12:00:00 | AAPL | Stock | 1.1451 | 1.1468 | 1.1429 | 1.1462 | 2956800.0 |
| 2000-03-21 12:05:00 | AAPL | Stock | 1.1445 | 1.1473 | 1.1429 | 1.1451 | 918400.0 |
| 2000-03-21 12:10:00 | AAPL | Stock | 1.1451 | 1.1451 | 1.144 | 1.1451 | 896000.0 |
| 2000-03-21 12:15:00 | AAPL | Stock | 1.1448 | 1.1451 | 1.1429 | 1.144 | 1467200.0 |
| 2000-03-21 12:20:00 | AAPL | Stock | 1.1445 | 1.1456 | 1.144 | 1.144 | 929600.0 |
| 2000-03-21 12:25:00 | AAPL | Stock | 1.1451 | 1.1456 | 1.144 | 1.1445 | 1668800.0 |
| 2000-03-21 12:30:00 | AAPL | Stock | 1.1445 | 1.1456 | 1.144 | 1.144 | 5107200.0 |
| 2000-03-21 12:35:00 | AAPL | Stock | 1.144 | 1.1451 | 1.144 | 1.1451 | 2105600.0 |
| 2000-03-21 12:40:00 | AAPL | Stock | 1.1445 | 1.1451 | 1.1434 | 1.1445 | 683200.0 |
| 2000-03-21 12:45:00 | AAPL | Stock | 1.1445 | 1.1496 | 1.1445 | 1.1468 | 4648000.0 |
| 2000-03-21 12:50:00 | AAPL | Stock | 1.1468 | 1.1507 | 1.1468 | 1.1507 | 1254400.0 |
| 2000-03-21 12:55:00 | AAPL | Stock | 1.1507 | 1.1507 | 1.1429 | 1.1473 | 2968000.0 |
| 2000-03-21 13:00:00 | AAPL | Stock | 1.1462 | 1.1473 | 1.1429 | 1.1462 | 907200.0 |
| 2000-03-21 13:05:00 | AAPL | Stock | 1.1462 | 1.1496 | 1.1462 | 1.149 | 2430400.0 |
| 2000-03-21 13:10:00 | AAPL | Stock | 1.1473 | 1.1501 | 1.1473 | 1.1496 | 2923200.0 |
| 2000-03-21 13:15:00 | AAPL | Stock | 1.1462 | 1.1496 | 1.1462 | 1.1484 | 772800.0 |
| 2000-03-21 13:20:00 | AAPL | Stock | 1.1484 | 1.1496 | 1.1473 | 1.1479 | 884800.0 |
| 2000-03-21 13:25:00 | AAPL | Stock | 1.149 | 1.149 | 1.1473 | 1.1473 | 436800.0 |
| 2000-03-21 13:30:00 | AAPL | Stock | 1.1484 | 1.149 | 1.1473 | 1.149 | 1724800.0 |
| 2000-03-21 13:35:00 | AAPL | Stock | 1.1484 | 1.154 | 1.1484 | 1.1529 | 4636800.0 |
> showing 50 of 87,899 rows — these rows as CSV