PREVIEW / stock_5min / 2013-06-19
file: by_date/stock_5min/2013/2013-06-19.parquet size: 5.0 MB rows: 337,022 symbols: 3,518
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-06-19 06:25:00 | AAPL | Stock | 15.4325 | 15.4325 | 15.4325 | 15.4325 | 2800.0 |
| 2013-06-19 06:40:00 | AAPL | Stock | 15.4279 | 15.4279 | 15.4279 | 15.4279 | 2800.0 |
| 2013-06-19 07:00:00 | AAPL | Stock | 15.4221 | 15.4221 | 15.4118 | 15.4118 | 25200.0 |
| 2013-06-19 07:05:00 | AAPL | Stock | 15.4107 | 15.4193 | 15.4107 | 15.4193 | 14000.0 |
| 2013-06-19 07:10:00 | AAPL | Stock | 15.4071 | 15.4121 | 15.4039 | 15.4039 | 14000.0 |
| 2013-06-19 07:20:00 | AAPL | Stock | 15.4086 | 15.4086 | 15.4086 | 15.4086 | 8400.0 |
| 2013-06-19 07:30:00 | AAPL | Stock | 15.4043 | 15.4043 | 15.3929 | 15.3929 | 38500.0 |
| 2013-06-19 07:35:00 | AAPL | Stock | 15.3932 | 15.3932 | 15.3932 | 15.3932 | 2800.0 |
| 2013-06-19 07:40:00 | AAPL | Stock | 15.3932 | 15.3964 | 15.3932 | 15.3964 | 8400.0 |
| 2013-06-19 07:45:00 | AAPL | Stock | 15.4029 | 15.4032 | 15.4029 | 15.4032 | 9380.0 |
| 2013-06-19 07:50:00 | AAPL | Stock | 15.3971 | 15.3975 | 15.3971 | 15.3975 | 11200.0 |
| 2013-06-19 07:55:00 | AAPL | Stock | 15.3989 | 15.4032 | 15.3939 | 15.4029 | 38276.0 |
| 2013-06-19 08:00:00 | AAPL | Stock | 15.4036 | 15.4154 | 15.3929 | 15.4107 | 156380.0 |
| 2013-06-19 08:05:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4014 | 15.4014 | 13664.0 |
| 2013-06-19 08:15:00 | AAPL | Stock | 15.4125 | 15.4125 | 15.4125 | 15.4125 | 5600.0 |
| 2013-06-19 08:20:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 2800.0 |
| 2013-06-19 08:30:00 | AAPL | Stock | 15.4018 | 15.4018 | 15.4 | 15.4 | 17724.0 |
| 2013-06-19 08:35:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4 | 15.4036 | 22400.0 |
| 2013-06-19 08:40:00 | AAPL | Stock | 15.3982 | 15.405 | 15.3982 | 15.405 | 19600.0 |
| 2013-06-19 08:45:00 | AAPL | Stock | 15.4086 | 15.4086 | 15.4086 | 15.4086 | 2800.0 |
| 2013-06-19 08:50:00 | AAPL | Stock | 15.4086 | 15.4086 | 15.4086 | 15.4086 | 2800.0 |
| 2013-06-19 08:55:00 | AAPL | Stock | 15.4068 | 15.4071 | 15.4068 | 15.4071 | 5600.0 |
| 2013-06-19 09:00:00 | AAPL | Stock | 15.4089 | 15.4089 | 15.4089 | 15.4089 | 2800.0 |
| 2013-06-19 09:05:00 | AAPL | Stock | 15.4093 | 15.4093 | 15.4093 | 15.4093 | 5600.0 |
| 2013-06-19 09:10:00 | AAPL | Stock | 15.4093 | 15.4093 | 15.4093 | 15.4093 | 2800.0 |
| 2013-06-19 09:15:00 | AAPL | Stock | 15.4018 | 15.4036 | 15.4018 | 15.4036 | 5600.0 |
| 2013-06-19 09:20:00 | AAPL | Stock | 15.3968 | 15.4036 | 15.3861 | 15.4036 | 88032.0 |
| 2013-06-19 09:25:00 | AAPL | Stock | 15.3954 | 15.4061 | 15.3929 | 15.3939 | 61320.0 |
| 2013-06-19 09:30:00 | AAPL | Stock | 15.3946 | 15.4164 | 15.3786 | 15.3889 | 7402528.0 |
| 2013-06-19 09:35:00 | AAPL | Stock | 15.39 | 15.395 | 15.3696 | 15.3918 | 4596984.0 |
| 2013-06-19 09:40:00 | AAPL | Stock | 15.3896 | 15.3904 | 15.3479 | 15.3597 | 6143424.0 |
| 2013-06-19 09:45:00 | AAPL | Stock | 15.3632 | 15.3711 | 15.3304 | 15.3318 | 4199384.0 |
| 2013-06-19 09:50:00 | AAPL | Stock | 15.3318 | 15.3464 | 15.3146 | 15.3257 | 5419008.0 |
| 2013-06-19 09:55:00 | AAPL | Stock | 15.3257 | 15.3457 | 15.3171 | 15.3241 | 5426848.0 |
| 2013-06-19 10:00:00 | AAPL | Stock | 15.3254 | 15.3254 | 15.2921 | 15.2946 | 5939472.0 |
| 2013-06-19 10:05:00 | AAPL | Stock | 15.2936 | 15.3018 | 15.2689 | 15.2793 | 7290444.0 |
| 2013-06-19 10:10:00 | AAPL | Stock | 15.285 | 15.3142 | 15.2732 | 15.3068 | 4327568.0 |
| 2013-06-19 10:15:00 | AAPL | Stock | 15.3093 | 15.3371 | 15.3071 | 15.3182 | 4300016.0 |
| 2013-06-19 10:20:00 | AAPL | Stock | 15.3171 | 15.3336 | 15.3036 | 15.3061 | 3932320.0 |
| 2013-06-19 10:25:00 | AAPL | Stock | 15.3079 | 15.3139 | 15.2968 | 15.3004 | 3892700.0 |
| 2013-06-19 10:30:00 | AAPL | Stock | 15.3 | 15.3093 | 15.2929 | 15.3093 | 2007628.0 |
| 2013-06-19 10:35:00 | AAPL | Stock | 15.3111 | 15.325 | 15.3046 | 15.3182 | 2150260.0 |
| 2013-06-19 10:40:00 | AAPL | Stock | 15.3214 | 15.335 | 15.3143 | 15.3332 | 2740528.0 |
| 2013-06-19 10:45:00 | AAPL | Stock | 15.3332 | 15.335 | 15.2893 | 15.294 | 3432492.0 |
| 2013-06-19 10:50:00 | AAPL | Stock | 15.2977 | 15.3107 | 15.2914 | 15.2936 | 1312752.0 |
| 2013-06-19 10:55:00 | AAPL | Stock | 15.2946 | 15.3136 | 15.2839 | 15.2916 | 2785076.0 |
| 2013-06-19 11:00:00 | AAPL | Stock | 15.2943 | 15.3118 | 15.2857 | 15.3061 | 1504748.0 |
| 2013-06-19 11:05:00 | AAPL | Stock | 15.3075 | 15.3086 | 15.2939 | 15.2964 | 1225448.0 |
| 2013-06-19 11:10:00 | AAPL | Stock | 15.2982 | 15.2996 | 15.2821 | 15.2857 | 2658404.0 |
| 2013-06-19 11:15:00 | AAPL | Stock | 15.2882 | 15.2993 | 15.2782 | 15.2954 | 2456104.0 |
> showing 50 of 337,022 rows — these rows as CSV