PREVIEW / stock_1min / 2007-01-10
file: by_date/stock_1min/2007/2007-01-10.parquet size: 9.1 MB rows: 740,814 symbols: 2,024
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-01-10 04:50:00 | AAPL | Stock | 3.3018 | 3.3018 | 3.3018 | 3.3018 | 14000.0 |
| 2007-01-10 05:26:00 | AAPL | Stock | 3.2975 | 3.2975 | 3.2968 | 3.2968 | 25480.0 |
| 2007-01-10 05:48:00 | AAPL | Stock | 3.2975 | 3.2975 | 3.2975 | 3.2975 | 2800.0 |
| 2007-01-10 05:49:00 | AAPL | Stock | 3.2971 | 3.2971 | 3.2971 | 3.2971 | 14000.0 |
| 2007-01-10 05:51:00 | AAPL | Stock | 3.2979 | 3.2979 | 3.2971 | 3.2971 | 11200.0 |
| 2007-01-10 05:52:00 | AAPL | Stock | 3.2971 | 3.2971 | 3.2971 | 3.2971 | 4060.0 |
| 2007-01-10 05:59:00 | AAPL | Stock | 3.2971 | 3.2971 | 3.2971 | 3.2971 | 2800.0 |
| 2007-01-10 06:11:00 | AAPL | Stock | 3.2982 | 3.2982 | 3.2982 | 3.2982 | 3220.0 |
| 2007-01-10 06:17:00 | AAPL | Stock | 3.2993 | 3.2993 | 3.2993 | 3.2993 | 2800.0 |
| 2007-01-10 06:18:00 | AAPL | Stock | 3.2989 | 3.2989 | 3.2989 | 3.2989 | 5600.0 |
| 2007-01-10 06:38:00 | AAPL | Stock | 3.3 | 3.3 | 3.3 | 3.3 | 2800.0 |
| 2007-01-10 06:41:00 | AAPL | Stock | 3.3032 | 3.3036 | 3.3032 | 3.3036 | 58800.0 |
| 2007-01-10 06:42:00 | AAPL | Stock | 3.305 | 3.3089 | 3.305 | 3.3089 | 201600.0 |
| 2007-01-10 06:52:00 | AAPL | Stock | 3.3068 | 3.3068 | 3.3068 | 3.3068 | 28000.0 |
| 2007-01-10 06:54:00 | AAPL | Stock | 3.3132 | 3.3211 | 3.3132 | 3.3211 | 232904.0 |
| 2007-01-10 06:57:00 | AAPL | Stock | 3.3089 | 3.3089 | 3.3071 | 3.3071 | 140000.0 |
| 2007-01-10 07:00:00 | AAPL | Stock | 3.3143 | 3.3143 | 3.3143 | 3.3143 | 11200.0 |
| 2007-01-10 07:01:00 | AAPL | Stock | 3.3143 | 3.3179 | 3.3143 | 3.3179 | 42168.0 |
| 2007-01-10 07:02:00 | AAPL | Stock | 3.3179 | 3.3204 | 3.3179 | 3.3204 | 114632.0 |
| 2007-01-10 07:03:00 | AAPL | Stock | 3.3196 | 3.3246 | 3.3196 | 3.3246 | 288568.0 |
| 2007-01-10 07:04:00 | AAPL | Stock | 3.3218 | 3.3286 | 3.3218 | 3.3286 | 83160.0 |
| 2007-01-10 07:05:00 | AAPL | Stock | 3.3279 | 3.3289 | 3.3279 | 3.3289 | 63000.0 |
| 2007-01-10 07:06:00 | AAPL | Stock | 3.3286 | 3.3314 | 3.3218 | 3.3246 | 181020.0 |
| 2007-01-10 07:07:00 | AAPL | Stock | 3.3264 | 3.3286 | 3.3221 | 3.3286 | 114800.0 |
| 2007-01-10 07:08:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3225 | 3.3286 | 73780.0 |
| 2007-01-10 07:09:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3286 | 3.3286 | 2800.0 |
| 2007-01-10 07:10:00 | AAPL | Stock | 3.3286 | 3.3321 | 3.3286 | 3.3321 | 244104.0 |
| 2007-01-10 07:11:00 | AAPL | Stock | 3.3321 | 3.3321 | 3.3304 | 3.3304 | 5600.0 |
| 2007-01-10 07:12:00 | AAPL | Stock | 3.3336 | 3.3339 | 3.3336 | 3.3339 | 5600.0 |
| 2007-01-10 07:13:00 | AAPL | Stock | 3.3339 | 3.3339 | 3.3332 | 3.3332 | 8400.0 |
| 2007-01-10 07:14:00 | AAPL | Stock | 3.3321 | 3.3332 | 3.3321 | 3.3321 | 109200.0 |
| 2007-01-10 07:15:00 | AAPL | Stock | 3.3321 | 3.3325 | 3.3214 | 3.3214 | 263200.0 |
| 2007-01-10 07:16:00 | AAPL | Stock | 3.3321 | 3.3321 | 3.3321 | 3.3321 | 198800.0 |
| 2007-01-10 07:17:00 | AAPL | Stock | 3.3321 | 3.3368 | 3.3321 | 3.3368 | 271572.0 |
| 2007-01-10 07:18:00 | AAPL | Stock | 3.3382 | 3.3393 | 3.3382 | 3.3393 | 290948.0 |
| 2007-01-10 07:19:00 | AAPL | Stock | 3.3346 | 3.3346 | 3.3346 | 3.3346 | 4200.0 |
| 2007-01-10 07:20:00 | AAPL | Stock | 3.3346 | 3.3393 | 3.3325 | 3.3393 | 204288.0 |
| 2007-01-10 07:21:00 | AAPL | Stock | 3.3407 | 3.3468 | 3.3407 | 3.3464 | 507920.0 |
| 2007-01-10 07:22:00 | AAPL | Stock | 3.3464 | 3.3468 | 3.3446 | 3.3446 | 21000.0 |
| 2007-01-10 07:23:00 | AAPL | Stock | 3.3411 | 3.3411 | 3.3357 | 3.3357 | 30800.0 |
| 2007-01-10 07:24:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3375 | 3.3379 | 33040.0 |
| 2007-01-10 07:26:00 | AAPL | Stock | 3.3386 | 3.3386 | 3.3386 | 3.3386 | 2800.0 |
| 2007-01-10 07:27:00 | AAPL | Stock | 3.3393 | 3.3393 | 3.3393 | 3.3393 | 5292.0 |
| 2007-01-10 07:28:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3396 | 3.3411 | 115108.0 |
| 2007-01-10 07:29:00 | AAPL | Stock | 3.3429 | 3.345 | 3.3414 | 3.3414 | 67200.0 |
| 2007-01-10 07:30:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3393 | 3.3393 | 44940.0 |
| 2007-01-10 07:31:00 | AAPL | Stock | 3.3393 | 3.3429 | 3.3393 | 3.3393 | 50400.0 |
| 2007-01-10 07:32:00 | AAPL | Stock | 3.3393 | 3.3396 | 3.3382 | 3.3396 | 218400.0 |
| 2007-01-10 07:33:00 | AAPL | Stock | 3.3396 | 3.3429 | 3.3393 | 3.3429 | 18200.0 |
| 2007-01-10 07:34:00 | AAPL | Stock | 3.3396 | 3.3429 | 3.3396 | 3.3429 | 44800.0 |
> showing 50 of 740,814 rows — these rows as CSV