PREVIEW / stock_5min / 2006-08-18
file: by_date/stock_5min/2006/2006-08-18.parquet size: 2.9 MB rows: 218,559 symbols: 2,325
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-18 08:00:00 | AAPL | Stock | 2.4136 | 2.4136 | 2.4107 | 2.4107 | 5600.0 |
| 2006-08-18 08:05:00 | AAPL | Stock | 2.4107 | 2.4107 | 2.4071 | 2.4071 | 56000.0 |
| 2006-08-18 08:10:00 | AAPL | Stock | 2.4075 | 2.4075 | 2.4075 | 2.4075 | 30800.0 |
| 2006-08-18 08:15:00 | AAPL | Stock | 2.4125 | 2.4125 | 2.4075 | 2.4075 | 19600.0 |
| 2006-08-18 08:20:00 | AAPL | Stock | 2.4089 | 2.4104 | 2.4071 | 2.4089 | 144060.0 |
| 2006-08-18 08:25:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 7280.0 |
| 2006-08-18 08:30:00 | AAPL | Stock | 2.4054 | 2.4054 | 2.4036 | 2.4036 | 39200.0 |
| 2006-08-18 08:35:00 | AAPL | Stock | 2.405 | 2.4054 | 2.4039 | 2.4054 | 57400.0 |
| 2006-08-18 08:40:00 | AAPL | Stock | 2.4039 | 2.4089 | 2.4039 | 2.4089 | 149240.0 |
| 2006-08-18 08:45:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4054 | 2.4054 | 28000.0 |
| 2006-08-18 08:50:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 50400.0 |
| 2006-08-18 08:55:00 | AAPL | Stock | 2.4071 | 2.4089 | 2.4071 | 2.4089 | 149436.0 |
| 2006-08-18 09:00:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 89600.0 |
| 2006-08-18 09:05:00 | AAPL | Stock | 2.4079 | 2.4082 | 2.4071 | 2.4082 | 110236.0 |
| 2006-08-18 09:10:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 56000.0 |
| 2006-08-18 09:15:00 | AAPL | Stock | 2.4054 | 2.4082 | 2.4043 | 2.4082 | 54600.0 |
| 2006-08-18 09:20:00 | AAPL | Stock | 2.4079 | 2.4089 | 2.4079 | 2.4089 | 23100.0 |
| 2006-08-18 09:25:00 | AAPL | Stock | 2.4064 | 2.4196 | 2.4064 | 2.4193 | 1119552.0 |
| 2006-08-18 09:30:00 | AAPL | Stock | 2.4182 | 2.4196 | 2.4021 | 2.4036 | 40535236.0 |
| 2006-08-18 09:35:00 | AAPL | Stock | 2.4039 | 2.4179 | 2.4039 | 2.4096 | 10998456.0 |
| 2006-08-18 09:40:00 | AAPL | Stock | 2.4096 | 2.4154 | 2.4068 | 2.415 | 6477884.0 |
| 2006-08-18 09:45:00 | AAPL | Stock | 2.4146 | 2.4211 | 2.4114 | 2.4118 | 10285604.0 |
| 2006-08-18 09:50:00 | AAPL | Stock | 2.4121 | 2.4164 | 2.4071 | 2.4118 | 11070360.0 |
| 2006-08-18 09:55:00 | AAPL | Stock | 2.4107 | 2.4164 | 2.4064 | 2.4136 | 12648412.0 |
| 2006-08-18 10:00:00 | AAPL | Stock | 2.4143 | 2.4204 | 2.4132 | 2.4179 | 15645168.0 |
| 2006-08-18 10:05:00 | AAPL | Stock | 2.4175 | 2.4186 | 2.4093 | 2.4139 | 9112040.0 |
| 2006-08-18 10:10:00 | AAPL | Stock | 2.4136 | 2.4171 | 2.4111 | 2.4132 | 8098020.0 |
| 2006-08-18 10:15:00 | AAPL | Stock | 2.4129 | 2.4161 | 2.4096 | 2.4121 | 12478760.0 |
| 2006-08-18 10:20:00 | AAPL | Stock | 2.4121 | 2.4157 | 2.4093 | 2.4146 | 6306524.0 |
| 2006-08-18 10:25:00 | AAPL | Stock | 2.4146 | 2.4157 | 2.4107 | 2.4129 | 3969756.0 |
| 2006-08-18 10:30:00 | AAPL | Stock | 2.4125 | 2.4175 | 2.4125 | 2.4143 | 5674004.0 |
| 2006-08-18 10:35:00 | AAPL | Stock | 2.4139 | 2.4229 | 2.4125 | 2.4211 | 9712780.0 |
| 2006-08-18 10:40:00 | AAPL | Stock | 2.4211 | 2.4339 | 2.4207 | 2.43 | 18603424.0 |
| 2006-08-18 10:45:00 | AAPL | Stock | 2.43 | 2.4307 | 2.425 | 2.4296 | 9079336.0 |
| 2006-08-18 10:50:00 | AAPL | Stock | 2.43 | 2.4318 | 2.4229 | 2.4264 | 10226356.0 |
| 2006-08-18 10:55:00 | AAPL | Stock | 2.4254 | 2.4368 | 2.4246 | 2.4346 | 12398624.0 |
| 2006-08-18 11:00:00 | AAPL | Stock | 2.4347 | 2.4407 | 2.4346 | 2.4389 | 12474448.0 |
| 2006-08-18 11:05:00 | AAPL | Stock | 2.4393 | 2.4429 | 2.4375 | 2.4414 | 10859548.0 |
| 2006-08-18 11:10:00 | AAPL | Stock | 2.4414 | 2.4421 | 2.4382 | 2.4382 | 6197856.0 |
| 2006-08-18 11:15:00 | AAPL | Stock | 2.4382 | 2.4404 | 2.4364 | 2.4389 | 4677176.0 |
| 2006-08-18 11:20:00 | AAPL | Stock | 2.4393 | 2.4404 | 2.4357 | 2.4364 | 4323452.0 |
| 2006-08-18 11:25:00 | AAPL | Stock | 2.4364 | 2.4368 | 2.4329 | 2.4329 | 5147268.0 |
| 2006-08-18 11:30:00 | AAPL | Stock | 2.4329 | 2.4329 | 2.4264 | 2.4264 | 7419020.0 |
| 2006-08-18 11:35:00 | AAPL | Stock | 2.4264 | 2.4286 | 2.425 | 2.4279 | 6490904.0 |
| 2006-08-18 11:40:00 | AAPL | Stock | 2.4275 | 2.43 | 2.4254 | 2.4282 | 4636576.0 |
| 2006-08-18 11:45:00 | AAPL | Stock | 2.4279 | 2.4293 | 2.4261 | 2.4264 | 2280684.0 |
| 2006-08-18 11:50:00 | AAPL | Stock | 2.4264 | 2.4296 | 2.4264 | 2.4296 | 3773616.0 |
| 2006-08-18 11:55:00 | AAPL | Stock | 2.4293 | 2.4339 | 2.4293 | 2.4311 | 5975676.0 |
| 2006-08-18 12:00:00 | AAPL | Stock | 2.4307 | 2.4321 | 2.425 | 2.4261 | 7525112.0 |
| 2006-08-18 12:05:00 | AAPL | Stock | 2.4257 | 2.4271 | 2.4204 | 2.4214 | 7785260.0 |
> showing 50 of 218,559 rows — these rows as CSV