PREVIEW / stock_5min / 2003-08-18
file: by_date/stock_5min/2003/2003-08-18.parquet size: 2.1 MB rows: 154,834 symbols: 1,610
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-18 08:20:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3527 | 0.3527 | 5600.0 |
| 2003-08-18 08:35:00 | AAPL | Stock | 0.3527 | 0.3536 | 0.3527 | 0.3536 | 44800.0 |
| 2003-08-18 08:40:00 | AAPL | Stock | 0.3553 | 0.3554 | 0.3553 | 0.3554 | 33600.0 |
| 2003-08-18 08:55:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3554 | 0.3554 | 22400.0 |
| 2003-08-18 09:00:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3554 | 0.3554 | 5600.0 |
| 2003-08-18 09:05:00 | AAPL | Stock | 0.3521 | 0.3521 | 0.3521 | 0.3521 | 929600.0 |
| 2003-08-18 09:20:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3536 | 0.3536 | 324800.0 |
| 2003-08-18 09:25:00 | AAPL | Stock | 0.3536 | 0.3538 | 0.3536 | 0.3536 | 201600.0 |
| 2003-08-18 09:30:00 | AAPL | Stock | 0.3546 | 0.3554 | 0.3538 | 0.3548 | 4452000.0 |
| 2003-08-18 09:35:00 | AAPL | Stock | 0.355 | 0.355 | 0.3521 | 0.3536 | 2083200.0 |
| 2003-08-18 09:40:00 | AAPL | Stock | 0.3536 | 0.3546 | 0.3534 | 0.3545 | 1680056.0 |
| 2003-08-18 09:45:00 | AAPL | Stock | 0.3548 | 0.3563 | 0.3545 | 0.3554 | 2979200.0 |
| 2003-08-18 09:50:00 | AAPL | Stock | 0.3552 | 0.3561 | 0.353 | 0.3532 | 5372528.0 |
| 2003-08-18 09:55:00 | AAPL | Stock | 0.3532 | 0.3543 | 0.3529 | 0.3541 | 4717888.0 |
| 2003-08-18 10:00:00 | AAPL | Stock | 0.3543 | 0.3543 | 0.3523 | 0.3527 | 1349600.0 |
| 2003-08-18 10:05:00 | AAPL | Stock | 0.3525 | 0.3539 | 0.3523 | 0.3538 | 3546648.0 |
| 2003-08-18 10:10:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3534 | 0.3536 | 1975176.0 |
| 2003-08-18 10:15:00 | AAPL | Stock | 0.3536 | 0.3548 | 0.353 | 0.3532 | 3236800.0 |
| 2003-08-18 10:20:00 | AAPL | Stock | 0.3534 | 0.3545 | 0.3534 | 0.3543 | 912800.0 |
| 2003-08-18 10:25:00 | AAPL | Stock | 0.3545 | 0.3552 | 0.3545 | 0.3552 | 828856.0 |
| 2003-08-18 10:30:00 | AAPL | Stock | 0.355 | 0.3556 | 0.3539 | 0.3539 | 4577832.0 |
| 2003-08-18 10:35:00 | AAPL | Stock | 0.3539 | 0.3541 | 0.3538 | 0.3538 | 871528.0 |
| 2003-08-18 10:40:00 | AAPL | Stock | 0.3538 | 0.3545 | 0.3536 | 0.3545 | 1836800.0 |
| 2003-08-18 10:45:00 | AAPL | Stock | 0.3545 | 0.3564 | 0.3539 | 0.3552 | 6445096.0 |
| 2003-08-18 10:50:00 | AAPL | Stock | 0.3552 | 0.3554 | 0.3545 | 0.3545 | 1547560.0 |
| 2003-08-18 10:55:00 | AAPL | Stock | 0.3546 | 0.3546 | 0.3534 | 0.3545 | 2195200.0 |
| 2003-08-18 11:00:00 | AAPL | Stock | 0.3545 | 0.3563 | 0.3545 | 0.3563 | 2021600.0 |
| 2003-08-18 11:05:00 | AAPL | Stock | 0.3563 | 0.3564 | 0.3561 | 0.3564 | 1800176.0 |
| 2003-08-18 11:10:00 | AAPL | Stock | 0.3564 | 0.357 | 0.3563 | 0.3568 | 1713600.0 |
| 2003-08-18 11:15:00 | AAPL | Stock | 0.3568 | 0.3582 | 0.3566 | 0.358 | 3135272.0 |
| 2003-08-18 11:20:00 | AAPL | Stock | 0.3577 | 0.3582 | 0.3561 | 0.3571 | 3701936.0 |
| 2003-08-18 11:25:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3563 | 0.3564 | 1030400.0 |
| 2003-08-18 11:30:00 | AAPL | Stock | 0.3566 | 0.3566 | 0.3559 | 0.3561 | 845600.0 |
| 2003-08-18 11:35:00 | AAPL | Stock | 0.3561 | 0.3579 | 0.3561 | 0.3568 | 4216072.0 |
| 2003-08-18 11:40:00 | AAPL | Stock | 0.3568 | 0.3582 | 0.3564 | 0.358 | 705600.0 |
| 2003-08-18 11:45:00 | AAPL | Stock | 0.3584 | 0.3604 | 0.358 | 0.3604 | 3802848.0 |
| 2003-08-18 11:50:00 | AAPL | Stock | 0.3604 | 0.3607 | 0.3598 | 0.3604 | 2220400.0 |
| 2003-08-18 11:55:00 | AAPL | Stock | 0.3604 | 0.3613 | 0.3596 | 0.3596 | 4894400.0 |
| 2003-08-18 12:00:00 | AAPL | Stock | 0.3596 | 0.3607 | 0.3596 | 0.3604 | 4552968.0 |
| 2003-08-18 12:05:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3586 | 0.3589 | 5421864.0 |
| 2003-08-18 12:10:00 | AAPL | Stock | 0.3588 | 0.3598 | 0.3588 | 0.3595 | 2475200.0 |
| 2003-08-18 12:15:00 | AAPL | Stock | 0.3595 | 0.3595 | 0.3582 | 0.3584 | 1098720.0 |
| 2003-08-18 12:20:00 | AAPL | Stock | 0.3584 | 0.3598 | 0.3584 | 0.3598 | 1148728.0 |
| 2003-08-18 12:25:00 | AAPL | Stock | 0.36 | 0.3609 | 0.3598 | 0.3604 | 5305440.0 |
| 2003-08-18 12:30:00 | AAPL | Stock | 0.3605 | 0.3609 | 0.3596 | 0.3602 | 2326800.0 |
| 2003-08-18 12:35:00 | AAPL | Stock | 0.3604 | 0.3607 | 0.3588 | 0.3589 | 1981056.0 |
| 2003-08-18 12:40:00 | AAPL | Stock | 0.3589 | 0.3602 | 0.3589 | 0.3602 | 257600.0 |
| 2003-08-18 12:45:00 | AAPL | Stock | 0.3602 | 0.3602 | 0.36 | 0.3602 | 408800.0 |
| 2003-08-18 12:50:00 | AAPL | Stock | 0.3602 | 0.3602 | 0.36 | 0.3602 | 151200.0 |
| 2003-08-18 12:55:00 | AAPL | Stock | 0.36 | 0.3602 | 0.3584 | 0.3588 | 2626400.0 |
> showing 50 of 154,834 rows — these rows as CSV