PREVIEW / stock_5min / 2006-04-21
file: by_date/stock_5min/2006/2006-04-21.parquet size: 3.1 MB rows: 222,623 symbols: 2,237
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-04-21 06:15:00 | AAPL | Stock | 2.4304 | 2.4304 | 2.4304 | 2.4304 | 2800.0 |
| 2006-04-21 07:40:00 | AAPL | Stock | 2.4268 | 2.4268 | 2.4268 | 2.4268 | 22400.0 |
| 2006-04-21 07:55:00 | AAPL | Stock | 2.4286 | 2.4332 | 2.4268 | 2.4282 | 81200.0 |
| 2006-04-21 08:00:00 | AAPL | Stock | 2.4282 | 2.4332 | 2.425 | 2.4286 | 398748.0 |
| 2006-04-21 08:05:00 | AAPL | Stock | 2.4286 | 2.4286 | 2.425 | 2.425 | 36344.0 |
| 2006-04-21 08:10:00 | AAPL | Stock | 2.4268 | 2.4286 | 2.4232 | 2.4286 | 244300.0 |
| 2006-04-21 08:15:00 | AAPL | Stock | 2.4286 | 2.4304 | 2.425 | 2.4289 | 235900.0 |
| 2006-04-21 08:20:00 | AAPL | Stock | 2.4289 | 2.4304 | 2.4254 | 2.4282 | 173600.0 |
| 2006-04-21 08:25:00 | AAPL | Stock | 2.4257 | 2.4282 | 2.4257 | 2.4268 | 174300.0 |
| 2006-04-21 08:30:00 | AAPL | Stock | 2.4286 | 2.4293 | 2.4279 | 2.4286 | 156660.0 |
| 2006-04-21 08:35:00 | AAPL | Stock | 2.4286 | 2.4286 | 2.4282 | 2.4286 | 226800.0 |
| 2006-04-21 08:40:00 | AAPL | Stock | 2.4286 | 2.4293 | 2.4268 | 2.4286 | 255500.0 |
| 2006-04-21 08:45:00 | AAPL | Stock | 2.4286 | 2.4307 | 2.4286 | 2.4304 | 415716.0 |
| 2006-04-21 08:50:00 | AAPL | Stock | 2.4293 | 2.4321 | 2.4293 | 2.4314 | 434476.0 |
| 2006-04-21 08:55:00 | AAPL | Stock | 2.4314 | 2.4314 | 2.4286 | 2.4304 | 286104.0 |
| 2006-04-21 09:00:00 | AAPL | Stock | 2.4307 | 2.4307 | 2.4304 | 2.4307 | 89600.0 |
| 2006-04-21 09:05:00 | AAPL | Stock | 2.4307 | 2.4311 | 2.4304 | 2.4307 | 297276.0 |
| 2006-04-21 09:10:00 | AAPL | Stock | 2.4304 | 2.4307 | 2.4286 | 2.4307 | 250880.0 |
| 2006-04-21 09:15:00 | AAPL | Stock | 2.4304 | 2.4304 | 2.4286 | 2.43 | 265160.0 |
| 2006-04-21 09:20:00 | AAPL | Stock | 2.4286 | 2.4311 | 2.4286 | 2.4307 | 320824.0 |
| 2006-04-21 09:25:00 | AAPL | Stock | 2.4304 | 2.4496 | 2.4304 | 2.4343 | 3728620.0 |
| 2006-04-21 09:30:00 | AAPL | Stock | 2.4354 | 2.4514 | 2.4254 | 2.43 | 42039676.0 |
| 2006-04-21 09:35:00 | AAPL | Stock | 2.4304 | 2.4404 | 2.4261 | 2.4371 | 18889724.0 |
| 2006-04-21 09:40:00 | AAPL | Stock | 2.4368 | 2.4371 | 2.4164 | 2.4268 | 22574076.0 |
| 2006-04-21 09:45:00 | AAPL | Stock | 2.4268 | 2.4286 | 2.4207 | 2.4279 | 13669712.0 |
| 2006-04-21 09:50:00 | AAPL | Stock | 2.4279 | 2.4357 | 2.4257 | 2.435 | 14240772.0 |
| 2006-04-21 09:55:00 | AAPL | Stock | 2.435 | 2.4364 | 2.4229 | 2.4254 | 14064400.0 |
| 2006-04-21 10:00:00 | AAPL | Stock | 2.425 | 2.4279 | 2.4168 | 2.4271 | 15221444.0 |
| 2006-04-21 10:05:00 | AAPL | Stock | 2.4271 | 2.4279 | 2.4225 | 2.4256 | 8607732.0 |
| 2006-04-21 10:10:00 | AAPL | Stock | 2.4254 | 2.4357 | 2.4236 | 2.4268 | 14915068.0 |
| 2006-04-21 10:15:00 | AAPL | Stock | 2.4268 | 2.4275 | 2.4221 | 2.4268 | 8360520.0 |
| 2006-04-21 10:20:00 | AAPL | Stock | 2.4271 | 2.4286 | 2.4211 | 2.4229 | 7430920.0 |
| 2006-04-21 10:25:00 | AAPL | Stock | 2.4229 | 2.4229 | 2.4107 | 2.4118 | 18877992.0 |
| 2006-04-21 10:30:00 | AAPL | Stock | 2.4121 | 2.4139 | 2.4061 | 2.4071 | 18068680.0 |
| 2006-04-21 10:35:00 | AAPL | Stock | 2.4071 | 2.41 | 2.4018 | 2.41 | 19314372.0 |
| 2006-04-21 10:40:00 | AAPL | Stock | 2.41 | 2.4193 | 2.4089 | 2.4171 | 14479388.0 |
| 2006-04-21 10:45:00 | AAPL | Stock | 2.4164 | 2.4164 | 2.4093 | 2.4107 | 10596628.0 |
| 2006-04-21 10:50:00 | AAPL | Stock | 2.4107 | 2.4189 | 2.4089 | 2.4189 | 9035740.0 |
| 2006-04-21 10:55:00 | AAPL | Stock | 2.4189 | 2.4193 | 2.4161 | 2.4189 | 7220276.0 |
| 2006-04-21 11:00:00 | AAPL | Stock | 2.4189 | 2.4243 | 2.4186 | 2.4189 | 10067596.0 |
| 2006-04-21 11:05:00 | AAPL | Stock | 2.4186 | 2.4189 | 2.4136 | 2.4171 | 5369924.0 |
| 2006-04-21 11:10:00 | AAPL | Stock | 2.4164 | 2.4182 | 2.4143 | 2.4164 | 7637028.0 |
| 2006-04-21 11:15:00 | AAPL | Stock | 2.4161 | 2.4189 | 2.4157 | 2.4161 | 6311480.0 |
| 2006-04-21 11:20:00 | AAPL | Stock | 2.4161 | 2.4182 | 2.415 | 2.4175 | 5378016.0 |
| 2006-04-21 11:25:00 | AAPL | Stock | 2.4182 | 2.4225 | 2.4175 | 2.42 | 5395068.0 |
| 2006-04-21 11:30:00 | AAPL | Stock | 2.4196 | 2.4204 | 2.4146 | 2.4157 | 4035724.0 |
| 2006-04-21 11:35:00 | AAPL | Stock | 2.4161 | 2.4171 | 2.4132 | 2.4143 | 7087164.0 |
| 2006-04-21 11:40:00 | AAPL | Stock | 2.4146 | 2.4164 | 2.4139 | 2.4154 | 2557520.0 |
| 2006-04-21 11:45:00 | AAPL | Stock | 2.4154 | 2.4211 | 2.4154 | 2.4164 | 6631184.0 |
| 2006-04-21 11:50:00 | AAPL | Stock | 2.4171 | 2.4175 | 2.4146 | 2.4157 | 2338392.0 |
> showing 50 of 222,623 rows — these rows as CSV