PREVIEW / stock_5min / 2005-01-21
file: by_date/stock_5min/2005/2005-01-21.parquet size: 2.6 MB rows: 189,889 symbols: 1,908
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-21 08:00:00 | AAPL | Stock | 1.2813 | 1.2821 | 1.2768 | 1.2813 | 637840.0 |
| 2005-01-21 08:05:00 | AAPL | Stock | 1.2788 | 1.2788 | 1.2668 | 1.2766 | 346640.0 |
| 2005-01-21 08:10:00 | AAPL | Stock | 1.2768 | 1.2768 | 1.2732 | 1.2759 | 509600.0 |
| 2005-01-21 08:15:00 | AAPL | Stock | 1.2759 | 1.2768 | 1.2743 | 1.2752 | 721280.0 |
| 2005-01-21 08:20:00 | AAPL | Stock | 1.2757 | 1.2768 | 1.2752 | 1.2768 | 477120.0 |
| 2005-01-21 08:25:00 | AAPL | Stock | 1.2768 | 1.2768 | 1.2759 | 1.2763 | 218960.0 |
| 2005-01-21 08:30:00 | AAPL | Stock | 1.2763 | 1.2782 | 1.2763 | 1.2775 | 660800.0 |
| 2005-01-21 08:35:00 | AAPL | Stock | 1.2775 | 1.2777 | 1.2768 | 1.2768 | 448000.0 |
| 2005-01-21 08:40:00 | AAPL | Stock | 1.2771 | 1.2777 | 1.2771 | 1.2777 | 240800.0 |
| 2005-01-21 08:45:00 | AAPL | Stock | 1.2777 | 1.2804 | 1.2775 | 1.2804 | 806400.0 |
| 2005-01-21 08:50:00 | AAPL | Stock | 1.28 | 1.2813 | 1.2788 | 1.2791 | 532000.0 |
| 2005-01-21 08:55:00 | AAPL | Stock | 1.2791 | 1.2802 | 1.2786 | 1.2802 | 305704.0 |
| 2005-01-21 09:00:00 | AAPL | Stock | 1.2802 | 1.2802 | 1.2786 | 1.2786 | 612696.0 |
| 2005-01-21 09:05:00 | AAPL | Stock | 1.2786 | 1.2789 | 1.2786 | 1.2786 | 665336.0 |
| 2005-01-21 09:10:00 | AAPL | Stock | 1.2786 | 1.2788 | 1.2777 | 1.278 | 888608.0 |
| 2005-01-21 09:15:00 | AAPL | Stock | 1.2788 | 1.2788 | 1.278 | 1.2786 | 252000.0 |
| 2005-01-21 09:20:00 | AAPL | Stock | 1.2786 | 1.2795 | 1.2582 | 1.2788 | 1244320.0 |
| 2005-01-21 09:25:00 | AAPL | Stock | 1.2688 | 1.2795 | 1.2634 | 1.2745 | 8361864.0 |
| 2005-01-21 09:30:00 | AAPL | Stock | 1.2718 | 1.2786 | 1.2645 | 1.2691 | 78454208.0 |
| 2005-01-21 09:35:00 | AAPL | Stock | 1.2691 | 1.2768 | 1.267 | 1.2693 | 40439336.0 |
| 2005-01-21 09:40:00 | AAPL | Stock | 1.2693 | 1.2723 | 1.2652 | 1.2707 | 32841088.0 |
| 2005-01-21 09:45:00 | AAPL | Stock | 1.2704 | 1.2736 | 1.2688 | 1.2688 | 23922024.0 |
| 2005-01-21 09:50:00 | AAPL | Stock | 1.2684 | 1.2704 | 1.263 | 1.2652 | 27383776.0 |
| 2005-01-21 09:55:00 | AAPL | Stock | 1.2654 | 1.2734 | 1.2643 | 1.2721 | 23618056.0 |
| 2005-01-21 10:00:00 | AAPL | Stock | 1.2721 | 1.2741 | 1.2698 | 1.272 | 16324560.0 |
| 2005-01-21 10:05:00 | AAPL | Stock | 1.272 | 1.2746 | 1.2707 | 1.2725 | 12147968.0 |
| 2005-01-21 10:10:00 | AAPL | Stock | 1.2727 | 1.2729 | 1.2688 | 1.2702 | 19928776.0 |
| 2005-01-21 10:15:00 | AAPL | Stock | 1.2704 | 1.2714 | 1.2688 | 1.2705 | 17300080.0 |
| 2005-01-21 10:20:00 | AAPL | Stock | 1.2709 | 1.2714 | 1.2698 | 1.2714 | 5436648.0 |
| 2005-01-21 10:25:00 | AAPL | Stock | 1.2714 | 1.2716 | 1.267 | 1.2711 | 13785240.0 |
| 2005-01-21 10:30:00 | AAPL | Stock | 1.2711 | 1.2714 | 1.2679 | 1.2705 | 10626448.0 |
| 2005-01-21 10:35:00 | AAPL | Stock | 1.2705 | 1.2714 | 1.2661 | 1.2671 | 9164512.0 |
| 2005-01-21 10:40:00 | AAPL | Stock | 1.2673 | 1.2676 | 1.2643 | 1.2652 | 10720304.0 |
| 2005-01-21 10:45:00 | AAPL | Stock | 1.2652 | 1.2684 | 1.2641 | 1.268 | 12759152.0 |
| 2005-01-21 10:50:00 | AAPL | Stock | 1.2679 | 1.2682 | 1.2645 | 1.2654 | 11277112.0 |
| 2005-01-21 10:55:00 | AAPL | Stock | 1.2654 | 1.267 | 1.2636 | 1.2668 | 9648856.0 |
| 2005-01-21 11:00:00 | AAPL | Stock | 1.2666 | 1.267 | 1.2652 | 1.2655 | 4896696.0 |
| 2005-01-21 11:05:00 | AAPL | Stock | 1.2655 | 1.2659 | 1.2643 | 1.2659 | 4574808.0 |
| 2005-01-21 11:10:00 | AAPL | Stock | 1.2657 | 1.2668 | 1.265 | 1.2659 | 4804240.0 |
| 2005-01-21 11:15:00 | AAPL | Stock | 1.2659 | 1.2679 | 1.2655 | 1.2675 | 4001648.0 |
| 2005-01-21 11:20:00 | AAPL | Stock | 1.2671 | 1.2705 | 1.2663 | 1.2698 | 7261632.0 |
| 2005-01-21 11:25:00 | AAPL | Stock | 1.2696 | 1.2714 | 1.2682 | 1.2704 | 9003792.0 |
| 2005-01-21 11:30:00 | AAPL | Stock | 1.2696 | 1.2705 | 1.2682 | 1.2696 | 10575096.0 |
| 2005-01-21 11:35:00 | AAPL | Stock | 1.2698 | 1.2705 | 1.2691 | 1.2702 | 4561480.0 |
| 2005-01-21 11:40:00 | AAPL | Stock | 1.2705 | 1.2705 | 1.2698 | 1.2702 | 5623184.0 |
| 2005-01-21 11:45:00 | AAPL | Stock | 1.2704 | 1.2705 | 1.2695 | 1.2705 | 4816672.0 |
| 2005-01-21 11:50:00 | AAPL | Stock | 1.27 | 1.2705 | 1.2698 | 1.27 | 2912168.0 |
| 2005-01-21 11:55:00 | AAPL | Stock | 1.27 | 1.2704 | 1.2691 | 1.2696 | 3700200.0 |
| 2005-01-21 12:00:00 | AAPL | Stock | 1.2698 | 1.2705 | 1.2691 | 1.2694 | 7844256.0 |
| 2005-01-21 12:05:00 | AAPL | Stock | 1.2696 | 1.2704 | 1.2686 | 1.2686 | 3433248.0 |
> showing 50 of 189,889 rows — these rows as CSV