PREVIEW / stock_5min / 2005-11-04
file: by_date/stock_5min/2005/2005-11-04.parquet size: 2.8 MB rows: 201,777 symbols: 2,105
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-04 05:20:00 | AAPL | Stock | 2.175 | 2.175 | 2.175 | 2.175 | 14000.0 |
| 2005-11-04 05:25:00 | AAPL | Stock | 2.175 | 2.175 | 2.175 | 2.175 | 11200.0 |
| 2005-11-04 05:40:00 | AAPL | Stock | 2.1754 | 2.1754 | 2.175 | 2.175 | 28000.0 |
| 2005-11-04 06:05:00 | AAPL | Stock | 2.1696 | 2.1696 | 2.1696 | 2.1696 | 14000.0 |
| 2005-11-04 06:40:00 | AAPL | Stock | 2.1607 | 2.1607 | 2.1607 | 2.1607 | 2800.0 |
| 2005-11-04 07:00:00 | AAPL | Stock | 2.15 | 2.1689 | 2.15 | 2.1689 | 86800.0 |
| 2005-11-04 07:05:00 | AAPL | Stock | 2.1571 | 2.1607 | 2.1571 | 2.1607 | 1190000.0 |
| 2005-11-04 07:10:00 | AAPL | Stock | 2.1589 | 2.1607 | 2.1589 | 2.1589 | 72800.0 |
| 2005-11-04 07:15:00 | AAPL | Stock | 2.1568 | 2.1579 | 2.1557 | 2.1571 | 128800.0 |
| 2005-11-04 07:20:00 | AAPL | Stock | 2.1571 | 2.1607 | 2.1539 | 2.1579 | 92372.0 |
| 2005-11-04 07:25:00 | AAPL | Stock | 2.1579 | 2.1579 | 2.1579 | 2.1579 | 14000.0 |
| 2005-11-04 07:30:00 | AAPL | Stock | 2.1579 | 2.1579 | 2.1579 | 2.1579 | 19600.0 |
| 2005-11-04 07:35:00 | AAPL | Stock | 2.1579 | 2.1579 | 2.1579 | 2.1579 | 36400.0 |
| 2005-11-04 07:40:00 | AAPL | Stock | 2.1582 | 2.1607 | 2.1582 | 2.1607 | 25200.0 |
| 2005-11-04 07:45:00 | AAPL | Stock | 2.1607 | 2.1607 | 2.1571 | 2.1589 | 108052.0 |
| 2005-11-04 07:50:00 | AAPL | Stock | 2.1589 | 2.1632 | 2.1589 | 2.1632 | 105812.0 |
| 2005-11-04 07:55:00 | AAPL | Stock | 2.1636 | 2.1657 | 2.1636 | 2.1657 | 30800.0 |
| 2005-11-04 08:00:00 | AAPL | Stock | 2.1629 | 2.1768 | 2.1525 | 2.1557 | 2000824.0 |
| 2005-11-04 08:05:00 | AAPL | Stock | 2.1557 | 2.1625 | 2.1518 | 2.1604 | 1171520.0 |
| 2005-11-04 08:10:00 | AAPL | Stock | 2.1589 | 2.1682 | 2.1575 | 2.1675 | 534604.0 |
| 2005-11-04 08:15:00 | AAPL | Stock | 2.1679 | 2.175 | 2.1661 | 2.1718 | 772856.0 |
| 2005-11-04 08:20:00 | AAPL | Stock | 2.1729 | 2.1779 | 2.1718 | 2.1736 | 1036056.0 |
| 2005-11-04 08:25:00 | AAPL | Stock | 2.1732 | 2.1743 | 2.1689 | 2.1704 | 779268.0 |
| 2005-11-04 08:30:00 | AAPL | Stock | 2.1704 | 2.1707 | 2.1625 | 2.1654 | 1368948.0 |
| 2005-11-04 08:35:00 | AAPL | Stock | 2.1643 | 2.1689 | 2.1629 | 2.1661 | 749140.0 |
| 2005-11-04 08:40:00 | AAPL | Stock | 2.1643 | 2.1679 | 2.1643 | 2.1668 | 282324.0 |
| 2005-11-04 08:45:00 | AAPL | Stock | 2.1679 | 2.1679 | 2.1618 | 2.1618 | 921452.0 |
| 2005-11-04 08:50:00 | AAPL | Stock | 2.1636 | 2.1657 | 2.1618 | 2.1643 | 732900.0 |
| 2005-11-04 08:55:00 | AAPL | Stock | 2.1661 | 2.1668 | 2.1639 | 2.1661 | 252896.0 |
| 2005-11-04 09:00:00 | AAPL | Stock | 2.1668 | 2.1732 | 2.1668 | 2.1732 | 984788.0 |
| 2005-11-04 09:05:00 | AAPL | Stock | 2.1714 | 2.1761 | 2.1714 | 2.175 | 792036.0 |
| 2005-11-04 09:10:00 | AAPL | Stock | 2.175 | 2.1764 | 2.1732 | 2.1732 | 661528.0 |
| 2005-11-04 09:15:00 | AAPL | Stock | 2.1743 | 2.1743 | 2.1614 | 2.1661 | 817880.0 |
| 2005-11-04 09:20:00 | AAPL | Stock | 2.1654 | 2.1661 | 2.1643 | 2.1654 | 1070300.0 |
| 2005-11-04 09:25:00 | AAPL | Stock | 2.1664 | 2.1689 | 2.1554 | 2.1554 | 2980908.0 |
| 2005-11-04 09:30:00 | AAPL | Stock | 2.1554 | 2.1607 | 2.1454 | 2.1482 | 54630548.0 |
| 2005-11-04 09:35:00 | AAPL | Stock | 2.1489 | 2.1532 | 2.14 | 2.1493 | 51914940.0 |
| 2005-11-04 09:40:00 | AAPL | Stock | 2.1496 | 2.1571 | 2.1325 | 2.1357 | 31311224.0 |
| 2005-11-04 09:45:00 | AAPL | Stock | 2.1357 | 2.1418 | 2.1293 | 2.1407 | 28299712.0 |
| 2005-11-04 09:50:00 | AAPL | Stock | 2.14 | 2.1529 | 2.1371 | 2.1471 | 28100940.0 |
| 2005-11-04 09:55:00 | AAPL | Stock | 2.1475 | 2.1664 | 2.1468 | 2.1657 | 25781448.0 |
| 2005-11-04 10:00:00 | AAPL | Stock | 2.1657 | 2.1671 | 2.1511 | 2.1636 | 23650480.0 |
| 2005-11-04 10:05:00 | AAPL | Stock | 2.1639 | 2.1643 | 2.1582 | 2.1589 | 12915112.0 |
| 2005-11-04 10:10:00 | AAPL | Stock | 2.1589 | 2.1596 | 2.1507 | 2.1546 | 14107632.0 |
| 2005-11-04 10:15:00 | AAPL | Stock | 2.1543 | 2.1561 | 2.1475 | 2.1489 | 14792512.0 |
| 2005-11-04 10:20:00 | AAPL | Stock | 2.1493 | 2.1532 | 2.1446 | 2.1502 | 16849308.0 |
| 2005-11-04 10:25:00 | AAPL | Stock | 2.1504 | 2.1625 | 2.15 | 2.1604 | 10498488.0 |
| 2005-11-04 10:30:00 | AAPL | Stock | 2.1604 | 2.1611 | 2.1479 | 2.1518 | 9778692.0 |
| 2005-11-04 10:35:00 | AAPL | Stock | 2.1518 | 2.1543 | 2.1482 | 2.1493 | 9039744.0 |
| 2005-11-04 10:40:00 | AAPL | Stock | 2.1496 | 2.1536 | 2.1482 | 2.1514 | 9267524.0 |
> showing 50 of 201,777 rows — these rows as CSV