PREVIEW / stock_5min / 2003-08-11
file: by_date/stock_5min/2003/2003-08-11.parquet size: 2.0 MB rows: 144,425 symbols: 1,600
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-08-11 09:15:00 | AAPL | Stock | 0.3511 | 0.3511 | 0.3511 | 0.3511 | 11200.0 |
| 2003-08-11 09:20:00 | AAPL | Stock | 0.3511 | 0.3511 | 0.3511 | 0.3511 | 16800.0 |
| 2003-08-11 09:25:00 | AAPL | Stock | 0.3511 | 0.3527 | 0.3511 | 0.3527 | 95200.0 |
| 2003-08-11 09:30:00 | AAPL | Stock | 0.3539 | 0.3557 | 0.3525 | 0.3541 | 3561600.0 |
| 2003-08-11 09:35:00 | AAPL | Stock | 0.3541 | 0.3541 | 0.3509 | 0.3511 | 2752288.0 |
| 2003-08-11 09:40:00 | AAPL | Stock | 0.3511 | 0.3516 | 0.3504 | 0.3516 | 2350824.0 |
| 2003-08-11 09:45:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.3516 | 0.3521 | 3977680.0 |
| 2003-08-11 09:50:00 | AAPL | Stock | 0.3521 | 0.3536 | 0.3521 | 0.3534 | 1640800.0 |
| 2003-08-11 09:55:00 | AAPL | Stock | 0.3534 | 0.3534 | 0.3519 | 0.3529 | 1154944.0 |
| 2003-08-11 10:00:00 | AAPL | Stock | 0.3529 | 0.3532 | 0.3529 | 0.353 | 873600.0 |
| 2003-08-11 10:05:00 | AAPL | Stock | 0.3532 | 0.3532 | 0.352 | 0.3523 | 1666728.0 |
| 2003-08-11 10:10:00 | AAPL | Stock | 0.3523 | 0.3529 | 0.3523 | 0.3525 | 991200.0 |
| 2003-08-11 10:15:00 | AAPL | Stock | 0.3529 | 0.3554 | 0.3527 | 0.3548 | 2718240.0 |
| 2003-08-11 10:20:00 | AAPL | Stock | 0.3548 | 0.3554 | 0.3532 | 0.3538 | 4160688.0 |
| 2003-08-11 10:25:00 | AAPL | Stock | 0.3536 | 0.355 | 0.3536 | 0.3541 | 2248680.0 |
| 2003-08-11 10:30:00 | AAPL | Stock | 0.3543 | 0.3559 | 0.3541 | 0.3552 | 2418416.0 |
| 2003-08-11 10:35:00 | AAPL | Stock | 0.3552 | 0.3552 | 0.3521 | 0.353 | 2891056.0 |
| 2003-08-11 10:40:00 | AAPL | Stock | 0.3532 | 0.3536 | 0.3532 | 0.3536 | 1786400.0 |
| 2003-08-11 10:45:00 | AAPL | Stock | 0.3538 | 0.355 | 0.3538 | 0.3543 | 1038688.0 |
| 2003-08-11 10:50:00 | AAPL | Stock | 0.3545 | 0.3546 | 0.3541 | 0.3541 | 453432.0 |
| 2003-08-11 10:55:00 | AAPL | Stock | 0.3541 | 0.3543 | 0.3536 | 0.3539 | 789600.0 |
| 2003-08-11 11:00:00 | AAPL | Stock | 0.3543 | 0.3546 | 0.3541 | 0.3545 | 610400.0 |
| 2003-08-11 11:05:00 | AAPL | Stock | 0.3543 | 0.3545 | 0.3529 | 0.3529 | 823144.0 |
| 2003-08-11 11:10:00 | AAPL | Stock | 0.3529 | 0.3529 | 0.3514 | 0.3521 | 1036168.0 |
| 2003-08-11 11:15:00 | AAPL | Stock | 0.3521 | 0.3527 | 0.3514 | 0.3525 | 946400.0 |
| 2003-08-11 11:20:00 | AAPL | Stock | 0.3525 | 0.3527 | 0.3523 | 0.3527 | 728000.0 |
| 2003-08-11 11:25:00 | AAPL | Stock | 0.3527 | 0.3535 | 0.3527 | 0.3532 | 817656.0 |
| 2003-08-11 11:30:00 | AAPL | Stock | 0.3532 | 0.3538 | 0.353 | 0.353 | 1019200.0 |
| 2003-08-11 11:35:00 | AAPL | Stock | 0.353 | 0.3534 | 0.3518 | 0.352 | 964264.0 |
| 2003-08-11 11:40:00 | AAPL | Stock | 0.352 | 0.352 | 0.3508 | 0.3509 | 1109696.0 |
| 2003-08-11 11:45:00 | AAPL | Stock | 0.3509 | 0.3511 | 0.3486 | 0.3493 | 3788904.0 |
| 2003-08-11 11:50:00 | AAPL | Stock | 0.3493 | 0.3504 | 0.3491 | 0.35 | 1277472.0 |
| 2003-08-11 11:55:00 | AAPL | Stock | 0.3502 | 0.3521 | 0.35 | 0.3521 | 2995552.0 |
| 2003-08-11 12:00:00 | AAPL | Stock | 0.3521 | 0.3527 | 0.352 | 0.3525 | 4303600.0 |
| 2003-08-11 12:05:00 | AAPL | Stock | 0.3525 | 0.3525 | 0.3518 | 0.3518 | 877408.0 |
| 2003-08-11 12:10:00 | AAPL | Stock | 0.3518 | 0.3518 | 0.3509 | 0.3513 | 610400.0 |
| 2003-08-11 12:15:00 | AAPL | Stock | 0.3514 | 0.3514 | 0.3511 | 0.3511 | 616000.0 |
| 2003-08-11 12:20:00 | AAPL | Stock | 0.3513 | 0.3513 | 0.3511 | 0.3513 | 235200.0 |
| 2003-08-11 12:25:00 | AAPL | Stock | 0.3513 | 0.3514 | 0.3513 | 0.3514 | 448000.0 |
| 2003-08-11 12:30:00 | AAPL | Stock | 0.3514 | 0.3514 | 0.3511 | 0.3513 | 375200.0 |
| 2003-08-11 12:35:00 | AAPL | Stock | 0.3513 | 0.3518 | 0.3513 | 0.3516 | 660800.0 |
| 2003-08-11 12:40:00 | AAPL | Stock | 0.3516 | 0.352 | 0.3511 | 0.3511 | 811720.0 |
| 2003-08-11 12:45:00 | AAPL | Stock | 0.3509 | 0.3511 | 0.3502 | 0.3507 | 834400.0 |
| 2003-08-11 12:50:00 | AAPL | Stock | 0.3507 | 0.3511 | 0.3507 | 0.3509 | 285600.0 |
| 2003-08-11 12:55:00 | AAPL | Stock | 0.3509 | 0.3509 | 0.35 | 0.35 | 571200.0 |
| 2003-08-11 13:00:00 | AAPL | Stock | 0.35 | 0.3505 | 0.35 | 0.3505 | 375200.0 |
| 2003-08-11 13:05:00 | AAPL | Stock | 0.3505 | 0.3505 | 0.3502 | 0.3504 | 487200.0 |
| 2003-08-11 13:10:00 | AAPL | Stock | 0.3505 | 0.3507 | 0.3505 | 0.3505 | 302400.0 |
| 2003-08-11 13:15:00 | AAPL | Stock | 0.3505 | 0.3511 | 0.3505 | 0.3511 | 873600.0 |
| 2003-08-11 13:20:00 | AAPL | Stock | 0.3511 | 0.3514 | 0.3511 | 0.3514 | 548800.0 |
> showing 50 of 144,425 rows — these rows as CSV