PREVIEW / stock_1min / 2007-06-04
file: by_date/stock_1min/2007/2007-06-04.parquet size: 11.0 MB rows: 909,556 symbols: 2,499
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-04 09:30:00 | AAPL | Stock | 4.2368 | 4.2411 | 4.2354 | 4.24 | 7114968.0 |
| 2007-06-04 09:31:00 | AAPL | Stock | 4.2389 | 4.2411 | 4.2107 | 4.2125 | 7637896.0 |
| 2007-06-04 09:32:00 | AAPL | Stock | 4.2121 | 4.224 | 4.2107 | 4.2136 | 6256096.0 |
| 2007-06-04 09:33:00 | AAPL | Stock | 4.2136 | 4.2211 | 4.2114 | 4.2193 | 3430084.0 |
| 2007-06-04 09:34:00 | AAPL | Stock | 4.22 | 4.2271 | 4.2161 | 4.2236 | 4488344.0 |
| 2007-06-04 09:35:00 | AAPL | Stock | 4.2243 | 4.2389 | 4.2232 | 4.2368 | 4234664.0 |
| 2007-06-04 09:36:00 | AAPL | Stock | 4.2371 | 4.2493 | 4.2336 | 4.2482 | 6001464.0 |
| 2007-06-04 09:37:00 | AAPL | Stock | 4.2479 | 4.2639 | 4.2439 | 4.2625 | 7595644.0 |
| 2007-06-04 09:38:00 | AAPL | Stock | 4.2618 | 4.2639 | 4.2543 | 4.2568 | 6243160.0 |
| 2007-06-04 09:39:00 | AAPL | Stock | 4.2571 | 4.2571 | 4.2504 | 4.2546 | 3981264.0 |
| 2007-06-04 09:40:00 | AAPL | Stock | 4.2546 | 4.2679 | 4.2543 | 4.2639 | 6801480.0 |
| 2007-06-04 09:41:00 | AAPL | Stock | 4.2636 | 4.2786 | 4.2621 | 4.2771 | 6355804.0 |
| 2007-06-04 09:42:00 | AAPL | Stock | 4.2771 | 4.2821 | 4.2757 | 4.2803 | 7628796.0 |
| 2007-06-04 09:43:00 | AAPL | Stock | 4.2804 | 4.2804 | 4.2507 | 4.2729 | 7471016.0 |
| 2007-06-04 09:44:00 | AAPL | Stock | 4.2736 | 4.2771 | 4.2689 | 4.2693 | 4010272.0 |
| 2007-06-04 09:45:00 | AAPL | Stock | 4.2689 | 4.2732 | 4.2689 | 4.2718 | 3018484.0 |
| 2007-06-04 09:46:00 | AAPL | Stock | 4.2725 | 4.275 | 4.2657 | 4.2711 | 4201400.0 |
| 2007-06-04 09:47:00 | AAPL | Stock | 4.2704 | 4.2761 | 4.2682 | 4.2718 | 3536316.0 |
| 2007-06-04 09:48:00 | AAPL | Stock | 4.2725 | 4.2829 | 4.2686 | 4.2829 | 4328576.0 |
| 2007-06-04 09:49:00 | AAPL | Stock | 4.2825 | 4.2957 | 4.2817 | 4.295 | 9813692.0 |
| 2007-06-04 09:50:00 | AAPL | Stock | 4.2936 | 4.3039 | 4.2936 | 4.3025 | 8673028.0 |
| 2007-06-04 09:51:00 | AAPL | Stock | 4.3021 | 4.3089 | 4.2989 | 4.3004 | 7077112.0 |
| 2007-06-04 09:52:00 | AAPL | Stock | 4.3 | 4.3021 | 4.295 | 4.2982 | 4256784.0 |
| 2007-06-04 09:53:00 | AAPL | Stock | 4.2982 | 4.2982 | 4.2911 | 4.2918 | 3097920.0 |
| 2007-06-04 09:54:00 | AAPL | Stock | 4.2914 | 4.2936 | 4.2818 | 4.2829 | 5247368.0 |
| 2007-06-04 09:55:00 | AAPL | Stock | 4.2832 | 4.2864 | 4.2811 | 4.2825 | 4620224.0 |
| 2007-06-04 09:56:00 | AAPL | Stock | 4.2818 | 4.2857 | 4.2786 | 4.2811 | 2988832.0 |
| 2007-06-04 09:57:00 | AAPL | Stock | 4.2814 | 4.2836 | 4.2771 | 4.2825 | 3125864.0 |
| 2007-06-04 09:58:00 | AAPL | Stock | 4.2829 | 4.2925 | 4.2814 | 4.2907 | 4299988.0 |
| 2007-06-04 09:59:00 | AAPL | Stock | 4.29 | 4.3014 | 4.29 | 4.2989 | 4618628.0 |
| 2007-06-04 10:00:00 | AAPL | Stock | 4.2993 | 4.2996 | 4.2893 | 4.2932 | 4854080.0 |
| 2007-06-04 10:01:00 | AAPL | Stock | 4.2932 | 4.2964 | 4.2875 | 4.2879 | 2420096.0 |
| 2007-06-04 10:02:00 | AAPL | Stock | 4.2882 | 4.2921 | 4.2814 | 4.2868 | 3443664.0 |
| 2007-06-04 10:03:00 | AAPL | Stock | 4.2868 | 4.2914 | 4.2807 | 4.2809 | 3021844.0 |
| 2007-06-04 10:04:00 | AAPL | Stock | 4.2811 | 4.2911 | 4.2804 | 4.2911 | 2365776.0 |
| 2007-06-04 10:05:00 | AAPL | Stock | 4.2918 | 4.2925 | 4.2846 | 4.2904 | 3742452.0 |
| 2007-06-04 10:06:00 | AAPL | Stock | 4.2904 | 4.2964 | 4.2886 | 4.2964 | 2490012.0 |
| 2007-06-04 10:07:00 | AAPL | Stock | 4.2971 | 4.3032 | 4.2964 | 4.2986 | 7061404.0 |
| 2007-06-04 10:08:00 | AAPL | Stock | 4.2989 | 4.3021 | 4.2943 | 4.2964 | 3397380.0 |
| 2007-06-04 10:09:00 | AAPL | Stock | 4.2968 | 4.3032 | 4.2954 | 4.2971 | 4545156.0 |
| 2007-06-04 10:10:00 | AAPL | Stock | 4.2964 | 4.3089 | 4.2964 | 4.3071 | 7697228.0 |
| 2007-06-04 10:11:00 | AAPL | Stock | 4.3079 | 4.3114 | 4.3021 | 4.3068 | 8477896.0 |
| 2007-06-04 10:12:00 | AAPL | Stock | 4.3086 | 4.3171 | 4.3068 | 4.3164 | 7638764.0 |
| 2007-06-04 10:13:00 | AAPL | Stock | 4.3164 | 4.3232 | 4.3157 | 4.3214 | 10201212.0 |
| 2007-06-04 10:14:00 | AAPL | Stock | 4.3214 | 4.3264 | 4.3193 | 4.3196 | 7193648.0 |
| 2007-06-04 10:15:00 | AAPL | Stock | 4.3196 | 4.3232 | 4.3161 | 4.3232 | 5230456.0 |
| 2007-06-04 10:16:00 | AAPL | Stock | 4.3232 | 4.3271 | 4.3196 | 4.3214 | 4534572.0 |
| 2007-06-04 10:17:00 | AAPL | Stock | 4.3214 | 4.3221 | 4.3154 | 4.3179 | 3119088.0 |
| 2007-06-04 10:18:00 | AAPL | Stock | 4.3193 | 4.3193 | 4.3146 | 4.3161 | 1860656.0 |
| 2007-06-04 10:19:00 | AAPL | Stock | 4.3164 | 4.3211 | 4.3143 | 4.3186 | 3609228.0 |
> showing 50 of 909,556 rows — these rows as CSV