PREVIEW / stock_5min / 2007-06-19
file: by_date/stock_5min/2007/2007-06-19.parquet size: 3.9 MB rows: 291,893 symbols: 3,042
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-19 09:30:00 | AAPL | Stock | 4.4532 | 4.4646 | 4.4436 | 4.4479 | 30904916.0 |
| 2007-06-19 09:35:00 | AAPL | Stock | 4.4479 | 4.4511 | 4.4361 | 4.44 | 22048096.0 |
| 2007-06-19 09:40:00 | AAPL | Stock | 4.44 | 4.4411 | 4.4146 | 4.4282 | 32955076.0 |
| 2007-06-19 09:45:00 | AAPL | Stock | 4.4282 | 4.43 | 4.4093 | 4.4121 | 23261812.0 |
| 2007-06-19 09:50:00 | AAPL | Stock | 4.4121 | 4.4154 | 4.3975 | 4.4107 | 28973784.0 |
| 2007-06-19 09:55:00 | AAPL | Stock | 4.4104 | 4.4182 | 4.3993 | 4.4164 | 17663044.0 |
| 2007-06-19 10:00:00 | AAPL | Stock | 4.4154 | 4.4221 | 4.4079 | 4.4146 | 13356028.0 |
| 2007-06-19 10:05:00 | AAPL | Stock | 4.4146 | 4.4239 | 4.4111 | 4.4193 | 12144944.0 |
| 2007-06-19 10:10:00 | AAPL | Stock | 4.4193 | 4.4229 | 4.4125 | 4.4132 | 10863860.0 |
| 2007-06-19 10:15:00 | AAPL | Stock | 4.4132 | 4.4132 | 4.4054 | 4.4079 | 12713456.0 |
| 2007-06-19 10:20:00 | AAPL | Stock | 4.4079 | 4.4111 | 4.4018 | 4.4021 | 13951252.0 |
| 2007-06-19 10:25:00 | AAPL | Stock | 4.4021 | 4.4107 | 4.3993 | 4.41 | 12244904.0 |
| 2007-06-19 10:30:00 | AAPL | Stock | 4.4096 | 4.4196 | 4.4086 | 4.4125 | 15580740.0 |
| 2007-06-19 10:35:00 | AAPL | Stock | 4.4125 | 4.4157 | 4.4025 | 4.41 | 14928144.0 |
| 2007-06-19 10:40:00 | AAPL | Stock | 4.4107 | 4.4132 | 4.4039 | 4.4071 | 7858200.0 |
| 2007-06-19 10:45:00 | AAPL | Stock | 4.4071 | 4.4079 | 4.3936 | 4.3964 | 18287332.0 |
| 2007-06-19 10:50:00 | AAPL | Stock | 4.3961 | 4.3979 | 4.3896 | 4.3925 | 26720036.0 |
| 2007-06-19 10:55:00 | AAPL | Stock | 4.3925 | 4.405 | 4.3921 | 4.4 | 11812696.0 |
| 2007-06-19 11:00:00 | AAPL | Stock | 4.4 | 4.4011 | 4.3946 | 4.3964 | 5527452.0 |
| 2007-06-19 11:05:00 | AAPL | Stock | 4.3964 | 4.4 | 4.3921 | 4.3952 | 7133028.0 |
| 2007-06-19 11:10:00 | AAPL | Stock | 4.3953 | 4.4036 | 4.3946 | 4.4029 | 5972624.0 |
| 2007-06-19 11:15:00 | AAPL | Stock | 4.4029 | 4.4179 | 4.4025 | 4.41 | 21958888.0 |
| 2007-06-19 11:20:00 | AAPL | Stock | 4.4107 | 4.4175 | 4.41 | 4.4136 | 10774092.0 |
| 2007-06-19 11:25:00 | AAPL | Stock | 4.4139 | 4.4146 | 4.4039 | 4.4057 | 9029244.0 |
| 2007-06-19 11:30:00 | AAPL | Stock | 4.4054 | 4.4093 | 4.4018 | 4.4079 | 6867784.0 |
| 2007-06-19 11:35:00 | AAPL | Stock | 4.4079 | 4.4171 | 4.4068 | 4.4114 | 8327956.0 |
| 2007-06-19 11:40:00 | AAPL | Stock | 4.4114 | 4.4221 | 4.4096 | 4.4214 | 9107616.0 |
| 2007-06-19 11:45:00 | AAPL | Stock | 4.4214 | 4.4268 | 4.4182 | 4.4225 | 10556252.0 |
| 2007-06-19 11:50:00 | AAPL | Stock | 4.4214 | 4.4329 | 4.4207 | 4.4314 | 11665780.0 |
| 2007-06-19 11:55:00 | AAPL | Stock | 4.4311 | 4.4321 | 4.4232 | 4.4318 | 11428704.0 |
| 2007-06-19 12:00:00 | AAPL | Stock | 4.4318 | 4.4404 | 4.4293 | 4.4404 | 13639780.0 |
| 2007-06-19 12:05:00 | AAPL | Stock | 4.4404 | 4.4471 | 4.4382 | 4.4418 | 17038840.0 |
| 2007-06-19 12:10:00 | AAPL | Stock | 4.4421 | 4.4436 | 4.4368 | 4.4425 | 9683632.0 |
| 2007-06-19 12:15:00 | AAPL | Stock | 4.4421 | 4.4479 | 4.4364 | 4.4393 | 8779596.0 |
| 2007-06-19 12:20:00 | AAPL | Stock | 4.4393 | 4.4407 | 4.4311 | 4.4336 | 7749616.0 |
| 2007-06-19 12:25:00 | AAPL | Stock | 4.4332 | 4.4339 | 4.4264 | 4.4304 | 8605772.0 |
| 2007-06-19 12:30:00 | AAPL | Stock | 4.4306 | 4.4317 | 4.4275 | 4.4293 | 5953360.0 |
| 2007-06-19 12:35:00 | AAPL | Stock | 4.4289 | 4.4293 | 4.4218 | 4.4254 | 9192288.0 |
| 2007-06-19 12:40:00 | AAPL | Stock | 4.4254 | 4.4271 | 4.4243 | 4.4246 | 3726324.0 |
| 2007-06-19 12:45:00 | AAPL | Stock | 4.425 | 4.4254 | 4.4232 | 4.4232 | 4335128.0 |
| 2007-06-19 12:50:00 | AAPL | Stock | 4.4236 | 4.4318 | 4.4214 | 4.4286 | 7398244.0 |
| 2007-06-19 12:55:00 | AAPL | Stock | 4.4282 | 4.435 | 4.4275 | 4.4311 | 6304816.0 |
| 2007-06-19 13:00:00 | AAPL | Stock | 4.4304 | 4.4321 | 4.4286 | 4.4314 | 2851800.0 |
| 2007-06-19 13:05:00 | AAPL | Stock | 4.4318 | 4.435 | 4.4307 | 4.4329 | 2916508.0 |
| 2007-06-19 13:10:00 | AAPL | Stock | 4.4329 | 4.4354 | 4.4296 | 4.4354 | 3820824.0 |
| 2007-06-19 13:15:00 | AAPL | Stock | 4.4357 | 4.44 | 4.4329 | 4.4379 | 5015472.0 |
| 2007-06-19 13:20:00 | AAPL | Stock | 4.4379 | 4.4461 | 4.4375 | 4.4386 | 10681188.0 |
| 2007-06-19 13:25:00 | AAPL | Stock | 4.4386 | 4.4411 | 4.4171 | 4.4268 | 17790472.0 |
| 2007-06-19 13:30:00 | AAPL | Stock | 4.4257 | 4.4261 | 4.4093 | 4.4157 | 21878416.0 |
| 2007-06-19 13:35:00 | AAPL | Stock | 4.4161 | 4.4221 | 4.4107 | 4.4196 | 12877060.0 |
> showing 50 of 291,893 rows — these rows as CSV