PREVIEW / stock_1min / 2014-03-25
file: by_date/stock_1min/2014/2014-03-25.parquet size: 14.7 MB rows: 1,067,913 symbols: 2,855
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-03-25 04:11:00 | AAPL | Stock | 19.2857 | 19.2857 | 19.2857 | 19.2857 | 2800.0 |
| 2014-03-25 04:40:00 | AAPL | Stock | 19.3039 | 19.3039 | 19.3039 | 19.3039 | 2800.0 |
| 2014-03-25 05:17:00 | AAPL | Stock | 19.2857 | 19.2857 | 19.2857 | 19.2857 | 2800.0 |
| 2014-03-25 06:00:00 | AAPL | Stock | 19.3021 | 19.3021 | 19.3021 | 19.3021 | 2800.0 |
| 2014-03-25 06:39:00 | AAPL | Stock | 19.3136 | 19.3136 | 19.3136 | 19.3136 | 8400.0 |
| 2014-03-25 06:44:00 | AAPL | Stock | 19.3029 | 19.3029 | 19.3029 | 19.3029 | 14000.0 |
| 2014-03-25 06:56:00 | AAPL | Stock | 19.2929 | 19.2929 | 19.2786 | 19.2786 | 14056.0 |
| 2014-03-25 07:02:00 | AAPL | Stock | 19.2804 | 19.2818 | 19.2804 | 19.2818 | 10920.0 |
| 2014-03-25 07:10:00 | AAPL | Stock | 19.2804 | 19.2839 | 19.2804 | 19.2804 | 26180.0 |
| 2014-03-25 07:14:00 | AAPL | Stock | 19.2829 | 19.2829 | 19.2829 | 19.2829 | 2800.0 |
| 2014-03-25 07:24:00 | AAPL | Stock | 19.2804 | 19.2804 | 19.2804 | 19.2804 | 4984.0 |
| 2014-03-25 07:25:00 | AAPL | Stock | 19.2943 | 19.2943 | 19.2943 | 19.2943 | 7840.0 |
| 2014-03-25 07:27:00 | AAPL | Stock | 19.2882 | 19.2943 | 19.2882 | 19.2943 | 16800.0 |
| 2014-03-25 07:28:00 | AAPL | Stock | 19.3018 | 19.3082 | 19.3018 | 19.3082 | 25200.0 |
| 2014-03-25 07:37:00 | AAPL | Stock | 19.3079 | 19.3104 | 19.3079 | 19.3104 | 12460.0 |
| 2014-03-25 07:38:00 | AAPL | Stock | 19.3125 | 19.3125 | 19.3036 | 19.3036 | 5600.0 |
| 2014-03-25 07:39:00 | AAPL | Stock | 19.3079 | 19.3079 | 19.3079 | 19.3079 | 2800.0 |
| 2014-03-25 07:40:00 | AAPL | Stock | 19.3182 | 19.3182 | 19.3182 | 19.3182 | 2800.0 |
| 2014-03-25 07:43:00 | AAPL | Stock | 19.3161 | 19.3161 | 19.3071 | 19.3071 | 8400.0 |
| 2014-03-25 07:52:00 | AAPL | Stock | 19.3054 | 19.3143 | 19.3054 | 19.3143 | 47600.0 |
| 2014-03-25 07:53:00 | AAPL | Stock | 19.3204 | 19.3282 | 19.3204 | 19.3282 | 20300.0 |
| 2014-03-25 07:54:00 | AAPL | Stock | 19.325 | 19.3304 | 19.325 | 19.3304 | 8400.0 |
| 2014-03-25 07:55:00 | AAPL | Stock | 19.3311 | 19.3411 | 19.3311 | 19.3411 | 121100.0 |
| 2014-03-25 07:56:00 | AAPL | Stock | 19.35 | 19.35 | 19.3429 | 19.3429 | 8400.0 |
| 2014-03-25 07:58:00 | AAPL | Stock | 19.3393 | 19.3393 | 19.3393 | 19.3393 | 8400.0 |
| 2014-03-25 07:59:00 | AAPL | Stock | 19.3343 | 19.3343 | 19.3343 | 19.3343 | 8120.0 |
| 2014-03-25 08:00:00 | AAPL | Stock | 19.3304 | 19.3304 | 19.2804 | 19.3207 | 46088.0 |
| 2014-03-25 08:01:00 | AAPL | Stock | 19.3261 | 19.3271 | 19.3261 | 19.3264 | 14000.0 |
| 2014-03-25 08:02:00 | AAPL | Stock | 19.3246 | 19.3246 | 19.3246 | 19.3246 | 3220.0 |
| 2014-03-25 08:03:00 | AAPL | Stock | 19.3232 | 19.3271 | 19.3214 | 19.3271 | 14000.0 |
| 2014-03-25 08:04:00 | AAPL | Stock | 19.3286 | 19.3286 | 19.3221 | 19.3221 | 12348.0 |
| 2014-03-25 08:05:00 | AAPL | Stock | 19.33 | 19.33 | 19.3271 | 19.3271 | 8400.0 |
| 2014-03-25 08:06:00 | AAPL | Stock | 19.3236 | 19.3236 | 19.3189 | 19.3189 | 24276.0 |
| 2014-03-25 08:07:00 | AAPL | Stock | 19.3246 | 19.3246 | 19.3246 | 19.3246 | 2800.0 |
| 2014-03-25 08:08:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3214 | 19.3214 | 8400.0 |
| 2014-03-25 08:09:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3068 | 19.3068 | 64148.0 |
| 2014-03-25 08:10:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.3036 | 19.3036 | 7644.0 |
| 2014-03-25 08:11:00 | AAPL | Stock | 19.3125 | 19.3125 | 19.3125 | 19.3125 | 2800.0 |
| 2014-03-25 08:13:00 | AAPL | Stock | 19.3043 | 19.3043 | 19.2946 | 19.2946 | 30800.0 |
| 2014-03-25 08:14:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.3036 | 19.3036 | 15400.0 |
| 2014-03-25 08:15:00 | AAPL | Stock | 19.3107 | 19.3107 | 19.3107 | 19.3107 | 5600.0 |
| 2014-03-25 08:16:00 | AAPL | Stock | 19.3036 | 19.3071 | 19.3036 | 19.3071 | 5600.0 |
| 2014-03-25 08:17:00 | AAPL | Stock | 19.3071 | 19.3071 | 19.3071 | 19.3071 | 11200.0 |
| 2014-03-25 08:18:00 | AAPL | Stock | 19.3046 | 19.3046 | 19.3036 | 19.3036 | 31108.0 |
| 2014-03-25 08:21:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.3036 | 19.3036 | 2800.0 |
| 2014-03-25 08:22:00 | AAPL | Stock | 19.2946 | 19.2946 | 19.2946 | 19.2946 | 8400.0 |
| 2014-03-25 08:24:00 | AAPL | Stock | 19.2946 | 19.3004 | 19.2611 | 19.2611 | 135744.0 |
| 2014-03-25 08:25:00 | AAPL | Stock | 19.2836 | 19.2836 | 19.2829 | 19.2829 | 5600.0 |
| 2014-03-25 08:26:00 | AAPL | Stock | 19.2825 | 19.2857 | 19.2825 | 19.2857 | 5600.0 |
| 2014-03-25 08:27:00 | AAPL | Stock | 19.285 | 19.285 | 19.285 | 19.285 | 2800.0 |
> showing 50 of 1,067,913 rows — these rows as CSV