PREVIEW / stock_5min / 2005-01-27
file: by_date/stock_5min/2005/2005-01-27.parquet size: 2.6 MB rows: 187,816 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-27 08:00:00 | AAPL | Stock | 1.29 | 1.29 | 1.29 | 1.29 | 28000.0 |
| 2005-01-27 08:05:00 | AAPL | Stock | 1.29 | 1.29 | 1.29 | 1.29 | 89600.0 |
| 2005-01-27 08:10:00 | AAPL | Stock | 1.2893 | 1.2893 | 1.2884 | 1.2886 | 442512.0 |
| 2005-01-27 08:15:00 | AAPL | Stock | 1.2875 | 1.2884 | 1.2875 | 1.2884 | 72800.0 |
| 2005-01-27 08:20:00 | AAPL | Stock | 1.2884 | 1.2884 | 1.2884 | 1.2884 | 25200.0 |
| 2005-01-27 08:25:00 | AAPL | Stock | 1.2886 | 1.2886 | 1.2884 | 1.2884 | 361200.0 |
| 2005-01-27 08:30:00 | AAPL | Stock | 1.2886 | 1.2886 | 1.2866 | 1.2866 | 16800.0 |
| 2005-01-27 08:35:00 | AAPL | Stock | 1.2866 | 1.2875 | 1.2866 | 1.2875 | 39200.0 |
| 2005-01-27 08:40:00 | AAPL | Stock | 1.2861 | 1.2861 | 1.2861 | 1.2861 | 28000.0 |
| 2005-01-27 08:55:00 | AAPL | Stock | 1.2875 | 1.2875 | 1.2875 | 1.2875 | 38080.0 |
| 2005-01-27 09:00:00 | AAPL | Stock | 1.2886 | 1.2893 | 1.2879 | 1.2893 | 61600.0 |
| 2005-01-27 09:05:00 | AAPL | Stock | 1.2918 | 1.2918 | 1.2902 | 1.2907 | 22400.0 |
| 2005-01-27 09:10:00 | AAPL | Stock | 1.2902 | 1.2902 | 1.2902 | 1.2902 | 5600.0 |
| 2005-01-27 09:15:00 | AAPL | Stock | 1.2893 | 1.2893 | 1.2893 | 1.2893 | 56000.0 |
| 2005-01-27 09:25:00 | AAPL | Stock | 1.2891 | 1.2891 | 1.2875 | 1.2882 | 336952.0 |
| 2005-01-27 09:30:00 | AAPL | Stock | 1.2886 | 1.2929 | 1.2788 | 1.2855 | 17454752.0 |
| 2005-01-27 09:35:00 | AAPL | Stock | 1.2858 | 1.2866 | 1.2821 | 1.2852 | 12302360.0 |
| 2005-01-27 09:40:00 | AAPL | Stock | 1.2854 | 1.2854 | 1.2804 | 1.2809 | 6709808.0 |
| 2005-01-27 09:45:00 | AAPL | Stock | 1.2813 | 1.283 | 1.2777 | 1.2816 | 9735936.0 |
| 2005-01-27 09:50:00 | AAPL | Stock | 1.282 | 1.2852 | 1.2807 | 1.2838 | 11890816.0 |
| 2005-01-27 09:55:00 | AAPL | Stock | 1.2834 | 1.287 | 1.2813 | 1.2863 | 6508544.0 |
| 2005-01-27 10:00:00 | AAPL | Stock | 1.2866 | 1.29 | 1.2866 | 1.2875 | 14266952.0 |
| 2005-01-27 10:05:00 | AAPL | Stock | 1.2879 | 1.2914 | 1.2877 | 1.2895 | 8388632.0 |
| 2005-01-27 10:10:00 | AAPL | Stock | 1.2895 | 1.2898 | 1.2823 | 1.2848 | 10979416.0 |
| 2005-01-27 10:15:00 | AAPL | Stock | 1.2848 | 1.2848 | 1.2823 | 1.2836 | 5930064.0 |
| 2005-01-27 10:20:00 | AAPL | Stock | 1.2838 | 1.285 | 1.2823 | 1.2843 | 5250672.0 |
| 2005-01-27 10:25:00 | AAPL | Stock | 1.2843 | 1.2843 | 1.2821 | 1.283 | 4695656.0 |
| 2005-01-27 10:30:00 | AAPL | Stock | 1.2829 | 1.2854 | 1.2813 | 1.2848 | 10334072.0 |
| 2005-01-27 10:35:00 | AAPL | Stock | 1.2845 | 1.2877 | 1.2829 | 1.2864 | 5343240.0 |
| 2005-01-27 10:40:00 | AAPL | Stock | 1.2864 | 1.2884 | 1.2857 | 1.2859 | 8843128.0 |
| 2005-01-27 10:45:00 | AAPL | Stock | 1.2859 | 1.2864 | 1.2841 | 1.2852 | 6270600.0 |
| 2005-01-27 10:50:00 | AAPL | Stock | 1.2854 | 1.2891 | 1.2843 | 1.2884 | 8455944.0 |
| 2005-01-27 10:55:00 | AAPL | Stock | 1.2884 | 1.2902 | 1.288 | 1.2888 | 7194376.0 |
| 2005-01-27 11:00:00 | AAPL | Stock | 1.2889 | 1.2893 | 1.2871 | 1.2886 | 5918136.0 |
| 2005-01-27 11:05:00 | AAPL | Stock | 1.288 | 1.2911 | 1.2871 | 1.2909 | 7079520.0 |
| 2005-01-27 11:10:00 | AAPL | Stock | 1.2909 | 1.2923 | 1.2898 | 1.2904 | 10876096.0 |
| 2005-01-27 11:15:00 | AAPL | Stock | 1.2904 | 1.2909 | 1.2886 | 1.2902 | 5431720.0 |
| 2005-01-27 11:20:00 | AAPL | Stock | 1.2896 | 1.2907 | 1.2889 | 1.2898 | 4234832.0 |
| 2005-01-27 11:25:00 | AAPL | Stock | 1.2902 | 1.2904 | 1.2875 | 1.2891 | 5633712.0 |
| 2005-01-27 11:30:00 | AAPL | Stock | 1.2893 | 1.2907 | 1.2884 | 1.2907 | 6337856.0 |
| 2005-01-27 11:35:00 | AAPL | Stock | 1.2909 | 1.292 | 1.2893 | 1.292 | 5359480.0 |
| 2005-01-27 11:40:00 | AAPL | Stock | 1.2921 | 1.2988 | 1.292 | 1.2943 | 20498632.0 |
| 2005-01-27 11:45:00 | AAPL | Stock | 1.2943 | 1.2955 | 1.2929 | 1.2934 | 4873176.0 |
| 2005-01-27 11:50:00 | AAPL | Stock | 1.2936 | 1.2973 | 1.2927 | 1.2973 | 6219528.0 |
| 2005-01-27 11:55:00 | AAPL | Stock | 1.2973 | 1.3021 | 1.297 | 1.2979 | 16420264.0 |
| 2005-01-27 12:00:00 | AAPL | Stock | 1.2979 | 1.2991 | 1.2973 | 1.298 | 8988896.0 |
| 2005-01-27 12:05:00 | AAPL | Stock | 1.2984 | 1.3018 | 1.2946 | 1.2963 | 8900752.0 |
| 2005-01-27 12:10:00 | AAPL | Stock | 1.2963 | 1.2971 | 1.2948 | 1.2961 | 3297672.0 |
| 2005-01-27 12:15:00 | AAPL | Stock | 1.2955 | 1.2971 | 1.2954 | 1.2957 | 1747648.0 |
| 2005-01-27 12:20:00 | AAPL | Stock | 1.2957 | 1.297 | 1.2948 | 1.2952 | 2742992.0 |
> showing 50 of 187,816 rows — these rows as CSV