PREVIEW / stock_5min / 2005-06-21
file: by_date/stock_5min/2005/2005-06-21.parquet size: 2.7 MB rows: 196,768 symbols: 1,997
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-21 07:35:00 | AAPL | Stock | 1.3432 | 1.3432 | 1.3382 | 1.3382 | 44800.0 |
| 2005-06-21 08:00:00 | AAPL | Stock | 1.3304 | 1.3304 | 1.3304 | 1.3304 | 3752.0 |
| 2005-06-21 08:05:00 | AAPL | Stock | 1.3407 | 1.3414 | 1.3389 | 1.3414 | 70000.0 |
| 2005-06-21 08:15:00 | AAPL | Stock | 1.3411 | 1.3414 | 1.3411 | 1.3414 | 40096.0 |
| 2005-06-21 08:20:00 | AAPL | Stock | 1.3421 | 1.3421 | 1.3421 | 1.3421 | 14000.0 |
| 2005-06-21 08:25:00 | AAPL | Stock | 1.3396 | 1.3425 | 1.3396 | 1.3421 | 22400.0 |
| 2005-06-21 08:30:00 | AAPL | Stock | 1.3418 | 1.3425 | 1.3418 | 1.3425 | 42000.0 |
| 2005-06-21 08:45:00 | AAPL | Stock | 1.3425 | 1.3429 | 1.3425 | 1.3429 | 44800.0 |
| 2005-06-21 08:55:00 | AAPL | Stock | 1.3454 | 1.3454 | 1.3429 | 1.3429 | 28364.0 |
| 2005-06-21 09:00:00 | AAPL | Stock | 1.3429 | 1.3429 | 1.3414 | 1.3414 | 124096.0 |
| 2005-06-21 09:05:00 | AAPL | Stock | 1.3432 | 1.3432 | 1.3432 | 1.3432 | 5600.0 |
| 2005-06-21 09:10:00 | AAPL | Stock | 1.3429 | 1.3429 | 1.3429 | 1.3429 | 70000.0 |
| 2005-06-21 09:15:00 | AAPL | Stock | 1.3411 | 1.3411 | 1.3411 | 1.3411 | 19600.0 |
| 2005-06-21 09:20:00 | AAPL | Stock | 1.3429 | 1.3429 | 1.3429 | 1.3429 | 14000.0 |
| 2005-06-21 09:25:00 | AAPL | Stock | 1.3429 | 1.3443 | 1.3411 | 1.3443 | 98952.0 |
| 2005-06-21 09:30:00 | AAPL | Stock | 1.3471 | 1.3514 | 1.3407 | 1.3471 | 9707488.0 |
| 2005-06-21 09:35:00 | AAPL | Stock | 1.3471 | 1.3514 | 1.3471 | 1.35 | 7585648.0 |
| 2005-06-21 09:40:00 | AAPL | Stock | 1.35 | 1.3536 | 1.3407 | 1.345 | 13957328.0 |
| 2005-06-21 09:45:00 | AAPL | Stock | 1.345 | 1.3454 | 1.3368 | 1.3386 | 19871208.0 |
| 2005-06-21 09:50:00 | AAPL | Stock | 1.3386 | 1.3436 | 1.3379 | 1.3389 | 11624816.0 |
| 2005-06-21 09:55:00 | AAPL | Stock | 1.3389 | 1.3429 | 1.3361 | 1.3382 | 9200968.0 |
| 2005-06-21 10:00:00 | AAPL | Stock | 1.3379 | 1.3404 | 1.335 | 1.3382 | 8449140.0 |
| 2005-06-21 10:05:00 | AAPL | Stock | 1.3386 | 1.3386 | 1.3357 | 1.3371 | 5549852.0 |
| 2005-06-21 10:10:00 | AAPL | Stock | 1.3371 | 1.3382 | 1.3354 | 1.3371 | 4587100.0 |
| 2005-06-21 10:15:00 | AAPL | Stock | 1.3375 | 1.3421 | 1.3364 | 1.3414 | 8256500.0 |
| 2005-06-21 10:20:00 | AAPL | Stock | 1.3414 | 1.3439 | 1.3407 | 1.3411 | 5567884.0 |
| 2005-06-21 10:25:00 | AAPL | Stock | 1.3411 | 1.3518 | 1.3404 | 1.3489 | 9508352.0 |
| 2005-06-21 10:30:00 | AAPL | Stock | 1.3489 | 1.3536 | 1.3482 | 1.3489 | 10415468.0 |
| 2005-06-21 10:35:00 | AAPL | Stock | 1.3489 | 1.3489 | 1.3404 | 1.345 | 8875664.0 |
| 2005-06-21 10:40:00 | AAPL | Stock | 1.345 | 1.3511 | 1.345 | 1.3482 | 4412772.0 |
| 2005-06-21 10:45:00 | AAPL | Stock | 1.3482 | 1.3496 | 1.3471 | 1.3493 | 2212728.0 |
| 2005-06-21 10:50:00 | AAPL | Stock | 1.3493 | 1.3521 | 1.3471 | 1.3493 | 4325272.0 |
| 2005-06-21 10:55:00 | AAPL | Stock | 1.3489 | 1.3514 | 1.3486 | 1.3514 | 2514680.0 |
| 2005-06-21 11:00:00 | AAPL | Stock | 1.3514 | 1.3514 | 1.3504 | 1.3507 | 2263548.0 |
| 2005-06-21 11:05:00 | AAPL | Stock | 1.3507 | 1.3518 | 1.3504 | 1.3507 | 3195892.0 |
| 2005-06-21 11:10:00 | AAPL | Stock | 1.3507 | 1.3511 | 1.3493 | 1.3497 | 2361016.0 |
| 2005-06-21 11:15:00 | AAPL | Stock | 1.3496 | 1.3521 | 1.3496 | 1.3511 | 6120072.0 |
| 2005-06-21 11:20:00 | AAPL | Stock | 1.3507 | 1.3511 | 1.3475 | 1.3496 | 4415908.0 |
| 2005-06-21 11:25:00 | AAPL | Stock | 1.35 | 1.3514 | 1.3489 | 1.3489 | 3975020.0 |
| 2005-06-21 11:30:00 | AAPL | Stock | 1.3489 | 1.3493 | 1.3457 | 1.3486 | 3762836.0 |
| 2005-06-21 11:35:00 | AAPL | Stock | 1.3489 | 1.3504 | 1.3489 | 1.35 | 1223656.0 |
| 2005-06-21 11:40:00 | AAPL | Stock | 1.3503 | 1.3504 | 1.3486 | 1.3504 | 834764.0 |
| 2005-06-21 11:45:00 | AAPL | Stock | 1.3504 | 1.3518 | 1.3486 | 1.35 | 1749440.0 |
| 2005-06-21 11:50:00 | AAPL | Stock | 1.3504 | 1.3514 | 1.3489 | 1.3504 | 1120896.0 |
| 2005-06-21 11:55:00 | AAPL | Stock | 1.3504 | 1.3507 | 1.3496 | 1.3496 | 543536.0 |
| 2005-06-21 12:00:00 | AAPL | Stock | 1.35 | 1.3507 | 1.3493 | 1.3507 | 1062824.0 |
| 2005-06-21 12:05:00 | AAPL | Stock | 1.3507 | 1.3507 | 1.3496 | 1.35 | 776944.0 |
| 2005-06-21 12:10:00 | AAPL | Stock | 1.35 | 1.3529 | 1.3496 | 1.3525 | 2025184.0 |
| 2005-06-21 12:15:00 | AAPL | Stock | 1.3525 | 1.3532 | 1.3518 | 1.3521 | 1931916.0 |
| 2005-06-21 12:20:00 | AAPL | Stock | 1.3518 | 1.3529 | 1.3514 | 1.3514 | 1260700.0 |
> showing 50 of 196,768 rows — these rows as CSV