PREVIEW / stock_5min / 2007-01-11
file: by_date/stock_5min/2007/2007-01-11.parquet size: 3.4 MB rows: 243,558 symbols: 2,503
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-01-11 04:10:00 | AAPL | Stock | 3.44 | 3.44 | 3.44 | 3.44 | 11200.0 |
| 2007-01-11 04:15:00 | AAPL | Stock | 3.4475 | 3.4475 | 3.4475 | 3.4475 | 11200.0 |
| 2007-01-11 06:30:00 | AAPL | Stock | 3.4468 | 3.4468 | 3.4464 | 3.4464 | 11200.0 |
| 2007-01-11 07:00:00 | AAPL | Stock | 3.4496 | 3.4496 | 3.4464 | 3.4464 | 151200.0 |
| 2007-01-11 07:10:00 | AAPL | Stock | 3.4554 | 3.4554 | 3.4554 | 3.4554 | 140000.0 |
| 2007-01-11 07:15:00 | AAPL | Stock | 3.4571 | 3.4589 | 3.4464 | 3.4471 | 215180.0 |
| 2007-01-11 07:20:00 | AAPL | Stock | 3.4471 | 3.4471 | 3.4471 | 3.4471 | 84000.0 |
| 2007-01-11 07:25:00 | AAPL | Stock | 3.4471 | 3.4471 | 3.4471 | 3.4471 | 28000.0 |
| 2007-01-11 07:30:00 | AAPL | Stock | 3.4471 | 3.4536 | 3.4471 | 3.4536 | 42000.0 |
| 2007-01-11 07:35:00 | AAPL | Stock | 3.45 | 3.45 | 3.4429 | 3.4464 | 357504.0 |
| 2007-01-11 07:40:00 | AAPL | Stock | 3.4432 | 3.4482 | 3.4432 | 3.4482 | 42000.0 |
| 2007-01-11 07:45:00 | AAPL | Stock | 3.4482 | 3.4482 | 3.4482 | 3.4482 | 5600.0 |
| 2007-01-11 07:50:00 | AAPL | Stock | 3.4461 | 3.4461 | 3.4429 | 3.4443 | 61796.0 |
| 2007-01-11 07:55:00 | AAPL | Stock | 3.4443 | 3.4443 | 3.4393 | 3.4393 | 235760.0 |
| 2007-01-11 08:00:00 | AAPL | Stock | 3.4425 | 3.4425 | 3.4268 | 3.4307 | 3826340.0 |
| 2007-01-11 08:05:00 | AAPL | Stock | 3.4307 | 3.4321 | 3.4257 | 3.4275 | 1437576.0 |
| 2007-01-11 08:10:00 | AAPL | Stock | 3.4275 | 3.4354 | 3.425 | 3.4321 | 1871044.0 |
| 2007-01-11 08:15:00 | AAPL | Stock | 3.4321 | 3.4382 | 3.4296 | 3.4375 | 918764.0 |
| 2007-01-11 08:20:00 | AAPL | Stock | 3.4375 | 3.4375 | 3.4321 | 3.4329 | 503076.0 |
| 2007-01-11 08:25:00 | AAPL | Stock | 3.4332 | 3.4357 | 3.4289 | 3.4296 | 651756.0 |
| 2007-01-11 08:30:00 | AAPL | Stock | 3.4289 | 3.4321 | 3.4286 | 3.43 | 508480.0 |
| 2007-01-11 08:35:00 | AAPL | Stock | 3.4296 | 3.4321 | 3.4289 | 3.4304 | 1351700.0 |
| 2007-01-11 08:40:00 | AAPL | Stock | 3.4314 | 3.4371 | 3.4304 | 3.4364 | 811552.0 |
| 2007-01-11 08:45:00 | AAPL | Stock | 3.4357 | 3.44 | 3.435 | 3.44 | 799400.0 |
| 2007-01-11 08:50:00 | AAPL | Stock | 3.4386 | 3.44 | 3.4357 | 3.4357 | 1104544.0 |
| 2007-01-11 08:55:00 | AAPL | Stock | 3.4357 | 3.44 | 3.4357 | 3.4382 | 826448.0 |
| 2007-01-11 09:00:00 | AAPL | Stock | 3.4389 | 3.4389 | 3.4307 | 3.4336 | 1277332.0 |
| 2007-01-11 09:05:00 | AAPL | Stock | 3.4339 | 3.4357 | 3.4293 | 3.4321 | 1034096.0 |
| 2007-01-11 09:10:00 | AAPL | Stock | 3.4318 | 3.4321 | 3.4268 | 3.4286 | 2355752.0 |
| 2007-01-11 09:15:00 | AAPL | Stock | 3.4286 | 3.4311 | 3.4243 | 3.4246 | 1244796.0 |
| 2007-01-11 09:20:00 | AAPL | Stock | 3.425 | 3.4254 | 3.4186 | 3.425 | 2408000.0 |
| 2007-01-11 09:25:00 | AAPL | Stock | 3.425 | 3.4325 | 3.4232 | 3.4286 | 3526488.0 |
| 2007-01-11 09:30:00 | AAPL | Stock | 3.4264 | 3.4304 | 3.4004 | 3.4232 | 71619464.0 |
| 2007-01-11 09:35:00 | AAPL | Stock | 3.4232 | 3.4268 | 3.4143 | 3.4214 | 33573092.0 |
| 2007-01-11 09:40:00 | AAPL | Stock | 3.4208 | 3.4511 | 3.4189 | 3.4414 | 48668424.0 |
| 2007-01-11 09:45:00 | AAPL | Stock | 3.4411 | 3.4429 | 3.4232 | 3.4246 | 34593328.0 |
| 2007-01-11 09:50:00 | AAPL | Stock | 3.425 | 3.4304 | 3.4068 | 3.4093 | 34151628.0 |
| 2007-01-11 09:55:00 | AAPL | Stock | 3.4093 | 3.4143 | 3.3968 | 3.4032 | 43021188.0 |
| 2007-01-11 10:00:00 | AAPL | Stock | 3.4032 | 3.4271 | 3.3964 | 3.4057 | 28757876.0 |
| 2007-01-11 10:05:00 | AAPL | Stock | 3.4057 | 3.4161 | 3.4039 | 3.4129 | 22954036.0 |
| 2007-01-11 10:10:00 | AAPL | Stock | 3.4136 | 3.4243 | 3.4107 | 3.4114 | 33752712.0 |
| 2007-01-11 10:15:00 | AAPL | Stock | 3.4111 | 3.4196 | 3.4036 | 3.4082 | 24136000.0 |
| 2007-01-11 10:20:00 | AAPL | Stock | 3.4086 | 3.4143 | 3.4043 | 3.41 | 16617076.0 |
| 2007-01-11 10:25:00 | AAPL | Stock | 3.41 | 3.4179 | 3.4089 | 3.4139 | 15791608.0 |
| 2007-01-11 10:30:00 | AAPL | Stock | 3.4139 | 3.4168 | 3.4104 | 3.415 | 17315144.0 |
| 2007-01-11 10:35:00 | AAPL | Stock | 3.4156 | 3.4207 | 3.4114 | 3.4182 | 21134456.0 |
| 2007-01-11 10:40:00 | AAPL | Stock | 3.4179 | 3.42 | 3.4143 | 3.4164 | 16923788.0 |
| 2007-01-11 10:45:00 | AAPL | Stock | 3.4161 | 3.4196 | 3.4104 | 3.4186 | 17092068.0 |
| 2007-01-11 10:50:00 | AAPL | Stock | 3.4186 | 3.4282 | 3.4175 | 3.4268 | 26823188.0 |
| 2007-01-11 10:55:00 | AAPL | Stock | 3.4268 | 3.4432 | 3.425 | 3.4429 | 30612652.0 |
> showing 50 of 243,558 rows — these rows as CSV