PREVIEW / stock_5min / 2006-03-24
file: by_date/stock_5min/2006/2006-03-24.parquet size: 3.0 MB rows: 218,548 symbols: 2,196
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-03-24 04:30:00 | AAPL | Stock | 2.15 | 2.15 | 2.15 | 2.15 | 2800.0 |
| 2006-03-24 06:30:00 | AAPL | Stock | 2.1536 | 2.1536 | 2.1536 | 2.1536 | 2800.0 |
| 2006-03-24 06:35:00 | AAPL | Stock | 2.1536 | 2.1536 | 2.1536 | 2.1536 | 2800.0 |
| 2006-03-24 06:55:00 | AAPL | Stock | 2.1536 | 2.1536 | 2.1536 | 2.1536 | 2800.0 |
| 2006-03-24 07:15:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 2800.0 |
| 2006-03-24 07:45:00 | AAPL | Stock | 2.1518 | 2.1536 | 2.1518 | 2.1536 | 64400.0 |
| 2006-03-24 07:50:00 | AAPL | Stock | 2.1536 | 2.1536 | 2.1536 | 2.1536 | 99680.0 |
| 2006-03-24 07:55:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1571 | 2.1571 | 5600.0 |
| 2006-03-24 08:00:00 | AAPL | Stock | 2.1589 | 2.1643 | 2.1554 | 2.16 | 675584.0 |
| 2006-03-24 08:05:00 | AAPL | Stock | 2.1589 | 2.1607 | 2.1554 | 2.1554 | 638708.0 |
| 2006-03-24 08:10:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1546 | 2.1571 | 84924.0 |
| 2006-03-24 08:15:00 | AAPL | Stock | 2.1575 | 2.1586 | 2.1571 | 2.1579 | 202160.0 |
| 2006-03-24 08:20:00 | AAPL | Stock | 2.1571 | 2.1582 | 2.1561 | 2.1561 | 45192.0 |
| 2006-03-24 08:25:00 | AAPL | Stock | 2.1579 | 2.1586 | 2.1543 | 2.1571 | 149800.0 |
| 2006-03-24 08:30:00 | AAPL | Stock | 2.1554 | 2.1568 | 2.1514 | 2.1568 | 385000.0 |
| 2006-03-24 08:35:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1539 | 2.1554 | 69020.0 |
| 2006-03-24 08:40:00 | AAPL | Stock | 2.1543 | 2.1554 | 2.1521 | 2.1546 | 64400.0 |
| 2006-03-24 08:45:00 | AAPL | Stock | 2.155 | 2.1557 | 2.1536 | 2.1539 | 180040.0 |
| 2006-03-24 08:50:00 | AAPL | Stock | 2.1554 | 2.1568 | 2.1525 | 2.1525 | 183120.0 |
| 2006-03-24 08:55:00 | AAPL | Stock | 2.1525 | 2.1536 | 2.1518 | 2.1536 | 124516.0 |
| 2006-03-24 09:00:00 | AAPL | Stock | 2.1518 | 2.1536 | 2.1511 | 2.1518 | 332304.0 |
| 2006-03-24 09:05:00 | AAPL | Stock | 2.1518 | 2.1518 | 2.1482 | 2.1486 | 567588.0 |
| 2006-03-24 09:10:00 | AAPL | Stock | 2.1486 | 2.1486 | 2.1464 | 2.1475 | 412888.0 |
| 2006-03-24 09:15:00 | AAPL | Stock | 2.1475 | 2.1496 | 2.1439 | 2.1493 | 537460.0 |
| 2006-03-24 09:20:00 | AAPL | Stock | 2.1486 | 2.1521 | 2.1485 | 2.1493 | 2063600.0 |
| 2006-03-24 09:25:00 | AAPL | Stock | 2.1514 | 2.1536 | 2.1493 | 2.1532 | 1094016.0 |
| 2006-03-24 09:30:00 | AAPL | Stock | 2.1518 | 2.1546 | 2.1432 | 2.1436 | 27624100.0 |
| 2006-03-24 09:35:00 | AAPL | Stock | 2.1439 | 2.1482 | 2.1396 | 2.1436 | 26345648.0 |
| 2006-03-24 09:40:00 | AAPL | Stock | 2.1436 | 2.1482 | 2.1346 | 2.1354 | 20691944.0 |
| 2006-03-24 09:45:00 | AAPL | Stock | 2.1354 | 2.1418 | 2.1343 | 2.135 | 18398632.0 |
| 2006-03-24 09:50:00 | AAPL | Stock | 2.1354 | 2.1446 | 2.135 | 2.1404 | 16478532.0 |
| 2006-03-24 09:55:00 | AAPL | Stock | 2.1404 | 2.1607 | 2.14 | 2.1536 | 34661788.0 |
| 2006-03-24 10:00:00 | AAPL | Stock | 2.1536 | 2.1586 | 2.15 | 2.1564 | 22034348.0 |
| 2006-03-24 10:05:00 | AAPL | Stock | 2.1564 | 2.1743 | 2.1554 | 2.1675 | 40340776.0 |
| 2006-03-24 10:10:00 | AAPL | Stock | 2.1668 | 2.1764 | 2.1654 | 2.1689 | 31141404.0 |
| 2006-03-24 10:15:00 | AAPL | Stock | 2.1682 | 2.1693 | 2.1614 | 2.1646 | 18414956.0 |
| 2006-03-24 10:20:00 | AAPL | Stock | 2.1643 | 2.1689 | 2.1625 | 2.1654 | 10178392.0 |
| 2006-03-24 10:25:00 | AAPL | Stock | 2.165 | 2.1754 | 2.1646 | 2.1732 | 15420440.0 |
| 2006-03-24 10:30:00 | AAPL | Stock | 2.1732 | 2.175 | 2.1689 | 2.1711 | 13913396.0 |
| 2006-03-24 10:35:00 | AAPL | Stock | 2.1718 | 2.1718 | 2.1621 | 2.1668 | 20291964.0 |
| 2006-03-24 10:40:00 | AAPL | Stock | 2.1668 | 2.1675 | 2.1604 | 2.1625 | 15400056.0 |
| 2006-03-24 10:45:00 | AAPL | Stock | 2.1632 | 2.1636 | 2.1539 | 2.1554 | 16208276.0 |
| 2006-03-24 10:50:00 | AAPL | Stock | 2.1554 | 2.1589 | 2.155 | 2.1566 | 7628404.0 |
| 2006-03-24 10:55:00 | AAPL | Stock | 2.1571 | 2.1579 | 2.1479 | 2.1554 | 17277008.0 |
| 2006-03-24 11:00:00 | AAPL | Stock | 2.1561 | 2.1586 | 2.1514 | 2.1582 | 9513952.0 |
| 2006-03-24 11:05:00 | AAPL | Stock | 2.1582 | 2.16 | 2.1554 | 2.1571 | 8518748.0 |
| 2006-03-24 11:10:00 | AAPL | Stock | 2.1571 | 2.1575 | 2.1443 | 2.1464 | 15911168.0 |
| 2006-03-24 11:15:00 | AAPL | Stock | 2.1464 | 2.1482 | 2.1446 | 2.1457 | 11642428.0 |
| 2006-03-24 11:20:00 | AAPL | Stock | 2.1457 | 2.1486 | 2.1411 | 2.1482 | 16890020.0 |
| 2006-03-24 11:25:00 | AAPL | Stock | 2.1482 | 2.1486 | 2.1432 | 2.1461 | 9154404.0 |
> showing 50 of 218,548 rows — these rows as CSV