PREVIEW / stock_5min / 2012-06-06
file: by_date/stock_5min/2012/2012-06-06.parquet size: 4.9 MB rows: 331,817 symbols: 3,536
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-06-06 04:00:00 | AAPL | Stock | 20.2018 | 20.2857 | 20.2018 | 20.2857 | 5600.0 |
| 2012-06-06 04:05:00 | AAPL | Stock | 20.3036 | 20.3214 | 20.3036 | 20.3211 | 30352.0 |
| 2012-06-06 04:30:00 | AAPL | Stock | 20.3204 | 20.3204 | 20.3036 | 20.3036 | 11200.0 |
| 2012-06-06 04:35:00 | AAPL | Stock | 20.3204 | 20.3204 | 20.3204 | 20.3204 | 5600.0 |
| 2012-06-06 04:45:00 | AAPL | Stock | 20.3204 | 20.3204 | 20.3193 | 20.3193 | 5600.0 |
| 2012-06-06 04:50:00 | AAPL | Stock | 20.3193 | 20.3204 | 20.3193 | 20.3204 | 5600.0 |
| 2012-06-06 04:55:00 | AAPL | Stock | 20.2875 | 20.2875 | 20.2857 | 20.2857 | 19600.0 |
| 2012-06-06 05:00:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 8400.0 |
| 2012-06-06 06:00:00 | AAPL | Stock | 20.2329 | 20.2329 | 20.2329 | 20.2329 | 4200.0 |
| 2012-06-06 06:05:00 | AAPL | Stock | 20.2821 | 20.2821 | 20.2821 | 20.2821 | 8400.0 |
| 2012-06-06 06:10:00 | AAPL | Stock | 20.3 | 20.3 | 20.3 | 20.3 | 2800.0 |
| 2012-06-06 06:20:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2679 | 20.2679 | 6300.0 |
| 2012-06-06 06:35:00 | AAPL | Stock | 20.2732 | 20.3032 | 20.2732 | 20.3032 | 29400.0 |
| 2012-06-06 06:40:00 | AAPL | Stock | 20.3032 | 20.3032 | 20.3032 | 20.3032 | 3668.0 |
| 2012-06-06 06:45:00 | AAPL | Stock | 20.3168 | 20.3171 | 20.3168 | 20.3171 | 7672.0 |
| 2012-06-06 06:50:00 | AAPL | Stock | 20.3171 | 20.3214 | 20.3171 | 20.3171 | 14000.0 |
| 2012-06-06 06:55:00 | AAPL | Stock | 20.3057 | 20.3057 | 20.3057 | 20.3057 | 5600.0 |
| 2012-06-06 07:00:00 | AAPL | Stock | 20.3054 | 20.3179 | 20.2946 | 20.3075 | 49000.0 |
| 2012-06-06 07:05:00 | AAPL | Stock | 20.3214 | 20.3354 | 20.3079 | 20.3293 | 72436.0 |
| 2012-06-06 07:10:00 | AAPL | Stock | 20.3175 | 20.3268 | 20.3036 | 20.3036 | 38836.0 |
| 2012-06-06 07:15:00 | AAPL | Stock | 20.3211 | 20.3214 | 20.3207 | 20.3214 | 67200.0 |
| 2012-06-06 07:20:00 | AAPL | Stock | 20.3214 | 20.3271 | 20.3214 | 20.3214 | 29540.0 |
| 2012-06-06 07:25:00 | AAPL | Stock | 20.3214 | 20.3429 | 20.3161 | 20.3393 | 203084.0 |
| 2012-06-06 07:30:00 | AAPL | Stock | 20.3379 | 20.3546 | 20.3375 | 20.3464 | 104580.0 |
| 2012-06-06 07:35:00 | AAPL | Stock | 20.3393 | 20.3429 | 20.3393 | 20.3429 | 19376.0 |
| 2012-06-06 07:40:00 | AAPL | Stock | 20.3429 | 20.3536 | 20.3393 | 20.3429 | 99680.0 |
| 2012-06-06 07:45:00 | AAPL | Stock | 20.3268 | 20.3389 | 20.2996 | 20.3286 | 198940.0 |
| 2012-06-06 07:50:00 | AAPL | Stock | 20.3371 | 20.3536 | 20.3339 | 20.3536 | 137760.0 |
| 2012-06-06 07:55:00 | AAPL | Stock | 20.3529 | 20.3529 | 20.3339 | 20.3339 | 53480.0 |
| 2012-06-06 08:00:00 | AAPL | Stock | 20.3371 | 20.3532 | 20.2996 | 20.3036 | 469560.0 |
| 2012-06-06 08:05:00 | AAPL | Stock | 20.3036 | 20.3036 | 20.2857 | 20.2857 | 137648.0 |
| 2012-06-06 08:10:00 | AAPL | Stock | 20.2839 | 20.2946 | 20.2771 | 20.28 | 230496.0 |
| 2012-06-06 08:15:00 | AAPL | Stock | 20.285 | 20.2946 | 20.275 | 20.2786 | 178388.0 |
| 2012-06-06 08:20:00 | AAPL | Stock | 20.2821 | 20.2946 | 20.2821 | 20.2911 | 82936.0 |
| 2012-06-06 08:25:00 | AAPL | Stock | 20.2886 | 20.3021 | 20.2886 | 20.2996 | 44436.0 |
| 2012-06-06 08:30:00 | AAPL | Stock | 20.3029 | 20.3168 | 20.2936 | 20.2954 | 432208.0 |
| 2012-06-06 08:35:00 | AAPL | Stock | 20.3032 | 20.3036 | 20.2536 | 20.2632 | 385252.0 |
| 2012-06-06 08:40:00 | AAPL | Stock | 20.265 | 20.265 | 20.2236 | 20.25 | 551096.0 |
| 2012-06-06 08:45:00 | AAPL | Stock | 20.2482 | 20.2639 | 20.2418 | 20.2421 | 160748.0 |
| 2012-06-06 08:50:00 | AAPL | Stock | 20.2429 | 20.25 | 20.2196 | 20.2268 | 210532.0 |
| 2012-06-06 08:55:00 | AAPL | Stock | 20.2379 | 20.24 | 20.2068 | 20.2164 | 244160.0 |
| 2012-06-06 09:00:00 | AAPL | Stock | 20.2089 | 20.2282 | 20.1907 | 20.2279 | 322000.0 |
| 2012-06-06 09:05:00 | AAPL | Stock | 20.2221 | 20.2246 | 20.2036 | 20.2246 | 112364.0 |
| 2012-06-06 09:10:00 | AAPL | Stock | 20.2143 | 20.2175 | 20.2079 | 20.2107 | 125916.0 |
| 2012-06-06 09:15:00 | AAPL | Stock | 20.2075 | 20.2268 | 20.2071 | 20.2196 | 117908.0 |
| 2012-06-06 09:20:00 | AAPL | Stock | 20.2164 | 20.2379 | 20.2161 | 20.2264 | 213472.0 |
| 2012-06-06 09:25:00 | AAPL | Stock | 20.2268 | 20.2821 | 20.2225 | 20.2786 | 539448.0 |
| 2012-06-06 09:30:00 | AAPL | Stock | 20.2821 | 20.2857 | 20.2079 | 20.2121 | 13057212.0 |
| 2012-06-06 09:35:00 | AAPL | Stock | 20.2143 | 20.28 | 20.1964 | 20.2432 | 10417876.0 |
| 2012-06-06 09:40:00 | AAPL | Stock | 20.2436 | 20.3007 | 20.2396 | 20.2905 | 10677996.0 |
> showing 50 of 331,817 rows — these rows as CSV