PREVIEW / stock_5min / 2005-11-09
file: by_date/stock_5min/2005/2005-11-09.parquet size: 2.8 MB rows: 205,677 symbols: 2,100
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-09 07:30:00 | AAPL | Stock | 2.145 | 2.145 | 2.145 | 2.145 | 28000.0 |
| 2005-11-09 07:35:00 | AAPL | Stock | 2.1496 | 2.1496 | 2.1496 | 2.1496 | 2800.0 |
| 2005-11-09 08:00:00 | AAPL | Stock | 2.1429 | 2.1464 | 2.1429 | 2.1464 | 902916.0 |
| 2005-11-09 08:05:00 | AAPL | Stock | 2.145 | 2.1482 | 2.145 | 2.1464 | 28980.0 |
| 2005-11-09 08:10:00 | AAPL | Stock | 2.1482 | 2.1496 | 2.1482 | 2.1496 | 64400.0 |
| 2005-11-09 08:15:00 | AAPL | Stock | 2.1482 | 2.1482 | 2.145 | 2.1464 | 92400.0 |
| 2005-11-09 08:20:00 | AAPL | Stock | 2.145 | 2.145 | 2.1429 | 2.1429 | 112280.0 |
| 2005-11-09 08:25:00 | AAPL | Stock | 2.1429 | 2.1429 | 2.1429 | 2.1429 | 83160.0 |
| 2005-11-09 08:30:00 | AAPL | Stock | 2.145 | 2.145 | 2.145 | 2.145 | 36120.0 |
| 2005-11-09 08:35:00 | AAPL | Stock | 2.1429 | 2.1429 | 2.1429 | 2.1429 | 8400.0 |
| 2005-11-09 08:40:00 | AAPL | Stock | 2.1414 | 2.1429 | 2.1393 | 2.1429 | 33600.0 |
| 2005-11-09 08:45:00 | AAPL | Stock | 2.1429 | 2.1457 | 2.1429 | 2.1454 | 106400.0 |
| 2005-11-09 08:50:00 | AAPL | Stock | 2.1429 | 2.1429 | 2.1429 | 2.1429 | 14000.0 |
| 2005-11-09 08:55:00 | AAPL | Stock | 2.1457 | 2.1461 | 2.1457 | 2.1461 | 103600.0 |
| 2005-11-09 09:00:00 | AAPL | Stock | 2.1432 | 2.1432 | 2.1429 | 2.1429 | 43680.0 |
| 2005-11-09 09:05:00 | AAPL | Stock | 2.1454 | 2.1454 | 2.1439 | 2.1439 | 19600.0 |
| 2005-11-09 09:10:00 | AAPL | Stock | 2.1454 | 2.1464 | 2.1454 | 2.1464 | 92400.0 |
| 2005-11-09 09:15:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 19320.0 |
| 2005-11-09 09:20:00 | AAPL | Stock | 2.1432 | 2.1479 | 2.1432 | 2.1479 | 16800.0 |
| 2005-11-09 09:25:00 | AAPL | Stock | 2.1446 | 2.1479 | 2.1432 | 2.1479 | 511700.0 |
| 2005-11-09 09:30:00 | AAPL | Stock | 2.1429 | 2.1618 | 2.1429 | 2.1525 | 16298016.0 |
| 2005-11-09 09:35:00 | AAPL | Stock | 2.1534 | 2.1571 | 2.15 | 2.1561 | 9688252.0 |
| 2005-11-09 09:40:00 | AAPL | Stock | 2.1564 | 2.1739 | 2.1557 | 2.1729 | 17190880.0 |
| 2005-11-09 09:45:00 | AAPL | Stock | 2.1732 | 2.185 | 2.1693 | 2.1839 | 26580680.0 |
| 2005-11-09 09:50:00 | AAPL | Stock | 2.1836 | 2.1861 | 2.1732 | 2.1779 | 21170436.0 |
| 2005-11-09 09:55:00 | AAPL | Stock | 2.1775 | 2.1804 | 2.1639 | 2.1668 | 16209928.0 |
| 2005-11-09 10:00:00 | AAPL | Stock | 2.1664 | 2.1786 | 2.1657 | 2.1786 | 11013016.0 |
| 2005-11-09 10:05:00 | AAPL | Stock | 2.1786 | 2.1814 | 2.1729 | 2.1757 | 8952916.0 |
| 2005-11-09 10:10:00 | AAPL | Stock | 2.1757 | 2.1786 | 2.1725 | 2.1775 | 7088088.0 |
| 2005-11-09 10:15:00 | AAPL | Stock | 2.1775 | 2.18 | 2.1696 | 2.1704 | 7810208.0 |
| 2005-11-09 10:20:00 | AAPL | Stock | 2.17 | 2.1743 | 2.1661 | 2.1664 | 6212836.0 |
| 2005-11-09 10:25:00 | AAPL | Stock | 2.1661 | 2.1664 | 2.1561 | 2.1661 | 18999736.0 |
| 2005-11-09 10:30:00 | AAPL | Stock | 2.1639 | 2.1732 | 2.1625 | 2.1718 | 11254908.0 |
| 2005-11-09 10:35:00 | AAPL | Stock | 2.1721 | 2.1857 | 2.1714 | 2.1739 | 16107420.0 |
| 2005-11-09 10:40:00 | AAPL | Stock | 2.1743 | 2.18 | 2.1743 | 2.1793 | 9059848.0 |
| 2005-11-09 10:45:00 | AAPL | Stock | 2.1793 | 2.1804 | 2.1764 | 2.1775 | 6201916.0 |
| 2005-11-09 10:50:00 | AAPL | Stock | 2.1779 | 2.1789 | 2.1721 | 2.1732 | 7131992.0 |
| 2005-11-09 10:55:00 | AAPL | Stock | 2.1736 | 2.1739 | 2.1696 | 2.1696 | 4708060.0 |
| 2005-11-09 11:00:00 | AAPL | Stock | 2.17 | 2.1736 | 2.1664 | 2.17 | 6476624.0 |
| 2005-11-09 11:05:00 | AAPL | Stock | 2.1696 | 2.17 | 2.1646 | 2.1679 | 6228320.0 |
| 2005-11-09 11:10:00 | AAPL | Stock | 2.1675 | 2.1689 | 2.1636 | 2.1689 | 4713800.0 |
| 2005-11-09 11:15:00 | AAPL | Stock | 2.1686 | 2.1732 | 2.1661 | 2.1721 | 4814236.0 |
| 2005-11-09 11:20:00 | AAPL | Stock | 2.1718 | 2.1725 | 2.17 | 2.1707 | 2163840.0 |
| 2005-11-09 11:25:00 | AAPL | Stock | 2.1711 | 2.1732 | 2.1668 | 2.1704 | 5060608.0 |
| 2005-11-09 11:30:00 | AAPL | Stock | 2.1704 | 2.1707 | 2.1664 | 2.1675 | 3015768.0 |
| 2005-11-09 11:35:00 | AAPL | Stock | 2.1675 | 2.17 | 2.1643 | 2.1654 | 4580632.0 |
| 2005-11-09 11:40:00 | AAPL | Stock | 2.1654 | 2.1664 | 2.1611 | 2.1661 | 4499740.0 |
| 2005-11-09 11:45:00 | AAPL | Stock | 2.1661 | 2.1664 | 2.1607 | 2.1614 | 5233424.0 |
| 2005-11-09 11:50:00 | AAPL | Stock | 2.1607 | 2.1664 | 2.1607 | 2.1647 | 5026588.0 |
| 2005-11-09 11:55:00 | AAPL | Stock | 2.1646 | 2.1654 | 2.1625 | 2.1643 | 2325540.0 |
> showing 50 of 205,677 rows — these rows as CSV