PREVIEW / stock_1min / 2014-05-07
file: by_date/stock_1min/2014/2014-05-07.parquet size: 15.3 MB rows: 1,108,892 symbols: 2,878
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-07 04:19:00 | AAPL | Stock | 21.2368 | 21.2368 | 21.2368 | 21.2368 | 2800.0 |
| 2014-05-07 06:36:00 | AAPL | Stock | 21.275 | 21.275 | 21.275 | 21.275 | 2800.0 |
| 2014-05-07 06:42:00 | AAPL | Stock | 21.2593 | 21.2593 | 21.2593 | 21.2593 | 2800.0 |
| 2014-05-07 06:43:00 | AAPL | Stock | 21.2589 | 21.2589 | 21.2589 | 21.2589 | 5600.0 |
| 2014-05-07 07:01:00 | AAPL | Stock | 21.2654 | 21.3161 | 21.2654 | 21.3161 | 30800.0 |
| 2014-05-07 07:11:00 | AAPL | Stock | 21.2989 | 21.3036 | 21.2989 | 21.3036 | 25312.0 |
| 2014-05-07 07:17:00 | AAPL | Stock | 21.2982 | 21.3 | 21.2982 | 21.3 | 6160.0 |
| 2014-05-07 07:19:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 7504.0 |
| 2014-05-07 07:21:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 2800.0 |
| 2014-05-07 07:23:00 | AAPL | Stock | 21.3036 | 21.3118 | 21.3036 | 21.3118 | 8400.0 |
| 2014-05-07 07:24:00 | AAPL | Stock | 21.3004 | 21.3004 | 21.2929 | 21.2929 | 5600.0 |
| 2014-05-07 07:29:00 | AAPL | Stock | 21.3114 | 21.3114 | 21.3114 | 21.3114 | 2800.0 |
| 2014-05-07 07:39:00 | AAPL | Stock | 21.2939 | 21.2939 | 21.2929 | 21.2929 | 5600.0 |
| 2014-05-07 07:45:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 6720.0 |
| 2014-05-07 07:46:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 14000.0 |
| 2014-05-07 07:47:00 | AAPL | Stock | 21.3011 | 21.3036 | 21.2946 | 21.2946 | 50400.0 |
| 2014-05-07 07:48:00 | AAPL | Stock | 21.2929 | 21.2929 | 21.2857 | 21.2857 | 16520.0 |
| 2014-05-07 07:49:00 | AAPL | Stock | 21.3014 | 21.3018 | 21.3014 | 21.3018 | 5600.0 |
| 2014-05-07 07:53:00 | AAPL | Stock | 21.3032 | 21.31 | 21.3032 | 21.31 | 15848.0 |
| 2014-05-07 07:59:00 | AAPL | Stock | 21.2996 | 21.2996 | 21.2996 | 21.2996 | 2800.0 |
| 2014-05-07 08:00:00 | AAPL | Stock | 21.2946 | 21.3032 | 21.2871 | 21.3021 | 73640.0 |
| 2014-05-07 08:01:00 | AAPL | Stock | 21.2964 | 21.3004 | 21.1786 | 21.1786 | 93800.0 |
| 2014-05-07 08:02:00 | AAPL | Stock | 21.2871 | 21.2871 | 21.2864 | 21.2864 | 8400.0 |
| 2014-05-07 08:03:00 | AAPL | Stock | 21.2936 | 21.2946 | 21.2936 | 21.2946 | 25200.0 |
| 2014-05-07 08:04:00 | AAPL | Stock | 21.2943 | 21.2961 | 21.2943 | 21.2961 | 16800.0 |
| 2014-05-07 08:06:00 | AAPL | Stock | 21.2879 | 21.2886 | 21.2879 | 21.2886 | 5600.0 |
| 2014-05-07 08:07:00 | AAPL | Stock | 21.2957 | 21.3054 | 21.2886 | 21.3029 | 70000.0 |
| 2014-05-07 08:10:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 3920.0 |
| 2014-05-07 08:11:00 | AAPL | Stock | 21.3036 | 21.31 | 21.3036 | 21.31 | 18620.0 |
| 2014-05-07 08:12:00 | AAPL | Stock | 21.3046 | 21.3046 | 21.3036 | 21.3043 | 14000.0 |
| 2014-05-07 08:13:00 | AAPL | Stock | 21.3125 | 21.3125 | 21.3125 | 21.3125 | 2800.0 |
| 2014-05-07 08:14:00 | AAPL | Stock | 21.3107 | 21.3143 | 21.3107 | 21.3143 | 29540.0 |
| 2014-05-07 08:15:00 | AAPL | Stock | 21.3143 | 21.3286 | 21.3143 | 21.3286 | 150444.0 |
| 2014-05-07 08:16:00 | AAPL | Stock | 21.3282 | 21.3304 | 21.3282 | 21.3304 | 14000.0 |
| 2014-05-07 08:17:00 | AAPL | Stock | 21.3375 | 21.3375 | 21.3375 | 21.3375 | 16800.0 |
| 2014-05-07 08:19:00 | AAPL | Stock | 21.3396 | 21.3396 | 21.3396 | 21.3396 | 2800.0 |
| 2014-05-07 08:20:00 | AAPL | Stock | 21.3304 | 21.3304 | 21.3304 | 21.3304 | 48860.0 |
| 2014-05-07 08:21:00 | AAPL | Stock | 21.3304 | 21.3318 | 21.3282 | 21.3282 | 69776.0 |
| 2014-05-07 08:22:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3214 | 21.3214 | 5600.0 |
| 2014-05-07 08:23:00 | AAPL | Stock | 21.3211 | 21.3211 | 21.3211 | 21.3211 | 11088.0 |
| 2014-05-07 08:24:00 | AAPL | Stock | 21.3196 | 21.3343 | 21.3196 | 21.3343 | 140868.0 |
| 2014-05-07 08:25:00 | AAPL | Stock | 21.3146 | 21.3146 | 21.3146 | 21.3146 | 5600.0 |
| 2014-05-07 08:26:00 | AAPL | Stock | 21.3368 | 21.3368 | 21.3368 | 21.3368 | 2800.0 |
| 2014-05-07 08:27:00 | AAPL | Stock | 21.3354 | 21.3354 | 21.3329 | 21.3329 | 11200.0 |
| 2014-05-07 08:28:00 | AAPL | Stock | 21.3357 | 21.3454 | 21.3357 | 21.3404 | 87808.0 |
| 2014-05-07 08:29:00 | AAPL | Stock | 21.3393 | 21.3393 | 21.3393 | 21.3393 | 16240.0 |
| 2014-05-07 08:30:00 | AAPL | Stock | 21.3393 | 21.3393 | 21.3393 | 21.3393 | 5600.0 |
| 2014-05-07 08:32:00 | AAPL | Stock | 21.3389 | 21.3411 | 21.3389 | 21.3389 | 30800.0 |
| 2014-05-07 08:33:00 | AAPL | Stock | 21.3429 | 21.3429 | 21.3429 | 21.3429 | 4200.0 |
| 2014-05-07 08:35:00 | AAPL | Stock | 21.3479 | 21.3479 | 21.335 | 21.335 | 11200.0 |
> showing 50 of 1,108,892 rows — these rows as CSV