PREVIEW / stock_5min / 2003-06-24
file: by_date/stock_5min/2003/2003-06-24.parquet size: 2.1 MB rows: 151,037 symbols: 1,587
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-06-24 08:00:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3439 | 0.3439 | 72800.0 |
| 2003-06-24 08:25:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3457 | 0.3459 | 47040.0 |
| 2003-06-24 08:30:00 | AAPL | Stock | 0.3459 | 0.3491 | 0.3459 | 0.3473 | 1125600.0 |
| 2003-06-24 08:35:00 | AAPL | Stock | 0.3496 | 0.35 | 0.3496 | 0.35 | 95200.0 |
| 2003-06-24 08:40:00 | AAPL | Stock | 0.35 | 0.3513 | 0.35 | 0.3513 | 95760.0 |
| 2003-06-24 08:45:00 | AAPL | Stock | 0.3527 | 0.3534 | 0.3518 | 0.3518 | 168000.0 |
| 2003-06-24 08:50:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3448 | 0.3448 | 201600.0 |
| 2003-06-24 08:55:00 | AAPL | Stock | 0.3514 | 0.3527 | 0.3509 | 0.3509 | 196000.0 |
| 2003-06-24 09:00:00 | AAPL | Stock | 0.3509 | 0.3509 | 0.3502 | 0.3502 | 84000.0 |
| 2003-06-24 09:05:00 | AAPL | Stock | 0.35 | 0.35 | 0.35 | 0.35 | 109200.0 |
| 2003-06-24 09:10:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3473 | 0.3473 | 72800.0 |
| 2003-06-24 09:15:00 | AAPL | Stock | 0.35 | 0.35 | 0.35 | 0.35 | 56000.0 |
| 2003-06-24 09:20:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3464 | 0.3464 | 417200.0 |
| 2003-06-24 09:25:00 | AAPL | Stock | 0.3464 | 0.3477 | 0.3455 | 0.3473 | 464800.0 |
| 2003-06-24 09:30:00 | AAPL | Stock | 0.3477 | 0.3513 | 0.3455 | 0.3477 | 15682968.0 |
| 2003-06-24 09:35:00 | AAPL | Stock | 0.3479 | 0.3482 | 0.3454 | 0.3464 | 10689112.0 |
| 2003-06-24 09:40:00 | AAPL | Stock | 0.3464 | 0.3484 | 0.3461 | 0.3466 | 8554000.0 |
| 2003-06-24 09:45:00 | AAPL | Stock | 0.3468 | 0.3486 | 0.3459 | 0.3473 | 20682536.0 |
| 2003-06-24 09:50:00 | AAPL | Stock | 0.3471 | 0.3479 | 0.3466 | 0.3479 | 9333520.0 |
| 2003-06-24 09:55:00 | AAPL | Stock | 0.3479 | 0.3493 | 0.3473 | 0.3489 | 11588192.0 |
| 2003-06-24 10:00:00 | AAPL | Stock | 0.3488 | 0.3502 | 0.348 | 0.3482 | 10953208.0 |
| 2003-06-24 10:05:00 | AAPL | Stock | 0.3482 | 0.3488 | 0.3468 | 0.347 | 4944800.0 |
| 2003-06-24 10:10:00 | AAPL | Stock | 0.3468 | 0.347 | 0.345 | 0.345 | 7461776.0 |
| 2003-06-24 10:15:00 | AAPL | Stock | 0.345 | 0.3452 | 0.3425 | 0.3429 | 10069024.0 |
| 2003-06-24 10:20:00 | AAPL | Stock | 0.343 | 0.3441 | 0.3429 | 0.3436 | 7700224.0 |
| 2003-06-24 10:25:00 | AAPL | Stock | 0.3436 | 0.3452 | 0.3435 | 0.3441 | 5539296.0 |
| 2003-06-24 10:30:00 | AAPL | Stock | 0.3441 | 0.3446 | 0.3439 | 0.3443 | 2382800.0 |
| 2003-06-24 10:35:00 | AAPL | Stock | 0.3445 | 0.3446 | 0.3402 | 0.3421 | 7963200.0 |
| 2003-06-24 10:40:00 | AAPL | Stock | 0.342 | 0.3427 | 0.3404 | 0.3421 | 5051200.0 |
| 2003-06-24 10:45:00 | AAPL | Stock | 0.342 | 0.3425 | 0.3415 | 0.3416 | 2789248.0 |
| 2003-06-24 10:50:00 | AAPL | Stock | 0.3416 | 0.342 | 0.3411 | 0.3418 | 2228800.0 |
| 2003-06-24 10:55:00 | AAPL | Stock | 0.3418 | 0.3427 | 0.3416 | 0.3427 | 3309600.0 |
| 2003-06-24 11:00:00 | AAPL | Stock | 0.3427 | 0.343 | 0.3418 | 0.3423 | 2694944.0 |
| 2003-06-24 11:05:00 | AAPL | Stock | 0.3423 | 0.3439 | 0.3421 | 0.3438 | 2982728.0 |
| 2003-06-24 11:10:00 | AAPL | Stock | 0.3437 | 0.3438 | 0.3425 | 0.3427 | 3774232.0 |
| 2003-06-24 11:15:00 | AAPL | Stock | 0.3427 | 0.3452 | 0.3427 | 0.3448 | 4213216.0 |
| 2003-06-24 11:20:00 | AAPL | Stock | 0.3448 | 0.3463 | 0.3446 | 0.3463 | 4555824.0 |
| 2003-06-24 11:25:00 | AAPL | Stock | 0.3459 | 0.3463 | 0.3441 | 0.3446 | 3816176.0 |
| 2003-06-24 11:30:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3442 | 0.3445 | 1220800.0 |
| 2003-06-24 11:35:00 | AAPL | Stock | 0.3445 | 0.3448 | 0.3443 | 0.3443 | 1349600.0 |
| 2003-06-24 11:40:00 | AAPL | Stock | 0.3443 | 0.3445 | 0.343 | 0.3436 | 3225600.0 |
| 2003-06-24 11:45:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3431 | 0.3438 | 1383200.0 |
| 2003-06-24 11:50:00 | AAPL | Stock | 0.3438 | 0.3443 | 0.3436 | 0.3436 | 1537984.0 |
| 2003-06-24 11:55:00 | AAPL | Stock | 0.3436 | 0.3439 | 0.3432 | 0.3434 | 1301776.0 |
| 2003-06-24 12:00:00 | AAPL | Stock | 0.3434 | 0.3445 | 0.3432 | 0.3436 | 4010608.0 |
| 2003-06-24 12:05:00 | AAPL | Stock | 0.3436 | 0.3443 | 0.3434 | 0.3439 | 3248056.0 |
| 2003-06-24 12:10:00 | AAPL | Stock | 0.3439 | 0.3445 | 0.3429 | 0.3438 | 1472800.0 |
| 2003-06-24 12:15:00 | AAPL | Stock | 0.3436 | 0.3438 | 0.3434 | 0.3436 | 1720488.0 |
| 2003-06-24 12:20:00 | AAPL | Stock | 0.3437 | 0.3446 | 0.3436 | 0.3446 | 2482480.0 |
| 2003-06-24 12:25:00 | AAPL | Stock | 0.3446 | 0.3466 | 0.3446 | 0.3455 | 5611760.0 |
> showing 50 of 151,037 rows — these rows as CSV