PREVIEW / stock_5min / 2011-10-07
file: by_date/stock_5min/2011/2011-10-07.parquet size: 4.7 MB rows: 320,336 symbols: 3,477
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:35: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.4925 | 13.4925 | 5600.0 |
| 2011-10-07 05:50:00 | AAPL | Stock | 13.4607 | 13.4607 | 13.4493 | 13.4493 | 11200.0 |
| 2011-10-07 06:05:00 | AAPL | Stock | 13.4461 | 13.4461 | 13.4461 | 13.4461 | 2800.0 |
| 2011-10-07 06:25: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:15:00 | AAPL | Stock | 13.4457 | 13.4457 | 13.4218 | 13.4218 | 15708.0 |
| 2011-10-07 07:20:00 | AAPL | Stock | 13.4286 | 13.4286 | 13.4286 | 13.4286 | 2800.0 |
| 2011-10-07 07:25:00 | AAPL | Stock | 13.4286 | 13.4286 | 13.4246 | 13.4246 | 39200.0 |
| 2011-10-07 07:30:00 | AAPL | Stock | 13.4107 | 13.425 | 13.4107 | 13.425 | 5600.0 |
| 2011-10-07 07:45:00 | AAPL | Stock | 13.435 | 13.435 | 13.4204 | 13.4286 | 51800.0 |
| 2011-10-07 07:55:00 | AAPL | Stock | 13.435 | 13.435 | 13.425 | 13.425 | 9520.0 |
| 2011-10-07 08:00:00 | AAPL | Stock | 13.4286 | 13.4357 | 13.4254 | 13.4357 | 92680.0 |
| 2011-10-07 08:05:00 | AAPL | Stock | 13.4357 | 13.4357 | 13.4286 | 13.4311 | 39004.0 |
| 2011-10-07 08:10:00 | AAPL | Stock | 13.4311 | 13.4311 | 13.4221 | 13.4279 | 69300.0 |
| 2011-10-07 08:15:00 | AAPL | Stock | 13.4286 | 13.4421 | 13.4286 | 13.4346 | 95956.0 |
| 2011-10-07 08:20:00 | AAPL | Stock | 13.4386 | 13.4421 | 13.4339 | 13.4339 | 183960.0 |
| 2011-10-07 08:25:00 | AAPL | Stock | 13.4339 | 13.4461 | 13.4339 | 13.4443 | 75040.0 |
| 2011-10-07 08:30:00 | AAPL | Stock | 13.4561 | 13.545 | 13.4554 | 13.4871 | 2044896.0 |
| 2011-10-07 08:35:00 | AAPL | Stock | 13.4871 | 13.5418 | 13.4804 | 13.5336 | 984928.0 |
| 2011-10-07 08:40:00 | AAPL | Stock | 13.5329 | 13.5357 | 13.51 | 13.5104 | 670180.0 |
| 2011-10-07 08:45:00 | AAPL | Stock | 13.5132 | 13.5214 | 13.5 | 13.5 | 469084.0 |
| 2011-10-07 08:50:00 | AAPL | Stock | 13.4946 | 13.5179 | 13.4946 | 13.5132 | 562128.0 |
| 2011-10-07 08:55:00 | AAPL | Stock | 13.5139 | 13.5164 | 13.4893 | 13.5036 | 1113280.0 |
| 2011-10-07 09:00:00 | AAPL | Stock | 13.5036 | 13.5104 | 13.4825 | 13.4911 | 251104.0 |
| 2011-10-07 09:05:00 | AAPL | Stock | 13.4914 | 13.4914 | 13.4707 | 13.4786 | 662788.0 |
| 2011-10-07 09:10:00 | AAPL | Stock | 13.4768 | 13.4821 | 13.4596 | 13.4821 | 550676.0 |
| 2011-10-07 09:15:00 | AAPL | Stock | 13.4796 | 13.4804 | 13.455 | 13.4643 | 430108.0 |
| 2011-10-07 09:20:00 | AAPL | Stock | 13.4675 | 13.4696 | 13.4454 | 13.4454 | 188776.0 |
| 2011-10-07 09:25:00 | AAPL | Stock | 13.4425 | 13.4557 | 13.4225 | 13.4225 | 724080.0 |
| 2011-10-07 09:30:00 | AAPL | Stock | 13.4204 | 13.4389 | 13.3682 | 13.3989 | 16930424.0 |
| 2011-10-07 09:35:00 | AAPL | Stock | 13.3984 | 13.4525 | 13.3718 | 13.375 | 12001136.0 |
| 2011-10-07 09:40:00 | AAPL | Stock | 13.375 | 13.4171 | 13.3521 | 13.3929 | 13187692.0 |
| 2011-10-07 09:45:00 | AAPL | Stock | 13.3929 | 13.4807 | 13.3846 | 13.4633 | 12082924.0 |
| 2011-10-07 09:50:00 | AAPL | Stock | 13.4679 | 13.4786 | 13.4179 | 13.4721 | 9057636.0 |
| 2011-10-07 09:55:00 | AAPL | Stock | 13.475 | 13.4907 | 13.4418 | 13.4525 | 7073836.0 |
| 2011-10-07 10:00:00 | AAPL | Stock | 13.4568 | 13.4718 | 13.4014 | 13.4275 | 6529264.0 |
| 2011-10-07 10:05:00 | AAPL | Stock | 13.4295 | 13.4311 | 13.3886 | 13.3939 | 6675200.0 |
| 2011-10-07 10:10:00 | AAPL | Stock | 13.3932 | 13.4418 | 13.3861 | 13.4289 | 4778564.0 |
| 2011-10-07 10:15:00 | AAPL | Stock | 13.4336 | 13.46 | 13.43 | 13.4325 | 4327652.0 |
| 2011-10-07 10:20:00 | AAPL | Stock | 13.4336 | 13.4357 | 13.4111 | 13.4218 | 4667376.0 |
| 2011-10-07 10:25:00 | AAPL | Stock | 13.4246 | 13.4368 | 13.3975 | 13.408 | 8859620.0 |
| 2011-10-07 10:30:00 | AAPL | Stock | 13.41 | 13.4282 | 13.4014 | 13.4084 | 4561564.0 |
| 2011-10-07 10:35:00 | AAPL | Stock | 13.4096 | 13.4187 | 13.3768 | 13.3846 | 7602448.0 |
| 2011-10-07 10:40:00 | AAPL | Stock | 13.3871 | 13.3946 | 13.3571 | 13.3736 | 5890220.0 |
| 2011-10-07 10:45:00 | AAPL | Stock | 13.3715 | 13.3725 | 13.3214 | 13.3246 | 11297048.0 |
| 2011-10-07 10:50:00 | AAPL | Stock | 13.3243 | 13.3521 | 13.3211 | 13.335 | 7042980.0 |
| 2011-10-07 10:55:00 | AAPL | Stock | 13.335 | 13.3571 | 13.3175 | 13.3218 | 7795200.0 |
| 2011-10-07 11:00:00 | AAPL | Stock | 13.3271 | 13.3364 | 13.295 | 13.3125 | 6122480.0 |
| 2011-10-07 11:05:00 | AAPL | Stock | 13.3125 | 13.3132 | 13.2879 | 13.2882 | 7212352.0 |
> showing 50 of 320,336 rows — these rows as CSV