PREVIEW / stock_5min / 2005-01-24
file: by_date/stock_5min/2005/2005-01-24.parquet size: 2.6 MB rows: 189,184 symbols: 1,914
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-24 08:00:00 | AAPL | Stock | 1.2727 | 1.2727 | 1.2652 | 1.2652 | 78792.0 |
| 2005-01-24 08:05:00 | AAPL | Stock | 1.2652 | 1.2679 | 1.2641 | 1.265 | 213584.0 |
| 2005-01-24 08:10:00 | AAPL | Stock | 1.265 | 1.2688 | 1.265 | 1.2688 | 22400.0 |
| 2005-01-24 08:15:00 | AAPL | Stock | 1.2652 | 1.2652 | 1.265 | 1.265 | 45920.0 |
| 2005-01-24 08:20:00 | AAPL | Stock | 1.2673 | 1.2679 | 1.2652 | 1.2679 | 427224.0 |
| 2005-01-24 08:25:00 | AAPL | Stock | 1.2679 | 1.2679 | 1.2661 | 1.2661 | 168000.0 |
| 2005-01-24 08:30:00 | AAPL | Stock | 1.2679 | 1.2686 | 1.2675 | 1.2679 | 240800.0 |
| 2005-01-24 08:35:00 | AAPL | Stock | 1.2684 | 1.2732 | 1.2684 | 1.2723 | 1118600.0 |
| 2005-01-24 08:40:00 | AAPL | Stock | 1.2727 | 1.2732 | 1.2713 | 1.2723 | 638288.0 |
| 2005-01-24 08:45:00 | AAPL | Stock | 1.2723 | 1.2741 | 1.2723 | 1.2723 | 56000.0 |
| 2005-01-24 08:50:00 | AAPL | Stock | 1.2707 | 1.2732 | 1.2707 | 1.2718 | 760424.0 |
| 2005-01-24 08:55:00 | AAPL | Stock | 1.273 | 1.2732 | 1.2723 | 1.2723 | 52640.0 |
| 2005-01-24 09:00:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2696 | 1.2714 | 149800.0 |
| 2005-01-24 09:05:00 | AAPL | Stock | 1.2714 | 1.2723 | 1.2714 | 1.2714 | 327040.0 |
| 2005-01-24 09:10:00 | AAPL | Stock | 1.2714 | 1.2714 | 1.2714 | 1.2714 | 91000.0 |
| 2005-01-24 09:15:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2707 | 1.2707 | 96656.0 |
| 2005-01-24 09:20:00 | AAPL | Stock | 1.27 | 1.27 | 1.2679 | 1.2696 | 352072.0 |
| 2005-01-24 09:25:00 | AAPL | Stock | 1.2618 | 1.2709 | 1.2614 | 1.2684 | 2055984.0 |
| 2005-01-24 09:30:00 | AAPL | Stock | 1.2675 | 1.2761 | 1.2643 | 1.2725 | 39289208.0 |
| 2005-01-24 09:35:00 | AAPL | Stock | 1.2729 | 1.2768 | 1.2714 | 1.2736 | 21653128.0 |
| 2005-01-24 09:40:00 | AAPL | Stock | 1.2741 | 1.2777 | 1.2723 | 1.2729 | 24889816.0 |
| 2005-01-24 09:45:00 | AAPL | Stock | 1.2729 | 1.2746 | 1.2696 | 1.2725 | 15424080.0 |
| 2005-01-24 09:50:00 | AAPL | Stock | 1.2725 | 1.2741 | 1.2679 | 1.2696 | 16621752.0 |
| 2005-01-24 09:55:00 | AAPL | Stock | 1.2695 | 1.2721 | 1.2693 | 1.2702 | 11321016.0 |
| 2005-01-24 10:00:00 | AAPL | Stock | 1.27 | 1.2727 | 1.2682 | 1.2702 | 10778264.0 |
| 2005-01-24 10:05:00 | AAPL | Stock | 1.2698 | 1.2723 | 1.2698 | 1.2709 | 8928752.0 |
| 2005-01-24 10:10:00 | AAPL | Stock | 1.2705 | 1.2746 | 1.2679 | 1.2745 | 16433256.0 |
| 2005-01-24 10:15:00 | AAPL | Stock | 1.2745 | 1.2779 | 1.2734 | 1.275 | 35443576.0 |
| 2005-01-24 10:20:00 | AAPL | Stock | 1.2745 | 1.2764 | 1.2732 | 1.2748 | 15067864.0 |
| 2005-01-24 10:25:00 | AAPL | Stock | 1.275 | 1.2764 | 1.2734 | 1.2741 | 7592928.0 |
| 2005-01-24 10:30:00 | AAPL | Stock | 1.2741 | 1.2777 | 1.2739 | 1.2775 | 25434640.0 |
| 2005-01-24 10:35:00 | AAPL | Stock | 1.2777 | 1.2818 | 1.2764 | 1.2768 | 48783224.0 |
| 2005-01-24 10:40:00 | AAPL | Stock | 1.2768 | 1.277 | 1.2741 | 1.2752 | 16040584.0 |
| 2005-01-24 10:45:00 | AAPL | Stock | 1.275 | 1.2766 | 1.2732 | 1.2732 | 9080064.0 |
| 2005-01-24 10:50:00 | AAPL | Stock | 1.2732 | 1.2745 | 1.272 | 1.2723 | 15951488.0 |
| 2005-01-24 10:55:00 | AAPL | Stock | 1.2721 | 1.2723 | 1.2689 | 1.2702 | 17880128.0 |
| 2005-01-24 11:00:00 | AAPL | Stock | 1.27 | 1.2721 | 1.2698 | 1.2702 | 7218904.0 |
| 2005-01-24 11:05:00 | AAPL | Stock | 1.27 | 1.2714 | 1.2677 | 1.2704 | 16298912.0 |
| 2005-01-24 11:10:00 | AAPL | Stock | 1.2707 | 1.2732 | 1.2707 | 1.2711 | 7034776.0 |
| 2005-01-24 11:15:00 | AAPL | Stock | 1.2711 | 1.2748 | 1.2711 | 1.2741 | 9845304.0 |
| 2005-01-24 11:20:00 | AAPL | Stock | 1.2741 | 1.2757 | 1.272 | 1.2746 | 12818792.0 |
| 2005-01-24 11:25:00 | AAPL | Stock | 1.2748 | 1.2755 | 1.272 | 1.2725 | 7599368.0 |
| 2005-01-24 11:30:00 | AAPL | Stock | 1.2725 | 1.2748 | 1.2696 | 1.2746 | 5143824.0 |
| 2005-01-24 11:35:00 | AAPL | Stock | 1.2743 | 1.2752 | 1.2718 | 1.2721 | 6808200.0 |
| 2005-01-24 11:40:00 | AAPL | Stock | 1.272 | 1.2723 | 1.2648 | 1.2679 | 19823608.0 |
| 2005-01-24 11:45:00 | AAPL | Stock | 1.2679 | 1.2754 | 1.2623 | 1.2657 | 24807776.0 |
| 2005-01-24 11:50:00 | AAPL | Stock | 1.2654 | 1.2727 | 1.2654 | 1.268 | 6907320.0 |
| 2005-01-24 11:55:00 | AAPL | Stock | 1.2682 | 1.2686 | 1.2661 | 1.267 | 6717200.0 |
| 2005-01-24 12:00:00 | AAPL | Stock | 1.2673 | 1.2707 | 1.2666 | 1.2689 | 7269360.0 |
| 2005-01-24 12:05:00 | AAPL | Stock | 1.2689 | 1.2696 | 1.2643 | 1.2652 | 5766208.0 |
> showing 50 of 189,184 rows — these rows as CSV