PREVIEW / stock_5min / 2003-12-18
file: by_date/stock_5min/2003/2003-12-18.parquet size: 2.3 MB rows: 169,754 symbols: 1,693
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-18 08:50:00 | AAPL | Stock | 0.3552 | 0.3554 | 0.3552 | 0.3554 | 61600.0 |
| 2003-12-18 09:05:00 | AAPL | Stock | 0.3555 | 0.3555 | 0.3555 | 0.3555 | 56000.0 |
| 2003-12-18 09:10:00 | AAPL | Stock | 0.3555 | 0.3555 | 0.3555 | 0.3555 | 5600.0 |
| 2003-12-18 09:15:00 | AAPL | Stock | 0.3555 | 0.3555 | 0.3555 | 0.3555 | 28000.0 |
| 2003-12-18 09:25:00 | AAPL | Stock | 0.3555 | 0.3573 | 0.3555 | 0.3571 | 571200.0 |
| 2003-12-18 09:30:00 | AAPL | Stock | 0.3554 | 0.3589 | 0.3554 | 0.358 | 8327088.0 |
| 2003-12-18 09:35:00 | AAPL | Stock | 0.358 | 0.358 | 0.3573 | 0.3573 | 4019120.0 |
| 2003-12-18 09:40:00 | AAPL | Stock | 0.3575 | 0.358 | 0.3573 | 0.3579 | 8517544.0 |
| 2003-12-18 09:45:00 | AAPL | Stock | 0.3577 | 0.358 | 0.3575 | 0.3579 | 3293528.0 |
| 2003-12-18 09:50:00 | AAPL | Stock | 0.3579 | 0.3584 | 0.3577 | 0.3582 | 12214944.0 |
| 2003-12-18 09:55:00 | AAPL | Stock | 0.3582 | 0.3586 | 0.3579 | 0.3584 | 12499256.0 |
| 2003-12-18 10:00:00 | AAPL | Stock | 0.3582 | 0.3584 | 0.358 | 0.3582 | 5677840.0 |
| 2003-12-18 10:05:00 | AAPL | Stock | 0.3582 | 0.3582 | 0.357 | 0.3579 | 5156984.0 |
| 2003-12-18 10:10:00 | AAPL | Stock | 0.3571 | 0.3579 | 0.3568 | 0.3575 | 19202792.0 |
| 2003-12-18 10:15:00 | AAPL | Stock | 0.3577 | 0.3579 | 0.3577 | 0.3578 | 6330520.0 |
| 2003-12-18 10:20:00 | AAPL | Stock | 0.3577 | 0.3579 | 0.3575 | 0.3579 | 1877064.0 |
| 2003-12-18 10:25:00 | AAPL | Stock | 0.3577 | 0.3579 | 0.3575 | 0.3577 | 1935024.0 |
| 2003-12-18 10:30:00 | AAPL | Stock | 0.3577 | 0.358 | 0.3577 | 0.3577 | 5279120.0 |
| 2003-12-18 10:35:00 | AAPL | Stock | 0.3577 | 0.3579 | 0.3575 | 0.3577 | 1543920.0 |
| 2003-12-18 10:40:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3571 | 0.3573 | 1693944.0 |
| 2003-12-18 10:45:00 | AAPL | Stock | 0.3573 | 0.3573 | 0.3571 | 0.3571 | 3041808.0 |
| 2003-12-18 10:50:00 | AAPL | Stock | 0.3571 | 0.3573 | 0.3568 | 0.3568 | 1935976.0 |
| 2003-12-18 10:55:00 | AAPL | Stock | 0.3568 | 0.3571 | 0.3564 | 0.3571 | 4587128.0 |
| 2003-12-18 11:00:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.357 | 0.3571 | 697200.0 |
| 2003-12-18 11:05:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3568 | 0.357 | 2195424.0 |
| 2003-12-18 11:10:00 | AAPL | Stock | 0.357 | 0.3571 | 0.357 | 0.3571 | 1219344.0 |
| 2003-12-18 11:15:00 | AAPL | Stock | 0.357 | 0.3571 | 0.3566 | 0.3566 | 1438920.0 |
| 2003-12-18 11:20:00 | AAPL | Stock | 0.3568 | 0.3568 | 0.3564 | 0.3566 | 1294944.0 |
| 2003-12-18 11:25:00 | AAPL | Stock | 0.3564 | 0.3568 | 0.3564 | 0.3566 | 1584072.0 |
| 2003-12-18 11:30:00 | AAPL | Stock | 0.3568 | 0.3568 | 0.3564 | 0.3564 | 1991192.0 |
| 2003-12-18 11:35:00 | AAPL | Stock | 0.3564 | 0.357 | 0.3564 | 0.357 | 1222816.0 |
| 2003-12-18 11:40:00 | AAPL | Stock | 0.357 | 0.3571 | 0.3566 | 0.3571 | 2034480.0 |
| 2003-12-18 11:45:00 | AAPL | Stock | 0.3571 | 0.3573 | 0.357 | 0.3573 | 18384408.0 |
| 2003-12-18 11:50:00 | AAPL | Stock | 0.3573 | 0.3573 | 0.3571 | 0.3571 | 5504520.0 |
| 2003-12-18 11:55:00 | AAPL | Stock | 0.3568 | 0.3575 | 0.3568 | 0.3575 | 2646000.0 |
| 2003-12-18 12:00:00 | AAPL | Stock | 0.3575 | 0.3579 | 0.3573 | 0.3577 | 2448936.0 |
| 2003-12-18 12:05:00 | AAPL | Stock | 0.3579 | 0.3582 | 0.3577 | 0.358 | 11904088.0 |
| 2003-12-18 12:10:00 | AAPL | Stock | 0.358 | 0.358 | 0.3577 | 0.3577 | 5308072.0 |
| 2003-12-18 12:15:00 | AAPL | Stock | 0.3577 | 0.358 | 0.3577 | 0.3579 | 2234064.0 |
| 2003-12-18 12:20:00 | AAPL | Stock | 0.3577 | 0.3582 | 0.3577 | 0.358 | 1695008.0 |
| 2003-12-18 12:25:00 | AAPL | Stock | 0.358 | 0.358 | 0.3579 | 0.3579 | 2847936.0 |
| 2003-12-18 12:30:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3577 | 0.3579 | 680904.0 |
| 2003-12-18 12:35:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3577 | 0.3579 | 1217888.0 |
| 2003-12-18 12:40:00 | AAPL | Stock | 0.3579 | 0.3582 | 0.3577 | 0.358 | 2727872.0 |
| 2003-12-18 12:45:00 | AAPL | Stock | 0.3579 | 0.358 | 0.3577 | 0.3579 | 1068872.0 |
| 2003-12-18 12:50:00 | AAPL | Stock | 0.3577 | 0.358 | 0.3577 | 0.3579 | 1103200.0 |
| 2003-12-18 12:55:00 | AAPL | Stock | 0.3579 | 0.358 | 0.3577 | 0.3579 | 629272.0 |
| 2003-12-18 13:00:00 | AAPL | Stock | 0.3579 | 0.3589 | 0.3575 | 0.3582 | 5275648.0 |
| 2003-12-18 13:05:00 | AAPL | Stock | 0.3582 | 0.3586 | 0.358 | 0.3586 | 2458960.0 |
| 2003-12-18 13:10:00 | AAPL | Stock | 0.3586 | 0.3589 | 0.3584 | 0.3588 | 2752512.0 |
> showing 50 of 169,754 rows — these rows as CSV