PREVIEW / stock_5min / 2006-08-02
file: by_date/stock_5min/2006/2006-08-02.parquet size: 3.1 MB rows: 228,663 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-02 07:10:00 | AAPL | Stock | 2.425 | 2.4446 | 2.425 | 2.4446 | 18200.0 |
| 2006-08-02 07:40:00 | AAPL | Stock | 2.4139 | 2.4139 | 2.4139 | 2.4139 | 2800.0 |
| 2006-08-02 07:45:00 | AAPL | Stock | 2.4139 | 2.4139 | 2.4139 | 2.4139 | 2800.0 |
| 2006-08-02 08:00:00 | AAPL | Stock | 2.4139 | 2.4146 | 2.4132 | 2.4146 | 287420.0 |
| 2006-08-02 08:05:00 | AAPL | Stock | 2.4179 | 2.4214 | 2.4089 | 2.4214 | 536004.0 |
| 2006-08-02 08:10:00 | AAPL | Stock | 2.4214 | 2.4229 | 2.4214 | 2.4229 | 103600.0 |
| 2006-08-02 08:15:00 | AAPL | Stock | 2.4229 | 2.425 | 2.4214 | 2.4232 | 241780.0 |
| 2006-08-02 08:20:00 | AAPL | Stock | 2.4232 | 2.4268 | 2.4232 | 2.4257 | 534800.0 |
| 2006-08-02 08:25:00 | AAPL | Stock | 2.425 | 2.4268 | 2.4218 | 2.4232 | 81284.0 |
| 2006-08-02 08:30:00 | AAPL | Stock | 2.4218 | 2.4246 | 2.4218 | 2.4246 | 131600.0 |
| 2006-08-02 08:35:00 | AAPL | Stock | 2.4221 | 2.4221 | 2.42 | 2.42 | 121996.0 |
| 2006-08-02 08:40:00 | AAPL | Stock | 2.42 | 2.4214 | 2.4196 | 2.4196 | 53200.0 |
| 2006-08-02 08:45:00 | AAPL | Stock | 2.4179 | 2.4196 | 2.4179 | 2.4179 | 95200.0 |
| 2006-08-02 08:50:00 | AAPL | Stock | 2.4179 | 2.4196 | 2.415 | 2.4161 | 259000.0 |
| 2006-08-02 08:55:00 | AAPL | Stock | 2.415 | 2.4168 | 2.4143 | 2.4161 | 188160.0 |
| 2006-08-02 09:00:00 | AAPL | Stock | 2.4143 | 2.4161 | 2.4143 | 2.4143 | 84000.0 |
| 2006-08-02 09:05:00 | AAPL | Stock | 2.4143 | 2.4179 | 2.4143 | 2.4179 | 101920.0 |
| 2006-08-02 09:10:00 | AAPL | Stock | 2.4196 | 2.4214 | 2.4196 | 2.4214 | 207200.0 |
| 2006-08-02 09:15:00 | AAPL | Stock | 2.4229 | 2.4229 | 2.4211 | 2.4211 | 39284.0 |
| 2006-08-02 09:20:00 | AAPL | Stock | 2.4161 | 2.4196 | 2.4161 | 2.4196 | 58800.0 |
| 2006-08-02 09:25:00 | AAPL | Stock | 2.4161 | 2.4229 | 2.4146 | 2.4161 | 322336.0 |
| 2006-08-02 09:30:00 | AAPL | Stock | 2.4161 | 2.4279 | 2.4111 | 2.4264 | 18111632.0 |
| 2006-08-02 09:35:00 | AAPL | Stock | 2.4257 | 2.4275 | 2.4161 | 2.4182 | 11343192.0 |
| 2006-08-02 09:40:00 | AAPL | Stock | 2.4182 | 2.4214 | 2.415 | 2.4204 | 8558312.0 |
| 2006-08-02 09:45:00 | AAPL | Stock | 2.4204 | 2.425 | 2.4168 | 2.425 | 9478028.0 |
| 2006-08-02 09:50:00 | AAPL | Stock | 2.4246 | 2.4354 | 2.4221 | 2.4321 | 16519300.0 |
| 2006-08-02 09:55:00 | AAPL | Stock | 2.4325 | 2.4325 | 2.4243 | 2.4264 | 8622264.0 |
| 2006-08-02 10:00:00 | AAPL | Stock | 2.4264 | 2.4314 | 2.4225 | 2.4307 | 9649556.0 |
| 2006-08-02 10:05:00 | AAPL | Stock | 2.4307 | 2.4321 | 2.4214 | 2.4239 | 11028808.0 |
| 2006-08-02 10:10:00 | AAPL | Stock | 2.4236 | 2.4282 | 2.4232 | 2.4264 | 5859504.0 |
| 2006-08-02 10:15:00 | AAPL | Stock | 2.4261 | 2.4282 | 2.4229 | 2.4229 | 7977144.0 |
| 2006-08-02 10:20:00 | AAPL | Stock | 2.4232 | 2.4246 | 2.4211 | 2.4235 | 8416436.0 |
| 2006-08-02 10:25:00 | AAPL | Stock | 2.4232 | 2.4264 | 2.4225 | 2.425 | 4481876.0 |
| 2006-08-02 10:30:00 | AAPL | Stock | 2.425 | 2.4286 | 2.4221 | 2.4246 | 7182420.0 |
| 2006-08-02 10:35:00 | AAPL | Stock | 2.4246 | 2.4268 | 2.4239 | 2.4268 | 4268320.0 |
| 2006-08-02 10:40:00 | AAPL | Stock | 2.4268 | 2.4296 | 2.4239 | 2.425 | 6622000.0 |
| 2006-08-02 10:45:00 | AAPL | Stock | 2.425 | 2.4257 | 2.4225 | 2.4236 | 5213320.0 |
| 2006-08-02 10:50:00 | AAPL | Stock | 2.4236 | 2.4332 | 2.4229 | 2.4307 | 10560928.0 |
| 2006-08-02 10:55:00 | AAPL | Stock | 2.4307 | 2.4307 | 2.4271 | 2.4282 | 4453120.0 |
| 2006-08-02 11:00:00 | AAPL | Stock | 2.4279 | 2.4421 | 2.4279 | 2.4393 | 15675800.0 |
| 2006-08-02 11:05:00 | AAPL | Stock | 2.4389 | 2.4393 | 2.4314 | 2.435 | 8550976.0 |
| 2006-08-02 11:10:00 | AAPL | Stock | 2.435 | 2.4414 | 2.4268 | 2.4382 | 7629636.0 |
| 2006-08-02 11:15:00 | AAPL | Stock | 2.4382 | 2.4425 | 2.4354 | 2.4371 | 7806120.0 |
| 2006-08-02 11:20:00 | AAPL | Stock | 2.4371 | 2.4386 | 2.4357 | 2.4379 | 4716936.0 |
| 2006-08-02 11:25:00 | AAPL | Stock | 2.4375 | 2.4379 | 2.4321 | 2.4329 | 6152328.0 |
| 2006-08-02 11:30:00 | AAPL | Stock | 2.4329 | 2.4368 | 2.4325 | 2.4339 | 3512180.0 |
| 2006-08-02 11:35:00 | AAPL | Stock | 2.4339 | 2.435 | 2.4325 | 2.435 | 2881872.0 |
| 2006-08-02 11:40:00 | AAPL | Stock | 2.435 | 2.438 | 2.4349 | 2.4372 | 4207224.0 |
| 2006-08-02 11:45:00 | AAPL | Stock | 2.4375 | 2.4407 | 2.4368 | 2.44 | 4477648.0 |
| 2006-08-02 11:50:00 | AAPL | Stock | 2.4396 | 2.4418 | 2.4371 | 2.4389 | 5851944.0 |
> showing 50 of 228,663 rows — these rows as CSV