PREVIEW / stock_1min / 2013-02-07
file: by_date/stock_1min/2013/2013-02-07.parquet size: 12.9 MB rows: 953,376 symbols: 2,815
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-07 04:54:00 | AAPL | Stock | 16.2964 | 16.2964 | 16.2964 | 16.2964 | 13944.0 |
| 2013-02-07 05:08:00 | AAPL | Stock | 16.2957 | 16.2961 | 16.2957 | 16.2961 | 11760.0 |
| 2013-02-07 05:09:00 | AAPL | Stock | 16.2982 | 16.2982 | 16.2982 | 16.2982 | 2800.0 |
| 2013-02-07 06:41:00 | AAPL | Stock | 16.3296 | 16.33 | 16.3296 | 16.33 | 25760.0 |
| 2013-02-07 06:56:00 | AAPL | Stock | 16.2886 | 16.2886 | 16.2857 | 16.2857 | 11200.0 |
| 2013-02-07 06:58:00 | AAPL | Stock | 16.3286 | 16.3286 | 16.3286 | 16.3286 | 8400.0 |
| 2013-02-07 07:01:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.2857 | 16.2857 | 10892.0 |
| 2013-02-07 07:04:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 2800.0 |
| 2013-02-07 07:07:00 | AAPL | Stock | 16.28 | 16.28 | 16.28 | 16.28 | 2800.0 |
| 2013-02-07 07:08:00 | AAPL | Stock | 16.2729 | 16.2729 | 16.2729 | 16.2729 | 5600.0 |
| 2013-02-07 07:13:00 | AAPL | Stock | 16.2743 | 16.2743 | 16.2743 | 16.2743 | 5600.0 |
| 2013-02-07 07:15:00 | AAPL | Stock | 16.2779 | 16.2779 | 16.2779 | 16.2779 | 2800.0 |
| 2013-02-07 07:22:00 | AAPL | Stock | 16.2643 | 16.2643 | 16.2643 | 16.2643 | 5180.0 |
| 2013-02-07 07:24:00 | AAPL | Stock | 16.2643 | 16.2643 | 16.2643 | 16.2643 | 2800.0 |
| 2013-02-07 07:37:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2521 | 16.2521 | 31192.0 |
| 2013-02-07 07:38:00 | AAPL | Stock | 16.2675 | 16.2679 | 16.2675 | 16.2679 | 21336.0 |
| 2013-02-07 07:40:00 | AAPL | Stock | 16.2518 | 16.2518 | 16.25 | 16.25 | 14084.0 |
| 2013-02-07 07:46:00 | AAPL | Stock | 16.2664 | 16.2664 | 16.2664 | 16.2664 | 2800.0 |
| 2013-02-07 07:47:00 | AAPL | Stock | 16.2632 | 16.2679 | 16.2632 | 16.2679 | 19124.0 |
| 2013-02-07 07:48:00 | AAPL | Stock | 16.255 | 16.2571 | 16.2536 | 16.2536 | 19600.0 |
| 2013-02-07 07:50:00 | AAPL | Stock | 16.2571 | 16.2571 | 16.2571 | 16.2571 | 2800.0 |
| 2013-02-07 07:52:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 5516.0 |
| 2013-02-07 07:54:00 | AAPL | Stock | 16.2504 | 16.2504 | 16.2504 | 16.2504 | 5600.0 |
| 2013-02-07 07:55:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 7000.0 |
| 2013-02-07 07:59:00 | AAPL | Stock | 16.2457 | 16.2457 | 16.2411 | 16.2411 | 5600.0 |
| 2013-02-07 08:00:00 | AAPL | Stock | 16.2493 | 16.2896 | 16.2454 | 16.2521 | 125636.0 |
| 2013-02-07 08:01:00 | AAPL | Stock | 16.2521 | 16.2525 | 16.2464 | 16.2464 | 98056.0 |
| 2013-02-07 08:02:00 | AAPL | Stock | 16.2396 | 16.245 | 16.2396 | 16.245 | 36400.0 |
| 2013-02-07 08:03:00 | AAPL | Stock | 16.2393 | 16.245 | 16.2321 | 16.2321 | 42140.0 |
| 2013-02-07 08:04:00 | AAPL | Stock | 16.2364 | 16.2364 | 16.2357 | 16.2357 | 14000.0 |
| 2013-02-07 08:05:00 | AAPL | Stock | 16.2361 | 16.2361 | 16.2286 | 16.2286 | 73164.0 |
| 2013-02-07 08:06:00 | AAPL | Stock | 16.2286 | 16.23 | 16.2168 | 16.2168 | 28000.0 |
| 2013-02-07 08:07:00 | AAPL | Stock | 16.2168 | 16.2186 | 16.2143 | 16.2186 | 11200.0 |
| 2013-02-07 08:08:00 | AAPL | Stock | 16.225 | 16.2257 | 16.2186 | 16.225 | 35140.0 |
| 2013-02-07 08:09:00 | AAPL | Stock | 16.2257 | 16.2339 | 16.2218 | 16.2339 | 35980.0 |
| 2013-02-07 08:10:00 | AAPL | Stock | 16.2339 | 16.2339 | 16.2279 | 16.2304 | 22260.0 |
| 2013-02-07 08:11:00 | AAPL | Stock | 16.2304 | 16.2304 | 16.2232 | 16.2289 | 49924.0 |
| 2013-02-07 08:12:00 | AAPL | Stock | 16.2232 | 16.2232 | 16.2232 | 16.2232 | 3724.0 |
| 2013-02-07 08:13:00 | AAPL | Stock | 16.2232 | 16.2232 | 16.2143 | 16.2143 | 214200.0 |
| 2013-02-07 08:14:00 | AAPL | Stock | 16.2175 | 16.2175 | 16.2161 | 16.2161 | 21392.0 |
| 2013-02-07 08:15:00 | AAPL | Stock | 16.2186 | 16.2286 | 16.2164 | 16.2164 | 45416.0 |
| 2013-02-07 08:16:00 | AAPL | Stock | 16.2168 | 16.2232 | 16.2168 | 16.2214 | 44100.0 |
| 2013-02-07 08:17:00 | AAPL | Stock | 16.2214 | 16.2239 | 16.2214 | 16.2239 | 37800.0 |
| 2013-02-07 08:18:00 | AAPL | Stock | 16.2239 | 16.2239 | 16.2239 | 16.2239 | 4200.0 |
| 2013-02-07 08:19:00 | AAPL | Stock | 16.22 | 16.22 | 16.2196 | 16.2196 | 39480.0 |
| 2013-02-07 08:20:00 | AAPL | Stock | 16.2146 | 16.2179 | 16.1964 | 16.1964 | 85400.0 |
| 2013-02-07 08:21:00 | AAPL | Stock | 16.2036 | 16.2054 | 16.2036 | 16.2054 | 11200.0 |
| 2013-02-07 08:22:00 | AAPL | Stock | 16.2136 | 16.2143 | 16.2136 | 16.2143 | 30800.0 |
| 2013-02-07 08:23:00 | AAPL | Stock | 16.2143 | 16.2196 | 16.2139 | 16.2196 | 20020.0 |
| 2013-02-07 08:24:00 | AAPL | Stock | 16.2071 | 16.2136 | 16.2071 | 16.2136 | 12600.0 |
> showing 50 of 953,376 rows — these rows as CSV