PREVIEW / stock_5min / 2013-10-02
file: by_date/stock_5min/2013/2013-10-02.parquet size: 5.3 MB rows: 350,097 symbols: 3,524
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-10-02 04:00:00 | AAPL | Stock | 17.3357 | 17.3357 | 17.3214 | 17.3214 | 31920.0 |
| 2013-10-02 04:10:00 | AAPL | Stock | 17.3132 | 17.3132 | 17.3132 | 17.3132 | 2800.0 |
| 2013-10-02 04:25:00 | AAPL | Stock | 17.2929 | 17.2929 | 17.2929 | 17.2929 | 5600.0 |
| 2013-10-02 04:30:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 5600.0 |
| 2013-10-02 04:35:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 2800.0 |
| 2013-10-02 05:20:00 | AAPL | Stock | 17.2964 | 17.2964 | 17.2954 | 17.2954 | 16800.0 |
| 2013-10-02 05:45:00 | AAPL | Stock | 17.3036 | 17.3071 | 17.3036 | 17.3071 | 35000.0 |
| 2013-10-02 05:50:00 | AAPL | Stock | 17.2925 | 17.2925 | 17.2925 | 17.2925 | 2800.0 |
| 2013-10-02 06:15:00 | AAPL | Stock | 17.2932 | 17.2964 | 17.2932 | 17.2964 | 6440.0 |
| 2013-10-02 06:20:00 | AAPL | Stock | 17.3004 | 17.3004 | 17.295 | 17.295 | 8400.0 |
| 2013-10-02 06:30:00 | AAPL | Stock | 17.2946 | 17.2946 | 17.2857 | 17.2946 | 54320.0 |
| 2013-10-02 06:35:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 4396.0 |
| 2013-10-02 06:45:00 | AAPL | Stock | 17.3211 | 17.3211 | 17.3211 | 17.3211 | 2800.0 |
| 2013-10-02 06:50:00 | AAPL | Stock | 17.3214 | 17.3304 | 17.3214 | 17.3304 | 10612.0 |
| 2013-10-02 06:55:00 | AAPL | Stock | 17.3568 | 17.3575 | 17.3107 | 17.3214 | 126588.0 |
| 2013-10-02 07:00:00 | AAPL | Stock | 17.3304 | 17.3321 | 17.3161 | 17.3321 | 57904.0 |
| 2013-10-02 07:05:00 | AAPL | Stock | 17.3389 | 17.35 | 17.3329 | 17.3429 | 121772.0 |
| 2013-10-02 07:10:00 | AAPL | Stock | 17.3429 | 17.3711 | 17.3389 | 17.3711 | 98000.0 |
| 2013-10-02 07:15:00 | AAPL | Stock | 17.3693 | 17.3693 | 17.3536 | 17.3536 | 58800.0 |
| 2013-10-02 07:20:00 | AAPL | Stock | 17.3536 | 17.3839 | 17.3454 | 17.3664 | 132076.0 |
| 2013-10-02 07:25:00 | AAPL | Stock | 17.3707 | 17.3961 | 17.3661 | 17.3929 | 126840.0 |
| 2013-10-02 07:30:00 | AAPL | Stock | 17.4004 | 17.4004 | 17.3946 | 17.3946 | 10472.0 |
| 2013-10-02 07:35:00 | AAPL | Stock | 17.4036 | 17.4336 | 17.4036 | 17.4107 | 122220.0 |
| 2013-10-02 07:40:00 | AAPL | Stock | 17.4114 | 17.4143 | 17.3857 | 17.3857 | 81200.0 |
| 2013-10-02 07:45:00 | AAPL | Stock | 17.3807 | 17.3807 | 17.3746 | 17.3775 | 54656.0 |
| 2013-10-02 07:50:00 | AAPL | Stock | 17.3875 | 17.3921 | 17.3875 | 17.3921 | 22400.0 |
| 2013-10-02 07:55:00 | AAPL | Stock | 17.3921 | 17.3925 | 17.3839 | 17.3889 | 181272.0 |
| 2013-10-02 08:00:00 | AAPL | Stock | 17.3921 | 17.4282 | 17.31 | 17.3714 | 432208.0 |
| 2013-10-02 08:05:00 | AAPL | Stock | 17.3904 | 17.3904 | 17.3736 | 17.3786 | 148204.0 |
| 2013-10-02 08:10:00 | AAPL | Stock | 17.3911 | 17.3925 | 17.3911 | 17.3925 | 22400.0 |
| 2013-10-02 08:15:00 | AAPL | Stock | 17.38 | 17.3929 | 17.3575 | 17.375 | 241780.0 |
| 2013-10-02 08:20:00 | AAPL | Stock | 17.375 | 17.375 | 17.35 | 17.3536 | 323568.0 |
| 2013-10-02 08:25:00 | AAPL | Stock | 17.3575 | 17.3786 | 17.3575 | 17.375 | 92512.0 |
| 2013-10-02 08:30:00 | AAPL | Stock | 17.3682 | 17.3682 | 17.3468 | 17.3679 | 294700.0 |
| 2013-10-02 08:35:00 | AAPL | Stock | 17.3661 | 17.3668 | 17.3625 | 17.3661 | 58800.0 |
| 2013-10-02 08:40:00 | AAPL | Stock | 17.3661 | 17.375 | 17.3607 | 17.3679 | 163716.0 |
| 2013-10-02 08:45:00 | AAPL | Stock | 17.3679 | 17.3725 | 17.3654 | 17.3654 | 58520.0 |
| 2013-10-02 08:50:00 | AAPL | Stock | 17.3732 | 17.3736 | 17.3589 | 17.3675 | 165788.0 |
| 2013-10-02 08:55:00 | AAPL | Stock | 17.3668 | 17.3679 | 17.3518 | 17.3518 | 101220.0 |
| 2013-10-02 09:00:00 | AAPL | Stock | 17.3532 | 17.3554 | 17.3196 | 17.3214 | 277956.0 |
| 2013-10-02 09:05:00 | AAPL | Stock | 17.3193 | 17.3264 | 17.3036 | 17.3264 | 461888.0 |
| 2013-10-02 09:10:00 | AAPL | Stock | 17.325 | 17.3389 | 17.3214 | 17.3296 | 232736.0 |
| 2013-10-02 09:15:00 | AAPL | Stock | 17.3236 | 17.3571 | 17.3236 | 17.3464 | 184492.0 |
| 2013-10-02 09:20:00 | AAPL | Stock | 17.3425 | 17.3493 | 17.3396 | 17.3396 | 61600.0 |
| 2013-10-02 09:25:00 | AAPL | Stock | 17.34 | 17.3571 | 17.3307 | 17.3321 | 263032.0 |
| 2013-10-02 09:30:00 | AAPL | Stock | 17.3439 | 17.375 | 17.2768 | 17.3018 | 18506208.0 |
| 2013-10-02 09:35:00 | AAPL | Stock | 17.3079 | 17.3625 | 17.2786 | 17.294 | 10013108.0 |
| 2013-10-02 09:40:00 | AAPL | Stock | 17.2957 | 17.3886 | 17.2936 | 17.3743 | 8411592.0 |
| 2013-10-02 09:45:00 | AAPL | Stock | 17.3729 | 17.3746 | 17.3207 | 17.3461 | 4961824.0 |
| 2013-10-02 09:50:00 | AAPL | Stock | 17.3343 | 17.3457 | 17.3061 | 17.3403 | 4619356.0 |
> showing 50 of 350,097 rows — these rows as CSV