PREVIEW / stock_5min / 2011-05-13
file: by_date/stock_5min/2011/2011-05-13.parquet size: 4.9 MB rows: 332,568 symbols: 3,566
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-13 04:10:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 5600.0 |
| 2011-05-13 04:45:00 | AAPL | Stock | 12.375 | 12.375 | 12.375 | 12.375 | 2800.0 |
| 2011-05-13 05:25:00 | AAPL | Stock | 12.3607 | 12.3607 | 12.3607 | 12.3607 | 5880.0 |
| 2011-05-13 05:35:00 | AAPL | Stock | 12.3643 | 12.3643 | 12.3643 | 12.3643 | 53760.0 |
| 2011-05-13 06:00:00 | AAPL | Stock | 12.3657 | 12.3896 | 12.3657 | 12.3896 | 11200.0 |
| 2011-05-13 07:00:00 | AAPL | Stock | 12.3764 | 12.3818 | 12.3764 | 12.3818 | 18480.0 |
| 2011-05-13 07:05:00 | AAPL | Stock | 12.3764 | 12.3764 | 12.3764 | 12.3764 | 2800.0 |
| 2011-05-13 07:20:00 | AAPL | Stock | 12.3764 | 12.3764 | 12.3764 | 12.3764 | 14000.0 |
| 2011-05-13 07:25:00 | AAPL | Stock | 12.3693 | 12.3696 | 12.3693 | 12.3696 | 5600.0 |
| 2011-05-13 07:30:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3696 | 12.3696 | 6048.0 |
| 2011-05-13 07:35:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3696 | 12.3696 | 22400.0 |
| 2011-05-13 07:40:00 | AAPL | Stock | 12.3761 | 12.3839 | 12.3761 | 12.3839 | 13720.0 |
| 2011-05-13 07:45:00 | AAPL | Stock | 12.3764 | 12.3764 | 12.3764 | 12.3764 | 2800.0 |
| 2011-05-13 07:50:00 | AAPL | Stock | 12.3861 | 12.3861 | 12.3782 | 12.3782 | 5600.0 |
| 2011-05-13 07:55:00 | AAPL | Stock | 12.3771 | 12.3771 | 12.375 | 12.375 | 16800.0 |
| 2011-05-13 08:00:00 | AAPL | Stock | 12.3818 | 12.3825 | 12.3611 | 12.3611 | 51380.0 |
| 2011-05-13 08:05:00 | AAPL | Stock | 12.3646 | 12.3661 | 12.3571 | 12.3571 | 84532.0 |
| 2011-05-13 08:10:00 | AAPL | Stock | 12.3571 | 12.3729 | 12.3571 | 12.3729 | 76664.0 |
| 2011-05-13 08:15:00 | AAPL | Stock | 12.3729 | 12.38 | 12.3729 | 12.375 | 42532.0 |
| 2011-05-13 08:25:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3696 | 12.3696 | 6440.0 |
| 2011-05-13 08:30:00 | AAPL | Stock | 12.375 | 12.3775 | 12.3661 | 12.3661 | 134652.0 |
| 2011-05-13 08:35:00 | AAPL | Stock | 12.3661 | 12.3743 | 12.3661 | 12.3743 | 148204.0 |
| 2011-05-13 08:40:00 | AAPL | Stock | 12.3768 | 12.3818 | 12.3664 | 12.3664 | 204260.0 |
| 2011-05-13 08:45:00 | AAPL | Stock | 12.3746 | 12.375 | 12.3643 | 12.3732 | 64400.0 |
| 2011-05-13 08:50:00 | AAPL | Stock | 12.3646 | 12.3689 | 12.3529 | 12.3536 | 152264.0 |
| 2011-05-13 08:55:00 | AAPL | Stock | 12.3518 | 12.3529 | 12.3429 | 12.3429 | 257180.0 |
| 2011-05-13 09:00:00 | AAPL | Stock | 12.3511 | 12.3511 | 12.3393 | 12.34 | 112112.0 |
| 2011-05-13 09:05:00 | AAPL | Stock | 12.345 | 12.3464 | 12.345 | 12.3464 | 30800.0 |
| 2011-05-13 09:10:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3354 | 12.3357 | 123312.0 |
| 2011-05-13 09:15:00 | AAPL | Stock | 12.345 | 12.3457 | 12.3321 | 12.3321 | 50400.0 |
| 2011-05-13 09:20:00 | AAPL | Stock | 12.3393 | 12.3425 | 12.3389 | 12.3404 | 36400.0 |
| 2011-05-13 09:25:00 | AAPL | Stock | 12.3443 | 12.3571 | 12.3429 | 12.3496 | 338716.0 |
| 2011-05-13 09:30:00 | AAPL | Stock | 12.345 | 12.3661 | 12.3143 | 12.3207 | 8643936.0 |
| 2011-05-13 09:35:00 | AAPL | Stock | 12.3214 | 12.33 | 12.305 | 12.3207 | 8672412.0 |
| 2011-05-13 09:40:00 | AAPL | Stock | 12.3225 | 12.3446 | 12.3146 | 12.3332 | 4525360.0 |
| 2011-05-13 09:45:00 | AAPL | Stock | 12.3293 | 12.3346 | 12.3111 | 12.3246 | 4269048.0 |
| 2011-05-13 09:50:00 | AAPL | Stock | 12.3257 | 12.3264 | 12.3107 | 12.3236 | 3567228.0 |
| 2011-05-13 09:55:00 | AAPL | Stock | 12.3193 | 12.3257 | 12.2811 | 12.2868 | 8910496.0 |
| 2011-05-13 10:00:00 | AAPL | Stock | 12.2843 | 12.3061 | 12.2754 | 12.3046 | 6102740.0 |
| 2011-05-13 10:05:00 | AAPL | Stock | 12.3011 | 12.3086 | 12.2821 | 12.2918 | 5331508.0 |
| 2011-05-13 10:10:00 | AAPL | Stock | 12.2925 | 12.3171 | 12.29 | 12.3079 | 4631508.0 |
| 2011-05-13 10:15:00 | AAPL | Stock | 12.3075 | 12.3211 | 12.3061 | 12.3196 | 2791880.0 |
| 2011-05-13 10:20:00 | AAPL | Stock | 12.3193 | 12.3214 | 12.3021 | 12.309 | 3477292.0 |
| 2011-05-13 10:25:00 | AAPL | Stock | 12.3136 | 12.3254 | 12.3046 | 12.3171 | 2542820.0 |
| 2011-05-13 10:30:00 | AAPL | Stock | 12.315 | 12.3261 | 12.3125 | 12.3186 | 2046828.0 |
| 2011-05-13 10:35:00 | AAPL | Stock | 12.3196 | 12.3275 | 12.3107 | 12.3134 | 2497600.0 |
| 2011-05-13 10:40:00 | AAPL | Stock | 12.3143 | 12.3239 | 12.3071 | 12.3082 | 2462460.0 |
| 2011-05-13 10:45:00 | AAPL | Stock | 12.3086 | 12.3086 | 12.2886 | 12.2975 | 3067204.0 |
| 2011-05-13 10:50:00 | AAPL | Stock | 12.3 | 12.3068 | 12.2916 | 12.3014 | 2185736.0 |
| 2011-05-13 10:55:00 | AAPL | Stock | 12.3014 | 12.3036 | 12.2914 | 12.2946 | 1707496.0 |
> showing 50 of 332,568 rows — these rows as CSV