PREVIEW / stock_1min / 2002-07-01
file: by_date/stock_1min/2002/2002-07-01.parquet size: 4.8 MB rows: 382,230 symbols: 1,191
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-01 08:01:00 | AAPL | Stock | 0.3143 | 0.3143 | 0.3105 | 0.3143 | 33600.0 |
| 2002-07-01 08:02:00 | AAPL | Stock | 0.3141 | 0.3141 | 0.3141 | 0.3141 | 44800.0 |
| 2002-07-01 08:05:00 | AAPL | Stock | 0.3155 | 0.3155 | 0.3155 | 0.3155 | 33600.0 |
| 2002-07-01 08:07:00 | AAPL | Stock | 0.3159 | 0.3159 | 0.3159 | 0.3159 | 5600.0 |
| 2002-07-01 08:11:00 | AAPL | Stock | 0.3143 | 0.3143 | 0.3143 | 0.3143 | 56000.0 |
| 2002-07-01 08:15:00 | AAPL | Stock | 0.3152 | 0.3152 | 0.3143 | 0.3143 | 28000.0 |
| 2002-07-01 08:17:00 | AAPL | Stock | 0.3143 | 0.3143 | 0.3143 | 0.3143 | 5600.0 |
| 2002-07-01 08:26:00 | AAPL | Stock | 0.3143 | 0.3143 | 0.3143 | 0.3143 | 56000.0 |
| 2002-07-01 08:30:00 | AAPL | Stock | 0.3152 | 0.3161 | 0.3152 | 0.3161 | 347200.0 |
| 2002-07-01 08:31:00 | AAPL | Stock | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 112000.0 |
| 2002-07-01 08:32:00 | AAPL | Stock | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 117600.0 |
| 2002-07-01 08:34:00 | AAPL | Stock | 0.3143 | 0.3143 | 0.3143 | 0.3143 | 72800.0 |
| 2002-07-01 08:41:00 | AAPL | Stock | 0.3152 | 0.3152 | 0.3152 | 0.3152 | 280000.0 |
| 2002-07-01 08:52:00 | AAPL | Stock | 0.3164 | 0.3164 | 0.3164 | 0.3164 | 744800.0 |
| 2002-07-01 08:54:00 | AAPL | Stock | 0.315 | 0.315 | 0.315 | 0.315 | 50400.0 |
| 2002-07-01 08:59:00 | AAPL | Stock | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 11200.0 |
| 2002-07-01 09:04:00 | AAPL | Stock | 0.3164 | 0.3164 | 0.3164 | 0.3164 | 616000.0 |
| 2002-07-01 09:06:00 | AAPL | Stock | 0.3166 | 0.3166 | 0.3161 | 0.3161 | 95200.0 |
| 2002-07-01 09:09:00 | AAPL | Stock | 0.3164 | 0.3164 | 0.3164 | 0.3164 | 2128000.0 |
| 2002-07-01 09:11:00 | AAPL | Stock | 0.317 | 0.317 | 0.317 | 0.317 | 61600.0 |
| 2002-07-01 09:16:00 | AAPL | Stock | 0.3186 | 0.3186 | 0.3177 | 0.3179 | 39200.0 |
| 2002-07-01 09:17:00 | AAPL | Stock | 0.3164 | 0.3171 | 0.3164 | 0.3171 | 263200.0 |
| 2002-07-01 09:19:00 | AAPL | Stock | 0.3171 | 0.3171 | 0.3171 | 0.3171 | 56000.0 |
| 2002-07-01 09:22:00 | AAPL | Stock | 0.3156 | 0.3156 | 0.3155 | 0.3155 | 39200.0 |
| 2002-07-01 09:23:00 | AAPL | Stock | 0.3157 | 0.3163 | 0.3157 | 0.3163 | 61600.0 |
| 2002-07-01 09:27:00 | AAPL | Stock | 0.3157 | 0.3159 | 0.3157 | 0.3157 | 117600.0 |
| 2002-07-01 09:28:00 | AAPL | Stock | 0.3157 | 0.3157 | 0.3157 | 0.3157 | 56000.0 |
| 2002-07-01 09:29:00 | AAPL | Stock | 0.3163 | 0.3163 | 0.3157 | 0.3157 | 134400.0 |
| 2002-07-01 09:30:00 | AAPL | Stock | 0.3163 | 0.3193 | 0.3157 | 0.318 | 3981600.0 |
| 2002-07-01 09:31:00 | AAPL | Stock | 0.3171 | 0.3184 | 0.3163 | 0.3166 | 1635200.0 |
| 2002-07-01 09:32:00 | AAPL | Stock | 0.3166 | 0.3171 | 0.3166 | 0.3171 | 974400.0 |
| 2002-07-01 09:33:00 | AAPL | Stock | 0.3171 | 0.3177 | 0.3159 | 0.3159 | 1108800.0 |
| 2002-07-01 09:34:00 | AAPL | Stock | 0.3166 | 0.317 | 0.3163 | 0.3166 | 935200.0 |
| 2002-07-01 09:35:00 | AAPL | Stock | 0.3166 | 0.3166 | 0.3161 | 0.3161 | 1495200.0 |
| 2002-07-01 09:36:00 | AAPL | Stock | 0.3166 | 0.3175 | 0.3164 | 0.3171 | 498400.0 |
| 2002-07-01 09:37:00 | AAPL | Stock | 0.3173 | 0.3173 | 0.317 | 0.317 | 593600.0 |
| 2002-07-01 09:38:00 | AAPL | Stock | 0.317 | 0.3171 | 0.3168 | 0.317 | 425600.0 |
| 2002-07-01 09:39:00 | AAPL | Stock | 0.3168 | 0.3168 | 0.3163 | 0.3166 | 459200.0 |
| 2002-07-01 09:40:00 | AAPL | Stock | 0.3166 | 0.3166 | 0.3157 | 0.3163 | 526400.0 |
| 2002-07-01 09:41:00 | AAPL | Stock | 0.3163 | 0.3164 | 0.3152 | 0.3154 | 711200.0 |
| 2002-07-01 09:42:00 | AAPL | Stock | 0.3171 | 0.3171 | 0.3154 | 0.3155 | 845600.0 |
| 2002-07-01 09:43:00 | AAPL | Stock | 0.3155 | 0.3164 | 0.3148 | 0.3148 | 168000.0 |
| 2002-07-01 09:44:00 | AAPL | Stock | 0.315 | 0.3164 | 0.3148 | 0.3157 | 408800.0 |
| 2002-07-01 09:45:00 | AAPL | Stock | 0.3157 | 0.317 | 0.3157 | 0.3169 | 683200.0 |
| 2002-07-01 09:46:00 | AAPL | Stock | 0.3169 | 0.3184 | 0.3164 | 0.3179 | 1041600.0 |
| 2002-07-01 09:47:00 | AAPL | Stock | 0.3177 | 0.3179 | 0.3171 | 0.3173 | 375200.0 |
| 2002-07-01 09:48:00 | AAPL | Stock | 0.3173 | 0.3177 | 0.3172 | 0.3177 | 403200.0 |
| 2002-07-01 09:49:00 | AAPL | Stock | 0.3177 | 0.3177 | 0.3173 | 0.3173 | 296800.0 |
| 2002-07-01 09:50:00 | AAPL | Stock | 0.3171 | 0.3171 | 0.3163 | 0.3168 | 156800.0 |
| 2002-07-01 09:51:00 | AAPL | Stock | 0.3168 | 0.3177 | 0.3165 | 0.3165 | 610400.0 |
> showing 50 of 382,230 rows — these rows as CSV