PREVIEW / stock_5min / 2013-02-07
file: by_date/stock_5min/2013/2013-02-07.parquet size: 4.8 MB rows: 320,235 symbols: 3,467
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-02-07 04:50:00 | AAPL | Stock | 16.2964 | 16.2964 | 16.2964 | 16.2964 | 13944.0 |
| 2013-02-07 05:05:00 | AAPL | Stock | 16.2957 | 16.2982 | 16.2957 | 16.2982 | 14560.0 |
| 2013-02-07 06:40:00 | AAPL | Stock | 16.3296 | 16.33 | 16.3296 | 16.33 | 25760.0 |
| 2013-02-07 06:55:00 | AAPL | Stock | 16.2886 | 16.3286 | 16.2857 | 16.3286 | 19600.0 |
| 2013-02-07 07:00:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.2857 | 16.2857 | 13692.0 |
| 2013-02-07 07:05:00 | AAPL | Stock | 16.28 | 16.28 | 16.2729 | 16.2729 | 8400.0 |
| 2013-02-07 07:10:00 | AAPL | Stock | 16.2743 | 16.2743 | 16.2743 | 16.2743 | 5600.0 |
| 2013-02-07 07:15:00 | AAPL | Stock | 16.2779 | 16.2779 | 16.2779 | 16.2779 | 2800.0 |
| 2013-02-07 07:20:00 | AAPL | Stock | 16.2643 | 16.2643 | 16.2643 | 16.2643 | 7980.0 |
| 2013-02-07 07:35:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2521 | 16.2679 | 52528.0 |
| 2013-02-07 07:40:00 | AAPL | Stock | 16.2518 | 16.2518 | 16.25 | 16.25 | 14084.0 |
| 2013-02-07 07:45:00 | AAPL | Stock | 16.2664 | 16.2679 | 16.2536 | 16.2536 | 41524.0 |
| 2013-02-07 07:50:00 | AAPL | Stock | 16.2571 | 16.2571 | 16.25 | 16.2504 | 13916.0 |
| 2013-02-07 07:55:00 | AAPL | Stock | 16.25 | 16.25 | 16.2411 | 16.2411 | 12600.0 |
| 2013-02-07 08:00:00 | AAPL | Stock | 16.2493 | 16.2896 | 16.2321 | 16.2357 | 316232.0 |
| 2013-02-07 08:05:00 | AAPL | Stock | 16.2361 | 16.2361 | 16.2143 | 16.2339 | 183484.0 |
| 2013-02-07 08:10:00 | AAPL | Stock | 16.2339 | 16.2339 | 16.2143 | 16.2161 | 311500.0 |
| 2013-02-07 08:15:00 | AAPL | Stock | 16.2186 | 16.2286 | 16.2164 | 16.2196 | 170996.0 |
| 2013-02-07 08:20:00 | AAPL | Stock | 16.2146 | 16.2196 | 16.1964 | 16.2136 | 160020.0 |
| 2013-02-07 08:25:00 | AAPL | Stock | 16.2129 | 16.2318 | 16.2129 | 16.2286 | 69860.0 |
| 2013-02-07 08:30:00 | AAPL | Stock | 16.2286 | 16.4643 | 16.2179 | 16.3764 | 3371144.0 |
| 2013-02-07 08:35:00 | AAPL | Stock | 16.3764 | 16.47 | 16.3575 | 16.4254 | 4456284.0 |
| 2013-02-07 08:40:00 | AAPL | Stock | 16.4168 | 16.4911 | 16.3929 | 16.4832 | 1861636.0 |
| 2013-02-07 08:45:00 | AAPL | Stock | 16.4875 | 16.5057 | 16.4286 | 16.4286 | 2353456.0 |
| 2013-02-07 08:50:00 | AAPL | Stock | 16.4289 | 16.5714 | 16.4146 | 16.5689 | 3896788.0 |
| 2013-02-07 08:55:00 | AAPL | Stock | 16.5689 | 16.645 | 16.5496 | 16.5814 | 4564952.0 |
| 2013-02-07 09:00:00 | AAPL | Stock | 16.5736 | 16.5893 | 16.5039 | 16.5893 | 2620184.0 |
| 2013-02-07 09:05:00 | AAPL | Stock | 16.5911 | 16.6071 | 16.5089 | 16.5357 | 2069564.0 |
| 2013-02-07 09:10:00 | AAPL | Stock | 16.5332 | 16.5857 | 16.5286 | 16.5714 | 879788.0 |
| 2013-02-07 09:15:00 | AAPL | Stock | 16.5539 | 16.5893 | 16.5539 | 16.5814 | 722848.0 |
| 2013-02-07 09:20:00 | AAPL | Stock | 16.5796 | 16.5982 | 16.5446 | 16.5764 | 743512.0 |
| 2013-02-07 09:25:00 | AAPL | Stock | 16.5807 | 16.5807 | 16.5446 | 16.545 | 613172.0 |
| 2013-02-07 09:30:00 | AAPL | Stock | 16.5471 | 16.5629 | 16.3714 | 16.3814 | 30801904.0 |
| 2013-02-07 09:35:00 | AAPL | Stock | 16.3825 | 16.4386 | 16.3421 | 16.3557 | 16915220.0 |
| 2013-02-07 09:40:00 | AAPL | Stock | 16.3504 | 16.405 | 16.3143 | 16.3961 | 12865048.0 |
| 2013-02-07 09:45:00 | AAPL | Stock | 16.3961 | 16.4186 | 16.3625 | 16.3768 | 7365036.0 |
| 2013-02-07 09:50:00 | AAPL | Stock | 16.3718 | 16.383 | 16.2965 | 16.3004 | 12073796.0 |
| 2013-02-07 09:55:00 | AAPL | Stock | 16.3032 | 16.3693 | 16.3004 | 16.3446 | 6815032.0 |
| 2013-02-07 10:00:00 | AAPL | Stock | 16.345 | 16.4054 | 16.34 | 16.3857 | 8940204.0 |
| 2013-02-07 10:05:00 | AAPL | Stock | 16.3832 | 16.4007 | 16.3429 | 16.3871 | 8176168.0 |
| 2013-02-07 10:10:00 | AAPL | Stock | 16.3871 | 16.3957 | 16.3036 | 16.3293 | 7606284.0 |
| 2013-02-07 10:15:00 | AAPL | Stock | 16.3282 | 16.355 | 16.3161 | 16.3318 | 6701576.0 |
| 2013-02-07 10:20:00 | AAPL | Stock | 16.3354 | 16.3461 | 16.2389 | 16.2629 | 12978280.0 |
| 2013-02-07 10:25:00 | AAPL | Stock | 16.2636 | 16.2996 | 16.2389 | 16.2996 | 8344000.0 |
| 2013-02-07 10:30:00 | AAPL | Stock | 16.2996 | 16.3032 | 16.2518 | 16.2521 | 6146280.0 |
| 2013-02-07 10:35:00 | AAPL | Stock | 16.2536 | 16.3143 | 16.25 | 16.3011 | 6264692.0 |
| 2013-02-07 10:40:00 | AAPL | Stock | 16.3011 | 16.3254 | 16.2768 | 16.2871 | 5452244.0 |
| 2013-02-07 10:45:00 | AAPL | Stock | 16.2879 | 16.29 | 16.2425 | 16.2596 | 6451592.0 |
| 2013-02-07 10:50:00 | AAPL | Stock | 16.2561 | 16.2616 | 16.2186 | 16.2416 | 6890408.0 |
| 2013-02-07 10:55:00 | AAPL | Stock | 16.2418 | 16.2846 | 16.2318 | 16.2843 | 6106856.0 |
> showing 50 of 320,235 rows — these rows as CSV