PREVIEW / stock_5min / 2003-01-02
file: by_date/stock_5min/2003/2003-01-02.parquet size: 1.9 MB rows: 135,069 symbols: 1,522
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-01-02 09:15:00 | AAPL | Stock | 0.2564 | 0.2566 | 0.2564 | 0.2564 | 114800.0 |
| 2003-01-02 09:25:00 | AAPL | Stock | 0.2564 | 0.257 | 0.2564 | 0.257 | 95200.0 |
| 2003-01-02 09:30:00 | AAPL | Stock | 0.2564 | 0.2598 | 0.2564 | 0.2589 | 5093928.0 |
| 2003-01-02 09:35:00 | AAPL | Stock | 0.2589 | 0.2593 | 0.2584 | 0.2589 | 5333440.0 |
| 2003-01-02 09:40:00 | AAPL | Stock | 0.2589 | 0.2591 | 0.2588 | 0.2589 | 12391904.0 |
| 2003-01-02 09:45:00 | AAPL | Stock | 0.2589 | 0.2589 | 0.2571 | 0.2573 | 4070640.0 |
| 2003-01-02 09:50:00 | AAPL | Stock | 0.2572 | 0.2577 | 0.2563 | 0.2571 | 3460688.0 |
| 2003-01-02 09:55:00 | AAPL | Stock | 0.2573 | 0.2586 | 0.2564 | 0.258 | 1188096.0 |
| 2003-01-02 10:00:00 | AAPL | Stock | 0.258 | 0.2623 | 0.258 | 0.2618 | 5327896.0 |
| 2003-01-02 10:05:00 | AAPL | Stock | 0.2614 | 0.2627 | 0.2604 | 0.2623 | 3284008.0 |
| 2003-01-02 10:10:00 | AAPL | Stock | 0.2627 | 0.2638 | 0.2618 | 0.2623 | 3709664.0 |
| 2003-01-02 10:15:00 | AAPL | Stock | 0.2621 | 0.2627 | 0.262 | 0.2623 | 1909600.0 |
| 2003-01-02 10:20:00 | AAPL | Stock | 0.262 | 0.2636 | 0.262 | 0.2627 | 2629256.0 |
| 2003-01-02 10:25:00 | AAPL | Stock | 0.2625 | 0.2643 | 0.2625 | 0.2643 | 4306400.0 |
| 2003-01-02 10:30:00 | AAPL | Stock | 0.2643 | 0.2652 | 0.2639 | 0.2641 | 7028672.0 |
| 2003-01-02 10:35:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.2636 | 0.2639 | 2340464.0 |
| 2003-01-02 10:40:00 | AAPL | Stock | 0.2639 | 0.265 | 0.2636 | 0.265 | 2228184.0 |
| 2003-01-02 10:45:00 | AAPL | Stock | 0.2648 | 0.2648 | 0.2636 | 0.2646 | 1626800.0 |
| 2003-01-02 10:50:00 | AAPL | Stock | 0.2646 | 0.2652 | 0.2639 | 0.2641 | 1589000.0 |
| 2003-01-02 10:55:00 | AAPL | Stock | 0.2641 | 0.2645 | 0.2639 | 0.2645 | 1835456.0 |
| 2003-01-02 11:00:00 | AAPL | Stock | 0.2645 | 0.2652 | 0.2641 | 0.2641 | 1385664.0 |
| 2003-01-02 11:05:00 | AAPL | Stock | 0.2639 | 0.2641 | 0.2629 | 0.263 | 1814400.0 |
| 2003-01-02 11:10:00 | AAPL | Stock | 0.263 | 0.2639 | 0.2625 | 0.2639 | 877128.0 |
| 2003-01-02 11:15:00 | AAPL | Stock | 0.2638 | 0.2638 | 0.2634 | 0.2638 | 238784.0 |
| 2003-01-02 11:20:00 | AAPL | Stock | 0.2636 | 0.2643 | 0.2636 | 0.2641 | 1125040.0 |
| 2003-01-02 11:25:00 | AAPL | Stock | 0.2643 | 0.2648 | 0.2641 | 0.2643 | 980000.0 |
| 2003-01-02 11:30:00 | AAPL | Stock | 0.2643 | 0.2648 | 0.2643 | 0.2645 | 606984.0 |
| 2003-01-02 11:35:00 | AAPL | Stock | 0.2643 | 0.2645 | 0.2639 | 0.2639 | 924000.0 |
| 2003-01-02 11:40:00 | AAPL | Stock | 0.2639 | 0.2643 | 0.2634 | 0.2636 | 4972800.0 |
| 2003-01-02 11:45:00 | AAPL | Stock | 0.2636 | 0.2646 | 0.2634 | 0.2646 | 1531712.0 |
| 2003-01-02 11:50:00 | AAPL | Stock | 0.2643 | 0.2646 | 0.2641 | 0.2643 | 1128400.0 |
| 2003-01-02 11:55:00 | AAPL | Stock | 0.2643 | 0.2652 | 0.2643 | 0.2652 | 1215200.0 |
| 2003-01-02 12:00:00 | AAPL | Stock | 0.265 | 0.2654 | 0.2646 | 0.2652 | 1685600.0 |
| 2003-01-02 12:05:00 | AAPL | Stock | 0.265 | 0.2654 | 0.2643 | 0.2652 | 2217600.0 |
| 2003-01-02 12:10:00 | AAPL | Stock | 0.2651 | 0.2654 | 0.2651 | 0.2652 | 280616.0 |
| 2003-01-02 12:15:00 | AAPL | Stock | 0.2652 | 0.2661 | 0.2652 | 0.2657 | 3840760.0 |
| 2003-01-02 12:20:00 | AAPL | Stock | 0.2655 | 0.2655 | 0.265 | 0.265 | 1147664.0 |
| 2003-01-02 12:25:00 | AAPL | Stock | 0.2652 | 0.2652 | 0.2648 | 0.2652 | 378896.0 |
| 2003-01-02 12:30:00 | AAPL | Stock | 0.2652 | 0.2655 | 0.265 | 0.265 | 1703968.0 |
| 2003-01-02 12:35:00 | AAPL | Stock | 0.265 | 0.2657 | 0.265 | 0.2652 | 1280048.0 |
| 2003-01-02 12:40:00 | AAPL | Stock | 0.2652 | 0.2661 | 0.2648 | 0.2655 | 1151080.0 |
| 2003-01-02 12:45:00 | AAPL | Stock | 0.2655 | 0.2655 | 0.265 | 0.265 | 199136.0 |
| 2003-01-02 12:50:00 | AAPL | Stock | 0.265 | 0.265 | 0.2646 | 0.2646 | 548800.0 |
| 2003-01-02 12:55:00 | AAPL | Stock | 0.2648 | 0.265 | 0.2646 | 0.2646 | 604800.0 |
| 2003-01-02 13:00:00 | AAPL | Stock | 0.2646 | 0.265 | 0.2646 | 0.2648 | 688800.0 |
| 2003-01-02 13:05:00 | AAPL | Stock | 0.2646 | 0.2648 | 0.2641 | 0.2641 | 1507296.0 |
| 2003-01-02 13:10:00 | AAPL | Stock | 0.2641 | 0.2643 | 0.2638 | 0.2639 | 304640.0 |
| 2003-01-02 13:15:00 | AAPL | Stock | 0.2638 | 0.2638 | 0.2634 | 0.2636 | 719544.0 |
| 2003-01-02 13:20:00 | AAPL | Stock | 0.2634 | 0.2636 | 0.263 | 0.2634 | 750400.0 |
| 2003-01-02 13:25:00 | AAPL | Stock | 0.263 | 0.2632 | 0.2629 | 0.263 | 648088.0 |
> showing 50 of 135,069 rows — these rows as CSV