PREVIEW / stock_1min / 2014-01-21
file: by_date/stock_1min/2014/2014-01-21.parquet size: 15.2 MB rows: 1,084,105 symbols: 2,875
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-01-21 04:00:00 | AAPL | Stock | 19.3107 | 19.3929 | 19.3107 | 19.3571 | 18620.0 |
| 2014-01-21 04:11:00 | AAPL | Stock | 19.3571 | 19.3643 | 19.3571 | 19.3589 | 8624.0 |
| 2014-01-21 04:16:00 | AAPL | Stock | 19.3589 | 19.3589 | 19.3589 | 19.3589 | 2800.0 |
| 2014-01-21 04:18:00 | AAPL | Stock | 19.3782 | 19.3782 | 19.3782 | 19.3782 | 2800.0 |
| 2014-01-21 04:29:00 | AAPL | Stock | 19.3629 | 19.3629 | 19.3629 | 19.3629 | 6300.0 |
| 2014-01-21 04:36:00 | AAPL | Stock | 19.3607 | 19.3607 | 19.3607 | 19.3607 | 4480.0 |
| 2014-01-21 04:37:00 | AAPL | Stock | 19.37 | 19.37 | 19.37 | 19.37 | 2800.0 |
| 2014-01-21 05:00:00 | AAPL | Stock | 19.3704 | 19.3704 | 19.3704 | 19.3704 | 2800.0 |
| 2014-01-21 05:07:00 | AAPL | Stock | 19.3729 | 19.375 | 19.3729 | 19.375 | 8400.0 |
| 2014-01-21 05:14:00 | AAPL | Stock | 19.375 | 19.3786 | 19.375 | 19.3786 | 11956.0 |
| 2014-01-21 05:17:00 | AAPL | Stock | 19.3764 | 19.3764 | 19.3764 | 19.3764 | 2800.0 |
| 2014-01-21 05:18:00 | AAPL | Stock | 19.375 | 19.375 | 19.375 | 19.375 | 5600.0 |
| 2014-01-21 05:19:00 | AAPL | Stock | 19.375 | 19.375 | 19.375 | 19.375 | 5600.0 |
| 2014-01-21 05:25:00 | AAPL | Stock | 19.3921 | 19.3921 | 19.3921 | 19.3921 | 28000.0 |
| 2014-01-21 05:26:00 | AAPL | Stock | 19.4086 | 19.4107 | 19.4086 | 19.4107 | 7392.0 |
| 2014-01-21 05:31:00 | AAPL | Stock | 19.3861 | 19.4004 | 19.3861 | 19.4004 | 5600.0 |
| 2014-01-21 05:32:00 | AAPL | Stock | 19.4007 | 19.4061 | 19.4007 | 19.4061 | 8400.0 |
| 2014-01-21 05:33:00 | AAPL | Stock | 19.4079 | 19.4079 | 19.4079 | 19.4079 | 5824.0 |
| 2014-01-21 05:38:00 | AAPL | Stock | 19.4079 | 19.4079 | 19.4079 | 19.4079 | 2800.0 |
| 2014-01-21 05:41:00 | AAPL | Stock | 19.4139 | 19.415 | 19.4139 | 19.415 | 26320.0 |
| 2014-01-21 05:52:00 | AAPL | Stock | 19.415 | 19.4161 | 19.415 | 19.4161 | 12684.0 |
| 2014-01-21 05:54:00 | AAPL | Stock | 19.4132 | 19.4132 | 19.4132 | 19.4132 | 2800.0 |
| 2014-01-21 06:08:00 | AAPL | Stock | 19.4093 | 19.4093 | 19.4093 | 19.4093 | 2800.0 |
| 2014-01-21 06:15:00 | AAPL | Stock | 19.4071 | 19.4071 | 19.4071 | 19.4071 | 2800.0 |
| 2014-01-21 06:17:00 | AAPL | Stock | 19.4179 | 19.4179 | 19.4143 | 19.4143 | 15400.0 |
| 2014-01-21 06:24:00 | AAPL | Stock | 19.4161 | 19.4161 | 19.4107 | 19.4107 | 17472.0 |
| 2014-01-21 06:39:00 | AAPL | Stock | 19.4071 | 19.4071 | 19.4071 | 19.4071 | 2800.0 |
| 2014-01-21 06:40:00 | AAPL | Stock | 19.4089 | 19.4089 | 19.4089 | 19.4089 | 19152.0 |
| 2014-01-21 06:42:00 | AAPL | Stock | 19.4071 | 19.4071 | 19.4071 | 19.4071 | 2800.0 |
| 2014-01-21 06:54:00 | AAPL | Stock | 19.4079 | 19.4079 | 19.4079 | 19.4079 | 2800.0 |
| 2014-01-21 06:55:00 | AAPL | Stock | 19.3929 | 19.3932 | 19.3929 | 19.3932 | 14000.0 |
| 2014-01-21 07:01:00 | AAPL | Stock | 19.3968 | 19.4071 | 19.3968 | 19.4071 | 5600.0 |
| 2014-01-21 07:02:00 | AAPL | Stock | 19.4071 | 19.4279 | 19.4071 | 19.4071 | 44800.0 |
| 2014-01-21 07:03:00 | AAPL | Stock | 19.4071 | 19.4071 | 19.4018 | 19.4018 | 29400.0 |
| 2014-01-21 07:10:00 | AAPL | Stock | 19.4 | 19.4 | 19.3893 | 19.3893 | 44800.0 |
| 2014-01-21 07:16:00 | AAPL | Stock | 19.3943 | 19.3943 | 19.3943 | 19.3943 | 2800.0 |
| 2014-01-21 07:17:00 | AAPL | Stock | 19.3893 | 19.3893 | 19.3893 | 19.3893 | 11200.0 |
| 2014-01-21 07:18:00 | AAPL | Stock | 19.3893 | 19.3893 | 19.3893 | 19.3893 | 11200.0 |
| 2014-01-21 07:22:00 | AAPL | Stock | 19.3821 | 19.3821 | 19.3821 | 19.3821 | 26236.0 |
| 2014-01-21 07:25:00 | AAPL | Stock | 19.3821 | 19.3821 | 19.3821 | 19.3821 | 18200.0 |
| 2014-01-21 07:26:00 | AAPL | Stock | 19.3821 | 19.3821 | 19.3821 | 19.3821 | 10640.0 |
| 2014-01-21 07:29:00 | AAPL | Stock | 19.3857 | 19.3857 | 19.3839 | 19.3839 | 16800.0 |
| 2014-01-21 07:30:00 | AAPL | Stock | 19.375 | 19.375 | 19.375 | 19.375 | 2800.0 |
| 2014-01-21 07:31:00 | AAPL | Stock | 19.3718 | 19.3786 | 19.3718 | 19.375 | 19600.0 |
| 2014-01-21 07:32:00 | AAPL | Stock | 19.3732 | 19.375 | 19.3714 | 19.3714 | 16800.0 |
| 2014-01-21 07:33:00 | AAPL | Stock | 19.375 | 19.375 | 19.375 | 19.375 | 8960.0 |
| 2014-01-21 07:34:00 | AAPL | Stock | 19.3714 | 19.3714 | 19.355 | 19.355 | 22400.0 |
| 2014-01-21 07:36:00 | AAPL | Stock | 19.3561 | 19.3571 | 19.3561 | 19.3571 | 8400.0 |
| 2014-01-21 07:38:00 | AAPL | Stock | 19.3586 | 19.3586 | 19.3571 | 19.3571 | 26740.0 |
| 2014-01-21 07:39:00 | AAPL | Stock | 19.3493 | 19.3493 | 19.3479 | 19.3479 | 8400.0 |
> showing 50 of 1,084,105 rows — these rows as CSV