PREVIEW / stock_5min / 2006-06-07
file: by_date/stock_5min/2006/2006-06-07.parquet size: 3.1 MB rows: 228,431 symbols: 2,280
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-07 07:45:00 | AAPL | Stock | 2.1375 | 2.1375 | 2.1375 | 2.1375 | 2800.0 |
| 2006-06-07 08:00:00 | AAPL | Stock | 2.1393 | 2.1429 | 2.1393 | 2.1421 | 64232.0 |
| 2006-06-07 08:05:00 | AAPL | Stock | 2.1439 | 2.1468 | 2.1429 | 2.1443 | 217952.0 |
| 2006-06-07 08:10:00 | AAPL | Stock | 2.1443 | 2.1543 | 2.1443 | 2.1543 | 30800.0 |
| 2006-06-07 08:15:00 | AAPL | Stock | 2.1496 | 2.15 | 2.1464 | 2.1464 | 152964.0 |
| 2006-06-07 08:20:00 | AAPL | Stock | 2.1479 | 2.15 | 2.1479 | 2.15 | 70000.0 |
| 2006-06-07 08:25:00 | AAPL | Stock | 2.15 | 2.1507 | 2.15 | 2.15 | 67200.0 |
| 2006-06-07 08:30:00 | AAPL | Stock | 2.1482 | 2.1482 | 2.1454 | 2.1457 | 69384.0 |
| 2006-06-07 08:35:00 | AAPL | Stock | 2.1461 | 2.1461 | 2.1461 | 2.1461 | 30800.0 |
| 2006-06-07 08:40:00 | AAPL | Stock | 2.1446 | 2.1446 | 2.1446 | 2.1446 | 5600.0 |
| 2006-06-07 08:45:00 | AAPL | Stock | 2.1471 | 2.1479 | 2.1464 | 2.1464 | 140672.0 |
| 2006-06-07 08:50:00 | AAPL | Stock | 2.1468 | 2.15 | 2.1464 | 2.1475 | 383992.0 |
| 2006-06-07 08:55:00 | AAPL | Stock | 2.1475 | 2.1479 | 2.1464 | 2.1471 | 67200.0 |
| 2006-06-07 09:05:00 | AAPL | Stock | 2.1464 | 2.1471 | 2.1461 | 2.1471 | 53088.0 |
| 2006-06-07 09:10:00 | AAPL | Stock | 2.1464 | 2.1471 | 2.1464 | 2.1471 | 53200.0 |
| 2006-06-07 09:15:00 | AAPL | Stock | 2.1479 | 2.1496 | 2.1479 | 2.1489 | 53312.0 |
| 2006-06-07 09:20:00 | AAPL | Stock | 2.1471 | 2.1493 | 2.1471 | 2.1489 | 123200.0 |
| 2006-06-07 09:25:00 | AAPL | Stock | 2.1439 | 2.1486 | 2.1439 | 2.1479 | 162400.0 |
| 2006-06-07 09:30:00 | AAPL | Stock | 2.1464 | 2.15 | 2.1371 | 2.1443 | 15502676.0 |
| 2006-06-07 09:35:00 | AAPL | Stock | 2.1443 | 2.145 | 2.1286 | 2.1339 | 11805416.0 |
| 2006-06-07 09:40:00 | AAPL | Stock | 2.135 | 2.1368 | 2.1314 | 2.1314 | 8919176.0 |
| 2006-06-07 09:45:00 | AAPL | Stock | 2.1314 | 2.1321 | 2.1207 | 2.1246 | 13278188.0 |
| 2006-06-07 09:50:00 | AAPL | Stock | 2.1246 | 2.1304 | 2.1207 | 2.1279 | 9689148.0 |
| 2006-06-07 09:55:00 | AAPL | Stock | 2.1279 | 2.1318 | 2.1225 | 2.1289 | 8947428.0 |
| 2006-06-07 10:00:00 | AAPL | Stock | 2.1289 | 2.1475 | 2.1282 | 2.1443 | 26180392.0 |
| 2006-06-07 10:05:00 | AAPL | Stock | 2.1442 | 2.155 | 2.1411 | 2.15 | 19464116.0 |
| 2006-06-07 10:10:00 | AAPL | Stock | 2.1496 | 2.1539 | 2.1475 | 2.1507 | 12978756.0 |
| 2006-06-07 10:15:00 | AAPL | Stock | 2.15 | 2.1571 | 2.1482 | 2.1557 | 16151828.0 |
| 2006-06-07 10:20:00 | AAPL | Stock | 2.155 | 2.1557 | 2.1475 | 2.1504 | 13620656.0 |
| 2006-06-07 10:25:00 | AAPL | Stock | 2.1507 | 2.1532 | 2.1468 | 2.1479 | 7640556.0 |
| 2006-06-07 10:30:00 | AAPL | Stock | 2.1471 | 2.1504 | 2.1404 | 2.1411 | 13770624.0 |
| 2006-06-07 10:35:00 | AAPL | Stock | 2.1411 | 2.1411 | 2.1311 | 2.1336 | 12286904.0 |
| 2006-06-07 10:40:00 | AAPL | Stock | 2.1332 | 2.1382 | 2.1325 | 2.1343 | 7006048.0 |
| 2006-06-07 10:45:00 | AAPL | Stock | 2.1346 | 2.1346 | 2.1254 | 2.1296 | 11622436.0 |
| 2006-06-07 10:50:00 | AAPL | Stock | 2.1296 | 2.1314 | 2.125 | 2.1271 | 10462704.0 |
| 2006-06-07 10:55:00 | AAPL | Stock | 2.1275 | 2.1357 | 2.1268 | 2.1343 | 10980480.0 |
| 2006-06-07 11:00:00 | AAPL | Stock | 2.1343 | 2.1425 | 2.1329 | 2.1411 | 11558680.0 |
| 2006-06-07 11:05:00 | AAPL | Stock | 2.1407 | 2.1454 | 2.1389 | 2.1414 | 11991896.0 |
| 2006-06-07 11:10:00 | AAPL | Stock | 2.1414 | 2.1493 | 2.1411 | 2.1479 | 7305928.0 |
| 2006-06-07 11:15:00 | AAPL | Stock | 2.1479 | 2.1496 | 2.1425 | 2.1446 | 6153952.0 |
| 2006-06-07 11:20:00 | AAPL | Stock | 2.1446 | 2.1468 | 2.14 | 2.1421 | 7104104.0 |
| 2006-06-07 11:25:00 | AAPL | Stock | 2.1418 | 2.1421 | 2.1343 | 2.1357 | 5968312.0 |
| 2006-06-07 11:30:00 | AAPL | Stock | 2.1354 | 2.1389 | 2.135 | 2.1371 | 5494244.0 |
| 2006-06-07 11:35:00 | AAPL | Stock | 2.1368 | 2.1446 | 2.1357 | 2.1428 | 7395472.0 |
| 2006-06-07 11:40:00 | AAPL | Stock | 2.1425 | 2.1446 | 2.1411 | 2.1443 | 5604620.0 |
| 2006-06-07 11:45:00 | AAPL | Stock | 2.1443 | 2.1443 | 2.1404 | 2.1418 | 5152392.0 |
| 2006-06-07 11:50:00 | AAPL | Stock | 2.1421 | 2.1432 | 2.1407 | 2.1429 | 2250136.0 |
| 2006-06-07 11:55:00 | AAPL | Stock | 2.1432 | 2.1486 | 2.1425 | 2.1475 | 9287852.0 |
| 2006-06-07 12:00:00 | AAPL | Stock | 2.1479 | 2.15 | 2.1446 | 2.1486 | 6835976.0 |
| 2006-06-07 12:05:00 | AAPL | Stock | 2.1486 | 2.1518 | 2.1464 | 2.1475 | 5672996.0 |
> showing 50 of 228,431 rows — these rows as CSV