PREVIEW / stock_5min / 2011-01-11
file: by_date/stock_5min/2011/2011-01-11.parquet size: 4.9 MB rows: 334,141 symbols: 3,509
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-11 04:00:00 | AAPL | Stock | 12.3014 | 12.3014 | 12.3014 | 12.3014 | 28000.0 |
| 2011-01-11 04:30:00 | AAPL | Stock | 12.3068 | 12.3071 | 12.3068 | 12.3071 | 5600.0 |
| 2011-01-11 04:35:00 | AAPL | Stock | 12.3054 | 12.3054 | 12.3054 | 12.3054 | 2800.0 |
| 2011-01-11 04:40:00 | AAPL | Stock | 12.3107 | 12.3107 | 12.3107 | 12.3107 | 2800.0 |
| 2011-01-11 05:05:00 | AAPL | Stock | 12.3146 | 12.3146 | 12.3146 | 12.3146 | 2800.0 |
| 2011-01-11 05:10:00 | AAPL | Stock | 12.3004 | 12.3004 | 12.3004 | 12.3004 | 2800.0 |
| 2011-01-11 05:25:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 05:30:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 05:35:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 05:50:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 06:00:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 84000.0 |
| 2011-01-11 06:10:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3043 | 12.3139 | 39200.0 |
| 2011-01-11 06:25:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 06:30:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 16800.0 |
| 2011-01-11 06:45:00 | AAPL | Stock | 12.3139 | 12.3157 | 12.3139 | 12.3157 | 8400.0 |
| 2011-01-11 06:50:00 | AAPL | Stock | 12.3089 | 12.3157 | 12.3089 | 12.3143 | 19600.0 |
| 2011-01-11 06:55:00 | AAPL | Stock | 12.3211 | 12.3389 | 12.3211 | 12.3389 | 21000.0 |
| 2011-01-11 07:00:00 | AAPL | Stock | 12.3171 | 12.3382 | 12.3093 | 12.3125 | 41720.0 |
| 2011-01-11 07:05:00 | AAPL | Stock | 12.3286 | 12.3336 | 12.3214 | 12.3336 | 26180.0 |
| 2011-01-11 07:10:00 | AAPL | Stock | 12.3343 | 12.3389 | 12.3339 | 12.3357 | 75600.0 |
| 2011-01-11 07:15:00 | AAPL | Stock | 12.3357 | 12.3357 | 12.3214 | 12.3214 | 56560.0 |
| 2011-01-11 07:20:00 | AAPL | Stock | 12.3214 | 12.3289 | 12.315 | 12.3289 | 97860.0 |
| 2011-01-11 07:25:00 | AAPL | Stock | 12.3289 | 12.3289 | 12.325 | 12.325 | 16800.0 |
| 2011-01-11 07:30:00 | AAPL | Stock | 12.325 | 12.3304 | 12.3132 | 12.3132 | 64400.0 |
| 2011-01-11 07:35:00 | AAPL | Stock | 12.3111 | 12.3164 | 12.3089 | 12.3107 | 63000.0 |
| 2011-01-11 07:40:00 | AAPL | Stock | 12.3207 | 12.3207 | 12.3093 | 12.3093 | 16800.0 |
| 2011-01-11 07:45:00 | AAPL | Stock | 12.3111 | 12.3186 | 12.3036 | 12.3036 | 72800.0 |
| 2011-01-11 07:50:00 | AAPL | Stock | 12.3036 | 12.3118 | 12.2936 | 12.2936 | 147476.0 |
| 2011-01-11 07:55:00 | AAPL | Stock | 12.29 | 12.3036 | 12.2893 | 12.3018 | 98000.0 |
| 2011-01-11 08:00:00 | AAPL | Stock | 12.2989 | 12.3089 | 12.2936 | 12.2979 | 337568.0 |
| 2011-01-11 08:05:00 | AAPL | Stock | 12.2982 | 12.2982 | 12.275 | 12.2804 | 555968.0 |
| 2011-01-11 08:10:00 | AAPL | Stock | 12.2743 | 12.2857 | 12.2743 | 12.2768 | 354816.0 |
| 2011-01-11 08:15:00 | AAPL | Stock | 12.2775 | 12.2839 | 12.2768 | 12.2821 | 213136.0 |
| 2011-01-11 08:20:00 | AAPL | Stock | 12.2821 | 12.2996 | 12.2804 | 12.2982 | 353052.0 |
| 2011-01-11 08:25:00 | AAPL | Stock | 12.295 | 12.3068 | 12.295 | 12.3036 | 701484.0 |
| 2011-01-11 08:30:00 | AAPL | Stock | 12.3032 | 12.3032 | 12.2936 | 12.295 | 361872.0 |
| 2011-01-11 08:35:00 | AAPL | Stock | 12.2993 | 12.3036 | 12.2979 | 12.3018 | 320712.0 |
| 2011-01-11 08:40:00 | AAPL | Stock | 12.2993 | 12.3025 | 12.2982 | 12.3025 | 140000.0 |
| 2011-01-11 08:45:00 | AAPL | Stock | 12.3029 | 12.3029 | 12.295 | 12.295 | 182980.0 |
| 2011-01-11 08:50:00 | AAPL | Stock | 12.2986 | 12.3014 | 12.2946 | 12.3 | 331324.0 |
| 2011-01-11 08:55:00 | AAPL | Stock | 12.2993 | 12.3011 | 12.2929 | 12.3 | 681016.0 |
| 2011-01-11 09:00:00 | AAPL | Stock | 12.2996 | 12.3107 | 12.2989 | 12.3054 | 387296.0 |
| 2011-01-11 09:05:00 | AAPL | Stock | 12.3061 | 12.3125 | 12.3039 | 12.3039 | 474208.0 |
| 2011-01-11 09:10:00 | AAPL | Stock | 12.3054 | 12.3129 | 12.3036 | 12.3118 | 441616.0 |
| 2011-01-11 09:15:00 | AAPL | Stock | 12.3104 | 12.3125 | 12.3 | 12.3029 | 281820.0 |
| 2011-01-11 09:20:00 | AAPL | Stock | 12.3004 | 12.3036 | 12.2968 | 12.3025 | 380072.0 |
| 2011-01-11 09:25:00 | AAPL | Stock | 12.3018 | 12.3114 | 12.2982 | 12.3114 | 959476.0 |
| 2011-01-11 09:30:00 | AAPL | Stock | 12.3114 | 12.32 | 12.2593 | 12.2714 | 23975812.0 |
| 2011-01-11 09:35:00 | AAPL | Stock | 12.2714 | 12.2764 | 12.2339 | 12.2443 | 18861668.0 |
| 2011-01-11 09:40:00 | AAPL | Stock | 12.245 | 12.2607 | 12.2318 | 12.2518 | 11291168.0 |
> showing 50 of 334,141 rows — these rows as CSV