PREVIEW / stock_5min / 2012-05-29
file: by_date/stock_5min/2012/2012-05-29.parquet size: 4.8 MB rows: 325,832 symbols: 3,528
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-29 04:00:00 | AAPL | Stock | 20.29 | 20.29 | 20.29 | 20.29 | 5600.0 |
| 2012-05-29 04:15:00 | AAPL | Stock | 20.3304 | 20.3304 | 20.3304 | 20.3304 | 2800.0 |
| 2012-05-29 04:30:00 | AAPL | Stock | 20.33 | 20.3304 | 20.33 | 20.3304 | 19880.0 |
| 2012-05-29 05:35:00 | AAPL | Stock | 20.2929 | 20.2929 | 20.2929 | 20.2929 | 2800.0 |
| 2012-05-29 05:40:00 | AAPL | Stock | 20.2571 | 20.2571 | 20.2571 | 20.2571 | 26600.0 |
| 2012-05-29 05:45:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 2800.0 |
| 2012-05-29 06:10:00 | AAPL | Stock | 20.1857 | 20.1857 | 20.1857 | 20.1857 | 5600.0 |
| 2012-05-29 06:30:00 | AAPL | Stock | 20.2004 | 20.2004 | 20.2004 | 20.2004 | 4620.0 |
| 2012-05-29 07:00:00 | AAPL | Stock | 20.2071 | 20.2321 | 20.2071 | 20.2321 | 22288.0 |
| 2012-05-29 07:05:00 | AAPL | Stock | 20.2321 | 20.2407 | 20.2321 | 20.2407 | 16240.0 |
| 2012-05-29 07:10:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 8372.0 |
| 2012-05-29 07:15:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 7000.0 |
| 2012-05-29 07:20:00 | AAPL | Stock | 20.2211 | 20.2389 | 20.2211 | 20.2329 | 29400.0 |
| 2012-05-29 07:25:00 | AAPL | Stock | 20.2357 | 20.2386 | 20.2357 | 20.2386 | 23800.0 |
| 2012-05-29 07:30:00 | AAPL | Stock | 20.2264 | 20.2321 | 20.2221 | 20.2239 | 42000.0 |
| 2012-05-29 07:35:00 | AAPL | Stock | 20.2346 | 20.2346 | 20.2321 | 20.2321 | 5600.0 |
| 2012-05-29 07:40:00 | AAPL | Stock | 20.2286 | 20.2286 | 20.2239 | 20.2239 | 16800.0 |
| 2012-05-29 07:50:00 | AAPL | Stock | 20.2318 | 20.2464 | 20.2318 | 20.2464 | 92288.0 |
| 2012-05-29 07:55:00 | AAPL | Stock | 20.2482 | 20.2571 | 20.2396 | 20.2489 | 96852.0 |
| 2012-05-29 08:00:00 | AAPL | Stock | 20.2364 | 20.2475 | 20.2179 | 20.2386 | 376656.0 |
| 2012-05-29 08:05:00 | AAPL | Stock | 20.2461 | 20.2568 | 20.2393 | 20.2414 | 150948.0 |
| 2012-05-29 08:10:00 | AAPL | Stock | 20.2375 | 20.2571 | 20.2371 | 20.2557 | 272468.0 |
| 2012-05-29 08:15:00 | AAPL | Stock | 20.2557 | 20.2889 | 20.25 | 20.2857 | 332668.0 |
| 2012-05-29 08:20:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2711 | 20.2718 | 155568.0 |
| 2012-05-29 08:25:00 | AAPL | Stock | 20.2725 | 20.28 | 20.2668 | 20.2668 | 149072.0 |
| 2012-05-29 08:30:00 | AAPL | Stock | 20.2671 | 20.2793 | 20.2671 | 20.2682 | 171976.0 |
| 2012-05-29 08:35:00 | AAPL | Stock | 20.2743 | 20.2743 | 20.2679 | 20.2721 | 43596.0 |
| 2012-05-29 08:40:00 | AAPL | Stock | 20.27 | 20.2857 | 20.27 | 20.2843 | 100800.0 |
| 2012-05-29 08:45:00 | AAPL | Stock | 20.2836 | 20.2836 | 20.2689 | 20.2693 | 74480.0 |
| 2012-05-29 08:50:00 | AAPL | Stock | 20.2729 | 20.2996 | 20.2729 | 20.2864 | 197484.0 |
| 2012-05-29 08:55:00 | AAPL | Stock | 20.2929 | 20.3011 | 20.2929 | 20.3 | 81760.0 |
| 2012-05-29 09:00:00 | AAPL | Stock | 20.3025 | 20.3054 | 20.2789 | 20.2939 | 325836.0 |
| 2012-05-29 09:05:00 | AAPL | Stock | 20.2946 | 20.3164 | 20.2907 | 20.3 | 364000.0 |
| 2012-05-29 09:10:00 | AAPL | Stock | 20.2968 | 20.3 | 20.2896 | 20.3 | 214620.0 |
| 2012-05-29 09:15:00 | AAPL | Stock | 20.3 | 20.3214 | 20.3 | 20.3182 | 354956.0 |
| 2012-05-29 09:20:00 | AAPL | Stock | 20.3179 | 20.3214 | 20.3036 | 20.3114 | 174664.0 |
| 2012-05-29 09:25:00 | AAPL | Stock | 20.3118 | 20.3896 | 20.3118 | 20.3807 | 1044876.0 |
| 2012-05-29 09:30:00 | AAPL | Stock | 20.3868 | 20.3929 | 20.3093 | 20.3189 | 18907196.0 |
| 2012-05-29 09:35:00 | AAPL | Stock | 20.3204 | 20.3571 | 20.2936 | 20.294 | 11256168.0 |
| 2012-05-29 09:40:00 | AAPL | Stock | 20.2961 | 20.3289 | 20.2732 | 20.2957 | 9725884.0 |
| 2012-05-29 09:45:00 | AAPL | Stock | 20.2964 | 20.2993 | 20.2261 | 20.2729 | 9785888.0 |
| 2012-05-29 09:50:00 | AAPL | Stock | 20.2803 | 20.2975 | 20.2593 | 20.2904 | 5806892.0 |
| 2012-05-29 09:55:00 | AAPL | Stock | 20.2896 | 20.3036 | 20.27 | 20.2936 | 5924492.0 |
| 2012-05-29 10:00:00 | AAPL | Stock | 20.2836 | 20.2945 | 20.2371 | 20.2793 | 6892424.0 |
| 2012-05-29 10:05:00 | AAPL | Stock | 20.2779 | 20.325 | 20.2739 | 20.3245 | 8401792.0 |
| 2012-05-29 10:10:00 | AAPL | Stock | 20.3229 | 20.3814 | 20.3219 | 20.3679 | 12034064.0 |
| 2012-05-29 10:15:00 | AAPL | Stock | 20.3686 | 20.4029 | 20.3393 | 20.3854 | 8636292.0 |
| 2012-05-29 10:20:00 | AAPL | Stock | 20.39 | 20.4786 | 20.3886 | 20.4779 | 12717124.0 |
| 2012-05-29 10:25:00 | AAPL | Stock | 20.4764 | 20.4807 | 20.4018 | 20.4389 | 9052484.0 |
| 2012-05-29 10:30:00 | AAPL | Stock | 20.4439 | 20.5 | 20.4404 | 20.4829 | 9151156.0 |
> showing 50 of 325,832 rows — these rows as CSV