PREVIEW / stock_1min / 2014-05-15
file: by_date/stock_1min/2014/2014-05-15.parquet size: 14.9 MB rows: 1,087,378 symbols: 2,871
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-05-15 05:44:00 | AAPL | Stock | 21.1804 | 21.1804 | 21.1804 | 21.1804 | 2800.0 |
| 2014-05-15 07:00:00 | AAPL | Stock | 21.1964 | 21.2004 | 21.1964 | 21.2004 | 11200.0 |
| 2014-05-15 07:09:00 | AAPL | Stock | 21.2036 | 21.2036 | 21.2036 | 21.2036 | 14000.0 |
| 2014-05-15 07:10:00 | AAPL | Stock | 21.2036 | 21.2111 | 21.2036 | 21.2111 | 22400.0 |
| 2014-05-15 07:16:00 | AAPL | Stock | 21.2036 | 21.2036 | 21.2036 | 21.2036 | 2800.0 |
| 2014-05-15 07:19:00 | AAPL | Stock | 21.2036 | 21.2036 | 21.2036 | 21.2036 | 2800.0 |
| 2014-05-15 07:23:00 | AAPL | Stock | 21.2036 | 21.2139 | 21.2036 | 21.2139 | 22288.0 |
| 2014-05-15 07:35:00 | AAPL | Stock | 21.2029 | 21.2029 | 21.2018 | 21.2018 | 5600.0 |
| 2014-05-15 07:44:00 | AAPL | Stock | 21.1804 | 21.1804 | 21.1804 | 21.1804 | 2800.0 |
| 2014-05-15 08:00:00 | AAPL | Stock | 21.1829 | 21.2029 | 21.1796 | 21.1996 | 42084.0 |
| 2014-05-15 08:02:00 | AAPL | Stock | 21.1811 | 21.1843 | 21.1796 | 21.1796 | 17360.0 |
| 2014-05-15 08:03:00 | AAPL | Stock | 21.1789 | 21.1789 | 21.1768 | 21.1768 | 19600.0 |
| 2014-05-15 08:08:00 | AAPL | Stock | 21.1986 | 21.1986 | 21.1986 | 21.1986 | 2800.0 |
| 2014-05-15 08:20:00 | AAPL | Stock | 21.1893 | 21.1893 | 21.1893 | 21.1893 | 2800.0 |
| 2014-05-15 08:27:00 | AAPL | Stock | 21.1964 | 21.1964 | 21.1964 | 21.1964 | 2800.0 |
| 2014-05-15 08:30:00 | AAPL | Stock | 21.1996 | 21.2011 | 21.1993 | 21.2011 | 44128.0 |
| 2014-05-15 08:32:00 | AAPL | Stock | 21.21 | 21.2136 | 21.21 | 21.2104 | 44184.0 |
| 2014-05-15 08:33:00 | AAPL | Stock | 21.2104 | 21.2189 | 21.2036 | 21.2104 | 99960.0 |
| 2014-05-15 08:34:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 2800.0 |
| 2014-05-15 08:36:00 | AAPL | Stock | 21.215 | 21.215 | 21.215 | 21.215 | 2800.0 |
| 2014-05-15 08:39:00 | AAPL | Stock | 21.2232 | 21.2232 | 21.2232 | 21.2232 | 2800.0 |
| 2014-05-15 08:40:00 | AAPL | Stock | 21.2246 | 21.2286 | 21.2239 | 21.2286 | 67004.0 |
| 2014-05-15 08:42:00 | AAPL | Stock | 21.2364 | 21.2364 | 21.2321 | 21.2321 | 44800.0 |
| 2014-05-15 08:43:00 | AAPL | Stock | 21.2321 | 21.2321 | 21.2321 | 21.2321 | 8400.0 |
| 2014-05-15 08:44:00 | AAPL | Stock | 21.2439 | 21.2482 | 21.2268 | 21.2268 | 39200.0 |
| 2014-05-15 08:45:00 | AAPL | Stock | 21.2293 | 21.2432 | 21.2236 | 21.2432 | 16800.0 |
| 2014-05-15 08:47:00 | AAPL | Stock | 21.2304 | 21.2304 | 21.2257 | 21.2257 | 14000.0 |
| 2014-05-15 08:51:00 | AAPL | Stock | 21.2232 | 21.2232 | 21.2232 | 21.2232 | 2800.0 |
| 2014-05-15 08:56:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 11900.0 |
| 2014-05-15 09:01:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 4704.0 |
| 2014-05-15 09:02:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 8400.0 |
| 2014-05-15 09:04:00 | AAPL | Stock | 21.2139 | 21.2139 | 21.2139 | 21.2139 | 14000.0 |
| 2014-05-15 09:08:00 | AAPL | Stock | 21.2139 | 21.2179 | 21.2139 | 21.2143 | 72016.0 |
| 2014-05-15 09:09:00 | AAPL | Stock | 21.2143 | 21.2175 | 21.2143 | 21.2175 | 19600.0 |
| 2014-05-15 09:10:00 | AAPL | Stock | 21.2175 | 21.2179 | 21.2171 | 21.2179 | 16800.0 |
| 2014-05-15 09:11:00 | AAPL | Stock | 21.2179 | 21.2179 | 21.2179 | 21.2179 | 2800.0 |
| 2014-05-15 09:12:00 | AAPL | Stock | 21.2171 | 21.2171 | 21.2171 | 21.2171 | 2800.0 |
| 2014-05-15 09:13:00 | AAPL | Stock | 21.2146 | 21.2146 | 21.2146 | 21.2146 | 5600.0 |
| 2014-05-15 09:15:00 | AAPL | Stock | 21.215 | 21.215 | 21.215 | 21.215 | 4340.0 |
| 2014-05-15 09:16:00 | AAPL | Stock | 21.2218 | 21.2218 | 21.2218 | 21.2218 | 8400.0 |
| 2014-05-15 09:17:00 | AAPL | Stock | 21.2171 | 21.2171 | 21.2171 | 21.2171 | 2800.0 |
| 2014-05-15 09:18:00 | AAPL | Stock | 21.2179 | 21.2179 | 21.2179 | 21.2179 | 5600.0 |
| 2014-05-15 09:19:00 | AAPL | Stock | 21.2182 | 21.2182 | 21.2182 | 21.2182 | 8400.0 |
| 2014-05-15 09:21:00 | AAPL | Stock | 21.2161 | 21.2161 | 21.2039 | 21.2039 | 8400.0 |
| 2014-05-15 09:24:00 | AAPL | Stock | 21.2171 | 21.2179 | 21.2171 | 21.2179 | 5600.0 |
| 2014-05-15 09:27:00 | AAPL | Stock | 21.2071 | 21.2071 | 21.2071 | 21.2071 | 6720.0 |
| 2014-05-15 09:28:00 | AAPL | Stock | 21.2214 | 21.2382 | 21.2196 | 21.2343 | 144620.0 |
| 2014-05-15 09:29:00 | AAPL | Stock | 21.2375 | 21.2468 | 21.2289 | 21.2289 | 47152.0 |
| 2014-05-15 09:30:00 | AAPL | Stock | 21.2354 | 21.2536 | 21.2232 | 21.2425 | 3454808.0 |
| 2014-05-15 09:31:00 | AAPL | Stock | 21.2393 | 21.2943 | 21.2393 | 21.2814 | 2474976.0 |
> showing 50 of 1,087,378 rows — these rows as CSV