PREVIEW / stock_5min / 2012-05-30
file: by_date/stock_5min/2012/2012-05-30.parquet size: 4.7 MB rows: 322,760 symbols: 3,544
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-05-30 04:00:00 | AAPL | Stock | 20.3668 | 20.3668 | 20.3536 | 20.3536 | 8400.0 |
| 2012-05-30 04:15:00 | AAPL | Stock | 20.3218 | 20.3482 | 20.3218 | 20.3482 | 8400.0 |
| 2012-05-30 04:20:00 | AAPL | Stock | 20.3482 | 20.3482 | 20.3482 | 20.3482 | 2800.0 |
| 2012-05-30 04:25:00 | AAPL | Stock | 20.3482 | 20.3482 | 20.3482 | 20.3482 | 8568.0 |
| 2012-05-30 04:50:00 | AAPL | Stock | 20.3218 | 20.3218 | 20.3214 | 20.3214 | 5712.0 |
| 2012-05-30 05:00:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 22400.0 |
| 2012-05-30 05:20:00 | AAPL | Stock | 20.2975 | 20.2975 | 20.2975 | 20.2975 | 2800.0 |
| 2012-05-30 05:25:00 | AAPL | Stock | 20.2975 | 20.3357 | 20.2975 | 20.3357 | 8400.0 |
| 2012-05-30 05:30:00 | AAPL | Stock | 20.3357 | 20.3357 | 20.3107 | 20.3107 | 11200.0 |
| 2012-05-30 06:25:00 | AAPL | Stock | 20.3179 | 20.3179 | 20.3179 | 20.3179 | 16800.0 |
| 2012-05-30 06:30:00 | AAPL | Stock | 20.305 | 20.305 | 20.3018 | 20.3036 | 14000.0 |
| 2012-05-30 06:55:00 | AAPL | Stock | 20.2907 | 20.2907 | 20.2907 | 20.2907 | 2800.0 |
| 2012-05-30 07:00:00 | AAPL | Stock | 20.29 | 20.3571 | 20.2543 | 20.3482 | 193648.0 |
| 2012-05-30 07:05:00 | AAPL | Stock | 20.3393 | 20.3836 | 20.3393 | 20.3589 | 59024.0 |
| 2012-05-30 07:10:00 | AAPL | Stock | 20.3304 | 20.3661 | 20.3211 | 20.3304 | 232764.0 |
| 2012-05-30 07:15:00 | AAPL | Stock | 20.3536 | 20.3536 | 20.3125 | 20.3125 | 47628.0 |
| 2012-05-30 07:20:00 | AAPL | Stock | 20.3211 | 20.3461 | 20.3211 | 20.3461 | 22400.0 |
| 2012-05-30 07:25:00 | AAPL | Stock | 20.3457 | 20.3457 | 20.3386 | 20.3411 | 19740.0 |
| 2012-05-30 07:30:00 | AAPL | Stock | 20.3314 | 20.3393 | 20.3211 | 20.3357 | 123900.0 |
| 2012-05-30 07:35:00 | AAPL | Stock | 20.3386 | 20.35 | 20.3254 | 20.35 | 107380.0 |
| 2012-05-30 07:40:00 | AAPL | Stock | 20.3514 | 20.375 | 20.3514 | 20.3721 | 42000.0 |
| 2012-05-30 07:45:00 | AAPL | Stock | 20.3746 | 20.4207 | 20.3746 | 20.3929 | 106260.0 |
| 2012-05-30 07:50:00 | AAPL | Stock | 20.3911 | 20.4029 | 20.3854 | 20.3929 | 66780.0 |
| 2012-05-30 07:55:00 | AAPL | Stock | 20.3857 | 20.3857 | 20.3571 | 20.3571 | 48832.0 |
| 2012-05-30 08:00:00 | AAPL | Stock | 20.3343 | 20.3621 | 20.2896 | 20.2896 | 419188.0 |
| 2012-05-30 08:05:00 | AAPL | Stock | 20.3068 | 20.3214 | 20.3061 | 20.3211 | 143248.0 |
| 2012-05-30 08:10:00 | AAPL | Stock | 20.3096 | 20.3211 | 20.2786 | 20.2893 | 507696.0 |
| 2012-05-30 08:15:00 | AAPL | Stock | 20.2964 | 20.3214 | 20.2904 | 20.3125 | 249900.0 |
| 2012-05-30 08:20:00 | AAPL | Stock | 20.3071 | 20.3104 | 20.2875 | 20.3032 | 133448.0 |
| 2012-05-30 08:25:00 | AAPL | Stock | 20.3029 | 20.3132 | 20.2946 | 20.2964 | 117236.0 |
| 2012-05-30 08:30:00 | AAPL | Stock | 20.2957 | 20.2957 | 20.2696 | 20.2739 | 254828.0 |
| 2012-05-30 08:35:00 | AAPL | Stock | 20.285 | 20.3093 | 20.2843 | 20.3039 | 146048.0 |
| 2012-05-30 08:40:00 | AAPL | Stock | 20.3061 | 20.3107 | 20.2893 | 20.3032 | 151004.0 |
| 2012-05-30 08:45:00 | AAPL | Stock | 20.2975 | 20.2986 | 20.2975 | 20.2982 | 22400.0 |
| 2012-05-30 08:50:00 | AAPL | Stock | 20.3036 | 20.3339 | 20.3036 | 20.3339 | 230916.0 |
| 2012-05-30 08:55:00 | AAPL | Stock | 20.3339 | 20.3354 | 20.305 | 20.3182 | 113820.0 |
| 2012-05-30 09:00:00 | AAPL | Stock | 20.3107 | 20.3425 | 20.3107 | 20.3393 | 380212.0 |
| 2012-05-30 09:05:00 | AAPL | Stock | 20.3421 | 20.3643 | 20.3346 | 20.3571 | 524216.0 |
| 2012-05-30 09:10:00 | AAPL | Stock | 20.3589 | 20.3661 | 20.35 | 20.35 | 643384.0 |
| 2012-05-30 09:15:00 | AAPL | Stock | 20.3482 | 20.3489 | 20.3207 | 20.3218 | 667268.0 |
| 2012-05-30 09:20:00 | AAPL | Stock | 20.3232 | 20.3268 | 20.3089 | 20.3268 | 328972.0 |
| 2012-05-30 09:25:00 | AAPL | Stock | 20.3221 | 20.3429 | 20.3221 | 20.3429 | 301812.0 |
| 2012-05-30 09:30:00 | AAPL | Stock | 20.3286 | 20.3921 | 20.2954 | 20.37 | 19019812.0 |
| 2012-05-30 09:35:00 | AAPL | Stock | 20.365 | 20.3689 | 20.2696 | 20.3021 | 12853372.0 |
| 2012-05-30 09:40:00 | AAPL | Stock | 20.2957 | 20.3025 | 20.2343 | 20.2564 | 10738952.0 |
| 2012-05-30 09:45:00 | AAPL | Stock | 20.2575 | 20.3068 | 20.245 | 20.2793 | 6690740.0 |
| 2012-05-30 09:50:00 | AAPL | Stock | 20.2754 | 20.3304 | 20.2507 | 20.3261 | 6427652.0 |
| 2012-05-30 09:55:00 | AAPL | Stock | 20.3296 | 20.3296 | 20.2939 | 20.2964 | 4154976.0 |
| 2012-05-30 10:00:00 | AAPL | Stock | 20.295 | 20.3482 | 20.2679 | 20.3264 | 7873684.0 |
| 2012-05-30 10:05:00 | AAPL | Stock | 20.3264 | 20.375 | 20.3131 | 20.3671 | 7812252.0 |
> showing 50 of 322,760 rows — these rows as CSV