PREVIEW / stock_5min / 2000-04-19
file: by_date/stock_5min/2000/2000-04-19.parquet size: 1.1 MB rows: 86,361 symbols: 1,167
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-04-19 09:30:00 | AAPL | Stock | 1.1267 | 1.1272 | 1.115 | 1.1155 | 8075200.0 |
| 2000-04-19 09:35:00 | AAPL | Stock | 1.1155 | 1.12 | 1.1138 | 1.1194 | 8041600.0 |
| 2000-04-19 09:40:00 | AAPL | Stock | 1.1194 | 1.1311 | 1.1138 | 1.1303 | 7011200.0 |
| 2000-04-19 09:45:00 | AAPL | Stock | 1.1306 | 1.1468 | 1.1295 | 1.1451 | 10080000.0 |
| 2000-04-19 09:50:00 | AAPL | Stock | 1.1456 | 1.1507 | 1.1317 | 1.1317 | 6148800.0 |
| 2000-04-19 09:55:00 | AAPL | Stock | 1.1328 | 1.1429 | 1.1317 | 1.1406 | 5420800.0 |
| 2000-04-19 10:00:00 | AAPL | Stock | 1.1415 | 1.1429 | 1.125 | 1.1295 | 8624000.0 |
| 2000-04-19 10:05:00 | AAPL | Stock | 1.1323 | 1.1328 | 1.125 | 1.1295 | 4625600.0 |
| 2000-04-19 10:10:00 | AAPL | Stock | 1.1295 | 1.1378 | 1.125 | 1.1367 | 8881600.0 |
| 2000-04-19 10:15:00 | AAPL | Stock | 1.1345 | 1.1429 | 1.1334 | 1.1417 | 6395200.0 |
| 2000-04-19 10:20:00 | AAPL | Stock | 1.1417 | 1.1451 | 1.1339 | 1.1395 | 7784000.0 |
| 2000-04-19 10:25:00 | AAPL | Stock | 1.1392 | 1.1445 | 1.1362 | 1.1406 | 4692800.0 |
| 2000-04-19 10:30:00 | AAPL | Stock | 1.1412 | 1.1448 | 1.1362 | 1.1429 | 3169600.0 |
| 2000-04-19 10:35:00 | AAPL | Stock | 1.1429 | 1.1429 | 1.135 | 1.1409 | 2811200.0 |
| 2000-04-19 10:40:00 | AAPL | Stock | 1.1395 | 1.144 | 1.1362 | 1.1417 | 2587200.0 |
| 2000-04-19 10:45:00 | AAPL | Stock | 1.1395 | 1.144 | 1.1395 | 1.1437 | 2105600.0 |
| 2000-04-19 10:50:00 | AAPL | Stock | 1.1445 | 1.1563 | 1.1412 | 1.1484 | 9105600.0 |
| 2000-04-19 10:55:00 | AAPL | Stock | 1.1462 | 1.154 | 1.144 | 1.1518 | 3864000.0 |
| 2000-04-19 11:00:00 | AAPL | Stock | 1.1501 | 1.154 | 1.1429 | 1.1496 | 4177600.0 |
| 2000-04-19 11:05:00 | AAPL | Stock | 1.1462 | 1.149 | 1.135 | 1.1468 | 3416000.0 |
| 2000-04-19 11:10:00 | AAPL | Stock | 1.1468 | 1.1496 | 1.1401 | 1.1401 | 2251200.0 |
| 2000-04-19 11:15:00 | AAPL | Stock | 1.1395 | 1.1456 | 1.1384 | 1.1395 | 2139200.0 |
| 2000-04-19 11:20:00 | AAPL | Stock | 1.1395 | 1.1429 | 1.139 | 1.1412 | 2408000.0 |
| 2000-04-19 11:25:00 | AAPL | Stock | 1.1417 | 1.1417 | 1.139 | 1.1401 | 4412800.0 |
| 2000-04-19 11:30:00 | AAPL | Stock | 1.1401 | 1.1445 | 1.1395 | 1.1429 | 4267200.0 |
| 2000-04-19 11:35:00 | AAPL | Stock | 1.1445 | 1.1484 | 1.1429 | 1.1484 | 2284800.0 |
| 2000-04-19 11:40:00 | AAPL | Stock | 1.1479 | 1.1518 | 1.1462 | 1.1518 | 6070400.0 |
| 2000-04-19 11:45:00 | AAPL | Stock | 1.1518 | 1.1557 | 1.1484 | 1.154 | 7761600.0 |
| 2000-04-19 11:50:00 | AAPL | Stock | 1.1535 | 1.159 | 1.1535 | 1.159 | 5252800.0 |
| 2000-04-19 11:55:00 | AAPL | Stock | 1.1585 | 1.1629 | 1.1518 | 1.1557 | 14660800.0 |
| 2000-04-19 12:00:00 | AAPL | Stock | 1.1546 | 1.1585 | 1.1529 | 1.1557 | 1881600.0 |
| 2000-04-19 12:05:00 | AAPL | Stock | 1.1563 | 1.1563 | 1.1479 | 1.1507 | 4379200.0 |
| 2000-04-19 12:10:00 | AAPL | Stock | 1.1484 | 1.1512 | 1.1451 | 1.1451 | 2116800.0 |
| 2000-04-19 12:15:00 | AAPL | Stock | 1.1451 | 1.1496 | 1.144 | 1.149 | 1736000.0 |
| 2000-04-19 12:20:00 | AAPL | Stock | 1.1459 | 1.1535 | 1.1429 | 1.1456 | 1456000.0 |
| 2000-04-19 12:25:00 | AAPL | Stock | 1.1451 | 1.1473 | 1.144 | 1.1462 | 1344000.0 |
| 2000-04-19 12:30:00 | AAPL | Stock | 1.1462 | 1.1468 | 1.1456 | 1.1468 | 1064000.0 |
| 2000-04-19 12:35:00 | AAPL | Stock | 1.1465 | 1.1501 | 1.1462 | 1.1496 | 1814400.0 |
| 2000-04-19 12:40:00 | AAPL | Stock | 1.149 | 1.1507 | 1.1462 | 1.1462 | 1086400.0 |
| 2000-04-19 12:45:00 | AAPL | Stock | 1.1462 | 1.1479 | 1.1456 | 1.1468 | 436800.0 |
| 2000-04-19 12:50:00 | AAPL | Stock | 1.1473 | 1.1479 | 1.1429 | 1.1429 | 2172800.0 |
| 2000-04-19 12:55:00 | AAPL | Stock | 1.1429 | 1.1434 | 1.1373 | 1.1384 | 7649600.0 |
| 2000-04-19 13:00:00 | AAPL | Stock | 1.139 | 1.1406 | 1.1339 | 1.1378 | 2710400.0 |
| 2000-04-19 13:05:00 | AAPL | Stock | 1.1373 | 1.1462 | 1.1356 | 1.1462 | 4726400.0 |
| 2000-04-19 13:10:00 | AAPL | Stock | 1.1473 | 1.1473 | 1.1384 | 1.1384 | 1052800.0 |
| 2000-04-19 13:15:00 | AAPL | Stock | 1.1384 | 1.1406 | 1.1362 | 1.1367 | 1321600.0 |
| 2000-04-19 13:20:00 | AAPL | Stock | 1.1384 | 1.1401 | 1.1356 | 1.1362 | 2710400.0 |
| 2000-04-19 13:25:00 | AAPL | Stock | 1.1373 | 1.1406 | 1.1356 | 1.1406 | 1444800.0 |
| 2000-04-19 13:30:00 | AAPL | Stock | 1.1406 | 1.1445 | 1.1378 | 1.1445 | 1411200.0 |
| 2000-04-19 13:35:00 | AAPL | Stock | 1.1451 | 1.1451 | 1.1373 | 1.1395 | 2060800.0 |
> showing 50 of 86,361 rows — these rows as CSV