PREVIEW / stock_5min / 2012-02-06
file: by_date/stock_5min/2012/2012-02-06.parquet size: 4.8 MB rows: 324,951 symbols: 3,553
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-06 06:00:00 | AAPL | Stock | 16.3607 | 16.3607 | 16.3607 | 16.3607 | 5600.0 |
| 2012-02-06 06:25:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3571 | 16.3571 | 9520.0 |
| 2012-02-06 06:50:00 | AAPL | Stock | 16.3607 | 16.3607 | 16.3571 | 16.3571 | 8400.0 |
| 2012-02-06 07:00:00 | AAPL | Stock | 16.3654 | 16.3654 | 16.3654 | 16.3654 | 8400.0 |
| 2012-02-06 07:05:00 | AAPL | Stock | 16.3804 | 16.3804 | 16.3804 | 16.3804 | 5600.0 |
| 2012-02-06 07:10:00 | AAPL | Stock | 16.3643 | 16.3643 | 16.3643 | 16.3643 | 5600.0 |
| 2012-02-06 07:15:00 | AAPL | Stock | 16.3632 | 16.3679 | 16.3632 | 16.3679 | 7000.0 |
| 2012-02-06 07:20:00 | AAPL | Stock | 16.3768 | 16.3829 | 16.3768 | 16.3829 | 18508.0 |
| 2012-02-06 07:40:00 | AAPL | Stock | 16.3679 | 16.3679 | 16.3679 | 16.3679 | 2800.0 |
| 2012-02-06 07:55:00 | AAPL | Stock | 16.3593 | 16.3593 | 16.3582 | 16.3589 | 11200.0 |
| 2012-02-06 08:00:00 | AAPL | Stock | 16.3711 | 16.375 | 16.3711 | 16.3714 | 55468.0 |
| 2012-02-06 08:05:00 | AAPL | Stock | 16.3714 | 16.3714 | 16.3611 | 16.3679 | 48860.0 |
| 2012-02-06 08:10:00 | AAPL | Stock | 16.3846 | 16.3846 | 16.3679 | 16.3682 | 28700.0 |
| 2012-02-06 08:15:00 | AAPL | Stock | 16.3682 | 16.3714 | 16.3682 | 16.3682 | 16800.0 |
| 2012-02-06 08:20:00 | AAPL | Stock | 16.3689 | 16.37 | 16.3661 | 16.3661 | 36708.0 |
| 2012-02-06 08:25:00 | AAPL | Stock | 16.3671 | 16.3675 | 16.3643 | 16.3643 | 40012.0 |
| 2012-02-06 08:35:00 | AAPL | Stock | 16.3618 | 16.3618 | 16.3518 | 16.3571 | 147868.0 |
| 2012-02-06 08:40:00 | AAPL | Stock | 16.3518 | 16.3518 | 16.3443 | 16.3514 | 45500.0 |
| 2012-02-06 08:45:00 | AAPL | Stock | 16.35 | 16.35 | 16.35 | 16.35 | 46732.0 |
| 2012-02-06 08:50:00 | AAPL | Stock | 16.3571 | 16.3643 | 16.3571 | 16.3571 | 30912.0 |
| 2012-02-06 08:55:00 | AAPL | Stock | 16.3536 | 16.3539 | 16.3536 | 16.3539 | 5600.0 |
| 2012-02-06 09:00:00 | AAPL | Stock | 16.3496 | 16.3543 | 16.3479 | 16.3543 | 28000.0 |
| 2012-02-06 09:05:00 | AAPL | Stock | 16.3536 | 16.3607 | 16.3504 | 16.3504 | 148400.0 |
| 2012-02-06 09:10:00 | AAPL | Stock | 16.3564 | 16.3564 | 16.3511 | 16.3511 | 32900.0 |
| 2012-02-06 09:15:00 | AAPL | Stock | 16.35 | 16.3564 | 16.3468 | 16.3564 | 203616.0 |
| 2012-02-06 09:20:00 | AAPL | Stock | 16.3571 | 16.3625 | 16.3571 | 16.3607 | 173488.0 |
| 2012-02-06 09:25:00 | AAPL | Stock | 16.3571 | 16.3746 | 16.3571 | 16.3675 | 327740.0 |
| 2012-02-06 09:30:00 | AAPL | Stock | 16.365 | 16.4068 | 16.3646 | 16.3836 | 8040004.0 |
| 2012-02-06 09:35:00 | AAPL | Stock | 16.3837 | 16.3986 | 16.3679 | 16.3825 | 3806432.0 |
| 2012-02-06 09:40:00 | AAPL | Stock | 16.3825 | 16.3864 | 16.3643 | 16.3779 | 4224304.0 |
| 2012-02-06 09:45:00 | AAPL | Stock | 16.3759 | 16.41 | 16.3741 | 16.4096 | 3926356.0 |
| 2012-02-06 09:50:00 | AAPL | Stock | 16.4068 | 16.4528 | 16.4068 | 16.4379 | 10464720.0 |
| 2012-02-06 09:55:00 | AAPL | Stock | 16.4367 | 16.4743 | 16.4286 | 16.4639 | 6615476.0 |
| 2012-02-06 10:00:00 | AAPL | Stock | 16.4636 | 16.4714 | 16.4547 | 16.4646 | 4165924.0 |
| 2012-02-06 10:05:00 | AAPL | Stock | 16.4664 | 16.4779 | 16.4557 | 16.4646 | 4297692.0 |
| 2012-02-06 10:10:00 | AAPL | Stock | 16.4643 | 16.4761 | 16.4568 | 16.4662 | 3865204.0 |
| 2012-02-06 10:15:00 | AAPL | Stock | 16.4657 | 16.4704 | 16.4575 | 16.4625 | 2822092.0 |
| 2012-02-06 10:20:00 | AAPL | Stock | 16.4611 | 16.4693 | 16.4575 | 16.4668 | 1556744.0 |
| 2012-02-06 10:25:00 | AAPL | Stock | 16.4655 | 16.475 | 16.4625 | 16.4643 | 3133172.0 |
| 2012-02-06 10:30:00 | AAPL | Stock | 16.4643 | 16.4725 | 16.4557 | 16.4725 | 2683716.0 |
| 2012-02-06 10:35:00 | AAPL | Stock | 16.4714 | 16.4886 | 16.4689 | 16.4861 | 5086032.0 |
| 2012-02-06 10:40:00 | AAPL | Stock | 16.4885 | 16.4885 | 16.4704 | 16.4739 | 4053196.0 |
| 2012-02-06 10:45:00 | AAPL | Stock | 16.4739 | 16.4971 | 16.4707 | 16.4896 | 4450292.0 |
| 2012-02-06 10:50:00 | AAPL | Stock | 16.4896 | 16.5143 | 16.4877 | 16.5143 | 5223428.0 |
| 2012-02-06 10:55:00 | AAPL | Stock | 16.5136 | 16.5179 | 16.4982 | 16.5082 | 4945724.0 |
| 2012-02-06 11:00:00 | AAPL | Stock | 16.5082 | 16.5168 | 16.5004 | 16.5093 | 3202388.0 |
| 2012-02-06 11:05:00 | AAPL | Stock | 16.51 | 16.5279 | 16.5079 | 16.5275 | 4482296.0 |
| 2012-02-06 11:10:00 | AAPL | Stock | 16.5264 | 16.5318 | 16.5179 | 16.5243 | 2820244.0 |
| 2012-02-06 11:15:00 | AAPL | Stock | 16.5225 | 16.546 | 16.5199 | 16.5443 | 3854620.0 |
| 2012-02-06 11:20:00 | AAPL | Stock | 16.5443 | 16.5607 | 16.5375 | 16.5571 | 5045068.0 |
> showing 50 of 324,951 rows — these rows as CSV