PREVIEW / stock_5min / 2011-03-31
file: by_date/stock_5min/2011/2011-03-31.parquet size: 4.9 MB rows: 332,168 symbols: 3,535
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-03-31 04:00:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 2800.0 |
| 2011-03-31 04:10:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 2800.0 |
| 2011-03-31 04:55:00 | AAPL | Stock | 12.4639 | 12.4639 | 12.4639 | 12.4639 | 2800.0 |
| 2011-03-31 05:00:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 5600.0 |
| 2011-03-31 05:05:00 | AAPL | Stock | 12.4607 | 12.4607 | 12.4607 | 12.4607 | 2800.0 |
| 2011-03-31 05:20:00 | AAPL | Stock | 12.4429 | 12.4429 | 12.4429 | 12.4429 | 2800.0 |
| 2011-03-31 05:55:00 | AAPL | Stock | 12.4607 | 12.4639 | 12.4607 | 12.4639 | 5600.0 |
| 2011-03-31 06:30:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4393 | 12.4393 | 2800.0 |
| 2011-03-31 06:55:00 | AAPL | Stock | 12.4314 | 12.4314 | 12.4314 | 12.4314 | 2800.0 |
| 2011-03-31 07:00:00 | AAPL | Stock | 12.4143 | 12.4143 | 12.4104 | 12.4107 | 38248.0 |
| 2011-03-31 07:15:00 | AAPL | Stock | 12.4107 | 12.4279 | 12.4107 | 12.4275 | 8400.0 |
| 2011-03-31 07:20:00 | AAPL | Stock | 12.4111 | 12.4111 | 12.4089 | 12.4089 | 22400.0 |
| 2011-03-31 07:25:00 | AAPL | Stock | 12.4168 | 12.4168 | 12.4168 | 12.4168 | 5600.0 |
| 2011-03-31 07:30:00 | AAPL | Stock | 12.4143 | 12.4171 | 12.4143 | 12.4171 | 17668.0 |
| 2011-03-31 07:35:00 | AAPL | Stock | 12.4171 | 12.4171 | 12.4068 | 12.4079 | 44744.0 |
| 2011-03-31 07:50:00 | AAPL | Stock | 12.4061 | 12.4068 | 12.4032 | 12.4032 | 17584.0 |
| 2011-03-31 07:55:00 | AAPL | Stock | 12.4107 | 12.4132 | 12.4107 | 12.4132 | 16800.0 |
| 2011-03-31 08:00:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.3968 | 12.3968 | 111692.0 |
| 2011-03-31 08:05:00 | AAPL | Stock | 12.3968 | 12.3971 | 12.3939 | 12.3939 | 155120.0 |
| 2011-03-31 08:10:00 | AAPL | Stock | 12.3939 | 12.3964 | 12.3843 | 12.3964 | 239848.0 |
| 2011-03-31 08:15:00 | AAPL | Stock | 12.3993 | 12.3993 | 12.3632 | 12.3632 | 465024.0 |
| 2011-03-31 08:20:00 | AAPL | Stock | 12.3664 | 12.3786 | 12.3664 | 12.3786 | 117936.0 |
| 2011-03-31 08:25:00 | AAPL | Stock | 12.3857 | 12.3982 | 12.3857 | 12.3857 | 116480.0 |
| 2011-03-31 08:30:00 | AAPL | Stock | 12.3857 | 12.3925 | 12.3821 | 12.3925 | 68600.0 |
| 2011-03-31 08:35:00 | AAPL | Stock | 12.3875 | 12.3893 | 12.3846 | 12.3861 | 34440.0 |
| 2011-03-31 08:40:00 | AAPL | Stock | 12.3907 | 12.3964 | 12.3893 | 12.3929 | 158704.0 |
| 2011-03-31 08:45:00 | AAPL | Stock | 12.3929 | 12.3932 | 12.3821 | 12.3821 | 164780.0 |
| 2011-03-31 08:50:00 | AAPL | Stock | 12.3829 | 12.3857 | 12.3786 | 12.3786 | 61600.0 |
| 2011-03-31 08:55:00 | AAPL | Stock | 12.3854 | 12.3854 | 12.375 | 12.3836 | 49700.0 |
| 2011-03-31 09:00:00 | AAPL | Stock | 12.3821 | 12.3904 | 12.3821 | 12.3889 | 93576.0 |
| 2011-03-31 09:05:00 | AAPL | Stock | 12.3886 | 12.3886 | 12.3779 | 12.3821 | 60620.0 |
| 2011-03-31 09:10:00 | AAPL | Stock | 12.3821 | 12.3832 | 12.3671 | 12.3671 | 71540.0 |
| 2011-03-31 09:15:00 | AAPL | Stock | 12.3714 | 12.3757 | 12.3714 | 12.3746 | 55972.0 |
| 2011-03-31 09:20:00 | AAPL | Stock | 12.3746 | 12.3746 | 12.3661 | 12.3661 | 156744.0 |
| 2011-03-31 09:25:00 | AAPL | Stock | 12.3661 | 12.3718 | 12.3596 | 12.3675 | 620172.0 |
| 2011-03-31 09:30:00 | AAPL | Stock | 12.3675 | 12.4446 | 12.3593 | 12.4436 | 11905628.0 |
| 2011-03-31 09:35:00 | AAPL | Stock | 12.4436 | 12.4668 | 12.4293 | 12.4611 | 11347252.0 |
| 2011-03-31 09:40:00 | AAPL | Stock | 12.4636 | 12.4929 | 12.4636 | 12.4807 | 11106592.0 |
| 2011-03-31 09:45:00 | AAPL | Stock | 12.4818 | 12.4818 | 12.4543 | 12.4611 | 7660100.0 |
| 2011-03-31 09:50:00 | AAPL | Stock | 12.4618 | 12.4696 | 12.4386 | 12.4564 | 7037912.0 |
| 2011-03-31 09:55:00 | AAPL | Stock | 12.4555 | 12.4671 | 12.4475 | 12.4532 | 2980852.0 |
| 2011-03-31 10:00:00 | AAPL | Stock | 12.4532 | 12.4714 | 12.4268 | 12.4339 | 6975556.0 |
| 2011-03-31 10:05:00 | AAPL | Stock | 12.4307 | 12.4421 | 12.4221 | 12.4357 | 4157664.0 |
| 2011-03-31 10:10:00 | AAPL | Stock | 12.4357 | 12.4361 | 12.4136 | 12.4304 | 4432064.0 |
| 2011-03-31 10:15:00 | AAPL | Stock | 12.4307 | 12.4429 | 12.4225 | 12.4368 | 3566976.0 |
| 2011-03-31 10:20:00 | AAPL | Stock | 12.4371 | 12.46 | 12.4339 | 12.4543 | 4118828.0 |
| 2011-03-31 10:25:00 | AAPL | Stock | 12.4557 | 12.4589 | 12.4443 | 12.4482 | 2422028.0 |
| 2011-03-31 10:30:00 | AAPL | Stock | 12.4479 | 12.4661 | 12.4479 | 12.4661 | 3411380.0 |
| 2011-03-31 10:35:00 | AAPL | Stock | 12.4661 | 12.4775 | 12.4636 | 12.4721 | 3532004.0 |
| 2011-03-31 10:40:00 | AAPL | Stock | 12.4718 | 12.4748 | 12.4621 | 12.4668 | 2233644.0 |
> showing 50 of 332,168 rows — these rows as CSV