PREVIEW / stock_5min / 2014-05-07
file: by_date/stock_5min/2014/2014-05-07.parquet size: 5.5 MB rows: 365,678 symbols: 3,552
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-05-07 04:15:00 | AAPL | Stock | 21.2368 | 21.2368 | 21.2368 | 21.2368 | 2800.0 |
| 2014-05-07 06:35:00 | AAPL | Stock | 21.275 | 21.275 | 21.275 | 21.275 | 2800.0 |
| 2014-05-07 06:40:00 | AAPL | Stock | 21.2593 | 21.2593 | 21.2589 | 21.2589 | 8400.0 |
| 2014-05-07 07:00:00 | AAPL | Stock | 21.2654 | 21.3161 | 21.2654 | 21.3161 | 30800.0 |
| 2014-05-07 07:10:00 | AAPL | Stock | 21.2989 | 21.3036 | 21.2989 | 21.3036 | 25312.0 |
| 2014-05-07 07:15:00 | AAPL | Stock | 21.2982 | 21.3 | 21.2982 | 21.3 | 13664.0 |
| 2014-05-07 07:20:00 | AAPL | Stock | 21.3036 | 21.3118 | 21.2929 | 21.2929 | 16800.0 |
| 2014-05-07 07:25:00 | AAPL | Stock | 21.3114 | 21.3114 | 21.3114 | 21.3114 | 2800.0 |
| 2014-05-07 07:35:00 | AAPL | Stock | 21.2939 | 21.2939 | 21.2929 | 21.2929 | 5600.0 |
| 2014-05-07 07:45:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.2857 | 21.3018 | 93240.0 |
| 2014-05-07 07:50:00 | AAPL | Stock | 21.3032 | 21.31 | 21.3032 | 21.31 | 15848.0 |
| 2014-05-07 07:55:00 | AAPL | Stock | 21.2996 | 21.2996 | 21.2996 | 21.2996 | 2800.0 |
| 2014-05-07 08:00:00 | AAPL | Stock | 21.2946 | 21.3032 | 21.1786 | 21.2961 | 217840.0 |
| 2014-05-07 08:05:00 | AAPL | Stock | 21.2879 | 21.3054 | 21.2879 | 21.3029 | 75600.0 |
| 2014-05-07 08:10:00 | AAPL | Stock | 21.3036 | 21.3143 | 21.3036 | 21.3143 | 68880.0 |
| 2014-05-07 08:15:00 | AAPL | Stock | 21.3143 | 21.3396 | 21.3143 | 21.3396 | 184044.0 |
| 2014-05-07 08:20:00 | AAPL | Stock | 21.3304 | 21.3343 | 21.3196 | 21.3343 | 276192.0 |
| 2014-05-07 08:25:00 | AAPL | Stock | 21.3146 | 21.3454 | 21.3146 | 21.3393 | 123648.0 |
| 2014-05-07 08:30:00 | AAPL | Stock | 21.3393 | 21.3429 | 21.3389 | 21.3429 | 40600.0 |
| 2014-05-07 08:35:00 | AAPL | Stock | 21.3479 | 21.3479 | 21.335 | 21.3461 | 47320.0 |
| 2014-05-07 08:40:00 | AAPL | Stock | 21.3364 | 21.3364 | 21.3289 | 21.3357 | 46508.0 |
| 2014-05-07 08:45:00 | AAPL | Stock | 21.3339 | 21.3339 | 21.3339 | 21.3339 | 7560.0 |
| 2014-05-07 08:50:00 | AAPL | Stock | 21.3218 | 21.3218 | 21.3218 | 21.3218 | 2800.0 |
| 2014-05-07 08:55:00 | AAPL | Stock | 21.3357 | 21.3393 | 21.3357 | 21.3393 | 35532.0 |
| 2014-05-07 09:00:00 | AAPL | Stock | 21.3418 | 21.3429 | 21.3232 | 21.3232 | 43708.0 |
| 2014-05-07 09:05:00 | AAPL | Stock | 21.3221 | 21.3221 | 21.3214 | 21.3214 | 11200.0 |
| 2014-05-07 09:10:00 | AAPL | Stock | 21.3218 | 21.3218 | 21.2893 | 21.3 | 52220.0 |
| 2014-05-07 09:15:00 | AAPL | Stock | 21.3014 | 21.3057 | 21.2954 | 21.2954 | 32760.0 |
| 2014-05-07 09:20:00 | AAPL | Stock | 21.3021 | 21.3175 | 21.2957 | 21.3057 | 78260.0 |
| 2014-05-07 09:25:00 | AAPL | Stock | 21.2957 | 21.2957 | 21.2504 | 21.2589 | 615412.0 |
| 2014-05-07 09:30:00 | AAPL | Stock | 21.2589 | 21.3304 | 21.2375 | 21.3211 | 11400676.0 |
| 2014-05-07 09:35:00 | AAPL | Stock | 21.3189 | 21.3318 | 21.2746 | 21.2839 | 5252436.0 |
| 2014-05-07 09:40:00 | AAPL | Stock | 21.2775 | 21.3164 | 21.2554 | 21.3129 | 2811088.0 |
| 2014-05-07 09:45:00 | AAPL | Stock | 21.3075 | 21.3189 | 21.2871 | 21.3186 | 3305092.0 |
| 2014-05-07 09:50:00 | AAPL | Stock | 21.3189 | 21.3304 | 21.2832 | 21.2907 | 4112192.0 |
| 2014-05-07 09:55:00 | AAPL | Stock | 21.2882 | 21.2936 | 21.115 | 21.1586 | 9278332.0 |
| 2014-05-07 10:00:00 | AAPL | Stock | 21.1586 | 21.2357 | 21.1429 | 21.2323 | 5862724.0 |
| 2014-05-07 10:05:00 | AAPL | Stock | 21.2314 | 21.2354 | 21.1432 | 21.1461 | 4142180.0 |
| 2014-05-07 10:10:00 | AAPL | Stock | 21.1468 | 21.1543 | 21.0071 | 21.0268 | 10367420.0 |
| 2014-05-07 10:15:00 | AAPL | Stock | 21.0329 | 21.0786 | 20.9904 | 21.0693 | 10396148.0 |
| 2014-05-07 10:20:00 | AAPL | Stock | 21.0643 | 21.1093 | 21.0521 | 21.1018 | 5199740.0 |
| 2014-05-07 10:25:00 | AAPL | Stock | 21.1036 | 21.1325 | 21.0921 | 21.0929 | 3764236.0 |
| 2014-05-07 10:30:00 | AAPL | Stock | 21.0936 | 21.1107 | 21.0436 | 21.0814 | 3558548.0 |
| 2014-05-07 10:35:00 | AAPL | Stock | 21.083 | 21.13 | 21.0627 | 21.1296 | 3532172.0 |
| 2014-05-07 10:40:00 | AAPL | Stock | 21.1289 | 21.1404 | 21.0925 | 21.0964 | 3064572.0 |
| 2014-05-07 10:45:00 | AAPL | Stock | 21.0979 | 21.1357 | 21.0979 | 21.1267 | 1991472.0 |
| 2014-05-07 10:50:00 | AAPL | Stock | 21.1271 | 21.1432 | 21.1039 | 21.1204 | 1967924.0 |
| 2014-05-07 10:55:00 | AAPL | Stock | 21.1211 | 21.13 | 21.0918 | 21.0982 | 1713544.0 |
| 2014-05-07 11:00:00 | AAPL | Stock | 21.0996 | 21.0996 | 21.0754 | 21.0943 | 2189824.0 |
| 2014-05-07 11:05:00 | AAPL | Stock | 21.0896 | 21.0943 | 21.0375 | 21.0596 | 3149524.0 |
> showing 50 of 365,678 rows — these rows as CSV