PREVIEW / stock_1min / 2005-01-13
file: by_date/stock_1min/2005/2005-01-13.parquet size: 6.6 MB rows: 544,866 symbols: 1,567
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-13 08:00:00 | AAPL | Stock | 1.3182 | 1.3214 | 1.3129 | 1.3214 | 1610560.0 |
| 2005-01-13 08:01:00 | AAPL | Stock | 1.3207 | 1.3241 | 1.3152 | 1.3202 | 10400544.0 |
| 2005-01-13 08:02:00 | AAPL | Stock | 1.32 | 1.3211 | 1.3152 | 1.3182 | 2233616.0 |
| 2005-01-13 08:03:00 | AAPL | Stock | 1.3179 | 1.3179 | 1.3071 | 1.3071 | 3462032.0 |
| 2005-01-13 08:04:00 | AAPL | Stock | 1.3088 | 1.3179 | 1.3036 | 1.3068 | 3073000.0 |
| 2005-01-13 08:05:00 | AAPL | Stock | 1.3071 | 1.3125 | 1.3046 | 1.3114 | 2057216.0 |
| 2005-01-13 08:06:00 | AAPL | Stock | 1.31 | 1.3125 | 1.3098 | 1.3116 | 677320.0 |
| 2005-01-13 08:07:00 | AAPL | Stock | 1.3123 | 1.3173 | 1.3123 | 1.3145 | 1825880.0 |
| 2005-01-13 08:08:00 | AAPL | Stock | 1.3143 | 1.3143 | 1.308 | 1.3143 | 882000.0 |
| 2005-01-13 08:09:00 | AAPL | Stock | 1.3161 | 1.317 | 1.3125 | 1.317 | 1068648.0 |
| 2005-01-13 08:10:00 | AAPL | Stock | 1.3161 | 1.317 | 1.3125 | 1.3168 | 912408.0 |
| 2005-01-13 08:11:00 | AAPL | Stock | 1.317 | 1.3179 | 1.3143 | 1.3161 | 783608.0 |
| 2005-01-13 08:12:00 | AAPL | Stock | 1.317 | 1.3188 | 1.3161 | 1.3168 | 638400.0 |
| 2005-01-13 08:13:00 | AAPL | Stock | 1.3161 | 1.3161 | 1.3134 | 1.3145 | 419216.0 |
| 2005-01-13 08:14:00 | AAPL | Stock | 1.3136 | 1.3166 | 1.3134 | 1.3161 | 955528.0 |
| 2005-01-13 08:15:00 | AAPL | Stock | 1.3161 | 1.3166 | 1.3143 | 1.3152 | 709688.0 |
| 2005-01-13 08:16:00 | AAPL | Stock | 1.3152 | 1.3161 | 1.3143 | 1.3152 | 510440.0 |
| 2005-01-13 08:17:00 | AAPL | Stock | 1.3145 | 1.315 | 1.3134 | 1.3145 | 517440.0 |
| 2005-01-13 08:18:00 | AAPL | Stock | 1.3143 | 1.3166 | 1.3134 | 1.3159 | 694512.0 |
| 2005-01-13 08:19:00 | AAPL | Stock | 1.3161 | 1.317 | 1.3152 | 1.3161 | 866096.0 |
| 2005-01-13 08:20:00 | AAPL | Stock | 1.3152 | 1.3161 | 1.3143 | 1.3152 | 743960.0 |
| 2005-01-13 08:21:00 | AAPL | Stock | 1.3146 | 1.3152 | 1.3143 | 1.3146 | 242760.0 |
| 2005-01-13 08:22:00 | AAPL | Stock | 1.3145 | 1.3157 | 1.3125 | 1.315 | 2199232.0 |
| 2005-01-13 08:23:00 | AAPL | Stock | 1.3132 | 1.3161 | 1.3132 | 1.3155 | 1306144.0 |
| 2005-01-13 08:24:00 | AAPL | Stock | 1.3161 | 1.3166 | 1.3152 | 1.3155 | 666064.0 |
| 2005-01-13 08:25:00 | AAPL | Stock | 1.3164 | 1.3166 | 1.3134 | 1.3146 | 771232.0 |
| 2005-01-13 08:26:00 | AAPL | Stock | 1.3146 | 1.3159 | 1.3125 | 1.3127 | 660128.0 |
| 2005-01-13 08:27:00 | AAPL | Stock | 1.3134 | 1.3164 | 1.3134 | 1.3152 | 2277632.0 |
| 2005-01-13 08:28:00 | AAPL | Stock | 1.3161 | 1.3207 | 1.3161 | 1.3207 | 2769648.0 |
| 2005-01-13 08:29:00 | AAPL | Stock | 1.3202 | 1.3248 | 1.3196 | 1.3248 | 5269824.0 |
| 2005-01-13 08:30:00 | AAPL | Stock | 1.3239 | 1.325 | 1.3202 | 1.3214 | 2229920.0 |
| 2005-01-13 08:31:00 | AAPL | Stock | 1.3214 | 1.3245 | 1.3214 | 1.3241 | 1242528.0 |
| 2005-01-13 08:32:00 | AAPL | Stock | 1.3236 | 1.3286 | 1.3236 | 1.3279 | 4580632.0 |
| 2005-01-13 08:33:00 | AAPL | Stock | 1.3273 | 1.3295 | 1.3259 | 1.3266 | 2558136.0 |
| 2005-01-13 08:34:00 | AAPL | Stock | 1.3259 | 1.3295 | 1.3241 | 1.3241 | 2058504.0 |
| 2005-01-13 08:35:00 | AAPL | Stock | 1.3241 | 1.325 | 1.3227 | 1.325 | 999600.0 |
| 2005-01-13 08:36:00 | AAPL | Stock | 1.325 | 1.325 | 1.3216 | 1.3227 | 1354584.0 |
| 2005-01-13 08:37:00 | AAPL | Stock | 1.3227 | 1.3295 | 1.3227 | 1.328 | 2634128.0 |
| 2005-01-13 08:38:00 | AAPL | Stock | 1.327 | 1.3271 | 1.3232 | 1.3236 | 1366400.0 |
| 2005-01-13 08:39:00 | AAPL | Stock | 1.3236 | 1.3246 | 1.3232 | 1.3241 | 1106728.0 |
| 2005-01-13 08:40:00 | AAPL | Stock | 1.3241 | 1.3263 | 1.3236 | 1.3243 | 2502080.0 |
| 2005-01-13 08:41:00 | AAPL | Stock | 1.3243 | 1.3259 | 1.3223 | 1.3259 | 6742344.0 |
| 2005-01-13 08:42:00 | AAPL | Stock | 1.3263 | 1.3264 | 1.3232 | 1.3248 | 5744088.0 |
| 2005-01-13 08:43:00 | AAPL | Stock | 1.3248 | 1.3268 | 1.3246 | 1.3268 | 3515064.0 |
| 2005-01-13 08:44:00 | AAPL | Stock | 1.3263 | 1.3268 | 1.325 | 1.3254 | 3145688.0 |
| 2005-01-13 08:45:00 | AAPL | Stock | 1.325 | 1.3259 | 1.3241 | 1.3252 | 1407896.0 |
| 2005-01-13 08:46:00 | AAPL | Stock | 1.3252 | 1.3273 | 1.325 | 1.3257 | 2459352.0 |
| 2005-01-13 08:47:00 | AAPL | Stock | 1.3257 | 1.3266 | 1.3254 | 1.3263 | 388640.0 |
| 2005-01-13 08:48:00 | AAPL | Stock | 1.3263 | 1.3266 | 1.325 | 1.3261 | 2025072.0 |
| 2005-01-13 08:49:00 | AAPL | Stock | 1.3259 | 1.3277 | 1.325 | 1.3268 | 3690120.0 |
> showing 50 of 544,866 rows — these rows as CSV