PREVIEW / stock_5min / 2007-07-20
file: by_date/stock_5min/2007/2007-07-20.parquet size: 4.1 MB rows: 298,437 symbols: 3,062
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-07-20 09:30:00 | AAPL | Stock | 5.0589 | 5.0625 | 5.0393 | 5.0621 | 90596856.0 |
| 2007-07-20 09:35:00 | AAPL | Stock | 5.0618 | 5.0657 | 5.0496 | 5.0543 | 21073696.0 |
| 2007-07-20 09:40:00 | AAPL | Stock | 5.0543 | 5.0625 | 5.0525 | 5.0536 | 17048248.0 |
| 2007-07-20 09:45:00 | AAPL | Stock | 5.0532 | 5.0539 | 5.0446 | 5.0479 | 14217196.0 |
| 2007-07-20 09:50:00 | AAPL | Stock | 5.0479 | 5.0554 | 5.0457 | 5.0457 | 14589260.0 |
| 2007-07-20 09:55:00 | AAPL | Stock | 5.0454 | 5.0461 | 5.0139 | 5.03 | 37379356.0 |
| 2007-07-20 10:00:00 | AAPL | Stock | 5.0293 | 5.0389 | 5.0239 | 5.0379 | 14367080.0 |
| 2007-07-20 10:05:00 | AAPL | Stock | 5.0379 | 5.0432 | 5.0368 | 5.0386 | 12480552.0 |
| 2007-07-20 10:10:00 | AAPL | Stock | 5.0386 | 5.0407 | 5.0289 | 5.0386 | 12312524.0 |
| 2007-07-20 10:15:00 | AAPL | Stock | 5.0382 | 5.0386 | 5.0304 | 5.0336 | 11548740.0 |
| 2007-07-20 10:20:00 | AAPL | Stock | 5.0339 | 5.0386 | 5.0236 | 5.0289 | 11360188.0 |
| 2007-07-20 10:25:00 | AAPL | Stock | 5.0288 | 5.0339 | 5.0257 | 5.0311 | 7505064.0 |
| 2007-07-20 10:30:00 | AAPL | Stock | 5.0311 | 5.0336 | 5.0246 | 5.0277 | 9745792.0 |
| 2007-07-20 10:35:00 | AAPL | Stock | 5.0279 | 5.0296 | 5.0121 | 5.0236 | 16069228.0 |
| 2007-07-20 10:40:00 | AAPL | Stock | 5.0239 | 5.0357 | 5.0225 | 5.0229 | 12348364.0 |
| 2007-07-20 10:45:00 | AAPL | Stock | 5.0232 | 5.0271 | 5.0171 | 5.0261 | 9361128.0 |
| 2007-07-20 10:50:00 | AAPL | Stock | 5.0264 | 5.0357 | 5.0229 | 5.0254 | 17375792.0 |
| 2007-07-20 10:55:00 | AAPL | Stock | 5.025 | 5.0357 | 5.0243 | 5.0289 | 5511772.0 |
| 2007-07-20 11:00:00 | AAPL | Stock | 5.0289 | 5.0339 | 5.0282 | 5.0337 | 5965512.0 |
| 2007-07-20 11:05:00 | AAPL | Stock | 5.0339 | 5.0425 | 5.0321 | 5.0418 | 8666140.0 |
| 2007-07-20 11:10:00 | AAPL | Stock | 5.0421 | 5.0446 | 5.0379 | 5.0439 | 8082760.0 |
| 2007-07-20 11:15:00 | AAPL | Stock | 5.0436 | 5.0446 | 5.0357 | 5.0364 | 6353844.0 |
| 2007-07-20 11:20:00 | AAPL | Stock | 5.0364 | 5.0368 | 5.0286 | 5.0328 | 9194724.0 |
| 2007-07-20 11:25:00 | AAPL | Stock | 5.0321 | 5.0425 | 5.0296 | 5.0386 | 7862400.0 |
| 2007-07-20 11:30:00 | AAPL | Stock | 5.0381 | 5.0436 | 5.0379 | 5.0404 | 6801844.0 |
| 2007-07-20 11:35:00 | AAPL | Stock | 5.0407 | 5.0454 | 5.0289 | 5.0332 | 13997424.0 |
| 2007-07-20 11:40:00 | AAPL | Stock | 5.0332 | 5.0386 | 5.0314 | 5.0318 | 8851976.0 |
| 2007-07-20 11:45:00 | AAPL | Stock | 5.0318 | 5.0336 | 5.0289 | 5.0289 | 6698356.0 |
| 2007-07-20 11:50:00 | AAPL | Stock | 5.0293 | 5.0298 | 5.0179 | 5.0193 | 12069680.0 |
| 2007-07-20 11:55:00 | AAPL | Stock | 5.0193 | 5.0296 | 5.0179 | 5.0279 | 9488892.0 |
| 2007-07-20 12:00:00 | AAPL | Stock | 5.0282 | 5.0282 | 5.0007 | 5.0011 | 17711960.0 |
| 2007-07-20 12:05:00 | AAPL | Stock | 5.0011 | 5.0096 | 5.0 | 5.0064 | 15722028.0 |
| 2007-07-20 12:10:00 | AAPL | Stock | 5.0068 | 5.0257 | 5.0064 | 5.015 | 9455208.0 |
| 2007-07-20 12:15:00 | AAPL | Stock | 5.0139 | 5.0171 | 5.0125 | 5.0139 | 5198592.0 |
| 2007-07-20 12:20:00 | AAPL | Stock | 5.0139 | 5.0236 | 5.0139 | 5.0221 | 7804384.0 |
| 2007-07-20 12:25:00 | AAPL | Stock | 5.0218 | 5.0332 | 5.0218 | 5.0329 | 10073364.0 |
| 2007-07-20 12:30:00 | AAPL | Stock | 5.0329 | 5.0343 | 5.0276 | 5.0321 | 7654248.0 |
| 2007-07-20 12:35:00 | AAPL | Stock | 5.0318 | 5.0332 | 5.0275 | 5.0286 | 5491416.0 |
| 2007-07-20 12:40:00 | AAPL | Stock | 5.0286 | 5.0375 | 5.0271 | 5.0361 | 8599388.0 |
| 2007-07-20 12:45:00 | AAPL | Stock | 5.0364 | 5.0443 | 5.0357 | 5.04 | 12988388.0 |
| 2007-07-20 12:50:00 | AAPL | Stock | 5.0393 | 5.0429 | 5.0361 | 5.0364 | 8452360.0 |
| 2007-07-20 12:55:00 | AAPL | Stock | 5.0364 | 5.04 | 5.0257 | 5.0314 | 10089884.0 |
| 2007-07-20 13:00:00 | AAPL | Stock | 5.0314 | 5.0361 | 5.0286 | 5.0325 | 7615132.0 |
| 2007-07-20 13:05:00 | AAPL | Stock | 5.0329 | 5.0414 | 5.0318 | 5.0368 | 6320244.0 |
| 2007-07-20 13:10:00 | AAPL | Stock | 5.0375 | 5.0429 | 5.0357 | 5.0375 | 6404664.0 |
| 2007-07-20 13:15:00 | AAPL | Stock | 5.0375 | 5.048 | 5.0375 | 5.0471 | 10998316.0 |
| 2007-07-20 13:20:00 | AAPL | Stock | 5.0471 | 5.065 | 5.0446 | 5.0643 | 24283112.0 |
| 2007-07-20 13:25:00 | AAPL | Stock | 5.0643 | 5.0679 | 5.0548 | 5.0568 | 13727000.0 |
| 2007-07-20 13:30:00 | AAPL | Stock | 5.0563 | 5.0564 | 5.0514 | 5.0543 | 8048740.0 |
| 2007-07-20 13:35:00 | AAPL | Stock | 5.0543 | 5.0611 | 5.0536 | 5.0589 | 7352268.0 |
> showing 50 of 298,437 rows — these rows as CSV