PREVIEW / stock_5min / 2003-08-07
file: by_date/stock_5min/2003/2003-08-07.parquet size: 2.1 MB rows: 153,012 symbols: 1,599
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-07 08:35:00 | AAPL | Stock | 0.3509 | 0.3509 | 0.3509 | 0.3509 | 5600.0 |
| 2003-08-07 09:20:00 | AAPL | Stock | 0.3518 | 0.3518 | 0.3518 | 0.3518 | 28000.0 |
| 2003-08-07 09:25:00 | AAPL | Stock | 0.3505 | 0.3521 | 0.3505 | 0.3521 | 81816.0 |
| 2003-08-07 09:30:00 | AAPL | Stock | 0.3523 | 0.3541 | 0.3509 | 0.3516 | 3348800.0 |
| 2003-08-07 09:35:00 | AAPL | Stock | 0.3516 | 0.3518 | 0.3514 | 0.3516 | 2058000.0 |
| 2003-08-07 09:40:00 | AAPL | Stock | 0.3518 | 0.352 | 0.35 | 0.35 | 3651032.0 |
| 2003-08-07 09:45:00 | AAPL | Stock | 0.3502 | 0.3507 | 0.3496 | 0.3507 | 2436000.0 |
| 2003-08-07 09:50:00 | AAPL | Stock | 0.3505 | 0.3507 | 0.3493 | 0.35 | 1226400.0 |
| 2003-08-07 09:55:00 | AAPL | Stock | 0.35 | 0.3518 | 0.3495 | 0.3514 | 1708000.0 |
| 2003-08-07 10:00:00 | AAPL | Stock | 0.3518 | 0.3521 | 0.3504 | 0.3509 | 1503376.0 |
| 2003-08-07 10:05:00 | AAPL | Stock | 0.3507 | 0.3514 | 0.3504 | 0.3513 | 1792000.0 |
| 2003-08-07 10:10:00 | AAPL | Stock | 0.3511 | 0.3513 | 0.3486 | 0.3489 | 2108120.0 |
| 2003-08-07 10:15:00 | AAPL | Stock | 0.3491 | 0.3502 | 0.3489 | 0.3493 | 1254512.0 |
| 2003-08-07 10:20:00 | AAPL | Stock | 0.3493 | 0.3493 | 0.3484 | 0.3484 | 537600.0 |
| 2003-08-07 10:25:00 | AAPL | Stock | 0.3486 | 0.3502 | 0.3479 | 0.3496 | 1846320.0 |
| 2003-08-07 10:30:00 | AAPL | Stock | 0.3498 | 0.35 | 0.3484 | 0.3498 | 2035320.0 |
| 2003-08-07 10:35:00 | AAPL | Stock | 0.3498 | 0.3502 | 0.3486 | 0.3489 | 1646400.0 |
| 2003-08-07 10:40:00 | AAPL | Stock | 0.3484 | 0.3488 | 0.3468 | 0.3471 | 5426400.0 |
| 2003-08-07 10:45:00 | AAPL | Stock | 0.347 | 0.3491 | 0.347 | 0.3491 | 1401120.0 |
| 2003-08-07 10:50:00 | AAPL | Stock | 0.3493 | 0.3518 | 0.3493 | 0.3513 | 2195200.0 |
| 2003-08-07 10:55:00 | AAPL | Stock | 0.3513 | 0.3514 | 0.3504 | 0.3504 | 700000.0 |
| 2003-08-07 11:00:00 | AAPL | Stock | 0.3504 | 0.3505 | 0.3502 | 0.3502 | 618800.0 |
| 2003-08-07 11:05:00 | AAPL | Stock | 0.3502 | 0.3504 | 0.3488 | 0.3489 | 939904.0 |
| 2003-08-07 11:10:00 | AAPL | Stock | 0.3491 | 0.3507 | 0.3491 | 0.3507 | 890400.0 |
| 2003-08-07 11:15:00 | AAPL | Stock | 0.3507 | 0.3509 | 0.3498 | 0.3498 | 856800.0 |
| 2003-08-07 11:20:00 | AAPL | Stock | 0.3498 | 0.3513 | 0.3498 | 0.3511 | 1610000.0 |
| 2003-08-07 11:25:00 | AAPL | Stock | 0.3511 | 0.3516 | 0.3511 | 0.3514 | 991200.0 |
| 2003-08-07 11:30:00 | AAPL | Stock | 0.3513 | 0.3541 | 0.3512 | 0.3541 | 3836056.0 |
| 2003-08-07 11:35:00 | AAPL | Stock | 0.3543 | 0.3564 | 0.3538 | 0.3564 | 2516304.0 |
| 2003-08-07 11:40:00 | AAPL | Stock | 0.3566 | 0.3568 | 0.3552 | 0.3563 | 1638728.0 |
| 2003-08-07 11:45:00 | AAPL | Stock | 0.3561 | 0.3571 | 0.3557 | 0.3564 | 1907864.0 |
| 2003-08-07 11:50:00 | AAPL | Stock | 0.357 | 0.357 | 0.3555 | 0.3557 | 1685600.0 |
| 2003-08-07 11:55:00 | AAPL | Stock | 0.3555 | 0.3563 | 0.3552 | 0.3559 | 1568000.0 |
| 2003-08-07 12:00:00 | AAPL | Stock | 0.3559 | 0.3577 | 0.3557 | 0.3575 | 1769600.0 |
| 2003-08-07 12:05:00 | AAPL | Stock | 0.3577 | 0.3582 | 0.3564 | 0.3564 | 2570400.0 |
| 2003-08-07 12:10:00 | AAPL | Stock | 0.3568 | 0.3577 | 0.3568 | 0.357 | 1500800.0 |
| 2003-08-07 12:15:00 | AAPL | Stock | 0.357 | 0.3573 | 0.3568 | 0.3571 | 980000.0 |
| 2003-08-07 12:20:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3559 | 0.3559 | 1002400.0 |
| 2003-08-07 12:25:00 | AAPL | Stock | 0.3559 | 0.3561 | 0.3546 | 0.355 | 3074400.0 |
| 2003-08-07 12:30:00 | AAPL | Stock | 0.3552 | 0.3554 | 0.3543 | 0.3543 | 2783200.0 |
| 2003-08-07 12:35:00 | AAPL | Stock | 0.3543 | 0.3552 | 0.3543 | 0.3548 | 1534400.0 |
| 2003-08-07 12:40:00 | AAPL | Stock | 0.3548 | 0.3554 | 0.3546 | 0.3554 | 632800.0 |
| 2003-08-07 12:45:00 | AAPL | Stock | 0.3554 | 0.3563 | 0.3552 | 0.3561 | 777168.0 |
| 2003-08-07 12:50:00 | AAPL | Stock | 0.3561 | 0.3563 | 0.3559 | 0.3559 | 526400.0 |
| 2003-08-07 12:55:00 | AAPL | Stock | 0.3561 | 0.3561 | 0.3548 | 0.355 | 1170400.0 |
| 2003-08-07 13:00:00 | AAPL | Stock | 0.355 | 0.3563 | 0.3548 | 0.3554 | 1372000.0 |
| 2003-08-07 13:05:00 | AAPL | Stock | 0.3554 | 0.3575 | 0.3553 | 0.3571 | 2352000.0 |
| 2003-08-07 13:10:00 | AAPL | Stock | 0.357 | 0.3582 | 0.3563 | 0.3575 | 1864296.0 |
| 2003-08-07 13:15:00 | AAPL | Stock | 0.3575 | 0.3584 | 0.3571 | 0.3571 | 1818936.0 |
| 2003-08-07 13:20:00 | AAPL | Stock | 0.3571 | 0.3577 | 0.357 | 0.3573 | 840000.0 |
> showing 50 of 153,012 rows — these rows as CSV