PREVIEW / stock_5min / 2000-04-05
file: by_date/stock_5min/2000/2000-04-05.parquet size: 1.2 MB rows: 90,140 symbols: 1,146
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-05 09:30:00 | AAPL | Stock | 1.1292 | 1.1295 | 1.1116 | 1.1177 | 6070400.0 |
| 2000-04-05 09:35:00 | AAPL | Stock | 1.1133 | 1.1529 | 1.1133 | 1.1518 | 6921600.0 |
| 2000-04-05 09:40:00 | AAPL | Stock | 1.1484 | 1.1607 | 1.144 | 1.156 | 6316800.0 |
| 2000-04-05 09:45:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1523 | 1.1535 | 6630400.0 |
| 2000-04-05 09:50:00 | AAPL | Stock | 1.154 | 1.1602 | 1.1373 | 1.1384 | 7739200.0 |
| 2000-04-05 09:55:00 | AAPL | Stock | 1.1468 | 1.1529 | 1.1373 | 1.1529 | 14033600.0 |
| 2000-04-05 10:00:00 | AAPL | Stock | 1.144 | 1.1607 | 1.1362 | 1.1434 | 7772800.0 |
| 2000-04-05 10:05:00 | AAPL | Stock | 1.144 | 1.1456 | 1.1272 | 1.1406 | 5723200.0 |
| 2000-04-05 10:10:00 | AAPL | Stock | 1.1406 | 1.1445 | 1.1239 | 1.1317 | 9475200.0 |
| 2000-04-05 10:15:00 | AAPL | Stock | 1.1317 | 1.1339 | 1.1261 | 1.1272 | 7470400.0 |
| 2000-04-05 10:20:00 | AAPL | Stock | 1.1283 | 1.1339 | 1.1267 | 1.1317 | 6406400.0 |
| 2000-04-05 10:25:00 | AAPL | Stock | 1.1317 | 1.1362 | 1.13 | 1.1362 | 9878400.0 |
| 2000-04-05 10:30:00 | AAPL | Stock | 1.1362 | 1.1507 | 1.1356 | 1.1507 | 6832000.0 |
| 2000-04-05 10:35:00 | AAPL | Stock | 1.1518 | 1.1551 | 1.1429 | 1.1549 | 8332800.0 |
| 2000-04-05 10:40:00 | AAPL | Stock | 1.1546 | 1.1551 | 1.144 | 1.1496 | 4390400.0 |
| 2000-04-05 10:45:00 | AAPL | Stock | 1.1473 | 1.1518 | 1.1473 | 1.1496 | 5342400.0 |
| 2000-04-05 10:50:00 | AAPL | Stock | 1.149 | 1.1496 | 1.1406 | 1.1468 | 5196800.0 |
| 2000-04-05 10:55:00 | AAPL | Stock | 1.1465 | 1.1484 | 1.1362 | 1.1373 | 3953600.0 |
| 2000-04-05 11:00:00 | AAPL | Stock | 1.1367 | 1.1451 | 1.1367 | 1.144 | 4569600.0 |
| 2000-04-05 11:05:00 | AAPL | Stock | 1.1417 | 1.1431 | 1.1339 | 1.1373 | 3684800.0 |
| 2000-04-05 11:10:00 | AAPL | Stock | 1.1356 | 1.1406 | 1.1283 | 1.1328 | 8534400.0 |
| 2000-04-05 11:15:00 | AAPL | Stock | 1.1328 | 1.1337 | 1.1189 | 1.1323 | 3987200.0 |
| 2000-04-05 11:20:00 | AAPL | Stock | 1.1317 | 1.144 | 1.1311 | 1.1423 | 5868800.0 |
| 2000-04-05 11:25:00 | AAPL | Stock | 1.1429 | 1.144 | 1.1384 | 1.139 | 3449600.0 |
| 2000-04-05 11:30:00 | AAPL | Stock | 1.1373 | 1.144 | 1.1362 | 1.1423 | 3382400.0 |
| 2000-04-05 11:35:00 | AAPL | Stock | 1.1423 | 1.1429 | 1.1384 | 1.1412 | 2027200.0 |
| 2000-04-05 11:40:00 | AAPL | Stock | 1.1401 | 1.1423 | 1.1378 | 1.139 | 1355200.0 |
| 2000-04-05 11:45:00 | AAPL | Stock | 1.1384 | 1.1395 | 1.1328 | 1.1367 | 2788800.0 |
| 2000-04-05 11:50:00 | AAPL | Stock | 1.1401 | 1.1429 | 1.1356 | 1.1356 | 2004800.0 |
| 2000-04-05 11:55:00 | AAPL | Stock | 1.135 | 1.1356 | 1.1295 | 1.1309 | 3595200.0 |
| 2000-04-05 12:00:00 | AAPL | Stock | 1.1295 | 1.1317 | 1.1071 | 1.12 | 12644800.0 |
| 2000-04-05 12:05:00 | AAPL | Stock | 1.1166 | 1.1211 | 1.111 | 1.1166 | 7907200.0 |
| 2000-04-05 12:10:00 | AAPL | Stock | 1.1164 | 1.1306 | 1.1161 | 1.1211 | 13720000.0 |
| 2000-04-05 12:15:00 | AAPL | Stock | 1.1208 | 1.1317 | 1.1189 | 1.1228 | 9060800.0 |
| 2000-04-05 12:20:00 | AAPL | Stock | 1.1295 | 1.1373 | 1.1272 | 1.1356 | 2508800.0 |
| 2000-04-05 12:25:00 | AAPL | Stock | 1.1345 | 1.1423 | 1.1311 | 1.1423 | 1388800.0 |
| 2000-04-05 12:30:00 | AAPL | Stock | 1.1417 | 1.1429 | 1.139 | 1.1426 | 1523200.0 |
| 2000-04-05 12:35:00 | AAPL | Stock | 1.1426 | 1.1473 | 1.1378 | 1.1429 | 3875200.0 |
| 2000-04-05 12:40:00 | AAPL | Stock | 1.1406 | 1.1451 | 1.1406 | 1.1445 | 2777600.0 |
| 2000-04-05 12:45:00 | AAPL | Stock | 1.144 | 1.1465 | 1.1423 | 1.1445 | 4636800.0 |
| 2000-04-05 12:50:00 | AAPL | Stock | 1.1445 | 1.1451 | 1.1339 | 1.1362 | 1523200.0 |
| 2000-04-05 12:55:00 | AAPL | Stock | 1.1362 | 1.1429 | 1.1339 | 1.1423 | 2542400.0 |
| 2000-04-05 13:00:00 | AAPL | Stock | 1.1423 | 1.144 | 1.1395 | 1.1429 | 3617600.0 |
| 2000-04-05 13:05:00 | AAPL | Stock | 1.1429 | 1.1484 | 1.1406 | 1.1473 | 11760000.0 |
| 2000-04-05 13:10:00 | AAPL | Stock | 1.1476 | 1.1479 | 1.1339 | 1.1451 | 3662400.0 |
| 2000-04-05 13:15:00 | AAPL | Stock | 1.1456 | 1.154 | 1.1456 | 1.154 | 6854400.0 |
| 2000-04-05 13:20:00 | AAPL | Stock | 1.1551 | 1.1557 | 1.1484 | 1.1484 | 9038400.0 |
| 2000-04-05 13:25:00 | AAPL | Stock | 1.1484 | 1.1518 | 1.1468 | 1.1496 | 2923200.0 |
| 2000-04-05 13:30:00 | AAPL | Stock | 1.1496 | 1.1496 | 1.1429 | 1.1451 | 3281600.0 |
| 2000-04-05 13:35:00 | AAPL | Stock | 1.1434 | 1.1484 | 1.1434 | 1.144 | 1870400.0 |
> showing 50 of 90,140 rows — these rows as CSV