PREVIEW / stock_5min / 2014-02-19
file: by_date/stock_5min/2014/2014-02-19.parquet size: 5.5 MB rows: 359,868 symbols: 3,542
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-02-19 04:05:00 | AAPL | Stock | 19.5 | 19.5089 | 19.5 | 19.5089 | 16520.0 |
| 2014-02-19 05:45:00 | AAPL | Stock | 19.4925 | 19.4925 | 19.4911 | 19.4911 | 8400.0 |
| 2014-02-19 06:15:00 | AAPL | Stock | 19.4521 | 19.4521 | 19.4521 | 19.4521 | 2800.0 |
| 2014-02-19 06:25:00 | AAPL | Stock | 19.4243 | 19.4243 | 19.4243 | 19.4243 | 2800.0 |
| 2014-02-19 06:35:00 | AAPL | Stock | 19.4207 | 19.4207 | 19.4207 | 19.4207 | 3332.0 |
| 2014-02-19 06:50:00 | AAPL | Stock | 19.4286 | 19.4286 | 19.4286 | 19.4286 | 2800.0 |
| 2014-02-19 06:55:00 | AAPL | Stock | 19.4286 | 19.4286 | 19.4136 | 19.4171 | 8400.0 |
| 2014-02-19 07:00:00 | AAPL | Stock | 19.4196 | 19.4286 | 19.4196 | 19.4254 | 58800.0 |
| 2014-02-19 07:05:00 | AAPL | Stock | 19.4254 | 19.4254 | 19.4254 | 19.4254 | 5600.0 |
| 2014-02-19 07:10:00 | AAPL | Stock | 19.4196 | 19.4254 | 19.4196 | 19.4254 | 11900.0 |
| 2014-02-19 07:15:00 | AAPL | Stock | 19.4254 | 19.4254 | 19.4254 | 19.4254 | 2800.0 |
| 2014-02-19 07:25:00 | AAPL | Stock | 19.4286 | 19.4464 | 19.4218 | 19.4464 | 19740.0 |
| 2014-02-19 07:30:00 | AAPL | Stock | 19.4375 | 19.4375 | 19.4375 | 19.4375 | 8400.0 |
| 2014-02-19 07:40:00 | AAPL | Stock | 19.4568 | 19.4568 | 19.4464 | 19.4464 | 18200.0 |
| 2014-02-19 07:45:00 | AAPL | Stock | 19.4404 | 19.4404 | 19.4382 | 19.4389 | 11200.0 |
| 2014-02-19 07:50:00 | AAPL | Stock | 19.4575 | 19.4575 | 19.4464 | 19.4464 | 36400.0 |
| 2014-02-19 07:55:00 | AAPL | Stock | 19.4575 | 19.4625 | 19.4575 | 19.4589 | 24444.0 |
| 2014-02-19 08:00:00 | AAPL | Stock | 19.4643 | 19.4821 | 19.4286 | 19.4554 | 122696.0 |
| 2014-02-19 08:05:00 | AAPL | Stock | 19.4639 | 19.4639 | 19.46 | 19.4632 | 22400.0 |
| 2014-02-19 08:10:00 | AAPL | Stock | 19.4554 | 19.4632 | 19.4554 | 19.4625 | 18452.0 |
| 2014-02-19 08:15:00 | AAPL | Stock | 19.4579 | 19.4732 | 19.4536 | 19.4643 | 45892.0 |
| 2014-02-19 08:20:00 | AAPL | Stock | 19.4746 | 19.475 | 19.4746 | 19.475 | 8400.0 |
| 2014-02-19 08:25:00 | AAPL | Stock | 19.4682 | 19.4796 | 19.4643 | 19.4779 | 41748.0 |
| 2014-02-19 08:35:00 | AAPL | Stock | 19.4604 | 19.4604 | 19.4486 | 19.4604 | 23632.0 |
| 2014-02-19 08:40:00 | AAPL | Stock | 19.4621 | 19.4664 | 19.4607 | 19.4643 | 88928.0 |
| 2014-02-19 08:45:00 | AAPL | Stock | 19.4729 | 19.475 | 19.4654 | 19.475 | 61600.0 |
| 2014-02-19 08:50:00 | AAPL | Stock | 19.475 | 19.4754 | 19.475 | 19.4754 | 21000.0 |
| 2014-02-19 08:55:00 | AAPL | Stock | 19.4779 | 19.4796 | 19.4721 | 19.4796 | 25200.0 |
| 2014-02-19 09:00:00 | AAPL | Stock | 19.4682 | 19.4757 | 19.4682 | 19.4757 | 8904.0 |
| 2014-02-19 09:05:00 | AAPL | Stock | 19.4796 | 19.4871 | 19.4643 | 19.4643 | 112784.0 |
| 2014-02-19 09:10:00 | AAPL | Stock | 19.4614 | 19.4643 | 19.4614 | 19.4643 | 14000.0 |
| 2014-02-19 09:15:00 | AAPL | Stock | 19.4618 | 19.475 | 19.4586 | 19.4586 | 40600.0 |
| 2014-02-19 09:20:00 | AAPL | Stock | 19.4639 | 19.4693 | 19.4618 | 19.4693 | 19600.0 |
| 2014-02-19 09:25:00 | AAPL | Stock | 19.4575 | 19.4575 | 19.4293 | 19.4464 | 331240.0 |
| 2014-02-19 09:30:00 | AAPL | Stock | 19.4554 | 19.5318 | 19.432 | 19.4411 | 11410560.0 |
| 2014-02-19 09:35:00 | AAPL | Stock | 19.4393 | 19.475 | 19.3579 | 19.4689 | 9498524.0 |
| 2014-02-19 09:40:00 | AAPL | Stock | 19.4646 | 19.4904 | 19.4339 | 19.4439 | 4618432.0 |
| 2014-02-19 09:45:00 | AAPL | Stock | 19.4479 | 19.4625 | 19.4286 | 19.4436 | 3948784.0 |
| 2014-02-19 09:50:00 | AAPL | Stock | 19.4471 | 19.48 | 19.4232 | 19.4507 | 4632768.0 |
| 2014-02-19 09:55:00 | AAPL | Stock | 19.4507 | 19.4675 | 19.4336 | 19.4475 | 3084284.0 |
| 2014-02-19 10:00:00 | AAPL | Stock | 19.4493 | 19.4564 | 19.4018 | 19.4246 | 4646404.0 |
| 2014-02-19 10:05:00 | AAPL | Stock | 19.4307 | 19.4346 | 19.4075 | 19.4154 | 3340372.0 |
| 2014-02-19 10:10:00 | AAPL | Stock | 19.4139 | 19.4239 | 19.3957 | 19.4039 | 3926076.0 |
| 2014-02-19 10:15:00 | AAPL | Stock | 19.4036 | 19.4221 | 19.3839 | 19.3871 | 4137364.0 |
| 2014-02-19 10:20:00 | AAPL | Stock | 19.3871 | 19.3957 | 19.3607 | 19.3875 | 4734408.0 |
| 2014-02-19 10:25:00 | AAPL | Stock | 19.3893 | 19.4157 | 19.3857 | 19.4139 | 4790380.0 |
| 2014-02-19 10:30:00 | AAPL | Stock | 19.4139 | 19.4196 | 19.3954 | 19.4057 | 1985396.0 |
| 2014-02-19 10:35:00 | AAPL | Stock | 19.4068 | 19.4086 | 19.3861 | 19.3946 | 2240728.0 |
| 2014-02-19 10:40:00 | AAPL | Stock | 19.3964 | 19.4029 | 19.39 | 19.3929 | 1359064.0 |
| 2014-02-19 10:45:00 | AAPL | Stock | 19.3911 | 19.3968 | 19.3411 | 19.3489 | 3621044.0 |
> showing 50 of 359,868 rows — these rows as CSV