PREVIEW / stock_1min / 2011-05-12
file: by_date/stock_1min/2011/2011-05-12.parquet size: 13.5 MB rows: 1,009,113 symbols: 2,885
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-05-12 04:00:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 5600.0 |
| 2011-05-12 04:47:00 | AAPL | Stock | 12.3293 | 12.3293 | 12.3293 | 12.3293 | 2800.0 |
| 2011-05-12 04:54:00 | AAPL | Stock | 12.3479 | 12.3479 | 12.3479 | 12.3479 | 2800.0 |
| 2011-05-12 05:27:00 | AAPL | Stock | 12.3457 | 12.3457 | 12.3457 | 12.3457 | 2800.0 |
| 2011-05-12 05:46:00 | AAPL | Stock | 12.33 | 12.33 | 12.33 | 12.33 | 2800.0 |
| 2011-05-12 05:48:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 2800.0 |
| 2011-05-12 06:01:00 | AAPL | Stock | 12.3307 | 12.3307 | 12.3307 | 12.3307 | 2800.0 |
| 2011-05-12 06:10:00 | AAPL | Stock | 12.3 | 12.3 | 12.3 | 12.3 | 2800.0 |
| 2011-05-12 06:15:00 | AAPL | Stock | 12.295 | 12.295 | 12.295 | 12.295 | 2800.0 |
| 2011-05-12 06:17:00 | AAPL | Stock | 12.2954 | 12.2954 | 12.2954 | 12.2954 | 8400.0 |
| 2011-05-12 06:26:00 | AAPL | Stock | 12.3107 | 12.3107 | 12.3107 | 12.3107 | 8400.0 |
| 2011-05-12 06:47:00 | AAPL | Stock | 12.3046 | 12.3075 | 12.3046 | 12.3075 | 5600.0 |
| 2011-05-12 06:50:00 | AAPL | Stock | 12.3054 | 12.3054 | 12.3054 | 12.3054 | 5600.0 |
| 2011-05-12 06:51:00 | AAPL | Stock | 12.3107 | 12.3107 | 12.3107 | 12.3107 | 18900.0 |
| 2011-05-12 07:00:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 2800.0 |
| 2011-05-12 07:04:00 | AAPL | Stock | 12.3254 | 12.3254 | 12.3254 | 12.3254 | 2800.0 |
| 2011-05-12 07:08:00 | AAPL | Stock | 12.325 | 12.325 | 12.325 | 12.325 | 2800.0 |
| 2011-05-12 07:11:00 | AAPL | Stock | 12.3275 | 12.3275 | 12.325 | 12.3275 | 11200.0 |
| 2011-05-12 07:12:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3143 | 12.3214 | 66500.0 |
| 2011-05-12 07:18:00 | AAPL | Stock | 12.3354 | 12.3354 | 12.3354 | 12.3354 | 5600.0 |
| 2011-05-12 07:20:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.3286 | 12.3286 | 5600.0 |
| 2011-05-12 07:23:00 | AAPL | Stock | 12.3289 | 12.3289 | 12.3289 | 12.3289 | 5600.0 |
| 2011-05-12 07:24:00 | AAPL | Stock | 12.3268 | 12.3268 | 12.3268 | 12.3268 | 7000.0 |
| 2011-05-12 07:25:00 | AAPL | Stock | 12.3264 | 12.3264 | 12.3264 | 12.3264 | 5600.0 |
| 2011-05-12 07:26:00 | AAPL | Stock | 12.3264 | 12.3279 | 12.3264 | 12.3279 | 6440.0 |
| 2011-05-12 07:28:00 | AAPL | Stock | 12.3307 | 12.3307 | 12.3307 | 12.3307 | 2800.0 |
| 2011-05-12 07:32:00 | AAPL | Stock | 12.3275 | 12.3304 | 12.3275 | 12.3304 | 23576.0 |
| 2011-05-12 07:34:00 | AAPL | Stock | 12.3389 | 12.3393 | 12.3389 | 12.3393 | 13300.0 |
| 2011-05-12 07:41:00 | AAPL | Stock | 12.3314 | 12.3314 | 12.3189 | 12.3196 | 58800.0 |
| 2011-05-12 07:42:00 | AAPL | Stock | 12.315 | 12.315 | 12.315 | 12.315 | 5600.0 |
| 2011-05-12 07:45:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 5600.0 |
| 2011-05-12 07:46:00 | AAPL | Stock | 12.3211 | 12.3214 | 12.32 | 12.3207 | 11200.0 |
| 2011-05-12 07:47:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 14000.0 |
| 2011-05-12 07:48:00 | AAPL | Stock | 12.3207 | 12.3207 | 12.3207 | 12.3207 | 2800.0 |
| 2011-05-12 07:49:00 | AAPL | Stock | 12.3207 | 12.3214 | 12.3207 | 12.3214 | 22484.0 |
| 2011-05-12 07:51:00 | AAPL | Stock | 12.3214 | 12.3261 | 12.3179 | 12.3214 | 54600.0 |
| 2011-05-12 07:53:00 | AAPL | Stock | 12.3214 | 12.3229 | 12.3175 | 12.3214 | 33600.0 |
| 2011-05-12 07:58:00 | AAPL | Stock | 12.3232 | 12.3246 | 12.3189 | 12.3189 | 34804.0 |
| 2011-05-12 07:59:00 | AAPL | Stock | 12.3336 | 12.3336 | 12.3336 | 12.3336 | 2800.0 |
| 2011-05-12 08:00:00 | AAPL | Stock | 12.3321 | 12.34 | 12.3321 | 12.34 | 70420.0 |
| 2011-05-12 08:01:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3214 | 12.3214 | 325724.0 |
| 2011-05-12 08:02:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 12908.0 |
| 2011-05-12 08:03:00 | AAPL | Stock | 12.3214 | 12.3232 | 12.3186 | 12.3186 | 27188.0 |
| 2011-05-12 08:04:00 | AAPL | Stock | 12.3186 | 12.3186 | 12.3186 | 12.3186 | 2800.0 |
| 2011-05-12 08:05:00 | AAPL | Stock | 12.3207 | 12.3214 | 12.3196 | 12.3214 | 91560.0 |
| 2011-05-12 08:07:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 39760.0 |
| 2011-05-12 08:08:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 57596.0 |
| 2011-05-12 08:09:00 | AAPL | Stock | 12.3293 | 12.3293 | 12.3268 | 12.3268 | 52360.0 |
| 2011-05-12 08:11:00 | AAPL | Stock | 12.3264 | 12.3382 | 12.325 | 12.325 | 242480.0 |
| 2011-05-12 08:13:00 | AAPL | Stock | 12.3218 | 12.3218 | 12.3214 | 12.3214 | 8400.0 |
> showing 50 of 1,009,113 rows — these rows as CSV