PREVIEW / stock_5min / 2011-10-31
file: by_date/stock_5min/2011/2011-10-31.parquet size: 4.8 MB rows: 321,413 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 |
|---|---|---|---|---|---|---|---|
| 2011-10-31 04:45:00 | AAPL | Stock | 14.3929 | 14.4046 | 14.3929 | 14.4046 | 9800.0 |
| 2011-10-31 04:55:00 | AAPL | Stock | 14.3818 | 14.3818 | 14.3818 | 14.3818 | 5600.0 |
| 2011-10-31 05:00:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 5600.0 |
| 2011-10-31 05:30:00 | AAPL | Stock | 14.3393 | 14.3393 | 14.3393 | 14.3393 | 2800.0 |
| 2011-10-31 05:35:00 | AAPL | Stock | 14.3393 | 14.3393 | 14.3393 | 14.3393 | 22400.0 |
| 2011-10-31 05:40:00 | AAPL | Stock | 14.3393 | 14.3393 | 14.3393 | 14.3393 | 2800.0 |
| 2011-10-31 05:50:00 | AAPL | Stock | 14.3268 | 14.3275 | 14.3268 | 14.3275 | 8400.0 |
| 2011-10-31 06:00:00 | AAPL | Stock | 14.3143 | 14.3143 | 14.3125 | 14.3125 | 30800.0 |
| 2011-10-31 06:10:00 | AAPL | Stock | 14.3132 | 14.3132 | 14.3132 | 14.3132 | 4900.0 |
| 2011-10-31 06:50:00 | AAPL | Stock | 14.3321 | 14.3321 | 14.3321 | 14.3321 | 5404.0 |
| 2011-10-31 07:00:00 | AAPL | Stock | 14.3318 | 14.3321 | 14.3318 | 14.3321 | 8400.0 |
| 2011-10-31 07:05:00 | AAPL | Stock | 14.3482 | 14.3571 | 14.3482 | 14.3571 | 22400.0 |
| 2011-10-31 07:10:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3482 | 14.3482 | 5600.0 |
| 2011-10-31 07:15:00 | AAPL | Stock | 14.3371 | 14.34 | 14.3357 | 14.3357 | 14224.0 |
| 2011-10-31 07:20:00 | AAPL | Stock | 14.3393 | 14.3393 | 14.3321 | 14.3393 | 48020.0 |
| 2011-10-31 07:25:00 | AAPL | Stock | 14.3489 | 14.3489 | 14.3489 | 14.3489 | 2800.0 |
| 2011-10-31 07:35:00 | AAPL | Stock | 14.3414 | 14.3414 | 14.3411 | 14.3411 | 22400.0 |
| 2011-10-31 07:50:00 | AAPL | Stock | 14.3625 | 14.3661 | 14.3625 | 14.3661 | 14000.0 |
| 2011-10-31 07:55:00 | AAPL | Stock | 14.3429 | 14.3618 | 14.3429 | 14.3618 | 55720.0 |
| 2011-10-31 08:00:00 | AAPL | Stock | 14.3636 | 14.4061 | 14.3571 | 14.3929 | 236908.0 |
| 2011-10-31 08:05:00 | AAPL | Stock | 14.4021 | 14.4021 | 14.3839 | 14.3857 | 144676.0 |
| 2011-10-31 08:10:00 | AAPL | Stock | 14.3843 | 14.385 | 14.3839 | 14.3839 | 79016.0 |
| 2011-10-31 08:15:00 | AAPL | Stock | 14.3839 | 14.3839 | 14.38 | 14.3814 | 30800.0 |
| 2011-10-31 08:20:00 | AAPL | Stock | 14.3814 | 14.3814 | 14.3771 | 14.3771 | 47600.0 |
| 2011-10-31 08:25:00 | AAPL | Stock | 14.3839 | 14.3839 | 14.375 | 14.3768 | 67200.0 |
| 2011-10-31 08:30:00 | AAPL | Stock | 14.3721 | 14.3721 | 14.3668 | 14.3668 | 18200.0 |
| 2011-10-31 08:35:00 | AAPL | Stock | 14.3614 | 14.3696 | 14.3561 | 14.3625 | 183260.0 |
| 2011-10-31 08:40:00 | AAPL | Stock | 14.3607 | 14.37 | 14.3607 | 14.37 | 56980.0 |
| 2011-10-31 08:45:00 | AAPL | Stock | 14.3714 | 14.3714 | 14.3571 | 14.3571 | 41356.0 |
| 2011-10-31 08:50:00 | AAPL | Stock | 14.3596 | 14.3607 | 14.3529 | 14.3529 | 66248.0 |
| 2011-10-31 08:55:00 | AAPL | Stock | 14.3529 | 14.3746 | 14.3529 | 14.3746 | 58548.0 |
| 2011-10-31 09:00:00 | AAPL | Stock | 14.3714 | 14.3775 | 14.3646 | 14.3654 | 66920.0 |
| 2011-10-31 09:05:00 | AAPL | Stock | 14.3643 | 14.3654 | 14.3571 | 14.3575 | 146524.0 |
| 2011-10-31 09:10:00 | AAPL | Stock | 14.3636 | 14.3721 | 14.3636 | 14.3718 | 46648.0 |
| 2011-10-31 09:15:00 | AAPL | Stock | 14.3814 | 14.3814 | 14.3718 | 14.3718 | 25424.0 |
| 2011-10-31 09:20:00 | AAPL | Stock | 14.3714 | 14.3796 | 14.3711 | 14.3711 | 87052.0 |
| 2011-10-31 09:25:00 | AAPL | Stock | 14.3714 | 14.3754 | 14.3407 | 14.3707 | 526428.0 |
| 2011-10-31 09:30:00 | AAPL | Stock | 14.3714 | 14.4036 | 14.3232 | 14.3515 | 13643560.0 |
| 2011-10-31 09:35:00 | AAPL | Stock | 14.3557 | 14.3661 | 14.3396 | 14.3589 | 6731928.0 |
| 2011-10-31 09:40:00 | AAPL | Stock | 14.3593 | 14.3729 | 14.3457 | 14.3575 | 5520060.0 |
| 2011-10-31 09:45:00 | AAPL | Stock | 14.3579 | 14.3814 | 14.3407 | 14.3664 | 6702192.0 |
| 2011-10-31 09:50:00 | AAPL | Stock | 14.3661 | 14.4 | 14.3611 | 14.3964 | 7604492.0 |
| 2011-10-31 09:55:00 | AAPL | Stock | 14.3961 | 14.4286 | 14.3768 | 14.4271 | 6935320.0 |
| 2011-10-31 10:00:00 | AAPL | Stock | 14.4284 | 14.435 | 14.4114 | 14.4332 | 5190752.0 |
| 2011-10-31 10:05:00 | AAPL | Stock | 14.435 | 14.4596 | 14.433 | 14.4529 | 6417488.0 |
| 2011-10-31 10:10:00 | AAPL | Stock | 14.4511 | 14.4821 | 14.4414 | 14.4807 | 8590008.0 |
| 2011-10-31 10:15:00 | AAPL | Stock | 14.4807 | 14.5268 | 14.4732 | 14.5043 | 10987564.0 |
| 2011-10-31 10:20:00 | AAPL | Stock | 14.5057 | 14.52 | 14.495 | 14.495 | 6737472.0 |
| 2011-10-31 10:25:00 | AAPL | Stock | 14.4957 | 14.5132 | 14.4939 | 14.5018 | 3477824.0 |
| 2011-10-31 10:30:00 | AAPL | Stock | 14.505 | 14.5714 | 14.5032 | 14.5436 | 10312316.0 |
> showing 50 of 321,413 rows — these rows as CSV