PREVIEW / stock_5min / 2003-06-25
file: by_date/stock_5min/2003/2003-06-25.parquet size: 2.1 MB rows: 152,317 symbols: 1,583
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-25 08:30:00 | AAPL | Stock | 0.3368 | 0.3368 | 0.3368 | 0.3368 | 28000.0 |
| 2003-06-25 08:45:00 | AAPL | Stock | 0.3368 | 0.3368 | 0.3368 | 0.3368 | 50400.0 |
| 2003-06-25 09:15:00 | AAPL | Stock | 0.3368 | 0.3368 | 0.3368 | 0.3368 | 173600.0 |
| 2003-06-25 09:25:00 | AAPL | Stock | 0.3366 | 0.3366 | 0.3366 | 0.3366 | 11200.0 |
| 2003-06-25 09:30:00 | AAPL | Stock | 0.3368 | 0.3421 | 0.3359 | 0.341 | 5083400.0 |
| 2003-06-25 09:35:00 | AAPL | Stock | 0.3407 | 0.3409 | 0.3389 | 0.3395 | 4582368.0 |
| 2003-06-25 09:40:00 | AAPL | Stock | 0.3395 | 0.3405 | 0.3395 | 0.3398 | 1904280.0 |
| 2003-06-25 09:45:00 | AAPL | Stock | 0.3398 | 0.3413 | 0.3398 | 0.3411 | 2579696.0 |
| 2003-06-25 09:50:00 | AAPL | Stock | 0.3413 | 0.3429 | 0.3411 | 0.3425 | 4761568.0 |
| 2003-06-25 09:55:00 | AAPL | Stock | 0.3423 | 0.3432 | 0.342 | 0.3432 | 4577272.0 |
| 2003-06-25 10:00:00 | AAPL | Stock | 0.3434 | 0.3439 | 0.3431 | 0.3436 | 5414528.0 |
| 2003-06-25 10:05:00 | AAPL | Stock | 0.3436 | 0.3436 | 0.3423 | 0.3432 | 3315368.0 |
| 2003-06-25 10:10:00 | AAPL | Stock | 0.3434 | 0.3438 | 0.343 | 0.3432 | 3276000.0 |
| 2003-06-25 10:15:00 | AAPL | Stock | 0.3434 | 0.3436 | 0.3425 | 0.3432 | 3853024.0 |
| 2003-06-25 10:20:00 | AAPL | Stock | 0.343 | 0.3436 | 0.3427 | 0.3432 | 3132976.0 |
| 2003-06-25 10:25:00 | AAPL | Stock | 0.3432 | 0.3434 | 0.3425 | 0.3427 | 2029328.0 |
| 2003-06-25 10:30:00 | AAPL | Stock | 0.3427 | 0.3429 | 0.3425 | 0.3425 | 3889872.0 |
| 2003-06-25 10:35:00 | AAPL | Stock | 0.3425 | 0.3429 | 0.3423 | 0.3423 | 2672320.0 |
| 2003-06-25 10:40:00 | AAPL | Stock | 0.3423 | 0.343 | 0.3416 | 0.3418 | 3068688.0 |
| 2003-06-25 10:45:00 | AAPL | Stock | 0.342 | 0.3429 | 0.3418 | 0.3428 | 1377600.0 |
| 2003-06-25 10:50:00 | AAPL | Stock | 0.3429 | 0.3432 | 0.3427 | 0.3432 | 1865472.0 |
| 2003-06-25 10:55:00 | AAPL | Stock | 0.3431 | 0.3431 | 0.3427 | 0.343 | 744800.0 |
| 2003-06-25 11:00:00 | AAPL | Stock | 0.343 | 0.3436 | 0.3425 | 0.3425 | 2097816.0 |
| 2003-06-25 11:05:00 | AAPL | Stock | 0.3429 | 0.343 | 0.3425 | 0.343 | 875392.0 |
| 2003-06-25 11:10:00 | AAPL | Stock | 0.343 | 0.3432 | 0.3427 | 0.3432 | 655648.0 |
| 2003-06-25 11:15:00 | AAPL | Stock | 0.3432 | 0.3438 | 0.343 | 0.3438 | 2870000.0 |
| 2003-06-25 11:20:00 | AAPL | Stock | 0.3432 | 0.3436 | 0.3429 | 0.3432 | 2665600.0 |
| 2003-06-25 11:25:00 | AAPL | Stock | 0.343 | 0.3436 | 0.343 | 0.3434 | 537600.0 |
| 2003-06-25 11:30:00 | AAPL | Stock | 0.3434 | 0.3439 | 0.343 | 0.343 | 1837472.0 |
| 2003-06-25 11:35:00 | AAPL | Stock | 0.3432 | 0.3432 | 0.343 | 0.343 | 789600.0 |
| 2003-06-25 11:40:00 | AAPL | Stock | 0.3432 | 0.3432 | 0.3423 | 0.3427 | 1024800.0 |
| 2003-06-25 11:45:00 | AAPL | Stock | 0.3425 | 0.3427 | 0.3421 | 0.3421 | 1808800.0 |
| 2003-06-25 11:50:00 | AAPL | Stock | 0.3422 | 0.3423 | 0.3418 | 0.3418 | 1282400.0 |
| 2003-06-25 11:55:00 | AAPL | Stock | 0.3418 | 0.342 | 0.3414 | 0.3418 | 924000.0 |
| 2003-06-25 12:00:00 | AAPL | Stock | 0.3418 | 0.342 | 0.3416 | 0.342 | 862400.0 |
| 2003-06-25 12:05:00 | AAPL | Stock | 0.3418 | 0.342 | 0.3418 | 0.342 | 716800.0 |
| 2003-06-25 12:10:00 | AAPL | Stock | 0.342 | 0.3427 | 0.3418 | 0.342 | 1489600.0 |
| 2003-06-25 12:15:00 | AAPL | Stock | 0.342 | 0.342 | 0.3416 | 0.3418 | 621600.0 |
| 2003-06-25 12:20:00 | AAPL | Stock | 0.3418 | 0.3418 | 0.3411 | 0.3418 | 408800.0 |
| 2003-06-25 12:25:00 | AAPL | Stock | 0.3418 | 0.3425 | 0.3416 | 0.3425 | 756000.0 |
| 2003-06-25 12:30:00 | AAPL | Stock | 0.3423 | 0.3436 | 0.3423 | 0.3432 | 2092160.0 |
| 2003-06-25 12:35:00 | AAPL | Stock | 0.3434 | 0.3436 | 0.343 | 0.3434 | 498400.0 |
| 2003-06-25 12:40:00 | AAPL | Stock | 0.3434 | 0.3438 | 0.3434 | 0.3438 | 582400.0 |
| 2003-06-25 12:45:00 | AAPL | Stock | 0.3437 | 0.3439 | 0.3436 | 0.3438 | 2043552.0 |
| 2003-06-25 12:50:00 | AAPL | Stock | 0.3436 | 0.3436 | 0.343 | 0.3432 | 952000.0 |
| 2003-06-25 12:55:00 | AAPL | Stock | 0.3432 | 0.3438 | 0.343 | 0.3438 | 684768.0 |
| 2003-06-25 13:00:00 | AAPL | Stock | 0.3436 | 0.3441 | 0.3436 | 0.3436 | 3242400.0 |
| 2003-06-25 13:05:00 | AAPL | Stock | 0.3436 | 0.3446 | 0.3436 | 0.3443 | 2049600.0 |
| 2003-06-25 13:10:00 | AAPL | Stock | 0.3445 | 0.3446 | 0.3443 | 0.3446 | 817600.0 |
| 2003-06-25 13:15:00 | AAPL | Stock | 0.3445 | 0.3446 | 0.3439 | 0.3443 | 1254400.0 |
> showing 50 of 152,317 rows — these rows as CSV