PREVIEW / stock_1min / 2012-12-13
file: by_date/stock_1min/2012/2012-12-13.parquet size: 12.5 MB rows: 923,324 symbols: 2,848
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-13 04:22:00 | AAPL | Stock | 19.2682 | 19.2682 | 19.2682 | 19.2682 | 2800.0 |
| 2012-12-13 04:25:00 | AAPL | Stock | 19.2739 | 19.2739 | 19.2739 | 19.2739 | 2800.0 |
| 2012-12-13 04:43:00 | AAPL | Stock | 19.2346 | 19.2346 | 19.2346 | 19.2346 | 2800.0 |
| 2012-12-13 05:17:00 | AAPL | Stock | 19.2146 | 19.2146 | 19.2146 | 19.2146 | 2800.0 |
| 2012-12-13 05:27:00 | AAPL | Stock | 19.1993 | 19.1993 | 19.1993 | 19.1993 | 2800.0 |
| 2012-12-13 05:41:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 8400.0 |
| 2012-12-13 05:48:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 4200.0 |
| 2012-12-13 05:49:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 28560.0 |
| 2012-12-13 05:50:00 | AAPL | Stock | 19.1954 | 19.1954 | 19.1929 | 19.1929 | 5600.0 |
| 2012-12-13 05:51:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 2800.0 |
| 2012-12-13 06:01:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 2800.0 |
| 2012-12-13 06:05:00 | AAPL | Stock | 19.1786 | 19.1786 | 19.1786 | 19.1786 | 9520.0 |
| 2012-12-13 06:24:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 14000.0 |
| 2012-12-13 06:25:00 | AAPL | Stock | 19.1821 | 19.1821 | 19.1821 | 19.1821 | 26320.0 |
| 2012-12-13 06:38:00 | AAPL | Stock | 19.1607 | 19.1607 | 19.1607 | 19.1607 | 2800.0 |
| 2012-12-13 06:40:00 | AAPL | Stock | 19.1482 | 19.1482 | 19.1482 | 19.1482 | 5600.0 |
| 2012-12-13 06:41:00 | AAPL | Stock | 19.1446 | 19.1446 | 19.1446 | 19.1446 | 21560.0 |
| 2012-12-13 06:42:00 | AAPL | Stock | 19.1429 | 19.1429 | 19.1429 | 19.1429 | 8372.0 |
| 2012-12-13 06:50:00 | AAPL | Stock | 19.1571 | 19.1571 | 19.1571 | 19.1571 | 2800.0 |
| 2012-12-13 06:54:00 | AAPL | Stock | 19.1607 | 19.1607 | 19.1607 | 19.1607 | 2800.0 |
| 2012-12-13 06:58:00 | AAPL | Stock | 19.1596 | 19.1607 | 19.1596 | 19.1607 | 9520.0 |
| 2012-12-13 07:02:00 | AAPL | Stock | 19.1464 | 19.1464 | 19.1464 | 19.1464 | 2800.0 |
| 2012-12-13 07:03:00 | AAPL | Stock | 19.16 | 19.1607 | 19.16 | 19.1607 | 5600.0 |
| 2012-12-13 07:05:00 | AAPL | Stock | 19.1686 | 19.1696 | 19.1686 | 19.1696 | 5600.0 |
| 2012-12-13 07:06:00 | AAPL | Stock | 19.1607 | 19.1607 | 19.1607 | 19.1607 | 2800.0 |
| 2012-12-13 07:08:00 | AAPL | Stock | 19.1696 | 19.1786 | 19.16 | 19.1618 | 105392.0 |
| 2012-12-13 07:09:00 | AAPL | Stock | 19.1789 | 19.1789 | 19.1786 | 19.1786 | 15036.0 |
| 2012-12-13 07:12:00 | AAPL | Stock | 19.1821 | 19.1821 | 19.1821 | 19.1821 | 2800.0 |
| 2012-12-13 07:14:00 | AAPL | Stock | 19.1796 | 19.1796 | 19.1796 | 19.1796 | 23800.0 |
| 2012-12-13 07:15:00 | AAPL | Stock | 19.1796 | 19.1796 | 19.1796 | 19.1796 | 4200.0 |
| 2012-12-13 07:17:00 | AAPL | Stock | 19.2036 | 19.2036 | 19.2036 | 19.2036 | 2800.0 |
| 2012-12-13 07:18:00 | AAPL | Stock | 19.2036 | 19.2036 | 19.2036 | 19.2036 | 2800.0 |
| 2012-12-13 07:19:00 | AAPL | Stock | 19.2004 | 19.2004 | 19.2004 | 19.2004 | 5600.0 |
| 2012-12-13 07:21:00 | AAPL | Stock | 19.2118 | 19.2143 | 19.2086 | 19.2139 | 25424.0 |
| 2012-12-13 07:22:00 | AAPL | Stock | 19.1929 | 19.1929 | 19.1929 | 19.1929 | 2800.0 |
| 2012-12-13 07:23:00 | AAPL | Stock | 19.1861 | 19.1861 | 19.1843 | 19.1843 | 8400.0 |
| 2012-12-13 07:24:00 | AAPL | Stock | 19.1961 | 19.1961 | 19.1961 | 19.1961 | 2800.0 |
| 2012-12-13 07:28:00 | AAPL | Stock | 19.1932 | 19.21 | 19.1932 | 19.21 | 8400.0 |
| 2012-12-13 07:37:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 2800.0 |
| 2012-12-13 07:43:00 | AAPL | Stock | 19.2025 | 19.2057 | 19.2025 | 19.2054 | 24164.0 |
| 2012-12-13 07:44:00 | AAPL | Stock | 19.1943 | 19.1943 | 19.1796 | 19.1796 | 54768.0 |
| 2012-12-13 07:46:00 | AAPL | Stock | 19.1839 | 19.1964 | 19.1839 | 19.1964 | 18200.0 |
| 2012-12-13 07:48:00 | AAPL | Stock | 19.1982 | 19.1982 | 19.1982 | 19.1982 | 2800.0 |
| 2012-12-13 07:49:00 | AAPL | Stock | 19.1843 | 19.1843 | 19.1618 | 19.1618 | 56000.0 |
| 2012-12-13 07:51:00 | AAPL | Stock | 19.1607 | 19.175 | 19.1607 | 19.175 | 28000.0 |
| 2012-12-13 07:55:00 | AAPL | Stock | 19.1771 | 19.1786 | 19.1754 | 19.1754 | 11200.0 |
| 2012-12-13 07:56:00 | AAPL | Stock | 19.1611 | 19.1611 | 19.1607 | 19.1607 | 11200.0 |
| 2012-12-13 07:57:00 | AAPL | Stock | 19.1532 | 19.1532 | 19.1532 | 19.1532 | 2800.0 |
| 2012-12-13 07:59:00 | AAPL | Stock | 19.1607 | 19.1607 | 19.15 | 19.1586 | 21000.0 |
| 2012-12-13 08:00:00 | AAPL | Stock | 19.1614 | 19.2143 | 19.145 | 19.1504 | 124348.0 |
> showing 50 of 923,324 rows — these rows as CSV