PREVIEW / stock_5min / 2002-09-19
file: by_date/stock_5min/2002/2002-09-19.parquet size: 1.8 MB rows: 127,082 symbols: 1,498
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 |
|---|---|---|---|---|---|---|---|
| 2002-09-19 08:15:00 | AAPL | Stock | 0.2675 | 0.2675 | 0.2675 | 0.2675 | 11200.0 |
| 2002-09-19 09:15:00 | AAPL | Stock | 0.2673 | 0.2673 | 0.2673 | 0.2673 | 56000.0 |
| 2002-09-19 09:25:00 | AAPL | Stock | 0.2634 | 0.2636 | 0.2634 | 0.2636 | 268800.0 |
| 2002-09-19 09:30:00 | AAPL | Stock | 0.2634 | 0.2643 | 0.2618 | 0.2627 | 5936000.0 |
| 2002-09-19 09:35:00 | AAPL | Stock | 0.2627 | 0.2629 | 0.2618 | 0.2623 | 5555984.0 |
| 2002-09-19 09:40:00 | AAPL | Stock | 0.2623 | 0.2625 | 0.2607 | 0.2611 | 6151712.0 |
| 2002-09-19 09:45:00 | AAPL | Stock | 0.2614 | 0.2618 | 0.2605 | 0.2611 | 4349632.0 |
| 2002-09-19 09:50:00 | AAPL | Stock | 0.2609 | 0.262 | 0.2602 | 0.2614 | 6174560.0 |
| 2002-09-19 09:55:00 | AAPL | Stock | 0.2614 | 0.262 | 0.2614 | 0.2616 | 6011376.0 |
| 2002-09-19 10:00:00 | AAPL | Stock | 0.2618 | 0.2621 | 0.2611 | 0.2618 | 2441600.0 |
| 2002-09-19 10:05:00 | AAPL | Stock | 0.2621 | 0.2624 | 0.2616 | 0.2621 | 4595976.0 |
| 2002-09-19 10:10:00 | AAPL | Stock | 0.2621 | 0.2627 | 0.2616 | 0.2621 | 1926400.0 |
| 2002-09-19 10:15:00 | AAPL | Stock | 0.2621 | 0.2629 | 0.2618 | 0.2627 | 2036832.0 |
| 2002-09-19 10:20:00 | AAPL | Stock | 0.263 | 0.2636 | 0.2625 | 0.2636 | 3225600.0 |
| 2002-09-19 10:25:00 | AAPL | Stock | 0.2636 | 0.2636 | 0.2625 | 0.2629 | 4018000.0 |
| 2002-09-19 10:30:00 | AAPL | Stock | 0.263 | 0.263 | 0.2621 | 0.2621 | 1590400.0 |
| 2002-09-19 10:35:00 | AAPL | Stock | 0.2623 | 0.2625 | 0.2618 | 0.262 | 781424.0 |
| 2002-09-19 10:40:00 | AAPL | Stock | 0.2623 | 0.2623 | 0.2614 | 0.2614 | 2059288.0 |
| 2002-09-19 10:45:00 | AAPL | Stock | 0.2614 | 0.2629 | 0.2613 | 0.2625 | 1646400.0 |
| 2002-09-19 10:50:00 | AAPL | Stock | 0.262 | 0.2623 | 0.2613 | 0.2618 | 1048096.0 |
| 2002-09-19 10:55:00 | AAPL | Stock | 0.2618 | 0.2621 | 0.2609 | 0.2621 | 1612800.0 |
| 2002-09-19 11:00:00 | AAPL | Stock | 0.262 | 0.2634 | 0.2614 | 0.2634 | 2914576.0 |
| 2002-09-19 11:05:00 | AAPL | Stock | 0.2634 | 0.2636 | 0.262 | 0.2625 | 2088016.0 |
| 2002-09-19 11:10:00 | AAPL | Stock | 0.2625 | 0.2627 | 0.2625 | 0.2625 | 2526496.0 |
| 2002-09-19 11:15:00 | AAPL | Stock | 0.2625 | 0.2627 | 0.2623 | 0.2623 | 1111600.0 |
| 2002-09-19 11:20:00 | AAPL | Stock | 0.2623 | 0.2623 | 0.2615 | 0.2616 | 1859200.0 |
| 2002-09-19 11:25:00 | AAPL | Stock | 0.2616 | 0.262 | 0.2614 | 0.2614 | 1943200.0 |
| 2002-09-19 11:30:00 | AAPL | Stock | 0.2614 | 0.2625 | 0.2614 | 0.2621 | 1972600.0 |
| 2002-09-19 11:35:00 | AAPL | Stock | 0.262 | 0.2623 | 0.262 | 0.2623 | 1130304.0 |
| 2002-09-19 11:40:00 | AAPL | Stock | 0.2623 | 0.2625 | 0.262 | 0.2621 | 985600.0 |
| 2002-09-19 11:45:00 | AAPL | Stock | 0.2621 | 0.2621 | 0.262 | 0.262 | 196000.0 |
| 2002-09-19 11:50:00 | AAPL | Stock | 0.262 | 0.2621 | 0.2613 | 0.2613 | 448000.0 |
| 2002-09-19 11:55:00 | AAPL | Stock | 0.2611 | 0.2611 | 0.2604 | 0.2609 | 1061256.0 |
| 2002-09-19 12:00:00 | AAPL | Stock | 0.2609 | 0.2625 | 0.2609 | 0.262 | 2341864.0 |
| 2002-09-19 12:05:00 | AAPL | Stock | 0.262 | 0.2625 | 0.2613 | 0.2621 | 2447200.0 |
| 2002-09-19 12:10:00 | AAPL | Stock | 0.2621 | 0.2623 | 0.2611 | 0.2618 | 683200.0 |
| 2002-09-19 12:15:00 | AAPL | Stock | 0.2618 | 0.2621 | 0.2614 | 0.2616 | 784000.0 |
| 2002-09-19 12:20:00 | AAPL | Stock | 0.2616 | 0.2618 | 0.2607 | 0.2609 | 1121568.0 |
| 2002-09-19 12:25:00 | AAPL | Stock | 0.2609 | 0.2618 | 0.2607 | 0.2618 | 548800.0 |
| 2002-09-19 12:30:00 | AAPL | Stock | 0.2618 | 0.2625 | 0.2616 | 0.2616 | 2379664.0 |
| 2002-09-19 12:35:00 | AAPL | Stock | 0.2616 | 0.2625 | 0.2614 | 0.2614 | 1400000.0 |
| 2002-09-19 12:40:00 | AAPL | Stock | 0.262 | 0.2623 | 0.2613 | 0.2623 | 537600.0 |
| 2002-09-19 12:45:00 | AAPL | Stock | 0.2623 | 0.2625 | 0.2614 | 0.2616 | 1528800.0 |
| 2002-09-19 12:50:00 | AAPL | Stock | 0.2616 | 0.2621 | 0.2614 | 0.2618 | 1215592.0 |
| 2002-09-19 12:55:00 | AAPL | Stock | 0.2621 | 0.2621 | 0.2614 | 0.2614 | 666400.0 |
| 2002-09-19 13:00:00 | AAPL | Stock | 0.2614 | 0.2616 | 0.2614 | 0.2614 | 666400.0 |
| 2002-09-19 13:05:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2613 | 0.2614 | 828800.0 |
| 2002-09-19 13:10:00 | AAPL | Stock | 0.2613 | 0.2613 | 0.2607 | 0.2609 | 929600.0 |
| 2002-09-19 13:15:00 | AAPL | Stock | 0.2609 | 0.2611 | 0.2607 | 0.2607 | 1109192.0 |
| 2002-09-19 13:20:00 | AAPL | Stock | 0.2609 | 0.2611 | 0.2602 | 0.2602 | 868000.0 |
> showing 50 of 127,082 rows — these rows as CSV