PREVIEW / stock_5min / 2007-12-28
file: by_date/stock_5min/2007/2007-12-28.parquet size: 4.4 MB rows: 329,451 symbols: 3,263
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-28 05:05:00 | AAPL | Stock | 7.14 | 7.14 | 7.14 | 7.14 | 2800.0 |
| 2007-12-28 07:10:00 | AAPL | Stock | 7.1607 | 7.1718 | 7.1607 | 7.1679 | 106400.0 |
| 2007-12-28 07:15:00 | AAPL | Stock | 7.1714 | 7.1779 | 7.1679 | 7.1779 | 147812.0 |
| 2007-12-28 07:20:00 | AAPL | Stock | 7.1775 | 7.1775 | 7.1607 | 7.1771 | 184800.0 |
| 2007-12-28 07:30:00 | AAPL | Stock | 7.1625 | 7.1679 | 7.1446 | 7.1607 | 151704.0 |
| 2007-12-28 07:35:00 | AAPL | Stock | 7.1604 | 7.1604 | 7.1589 | 7.1604 | 204008.0 |
| 2007-12-28 07:40:00 | AAPL | Stock | 7.1589 | 7.1589 | 7.1507 | 7.1589 | 22596.0 |
| 2007-12-28 07:45:00 | AAPL | Stock | 7.1696 | 7.1736 | 7.1679 | 7.1696 | 184800.0 |
| 2007-12-28 07:50:00 | AAPL | Stock | 7.1714 | 7.1714 | 7.1696 | 7.1696 | 42000.0 |
| 2007-12-28 07:55:00 | AAPL | Stock | 7.1714 | 7.175 | 7.1679 | 7.1707 | 29400.0 |
| 2007-12-28 08:00:00 | AAPL | Stock | 7.1679 | 7.1764 | 7.1536 | 7.1714 | 1705228.0 |
| 2007-12-28 08:05:00 | AAPL | Stock | 7.1768 | 7.1875 | 7.1704 | 7.1743 | 1151556.0 |
| 2007-12-28 08:10:00 | AAPL | Stock | 7.175 | 7.1768 | 7.1696 | 7.1696 | 505876.0 |
| 2007-12-28 08:15:00 | AAPL | Stock | 7.1689 | 7.1714 | 7.1643 | 7.1661 | 237608.0 |
| 2007-12-28 08:20:00 | AAPL | Stock | 7.1679 | 7.1768 | 7.1679 | 7.1711 | 114912.0 |
| 2007-12-28 08:25:00 | AAPL | Stock | 7.1746 | 7.1746 | 7.1668 | 7.1668 | 69104.0 |
| 2007-12-28 08:30:00 | AAPL | Stock | 7.1679 | 7.1679 | 7.1571 | 7.1571 | 327292.0 |
| 2007-12-28 08:35:00 | AAPL | Stock | 7.1571 | 7.1632 | 7.1536 | 7.1625 | 138516.0 |
| 2007-12-28 08:40:00 | AAPL | Stock | 7.1607 | 7.1611 | 7.1468 | 7.1504 | 346136.0 |
| 2007-12-28 08:45:00 | AAPL | Stock | 7.1504 | 7.1604 | 7.1496 | 7.1518 | 222292.0 |
| 2007-12-28 08:50:00 | AAPL | Stock | 7.1571 | 7.1593 | 7.1518 | 7.1532 | 130200.0 |
| 2007-12-28 08:55:00 | AAPL | Stock | 7.1536 | 7.1536 | 7.1429 | 7.15 | 588588.0 |
| 2007-12-28 09:00:00 | AAPL | Stock | 7.1546 | 7.1589 | 7.1518 | 7.1518 | 162680.0 |
| 2007-12-28 09:05:00 | AAPL | Stock | 7.15 | 7.1561 | 7.1443 | 7.1561 | 383796.0 |
| 2007-12-28 09:10:00 | AAPL | Stock | 7.1561 | 7.1607 | 7.1536 | 7.1571 | 424396.0 |
| 2007-12-28 09:15:00 | AAPL | Stock | 7.1604 | 7.1604 | 7.1564 | 7.1564 | 98588.0 |
| 2007-12-28 09:20:00 | AAPL | Stock | 7.1571 | 7.1643 | 7.1536 | 7.1543 | 567252.0 |
| 2007-12-28 09:25:00 | AAPL | Stock | 7.1564 | 7.1629 | 7.1454 | 7.1611 | 530180.0 |
| 2007-12-28 09:30:00 | AAPL | Stock | 7.1639 | 7.1979 | 7.1475 | 7.1786 | 30819992.0 |
| 2007-12-28 09:35:00 | AAPL | Stock | 7.1775 | 7.1821 | 7.15 | 7.1816 | 19125960.0 |
| 2007-12-28 09:40:00 | AAPL | Stock | 7.1811 | 7.1986 | 7.1714 | 7.18 | 12509336.0 |
| 2007-12-28 09:45:00 | AAPL | Stock | 7.1814 | 7.1925 | 7.1696 | 7.1779 | 15102696.0 |
| 2007-12-28 09:50:00 | AAPL | Stock | 7.1786 | 7.1818 | 7.1682 | 7.1721 | 6174560.0 |
| 2007-12-28 09:55:00 | AAPL | Stock | 7.1721 | 7.1754 | 7.1646 | 7.1739 | 7702968.0 |
| 2007-12-28 10:00:00 | AAPL | Stock | 7.1743 | 7.1743 | 7.1414 | 7.1462 | 19392156.0 |
| 2007-12-28 10:05:00 | AAPL | Stock | 7.1454 | 7.1632 | 7.1429 | 7.1604 | 16817388.0 |
| 2007-12-28 10:10:00 | AAPL | Stock | 7.16 | 7.1696 | 7.1543 | 7.166 | 7904876.0 |
| 2007-12-28 10:15:00 | AAPL | Stock | 7.1668 | 7.1825 | 7.1607 | 7.1821 | 8431108.0 |
| 2007-12-28 10:20:00 | AAPL | Stock | 7.1825 | 7.1825 | 7.1682 | 7.1714 | 6190380.0 |
| 2007-12-28 10:25:00 | AAPL | Stock | 7.1714 | 7.1786 | 7.1668 | 7.1754 | 5770268.0 |
| 2007-12-28 10:30:00 | AAPL | Stock | 7.1757 | 7.1764 | 7.1607 | 7.1611 | 8782256.0 |
| 2007-12-28 10:35:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1461 | 7.1571 | 9326548.0 |
| 2007-12-28 10:40:00 | AAPL | Stock | 7.1579 | 7.1654 | 7.15 | 7.1511 | 6739516.0 |
| 2007-12-28 10:45:00 | AAPL | Stock | 7.1496 | 7.1532 | 7.1414 | 7.1529 | 8956276.0 |
| 2007-12-28 10:50:00 | AAPL | Stock | 7.1521 | 7.1529 | 7.1304 | 7.1482 | 11001340.0 |
| 2007-12-28 10:55:00 | AAPL | Stock | 7.1479 | 7.1496 | 7.1268 | 7.1407 | 8716624.0 |
| 2007-12-28 11:00:00 | AAPL | Stock | 7.1418 | 7.1457 | 7.1296 | 7.1304 | 5880028.0 |
| 2007-12-28 11:05:00 | AAPL | Stock | 7.13 | 7.1325 | 7.1204 | 7.1307 | 9366224.0 |
| 2007-12-28 11:10:00 | AAPL | Stock | 7.1307 | 7.1404 | 7.1286 | 7.1404 | 5183444.0 |
| 2007-12-28 11:15:00 | AAPL | Stock | 7.1396 | 7.1536 | 7.1379 | 7.1492 | 9120524.0 |
> showing 50 of 329,451 rows — these rows as CSV