PREVIEW / stock_5min / 2014-01-08
file: by_date/stock_5min/2014/2014-01-08.parquet size: 5.5 MB rows: 361,661 symbols: 3,521
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-08 05:00:00 | AAPL | Stock | 19.2868 | 19.2907 | 19.2868 | 19.2904 | 8400.0 |
| 2014-01-08 05:35:00 | AAPL | Stock | 19.3179 | 19.3361 | 19.3179 | 19.3361 | 5600.0 |
| 2014-01-08 05:55:00 | AAPL | Stock | 19.3086 | 19.3086 | 19.3086 | 19.3086 | 2800.0 |
| 2014-01-08 06:00:00 | AAPL | Stock | 19.3011 | 19.3011 | 19.2968 | 19.2968 | 11200.0 |
| 2014-01-08 06:50:00 | AAPL | Stock | 19.2971 | 19.2971 | 19.2718 | 19.2718 | 5600.0 |
| 2014-01-08 06:55:00 | AAPL | Stock | 19.2814 | 19.2814 | 19.2814 | 19.2814 | 2800.0 |
| 2014-01-08 07:00:00 | AAPL | Stock | 19.2679 | 19.2679 | 19.2679 | 19.2679 | 2800.0 |
| 2014-01-08 07:05:00 | AAPL | Stock | 19.2675 | 19.2675 | 19.2675 | 19.2675 | 2800.0 |
| 2014-01-08 07:20:00 | AAPL | Stock | 19.2764 | 19.2764 | 19.2764 | 19.2764 | 6440.0 |
| 2014-01-08 07:25:00 | AAPL | Stock | 19.2843 | 19.2857 | 19.2843 | 19.2857 | 8400.0 |
| 2014-01-08 07:35:00 | AAPL | Stock | 19.2954 | 19.2954 | 19.2879 | 19.2879 | 7224.0 |
| 2014-01-08 07:45:00 | AAPL | Stock | 19.29 | 19.29 | 19.29 | 19.29 | 2800.0 |
| 2014-01-08 07:55:00 | AAPL | Stock | 19.2954 | 19.3193 | 19.2954 | 19.3193 | 50400.0 |
| 2014-01-08 08:00:00 | AAPL | Stock | 19.3071 | 19.3089 | 19.2714 | 19.2954 | 86716.0 |
| 2014-01-08 08:05:00 | AAPL | Stock | 19.2954 | 19.3179 | 19.2954 | 19.3179 | 18480.0 |
| 2014-01-08 08:10:00 | AAPL | Stock | 19.3104 | 19.3204 | 19.3096 | 19.3096 | 36120.0 |
| 2014-01-08 08:15:00 | AAPL | Stock | 19.3096 | 19.3143 | 19.3039 | 19.3054 | 37184.0 |
| 2014-01-08 08:20:00 | AAPL | Stock | 19.3039 | 19.3118 | 19.3039 | 19.3118 | 33600.0 |
| 2014-01-08 08:25:00 | AAPL | Stock | 19.3 | 19.3036 | 19.2804 | 19.2914 | 194880.0 |
| 2014-01-08 08:30:00 | AAPL | Stock | 19.2814 | 19.2814 | 19.2771 | 19.2771 | 11200.0 |
| 2014-01-08 08:35:00 | AAPL | Stock | 19.2779 | 19.2946 | 19.2768 | 19.2796 | 140140.0 |
| 2014-01-08 08:40:00 | AAPL | Stock | 19.28 | 19.28 | 19.28 | 19.28 | 2800.0 |
| 2014-01-08 08:45:00 | AAPL | Stock | 19.2779 | 19.2786 | 19.2768 | 19.2771 | 22400.0 |
| 2014-01-08 08:50:00 | AAPL | Stock | 19.2821 | 19.3125 | 19.2779 | 19.3043 | 347760.0 |
| 2014-01-08 08:55:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.2857 | 19.2857 | 119840.0 |
| 2014-01-08 09:05:00 | AAPL | Stock | 19.2846 | 19.2846 | 19.2732 | 19.2732 | 18200.0 |
| 2014-01-08 09:10:00 | AAPL | Stock | 19.2754 | 19.2818 | 19.2532 | 19.2589 | 130928.0 |
| 2014-01-08 09:15:00 | AAPL | Stock | 19.2568 | 19.2571 | 19.2521 | 19.2571 | 24360.0 |
| 2014-01-08 09:20:00 | AAPL | Stock | 19.2625 | 19.2768 | 19.2625 | 19.2768 | 84000.0 |
| 2014-01-08 09:25:00 | AAPL | Stock | 19.2821 | 19.2821 | 19.2411 | 19.2536 | 183064.0 |
| 2014-01-08 09:30:00 | AAPL | Stock | 19.2432 | 19.3704 | 19.2389 | 19.3625 | 14809984.0 |
| 2014-01-08 09:35:00 | AAPL | Stock | 19.3654 | 19.3714 | 19.3221 | 19.3586 | 9447116.0 |
| 2014-01-08 09:40:00 | AAPL | Stock | 19.3618 | 19.3693 | 19.3346 | 19.3651 | 5770828.0 |
| 2014-01-08 09:45:00 | AAPL | Stock | 19.3668 | 19.3993 | 19.35 | 19.3846 | 8100036.0 |
| 2014-01-08 09:50:00 | AAPL | Stock | 19.3836 | 19.4442 | 19.3768 | 19.4371 | 8613024.0 |
| 2014-01-08 09:55:00 | AAPL | Stock | 19.4375 | 19.443 | 19.4018 | 19.4275 | 4148648.0 |
| 2014-01-08 10:00:00 | AAPL | Stock | 19.4275 | 19.4539 | 19.4154 | 19.4421 | 4517184.0 |
| 2014-01-08 10:05:00 | AAPL | Stock | 19.4436 | 19.4496 | 19.4046 | 19.4118 | 3786048.0 |
| 2014-01-08 10:10:00 | AAPL | Stock | 19.4143 | 19.4486 | 19.4036 | 19.4271 | 3217984.0 |
| 2014-01-08 10:15:00 | AAPL | Stock | 19.43 | 19.4432 | 19.4196 | 19.429 | 1550052.0 |
| 2014-01-08 10:20:00 | AAPL | Stock | 19.4357 | 19.4357 | 19.4175 | 19.4202 | 1767416.0 |
| 2014-01-08 10:25:00 | AAPL | Stock | 19.4203 | 19.4482 | 19.4203 | 19.4354 | 3145632.0 |
| 2014-01-08 10:30:00 | AAPL | Stock | 19.4396 | 19.4625 | 19.4371 | 19.46 | 3852576.0 |
| 2014-01-08 10:35:00 | AAPL | Stock | 19.4607 | 19.4839 | 19.4554 | 19.4725 | 4471544.0 |
| 2014-01-08 10:40:00 | AAPL | Stock | 19.475 | 19.4843 | 19.4557 | 19.46 | 3850756.0 |
| 2014-01-08 10:45:00 | AAPL | Stock | 19.4625 | 19.475 | 19.4564 | 19.4725 | 2301796.0 |
| 2014-01-08 10:50:00 | AAPL | Stock | 19.4725 | 19.4793 | 19.3771 | 19.385 | 4706632.0 |
| 2014-01-08 10:55:00 | AAPL | Stock | 19.385 | 19.4085 | 19.3782 | 19.3982 | 3599876.0 |
| 2014-01-08 11:00:00 | AAPL | Stock | 19.4 | 19.4271 | 19.3986 | 19.4155 | 2026528.0 |
| 2014-01-08 11:05:00 | AAPL | Stock | 19.4157 | 19.4225 | 19.3571 | 19.3743 | 2487548.0 |
> showing 50 of 361,661 rows — these rows as CSV