PREVIEW / stock_1min / 2013-12-27
file: by_date/stock_1min/2013/2013-12-27.parquet size: 13.2 MB rows: 967,942 symbols: 2,855
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-27 04:29:00 | AAPL | Stock | 20.1643 | 20.1643 | 20.1643 | 20.1643 | 2800.0 |
| 2013-12-27 04:41:00 | AAPL | Stock | 20.1571 | 20.1571 | 20.1571 | 20.1571 | 2800.0 |
| 2013-12-27 04:49:00 | AAPL | Stock | 20.1625 | 20.1625 | 20.1625 | 20.1625 | 2800.0 |
| 2013-12-27 04:59:00 | AAPL | Stock | 20.1607 | 20.1607 | 20.1571 | 20.1571 | 5600.0 |
| 2013-12-27 05:02:00 | AAPL | Stock | 20.15 | 20.15 | 20.1482 | 20.1482 | 5600.0 |
| 2013-12-27 05:05:00 | AAPL | Stock | 20.1471 | 20.1471 | 20.1471 | 20.1471 | 5600.0 |
| 2013-12-27 05:11:00 | AAPL | Stock | 20.1482 | 20.1482 | 20.1482 | 20.1482 | 2800.0 |
| 2013-12-27 05:25:00 | AAPL | Stock | 20.1446 | 20.1446 | 20.1429 | 20.1429 | 5600.0 |
| 2013-12-27 05:26:00 | AAPL | Stock | 20.1357 | 20.1357 | 20.1357 | 20.1357 | 2800.0 |
| 2013-12-27 05:29:00 | AAPL | Stock | 20.1321 | 20.1321 | 20.1321 | 20.1321 | 2800.0 |
| 2013-12-27 05:36:00 | AAPL | Stock | 20.125 | 20.125 | 20.125 | 20.125 | 2800.0 |
| 2013-12-27 05:40:00 | AAPL | Stock | 20.1314 | 20.1314 | 20.125 | 20.125 | 5600.0 |
| 2013-12-27 05:42:00 | AAPL | Stock | 20.1179 | 20.1179 | 20.1179 | 20.1179 | 2800.0 |
| 2013-12-27 06:04:00 | AAPL | Stock | 20.1279 | 20.1279 | 20.1279 | 20.1279 | 2800.0 |
| 2013-12-27 06:38:00 | AAPL | Stock | 20.1554 | 20.1571 | 20.1554 | 20.1554 | 15400.0 |
| 2013-12-27 06:41:00 | AAPL | Stock | 20.1536 | 20.1536 | 20.1536 | 20.1536 | 2800.0 |
| 2013-12-27 06:56:00 | AAPL | Stock | 20.1661 | 20.1661 | 20.1621 | 20.1621 | 5600.0 |
| 2013-12-27 07:15:00 | AAPL | Stock | 20.1786 | 20.1804 | 20.1786 | 20.1804 | 8400.0 |
| 2013-12-27 07:16:00 | AAPL | Stock | 20.1607 | 20.1607 | 20.1607 | 20.1607 | 2800.0 |
| 2013-12-27 07:17:00 | AAPL | Stock | 20.16 | 20.1821 | 20.16 | 20.1821 | 26236.0 |
| 2013-12-27 07:24:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1786 | 20.1786 | 5600.0 |
| 2013-12-27 07:27:00 | AAPL | Stock | 20.1789 | 20.1789 | 20.1775 | 20.1775 | 5600.0 |
| 2013-12-27 07:30:00 | AAPL | Stock | 20.1811 | 20.1904 | 20.1811 | 20.1904 | 5600.0 |
| 2013-12-27 07:31:00 | AAPL | Stock | 20.1925 | 20.1925 | 20.1925 | 20.1925 | 2800.0 |
| 2013-12-27 07:39:00 | AAPL | Stock | 20.1864 | 20.1864 | 20.1864 | 20.1864 | 2800.0 |
| 2013-12-27 07:41:00 | AAPL | Stock | 20.1771 | 20.1771 | 20.1771 | 20.1771 | 2800.0 |
| 2013-12-27 07:42:00 | AAPL | Stock | 20.1782 | 20.1782 | 20.1782 | 20.1782 | 2800.0 |
| 2013-12-27 07:49:00 | AAPL | Stock | 20.1875 | 20.1875 | 20.1875 | 20.1875 | 7280.0 |
| 2013-12-27 07:51:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1893 | 20.1893 | 2800.0 |
| 2013-12-27 07:54:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1893 | 20.1893 | 16800.0 |
| 2013-12-27 07:57:00 | AAPL | Stock | 20.1961 | 20.1961 | 20.1961 | 20.1961 | 2800.0 |
| 2013-12-27 07:58:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1821 | 20.1821 | 14700.0 |
| 2013-12-27 08:00:00 | AAPL | Stock | 20.14 | 20.1893 | 20.14 | 20.1864 | 41692.0 |
| 2013-12-27 08:02:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 70000.0 |
| 2013-12-27 08:03:00 | AAPL | Stock | 20.1964 | 20.1964 | 20.1964 | 20.1964 | 4200.0 |
| 2013-12-27 08:05:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1893 | 20.1893 | 2800.0 |
| 2013-12-27 08:06:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1786 | 20.1786 | 13720.0 |
| 2013-12-27 08:07:00 | AAPL | Stock | 20.1696 | 20.1696 | 20.1696 | 20.1696 | 2800.0 |
| 2013-12-27 08:09:00 | AAPL | Stock | 20.1696 | 20.1696 | 20.1696 | 20.1696 | 2800.0 |
| 2013-12-27 08:10:00 | AAPL | Stock | 20.1607 | 20.1768 | 20.1607 | 20.1768 | 30800.0 |
| 2013-12-27 08:13:00 | AAPL | Stock | 20.1707 | 20.1732 | 20.1654 | 20.1732 | 56700.0 |
| 2013-12-27 08:15:00 | AAPL | Stock | 20.1518 | 20.1518 | 20.1518 | 20.1518 | 5600.0 |
| 2013-12-27 08:17:00 | AAPL | Stock | 20.1632 | 20.1632 | 20.1632 | 20.1632 | 2800.0 |
| 2013-12-27 08:21:00 | AAPL | Stock | 20.1575 | 20.1607 | 20.1575 | 20.1607 | 10108.0 |
| 2013-12-27 08:22:00 | AAPL | Stock | 20.1689 | 20.1689 | 20.1654 | 20.1654 | 38780.0 |
| 2013-12-27 08:23:00 | AAPL | Stock | 20.1686 | 20.1686 | 20.1686 | 20.1686 | 2800.0 |
| 2013-12-27 08:24:00 | AAPL | Stock | 20.1686 | 20.1696 | 20.1686 | 20.1696 | 12600.0 |
| 2013-12-27 08:25:00 | AAPL | Stock | 20.175 | 20.175 | 20.1739 | 20.175 | 19600.0 |
| 2013-12-27 08:26:00 | AAPL | Stock | 20.17 | 20.1739 | 20.1607 | 20.1607 | 44800.0 |
| 2013-12-27 08:27:00 | AAPL | Stock | 20.1625 | 20.1625 | 20.1625 | 20.1625 | 2800.0 |
> showing 50 of 967,942 rows — these rows as CSV