PREVIEW / stock_1min / 2014-05-02
file: by_date/stock_1min/2014/2014-05-02.parquet size: 14.2 MB rows: 1,056,268 symbols: 2,870
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-02 04:00:00 | AAPL | Stock | 21.1429 | 21.1429 | 21.1429 | 21.1429 | 5600.0 |
| 2014-05-02 06:17:00 | AAPL | Stock | 21.1786 | 21.1786 | 21.1786 | 21.1786 | 2800.0 |
| 2014-05-02 06:58:00 | AAPL | Stock | 21.1786 | 21.1786 | 21.1786 | 21.1786 | 2800.0 |
| 2014-05-02 07:02:00 | AAPL | Stock | 21.1768 | 21.1768 | 21.1768 | 21.1768 | 2800.0 |
| 2014-05-02 07:04:00 | AAPL | Stock | 21.1714 | 21.1714 | 21.1714 | 21.1714 | 24668.0 |
| 2014-05-02 07:09:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 2800.0 |
| 2014-05-02 07:10:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 9212.0 |
| 2014-05-02 07:15:00 | AAPL | Stock | 21.1643 | 21.1643 | 21.1643 | 21.1643 | 12040.0 |
| 2014-05-02 07:29:00 | AAPL | Stock | 21.1643 | 21.1643 | 21.1643 | 21.1643 | 2800.0 |
| 2014-05-02 07:30:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 18200.0 |
| 2014-05-02 07:38:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 2800.0 |
| 2014-05-02 07:40:00 | AAPL | Stock | 21.1693 | 21.1693 | 21.1693 | 21.1693 | 2800.0 |
| 2014-05-02 07:51:00 | AAPL | Stock | 21.1686 | 21.1696 | 21.1686 | 21.1696 | 18200.0 |
| 2014-05-02 08:00:00 | AAPL | Stock | 21.1611 | 21.1696 | 21.1607 | 21.1607 | 46032.0 |
| 2014-05-02 08:01:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.16 | 21.1607 | 11172.0 |
| 2014-05-02 08:02:00 | AAPL | Stock | 21.1429 | 21.1607 | 21.1429 | 21.1607 | 28924.0 |
| 2014-05-02 08:08:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1475 | 21.1475 | 43848.0 |
| 2014-05-02 08:09:00 | AAPL | Stock | 21.155 | 21.1571 | 21.155 | 21.1557 | 13888.0 |
| 2014-05-02 08:11:00 | AAPL | Stock | 21.1582 | 21.1604 | 21.1582 | 21.1604 | 12936.0 |
| 2014-05-02 08:13:00 | AAPL | Stock | 21.1564 | 21.1564 | 21.1564 | 21.1564 | 2800.0 |
| 2014-05-02 08:17:00 | AAPL | Stock | 21.1593 | 21.1593 | 21.1593 | 21.1593 | 2800.0 |
| 2014-05-02 08:19:00 | AAPL | Stock | 21.1604 | 21.1604 | 21.1604 | 21.1604 | 2800.0 |
| 2014-05-02 08:25:00 | AAPL | Stock | 21.16 | 21.1604 | 21.1514 | 21.1514 | 16016.0 |
| 2014-05-02 08:26:00 | AAPL | Stock | 21.1657 | 21.1743 | 21.1657 | 21.1743 | 12824.0 |
| 2014-05-02 08:27:00 | AAPL | Stock | 21.1729 | 21.1729 | 21.1729 | 21.1729 | 2800.0 |
| 2014-05-02 08:29:00 | AAPL | Stock | 21.1611 | 21.1611 | 21.1611 | 21.1611 | 2800.0 |
| 2014-05-02 08:30:00 | AAPL | Stock | 21.1604 | 21.2107 | 21.1604 | 21.1961 | 49196.0 |
| 2014-05-02 08:31:00 | AAPL | Stock | 21.1786 | 21.1811 | 21.1604 | 21.1786 | 90440.0 |
| 2014-05-02 08:32:00 | AAPL | Stock | 21.1904 | 21.1914 | 21.1629 | 21.1782 | 19600.0 |
| 2014-05-02 08:33:00 | AAPL | Stock | 21.1746 | 21.1746 | 21.1739 | 21.1746 | 11200.0 |
| 2014-05-02 08:34:00 | AAPL | Stock | 21.19 | 21.19 | 21.19 | 21.19 | 2800.0 |
| 2014-05-02 08:35:00 | AAPL | Stock | 21.1789 | 21.1789 | 21.1696 | 21.1696 | 17724.0 |
| 2014-05-02 08:36:00 | AAPL | Stock | 21.1696 | 21.1696 | 21.1607 | 21.1607 | 14112.0 |
| 2014-05-02 08:37:00 | AAPL | Stock | 21.1704 | 21.1704 | 21.1682 | 21.1696 | 85876.0 |
| 2014-05-02 08:38:00 | AAPL | Stock | 21.1693 | 21.1693 | 21.1693 | 21.1693 | 2800.0 |
| 2014-05-02 08:40:00 | AAPL | Stock | 21.1693 | 21.1696 | 21.165 | 21.165 | 11200.0 |
| 2014-05-02 08:42:00 | AAPL | Stock | 21.1696 | 21.1696 | 21.1696 | 21.1696 | 8316.0 |
| 2014-05-02 08:46:00 | AAPL | Stock | 21.1829 | 21.1829 | 21.1829 | 21.1829 | 16632.0 |
| 2014-05-02 08:49:00 | AAPL | Stock | 21.1857 | 21.1857 | 21.1857 | 21.1857 | 2800.0 |
| 2014-05-02 08:50:00 | AAPL | Stock | 21.1893 | 21.1893 | 21.1821 | 21.1821 | 8540.0 |
| 2014-05-02 08:51:00 | AAPL | Stock | 21.1925 | 21.1925 | 21.1925 | 21.1925 | 5600.0 |
| 2014-05-02 08:55:00 | AAPL | Stock | 21.1804 | 21.1804 | 21.1793 | 21.1793 | 8400.0 |
| 2014-05-02 08:56:00 | AAPL | Stock | 21.1786 | 21.1789 | 21.1768 | 21.1775 | 67508.0 |
| 2014-05-02 08:57:00 | AAPL | Stock | 21.1714 | 21.1714 | 21.1714 | 21.1714 | 7000.0 |
| 2014-05-02 08:58:00 | AAPL | Stock | 21.1757 | 21.1771 | 21.1639 | 21.1639 | 19600.0 |
| 2014-05-02 09:01:00 | AAPL | Stock | 21.1646 | 21.1714 | 21.1646 | 21.1714 | 33880.0 |
| 2014-05-02 09:02:00 | AAPL | Stock | 21.1639 | 21.165 | 21.1607 | 21.1607 | 75124.0 |
| 2014-05-02 09:03:00 | AAPL | Stock | 21.1518 | 21.1625 | 21.1511 | 21.1625 | 42000.0 |
| 2014-05-02 09:04:00 | AAPL | Stock | 21.1546 | 21.1546 | 21.1546 | 21.1546 | 5320.0 |
| 2014-05-02 09:05:00 | AAPL | Stock | 21.1546 | 21.1625 | 21.1546 | 21.1625 | 16800.0 |
> showing 50 of 1,056,268 rows — these rows as CSV