PREVIEW / stock_5min / 2011-03-25
file: by_date/stock_5min/2011/2011-03-25.parquet size: 4.9 MB rows: 329,406 symbols: 3,514
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-03-25 04:00:00 | AAPL | Stock | 12.395 | 12.395 | 12.3886 | 12.3886 | 19600.0 |
| 2011-03-25 04:20:00 | AAPL | Stock | 12.4032 | 12.4032 | 12.4032 | 12.4032 | 2800.0 |
| 2011-03-25 04:35:00 | AAPL | Stock | 12.3971 | 12.4 | 12.3971 | 12.4 | 5600.0 |
| 2011-03-25 04:50:00 | AAPL | Stock | 12.3893 | 12.3893 | 12.3893 | 12.3893 | 2800.0 |
| 2011-03-25 04:55:00 | AAPL | Stock | 12.3893 | 12.3893 | 12.3893 | 12.3893 | 11200.0 |
| 2011-03-25 05:50:00 | AAPL | Stock | 12.3982 | 12.3982 | 12.3982 | 12.3982 | 2800.0 |
| 2011-03-25 06:00:00 | AAPL | Stock | 12.3982 | 12.4286 | 12.3982 | 12.4286 | 25200.0 |
| 2011-03-25 06:05:00 | AAPL | Stock | 12.4368 | 12.4368 | 12.4368 | 12.4368 | 2800.0 |
| 2011-03-25 06:30:00 | AAPL | Stock | 12.4343 | 12.4343 | 12.4343 | 12.4343 | 2800.0 |
| 2011-03-25 06:35:00 | AAPL | Stock | 12.4411 | 12.4432 | 12.4393 | 12.4432 | 12600.0 |
| 2011-03-25 06:40:00 | AAPL | Stock | 12.4396 | 12.4446 | 12.4357 | 12.4357 | 16800.0 |
| 2011-03-25 06:45:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4393 | 12.4393 | 2800.0 |
| 2011-03-25 06:50:00 | AAPL | Stock | 12.4071 | 12.4071 | 12.4071 | 12.4071 | 2800.0 |
| 2011-03-25 06:55:00 | AAPL | Stock | 12.4071 | 12.425 | 12.4071 | 12.425 | 5600.0 |
| 2011-03-25 07:00:00 | AAPL | Stock | 12.4286 | 12.4289 | 12.425 | 12.425 | 40740.0 |
| 2011-03-25 07:05:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 12320.0 |
| 2011-03-25 07:10:00 | AAPL | Stock | 12.4282 | 12.4282 | 12.4282 | 12.4282 | 2800.0 |
| 2011-03-25 07:15:00 | AAPL | Stock | 12.4271 | 12.4271 | 12.4154 | 12.4154 | 58100.0 |
| 2011-03-25 07:20:00 | AAPL | Stock | 12.4221 | 12.425 | 12.4221 | 12.4246 | 87668.0 |
| 2011-03-25 07:30:00 | AAPL | Stock | 12.4171 | 12.4171 | 12.4171 | 12.4171 | 2800.0 |
| 2011-03-25 07:35:00 | AAPL | Stock | 12.4207 | 12.4214 | 12.4143 | 12.4161 | 25984.0 |
| 2011-03-25 07:40:00 | AAPL | Stock | 12.4161 | 12.4161 | 12.4054 | 12.4075 | 126000.0 |
| 2011-03-25 07:45:00 | AAPL | Stock | 12.4136 | 12.4146 | 12.4071 | 12.4143 | 33600.0 |
| 2011-03-25 07:50:00 | AAPL | Stock | 12.4157 | 12.4286 | 12.415 | 12.4214 | 135520.0 |
| 2011-03-25 07:55:00 | AAPL | Stock | 12.4161 | 12.4161 | 12.4143 | 12.4143 | 52360.0 |
| 2011-03-25 08:00:00 | AAPL | Stock | 12.4111 | 12.4286 | 12.4111 | 12.4225 | 521472.0 |
| 2011-03-25 08:05:00 | AAPL | Stock | 12.425 | 12.4282 | 12.4214 | 12.4239 | 142660.0 |
| 2011-03-25 08:10:00 | AAPL | Stock | 12.4232 | 12.4268 | 12.4218 | 12.425 | 87304.0 |
| 2011-03-25 08:15:00 | AAPL | Stock | 12.4268 | 12.4268 | 12.4196 | 12.4196 | 118748.0 |
| 2011-03-25 08:20:00 | AAPL | Stock | 12.4196 | 12.4204 | 12.4146 | 12.4204 | 116172.0 |
| 2011-03-25 08:25:00 | AAPL | Stock | 12.4196 | 12.4214 | 12.4114 | 12.4114 | 186648.0 |
| 2011-03-25 08:30:00 | AAPL | Stock | 12.4143 | 12.4246 | 12.4143 | 12.4214 | 407848.0 |
| 2011-03-25 08:35:00 | AAPL | Stock | 12.4196 | 12.4196 | 12.3929 | 12.4139 | 182644.0 |
| 2011-03-25 08:40:00 | AAPL | Stock | 12.4214 | 12.4268 | 12.4146 | 12.4214 | 115864.0 |
| 2011-03-25 08:45:00 | AAPL | Stock | 12.4189 | 12.425 | 12.4136 | 12.4179 | 171136.0 |
| 2011-03-25 08:50:00 | AAPL | Stock | 12.4136 | 12.4186 | 12.4107 | 12.4179 | 334152.0 |
| 2011-03-25 08:55:00 | AAPL | Stock | 12.4179 | 12.4196 | 12.4114 | 12.4143 | 274540.0 |
| 2011-03-25 09:00:00 | AAPL | Stock | 12.4143 | 12.4179 | 12.4143 | 12.4179 | 25200.0 |
| 2011-03-25 09:05:00 | AAPL | Stock | 12.4132 | 12.4143 | 12.4132 | 12.4143 | 31808.0 |
| 2011-03-25 09:10:00 | AAPL | Stock | 12.4154 | 12.4179 | 12.4043 | 12.4164 | 397712.0 |
| 2011-03-25 09:15:00 | AAPL | Stock | 12.4175 | 12.4196 | 12.4143 | 12.4161 | 166152.0 |
| 2011-03-25 09:20:00 | AAPL | Stock | 12.4132 | 12.4175 | 12.4107 | 12.4143 | 196588.0 |
| 2011-03-25 09:25:00 | AAPL | Stock | 12.4143 | 12.4318 | 12.4139 | 12.4264 | 1170512.0 |
| 2011-03-25 09:30:00 | AAPL | Stock | 12.4304 | 12.435 | 12.3936 | 12.4075 | 14515704.0 |
| 2011-03-25 09:35:00 | AAPL | Stock | 12.4075 | 12.4332 | 12.4 | 12.4254 | 15008560.0 |
| 2011-03-25 09:40:00 | AAPL | Stock | 12.4232 | 12.4571 | 12.4104 | 12.4568 | 12336240.0 |
| 2011-03-25 09:45:00 | AAPL | Stock | 12.4564 | 12.4925 | 12.4446 | 12.4903 | 15829800.0 |
| 2011-03-25 09:50:00 | AAPL | Stock | 12.4914 | 12.5261 | 12.4821 | 12.5146 | 19983880.0 |
| 2011-03-25 09:55:00 | AAPL | Stock | 12.5129 | 12.5189 | 12.47 | 12.5053 | 16401924.0 |
| 2011-03-25 10:00:00 | AAPL | Stock | 12.5029 | 12.5132 | 12.4793 | 12.4965 | 10748724.0 |
> showing 50 of 329,406 rows — these rows as CSV