PREVIEW / stock_5min / 2010-08-05
file: by_date/stock_5min/2010/2010-08-05.parquet size: 4.6 MB rows: 316,568 symbols: 3,462
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-05 04:00:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 8400.0 |
| 2010-08-05 05:55:00 | AAPL | Stock | 9.4018 | 9.4018 | 9.4018 | 9.4018 | 17500.0 |
| 2010-08-05 07:00:00 | AAPL | Stock | 9.4193 | 9.4193 | 9.4193 | 9.4193 | 8400.0 |
| 2010-08-05 07:05:00 | AAPL | Stock | 9.4196 | 9.4286 | 9.4196 | 9.4286 | 14000.0 |
| 2010-08-05 07:10:00 | AAPL | Stock | 9.4282 | 9.4282 | 9.4282 | 9.4282 | 2800.0 |
| 2010-08-05 07:20:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4018 | 9.4018 | 120204.0 |
| 2010-08-05 07:25:00 | AAPL | Stock | 9.3964 | 9.3964 | 9.3964 | 9.3964 | 2800.0 |
| 2010-08-05 07:30:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4 | 9.4 | 8400.0 |
| 2010-08-05 07:40:00 | AAPL | Stock | 9.4246 | 9.4246 | 9.4229 | 9.4229 | 5600.0 |
| 2010-08-05 07:50:00 | AAPL | Stock | 9.4171 | 9.4171 | 9.4171 | 9.4171 | 2800.0 |
| 2010-08-05 07:55:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 2800.0 |
| 2010-08-05 08:00:00 | AAPL | Stock | 9.3971 | 9.4186 | 9.3971 | 9.4071 | 40460.0 |
| 2010-08-05 08:05:00 | AAPL | Stock | 9.4096 | 9.4111 | 9.4039 | 9.4039 | 253036.0 |
| 2010-08-05 08:10:00 | AAPL | Stock | 9.4036 | 9.41 | 9.4018 | 9.4025 | 101724.0 |
| 2010-08-05 08:15:00 | AAPL | Stock | 9.4071 | 9.4071 | 9.4036 | 9.4036 | 35000.0 |
| 2010-08-05 08:20:00 | AAPL | Stock | 9.4018 | 9.4018 | 9.3893 | 9.3936 | 268940.0 |
| 2010-08-05 08:25:00 | AAPL | Stock | 9.4011 | 9.4011 | 9.3996 | 9.3996 | 75180.0 |
| 2010-08-05 08:30:00 | AAPL | Stock | 9.385 | 9.3929 | 9.3754 | 9.385 | 1008308.0 |
| 2010-08-05 08:35:00 | AAPL | Stock | 9.3804 | 9.3807 | 9.3754 | 9.3804 | 364560.0 |
| 2010-08-05 08:40:00 | AAPL | Stock | 9.3818 | 9.3868 | 9.3775 | 9.3786 | 202244.0 |
| 2010-08-05 08:45:00 | AAPL | Stock | 9.3804 | 9.3804 | 9.3732 | 9.3782 | 222180.0 |
| 2010-08-05 08:50:00 | AAPL | Stock | 9.3771 | 9.3821 | 9.3757 | 9.3761 | 112840.0 |
| 2010-08-05 08:55:00 | AAPL | Stock | 9.3764 | 9.3782 | 9.3761 | 9.3768 | 30800.0 |
| 2010-08-05 09:00:00 | AAPL | Stock | 9.3768 | 9.3786 | 9.3671 | 9.3675 | 413140.0 |
| 2010-08-05 09:05:00 | AAPL | Stock | 9.3675 | 9.3743 | 9.3671 | 9.3693 | 98000.0 |
| 2010-08-05 09:10:00 | AAPL | Stock | 9.3704 | 9.3736 | 9.3668 | 9.3671 | 130424.0 |
| 2010-08-05 09:15:00 | AAPL | Stock | 9.3675 | 9.3686 | 9.3571 | 9.3571 | 618296.0 |
| 2010-08-05 09:20:00 | AAPL | Stock | 9.3579 | 9.3607 | 9.355 | 9.3575 | 210280.0 |
| 2010-08-05 09:25:00 | AAPL | Stock | 9.3561 | 9.3607 | 9.3396 | 9.3396 | 566776.0 |
| 2010-08-05 09:30:00 | AAPL | Stock | 9.3475 | 9.3761 | 9.3232 | 9.3443 | 13394416.0 |
| 2010-08-05 09:35:00 | AAPL | Stock | 9.3493 | 9.3704 | 9.3357 | 9.3643 | 7535920.0 |
| 2010-08-05 09:40:00 | AAPL | Stock | 9.3632 | 9.3868 | 9.3629 | 9.3832 | 8205064.0 |
| 2010-08-05 09:45:00 | AAPL | Stock | 9.382 | 9.3993 | 9.3757 | 9.39 | 9529100.0 |
| 2010-08-05 09:50:00 | AAPL | Stock | 9.3889 | 9.3911 | 9.3714 | 9.385 | 5835872.0 |
| 2010-08-05 09:55:00 | AAPL | Stock | 9.3871 | 9.39 | 9.3579 | 9.3582 | 5869220.0 |
| 2010-08-05 10:00:00 | AAPL | Stock | 9.3589 | 9.3736 | 9.3529 | 9.3668 | 6403012.0 |
| 2010-08-05 10:05:00 | AAPL | Stock | 9.3657 | 9.3729 | 9.3593 | 9.3629 | 4663932.0 |
| 2010-08-05 10:10:00 | AAPL | Stock | 9.3614 | 9.38 | 9.3614 | 9.3676 | 4451104.0 |
| 2010-08-05 10:15:00 | AAPL | Stock | 9.3686 | 9.3768 | 9.3571 | 9.3575 | 3491936.0 |
| 2010-08-05 10:20:00 | AAPL | Stock | 9.3571 | 9.3729 | 9.3529 | 9.3689 | 4356464.0 |
| 2010-08-05 10:25:00 | AAPL | Stock | 9.3689 | 9.3771 | 9.3607 | 9.3771 | 3299604.0 |
| 2010-08-05 10:30:00 | AAPL | Stock | 9.3757 | 9.3786 | 9.3582 | 9.3675 | 2961868.0 |
| 2010-08-05 10:35:00 | AAPL | Stock | 9.3682 | 9.3685 | 9.3511 | 9.3589 | 4179700.0 |
| 2010-08-05 10:40:00 | AAPL | Stock | 9.3607 | 9.3629 | 9.3493 | 9.3507 | 3443720.0 |
| 2010-08-05 10:45:00 | AAPL | Stock | 9.3493 | 9.3561 | 9.3404 | 9.3543 | 6233696.0 |
| 2010-08-05 10:50:00 | AAPL | Stock | 9.3539 | 9.3539 | 9.3307 | 9.3314 | 5829292.0 |
| 2010-08-05 10:55:00 | AAPL | Stock | 9.3307 | 9.3318 | 9.3171 | 9.3257 | 9537948.0 |
| 2010-08-05 11:00:00 | AAPL | Stock | 9.3262 | 9.3271 | 9.3114 | 9.3182 | 6271384.0 |
| 2010-08-05 11:05:00 | AAPL | Stock | 9.3179 | 9.3232 | 9.3054 | 9.3214 | 5495224.0 |
| 2010-08-05 11:10:00 | AAPL | Stock | 9.3225 | 9.332 | 9.3182 | 9.3318 | 4774140.0 |
> showing 50 of 316,568 rows — these rows as CSV