PREVIEW / stock_1min / 2011-01-11
file: by_date/stock_1min/2011/2011-01-11.parquet size: 13.3 MB rows: 995,141 symbols: 2,847
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-01-11 04:00:00 | AAPL | Stock | 12.3014 | 12.3014 | 12.3014 | 12.3014 | 22400.0 |
| 2011-01-11 04:01:00 | AAPL | Stock | 12.3014 | 12.3014 | 12.3014 | 12.3014 | 5600.0 |
| 2011-01-11 04:32:00 | AAPL | Stock | 12.3068 | 12.3068 | 12.3068 | 12.3068 | 2800.0 |
| 2011-01-11 04:33:00 | AAPL | Stock | 12.3071 | 12.3071 | 12.3071 | 12.3071 | 2800.0 |
| 2011-01-11 04:36:00 | AAPL | Stock | 12.3054 | 12.3054 | 12.3054 | 12.3054 | 2800.0 |
| 2011-01-11 04:42:00 | AAPL | Stock | 12.3107 | 12.3107 | 12.3107 | 12.3107 | 2800.0 |
| 2011-01-11 05:06:00 | AAPL | Stock | 12.3146 | 12.3146 | 12.3146 | 12.3146 | 2800.0 |
| 2011-01-11 05:13:00 | AAPL | Stock | 12.3004 | 12.3004 | 12.3004 | 12.3004 | 2800.0 |
| 2011-01-11 05:26:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 05:31:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 05:36:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 05:52:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 06:00:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 2800.0 |
| 2011-01-11 06:01:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 81200.0 |
| 2011-01-11 06:11:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3043 | 12.3043 | 33600.0 |
| 2011-01-11 06:13:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 06:14:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 06:27:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 06:30:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 14000.0 |
| 2011-01-11 06:32:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 2800.0 |
| 2011-01-11 06:46:00 | AAPL | Stock | 12.3139 | 12.3139 | 12.3139 | 12.3139 | 5600.0 |
| 2011-01-11 06:47:00 | AAPL | Stock | 12.3157 | 12.3157 | 12.3157 | 12.3157 | 2800.0 |
| 2011-01-11 06:50:00 | AAPL | Stock | 12.3089 | 12.3157 | 12.3089 | 12.3157 | 8400.0 |
| 2011-01-11 06:51:00 | AAPL | Stock | 12.3129 | 12.3129 | 12.3129 | 12.3129 | 2800.0 |
| 2011-01-11 06:53:00 | AAPL | Stock | 12.3146 | 12.3157 | 12.3146 | 12.3157 | 5600.0 |
| 2011-01-11 06:54:00 | AAPL | Stock | 12.3143 | 12.3143 | 12.3143 | 12.3143 | 2800.0 |
| 2011-01-11 06:55:00 | AAPL | Stock | 12.3211 | 12.3211 | 12.3211 | 12.3211 | 7000.0 |
| 2011-01-11 06:56:00 | AAPL | Stock | 12.3211 | 12.3214 | 12.3211 | 12.3214 | 11200.0 |
| 2011-01-11 06:57:00 | AAPL | Stock | 12.3389 | 12.3389 | 12.3389 | 12.3389 | 2800.0 |
| 2011-01-11 07:00:00 | AAPL | Stock | 12.3171 | 12.3171 | 12.3093 | 12.3143 | 19600.0 |
| 2011-01-11 07:01:00 | AAPL | Stock | 12.3339 | 12.3382 | 12.3207 | 12.3382 | 19320.0 |
| 2011-01-11 07:02:00 | AAPL | Stock | 12.3125 | 12.3125 | 12.3125 | 12.3125 | 2800.0 |
| 2011-01-11 07:05:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.3286 | 12.3286 | 9800.0 |
| 2011-01-11 07:06:00 | AAPL | Stock | 12.3214 | 12.3321 | 12.3214 | 12.3321 | 13580.0 |
| 2011-01-11 07:08:00 | AAPL | Stock | 12.3336 | 12.3336 | 12.3336 | 12.3336 | 2800.0 |
| 2011-01-11 07:10:00 | AAPL | Stock | 12.3343 | 12.335 | 12.3343 | 12.335 | 14000.0 |
| 2011-01-11 07:12:00 | AAPL | Stock | 12.3375 | 12.3389 | 12.3357 | 12.3357 | 33600.0 |
| 2011-01-11 07:13:00 | AAPL | Stock | 12.3343 | 12.3357 | 12.3339 | 12.3357 | 28000.0 |
| 2011-01-11 07:17:00 | AAPL | Stock | 12.3357 | 12.3357 | 12.3289 | 12.3289 | 16800.0 |
| 2011-01-11 07:18:00 | AAPL | Stock | 12.33 | 12.33 | 12.3286 | 12.3286 | 16800.0 |
| 2011-01-11 07:19:00 | AAPL | Stock | 12.3354 | 12.3354 | 12.3214 | 12.3214 | 22960.0 |
| 2011-01-11 07:20:00 | AAPL | Stock | 12.3214 | 12.3286 | 12.315 | 12.3214 | 55860.0 |
| 2011-01-11 07:21:00 | AAPL | Stock | 12.325 | 12.325 | 12.325 | 12.325 | 2800.0 |
| 2011-01-11 07:23:00 | AAPL | Stock | 12.3214 | 12.325 | 12.3214 | 12.325 | 11200.0 |
| 2011-01-11 07:24:00 | AAPL | Stock | 12.325 | 12.3289 | 12.325 | 12.3289 | 28000.0 |
| 2011-01-11 07:25:00 | AAPL | Stock | 12.3289 | 12.3289 | 12.3289 | 12.3289 | 2800.0 |
| 2011-01-11 07:26:00 | AAPL | Stock | 12.3289 | 12.3289 | 12.3289 | 12.3289 | 11200.0 |
| 2011-01-11 07:28:00 | AAPL | Stock | 12.325 | 12.325 | 12.325 | 12.325 | 2800.0 |
| 2011-01-11 07:30:00 | AAPL | Stock | 12.325 | 12.33 | 12.325 | 12.33 | 14000.0 |
| 2011-01-11 07:31:00 | AAPL | Stock | 12.3304 | 12.3304 | 12.3186 | 12.3186 | 33600.0 |
> showing 50 of 995,141 rows — these rows as CSV