PREVIEW / stock_5min / 2003-12-17
file: by_date/stock_5min/2003/2003-12-17.parquet size: 2.3 MB rows: 165,559 symbols: 1,701
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-12-17 08:00:00 | AAPL | Stock | 0.3588 | 0.3588 | 0.3588 | 0.3588 | 3052000.0 |
| 2003-12-17 08:30:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3589 | 0.3589 | 56000.0 |
| 2003-12-17 09:20:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3589 | 0.3589 | 22400.0 |
| 2003-12-17 09:25:00 | AAPL | Stock | 0.3589 | 0.3591 | 0.3575 | 0.3575 | 246400.0 |
| 2003-12-17 09:30:00 | AAPL | Stock | 0.3575 | 0.3588 | 0.3564 | 0.3571 | 6563312.0 |
| 2003-12-17 09:35:00 | AAPL | Stock | 0.3573 | 0.3573 | 0.3536 | 0.3543 | 11000360.0 |
| 2003-12-17 09:40:00 | AAPL | Stock | 0.3543 | 0.355 | 0.3538 | 0.355 | 8610672.0 |
| 2003-12-17 09:45:00 | AAPL | Stock | 0.355 | 0.3563 | 0.3545 | 0.3554 | 2553712.0 |
| 2003-12-17 09:50:00 | AAPL | Stock | 0.3554 | 0.3555 | 0.3545 | 0.3548 | 1940064.0 |
| 2003-12-17 09:55:00 | AAPL | Stock | 0.3548 | 0.3552 | 0.3548 | 0.3551 | 2003400.0 |
| 2003-12-17 10:00:00 | AAPL | Stock | 0.3552 | 0.3555 | 0.3548 | 0.355 | 2834048.0 |
| 2003-12-17 10:05:00 | AAPL | Stock | 0.355 | 0.3566 | 0.3541 | 0.3557 | 4062408.0 |
| 2003-12-17 10:10:00 | AAPL | Stock | 0.3557 | 0.3557 | 0.3543 | 0.3545 | 1657656.0 |
| 2003-12-17 10:15:00 | AAPL | Stock | 0.3545 | 0.3548 | 0.3534 | 0.3538 | 7551208.0 |
| 2003-12-17 10:20:00 | AAPL | Stock | 0.3538 | 0.3541 | 0.3534 | 0.354 | 2088520.0 |
| 2003-12-17 10:25:00 | AAPL | Stock | 0.3541 | 0.3546 | 0.3534 | 0.3538 | 2185848.0 |
| 2003-12-17 10:30:00 | AAPL | Stock | 0.3539 | 0.3566 | 0.3538 | 0.3563 | 4082792.0 |
| 2003-12-17 10:35:00 | AAPL | Stock | 0.3563 | 0.3568 | 0.3557 | 0.3568 | 1614144.0 |
| 2003-12-17 10:40:00 | AAPL | Stock | 0.3568 | 0.3571 | 0.3557 | 0.3557 | 4237408.0 |
| 2003-12-17 10:45:00 | AAPL | Stock | 0.3559 | 0.357 | 0.3559 | 0.3564 | 2556232.0 |
| 2003-12-17 10:50:00 | AAPL | Stock | 0.3566 | 0.3566 | 0.3554 | 0.3554 | 1695624.0 |
| 2003-12-17 10:55:00 | AAPL | Stock | 0.3554 | 0.3564 | 0.3553 | 0.3559 | 1186584.0 |
| 2003-12-17 11:00:00 | AAPL | Stock | 0.3559 | 0.3595 | 0.3559 | 0.3586 | 7640304.0 |
| 2003-12-17 11:05:00 | AAPL | Stock | 0.3589 | 0.3595 | 0.3582 | 0.3582 | 9791712.0 |
| 2003-12-17 11:10:00 | AAPL | Stock | 0.3582 | 0.3586 | 0.3564 | 0.3564 | 3850952.0 |
| 2003-12-17 11:15:00 | AAPL | Stock | 0.3564 | 0.3571 | 0.355 | 0.3557 | 6456240.0 |
| 2003-12-17 11:20:00 | AAPL | Stock | 0.3557 | 0.3559 | 0.3555 | 0.3559 | 679560.0 |
| 2003-12-17 11:25:00 | AAPL | Stock | 0.3559 | 0.3573 | 0.3557 | 0.3563 | 2327136.0 |
| 2003-12-17 11:30:00 | AAPL | Stock | 0.3563 | 0.3564 | 0.3552 | 0.3561 | 2895256.0 |
| 2003-12-17 11:35:00 | AAPL | Stock | 0.3561 | 0.3563 | 0.3552 | 0.3555 | 2931208.0 |
| 2003-12-17 11:40:00 | AAPL | Stock | 0.3557 | 0.3563 | 0.3554 | 0.3559 | 830592.0 |
| 2003-12-17 11:45:00 | AAPL | Stock | 0.3555 | 0.3563 | 0.3552 | 0.3559 | 1215928.0 |
| 2003-12-17 11:50:00 | AAPL | Stock | 0.3563 | 0.3568 | 0.3559 | 0.3566 | 1368248.0 |
| 2003-12-17 11:55:00 | AAPL | Stock | 0.3567 | 0.3568 | 0.3563 | 0.3566 | 796600.0 |
| 2003-12-17 12:00:00 | AAPL | Stock | 0.3564 | 0.3568 | 0.3552 | 0.3554 | 1694448.0 |
| 2003-12-17 12:05:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3546 | 0.3546 | 1953224.0 |
| 2003-12-17 12:10:00 | AAPL | Stock | 0.3546 | 0.3548 | 0.3545 | 0.3548 | 1213072.0 |
| 2003-12-17 12:15:00 | AAPL | Stock | 0.3546 | 0.355 | 0.3546 | 0.355 | 1015000.0 |
| 2003-12-17 12:20:00 | AAPL | Stock | 0.355 | 0.355 | 0.3548 | 0.355 | 711200.0 |
| 2003-12-17 12:25:00 | AAPL | Stock | 0.355 | 0.3554 | 0.3546 | 0.3554 | 1207864.0 |
| 2003-12-17 12:30:00 | AAPL | Stock | 0.3552 | 0.3561 | 0.3552 | 0.3557 | 1625512.0 |
| 2003-12-17 12:35:00 | AAPL | Stock | 0.3557 | 0.3559 | 0.3555 | 0.3557 | 672952.0 |
| 2003-12-17 12:40:00 | AAPL | Stock | 0.3557 | 0.3557 | 0.3552 | 0.3552 | 881944.0 |
| 2003-12-17 12:45:00 | AAPL | Stock | 0.3552 | 0.3554 | 0.3548 | 0.355 | 1324400.0 |
| 2003-12-17 12:50:00 | AAPL | Stock | 0.355 | 0.355 | 0.3545 | 0.3548 | 2820440.0 |
| 2003-12-17 12:55:00 | AAPL | Stock | 0.3548 | 0.355 | 0.3545 | 0.3546 | 1834616.0 |
| 2003-12-17 13:00:00 | AAPL | Stock | 0.3546 | 0.355 | 0.3545 | 0.355 | 1200584.0 |
| 2003-12-17 13:05:00 | AAPL | Stock | 0.3552 | 0.3557 | 0.3548 | 0.3555 | 4477760.0 |
| 2003-12-17 13:10:00 | AAPL | Stock | 0.3555 | 0.3555 | 0.3548 | 0.3555 | 1695568.0 |
| 2003-12-17 13:15:00 | AAPL | Stock | 0.3555 | 0.3555 | 0.3552 | 0.3555 | 2396800.0 |
> showing 50 of 165,559 rows — these rows as CSV