PREVIEW / stock_1min / 2014-05-19
file: by_date/stock_1min/2014/2014-05-19.parquet size: 13.8 MB rows: 1,019,952 symbols: 2,884
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-19 04:00:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 8400.0 |
| 2014-05-19 04:05:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 100800.0 |
| 2014-05-19 04:06:00 | AAPL | Stock | 21.2536 | 21.2536 | 21.2536 | 21.2536 | 2800.0 |
| 2014-05-19 04:34:00 | AAPL | Stock | 21.2579 | 21.2579 | 21.2579 | 21.2579 | 2800.0 |
| 2014-05-19 04:41:00 | AAPL | Stock | 21.2679 | 21.2679 | 21.2679 | 21.2679 | 2800.0 |
| 2014-05-19 04:54:00 | AAPL | Stock | 21.2514 | 21.2514 | 21.25 | 21.25 | 5600.0 |
| 2014-05-19 05:14:00 | AAPL | Stock | 21.2539 | 21.2539 | 21.2539 | 21.2539 | 2800.0 |
| 2014-05-19 05:30:00 | AAPL | Stock | 21.2579 | 21.2579 | 21.2571 | 21.2571 | 11200.0 |
| 2014-05-19 05:44:00 | AAPL | Stock | 21.2593 | 21.2593 | 21.2593 | 21.2593 | 2800.0 |
| 2014-05-19 05:50:00 | AAPL | Stock | 21.2604 | 21.2604 | 21.2604 | 21.2604 | 2800.0 |
| 2014-05-19 05:53:00 | AAPL | Stock | 21.2529 | 21.2529 | 21.2489 | 21.2489 | 22400.0 |
| 2014-05-19 05:57:00 | AAPL | Stock | 21.265 | 21.2657 | 21.265 | 21.2657 | 5600.0 |
| 2014-05-19 06:04:00 | AAPL | Stock | 21.2657 | 21.2657 | 21.2657 | 21.2657 | 10304.0 |
| 2014-05-19 06:06:00 | AAPL | Stock | 21.2589 | 21.2589 | 21.2589 | 21.2589 | 5600.0 |
| 2014-05-19 06:30:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 2800.0 |
| 2014-05-19 06:34:00 | AAPL | Stock | 21.2921 | 21.2925 | 21.2921 | 21.2925 | 5600.0 |
| 2014-05-19 06:46:00 | AAPL | Stock | 21.2971 | 21.2971 | 21.2971 | 21.2971 | 2800.0 |
| 2014-05-19 06:48:00 | AAPL | Stock | 21.2964 | 21.3 | 21.2886 | 21.2886 | 29596.0 |
| 2014-05-19 06:54:00 | AAPL | Stock | 21.2886 | 21.2886 | 21.2864 | 21.2864 | 22400.0 |
| 2014-05-19 07:00:00 | AAPL | Stock | 21.2864 | 21.2886 | 21.2864 | 21.2886 | 28000.0 |
| 2014-05-19 07:01:00 | AAPL | Stock | 21.2886 | 21.2886 | 21.2821 | 21.2821 | 16464.0 |
| 2014-05-19 07:02:00 | AAPL | Stock | 21.2889 | 21.2889 | 21.2889 | 21.2889 | 8400.0 |
| 2014-05-19 07:05:00 | AAPL | Stock | 21.2889 | 21.2889 | 21.2889 | 21.2889 | 5600.0 |
| 2014-05-19 07:06:00 | AAPL | Stock | 21.2932 | 21.2932 | 21.2932 | 21.2932 | 2800.0 |
| 2014-05-19 07:07:00 | AAPL | Stock | 21.2943 | 21.2943 | 21.2943 | 21.2943 | 2800.0 |
| 2014-05-19 07:08:00 | AAPL | Stock | 21.2929 | 21.2929 | 21.2929 | 21.2929 | 27440.0 |
| 2014-05-19 07:13:00 | AAPL | Stock | 21.2964 | 21.3007 | 21.2964 | 21.3007 | 19600.0 |
| 2014-05-19 07:14:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 2800.0 |
| 2014-05-19 07:17:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 5600.0 |
| 2014-05-19 07:18:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 2800.0 |
| 2014-05-19 07:27:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 17976.0 |
| 2014-05-19 07:28:00 | AAPL | Stock | 21.3114 | 21.3125 | 21.3114 | 21.3125 | 5600.0 |
| 2014-05-19 07:29:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 8400.0 |
| 2014-05-19 07:31:00 | AAPL | Stock | 21.3036 | 21.3107 | 21.3036 | 21.3107 | 25900.0 |
| 2014-05-19 07:32:00 | AAPL | Stock | 21.3111 | 21.3143 | 21.3111 | 21.3143 | 22400.0 |
| 2014-05-19 07:41:00 | AAPL | Stock | 21.3136 | 21.3136 | 21.3136 | 21.3136 | 2800.0 |
| 2014-05-19 07:42:00 | AAPL | Stock | 21.3143 | 21.3143 | 21.3143 | 21.3143 | 13300.0 |
| 2014-05-19 07:43:00 | AAPL | Stock | 21.3171 | 21.3464 | 21.3171 | 21.3464 | 29400.0 |
| 2014-05-19 07:44:00 | AAPL | Stock | 21.3289 | 21.3289 | 21.325 | 21.3268 | 30800.0 |
| 2014-05-19 07:48:00 | AAPL | Stock | 21.3286 | 21.3286 | 21.3268 | 21.3268 | 7000.0 |
| 2014-05-19 07:49:00 | AAPL | Stock | 21.3304 | 21.3304 | 21.3293 | 21.3304 | 20720.0 |
| 2014-05-19 07:51:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3196 | 21.3196 | 8400.0 |
| 2014-05-19 07:55:00 | AAPL | Stock | 21.3168 | 21.3182 | 21.3168 | 21.3179 | 16800.0 |
| 2014-05-19 07:56:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3214 | 21.3214 | 22232.0 |
| 2014-05-19 08:00:00 | AAPL | Stock | 21.3293 | 21.3293 | 21.2889 | 21.3179 | 101416.0 |
| 2014-05-19 08:01:00 | AAPL | Stock | 21.3136 | 21.3136 | 21.3136 | 21.3136 | 2800.0 |
| 2014-05-19 08:02:00 | AAPL | Stock | 21.3146 | 21.3161 | 21.3146 | 21.3161 | 29400.0 |
| 2014-05-19 08:03:00 | AAPL | Stock | 21.3261 | 21.3261 | 21.3261 | 21.3261 | 8400.0 |
| 2014-05-19 08:04:00 | AAPL | Stock | 21.3179 | 21.3179 | 21.3179 | 21.3179 | 11200.0 |
| 2014-05-19 08:05:00 | AAPL | Stock | 21.3179 | 21.3179 | 21.3161 | 21.3161 | 32200.0 |
> showing 50 of 1,019,952 rows — these rows as CSV