PREVIEW / stock_5min / 2014-04-02
file: by_date/stock_5min/2014/2014-04-02.parquet size: 5.5 MB rows: 364,772 symbols: 3,542
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-04-02 04:10:00 | AAPL | Stock | 19.3911 | 19.3929 | 19.3911 | 19.3929 | 8400.0 |
| 2014-04-02 04:30:00 | AAPL | Stock | 19.3961 | 19.3961 | 19.3961 | 19.3961 | 2800.0 |
| 2014-04-02 05:05:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 5600.0 |
| 2014-04-02 05:35:00 | AAPL | Stock | 19.3757 | 19.3757 | 19.3757 | 19.3757 | 3360.0 |
| 2014-04-02 05:45:00 | AAPL | Stock | 19.3757 | 19.3757 | 19.3757 | 19.3757 | 8400.0 |
| 2014-04-02 06:10:00 | AAPL | Stock | 19.3575 | 19.3575 | 19.3575 | 19.3575 | 2800.0 |
| 2014-04-02 06:15:00 | AAPL | Stock | 19.38 | 19.38 | 19.38 | 19.38 | 2800.0 |
| 2014-04-02 06:30:00 | AAPL | Stock | 19.3804 | 19.3804 | 19.3804 | 19.3804 | 16800.0 |
| 2014-04-02 06:35:00 | AAPL | Stock | 19.3804 | 19.3911 | 19.3804 | 19.3911 | 8400.0 |
| 2014-04-02 06:55:00 | AAPL | Stock | 19.3807 | 19.3807 | 19.3807 | 19.3807 | 4200.0 |
| 2014-04-02 07:00:00 | AAPL | Stock | 19.3804 | 19.3804 | 19.3804 | 19.3804 | 16800.0 |
| 2014-04-02 07:10:00 | AAPL | Stock | 19.3875 | 19.3875 | 19.3875 | 19.3875 | 5600.0 |
| 2014-04-02 07:15:00 | AAPL | Stock | 19.3925 | 19.4018 | 19.3925 | 19.4018 | 8400.0 |
| 2014-04-02 07:20:00 | AAPL | Stock | 19.3879 | 19.3932 | 19.3879 | 19.3932 | 31612.0 |
| 2014-04-02 07:35:00 | AAPL | Stock | 19.3857 | 19.3857 | 19.3857 | 19.3857 | 5880.0 |
| 2014-04-02 07:40:00 | AAPL | Stock | 19.3854 | 19.3854 | 19.3854 | 19.3854 | 5600.0 |
| 2014-04-02 07:45:00 | AAPL | Stock | 19.375 | 19.375 | 19.3736 | 19.3736 | 22400.0 |
| 2014-04-02 07:50:00 | AAPL | Stock | 19.3668 | 19.3686 | 19.3571 | 19.3657 | 38920.0 |
| 2014-04-02 07:55:00 | AAPL | Stock | 19.3575 | 19.3575 | 19.3575 | 19.3575 | 5600.0 |
| 2014-04-02 08:00:00 | AAPL | Stock | 19.3643 | 19.395 | 19.3471 | 19.35 | 183876.0 |
| 2014-04-02 08:05:00 | AAPL | Stock | 19.3536 | 19.3589 | 19.3536 | 19.3571 | 81760.0 |
| 2014-04-02 08:10:00 | AAPL | Stock | 19.3571 | 19.3629 | 19.3571 | 19.3629 | 5740.0 |
| 2014-04-02 08:15:00 | AAPL | Stock | 19.3646 | 19.3996 | 19.3646 | 19.3996 | 129024.0 |
| 2014-04-02 08:20:00 | AAPL | Stock | 19.3929 | 19.4021 | 19.3929 | 19.4 | 121296.0 |
| 2014-04-02 08:25:00 | AAPL | Stock | 19.3771 | 19.3804 | 19.3768 | 19.3804 | 12600.0 |
| 2014-04-02 08:30:00 | AAPL | Stock | 19.3789 | 19.3886 | 19.3743 | 19.3743 | 89768.0 |
| 2014-04-02 08:35:00 | AAPL | Stock | 19.3746 | 19.375 | 19.3643 | 19.375 | 56056.0 |
| 2014-04-02 08:40:00 | AAPL | Stock | 19.3786 | 19.3786 | 19.3786 | 19.3786 | 2800.0 |
| 2014-04-02 08:45:00 | AAPL | Stock | 19.3696 | 19.3696 | 19.3643 | 19.3679 | 74956.0 |
| 2014-04-02 08:50:00 | AAPL | Stock | 19.3643 | 19.3646 | 19.3643 | 19.3643 | 32956.0 |
| 2014-04-02 08:55:00 | AAPL | Stock | 19.3643 | 19.3689 | 19.3639 | 19.3639 | 14000.0 |
| 2014-04-02 09:00:00 | AAPL | Stock | 19.3668 | 19.3889 | 19.3661 | 19.3846 | 109480.0 |
| 2014-04-02 09:05:00 | AAPL | Stock | 19.375 | 19.3786 | 19.3721 | 19.3786 | 28000.0 |
| 2014-04-02 09:10:00 | AAPL | Stock | 19.3775 | 19.3843 | 19.375 | 19.375 | 83020.0 |
| 2014-04-02 09:15:00 | AAPL | Stock | 19.3689 | 19.3689 | 19.3661 | 19.3661 | 36400.0 |
| 2014-04-02 09:20:00 | AAPL | Stock | 19.3661 | 19.3843 | 19.3661 | 19.3843 | 98448.0 |
| 2014-04-02 09:25:00 | AAPL | Stock | 19.3839 | 19.3925 | 19.3664 | 19.3739 | 413336.0 |
| 2014-04-02 09:30:00 | AAPL | Stock | 19.3707 | 19.3989 | 19.3214 | 19.3489 | 9445184.0 |
| 2014-04-02 09:35:00 | AAPL | Stock | 19.3504 | 19.3554 | 19.3257 | 19.3368 | 4693836.0 |
| 2014-04-02 09:40:00 | AAPL | Stock | 19.3343 | 19.3621 | 19.3082 | 19.3321 | 5075700.0 |
| 2014-04-02 09:45:00 | AAPL | Stock | 19.3311 | 19.3589 | 19.3286 | 19.3432 | 4296880.0 |
| 2014-04-02 09:50:00 | AAPL | Stock | 19.3445 | 19.3535 | 19.3143 | 19.3182 | 3378480.0 |
| 2014-04-02 09:55:00 | AAPL | Stock | 19.3164 | 19.3354 | 19.2961 | 19.3036 | 3223416.0 |
| 2014-04-02 10:00:00 | AAPL | Stock | 19.3036 | 19.3475 | 19.2968 | 19.3421 | 2958620.0 |
| 2014-04-02 10:05:00 | AAPL | Stock | 19.3404 | 19.3575 | 19.3254 | 19.335 | 2336124.0 |
| 2014-04-02 10:10:00 | AAPL | Stock | 19.3396 | 19.3475 | 19.3071 | 19.3214 | 2524340.0 |
| 2014-04-02 10:15:00 | AAPL | Stock | 19.3193 | 19.3425 | 19.3107 | 19.3297 | 1303204.0 |
| 2014-04-02 10:20:00 | AAPL | Stock | 19.3386 | 19.3611 | 19.3243 | 19.3311 | 3697036.0 |
| 2014-04-02 10:25:00 | AAPL | Stock | 19.3304 | 19.3525 | 19.3277 | 19.3511 | 1194844.0 |
| 2014-04-02 10:30:00 | AAPL | Stock | 19.3507 | 19.3571 | 19.3336 | 19.3475 | 1933708.0 |
> showing 50 of 364,772 rows — these rows as CSV