PREVIEW / stock_5min / 2000-03-06
file: by_date/stock_5min/2000/2000-03-06.parquet size: 1.2 MB rows: 90,536 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-03-06 09:30:00 | AAPL | Stock | 1.125 | 1.125 | 1.1183 | 1.1228 | 4435200.0 |
| 2000-03-06 09:35:00 | AAPL | Stock | 1.1183 | 1.1228 | 1.1177 | 1.1203 | 3796800.0 |
| 2000-03-06 09:40:00 | AAPL | Stock | 1.12 | 1.1306 | 1.1183 | 1.1295 | 10460800.0 |
| 2000-03-06 09:45:00 | AAPL | Stock | 1.1317 | 1.1429 | 1.125 | 1.1378 | 6988800.0 |
| 2000-03-06 09:50:00 | AAPL | Stock | 1.1378 | 1.1384 | 1.1339 | 1.1339 | 6025600.0 |
| 2000-03-06 09:55:00 | AAPL | Stock | 1.1384 | 1.1451 | 1.135 | 1.1429 | 4872000.0 |
| 2000-03-06 10:00:00 | AAPL | Stock | 1.1417 | 1.1429 | 1.1401 | 1.1401 | 2531200.0 |
| 2000-03-06 10:05:00 | AAPL | Stock | 1.1401 | 1.1406 | 1.1306 | 1.1317 | 3774400.0 |
| 2000-03-06 10:10:00 | AAPL | Stock | 1.1325 | 1.1395 | 1.1325 | 1.1367 | 1769600.0 |
| 2000-03-06 10:15:00 | AAPL | Stock | 1.1345 | 1.1395 | 1.1342 | 1.1392 | 2184000.0 |
| 2000-03-06 10:20:00 | AAPL | Stock | 1.1392 | 1.1395 | 1.1244 | 1.1244 | 3136000.0 |
| 2000-03-06 10:25:00 | AAPL | Stock | 1.1261 | 1.1295 | 1.1161 | 1.1166 | 12958400.0 |
| 2000-03-06 10:30:00 | AAPL | Stock | 1.1183 | 1.125 | 1.1183 | 1.125 | 2161600.0 |
| 2000-03-06 10:35:00 | AAPL | Stock | 1.1256 | 1.1367 | 1.1233 | 1.1362 | 4065600.0 |
| 2000-03-06 10:40:00 | AAPL | Stock | 1.1362 | 1.1384 | 1.1339 | 1.1373 | 1724800.0 |
| 2000-03-06 10:45:00 | AAPL | Stock | 1.1376 | 1.1406 | 1.1362 | 1.1373 | 2296000.0 |
| 2000-03-06 10:50:00 | AAPL | Stock | 1.1367 | 1.1445 | 1.1367 | 1.1445 | 4592000.0 |
| 2000-03-06 10:55:00 | AAPL | Stock | 1.1445 | 1.1496 | 1.1434 | 1.1473 | 6104000.0 |
| 2000-03-06 11:00:00 | AAPL | Stock | 1.1473 | 1.1529 | 1.1473 | 1.1518 | 3808000.0 |
| 2000-03-06 11:05:00 | AAPL | Stock | 1.1529 | 1.1529 | 1.1417 | 1.1417 | 1792000.0 |
| 2000-03-06 11:10:00 | AAPL | Stock | 1.1423 | 1.1507 | 1.1417 | 1.1473 | 3225600.0 |
| 2000-03-06 11:15:00 | AAPL | Stock | 1.1451 | 1.1515 | 1.1451 | 1.1473 | 1265600.0 |
| 2000-03-06 11:20:00 | AAPL | Stock | 1.1451 | 1.1507 | 1.1451 | 1.1484 | 1713600.0 |
| 2000-03-06 11:25:00 | AAPL | Stock | 1.1473 | 1.1496 | 1.1473 | 1.1479 | 2542400.0 |
| 2000-03-06 11:30:00 | AAPL | Stock | 1.1479 | 1.1479 | 1.1345 | 1.1362 | 2912000.0 |
| 2000-03-06 11:35:00 | AAPL | Stock | 1.1362 | 1.144 | 1.1356 | 1.139 | 3259200.0 |
| 2000-03-06 11:40:00 | AAPL | Stock | 1.1373 | 1.144 | 1.1362 | 1.144 | 4502400.0 |
| 2000-03-06 11:45:00 | AAPL | Stock | 1.144 | 1.144 | 1.1429 | 1.1429 | 1220800.0 |
| 2000-03-06 11:50:00 | AAPL | Stock | 1.1429 | 1.1434 | 1.1339 | 1.1339 | 784000.0 |
| 2000-03-06 11:55:00 | AAPL | Stock | 1.1339 | 1.1417 | 1.1339 | 1.1412 | 1086400.0 |
| 2000-03-06 12:00:00 | AAPL | Stock | 1.1417 | 1.144 | 1.1417 | 1.1417 | 772800.0 |
| 2000-03-06 12:05:00 | AAPL | Stock | 1.1417 | 1.1429 | 1.1395 | 1.1395 | 952000.0 |
| 2000-03-06 12:10:00 | AAPL | Stock | 1.1401 | 1.144 | 1.1395 | 1.1429 | 1534400.0 |
| 2000-03-06 12:15:00 | AAPL | Stock | 1.144 | 1.1451 | 1.1429 | 1.1445 | 1691200.0 |
| 2000-03-06 12:20:00 | AAPL | Stock | 1.1445 | 1.1451 | 1.1412 | 1.1417 | 1926400.0 |
| 2000-03-06 12:25:00 | AAPL | Stock | 1.1417 | 1.1445 | 1.1378 | 1.1378 | 1064000.0 |
| 2000-03-06 12:30:00 | AAPL | Stock | 1.1406 | 1.1406 | 1.1323 | 1.1339 | 2318400.0 |
| 2000-03-06 12:35:00 | AAPL | Stock | 1.1339 | 1.1362 | 1.1295 | 1.1295 | 3214400.0 |
| 2000-03-06 12:40:00 | AAPL | Stock | 1.1295 | 1.1306 | 1.125 | 1.1272 | 4323200.0 |
| 2000-03-06 12:45:00 | AAPL | Stock | 1.1267 | 1.1362 | 1.1267 | 1.1345 | 3550400.0 |
| 2000-03-06 12:50:00 | AAPL | Stock | 1.1353 | 1.1356 | 1.1323 | 1.1328 | 2072000.0 |
| 2000-03-06 12:55:00 | AAPL | Stock | 1.1339 | 1.1339 | 1.1323 | 1.1339 | 672000.0 |
| 2000-03-06 13:00:00 | AAPL | Stock | 1.1323 | 1.1356 | 1.1317 | 1.1331 | 425600.0 |
| 2000-03-06 13:05:00 | AAPL | Stock | 1.1339 | 1.1339 | 1.1317 | 1.1317 | 716800.0 |
| 2000-03-06 13:10:00 | AAPL | Stock | 1.1317 | 1.1328 | 1.1283 | 1.1289 | 840000.0 |
| 2000-03-06 13:15:00 | AAPL | Stock | 1.1283 | 1.1317 | 1.1267 | 1.1272 | 3236800.0 |
| 2000-03-06 13:20:00 | AAPL | Stock | 1.1267 | 1.1339 | 1.1267 | 1.1339 | 694400.0 |
| 2000-03-06 13:25:00 | AAPL | Stock | 1.1339 | 1.1384 | 1.1328 | 1.1384 | 728000.0 |
| 2000-03-06 13:30:00 | AAPL | Stock | 1.1384 | 1.1384 | 1.1323 | 1.1323 | 1120000.0 |
| 2000-03-06 13:35:00 | AAPL | Stock | 1.1323 | 1.1339 | 1.1295 | 1.1317 | 627200.0 |
> showing 50 of 90,536 rows — these rows as CSV