PREVIEW / stock_1min / 2007-06-01
file: by_date/stock_1min/2007/2007-06-01.parquet size: 9.6 MB rows: 779,603 symbols: 2,155
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-01 07:14:00 | AAPL | Stock | 4.3168 | 4.3168 | 4.3168 | 4.3168 | 9800.0 |
| 2007-06-01 07:36:00 | AAPL | Stock | 4.3196 | 4.3196 | 4.3196 | 4.3196 | 14000.0 |
| 2007-06-01 07:38:00 | AAPL | Stock | 4.3196 | 4.3196 | 4.3196 | 4.3196 | 7000.0 |
| 2007-06-01 07:58:00 | AAPL | Stock | 4.3107 | 4.3107 | 4.3107 | 4.3107 | 2800.0 |
| 2007-06-01 07:59:00 | AAPL | Stock | 4.3143 | 4.3143 | 4.3143 | 4.3143 | 6720.0 |
| 2007-06-01 08:00:00 | AAPL | Stock | 4.3136 | 4.3196 | 4.3107 | 4.3143 | 197176.0 |
| 2007-06-01 08:01:00 | AAPL | Stock | 4.3171 | 4.3179 | 4.3171 | 4.3179 | 5600.0 |
| 2007-06-01 08:02:00 | AAPL | Stock | 4.315 | 4.3179 | 4.315 | 4.3179 | 57960.0 |
| 2007-06-01 08:03:00 | AAPL | Stock | 4.3171 | 4.3204 | 4.3171 | 4.3179 | 15400.0 |
| 2007-06-01 08:04:00 | AAPL | Stock | 4.3182 | 4.3196 | 4.3161 | 4.3161 | 99540.0 |
| 2007-06-01 08:05:00 | AAPL | Stock | 4.3196 | 4.3196 | 4.3182 | 4.3182 | 40600.0 |
| 2007-06-01 08:06:00 | AAPL | Stock | 4.3186 | 4.3214 | 4.3186 | 4.3214 | 173600.0 |
| 2007-06-01 08:07:00 | AAPL | Stock | 4.3211 | 4.3211 | 4.3207 | 4.3207 | 7000.0 |
| 2007-06-01 08:08:00 | AAPL | Stock | 4.3193 | 4.3214 | 4.3182 | 4.3214 | 187068.0 |
| 2007-06-01 08:09:00 | AAPL | Stock | 4.3211 | 4.325 | 4.3211 | 4.325 | 109312.0 |
| 2007-06-01 08:10:00 | AAPL | Stock | 4.325 | 4.3286 | 4.325 | 4.3286 | 134484.0 |
| 2007-06-01 08:11:00 | AAPL | Stock | 4.3304 | 4.3354 | 4.3286 | 4.3339 | 412300.0 |
| 2007-06-01 08:12:00 | AAPL | Stock | 4.3357 | 4.3414 | 4.3343 | 4.3414 | 482188.0 |
| 2007-06-01 08:13:00 | AAPL | Stock | 4.3457 | 4.3457 | 4.3393 | 4.3429 | 215068.0 |
| 2007-06-01 08:14:00 | AAPL | Stock | 4.3375 | 4.3393 | 4.3357 | 4.3357 | 58800.0 |
| 2007-06-01 08:15:00 | AAPL | Stock | 4.3361 | 4.3375 | 4.3361 | 4.3364 | 35196.0 |
| 2007-06-01 08:16:00 | AAPL | Stock | 4.3364 | 4.3364 | 4.3346 | 4.3346 | 89516.0 |
| 2007-06-01 08:17:00 | AAPL | Stock | 4.3343 | 4.3343 | 4.3325 | 4.3325 | 251524.0 |
| 2007-06-01 08:18:00 | AAPL | Stock | 4.3325 | 4.3357 | 4.3282 | 4.3282 | 62076.0 |
| 2007-06-01 08:19:00 | AAPL | Stock | 4.3321 | 4.3325 | 4.3321 | 4.3321 | 18200.0 |
| 2007-06-01 08:20:00 | AAPL | Stock | 4.3321 | 4.3332 | 4.3311 | 4.3325 | 42000.0 |
| 2007-06-01 08:21:00 | AAPL | Stock | 4.3332 | 4.3336 | 4.3329 | 4.3329 | 28000.0 |
| 2007-06-01 08:22:00 | AAPL | Stock | 4.3339 | 4.3379 | 4.3339 | 4.3371 | 118160.0 |
| 2007-06-01 08:23:00 | AAPL | Stock | 4.3357 | 4.3361 | 4.335 | 4.335 | 57400.0 |
| 2007-06-01 08:24:00 | AAPL | Stock | 4.3357 | 4.3357 | 4.335 | 4.335 | 42000.0 |
| 2007-06-01 08:25:00 | AAPL | Stock | 4.3346 | 4.3346 | 4.3314 | 4.3314 | 70000.0 |
| 2007-06-01 08:26:00 | AAPL | Stock | 4.3346 | 4.335 | 4.3346 | 4.335 | 30240.0 |
| 2007-06-01 08:27:00 | AAPL | Stock | 4.335 | 4.335 | 4.335 | 4.335 | 3360.0 |
| 2007-06-01 08:28:00 | AAPL | Stock | 4.3339 | 4.3339 | 4.3329 | 4.3329 | 39900.0 |
| 2007-06-01 08:30:00 | AAPL | Stock | 4.3325 | 4.3446 | 4.3321 | 4.335 | 261044.0 |
| 2007-06-01 08:31:00 | AAPL | Stock | 4.3371 | 4.3375 | 4.3371 | 4.3375 | 11200.0 |
| 2007-06-01 08:32:00 | AAPL | Stock | 4.3357 | 4.3357 | 4.3314 | 4.3357 | 119000.0 |
| 2007-06-01 08:33:00 | AAPL | Stock | 4.3389 | 4.3389 | 4.3354 | 4.3375 | 33600.0 |
| 2007-06-01 08:34:00 | AAPL | Stock | 4.3389 | 4.345 | 4.3389 | 4.345 | 51800.0 |
| 2007-06-01 08:35:00 | AAPL | Stock | 4.3429 | 4.3446 | 4.3396 | 4.3429 | 155400.0 |
| 2007-06-01 08:36:00 | AAPL | Stock | 4.3446 | 4.345 | 4.3429 | 4.3443 | 169288.0 |
| 2007-06-01 08:37:00 | AAPL | Stock | 4.3436 | 4.3457 | 4.3432 | 4.3436 | 254380.0 |
| 2007-06-01 08:38:00 | AAPL | Stock | 4.3436 | 4.3439 | 4.3429 | 4.3429 | 143864.0 |
| 2007-06-01 08:39:00 | AAPL | Stock | 4.3429 | 4.3457 | 4.3429 | 4.3443 | 32200.0 |
| 2007-06-01 08:40:00 | AAPL | Stock | 4.3436 | 4.3446 | 4.3436 | 4.3446 | 18200.0 |
| 2007-06-01 08:41:00 | AAPL | Stock | 4.3436 | 4.3446 | 4.3418 | 4.3429 | 131880.0 |
| 2007-06-01 08:42:00 | AAPL | Stock | 4.3429 | 4.3432 | 4.3429 | 4.3432 | 109200.0 |
| 2007-06-01 08:43:00 | AAPL | Stock | 4.3429 | 4.3429 | 4.3429 | 4.3429 | 19600.0 |
| 2007-06-01 08:44:00 | AAPL | Stock | 4.3429 | 4.3443 | 4.3414 | 4.3414 | 217924.0 |
| 2007-06-01 08:45:00 | AAPL | Stock | 4.3421 | 4.3421 | 4.3411 | 4.3411 | 196000.0 |
> showing 50 of 779,603 rows — these rows as CSV