PREVIEW / stock_5min / 2002-08-02
file: by_date/stock_5min/2002/2002-08-02.parquet size: 1.8 MB rows: 126,547 symbols: 1,456
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-08-02 08:00:00 | AAPL | Stock | 0.2642 | 0.2642 | 0.2634 | 0.2634 | 67200.0 |
| 2002-08-02 08:35:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 50400.0 |
| 2002-08-02 08:40:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 67200.0 |
| 2002-08-02 08:50:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2627 | 0.2632 | 100800.0 |
| 2002-08-02 08:55:00 | AAPL | Stock | 0.2632 | 0.2632 | 0.2625 | 0.2625 | 56000.0 |
| 2002-08-02 09:00:00 | AAPL | Stock | 0.2625 | 0.2625 | 0.2625 | 0.2625 | 56000.0 |
| 2002-08-02 09:15:00 | AAPL | Stock | 0.2616 | 0.2634 | 0.2616 | 0.2634 | 89600.0 |
| 2002-08-02 09:25:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.2641 | 0.2641 | 33600.0 |
| 2002-08-02 09:30:00 | AAPL | Stock | 0.2632 | 0.2679 | 0.2632 | 0.2673 | 5320000.0 |
| 2002-08-02 09:35:00 | AAPL | Stock | 0.2666 | 0.2666 | 0.2645 | 0.2655 | 2256800.0 |
| 2002-08-02 09:40:00 | AAPL | Stock | 0.2655 | 0.2657 | 0.2641 | 0.2657 | 4534432.0 |
| 2002-08-02 09:45:00 | AAPL | Stock | 0.2657 | 0.2661 | 0.2646 | 0.2646 | 2715720.0 |
| 2002-08-02 09:50:00 | AAPL | Stock | 0.2646 | 0.2655 | 0.2646 | 0.2655 | 2223200.0 |
| 2002-08-02 09:55:00 | AAPL | Stock | 0.2654 | 0.2661 | 0.2646 | 0.2657 | 1786400.0 |
| 2002-08-02 10:00:00 | AAPL | Stock | 0.2652 | 0.2661 | 0.2634 | 0.2653 | 3999408.0 |
| 2002-08-02 10:05:00 | AAPL | Stock | 0.2654 | 0.2661 | 0.2634 | 0.2636 | 3785376.0 |
| 2002-08-02 10:10:00 | AAPL | Stock | 0.2639 | 0.2639 | 0.2627 | 0.263 | 4299512.0 |
| 2002-08-02 10:15:00 | AAPL | Stock | 0.2632 | 0.2639 | 0.263 | 0.2636 | 2051672.0 |
| 2002-08-02 10:20:00 | AAPL | Stock | 0.2634 | 0.2636 | 0.2618 | 0.2636 | 3074400.0 |
| 2002-08-02 10:25:00 | AAPL | Stock | 0.2636 | 0.2641 | 0.2616 | 0.2616 | 1422400.0 |
| 2002-08-02 10:30:00 | AAPL | Stock | 0.2616 | 0.2622 | 0.2609 | 0.2622 | 1289568.0 |
| 2002-08-02 10:35:00 | AAPL | Stock | 0.2623 | 0.2627 | 0.2607 | 0.2614 | 560000.0 |
| 2002-08-02 10:40:00 | AAPL | Stock | 0.2614 | 0.2618 | 0.2593 | 0.2598 | 1597680.0 |
| 2002-08-02 10:45:00 | AAPL | Stock | 0.26 | 0.2607 | 0.2593 | 0.2598 | 1300320.0 |
| 2002-08-02 10:50:00 | AAPL | Stock | 0.2604 | 0.2607 | 0.2591 | 0.2593 | 1411200.0 |
| 2002-08-02 10:55:00 | AAPL | Stock | 0.2593 | 0.2598 | 0.2593 | 0.2598 | 1584800.0 |
| 2002-08-02 11:00:00 | AAPL | Stock | 0.2598 | 0.2605 | 0.2595 | 0.2598 | 1267504.0 |
| 2002-08-02 11:05:00 | AAPL | Stock | 0.26 | 0.2618 | 0.2596 | 0.2616 | 2052792.0 |
| 2002-08-02 11:10:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2598 | 0.26 | 576800.0 |
| 2002-08-02 11:15:00 | AAPL | Stock | 0.26 | 0.26 | 0.2591 | 0.2591 | 2664480.0 |
| 2002-08-02 11:20:00 | AAPL | Stock | 0.2593 | 0.2604 | 0.2591 | 0.2596 | 1797600.0 |
| 2002-08-02 11:25:00 | AAPL | Stock | 0.2596 | 0.2607 | 0.2596 | 0.2605 | 985600.0 |
| 2002-08-02 11:30:00 | AAPL | Stock | 0.2604 | 0.2604 | 0.2596 | 0.26 | 495600.0 |
| 2002-08-02 11:35:00 | AAPL | Stock | 0.2604 | 0.2607 | 0.26 | 0.26 | 1635200.0 |
| 2002-08-02 11:40:00 | AAPL | Stock | 0.2596 | 0.2596 | 0.2589 | 0.2591 | 2617160.0 |
| 2002-08-02 11:45:00 | AAPL | Stock | 0.2591 | 0.2593 | 0.2589 | 0.2593 | 1592304.0 |
| 2002-08-02 11:50:00 | AAPL | Stock | 0.2593 | 0.2596 | 0.2589 | 0.2596 | 812000.0 |
| 2002-08-02 11:55:00 | AAPL | Stock | 0.2595 | 0.2595 | 0.2589 | 0.2591 | 878528.0 |
| 2002-08-02 12:00:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2586 | 0.2586 | 3753120.0 |
| 2002-08-02 12:05:00 | AAPL | Stock | 0.2586 | 0.2588 | 0.2584 | 0.2586 | 1478400.0 |
| 2002-08-02 12:10:00 | AAPL | Stock | 0.2586 | 0.2589 | 0.2584 | 0.2589 | 1666392.0 |
| 2002-08-02 12:15:00 | AAPL | Stock | 0.2586 | 0.2589 | 0.2584 | 0.2584 | 2265648.0 |
| 2002-08-02 12:20:00 | AAPL | Stock | 0.2584 | 0.2589 | 0.2584 | 0.2584 | 1640800.0 |
| 2002-08-02 12:25:00 | AAPL | Stock | 0.2584 | 0.2589 | 0.2584 | 0.2588 | 627200.0 |
| 2002-08-02 12:30:00 | AAPL | Stock | 0.2586 | 0.2595 | 0.2584 | 0.2589 | 2278808.0 |
| 2002-08-02 12:35:00 | AAPL | Stock | 0.2589 | 0.2593 | 0.2588 | 0.2593 | 1310400.0 |
| 2002-08-02 12:40:00 | AAPL | Stock | 0.2591 | 0.2595 | 0.2586 | 0.2588 | 4032000.0 |
| 2002-08-02 12:45:00 | AAPL | Stock | 0.2588 | 0.2591 | 0.2584 | 0.2589 | 1879360.0 |
| 2002-08-02 12:50:00 | AAPL | Stock | 0.2589 | 0.2595 | 0.2588 | 0.2588 | 382592.0 |
| 2002-08-02 12:55:00 | AAPL | Stock | 0.2588 | 0.2588 | 0.2584 | 0.2584 | 957600.0 |
> showing 50 of 126,547 rows — these rows as CSV