PREVIEW / stock_5min / 2008-03-13
file: by_date/stock_5min/2008/2008-03-13.parquet size: 4.4 MB rows: 318,067 symbols: 3,270
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-13 04:15:00 | AAPL | Stock | 4.4732 | 4.4732 | 4.4643 | 4.4643 | 25200.0 |
| 2008-03-13 04:30:00 | AAPL | Stock | 4.4554 | 4.4554 | 4.4554 | 4.4554 | 5600.0 |
| 2008-03-13 05:05:00 | AAPL | Stock | 4.4375 | 4.4375 | 4.4375 | 4.4375 | 8400.0 |
| 2008-03-13 06:05:00 | AAPL | Stock | 4.4318 | 4.4318 | 4.4318 | 4.4318 | 16800.0 |
| 2008-03-13 07:20:00 | AAPL | Stock | 4.4314 | 4.4314 | 4.4314 | 4.4314 | 13580.0 |
| 2008-03-13 07:25:00 | AAPL | Stock | 4.4375 | 4.4375 | 4.4311 | 4.4311 | 30800.0 |
| 2008-03-13 07:30:00 | AAPL | Stock | 4.4321 | 4.4321 | 4.4321 | 4.4321 | 14000.0 |
| 2008-03-13 07:35:00 | AAPL | Stock | 4.4289 | 4.4289 | 4.4282 | 4.4282 | 18200.0 |
| 2008-03-13 07:40:00 | AAPL | Stock | 4.4239 | 4.4286 | 4.4239 | 4.4239 | 16800.0 |
| 2008-03-13 07:45:00 | AAPL | Stock | 4.4286 | 4.4286 | 4.4286 | 4.4286 | 131600.0 |
| 2008-03-13 08:00:00 | AAPL | Stock | 4.4389 | 4.4539 | 4.4286 | 4.4321 | 610540.0 |
| 2008-03-13 08:05:00 | AAPL | Stock | 4.4321 | 4.4336 | 4.4286 | 4.4286 | 327292.0 |
| 2008-03-13 08:10:00 | AAPL | Stock | 4.4289 | 4.4321 | 4.4286 | 4.4289 | 123900.0 |
| 2008-03-13 08:15:00 | AAPL | Stock | 4.4286 | 4.4318 | 4.4268 | 4.4296 | 205016.0 |
| 2008-03-13 08:20:00 | AAPL | Stock | 4.4321 | 4.4354 | 4.4307 | 4.4307 | 310100.0 |
| 2008-03-13 08:25:00 | AAPL | Stock | 4.4286 | 4.4321 | 4.4264 | 4.4321 | 302960.0 |
| 2008-03-13 08:30:00 | AAPL | Stock | 4.4268 | 4.4346 | 4.4186 | 4.4321 | 645372.0 |
| 2008-03-13 08:35:00 | AAPL | Stock | 4.4357 | 4.4389 | 4.4286 | 4.4286 | 253624.0 |
| 2008-03-13 08:40:00 | AAPL | Stock | 4.4286 | 4.4321 | 4.4268 | 4.4289 | 318164.0 |
| 2008-03-13 08:45:00 | AAPL | Stock | 4.4286 | 4.4339 | 4.4268 | 4.4286 | 746956.0 |
| 2008-03-13 08:50:00 | AAPL | Stock | 4.4286 | 4.4318 | 4.4268 | 4.4318 | 263312.0 |
| 2008-03-13 08:55:00 | AAPL | Stock | 4.4318 | 4.4318 | 4.4196 | 4.4211 | 376852.0 |
| 2008-03-13 09:00:00 | AAPL | Stock | 4.4214 | 4.4243 | 4.4207 | 4.4218 | 233408.0 |
| 2008-03-13 09:05:00 | AAPL | Stock | 4.4236 | 4.4254 | 4.4214 | 4.425 | 255556.0 |
| 2008-03-13 09:10:00 | AAPL | Stock | 4.4246 | 4.4332 | 4.4246 | 4.4296 | 185444.0 |
| 2008-03-13 09:15:00 | AAPL | Stock | 4.4325 | 4.4332 | 4.4264 | 4.4264 | 187740.0 |
| 2008-03-13 09:20:00 | AAPL | Stock | 4.4286 | 4.4339 | 4.425 | 4.4311 | 193480.0 |
| 2008-03-13 09:25:00 | AAPL | Stock | 4.4321 | 4.4407 | 4.4214 | 4.4343 | 945392.0 |
| 2008-03-13 09:30:00 | AAPL | Stock | 4.4325 | 4.4382 | 4.4014 | 4.415 | 29052772.0 |
| 2008-03-13 09:35:00 | AAPL | Stock | 4.4157 | 4.4489 | 4.4129 | 4.4368 | 25814824.0 |
| 2008-03-13 09:40:00 | AAPL | Stock | 4.4371 | 4.4575 | 4.4132 | 4.4229 | 21495012.0 |
| 2008-03-13 09:45:00 | AAPL | Stock | 4.4239 | 4.4325 | 4.41 | 4.4286 | 19945856.0 |
| 2008-03-13 09:50:00 | AAPL | Stock | 4.4289 | 4.4507 | 4.4232 | 4.4343 | 20160980.0 |
| 2008-03-13 09:55:00 | AAPL | Stock | 4.4343 | 4.4518 | 4.4057 | 4.4221 | 23180948.0 |
| 2008-03-13 10:00:00 | AAPL | Stock | 4.4221 | 4.4396 | 4.4111 | 4.4364 | 19500880.0 |
| 2008-03-13 10:05:00 | AAPL | Stock | 4.4357 | 4.4561 | 4.4225 | 4.4486 | 21796572.0 |
| 2008-03-13 10:10:00 | AAPL | Stock | 4.4482 | 4.4661 | 4.445 | 4.4475 | 24842944.0 |
| 2008-03-13 10:15:00 | AAPL | Stock | 4.4475 | 4.4554 | 4.4293 | 4.4321 | 14746228.0 |
| 2008-03-13 10:20:00 | AAPL | Stock | 4.4321 | 4.4443 | 4.4207 | 4.4264 | 14488040.0 |
| 2008-03-13 10:25:00 | AAPL | Stock | 4.4264 | 4.4389 | 4.4218 | 4.4375 | 10823596.0 |
| 2008-03-13 10:30:00 | AAPL | Stock | 4.4375 | 4.4393 | 4.425 | 4.4336 | 11145568.0 |
| 2008-03-13 10:35:00 | AAPL | Stock | 4.4325 | 4.4375 | 4.4107 | 4.4125 | 20722044.0 |
| 2008-03-13 10:40:00 | AAPL | Stock | 4.4121 | 4.4243 | 4.4043 | 4.4182 | 13355468.0 |
| 2008-03-13 10:45:00 | AAPL | Stock | 4.4179 | 4.4179 | 4.3929 | 4.4077 | 16334332.0 |
| 2008-03-13 10:50:00 | AAPL | Stock | 4.4071 | 4.4168 | 4.4029 | 4.4059 | 8499484.0 |
| 2008-03-13 10:55:00 | AAPL | Stock | 4.4068 | 4.4214 | 4.4021 | 4.415 | 11281452.0 |
| 2008-03-13 11:00:00 | AAPL | Stock | 4.4157 | 4.4246 | 4.4057 | 4.4136 | 11728836.0 |
| 2008-03-13 11:05:00 | AAPL | Stock | 4.4136 | 4.4482 | 4.4136 | 4.4304 | 23817080.0 |
| 2008-03-13 11:10:00 | AAPL | Stock | 4.4293 | 4.4446 | 4.4229 | 4.428 | 18778760.0 |
| 2008-03-13 11:15:00 | AAPL | Stock | 4.4279 | 4.4286 | 4.4118 | 4.4132 | 11334680.0 |
> showing 50 of 318,067 rows — these rows as CSV