PREVIEW / stock_1min / 2007-06-13
file: by_date/stock_1min/2007/2007-06-13.parquet size: 11.0 MB rows: 906,948 symbols: 2,481
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-13 09:30:00 | AAPL | Stock | 4.3268 | 4.3282 | 4.2993 | 4.325 | 9273656.0 |
| 2007-06-13 09:31:00 | AAPL | Stock | 4.3254 | 4.3275 | 4.2993 | 4.3264 | 4539164.0 |
| 2007-06-13 09:32:00 | AAPL | Stock | 4.3011 | 4.3268 | 4.2993 | 4.315 | 8242388.0 |
| 2007-06-13 09:33:00 | AAPL | Stock | 4.3146 | 4.316 | 4.3011 | 4.3057 | 5609324.0 |
| 2007-06-13 09:34:00 | AAPL | Stock | 4.3054 | 4.3107 | 4.2954 | 4.3086 | 7262192.0 |
| 2007-06-13 09:35:00 | AAPL | Stock | 4.3086 | 4.3086 | 4.2632 | 4.3049 | 3123232.0 |
| 2007-06-13 09:36:00 | AAPL | Stock | 4.305 | 4.3168 | 4.2632 | 4.3139 | 3380468.0 |
| 2007-06-13 09:37:00 | AAPL | Stock | 4.3143 | 4.3193 | 4.2993 | 4.3164 | 2927904.0 |
| 2007-06-13 09:38:00 | AAPL | Stock | 4.3164 | 4.3164 | 4.3029 | 4.3029 | 7658308.0 |
| 2007-06-13 09:39:00 | AAPL | Stock | 4.3036 | 4.3089 | 4.2954 | 4.2961 | 4678996.0 |
| 2007-06-13 09:40:00 | AAPL | Stock | 4.2954 | 4.3068 | 4.2936 | 4.3032 | 4602528.0 |
| 2007-06-13 09:41:00 | AAPL | Stock | 4.3025 | 4.3071 | 4.2968 | 4.2982 | 3511172.0 |
| 2007-06-13 09:42:00 | AAPL | Stock | 4.2979 | 4.2979 | 4.2861 | 4.29 | 7851060.0 |
| 2007-06-13 09:43:00 | AAPL | Stock | 4.2904 | 4.2907 | 4.2829 | 4.29 | 6246548.0 |
| 2007-06-13 09:44:00 | AAPL | Stock | 4.2904 | 4.2964 | 4.2836 | 4.2889 | 5052656.0 |
| 2007-06-13 09:45:00 | AAPL | Stock | 4.2893 | 4.2981 | 4.2857 | 4.2939 | 3681832.0 |
| 2007-06-13 09:46:00 | AAPL | Stock | 4.2939 | 4.3 | 4.285 | 4.2871 | 5450732.0 |
| 2007-06-13 09:47:00 | AAPL | Stock | 4.2868 | 4.2945 | 4.2857 | 4.2921 | 3114272.0 |
| 2007-06-13 09:48:00 | AAPL | Stock | 4.2929 | 4.2939 | 4.2789 | 4.285 | 6551412.0 |
| 2007-06-13 09:49:00 | AAPL | Stock | 4.285 | 4.2889 | 4.2829 | 4.2879 | 2591512.0 |
| 2007-06-13 09:50:00 | AAPL | Stock | 4.2875 | 4.2932 | 4.2861 | 4.2918 | 3102820.0 |
| 2007-06-13 09:51:00 | AAPL | Stock | 4.2921 | 4.2975 | 4.2918 | 4.2921 | 2951564.0 |
| 2007-06-13 09:52:00 | AAPL | Stock | 4.2921 | 4.3257 | 4.2882 | 4.2925 | 3176572.0 |
| 2007-06-13 09:53:00 | AAPL | Stock | 4.2927 | 4.2977 | 4.29 | 4.2971 | 3484208.0 |
| 2007-06-13 09:54:00 | AAPL | Stock | 4.2975 | 4.3071 | 4.2975 | 4.3004 | 4882388.0 |
| 2007-06-13 09:55:00 | AAPL | Stock | 4.3007 | 4.3039 | 4.2971 | 4.3029 | 2080092.0 |
| 2007-06-13 09:56:00 | AAPL | Stock | 4.3014 | 4.3036 | 4.2946 | 4.2946 | 2500428.0 |
| 2007-06-13 09:57:00 | AAPL | Stock | 4.2946 | 4.2957 | 4.2857 | 4.2864 | 3714200.0 |
| 2007-06-13 09:58:00 | AAPL | Stock | 4.2871 | 4.2918 | 4.2861 | 4.2918 | 2103444.0 |
| 2007-06-13 09:59:00 | AAPL | Stock | 4.2914 | 4.2932 | 4.2868 | 4.2875 | 2654764.0 |
| 2007-06-13 10:00:00 | AAPL | Stock | 4.2871 | 4.2896 | 4.2825 | 4.2832 | 4145316.0 |
| 2007-06-13 10:01:00 | AAPL | Stock | 4.2834 | 4.2854 | 4.2768 | 4.2807 | 5200580.0 |
| 2007-06-13 10:02:00 | AAPL | Stock | 4.2811 | 4.2839 | 4.2786 | 4.2836 | 3206756.0 |
| 2007-06-13 10:03:00 | AAPL | Stock | 4.2829 | 4.2857 | 4.2821 | 4.2853 | 2119992.0 |
| 2007-06-13 10:04:00 | AAPL | Stock | 4.2852 | 4.2854 | 4.2786 | 4.2789 | 2770572.0 |
| 2007-06-13 10:05:00 | AAPL | Stock | 4.2789 | 4.285 | 4.2786 | 4.285 | 2981608.0 |
| 2007-06-13 10:06:00 | AAPL | Stock | 4.2847 | 4.2907 | 4.2839 | 4.2907 | 3141628.0 |
| 2007-06-13 10:07:00 | AAPL | Stock | 4.2904 | 4.2911 | 4.2861 | 4.2871 | 4321184.0 |
| 2007-06-13 10:08:00 | AAPL | Stock | 4.2868 | 4.2882 | 4.2793 | 4.2821 | 2227372.0 |
| 2007-06-13 10:09:00 | AAPL | Stock | 4.2821 | 4.2829 | 4.2754 | 4.2761 | 3267488.0 |
| 2007-06-13 10:10:00 | AAPL | Stock | 4.2766 | 4.2836 | 4.275 | 4.2807 | 3072356.0 |
| 2007-06-13 10:11:00 | AAPL | Stock | 4.2806 | 4.2806 | 4.2736 | 4.275 | 3896172.0 |
| 2007-06-13 10:12:00 | AAPL | Stock | 4.2743 | 4.2832 | 4.2739 | 4.2779 | 3651088.0 |
| 2007-06-13 10:13:00 | AAPL | Stock | 4.2786 | 4.2829 | 4.2779 | 4.2821 | 2346120.0 |
| 2007-06-13 10:14:00 | AAPL | Stock | 4.2818 | 4.2868 | 4.2811 | 4.2818 | 3592764.0 |
| 2007-06-13 10:15:00 | AAPL | Stock | 4.2821 | 4.2861 | 4.2818 | 4.2846 | 1770776.0 |
| 2007-06-13 10:16:00 | AAPL | Stock | 4.2854 | 4.2893 | 4.2839 | 4.2893 | 2948484.0 |
| 2007-06-13 10:17:00 | AAPL | Stock | 4.2889 | 4.2911 | 4.2861 | 4.2907 | 3048304.0 |
| 2007-06-13 10:18:00 | AAPL | Stock | 4.2907 | 4.2921 | 4.2886 | 4.2918 | 2567292.0 |
| 2007-06-13 10:19:00 | AAPL | Stock | 4.2918 | 4.2982 | 4.2904 | 4.295 | 3609228.0 |
> showing 50 of 906,948 rows — these rows as CSV