PREVIEW / stock_5min / 2011-06-01
file: by_date/stock_5min/2011/2011-06-01.parquet size: 5.1 MB rows: 347,819 symbols: 3,564
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-06-01 04:25:00 | AAPL | Stock | 12.4607 | 12.4607 | 12.4607 | 12.4607 | 2800.0 |
| 2011-06-01 04:40:00 | AAPL | Stock | 12.4339 | 12.4339 | 12.4339 | 12.4339 | 2800.0 |
| 2011-06-01 05:10:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 5600.0 |
| 2011-06-01 05:30:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 2800.0 |
| 2011-06-01 05:50:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 4480.0 |
| 2011-06-01 05:55:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4054 | 12.4107 | 53200.0 |
| 2011-06-01 06:30:00 | AAPL | Stock | 12.4 | 12.4 | 12.3929 | 12.3929 | 36288.0 |
| 2011-06-01 06:35:00 | AAPL | Stock | 12.3957 | 12.3957 | 12.3957 | 12.3957 | 2800.0 |
| 2011-06-01 06:50:00 | AAPL | Stock | 12.4071 | 12.4071 | 12.4036 | 12.4036 | 16800.0 |
| 2011-06-01 07:00:00 | AAPL | Stock | 12.4161 | 12.4246 | 12.4161 | 12.4246 | 83748.0 |
| 2011-06-01 07:05:00 | AAPL | Stock | 12.4357 | 12.4446 | 12.4357 | 12.4446 | 30660.0 |
| 2011-06-01 07:10:00 | AAPL | Stock | 12.4393 | 12.4461 | 12.4393 | 12.4461 | 11200.0 |
| 2011-06-01 07:15:00 | AAPL | Stock | 12.4304 | 12.4304 | 12.4107 | 12.4107 | 95200.0 |
| 2011-06-01 07:20:00 | AAPL | Stock | 12.4211 | 12.4214 | 12.4211 | 12.4214 | 39200.0 |
| 2011-06-01 07:25:00 | AAPL | Stock | 12.4268 | 12.4268 | 12.4268 | 12.4268 | 25200.0 |
| 2011-06-01 07:30:00 | AAPL | Stock | 12.4318 | 12.4318 | 12.4318 | 12.4318 | 42000.0 |
| 2011-06-01 07:35:00 | AAPL | Stock | 12.425 | 12.425 | 12.425 | 12.425 | 5600.0 |
| 2011-06-01 07:45:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4214 | 12.4257 | 38080.0 |
| 2011-06-01 07:50:00 | AAPL | Stock | 12.4196 | 12.4286 | 12.4196 | 12.4286 | 39200.0 |
| 2011-06-01 07:55:00 | AAPL | Stock | 12.4254 | 12.4254 | 12.425 | 12.425 | 8400.0 |
| 2011-06-01 08:00:00 | AAPL | Stock | 12.4225 | 12.4571 | 12.4225 | 12.4564 | 912912.0 |
| 2011-06-01 08:05:00 | AAPL | Stock | 12.4571 | 12.4621 | 12.4325 | 12.4375 | 282744.0 |
| 2011-06-01 08:10:00 | AAPL | Stock | 12.4393 | 12.4532 | 12.4329 | 12.4393 | 157360.0 |
| 2011-06-01 08:15:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4236 | 12.4286 | 669872.0 |
| 2011-06-01 08:20:00 | AAPL | Stock | 12.4286 | 12.4325 | 12.4236 | 12.4286 | 136136.0 |
| 2011-06-01 08:25:00 | AAPL | Stock | 12.4239 | 12.4239 | 12.4139 | 12.4179 | 107688.0 |
| 2011-06-01 08:30:00 | AAPL | Stock | 12.4146 | 12.4221 | 12.4143 | 12.4179 | 138600.0 |
| 2011-06-01 08:35:00 | AAPL | Stock | 12.4125 | 12.4225 | 12.4086 | 12.4161 | 234220.0 |
| 2011-06-01 08:40:00 | AAPL | Stock | 12.4179 | 12.425 | 12.4161 | 12.42 | 140280.0 |
| 2011-06-01 08:45:00 | AAPL | Stock | 12.4196 | 12.4321 | 12.4196 | 12.4286 | 109060.0 |
| 2011-06-01 08:50:00 | AAPL | Stock | 12.4254 | 12.4286 | 12.4232 | 12.4232 | 217084.0 |
| 2011-06-01 08:55:00 | AAPL | Stock | 12.4225 | 12.4286 | 12.4218 | 12.4286 | 67200.0 |
| 2011-06-01 09:00:00 | AAPL | Stock | 12.4218 | 12.4286 | 12.4143 | 12.4143 | 193144.0 |
| 2011-06-01 09:05:00 | AAPL | Stock | 12.4229 | 12.4239 | 12.4189 | 12.4189 | 51240.0 |
| 2011-06-01 09:10:00 | AAPL | Stock | 12.4275 | 12.4279 | 12.4182 | 12.4214 | 100492.0 |
| 2011-06-01 09:15:00 | AAPL | Stock | 12.4243 | 12.4321 | 12.4214 | 12.4321 | 128632.0 |
| 2011-06-01 09:20:00 | AAPL | Stock | 12.4336 | 12.4554 | 12.4336 | 12.4504 | 461804.0 |
| 2011-06-01 09:25:00 | AAPL | Stock | 12.4518 | 12.47 | 12.4446 | 12.4596 | 996212.0 |
| 2011-06-01 09:30:00 | AAPL | Stock | 12.4643 | 12.4779 | 12.4343 | 12.4754 | 20982416.0 |
| 2011-06-01 09:35:00 | AAPL | Stock | 12.4764 | 12.515 | 12.4539 | 12.5147 | 24945872.0 |
| 2011-06-01 09:40:00 | AAPL | Stock | 12.5121 | 12.535 | 12.505 | 12.5146 | 19349036.0 |
| 2011-06-01 09:45:00 | AAPL | Stock | 12.5144 | 12.5618 | 12.5114 | 12.55 | 17342304.0 |
| 2011-06-01 09:50:00 | AAPL | Stock | 12.5507 | 12.5761 | 12.5439 | 12.5443 | 18269888.0 |
| 2011-06-01 09:55:00 | AAPL | Stock | 12.5461 | 12.5586 | 12.5386 | 12.5414 | 11175696.0 |
| 2011-06-01 10:00:00 | AAPL | Stock | 12.5414 | 12.5536 | 12.5257 | 12.5479 | 14571844.0 |
| 2011-06-01 10:05:00 | AAPL | Stock | 12.5475 | 12.5514 | 12.5179 | 12.5214 | 9066400.0 |
| 2011-06-01 10:10:00 | AAPL | Stock | 12.5204 | 12.5246 | 12.4944 | 12.515 | 12909652.0 |
| 2011-06-01 10:15:00 | AAPL | Stock | 12.5155 | 12.5343 | 12.5075 | 12.5327 | 7104272.0 |
| 2011-06-01 10:20:00 | AAPL | Stock | 12.5339 | 12.5429 | 12.5246 | 12.5346 | 6517532.0 |
| 2011-06-01 10:25:00 | AAPL | Stock | 12.5336 | 12.5386 | 12.5071 | 12.5093 | 6883576.0 |
> showing 50 of 347,819 rows — these rows as CSV