PREVIEW / stock_1min / 2013-02-04
file: by_date/stock_1min/2013/2013-02-04.parquet size: 13.2 MB rows: 982,996 symbols: 2,820
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-02-04 04:02:00 | AAPL | Stock | 16.2218 | 16.2218 | 16.2218 | 16.2218 | 5600.0 |
| 2013-02-04 05:30:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2143 | 16.2143 | 17808.0 |
| 2013-02-04 05:31:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2143 | 16.2143 | 10052.0 |
| 2013-02-04 05:55:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2143 | 16.2143 | 2800.0 |
| 2013-02-04 06:29:00 | AAPL | Stock | 16.2071 | 16.2071 | 16.2018 | 16.2018 | 19600.0 |
| 2013-02-04 06:34:00 | AAPL | Stock | 16.2264 | 16.2264 | 16.2264 | 16.2264 | 2800.0 |
| 2013-02-04 06:52:00 | AAPL | Stock | 16.2261 | 16.2261 | 16.2261 | 16.2261 | 2800.0 |
| 2013-02-04 06:53:00 | AAPL | Stock | 16.1879 | 16.1879 | 16.1879 | 16.1879 | 25116.0 |
| 2013-02-04 07:02:00 | AAPL | Stock | 16.2036 | 16.2036 | 16.2036 | 16.2036 | 40460.0 |
| 2013-02-04 07:06:00 | AAPL | Stock | 16.2121 | 16.2214 | 16.2121 | 16.2214 | 11200.0 |
| 2013-02-04 07:08:00 | AAPL | Stock | 16.2036 | 16.2107 | 16.2 | 16.2 | 16800.0 |
| 2013-02-04 07:09:00 | AAPL | Stock | 16.2007 | 16.2007 | 16.2007 | 16.2007 | 5600.0 |
| 2013-02-04 07:10:00 | AAPL | Stock | 16.2007 | 16.2007 | 16.2007 | 16.2007 | 42000.0 |
| 2013-02-04 07:13:00 | AAPL | Stock | 16.1929 | 16.1929 | 16.1929 | 16.1929 | 2800.0 |
| 2013-02-04 07:15:00 | AAPL | Stock | 16.1843 | 16.1843 | 16.1843 | 16.1843 | 2800.0 |
| 2013-02-04 07:17:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1786 | 16.1786 | 2800.0 |
| 2013-02-04 07:19:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1786 | 16.1786 | 28000.0 |
| 2013-02-04 07:20:00 | AAPL | Stock | 16.1696 | 16.1786 | 16.1696 | 16.1786 | 8400.0 |
| 2013-02-04 07:26:00 | AAPL | Stock | 16.1643 | 16.1643 | 16.1429 | 16.1429 | 33600.0 |
| 2013-02-04 07:27:00 | AAPL | Stock | 16.1439 | 16.1639 | 16.1429 | 16.1429 | 54516.0 |
| 2013-02-04 07:28:00 | AAPL | Stock | 16.1407 | 16.1429 | 16.1407 | 16.1421 | 11200.0 |
| 2013-02-04 07:30:00 | AAPL | Stock | 16.1432 | 16.1432 | 16.1429 | 16.1429 | 8400.0 |
| 2013-02-04 07:33:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 5320.0 |
| 2013-02-04 07:34:00 | AAPL | Stock | 16.1607 | 16.1786 | 16.1607 | 16.1786 | 25284.0 |
| 2013-02-04 07:35:00 | AAPL | Stock | 16.15 | 16.1786 | 16.15 | 16.1786 | 31360.0 |
| 2013-02-04 07:38:00 | AAPL | Stock | 16.1786 | 16.1857 | 16.1732 | 16.1786 | 83804.0 |
| 2013-02-04 07:39:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1786 | 16.1786 | 2800.0 |
| 2013-02-04 07:40:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1786 | 16.1786 | 19600.0 |
| 2013-02-04 07:42:00 | AAPL | Stock | 16.1804 | 16.1804 | 16.1804 | 16.1804 | 5600.0 |
| 2013-02-04 07:43:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1786 | 16.1786 | 16800.0 |
| 2013-02-04 07:45:00 | AAPL | Stock | 16.1754 | 16.1754 | 16.175 | 16.175 | 8400.0 |
| 2013-02-04 07:51:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1679 | 16.1679 | 64848.0 |
| 2013-02-04 08:00:00 | AAPL | Stock | 16.1879 | 16.2 | 16.1343 | 16.1607 | 116200.0 |
| 2013-02-04 08:02:00 | AAPL | Stock | 16.1607 | 16.1607 | 16.1607 | 16.1607 | 2800.0 |
| 2013-02-04 08:03:00 | AAPL | Stock | 16.1464 | 16.1471 | 16.125 | 16.125 | 86968.0 |
| 2013-02-04 08:04:00 | AAPL | Stock | 16.1411 | 16.1411 | 16.1268 | 16.1286 | 11200.0 |
| 2013-02-04 08:05:00 | AAPL | Stock | 16.125 | 16.1271 | 16.12 | 16.1211 | 37884.0 |
| 2013-02-04 08:06:00 | AAPL | Stock | 16.1393 | 16.1393 | 16.1286 | 16.1286 | 11200.0 |
| 2013-02-04 08:08:00 | AAPL | Stock | 16.1286 | 16.1286 | 16.1179 | 16.1179 | 64400.0 |
| 2013-02-04 08:09:00 | AAPL | Stock | 16.1107 | 16.1161 | 16.1082 | 16.1082 | 71400.0 |
| 2013-02-04 08:10:00 | AAPL | Stock | 16.1107 | 16.1175 | 16.0911 | 16.0982 | 37912.0 |
| 2013-02-04 08:11:00 | AAPL | Stock | 16.09 | 16.0904 | 16.0771 | 16.0868 | 43400.0 |
| 2013-02-04 08:12:00 | AAPL | Stock | 16.0729 | 16.0729 | 16.0696 | 16.0696 | 60424.0 |
| 2013-02-04 08:13:00 | AAPL | Stock | 16.0632 | 16.07 | 16.0536 | 16.06 | 79240.0 |
| 2013-02-04 08:14:00 | AAPL | Stock | 16.0546 | 16.0546 | 16.0414 | 16.0414 | 50708.0 |
| 2013-02-04 08:15:00 | AAPL | Stock | 16.0457 | 16.0536 | 16.0457 | 16.0511 | 78400.0 |
| 2013-02-04 08:16:00 | AAPL | Stock | 16.0561 | 16.0632 | 16.0529 | 16.0607 | 28000.0 |
| 2013-02-04 08:17:00 | AAPL | Stock | 16.0625 | 16.1521 | 16.0571 | 16.0571 | 115696.0 |
| 2013-02-04 08:18:00 | AAPL | Stock | 16.0543 | 16.0679 | 16.05 | 16.05 | 70000.0 |
| 2013-02-04 08:19:00 | AAPL | Stock | 16.0639 | 16.0639 | 16.0525 | 16.0525 | 49560.0 |
> showing 50 of 982,996 rows — these rows as CSV