PREVIEW / stock_5min / 2005-06-20
file: by_date/stock_5min/2005/2005-06-20.parquet size: 2.7 MB rows: 197,024 symbols: 1,987
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-20 08:00:00 | AAPL | Stock | 1.3571 | 1.3571 | 1.3571 | 1.3571 | 338520.0 |
| 2005-06-20 08:05:00 | AAPL | Stock | 1.3564 | 1.3564 | 1.3393 | 1.3543 | 271488.0 |
| 2005-06-20 08:10:00 | AAPL | Stock | 1.3525 | 1.3525 | 1.35 | 1.35 | 16800.0 |
| 2005-06-20 08:15:00 | AAPL | Stock | 1.3482 | 1.35 | 1.3479 | 1.3479 | 53200.0 |
| 2005-06-20 08:20:00 | AAPL | Stock | 1.35 | 1.35 | 1.35 | 1.35 | 25200.0 |
| 2005-06-20 08:25:00 | AAPL | Stock | 1.3525 | 1.3525 | 1.3493 | 1.3493 | 24220.0 |
| 2005-06-20 08:35:00 | AAPL | Stock | 1.3493 | 1.3493 | 1.3482 | 1.3482 | 65100.0 |
| 2005-06-20 08:40:00 | AAPL | Stock | 1.35 | 1.3511 | 1.35 | 1.3511 | 30800.0 |
| 2005-06-20 08:45:00 | AAPL | Stock | 1.3489 | 1.3525 | 1.3489 | 1.3521 | 202440.0 |
| 2005-06-20 08:50:00 | AAPL | Stock | 1.3521 | 1.3525 | 1.3521 | 1.3525 | 27020.0 |
| 2005-06-20 08:55:00 | AAPL | Stock | 1.3525 | 1.3525 | 1.35 | 1.35 | 21392.0 |
| 2005-06-20 09:00:00 | AAPL | Stock | 1.35 | 1.35 | 1.35 | 1.35 | 89740.0 |
| 2005-06-20 09:05:00 | AAPL | Stock | 1.3518 | 1.3536 | 1.3518 | 1.3536 | 100800.0 |
| 2005-06-20 09:10:00 | AAPL | Stock | 1.3521 | 1.3521 | 1.3518 | 1.3518 | 53200.0 |
| 2005-06-20 09:15:00 | AAPL | Stock | 1.35 | 1.3518 | 1.35 | 1.3518 | 46200.0 |
| 2005-06-20 09:20:00 | AAPL | Stock | 1.3518 | 1.3521 | 1.3518 | 1.3518 | 80500.0 |
| 2005-06-20 09:25:00 | AAPL | Stock | 1.3518 | 1.3536 | 1.3507 | 1.3525 | 529480.0 |
| 2005-06-20 09:30:00 | AAPL | Stock | 1.3518 | 1.3604 | 1.3493 | 1.3525 | 15823584.0 |
| 2005-06-20 09:35:00 | AAPL | Stock | 1.3522 | 1.3536 | 1.3482 | 1.35 | 9546824.0 |
| 2005-06-20 09:40:00 | AAPL | Stock | 1.35 | 1.3521 | 1.3482 | 1.3507 | 6364288.0 |
| 2005-06-20 09:45:00 | AAPL | Stock | 1.3511 | 1.3568 | 1.3507 | 1.355 | 5537000.0 |
| 2005-06-20 09:50:00 | AAPL | Stock | 1.3546 | 1.355 | 1.3504 | 1.3532 | 5709872.0 |
| 2005-06-20 09:55:00 | AAPL | Stock | 1.3532 | 1.3532 | 1.3493 | 1.3496 | 5439560.0 |
| 2005-06-20 10:00:00 | AAPL | Stock | 1.3496 | 1.35 | 1.3429 | 1.3439 | 14011760.0 |
| 2005-06-20 10:05:00 | AAPL | Stock | 1.3446 | 1.3521 | 1.3389 | 1.3407 | 16658376.0 |
| 2005-06-20 10:10:00 | AAPL | Stock | 1.3407 | 1.3425 | 1.3396 | 1.3407 | 5366816.0 |
| 2005-06-20 10:15:00 | AAPL | Stock | 1.3407 | 1.3414 | 1.3375 | 1.34 | 5015444.0 |
| 2005-06-20 10:20:00 | AAPL | Stock | 1.34 | 1.3425 | 1.3382 | 1.3404 | 4628736.0 |
| 2005-06-20 10:25:00 | AAPL | Stock | 1.3404 | 1.3436 | 1.3404 | 1.3418 | 4229988.0 |
| 2005-06-20 10:30:00 | AAPL | Stock | 1.3418 | 1.3436 | 1.3407 | 1.3411 | 5682992.0 |
| 2005-06-20 10:35:00 | AAPL | Stock | 1.3407 | 1.3461 | 1.34 | 1.3454 | 8549464.0 |
| 2005-06-20 10:40:00 | AAPL | Stock | 1.3454 | 1.3461 | 1.3414 | 1.3432 | 5265484.0 |
| 2005-06-20 10:45:00 | AAPL | Stock | 1.3432 | 1.3443 | 1.3429 | 1.3432 | 2027592.0 |
| 2005-06-20 10:50:00 | AAPL | Stock | 1.3432 | 1.3436 | 1.3421 | 1.3421 | 2610916.0 |
| 2005-06-20 10:55:00 | AAPL | Stock | 1.3421 | 1.3432 | 1.3411 | 1.3429 | 1789732.0 |
| 2005-06-20 11:00:00 | AAPL | Stock | 1.3425 | 1.3454 | 1.3411 | 1.3454 | 3946124.0 |
| 2005-06-20 11:05:00 | AAPL | Stock | 1.345 | 1.3454 | 1.3439 | 1.345 | 3102372.0 |
| 2005-06-20 11:10:00 | AAPL | Stock | 1.3454 | 1.3457 | 1.3439 | 1.3454 | 2601760.0 |
| 2005-06-20 11:15:00 | AAPL | Stock | 1.345 | 1.3457 | 1.3439 | 1.3446 | 3888780.0 |
| 2005-06-20 11:20:00 | AAPL | Stock | 1.3447 | 1.3454 | 1.3432 | 1.345 | 3616872.0 |
| 2005-06-20 11:25:00 | AAPL | Stock | 1.345 | 1.3464 | 1.3436 | 1.3454 | 1975260.0 |
| 2005-06-20 11:30:00 | AAPL | Stock | 1.345 | 1.3464 | 1.3443 | 1.3454 | 2549260.0 |
| 2005-06-20 11:35:00 | AAPL | Stock | 1.345 | 1.3454 | 1.3429 | 1.3432 | 3144568.0 |
| 2005-06-20 11:40:00 | AAPL | Stock | 1.3432 | 1.3432 | 1.3411 | 1.3432 | 3291512.0 |
| 2005-06-20 11:45:00 | AAPL | Stock | 1.3429 | 1.3436 | 1.3421 | 1.343 | 1789480.0 |
| 2005-06-20 11:50:00 | AAPL | Stock | 1.3429 | 1.345 | 1.3425 | 1.345 | 2434712.0 |
| 2005-06-20 11:55:00 | AAPL | Stock | 1.345 | 1.3464 | 1.3443 | 1.3461 | 2564268.0 |
| 2005-06-20 12:00:00 | AAPL | Stock | 1.3461 | 1.3518 | 1.3432 | 1.3441 | 5997768.0 |
| 2005-06-20 12:05:00 | AAPL | Stock | 1.3443 | 1.3461 | 1.3436 | 1.3457 | 2770796.0 |
| 2005-06-20 12:10:00 | AAPL | Stock | 1.3457 | 1.3461 | 1.3432 | 1.3452 | 2318876.0 |
> showing 50 of 197,024 rows — these rows as CSV