PREVIEW / stock_1min / 2002-07-11
file: by_date/stock_1min/2002/2002-07-11.parquet size: 4.8 MB rows: 370,854 symbols: 1,190
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-11 08:06:00 | AAPL | Stock | 0.3125 | 0.3125 | 0.3125 | 0.3125 | 16800.0 |
| 2002-07-11 08:42:00 | AAPL | Stock | 0.3107 | 0.3107 | 0.3098 | 0.3098 | 56000.0 |
| 2002-07-11 09:02:00 | AAPL | Stock | 0.3045 | 0.3045 | 0.3045 | 0.3045 | 11200.0 |
| 2002-07-11 09:19:00 | AAPL | Stock | 0.3071 | 0.3071 | 0.3071 | 0.3071 | 5600.0 |
| 2002-07-11 09:26:00 | AAPL | Stock | 0.3073 | 0.3073 | 0.3073 | 0.3073 | 22400.0 |
| 2002-07-11 09:27:00 | AAPL | Stock | 0.3098 | 0.3098 | 0.3098 | 0.3098 | 5600.0 |
| 2002-07-11 09:30:00 | AAPL | Stock | 0.3082 | 0.3082 | 0.3077 | 0.308 | 1965600.0 |
| 2002-07-11 09:31:00 | AAPL | Stock | 0.308 | 0.308 | 0.3071 | 0.3073 | 1293600.0 |
| 2002-07-11 09:32:00 | AAPL | Stock | 0.3073 | 0.3075 | 0.3052 | 0.3053 | 812000.0 |
| 2002-07-11 09:33:00 | AAPL | Stock | 0.3055 | 0.3071 | 0.3052 | 0.3055 | 761600.0 |
| 2002-07-11 09:34:00 | AAPL | Stock | 0.3052 | 0.3061 | 0.3048 | 0.3061 | 862400.0 |
| 2002-07-11 09:35:00 | AAPL | Stock | 0.3061 | 0.3079 | 0.3061 | 0.3071 | 812000.0 |
| 2002-07-11 09:36:00 | AAPL | Stock | 0.3071 | 0.3071 | 0.305 | 0.305 | 1181600.0 |
| 2002-07-11 09:37:00 | AAPL | Stock | 0.3052 | 0.307 | 0.305 | 0.3064 | 1136800.0 |
| 2002-07-11 09:38:00 | AAPL | Stock | 0.307 | 0.3079 | 0.3064 | 0.3066 | 1226400.0 |
| 2002-07-11 09:39:00 | AAPL | Stock | 0.3066 | 0.3075 | 0.3045 | 0.3046 | 1248800.0 |
| 2002-07-11 09:40:00 | AAPL | Stock | 0.3046 | 0.3054 | 0.3045 | 0.3054 | 593600.0 |
| 2002-07-11 09:41:00 | AAPL | Stock | 0.3055 | 0.3061 | 0.305 | 0.305 | 274400.0 |
| 2002-07-11 09:42:00 | AAPL | Stock | 0.3052 | 0.3052 | 0.3041 | 0.3045 | 750400.0 |
| 2002-07-11 09:43:00 | AAPL | Stock | 0.3048 | 0.3048 | 0.3048 | 0.3048 | 95200.0 |
| 2002-07-11 09:44:00 | AAPL | Stock | 0.3048 | 0.3057 | 0.3039 | 0.3039 | 296800.0 |
| 2002-07-11 09:45:00 | AAPL | Stock | 0.3039 | 0.3041 | 0.3039 | 0.3041 | 498400.0 |
| 2002-07-11 09:46:00 | AAPL | Stock | 0.3039 | 0.3041 | 0.3036 | 0.3036 | 2307200.0 |
| 2002-07-11 09:47:00 | AAPL | Stock | 0.3034 | 0.3038 | 0.303 | 0.3038 | 1808800.0 |
| 2002-07-11 09:48:00 | AAPL | Stock | 0.3038 | 0.3043 | 0.3034 | 0.3038 | 369600.0 |
| 2002-07-11 09:49:00 | AAPL | Stock | 0.3036 | 0.3048 | 0.3036 | 0.3048 | 257600.0 |
| 2002-07-11 09:50:00 | AAPL | Stock | 0.3043 | 0.305 | 0.3043 | 0.305 | 375200.0 |
| 2002-07-11 09:51:00 | AAPL | Stock | 0.3046 | 0.3063 | 0.3045 | 0.3063 | 1108800.0 |
| 2002-07-11 09:52:00 | AAPL | Stock | 0.3063 | 0.308 | 0.3062 | 0.308 | 840000.0 |
| 2002-07-11 09:53:00 | AAPL | Stock | 0.308 | 0.31 | 0.308 | 0.3093 | 1069600.0 |
| 2002-07-11 09:54:00 | AAPL | Stock | 0.3102 | 0.3105 | 0.3093 | 0.3104 | 940800.0 |
| 2002-07-11 09:55:00 | AAPL | Stock | 0.3104 | 0.3118 | 0.3098 | 0.3118 | 1646400.0 |
| 2002-07-11 09:56:00 | AAPL | Stock | 0.3118 | 0.3127 | 0.3118 | 0.3125 | 1461600.0 |
| 2002-07-11 09:57:00 | AAPL | Stock | 0.3125 | 0.3125 | 0.3116 | 0.3125 | 2150400.0 |
| 2002-07-11 09:58:00 | AAPL | Stock | 0.3125 | 0.3125 | 0.3116 | 0.3116 | 464800.0 |
| 2002-07-11 09:59:00 | AAPL | Stock | 0.3118 | 0.3127 | 0.3114 | 0.3116 | 918400.0 |
| 2002-07-11 10:00:00 | AAPL | Stock | 0.3114 | 0.3123 | 0.3111 | 0.3116 | 2111200.0 |
| 2002-07-11 10:01:00 | AAPL | Stock | 0.3111 | 0.3146 | 0.3111 | 0.3145 | 1461600.0 |
| 2002-07-11 10:02:00 | AAPL | Stock | 0.3143 | 0.3164 | 0.3141 | 0.3159 | 2122400.0 |
| 2002-07-11 10:03:00 | AAPL | Stock | 0.3164 | 0.3175 | 0.3161 | 0.3173 | 1500800.0 |
| 2002-07-11 10:04:00 | AAPL | Stock | 0.3175 | 0.3184 | 0.3171 | 0.3173 | 1103200.0 |
| 2002-07-11 10:05:00 | AAPL | Stock | 0.318 | 0.318 | 0.3154 | 0.3155 | 1153600.0 |
| 2002-07-11 10:06:00 | AAPL | Stock | 0.3152 | 0.3159 | 0.3136 | 0.3146 | 2167200.0 |
| 2002-07-11 10:07:00 | AAPL | Stock | 0.3146 | 0.3161 | 0.3146 | 0.3152 | 481600.0 |
| 2002-07-11 10:08:00 | AAPL | Stock | 0.3157 | 0.3161 | 0.3145 | 0.315 | 1254400.0 |
| 2002-07-11 10:09:00 | AAPL | Stock | 0.3163 | 0.3166 | 0.3145 | 0.3146 | 996800.0 |
| 2002-07-11 10:10:00 | AAPL | Stock | 0.3146 | 0.3155 | 0.3143 | 0.3143 | 845600.0 |
| 2002-07-11 10:11:00 | AAPL | Stock | 0.3146 | 0.3148 | 0.3141 | 0.3148 | 924000.0 |
| 2002-07-11 10:12:00 | AAPL | Stock | 0.3141 | 0.3157 | 0.3141 | 0.3146 | 1024800.0 |
| 2002-07-11 10:13:00 | AAPL | Stock | 0.3148 | 0.3155 | 0.3146 | 0.3155 | 649600.0 |
> showing 50 of 370,854 rows — these rows as CSV