PREVIEW / stock_5min / 2005-01-25
file: by_date/stock_5min/2005/2005-01-25.parquet size: 2.6 MB rows: 189,160 symbols: 1,909
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-25 08:00:00 | AAPL | Stock | 1.2707 | 1.2707 | 1.2707 | 1.2707 | 22400.0 |
| 2005-01-25 08:05:00 | AAPL | Stock | 1.2711 | 1.2723 | 1.2705 | 1.2723 | 92176.0 |
| 2005-01-25 08:10:00 | AAPL | Stock | 1.2705 | 1.2705 | 1.2696 | 1.2696 | 187936.0 |
| 2005-01-25 08:15:00 | AAPL | Stock | 1.2696 | 1.2696 | 1.2696 | 1.2696 | 78288.0 |
| 2005-01-25 08:20:00 | AAPL | Stock | 1.2723 | 1.2732 | 1.2723 | 1.2723 | 333200.0 |
| 2005-01-25 08:30:00 | AAPL | Stock | 1.2725 | 1.2759 | 1.2725 | 1.275 | 386176.0 |
| 2005-01-25 08:35:00 | AAPL | Stock | 1.2759 | 1.2779 | 1.275 | 1.275 | 336000.0 |
| 2005-01-25 08:40:00 | AAPL | Stock | 1.2732 | 1.2732 | 1.2732 | 1.2732 | 11200.0 |
| 2005-01-25 08:45:00 | AAPL | Stock | 1.2734 | 1.2736 | 1.2714 | 1.2716 | 162400.0 |
| 2005-01-25 08:55:00 | AAPL | Stock | 1.272 | 1.272 | 1.272 | 1.272 | 11200.0 |
| 2005-01-25 09:00:00 | AAPL | Stock | 1.2723 | 1.2727 | 1.2723 | 1.2727 | 44800.0 |
| 2005-01-25 09:10:00 | AAPL | Stock | 1.2723 | 1.2727 | 1.2705 | 1.2718 | 403200.0 |
| 2005-01-25 09:15:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2723 | 1.2723 | 33600.0 |
| 2005-01-25 09:20:00 | AAPL | Stock | 1.2714 | 1.2723 | 1.2709 | 1.2709 | 182000.0 |
| 2005-01-25 09:25:00 | AAPL | Stock | 1.2723 | 1.2768 | 1.2723 | 1.2755 | 1783264.0 |
| 2005-01-25 09:30:00 | AAPL | Stock | 1.2752 | 1.2764 | 1.2725 | 1.2736 | 21623504.0 |
| 2005-01-25 09:35:00 | AAPL | Stock | 1.2739 | 1.2741 | 1.2709 | 1.2718 | 21245616.0 |
| 2005-01-25 09:40:00 | AAPL | Stock | 1.2718 | 1.2727 | 1.2668 | 1.2702 | 26405344.0 |
| 2005-01-25 09:45:00 | AAPL | Stock | 1.2702 | 1.275 | 1.2688 | 1.2739 | 31556728.0 |
| 2005-01-25 09:50:00 | AAPL | Stock | 1.2738 | 1.2739 | 1.268 | 1.2688 | 14173544.0 |
| 2005-01-25 09:55:00 | AAPL | Stock | 1.2688 | 1.2721 | 1.2682 | 1.2716 | 11300240.0 |
| 2005-01-25 10:00:00 | AAPL | Stock | 1.2716 | 1.2771 | 1.2714 | 1.2752 | 24305848.0 |
| 2005-01-25 10:05:00 | AAPL | Stock | 1.2746 | 1.2764 | 1.2696 | 1.2759 | 9940224.0 |
| 2005-01-25 10:10:00 | AAPL | Stock | 1.2759 | 1.2814 | 1.2746 | 1.2793 | 28806456.0 |
| 2005-01-25 10:15:00 | AAPL | Stock | 1.2793 | 1.2857 | 1.2789 | 1.2853 | 31670576.0 |
| 2005-01-25 10:20:00 | AAPL | Stock | 1.2852 | 1.2855 | 1.2807 | 1.2846 | 37881368.0 |
| 2005-01-25 10:25:00 | AAPL | Stock | 1.2848 | 1.2898 | 1.2841 | 1.2891 | 41819792.0 |
| 2005-01-25 10:30:00 | AAPL | Stock | 1.2891 | 1.2936 | 1.2879 | 1.2904 | 25437888.0 |
| 2005-01-25 10:35:00 | AAPL | Stock | 1.2902 | 1.2973 | 1.2882 | 1.2971 | 26426624.0 |
| 2005-01-25 10:40:00 | AAPL | Stock | 1.2971 | 1.2979 | 1.2911 | 1.2913 | 25219096.0 |
| 2005-01-25 10:45:00 | AAPL | Stock | 1.2913 | 1.293 | 1.29 | 1.292 | 11273696.0 |
| 2005-01-25 10:50:00 | AAPL | Stock | 1.291 | 1.2938 | 1.2888 | 1.2934 | 13205192.0 |
| 2005-01-25 10:55:00 | AAPL | Stock | 1.2929 | 1.2934 | 1.2893 | 1.2905 | 8977136.0 |
| 2005-01-25 11:00:00 | AAPL | Stock | 1.2905 | 1.2925 | 1.2902 | 1.2916 | 6827296.0 |
| 2005-01-25 11:05:00 | AAPL | Stock | 1.2919 | 1.2989 | 1.2913 | 1.2973 | 20603856.0 |
| 2005-01-25 11:10:00 | AAPL | Stock | 1.2971 | 1.3007 | 1.2964 | 1.2989 | 21141456.0 |
| 2005-01-25 11:15:00 | AAPL | Stock | 1.2982 | 1.2993 | 1.295 | 1.2979 | 9967944.0 |
| 2005-01-25 11:20:00 | AAPL | Stock | 1.2977 | 1.2984 | 1.2957 | 1.2961 | 5371016.0 |
| 2005-01-25 11:25:00 | AAPL | Stock | 1.2961 | 1.2975 | 1.2955 | 1.297 | 10056144.0 |
| 2005-01-25 11:30:00 | AAPL | Stock | 1.297 | 1.2996 | 1.2963 | 1.2984 | 7564200.0 |
| 2005-01-25 11:35:00 | AAPL | Stock | 1.2986 | 1.2988 | 1.2913 | 1.2941 | 12428136.0 |
| 2005-01-25 11:40:00 | AAPL | Stock | 1.2941 | 1.2961 | 1.2918 | 1.2932 | 10166184.0 |
| 2005-01-25 11:45:00 | AAPL | Stock | 1.2932 | 1.2945 | 1.2923 | 1.2936 | 8707664.0 |
| 2005-01-25 11:50:00 | AAPL | Stock | 1.2929 | 1.2945 | 1.2913 | 1.2928 | 9399656.0 |
| 2005-01-25 11:55:00 | AAPL | Stock | 1.2921 | 1.2938 | 1.292 | 1.2921 | 5020008.0 |
| 2005-01-25 12:00:00 | AAPL | Stock | 1.2921 | 1.2929 | 1.2888 | 1.2891 | 11823056.0 |
| 2005-01-25 12:05:00 | AAPL | Stock | 1.2889 | 1.2925 | 1.2879 | 1.292 | 9306864.0 |
| 2005-01-25 12:10:00 | AAPL | Stock | 1.2918 | 1.2921 | 1.29 | 1.2911 | 3980256.0 |
| 2005-01-25 12:15:00 | AAPL | Stock | 1.291 | 1.2913 | 1.2896 | 1.2911 | 4353776.0 |
| 2005-01-25 12:20:00 | AAPL | Stock | 1.2913 | 1.2932 | 1.2911 | 1.2927 | 6849192.0 |
> showing 50 of 189,160 rows — these rows as CSV