PREVIEW / stock_1min / 2012-07-03
file: by_date/stock_1min/2012/2012-07-03.parquet size: 7.7 MB rows: 554,592 symbols: 2,781
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-07-03 04:09:00 | AAPL | Stock | 21.1789 | 21.1789 | 21.1789 | 21.1789 | 8400.0 |
| 2012-07-03 04:10:00 | AAPL | Stock | 21.1789 | 21.1789 | 21.1789 | 21.1789 | 2800.0 |
| 2012-07-03 04:11:00 | AAPL | Stock | 21.1964 | 21.1964 | 21.1964 | 21.1964 | 5600.0 |
| 2012-07-03 04:14:00 | AAPL | Stock | 21.1964 | 21.1964 | 21.1964 | 21.1964 | 2800.0 |
| 2012-07-03 04:17:00 | AAPL | Stock | 21.1964 | 21.1964 | 21.1964 | 21.1964 | 2800.0 |
| 2012-07-03 04:20:00 | AAPL | Stock | 21.2071 | 21.2071 | 21.2071 | 21.2071 | 5600.0 |
| 2012-07-03 04:21:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 4200.0 |
| 2012-07-03 04:24:00 | AAPL | Stock | 21.2071 | 21.2071 | 21.2071 | 21.2071 | 5600.0 |
| 2012-07-03 04:36:00 | AAPL | Stock | 21.2054 | 21.2054 | 21.2054 | 21.2054 | 2800.0 |
| 2012-07-03 04:40:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 2800.0 |
| 2012-07-03 04:47:00 | AAPL | Stock | 21.2196 | 21.2196 | 21.2196 | 21.2196 | 2800.0 |
| 2012-07-03 04:48:00 | AAPL | Stock | 21.2196 | 21.2196 | 21.2196 | 21.2196 | 19600.0 |
| 2012-07-03 04:49:00 | AAPL | Stock | 21.2196 | 21.2196 | 21.2196 | 21.2196 | 2800.0 |
| 2012-07-03 04:53:00 | AAPL | Stock | 21.2379 | 21.2379 | 21.2379 | 21.2379 | 2800.0 |
| 2012-07-03 04:54:00 | AAPL | Stock | 21.22 | 21.22 | 21.2143 | 21.2143 | 14000.0 |
| 2012-07-03 04:58:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 11200.0 |
| 2012-07-03 05:05:00 | AAPL | Stock | 21.2111 | 21.2111 | 21.2111 | 21.2111 | 2800.0 |
| 2012-07-03 05:08:00 | AAPL | Stock | 21.2357 | 21.2357 | 21.2357 | 21.2357 | 2800.0 |
| 2012-07-03 05:11:00 | AAPL | Stock | 21.2357 | 21.2357 | 21.2357 | 21.2357 | 5600.0 |
| 2012-07-03 05:39:00 | AAPL | Stock | 21.2071 | 21.2071 | 21.2071 | 21.2071 | 2800.0 |
| 2012-07-03 06:00:00 | AAPL | Stock | 21.2214 | 21.2214 | 21.2214 | 21.2214 | 5600.0 |
| 2012-07-03 06:06:00 | AAPL | Stock | 21.2089 | 21.2089 | 21.2089 | 21.2089 | 2800.0 |
| 2012-07-03 06:30:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 28000.0 |
| 2012-07-03 06:33:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 2800.0 |
| 2012-07-03 06:34:00 | AAPL | Stock | 21.2107 | 21.2107 | 21.2107 | 21.2107 | 6020.0 |
| 2012-07-03 06:39:00 | AAPL | Stock | 21.2089 | 21.2089 | 21.2089 | 21.2089 | 2800.0 |
| 2012-07-03 06:54:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 2800.0 |
| 2012-07-03 07:00:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 2800.0 |
| 2012-07-03 07:07:00 | AAPL | Stock | 21.2161 | 21.2214 | 21.2114 | 21.2114 | 14000.0 |
| 2012-07-03 07:11:00 | AAPL | Stock | 21.2193 | 21.2193 | 21.2193 | 21.2193 | 2800.0 |
| 2012-07-03 07:12:00 | AAPL | Stock | 21.2229 | 21.2232 | 21.2229 | 21.2232 | 14000.0 |
| 2012-07-03 07:13:00 | AAPL | Stock | 21.2182 | 21.2182 | 21.2179 | 21.2179 | 14000.0 |
| 2012-07-03 07:15:00 | AAPL | Stock | 21.2179 | 21.2179 | 21.2179 | 21.2179 | 2800.0 |
| 2012-07-03 07:21:00 | AAPL | Stock | 21.2179 | 21.2179 | 21.2179 | 21.2179 | 2800.0 |
| 2012-07-03 07:22:00 | AAPL | Stock | 21.2179 | 21.2179 | 21.2179 | 21.2179 | 4200.0 |
| 2012-07-03 07:24:00 | AAPL | Stock | 21.2107 | 21.2118 | 21.21 | 21.2118 | 8400.0 |
| 2012-07-03 07:25:00 | AAPL | Stock | 21.2061 | 21.2071 | 21.2054 | 21.2071 | 11200.0 |
| 2012-07-03 07:26:00 | AAPL | Stock | 21.2071 | 21.2071 | 21.2071 | 21.2071 | 7000.0 |
| 2012-07-03 07:30:00 | AAPL | Stock | 21.2004 | 21.2004 | 21.1964 | 21.1964 | 14000.0 |
| 2012-07-03 07:31:00 | AAPL | Stock | 21.1882 | 21.1882 | 21.1857 | 21.1857 | 8400.0 |
| 2012-07-03 07:32:00 | AAPL | Stock | 21.1879 | 21.1882 | 21.1861 | 21.1861 | 11200.0 |
| 2012-07-03 07:33:00 | AAPL | Stock | 21.1964 | 21.1989 | 21.1964 | 21.1989 | 9408.0 |
| 2012-07-03 07:34:00 | AAPL | Stock | 21.2036 | 21.2036 | 21.2036 | 21.2036 | 5600.0 |
| 2012-07-03 07:48:00 | AAPL | Stock | 21.2071 | 21.2168 | 21.2071 | 21.2168 | 37324.0 |
| 2012-07-03 07:49:00 | AAPL | Stock | 21.2139 | 21.2139 | 21.2139 | 21.2139 | 2800.0 |
| 2012-07-03 07:51:00 | AAPL | Stock | 21.2225 | 21.2225 | 21.2225 | 21.2225 | 2800.0 |
| 2012-07-03 07:52:00 | AAPL | Stock | 21.2225 | 21.2225 | 21.2179 | 21.2179 | 5600.0 |
| 2012-07-03 07:53:00 | AAPL | Stock | 21.2232 | 21.2264 | 21.215 | 21.2264 | 39200.0 |
| 2012-07-03 07:54:00 | AAPL | Stock | 21.2286 | 21.2321 | 21.2286 | 21.2321 | 14000.0 |
| 2012-07-03 07:55:00 | AAPL | Stock | 21.2321 | 21.2346 | 21.2321 | 21.2346 | 14000.0 |
> showing 50 of 554,592 rows — these rows as CSV