PREVIEW / stock_5min / 2001-07-17
file: by_date/stock_5min/2001/2001-07-17.parquet size: 1.6 MB rows: 108,985 symbols: 1,308
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-17 08:00:00 | AAPL | Stock | 0.4277 | 0.4277 | 0.4277 | 0.4277 | 5600.0 |
| 2001-07-17 08:25:00 | AAPL | Stock | 0.4282 | 0.4282 | 0.428 | 0.428 | 28000.0 |
| 2001-07-17 08:45:00 | AAPL | Stock | 0.4277 | 0.4277 | 0.4277 | 0.4277 | 11200.0 |
| 2001-07-17 08:50:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4286 | 0.4286 | 28000.0 |
| 2001-07-17 09:05:00 | AAPL | Stock | 0.4289 | 0.4291 | 0.4289 | 0.4291 | 33600.0 |
| 2001-07-17 09:10:00 | AAPL | Stock | 0.4291 | 0.4291 | 0.4275 | 0.4275 | 190400.0 |
| 2001-07-17 09:15:00 | AAPL | Stock | 0.4305 | 0.4311 | 0.4291 | 0.4291 | 72800.0 |
| 2001-07-17 09:20:00 | AAPL | Stock | 0.4291 | 0.4295 | 0.4284 | 0.4286 | 677600.0 |
| 2001-07-17 09:25:00 | AAPL | Stock | 0.4291 | 0.4291 | 0.4282 | 0.4282 | 168000.0 |
| 2001-07-17 09:30:00 | AAPL | Stock | 0.4284 | 0.4321 | 0.4268 | 0.4313 | 12712000.0 |
| 2001-07-17 09:35:00 | AAPL | Stock | 0.4313 | 0.4332 | 0.4302 | 0.4329 | 13619200.0 |
| 2001-07-17 09:40:00 | AAPL | Stock | 0.4329 | 0.4375 | 0.4321 | 0.4321 | 17348800.0 |
| 2001-07-17 09:45:00 | AAPL | Stock | 0.4321 | 0.4339 | 0.4268 | 0.4277 | 9128000.0 |
| 2001-07-17 09:50:00 | AAPL | Stock | 0.428 | 0.4286 | 0.4268 | 0.4284 | 11704000.0 |
| 2001-07-17 09:55:00 | AAPL | Stock | 0.4284 | 0.4321 | 0.4275 | 0.4311 | 7672000.0 |
| 2001-07-17 10:00:00 | AAPL | Stock | 0.4311 | 0.433 | 0.4305 | 0.4321 | 3948000.0 |
| 2001-07-17 10:05:00 | AAPL | Stock | 0.432 | 0.4321 | 0.4277 | 0.4277 | 6927200.0 |
| 2001-07-17 10:10:00 | AAPL | Stock | 0.4277 | 0.4286 | 0.4257 | 0.4263 | 6216000.0 |
| 2001-07-17 10:15:00 | AAPL | Stock | 0.4263 | 0.428 | 0.4259 | 0.4277 | 12180000.0 |
| 2001-07-17 10:20:00 | AAPL | Stock | 0.4277 | 0.4295 | 0.4263 | 0.4284 | 13434400.0 |
| 2001-07-17 10:25:00 | AAPL | Stock | 0.4284 | 0.4309 | 0.4284 | 0.4304 | 10718400.0 |
| 2001-07-17 10:30:00 | AAPL | Stock | 0.4305 | 0.4363 | 0.4304 | 0.4339 | 8456000.0 |
| 2001-07-17 10:35:00 | AAPL | Stock | 0.4345 | 0.4345 | 0.4327 | 0.4334 | 4211200.0 |
| 2001-07-17 10:40:00 | AAPL | Stock | 0.4321 | 0.4355 | 0.4321 | 0.4336 | 7263200.0 |
| 2001-07-17 10:45:00 | AAPL | Stock | 0.4336 | 0.4343 | 0.4314 | 0.4323 | 3186400.0 |
| 2001-07-17 10:50:00 | AAPL | Stock | 0.4321 | 0.4323 | 0.4296 | 0.4307 | 3729600.0 |
| 2001-07-17 10:55:00 | AAPL | Stock | 0.4309 | 0.4318 | 0.4304 | 0.4304 | 2609600.0 |
| 2001-07-17 11:00:00 | AAPL | Stock | 0.4304 | 0.432 | 0.4296 | 0.4296 | 2872800.0 |
| 2001-07-17 11:05:00 | AAPL | Stock | 0.4298 | 0.4304 | 0.4286 | 0.4304 | 3091200.0 |
| 2001-07-17 11:10:00 | AAPL | Stock | 0.4304 | 0.4329 | 0.4295 | 0.4314 | 1148000.0 |
| 2001-07-17 11:15:00 | AAPL | Stock | 0.4318 | 0.4318 | 0.4279 | 0.428 | 1808800.0 |
| 2001-07-17 11:20:00 | AAPL | Stock | 0.428 | 0.4286 | 0.4268 | 0.4277 | 4474400.0 |
| 2001-07-17 11:25:00 | AAPL | Stock | 0.4277 | 0.4295 | 0.4275 | 0.4293 | 2783200.0 |
| 2001-07-17 11:30:00 | AAPL | Stock | 0.4293 | 0.43 | 0.4279 | 0.4282 | 2150400.0 |
| 2001-07-17 11:35:00 | AAPL | Stock | 0.4282 | 0.4286 | 0.4271 | 0.4271 | 1064000.0 |
| 2001-07-17 11:40:00 | AAPL | Stock | 0.4277 | 0.428 | 0.4268 | 0.4277 | 2424800.0 |
| 2001-07-17 11:45:00 | AAPL | Stock | 0.4273 | 0.4288 | 0.4263 | 0.4284 | 3578400.0 |
| 2001-07-17 11:50:00 | AAPL | Stock | 0.4282 | 0.4295 | 0.4266 | 0.4266 | 2380000.0 |
| 2001-07-17 11:55:00 | AAPL | Stock | 0.4264 | 0.4268 | 0.4221 | 0.4223 | 5258400.0 |
| 2001-07-17 12:00:00 | AAPL | Stock | 0.4221 | 0.4239 | 0.4221 | 0.4236 | 3231200.0 |
| 2001-07-17 12:05:00 | AAPL | Stock | 0.4234 | 0.4236 | 0.4186 | 0.4188 | 5628000.0 |
| 2001-07-17 12:10:00 | AAPL | Stock | 0.4188 | 0.4188 | 0.4148 | 0.4157 | 7571200.0 |
| 2001-07-17 12:15:00 | AAPL | Stock | 0.4161 | 0.4173 | 0.4154 | 0.4159 | 3707200.0 |
| 2001-07-17 12:20:00 | AAPL | Stock | 0.4159 | 0.4171 | 0.4145 | 0.4145 | 8310400.0 |
| 2001-07-17 12:25:00 | AAPL | Stock | 0.4143 | 0.4154 | 0.4125 | 0.4152 | 8562400.0 |
| 2001-07-17 12:30:00 | AAPL | Stock | 0.4152 | 0.4157 | 0.4121 | 0.4121 | 7565600.0 |
| 2001-07-17 12:35:00 | AAPL | Stock | 0.4121 | 0.4152 | 0.4109 | 0.4152 | 8075200.0 |
| 2001-07-17 12:40:00 | AAPL | Stock | 0.4154 | 0.4189 | 0.4134 | 0.4179 | 7481600.0 |
| 2001-07-17 12:45:00 | AAPL | Stock | 0.4186 | 0.4245 | 0.417 | 0.4213 | 13893600.0 |
| 2001-07-17 12:50:00 | AAPL | Stock | 0.4213 | 0.4216 | 0.4196 | 0.4209 | 2805600.0 |
> showing 50 of 108,985 rows — these rows as CSV