PREVIEW / stock_1min / 2007-06-27
file: by_date/stock_1min/2007/2007-06-27.parquet size: 11.5 MB rows: 940,852 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-27 09:30:00 | AAPL | Stock | 4.3075 | 4.31 | 4.2746 | 4.2814 | 13437536.0 |
| 2007-06-27 09:31:00 | AAPL | Stock | 4.2814 | 4.3043 | 4.2751 | 4.2939 | 6360172.0 |
| 2007-06-27 09:32:00 | AAPL | Stock | 4.2936 | 4.2957 | 4.2804 | 4.2852 | 4722788.0 |
| 2007-06-27 09:33:00 | AAPL | Stock | 4.2854 | 4.2876 | 4.2814 | 4.2825 | 4793460.0 |
| 2007-06-27 09:34:00 | AAPL | Stock | 4.2825 | 4.2861 | 4.2821 | 4.2857 | 4329360.0 |
| 2007-06-27 09:35:00 | AAPL | Stock | 4.2857 | 4.3018 | 4.2843 | 4.2982 | 9791096.0 |
| 2007-06-27 09:36:00 | AAPL | Stock | 4.2986 | 4.3107 | 4.2982 | 4.3093 | 7521192.0 |
| 2007-06-27 09:37:00 | AAPL | Stock | 4.3093 | 4.3161 | 4.3004 | 4.3111 | 7580776.0 |
| 2007-06-27 09:38:00 | AAPL | Stock | 4.3104 | 4.3154 | 4.3036 | 4.3127 | 6529600.0 |
| 2007-06-27 09:39:00 | AAPL | Stock | 4.3125 | 4.3136 | 4.3061 | 4.3064 | 5356568.0 |
| 2007-06-27 09:40:00 | AAPL | Stock | 4.3057 | 4.3132 | 4.3 | 4.3093 | 4699828.0 |
| 2007-06-27 09:41:00 | AAPL | Stock | 4.3089 | 4.3154 | 4.3054 | 4.3136 | 5714548.0 |
| 2007-06-27 09:42:00 | AAPL | Stock | 4.3129 | 4.3214 | 4.3125 | 4.3204 | 9626344.0 |
| 2007-06-27 09:43:00 | AAPL | Stock | 4.3207 | 4.3243 | 4.3132 | 4.3157 | 6331668.0 |
| 2007-06-27 09:44:00 | AAPL | Stock | 4.315 | 4.3196 | 4.3107 | 4.3107 | 3199672.0 |
| 2007-06-27 09:45:00 | AAPL | Stock | 4.3114 | 4.3164 | 4.3107 | 4.3154 | 3298960.0 |
| 2007-06-27 09:46:00 | AAPL | Stock | 4.315 | 4.3161 | 4.3132 | 4.3146 | 3839472.0 |
| 2007-06-27 09:47:00 | AAPL | Stock | 4.315 | 4.3204 | 4.3146 | 4.3179 | 3822308.0 |
| 2007-06-27 09:48:00 | AAPL | Stock | 4.3179 | 4.3214 | 4.3161 | 4.3207 | 3137960.0 |
| 2007-06-27 09:49:00 | AAPL | Stock | 4.3207 | 4.3229 | 4.3157 | 4.3189 | 5003124.0 |
| 2007-06-27 09:50:00 | AAPL | Stock | 4.3189 | 4.3286 | 4.3164 | 4.3275 | 7689444.0 |
| 2007-06-27 09:51:00 | AAPL | Stock | 4.3279 | 4.3357 | 4.3275 | 4.3325 | 4421676.0 |
| 2007-06-27 09:52:00 | AAPL | Stock | 4.3325 | 4.3375 | 4.3318 | 4.3343 | 4194204.0 |
| 2007-06-27 09:53:00 | AAPL | Stock | 4.3343 | 4.3357 | 4.3289 | 4.3304 | 4036788.0 |
| 2007-06-27 09:54:00 | AAPL | Stock | 4.3318 | 4.3329 | 4.3275 | 4.3293 | 4338936.0 |
| 2007-06-27 09:55:00 | AAPL | Stock | 4.3293 | 4.3314 | 4.3257 | 4.3304 | 2755956.0 |
| 2007-06-27 09:56:00 | AAPL | Stock | 4.3304 | 4.3311 | 4.3221 | 4.3232 | 3106628.0 |
| 2007-06-27 09:57:00 | AAPL | Stock | 4.3232 | 4.3275 | 4.3214 | 4.3214 | 4991112.0 |
| 2007-06-27 09:58:00 | AAPL | Stock | 4.3218 | 4.3236 | 4.3079 | 4.3127 | 8239952.0 |
| 2007-06-27 09:59:00 | AAPL | Stock | 4.3125 | 4.3139 | 4.3007 | 4.305 | 6144852.0 |
| 2007-06-27 10:00:00 | AAPL | Stock | 4.3046 | 4.3061 | 4.2946 | 4.2954 | 4920356.0 |
| 2007-06-27 10:01:00 | AAPL | Stock | 4.295 | 4.3029 | 4.2918 | 4.2968 | 5247704.0 |
| 2007-06-27 10:02:00 | AAPL | Stock | 4.2968 | 4.3036 | 4.2964 | 4.3014 | 2909648.0 |
| 2007-06-27 10:03:00 | AAPL | Stock | 4.3018 | 4.3071 | 4.3007 | 4.3046 | 2683156.0 |
| 2007-06-27 10:04:00 | AAPL | Stock | 4.3041 | 4.3054 | 4.3007 | 4.3014 | 1856876.0 |
| 2007-06-27 10:05:00 | AAPL | Stock | 4.3011 | 4.3121 | 4.2968 | 4.3057 | 4457012.0 |
| 2007-06-27 10:06:00 | AAPL | Stock | 4.3064 | 4.3118 | 4.3011 | 4.305 | 3325028.0 |
| 2007-06-27 10:07:00 | AAPL | Stock | 4.3046 | 4.3057 | 4.2968 | 4.2982 | 2138388.0 |
| 2007-06-27 10:08:00 | AAPL | Stock | 4.2982 | 4.3057 | 4.2982 | 4.3057 | 2946356.0 |
| 2007-06-27 10:09:00 | AAPL | Stock | 4.3061 | 4.3068 | 4.2936 | 4.2996 | 4975684.0 |
| 2007-06-27 10:10:00 | AAPL | Stock | 4.3 | 4.3018 | 4.2911 | 4.2936 | 3962952.0 |
| 2007-06-27 10:11:00 | AAPL | Stock | 4.2932 | 4.2954 | 4.2786 | 4.2804 | 5985980.0 |
| 2007-06-27 10:12:00 | AAPL | Stock | 4.2811 | 4.2889 | 4.2789 | 4.2864 | 4432260.0 |
| 2007-06-27 10:13:00 | AAPL | Stock | 4.2864 | 4.2868 | 4.2732 | 4.2779 | 5932752.0 |
| 2007-06-27 10:14:00 | AAPL | Stock | 4.2782 | 4.285 | 4.275 | 4.2793 | 3679788.0 |
| 2007-06-27 10:15:00 | AAPL | Stock | 4.2793 | 4.285 | 4.2704 | 4.2821 | 5814144.0 |
| 2007-06-27 10:16:00 | AAPL | Stock | 4.2818 | 4.2907 | 4.2811 | 4.2846 | 3529820.0 |
| 2007-06-27 10:17:00 | AAPL | Stock | 4.285 | 4.2861 | 4.28 | 4.2857 | 3075436.0 |
| 2007-06-27 10:18:00 | AAPL | Stock | 4.2864 | 4.2882 | 4.2789 | 4.2789 | 4421284.0 |
| 2007-06-27 10:19:00 | AAPL | Stock | 4.2786 | 4.285 | 4.2729 | 4.2746 | 3142748.0 |
> showing 50 of 940,852 rows — these rows as CSV