PREVIEW / stock_1min / 2011-09-26
file: by_date/stock_1min/2011/2011-09-26.parquet size: 13.6 MB rows: 1,021,547 symbols: 2,852
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-09-26 04:00:00 | AAPL | Stock | 14.4321 | 14.4321 | 14.4321 | 14.4321 | 2800.0 |
| 2011-09-26 04:05:00 | AAPL | Stock | 14.3811 | 14.3811 | 14.3811 | 14.3811 | 11200.0 |
| 2011-09-26 04:18:00 | AAPL | Stock | 14.4046 | 14.4046 | 14.4046 | 14.4046 | 2800.0 |
| 2011-09-26 04:19:00 | AAPL | Stock | 14.4229 | 14.4229 | 14.4229 | 14.4229 | 2800.0 |
| 2011-09-26 04:21:00 | AAPL | Stock | 14.4582 | 14.4582 | 14.4582 | 14.4582 | 11200.0 |
| 2011-09-26 04:25:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 28000.0 |
| 2011-09-26 04:34:00 | AAPL | Stock | 14.4321 | 14.4321 | 14.4321 | 14.4321 | 9800.0 |
| 2011-09-26 04:35:00 | AAPL | Stock | 14.4321 | 14.4464 | 14.4321 | 14.4464 | 8400.0 |
| 2011-09-26 04:39:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 19600.0 |
| 2011-09-26 04:41:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 16800.0 |
| 2011-09-26 04:51:00 | AAPL | Stock | 14.46 | 14.46 | 14.46 | 14.46 | 2800.0 |
| 2011-09-26 04:57:00 | AAPL | Stock | 14.4932 | 14.4964 | 14.4932 | 14.4964 | 11200.0 |
| 2011-09-26 05:04:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-09-26 05:07:00 | AAPL | Stock | 14.4964 | 14.4964 | 14.4964 | 14.4964 | 2800.0 |
| 2011-09-26 05:11:00 | AAPL | Stock | 14.5257 | 14.5279 | 14.5257 | 14.5279 | 18200.0 |
| 2011-09-26 05:14:00 | AAPL | Stock | 14.5321 | 14.5321 | 14.5321 | 14.5321 | 33460.0 |
| 2011-09-26 05:15:00 | AAPL | Stock | 14.5321 | 14.5321 | 14.5321 | 14.5321 | 8400.0 |
| 2011-09-26 05:17:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 14000.0 |
| 2011-09-26 05:33:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 19600.0 |
| 2011-09-26 05:34:00 | AAPL | Stock | 14.5286 | 14.5286 | 14.5286 | 14.5286 | 2800.0 |
| 2011-09-26 05:38:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5 | 14.5 | 33684.0 |
| 2011-09-26 05:39:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 14000.0 |
| 2011-09-26 05:41:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-09-26 05:54:00 | AAPL | Stock | 14.5061 | 14.5061 | 14.5061 | 14.5061 | 2800.0 |
| 2011-09-26 05:55:00 | AAPL | Stock | 14.5054 | 14.5054 | 14.5054 | 14.5054 | 2800.0 |
| 2011-09-26 06:03:00 | AAPL | Stock | 14.4782 | 14.4821 | 14.4779 | 14.4821 | 53200.0 |
| 2011-09-26 06:04:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4786 | 14.4786 | 11200.0 |
| 2011-09-26 06:10:00 | AAPL | Stock | 14.4786 | 14.4786 | 14.4786 | 14.4786 | 2800.0 |
| 2011-09-26 06:25:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4636 | 14.4636 | 11200.0 |
| 2011-09-26 06:32:00 | AAPL | Stock | 14.4764 | 14.4764 | 14.4721 | 14.4732 | 29400.0 |
| 2011-09-26 06:34:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4286 | 14.4286 | 36400.0 |
| 2011-09-26 06:35:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 2800.0 |
| 2011-09-26 06:39:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 2800.0 |
| 2011-09-26 06:40:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 28000.0 |
| 2011-09-26 06:41:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 2800.0 |
| 2011-09-26 06:51:00 | AAPL | Stock | 14.4704 | 14.4704 | 14.4696 | 14.4696 | 5600.0 |
| 2011-09-26 06:56:00 | AAPL | Stock | 14.4868 | 14.4868 | 14.4789 | 14.4789 | 8400.0 |
| 2011-09-26 06:57:00 | AAPL | Stock | 14.4768 | 14.4768 | 14.4768 | 14.4768 | 11200.0 |
| 2011-09-26 06:58:00 | AAPL | Stock | 14.4571 | 14.4571 | 14.45 | 14.45 | 53760.0 |
| 2011-09-26 06:59:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 2800.0 |
| 2011-09-26 07:00:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4286 | 14.4411 | 151200.0 |
| 2011-09-26 07:01:00 | AAPL | Stock | 14.4411 | 14.4579 | 14.4207 | 14.4507 | 82880.0 |
| 2011-09-26 07:02:00 | AAPL | Stock | 14.4507 | 14.4643 | 14.4507 | 14.4643 | 49000.0 |
| 2011-09-26 07:03:00 | AAPL | Stock | 14.4814 | 14.4857 | 14.4643 | 14.4679 | 165200.0 |
| 2011-09-26 07:04:00 | AAPL | Stock | 14.475 | 14.4825 | 14.475 | 14.4821 | 33992.0 |
| 2011-09-26 07:05:00 | AAPL | Stock | 14.4679 | 14.4679 | 14.46 | 14.46 | 54208.0 |
| 2011-09-26 07:06:00 | AAPL | Stock | 14.4482 | 14.4482 | 14.4321 | 14.4482 | 77364.0 |
| 2011-09-26 07:07:00 | AAPL | Stock | 14.4354 | 14.4354 | 14.4232 | 14.4286 | 74452.0 |
| 2011-09-26 07:08:00 | AAPL | Stock | 14.4286 | 14.4411 | 14.4286 | 14.4411 | 33572.0 |
| 2011-09-26 07:09:00 | AAPL | Stock | 14.4482 | 14.4482 | 14.4289 | 14.4289 | 82600.0 |
> showing 50 of 1,021,547 rows — these rows as CSV