PREVIEW / stock_5min / 2005-01-26
file: by_date/stock_5min/2005/2005-01-26.parquet size: 2.6 MB rows: 187,346 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-26 08:00:00 | AAPL | Stock | 1.2945 | 1.2964 | 1.2945 | 1.2964 | 165480.0 |
| 2005-01-26 08:05:00 | AAPL | Stock | 1.297 | 1.2973 | 1.2955 | 1.2959 | 341600.0 |
| 2005-01-26 08:10:00 | AAPL | Stock | 1.2959 | 1.2964 | 1.2946 | 1.2955 | 520240.0 |
| 2005-01-26 08:15:00 | AAPL | Stock | 1.2955 | 1.2955 | 1.2946 | 1.2946 | 76048.0 |
| 2005-01-26 08:20:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 5600.0 |
| 2005-01-26 08:25:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 40880.0 |
| 2005-01-26 08:30:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.292 | 1.292 | 65520.0 |
| 2005-01-26 08:35:00 | AAPL | Stock | 1.2929 | 1.2941 | 1.2929 | 1.2938 | 16800.0 |
| 2005-01-26 08:40:00 | AAPL | Stock | 1.2929 | 1.2929 | 1.2916 | 1.2918 | 360080.0 |
| 2005-01-26 08:45:00 | AAPL | Stock | 1.2916 | 1.2918 | 1.2916 | 1.2918 | 39200.0 |
| 2005-01-26 08:50:00 | AAPL | Stock | 1.2918 | 1.2946 | 1.2918 | 1.2921 | 125440.0 |
| 2005-01-26 08:55:00 | AAPL | Stock | 1.2923 | 1.2923 | 1.2923 | 1.2923 | 5600.0 |
| 2005-01-26 09:00:00 | AAPL | Stock | 1.2929 | 1.2929 | 1.2923 | 1.2923 | 112000.0 |
| 2005-01-26 09:05:00 | AAPL | Stock | 1.2932 | 1.2964 | 1.2932 | 1.2964 | 688128.0 |
| 2005-01-26 09:10:00 | AAPL | Stock | 1.2963 | 1.2964 | 1.2963 | 1.2964 | 228368.0 |
| 2005-01-26 09:15:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 93968.0 |
| 2005-01-26 09:20:00 | AAPL | Stock | 1.2955 | 1.2955 | 1.2955 | 1.2955 | 11200.0 |
| 2005-01-26 09:25:00 | AAPL | Stock | 1.2955 | 1.3004 | 1.2905 | 1.2998 | 1649536.0 |
| 2005-01-26 09:30:00 | AAPL | Stock | 1.2979 | 1.2991 | 1.2921 | 1.2925 | 27356280.0 |
| 2005-01-26 09:35:00 | AAPL | Stock | 1.2927 | 1.2941 | 1.2871 | 1.2923 | 13477912.0 |
| 2005-01-26 09:40:00 | AAPL | Stock | 1.2925 | 1.2934 | 1.2884 | 1.2905 | 9523136.0 |
| 2005-01-26 09:45:00 | AAPL | Stock | 1.2904 | 1.292 | 1.2891 | 1.2891 | 6625024.0 |
| 2005-01-26 09:50:00 | AAPL | Stock | 1.2891 | 1.2914 | 1.2846 | 1.2852 | 16189152.0 |
| 2005-01-26 09:55:00 | AAPL | Stock | 1.2859 | 1.2871 | 1.2777 | 1.2807 | 24370136.0 |
| 2005-01-26 10:00:00 | AAPL | Stock | 1.2805 | 1.2854 | 1.2795 | 1.2845 | 25529728.0 |
| 2005-01-26 10:05:00 | AAPL | Stock | 1.2845 | 1.2882 | 1.2827 | 1.287 | 14762888.0 |
| 2005-01-26 10:10:00 | AAPL | Stock | 1.2868 | 1.2877 | 1.278 | 1.2786 | 15316952.0 |
| 2005-01-26 10:15:00 | AAPL | Stock | 1.2788 | 1.283 | 1.2786 | 1.2804 | 13111056.0 |
| 2005-01-26 10:20:00 | AAPL | Stock | 1.28 | 1.2811 | 1.2752 | 1.2761 | 15202320.0 |
| 2005-01-26 10:25:00 | AAPL | Stock | 1.2761 | 1.2786 | 1.2745 | 1.2775 | 13273232.0 |
| 2005-01-26 10:30:00 | AAPL | Stock | 1.2775 | 1.2786 | 1.2718 | 1.275 | 23209928.0 |
| 2005-01-26 10:35:00 | AAPL | Stock | 1.275 | 1.2761 | 1.2721 | 1.2759 | 19199936.0 |
| 2005-01-26 10:40:00 | AAPL | Stock | 1.2759 | 1.2813 | 1.2757 | 1.2802 | 12551168.0 |
| 2005-01-26 10:45:00 | AAPL | Stock | 1.28 | 1.2811 | 1.2791 | 1.2795 | 5459216.0 |
| 2005-01-26 10:50:00 | AAPL | Stock | 1.2795 | 1.2852 | 1.2793 | 1.285 | 12687808.0 |
| 2005-01-26 10:55:00 | AAPL | Stock | 1.285 | 1.292 | 1.285 | 1.2882 | 24362576.0 |
| 2005-01-26 11:00:00 | AAPL | Stock | 1.2886 | 1.2964 | 1.2875 | 1.2952 | 23099832.0 |
| 2005-01-26 11:05:00 | AAPL | Stock | 1.2952 | 1.2952 | 1.2875 | 1.2889 | 12598768.0 |
| 2005-01-26 11:10:00 | AAPL | Stock | 1.2893 | 1.29 | 1.2854 | 1.2888 | 13740328.0 |
| 2005-01-26 11:15:00 | AAPL | Stock | 1.2891 | 1.2891 | 1.2838 | 1.2859 | 9814784.0 |
| 2005-01-26 11:20:00 | AAPL | Stock | 1.2868 | 1.287 | 1.2795 | 1.2823 | 10752672.0 |
| 2005-01-26 11:25:00 | AAPL | Stock | 1.2825 | 1.2855 | 1.2821 | 1.2838 | 11735752.0 |
| 2005-01-26 11:30:00 | AAPL | Stock | 1.2838 | 1.2882 | 1.2838 | 1.2864 | 13606488.0 |
| 2005-01-26 11:35:00 | AAPL | Stock | 1.2864 | 1.2864 | 1.2821 | 1.2823 | 17590888.0 |
| 2005-01-26 11:40:00 | AAPL | Stock | 1.2823 | 1.2889 | 1.282 | 1.2879 | 10724504.0 |
| 2005-01-26 11:45:00 | AAPL | Stock | 1.2879 | 1.2891 | 1.2852 | 1.287 | 9336040.0 |
| 2005-01-26 11:50:00 | AAPL | Stock | 1.2866 | 1.2946 | 1.283 | 1.2855 | 6235824.0 |
| 2005-01-26 11:55:00 | AAPL | Stock | 1.2859 | 1.29 | 1.283 | 1.2866 | 6630008.0 |
| 2005-01-26 12:00:00 | AAPL | Stock | 1.2866 | 1.29 | 1.2863 | 1.2882 | 5753440.0 |
| 2005-01-26 12:05:00 | AAPL | Stock | 1.2884 | 1.2909 | 1.2875 | 1.2909 | 4864216.0 |
> showing 50 of 187,346 rows — these rows as CSV