PREVIEW / stock_1min / 2011-10-07
file: by_date/stock_1min/2011/2011-10-07.parquet size: 13.2 MB rows: 998,585 symbols: 2,814
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-10-07 04:37:00 | AAPL | Stock | 13.4996 | 13.4996 | 13.4996 | 13.4996 | 2800.0 |
| 2011-10-07 04:45:00 | AAPL | Stock | 13.4996 | 13.4996 | 13.4996 | 13.4996 | 2800.0 |
| 2011-10-07 04:46:00 | AAPL | Stock | 13.4925 | 13.4925 | 13.4925 | 13.4925 | 2800.0 |
| 2011-10-07 05:50:00 | AAPL | Stock | 13.4607 | 13.4607 | 13.4607 | 13.4607 | 5600.0 |
| 2011-10-07 05:52:00 | AAPL | Stock | 13.4493 | 13.4493 | 13.4493 | 13.4493 | 5600.0 |
| 2011-10-07 06:07:00 | AAPL | Stock | 13.4461 | 13.4461 | 13.4461 | 13.4461 | 2800.0 |
| 2011-10-07 06:27:00 | AAPL | Stock | 13.4236 | 13.4236 | 13.4236 | 13.4236 | 2800.0 |
| 2011-10-07 07:10:00 | AAPL | Stock | 13.4521 | 13.4521 | 13.4139 | 13.4443 | 22820.0 |
| 2011-10-07 07:19:00 | AAPL | Stock | 13.4457 | 13.4457 | 13.4218 | 13.4218 | 15708.0 |
| 2011-10-07 07:23:00 | AAPL | Stock | 13.4286 | 13.4286 | 13.4286 | 13.4286 | 2800.0 |
| 2011-10-07 07:28:00 | AAPL | Stock | 13.4286 | 13.4286 | 13.4246 | 13.4246 | 39200.0 |
| 2011-10-07 07:30:00 | AAPL | Stock | 13.4107 | 13.4107 | 13.4107 | 13.4107 | 2800.0 |
| 2011-10-07 07:33:00 | AAPL | Stock | 13.425 | 13.425 | 13.425 | 13.425 | 2800.0 |
| 2011-10-07 07:46:00 | AAPL | Stock | 13.435 | 13.435 | 13.4204 | 13.4204 | 35000.0 |
| 2011-10-07 07:47:00 | AAPL | Stock | 13.4346 | 13.4346 | 13.4346 | 13.4346 | 2800.0 |
| 2011-10-07 07:49:00 | AAPL | Stock | 13.4289 | 13.4289 | 13.4286 | 13.4286 | 14000.0 |
| 2011-10-07 07:58:00 | AAPL | Stock | 13.435 | 13.435 | 13.435 | 13.435 | 2800.0 |
| 2011-10-07 07:59:00 | AAPL | Stock | 13.425 | 13.425 | 13.425 | 13.425 | 6720.0 |
| 2011-10-07 08:00:00 | AAPL | Stock | 13.4286 | 13.4286 | 13.4254 | 13.4286 | 34300.0 |
| 2011-10-07 08:01:00 | AAPL | Stock | 13.435 | 13.4357 | 13.435 | 13.4357 | 48020.0 |
| 2011-10-07 08:02:00 | AAPL | Stock | 13.4286 | 13.4286 | 13.4286 | 13.4286 | 4760.0 |
| 2011-10-07 08:04:00 | AAPL | Stock | 13.4321 | 13.4357 | 13.4321 | 13.4357 | 5600.0 |
| 2011-10-07 08:06:00 | AAPL | Stock | 13.4357 | 13.4357 | 13.4286 | 13.4304 | 30604.0 |
| 2011-10-07 08:07:00 | AAPL | Stock | 13.4304 | 13.4304 | 13.4304 | 13.4304 | 5600.0 |
| 2011-10-07 08:09:00 | AAPL | Stock | 13.4311 | 13.4311 | 13.4311 | 13.4311 | 2800.0 |
| 2011-10-07 08:12:00 | AAPL | Stock | 13.4311 | 13.4311 | 13.4304 | 13.4304 | 18732.0 |
| 2011-10-07 08:13:00 | AAPL | Stock | 13.4293 | 13.4293 | 13.4221 | 13.4257 | 36568.0 |
| 2011-10-07 08:14:00 | AAPL | Stock | 13.4232 | 13.4279 | 13.4232 | 13.4279 | 14000.0 |
| 2011-10-07 08:15:00 | AAPL | Stock | 13.4286 | 13.4346 | 13.4286 | 13.4346 | 47600.0 |
| 2011-10-07 08:16:00 | AAPL | Stock | 13.4375 | 13.4393 | 13.4375 | 13.4393 | 7728.0 |
| 2011-10-07 08:17:00 | AAPL | Stock | 13.4304 | 13.4304 | 13.4304 | 13.4304 | 2800.0 |
| 2011-10-07 08:18:00 | AAPL | Stock | 13.4411 | 13.4421 | 13.4411 | 13.4421 | 32228.0 |
| 2011-10-07 08:19:00 | AAPL | Stock | 13.4314 | 13.4346 | 13.4314 | 13.4346 | 5600.0 |
| 2011-10-07 08:20:00 | AAPL | Stock | 13.4386 | 13.4386 | 13.4354 | 13.4386 | 19600.0 |
| 2011-10-07 08:21:00 | AAPL | Stock | 13.4354 | 13.4393 | 13.4354 | 13.4375 | 51800.0 |
| 2011-10-07 08:22:00 | AAPL | Stock | 13.4393 | 13.4421 | 13.4375 | 13.4421 | 84560.0 |
| 2011-10-07 08:23:00 | AAPL | Stock | 13.4379 | 13.4393 | 13.4379 | 13.4393 | 11200.0 |
| 2011-10-07 08:24:00 | AAPL | Stock | 13.4346 | 13.4346 | 13.4339 | 13.4339 | 16800.0 |
| 2011-10-07 08:25:00 | AAPL | Stock | 13.4339 | 13.4375 | 13.4339 | 13.4375 | 22400.0 |
| 2011-10-07 08:26:00 | AAPL | Stock | 13.4418 | 13.4461 | 13.4418 | 13.4429 | 38640.0 |
| 2011-10-07 08:27:00 | AAPL | Stock | 13.4429 | 13.4429 | 13.4429 | 13.4429 | 2800.0 |
| 2011-10-07 08:28:00 | AAPL | Stock | 13.4439 | 13.4443 | 13.4439 | 13.4439 | 8400.0 |
| 2011-10-07 08:29:00 | AAPL | Stock | 13.4443 | 13.4443 | 13.4443 | 13.4443 | 2800.0 |
| 2011-10-07 08:30:00 | AAPL | Stock | 13.4561 | 13.545 | 13.4554 | 13.4789 | 1012592.0 |
| 2011-10-07 08:31:00 | AAPL | Stock | 13.4796 | 13.5357 | 13.4796 | 13.5214 | 278936.0 |
| 2011-10-07 08:32:00 | AAPL | Stock | 13.5075 | 13.5154 | 13.4893 | 13.4893 | 370944.0 |
| 2011-10-07 08:33:00 | AAPL | Stock | 13.4964 | 13.51 | 13.4839 | 13.4932 | 180880.0 |
| 2011-10-07 08:34:00 | AAPL | Stock | 13.4868 | 13.4971 | 13.4739 | 13.4871 | 201544.0 |
| 2011-10-07 08:35:00 | AAPL | Stock | 13.4871 | 13.4993 | 13.4804 | 13.4993 | 194460.0 |
| 2011-10-07 08:36:00 | AAPL | Stock | 13.4964 | 13.5214 | 13.4964 | 13.5207 | 225232.0 |
> showing 50 of 998,585 rows — these rows as CSV