PREVIEW / stock_1min / 2014-01-29
file: by_date/stock_1min/2014/2014-01-29.parquet size: 15.1 MB rows: 1,087,963 symbols: 2,851
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-01-29 04:00:00 | AAPL | Stock | 18.1929 | 18.2611 | 18.1929 | 18.2611 | 79968.0 |
| 2014-01-29 04:01:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2857 | 18.2857 | 12880.0 |
| 2014-01-29 04:02:00 | AAPL | Stock | 18.2764 | 18.2857 | 18.2764 | 18.2857 | 21812.0 |
| 2014-01-29 04:03:00 | AAPL | Stock | 18.2804 | 18.2804 | 18.2804 | 18.2804 | 7728.0 |
| 2014-01-29 04:04:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2857 | 18.2857 | 5600.0 |
| 2014-01-29 04:05:00 | AAPL | Stock | 18.3125 | 18.3125 | 18.3125 | 18.3125 | 6440.0 |
| 2014-01-29 04:06:00 | AAPL | Stock | 18.2896 | 18.2896 | 18.2857 | 18.2857 | 8988.0 |
| 2014-01-29 04:07:00 | AAPL | Stock | 18.2554 | 18.2554 | 18.2554 | 18.2554 | 22344.0 |
| 2014-01-29 04:11:00 | AAPL | Stock | 18.2261 | 18.2268 | 18.2232 | 18.2246 | 47908.0 |
| 2014-01-29 04:12:00 | AAPL | Stock | 18.225 | 18.2268 | 18.225 | 18.2268 | 27944.0 |
| 2014-01-29 04:16:00 | AAPL | Stock | 18.2293 | 18.2293 | 18.2293 | 18.2293 | 2800.0 |
| 2014-01-29 04:27:00 | AAPL | Stock | 18.2514 | 18.2514 | 18.2514 | 18.2514 | 2800.0 |
| 2014-01-29 04:34:00 | AAPL | Stock | 18.25 | 18.25 | 18.25 | 18.25 | 2800.0 |
| 2014-01-29 04:35:00 | AAPL | Stock | 18.2414 | 18.25 | 18.2414 | 18.25 | 11060.0 |
| 2014-01-29 04:37:00 | AAPL | Stock | 18.2682 | 18.2682 | 18.2682 | 18.2682 | 2800.0 |
| 2014-01-29 04:41:00 | AAPL | Stock | 18.2682 | 18.2682 | 18.2682 | 18.2682 | 2800.0 |
| 2014-01-29 04:43:00 | AAPL | Stock | 18.2675 | 18.2675 | 18.2589 | 18.2589 | 14000.0 |
| 2014-01-29 04:44:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 15120.0 |
| 2014-01-29 04:45:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 2800.0 |
| 2014-01-29 04:58:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 2800.0 |
| 2014-01-29 05:01:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 5600.0 |
| 2014-01-29 05:02:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 28000.0 |
| 2014-01-29 05:08:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 5600.0 |
| 2014-01-29 05:09:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 2800.0 |
| 2014-01-29 05:13:00 | AAPL | Stock | 18.25 | 18.25 | 18.25 | 18.25 | 4900.0 |
| 2014-01-29 05:15:00 | AAPL | Stock | 18.2482 | 18.2482 | 18.2482 | 18.2482 | 2800.0 |
| 2014-01-29 05:20:00 | AAPL | Stock | 18.2482 | 18.2482 | 18.2482 | 18.2482 | 9940.0 |
| 2014-01-29 05:24:00 | AAPL | Stock | 18.25 | 18.25 | 18.25 | 18.25 | 14000.0 |
| 2014-01-29 05:27:00 | AAPL | Stock | 18.2411 | 18.2411 | 18.215 | 18.2411 | 30800.0 |
| 2014-01-29 05:28:00 | AAPL | Stock | 18.2164 | 18.2164 | 18.2161 | 18.2161 | 22624.0 |
| 2014-01-29 05:31:00 | AAPL | Stock | 18.2161 | 18.2161 | 18.2143 | 18.2143 | 6916.0 |
| 2014-01-29 05:33:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2143 | 18.2143 | 28000.0 |
| 2014-01-29 05:34:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2143 | 18.2143 | 5600.0 |
| 2014-01-29 05:35:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2143 | 18.2143 | 8400.0 |
| 2014-01-29 05:37:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2143 | 18.2143 | 15120.0 |
| 2014-01-29 05:38:00 | AAPL | Stock | 18.2425 | 18.2446 | 18.2143 | 18.2143 | 17360.0 |
| 2014-01-29 05:39:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2143 | 18.2143 | 9520.0 |
| 2014-01-29 05:44:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1964 | 18.1964 | 8400.0 |
| 2014-01-29 05:46:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1804 | 18.1804 | 14000.0 |
| 2014-01-29 05:47:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1964 | 18.1964 | 8400.0 |
| 2014-01-29 05:51:00 | AAPL | Stock | 18.2157 | 18.2157 | 18.2157 | 18.2157 | 2800.0 |
| 2014-01-29 05:55:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2143 | 18.2143 | 8400.0 |
| 2014-01-29 06:02:00 | AAPL | Stock | 18.2125 | 18.2125 | 18.2125 | 18.2125 | 2800.0 |
| 2014-01-29 06:04:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2125 | 18.2125 | 14000.0 |
| 2014-01-29 06:12:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1964 | 18.1964 | 2800.0 |
| 2014-01-29 06:20:00 | AAPL | Stock | 18.21 | 18.2143 | 18.2093 | 18.2143 | 14000.0 |
| 2014-01-29 06:23:00 | AAPL | Stock | 18.2036 | 18.2036 | 18.2036 | 18.2036 | 2800.0 |
| 2014-01-29 06:24:00 | AAPL | Stock | 18.2082 | 18.2082 | 18.2082 | 18.2082 | 5600.0 |
| 2014-01-29 06:28:00 | AAPL | Stock | 18.1989 | 18.1989 | 18.1964 | 18.1964 | 24920.0 |
| 2014-01-29 06:30:00 | AAPL | Stock | 18.2071 | 18.2071 | 18.2071 | 18.2071 | 2800.0 |
> showing 50 of 1,087,963 rows — these rows as CSV