PREVIEW / stock_1min / 2011-02-02
file: by_date/stock_1min/2011/2011-02-02.parquet size: 13.0 MB rows: 972,727 symbols: 2,848
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-02 04:38:00 | AAPL | Stock | 12.3225 | 12.3225 | 12.3225 | 12.3225 | 2800.0 |
| 2011-02-02 04:39:00 | AAPL | Stock | 12.3332 | 12.3332 | 12.3332 | 12.3332 | 2800.0 |
| 2011-02-02 04:41:00 | AAPL | Stock | 12.3496 | 12.3496 | 12.3496 | 12.3496 | 2800.0 |
| 2011-02-02 05:19:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 2800.0 |
| 2011-02-02 05:24:00 | AAPL | Stock | 12.3307 | 12.3307 | 12.3286 | 12.3286 | 5600.0 |
| 2011-02-02 06:28:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 14000.0 |
| 2011-02-02 06:31:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 2800.0 |
| 2011-02-02 06:32:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 8372.0 |
| 2011-02-02 06:34:00 | AAPL | Stock | 12.3321 | 12.3321 | 12.3321 | 12.3321 | 2828.0 |
| 2011-02-02 06:49:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.3286 | 12.3286 | 5600.0 |
| 2011-02-02 07:00:00 | AAPL | Stock | 12.3314 | 12.3314 | 12.3304 | 12.3304 | 47600.0 |
| 2011-02-02 07:01:00 | AAPL | Stock | 12.3225 | 12.3225 | 12.3225 | 12.3225 | 19600.0 |
| 2011-02-02 07:04:00 | AAPL | Stock | 12.3225 | 12.3225 | 12.3225 | 12.3225 | 8260.0 |
| 2011-02-02 07:06:00 | AAPL | Stock | 12.3318 | 12.3318 | 12.3318 | 12.3318 | 2800.0 |
| 2011-02-02 07:08:00 | AAPL | Stock | 12.3332 | 12.3332 | 12.3332 | 12.3332 | 5600.0 |
| 2011-02-02 07:10:00 | AAPL | Stock | 12.3332 | 12.3332 | 12.3332 | 12.3332 | 2800.0 |
| 2011-02-02 07:11:00 | AAPL | Stock | 12.3539 | 12.3539 | 12.3539 | 12.3539 | 33600.0 |
| 2011-02-02 07:12:00 | AAPL | Stock | 12.3375 | 12.3375 | 12.3375 | 12.3375 | 25200.0 |
| 2011-02-02 07:17:00 | AAPL | Stock | 12.3479 | 12.3479 | 12.3479 | 12.3479 | 2800.0 |
| 2011-02-02 07:23:00 | AAPL | Stock | 12.3479 | 12.3479 | 12.3479 | 12.3479 | 7812.0 |
| 2011-02-02 07:24:00 | AAPL | Stock | 12.3464 | 12.3464 | 12.3464 | 12.3464 | 7840.0 |
| 2011-02-02 07:33:00 | AAPL | Stock | 12.3307 | 12.3307 | 12.3307 | 12.3307 | 2800.0 |
| 2011-02-02 07:34:00 | AAPL | Stock | 12.33 | 12.33 | 12.33 | 12.33 | 2800.0 |
| 2011-02-02 07:36:00 | AAPL | Stock | 12.3304 | 12.3304 | 12.3304 | 12.3304 | 5600.0 |
| 2011-02-02 07:37:00 | AAPL | Stock | 12.3304 | 12.3304 | 12.3304 | 12.3304 | 2800.0 |
| 2011-02-02 07:43:00 | AAPL | Stock | 12.3225 | 12.3225 | 12.3225 | 12.3225 | 16800.0 |
| 2011-02-02 07:45:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 2800.0 |
| 2011-02-02 07:46:00 | AAPL | Stock | 12.3318 | 12.3321 | 12.3318 | 12.3321 | 5600.0 |
| 2011-02-02 08:00:00 | AAPL | Stock | 12.3279 | 12.3279 | 12.3196 | 12.3196 | 34496.0 |
| 2011-02-02 08:07:00 | AAPL | Stock | 12.3125 | 12.3129 | 12.3096 | 12.3125 | 25200.0 |
| 2011-02-02 08:09:00 | AAPL | Stock | 12.3118 | 12.3118 | 12.3118 | 12.3118 | 22400.0 |
| 2011-02-02 08:10:00 | AAPL | Stock | 12.3079 | 12.3079 | 12.3004 | 12.3004 | 53200.0 |
| 2011-02-02 08:11:00 | AAPL | Stock | 12.3 | 12.3036 | 12.2982 | 12.2993 | 39508.0 |
| 2011-02-02 08:12:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.2982 | 12.2989 | 39228.0 |
| 2011-02-02 08:13:00 | AAPL | Stock | 12.2975 | 12.2975 | 12.2946 | 12.2964 | 15204.0 |
| 2011-02-02 08:14:00 | AAPL | Stock | 12.2954 | 12.3014 | 12.2954 | 12.3014 | 27328.0 |
| 2011-02-02 08:15:00 | AAPL | Stock | 12.3014 | 12.3214 | 12.3014 | 12.3214 | 123200.0 |
| 2011-02-02 08:16:00 | AAPL | Stock | 12.3136 | 12.3211 | 12.3132 | 12.3132 | 39200.0 |
| 2011-02-02 08:17:00 | AAPL | Stock | 12.3143 | 12.3196 | 12.3143 | 12.3143 | 16800.0 |
| 2011-02-02 08:18:00 | AAPL | Stock | 12.3161 | 12.3161 | 12.3143 | 12.3143 | 9800.0 |
| 2011-02-02 08:20:00 | AAPL | Stock | 12.3143 | 12.3143 | 12.3143 | 12.3143 | 2800.0 |
| 2011-02-02 08:21:00 | AAPL | Stock | 12.3161 | 12.3164 | 12.3161 | 12.3164 | 8400.0 |
| 2011-02-02 08:22:00 | AAPL | Stock | 12.3161 | 12.3161 | 12.3143 | 12.3161 | 11200.0 |
| 2011-02-02 08:23:00 | AAPL | Stock | 12.3179 | 12.3214 | 12.3179 | 12.3214 | 81060.0 |
| 2011-02-02 08:24:00 | AAPL | Stock | 12.3218 | 12.3232 | 12.3164 | 12.3232 | 12600.0 |
| 2011-02-02 08:25:00 | AAPL | Stock | 12.3214 | 12.3243 | 12.3214 | 12.3214 | 38136.0 |
| 2011-02-02 08:26:00 | AAPL | Stock | 12.3214 | 12.3218 | 12.3143 | 12.3143 | 163800.0 |
| 2011-02-02 08:27:00 | AAPL | Stock | 12.3125 | 12.3125 | 12.3125 | 12.3125 | 2800.0 |
| 2011-02-02 08:28:00 | AAPL | Stock | 12.3196 | 12.3196 | 12.3125 | 12.3157 | 22400.0 |
| 2011-02-02 08:29:00 | AAPL | Stock | 12.3136 | 12.3136 | 12.3136 | 12.3136 | 2800.0 |
> showing 50 of 972,727 rows — these rows as CSV