PREVIEW / stock_5min / 2006-05-23
file: by_date/stock_5min/2006/2006-05-23.parquet size: 3.2 MB rows: 229,834 symbols: 2,268
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-23 05:40:00 | AAPL | Stock | 2.2696 | 2.2696 | 2.2696 | 2.2696 | 2800.0 |
| 2006-05-23 07:05:00 | AAPL | Stock | 2.2696 | 2.2696 | 2.2696 | 2.2696 | 2800.0 |
| 2006-05-23 07:20:00 | AAPL | Stock | 2.2714 | 2.2768 | 2.2714 | 2.2768 | 50400.0 |
| 2006-05-23 07:30:00 | AAPL | Stock | 2.2782 | 2.2804 | 2.2782 | 2.2804 | 47600.0 |
| 2006-05-23 07:45:00 | AAPL | Stock | 2.28 | 2.2818 | 2.28 | 2.2818 | 8932.0 |
| 2006-05-23 07:50:00 | AAPL | Stock | 2.2786 | 2.2786 | 2.2786 | 2.2786 | 12852.0 |
| 2006-05-23 07:55:00 | AAPL | Stock | 2.2786 | 2.2786 | 2.2786 | 2.2786 | 2800.0 |
| 2006-05-23 08:00:00 | AAPL | Stock | 2.2821 | 2.2821 | 2.2768 | 2.2793 | 198044.0 |
| 2006-05-23 08:05:00 | AAPL | Stock | 2.2807 | 2.2879 | 2.2807 | 2.2879 | 250544.0 |
| 2006-05-23 08:10:00 | AAPL | Stock | 2.2871 | 2.2896 | 2.2857 | 2.2889 | 231140.0 |
| 2006-05-23 08:15:00 | AAPL | Stock | 2.2893 | 2.2893 | 2.2875 | 2.2879 | 220780.0 |
| 2006-05-23 08:20:00 | AAPL | Stock | 2.2886 | 2.2886 | 2.2857 | 2.2857 | 189840.0 |
| 2006-05-23 08:25:00 | AAPL | Stock | 2.2868 | 2.2868 | 2.2857 | 2.2857 | 16800.0 |
| 2006-05-23 08:30:00 | AAPL | Stock | 2.2857 | 2.2871 | 2.2857 | 2.2871 | 72240.0 |
| 2006-05-23 08:35:00 | AAPL | Stock | 2.2861 | 2.2868 | 2.2857 | 2.2868 | 75880.0 |
| 2006-05-23 08:40:00 | AAPL | Stock | 2.2864 | 2.2864 | 2.2864 | 2.2864 | 11200.0 |
| 2006-05-23 08:45:00 | AAPL | Stock | 2.2857 | 2.2864 | 2.2857 | 2.2857 | 33600.0 |
| 2006-05-23 08:50:00 | AAPL | Stock | 2.2857 | 2.2864 | 2.2854 | 2.2857 | 72184.0 |
| 2006-05-23 08:55:00 | AAPL | Stock | 2.2857 | 2.2857 | 2.2857 | 2.2857 | 14000.0 |
| 2006-05-23 09:00:00 | AAPL | Stock | 2.2857 | 2.2864 | 2.2854 | 2.2854 | 64400.0 |
| 2006-05-23 09:05:00 | AAPL | Stock | 2.2854 | 2.2864 | 2.2854 | 2.2857 | 51912.0 |
| 2006-05-23 09:10:00 | AAPL | Stock | 2.2875 | 2.2911 | 2.2857 | 2.2911 | 952140.0 |
| 2006-05-23 09:15:00 | AAPL | Stock | 2.2893 | 2.2982 | 2.2893 | 2.2968 | 2034340.0 |
| 2006-05-23 09:20:00 | AAPL | Stock | 2.295 | 2.3054 | 2.2929 | 2.3036 | 1355480.0 |
| 2006-05-23 09:25:00 | AAPL | Stock | 2.3036 | 2.3225 | 2.2996 | 2.3164 | 4138848.0 |
| 2006-05-23 09:30:00 | AAPL | Stock | 2.3164 | 2.3282 | 2.3071 | 2.3111 | 38570616.0 |
| 2006-05-23 09:35:00 | AAPL | Stock | 2.3114 | 2.3161 | 2.2939 | 2.3 | 31079076.0 |
| 2006-05-23 09:40:00 | AAPL | Stock | 2.2996 | 2.3054 | 2.2961 | 2.3054 | 16788072.0 |
| 2006-05-23 09:45:00 | AAPL | Stock | 2.3054 | 2.3064 | 2.2929 | 2.2932 | 13415976.0 |
| 2006-05-23 09:50:00 | AAPL | Stock | 2.2936 | 2.2943 | 2.2868 | 2.2911 | 17534020.0 |
| 2006-05-23 09:55:00 | AAPL | Stock | 2.2914 | 2.2986 | 2.2879 | 2.2971 | 14754208.0 |
| 2006-05-23 10:00:00 | AAPL | Stock | 2.2971 | 2.2971 | 2.2893 | 2.2907 | 10471608.0 |
| 2006-05-23 10:05:00 | AAPL | Stock | 2.2904 | 2.2993 | 2.2904 | 2.2929 | 11799844.0 |
| 2006-05-23 10:10:00 | AAPL | Stock | 2.2946 | 2.2957 | 2.2839 | 2.2921 | 17437056.0 |
| 2006-05-23 10:15:00 | AAPL | Stock | 2.2914 | 2.2921 | 2.2761 | 2.2807 | 19000268.0 |
| 2006-05-23 10:20:00 | AAPL | Stock | 2.2807 | 2.2871 | 2.2746 | 2.2864 | 11269076.0 |
| 2006-05-23 10:25:00 | AAPL | Stock | 2.2854 | 2.2861 | 2.2718 | 2.2749 | 12217240.0 |
| 2006-05-23 10:30:00 | AAPL | Stock | 2.2739 | 2.3164 | 2.2718 | 2.2868 | 16232804.0 |
| 2006-05-23 10:35:00 | AAPL | Stock | 2.2868 | 2.2914 | 2.285 | 2.29 | 15902180.0 |
| 2006-05-23 10:40:00 | AAPL | Stock | 2.29 | 2.2936 | 2.2861 | 2.2896 | 18978624.0 |
| 2006-05-23 10:45:00 | AAPL | Stock | 2.29 | 2.2946 | 2.2879 | 2.2918 | 9328312.0 |
| 2006-05-23 10:50:00 | AAPL | Stock | 2.2914 | 2.3 | 2.2907 | 2.3 | 11281256.0 |
| 2006-05-23 10:55:00 | AAPL | Stock | 2.2996 | 2.3011 | 2.2939 | 2.2979 | 11724076.0 |
| 2006-05-23 11:00:00 | AAPL | Stock | 2.2979 | 2.2989 | 2.2943 | 2.2981 | 5543244.0 |
| 2006-05-23 11:05:00 | AAPL | Stock | 2.2975 | 2.2982 | 2.2854 | 2.2864 | 9156056.0 |
| 2006-05-23 11:10:00 | AAPL | Stock | 2.2864 | 2.2932 | 2.2821 | 2.2918 | 11319812.0 |
| 2006-05-23 11:15:00 | AAPL | Stock | 2.2921 | 2.2971 | 2.2875 | 2.2939 | 9618840.0 |
| 2006-05-23 11:20:00 | AAPL | Stock | 2.2939 | 2.2939 | 2.2889 | 2.2907 | 5839876.0 |
| 2006-05-23 11:25:00 | AAPL | Stock | 2.2904 | 2.2907 | 2.2829 | 2.2854 | 9068164.0 |
| 2006-05-23 11:30:00 | AAPL | Stock | 2.2861 | 2.2893 | 2.2832 | 2.2879 | 3692920.0 |
> showing 50 of 229,834 rows — these rows as CSV