PREVIEW / stock_5min / 2013-09-27
file: by_date/stock_5min/2013/2013-09-27.parquet size: 5.0 MB rows: 333,759 symbols: 3,523
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-09-27 04:20:00 | AAPL | Stock | 17.3846 | 17.3846 | 17.3846 | 17.3846 | 2800.0 |
| 2013-09-27 05:15:00 | AAPL | Stock | 17.3714 | 17.3714 | 17.3643 | 17.3643 | 11200.0 |
| 2013-09-27 05:20:00 | AAPL | Stock | 17.3807 | 17.3807 | 17.3807 | 17.3807 | 2800.0 |
| 2013-09-27 06:40:00 | AAPL | Stock | 17.3393 | 17.3489 | 17.3393 | 17.3489 | 5600.0 |
| 2013-09-27 06:45:00 | AAPL | Stock | 17.3393 | 17.3393 | 17.3393 | 17.3393 | 2800.0 |
| 2013-09-27 06:50:00 | AAPL | Stock | 17.3393 | 17.3393 | 17.3393 | 17.3393 | 2800.0 |
| 2013-09-27 06:55:00 | AAPL | Stock | 17.3393 | 17.3393 | 17.3221 | 17.3393 | 19600.0 |
| 2013-09-27 07:00:00 | AAPL | Stock | 17.3375 | 17.3679 | 17.3375 | 17.3571 | 60284.0 |
| 2013-09-27 07:05:00 | AAPL | Stock | 17.3486 | 17.3571 | 17.345 | 17.345 | 12600.0 |
| 2013-09-27 07:10:00 | AAPL | Stock | 17.3539 | 17.3568 | 17.3539 | 17.3568 | 19012.0 |
| 2013-09-27 07:15:00 | AAPL | Stock | 17.3504 | 17.3504 | 17.3482 | 17.3482 | 11200.0 |
| 2013-09-27 07:20:00 | AAPL | Stock | 17.3504 | 17.3504 | 17.3489 | 17.3504 | 10640.0 |
| 2013-09-27 07:25:00 | AAPL | Stock | 17.3429 | 17.3429 | 17.3393 | 17.3393 | 98000.0 |
| 2013-09-27 07:30:00 | AAPL | Stock | 17.3214 | 17.3218 | 17.3161 | 17.3161 | 24584.0 |
| 2013-09-27 07:35:00 | AAPL | Stock | 17.3036 | 17.3161 | 17.2946 | 17.3161 | 52360.0 |
| 2013-09-27 07:40:00 | AAPL | Stock | 17.3125 | 17.3125 | 17.2932 | 17.3036 | 43708.0 |
| 2013-09-27 07:45:00 | AAPL | Stock | 17.3032 | 17.3032 | 17.3032 | 17.3032 | 2800.0 |
| 2013-09-27 07:50:00 | AAPL | Stock | 17.3146 | 17.3221 | 17.3114 | 17.3146 | 71680.0 |
| 2013-09-27 07:55:00 | AAPL | Stock | 17.3264 | 17.3275 | 17.3264 | 17.3275 | 5600.0 |
| 2013-09-27 08:00:00 | AAPL | Stock | 17.3279 | 17.3786 | 17.2857 | 17.2986 | 375340.0 |
| 2013-09-27 08:05:00 | AAPL | Stock | 17.2961 | 17.3125 | 17.2961 | 17.3036 | 185920.0 |
| 2013-09-27 08:10:00 | AAPL | Stock | 17.3036 | 17.3107 | 17.3036 | 17.3036 | 29400.0 |
| 2013-09-27 08:15:00 | AAPL | Stock | 17.31 | 17.31 | 17.2896 | 17.2896 | 146608.0 |
| 2013-09-27 08:20:00 | AAPL | Stock | 17.2961 | 17.2982 | 17.2821 | 17.2832 | 160244.0 |
| 2013-09-27 08:25:00 | AAPL | Stock | 17.2775 | 17.2971 | 17.2714 | 17.2896 | 207872.0 |
| 2013-09-27 08:30:00 | AAPL | Stock | 17.2979 | 17.3064 | 17.29 | 17.3064 | 82040.0 |
| 2013-09-27 08:35:00 | AAPL | Stock | 17.3054 | 17.3071 | 17.2971 | 17.3071 | 108920.0 |
| 2013-09-27 08:40:00 | AAPL | Stock | 17.3025 | 17.3211 | 17.3025 | 17.3207 | 149380.0 |
| 2013-09-27 08:45:00 | AAPL | Stock | 17.3107 | 17.3143 | 17.3093 | 17.3143 | 20076.0 |
| 2013-09-27 08:50:00 | AAPL | Stock | 17.3139 | 17.3157 | 17.2939 | 17.2939 | 118664.0 |
| 2013-09-27 08:55:00 | AAPL | Stock | 17.2929 | 17.3075 | 17.2857 | 17.3075 | 37156.0 |
| 2013-09-27 09:00:00 | AAPL | Stock | 17.3139 | 17.3143 | 17.3139 | 17.3143 | 16800.0 |
| 2013-09-27 09:05:00 | AAPL | Stock | 17.3143 | 17.3214 | 17.3089 | 17.3164 | 220948.0 |
| 2013-09-27 09:10:00 | AAPL | Stock | 17.3164 | 17.365 | 17.3161 | 17.3161 | 438060.0 |
| 2013-09-27 09:15:00 | AAPL | Stock | 17.3161 | 17.3214 | 17.3161 | 17.3211 | 116592.0 |
| 2013-09-27 09:20:00 | AAPL | Stock | 17.3211 | 17.3289 | 17.3211 | 17.3289 | 35000.0 |
| 2013-09-27 09:25:00 | AAPL | Stock | 17.3236 | 17.325 | 17.2686 | 17.2768 | 627312.0 |
| 2013-09-27 09:30:00 | AAPL | Stock | 17.2779 | 17.3096 | 17.1955 | 17.2693 | 15299704.0 |
| 2013-09-27 09:35:00 | AAPL | Stock | 17.2693 | 17.2754 | 17.2089 | 17.2114 | 6464220.0 |
| 2013-09-27 09:40:00 | AAPL | Stock | 17.2096 | 17.2396 | 17.2039 | 17.225 | 4777388.0 |
| 2013-09-27 09:45:00 | AAPL | Stock | 17.2275 | 17.2446 | 17.2161 | 17.2305 | 5394704.0 |
| 2013-09-27 09:50:00 | AAPL | Stock | 17.2354 | 17.2693 | 17.2216 | 17.26 | 4678716.0 |
| 2013-09-27 09:55:00 | AAPL | Stock | 17.2618 | 17.2654 | 17.2075 | 17.2339 | 4580856.0 |
| 2013-09-27 10:00:00 | AAPL | Stock | 17.2339 | 17.2386 | 17.2111 | 17.2141 | 3909528.0 |
| 2013-09-27 10:05:00 | AAPL | Stock | 17.2179 | 17.2382 | 17.2139 | 17.2269 | 3071796.0 |
| 2013-09-27 10:10:00 | AAPL | Stock | 17.2268 | 17.2461 | 17.2218 | 17.2396 | 2638944.0 |
| 2013-09-27 10:15:00 | AAPL | Stock | 17.2396 | 17.2893 | 17.2394 | 17.2732 | 6356084.0 |
| 2013-09-27 10:20:00 | AAPL | Stock | 17.2739 | 17.2943 | 17.2686 | 17.2786 | 3857728.0 |
| 2013-09-27 10:25:00 | AAPL | Stock | 17.2811 | 17.2821 | 17.2625 | 17.2625 | 2952880.0 |
| 2013-09-27 10:30:00 | AAPL | Stock | 17.2671 | 17.2711 | 17.2511 | 17.2624 | 2799860.0 |
> showing 50 of 333,759 rows — these rows as CSV