PREVIEW / stock_5min / 2003-10-13
file: by_date/stock_5min/2003/2003-10-13.parquet size: 2.1 MB rows: 154,243 symbols: 1,642
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-13 08:00:00 | AAPL | Stock | 0.4223 | 0.4223 | 0.4223 | 0.4223 | 61600.0 |
| 2003-10-13 08:35:00 | AAPL | Stock | 0.4239 | 0.4239 | 0.4239 | 0.4239 | 56000.0 |
| 2003-10-13 08:55:00 | AAPL | Stock | 0.4245 | 0.4245 | 0.4245 | 0.4245 | 28000.0 |
| 2003-10-13 09:00:00 | AAPL | Stock | 0.4239 | 0.4245 | 0.4239 | 0.4243 | 89600.0 |
| 2003-10-13 09:05:00 | AAPL | Stock | 0.4243 | 0.4243 | 0.4238 | 0.4238 | 123200.0 |
| 2003-10-13 09:10:00 | AAPL | Stock | 0.4245 | 0.4245 | 0.4245 | 0.4245 | 22400.0 |
| 2003-10-13 09:25:00 | AAPL | Stock | 0.4239 | 0.425 | 0.4236 | 0.425 | 901600.0 |
| 2003-10-13 09:30:00 | AAPL | Stock | 0.4238 | 0.425 | 0.4236 | 0.4243 | 4438336.0 |
| 2003-10-13 09:35:00 | AAPL | Stock | 0.4243 | 0.425 | 0.4238 | 0.425 | 2357040.0 |
| 2003-10-13 09:40:00 | AAPL | Stock | 0.425 | 0.425 | 0.4241 | 0.4243 | 4288200.0 |
| 2003-10-13 09:45:00 | AAPL | Stock | 0.4243 | 0.4252 | 0.4238 | 0.425 | 1838480.0 |
| 2003-10-13 09:50:00 | AAPL | Stock | 0.425 | 0.4264 | 0.4248 | 0.4261 | 3981600.0 |
| 2003-10-13 09:55:00 | AAPL | Stock | 0.4261 | 0.4268 | 0.4254 | 0.4261 | 3740800.0 |
| 2003-10-13 10:00:00 | AAPL | Stock | 0.4266 | 0.4268 | 0.4255 | 0.4268 | 2304064.0 |
| 2003-10-13 10:05:00 | AAPL | Stock | 0.4268 | 0.4286 | 0.4263 | 0.4284 | 6628552.0 |
| 2003-10-13 10:10:00 | AAPL | Stock | 0.4282 | 0.4282 | 0.427 | 0.4271 | 1915200.0 |
| 2003-10-13 10:15:00 | AAPL | Stock | 0.4271 | 0.4284 | 0.4271 | 0.4279 | 2236584.0 |
| 2003-10-13 10:20:00 | AAPL | Stock | 0.4282 | 0.4284 | 0.4277 | 0.4282 | 2489312.0 |
| 2003-10-13 10:25:00 | AAPL | Stock | 0.4284 | 0.4289 | 0.4282 | 0.4288 | 6247808.0 |
| 2003-10-13 10:30:00 | AAPL | Stock | 0.4289 | 0.4289 | 0.4279 | 0.4282 | 3180240.0 |
| 2003-10-13 10:35:00 | AAPL | Stock | 0.4282 | 0.4288 | 0.4279 | 0.4279 | 1623832.0 |
| 2003-10-13 10:40:00 | AAPL | Stock | 0.4279 | 0.4284 | 0.4275 | 0.4284 | 1566376.0 |
| 2003-10-13 10:45:00 | AAPL | Stock | 0.4284 | 0.4284 | 0.427 | 0.4273 | 1528800.0 |
| 2003-10-13 10:50:00 | AAPL | Stock | 0.4273 | 0.4282 | 0.4266 | 0.4279 | 2228800.0 |
| 2003-10-13 10:55:00 | AAPL | Stock | 0.428 | 0.4284 | 0.428 | 0.4284 | 817600.0 |
| 2003-10-13 11:00:00 | AAPL | Stock | 0.4282 | 0.4288 | 0.4279 | 0.428 | 2116800.0 |
| 2003-10-13 11:05:00 | AAPL | Stock | 0.4282 | 0.4286 | 0.428 | 0.4284 | 1457232.0 |
| 2003-10-13 11:10:00 | AAPL | Stock | 0.4284 | 0.43 | 0.428 | 0.4298 | 3808000.0 |
| 2003-10-13 11:15:00 | AAPL | Stock | 0.4298 | 0.4302 | 0.4295 | 0.43 | 1602832.0 |
| 2003-10-13 11:20:00 | AAPL | Stock | 0.43 | 0.43 | 0.4291 | 0.4291 | 1472016.0 |
| 2003-10-13 11:25:00 | AAPL | Stock | 0.4291 | 0.4293 | 0.4284 | 0.4288 | 1892800.0 |
| 2003-10-13 11:30:00 | AAPL | Stock | 0.4288 | 0.4296 | 0.4286 | 0.4295 | 1909600.0 |
| 2003-10-13 11:35:00 | AAPL | Stock | 0.4292 | 0.4307 | 0.4292 | 0.4305 | 2032016.0 |
| 2003-10-13 11:40:00 | AAPL | Stock | 0.4305 | 0.433 | 0.4304 | 0.4329 | 9894304.0 |
| 2003-10-13 11:45:00 | AAPL | Stock | 0.4327 | 0.4343 | 0.4323 | 0.4339 | 11048800.0 |
| 2003-10-13 11:50:00 | AAPL | Stock | 0.4339 | 0.4343 | 0.433 | 0.4334 | 5785304.0 |
| 2003-10-13 11:55:00 | AAPL | Stock | 0.4337 | 0.4348 | 0.4332 | 0.4345 | 4696832.0 |
| 2003-10-13 12:00:00 | AAPL | Stock | 0.4345 | 0.4348 | 0.4343 | 0.4348 | 2264136.0 |
| 2003-10-13 12:05:00 | AAPL | Stock | 0.4348 | 0.4355 | 0.4346 | 0.4352 | 3399200.0 |
| 2003-10-13 12:10:00 | AAPL | Stock | 0.435 | 0.4357 | 0.435 | 0.4354 | 2394560.0 |
| 2003-10-13 12:15:00 | AAPL | Stock | 0.4354 | 0.4357 | 0.4354 | 0.4355 | 2999584.0 |
| 2003-10-13 12:20:00 | AAPL | Stock | 0.4354 | 0.4357 | 0.435 | 0.435 | 2447872.0 |
| 2003-10-13 12:25:00 | AAPL | Stock | 0.435 | 0.4352 | 0.4345 | 0.4346 | 2867200.0 |
| 2003-10-13 12:30:00 | AAPL | Stock | 0.4345 | 0.4359 | 0.4345 | 0.4357 | 2005360.0 |
| 2003-10-13 12:35:00 | AAPL | Stock | 0.4359 | 0.4359 | 0.4355 | 0.4355 | 1276352.0 |
| 2003-10-13 12:40:00 | AAPL | Stock | 0.4355 | 0.4355 | 0.4348 | 0.4354 | 1970248.0 |
| 2003-10-13 12:45:00 | AAPL | Stock | 0.4354 | 0.4355 | 0.4348 | 0.4354 | 1243200.0 |
| 2003-10-13 12:50:00 | AAPL | Stock | 0.4354 | 0.4355 | 0.4346 | 0.4348 | 2357600.0 |
| 2003-10-13 12:55:00 | AAPL | Stock | 0.4348 | 0.4354 | 0.4341 | 0.4343 | 1908704.0 |
| 2003-10-13 13:00:00 | AAPL | Stock | 0.4341 | 0.4346 | 0.4341 | 0.4343 | 1528800.0 |
> showing 50 of 154,243 rows — these rows as CSV