PREVIEW / stock_1min / 2010-07-29
file: by_date/stock_1min/2010/2010-07-29.parquet size: 12.7 MB rows: 961,678 symbols: 2,804
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-29 06:00:00 | AAPL | Stock | 9.3446 | 9.3482 | 9.3446 | 9.3482 | 5908.0 |
| 2010-07-29 06:04:00 | AAPL | Stock | 9.3482 | 9.3482 | 9.3482 | 9.3482 | 9212.0 |
| 2010-07-29 06:09:00 | AAPL | Stock | 9.3636 | 9.3636 | 9.3636 | 9.3636 | 2800.0 |
| 2010-07-29 06:41:00 | AAPL | Stock | 9.3518 | 9.3518 | 9.3518 | 9.3518 | 2800.0 |
| 2010-07-29 06:58:00 | AAPL | Stock | 9.3393 | 9.3393 | 9.3393 | 9.3393 | 2800.0 |
| 2010-07-29 07:02:00 | AAPL | Stock | 9.3589 | 9.3589 | 9.3589 | 9.3589 | 2800.0 |
| 2010-07-29 07:05:00 | AAPL | Stock | 9.3479 | 9.3479 | 9.3479 | 9.3479 | 5600.0 |
| 2010-07-29 07:17:00 | AAPL | Stock | 9.3557 | 9.3557 | 9.3557 | 9.3557 | 2800.0 |
| 2010-07-29 07:18:00 | AAPL | Stock | 9.345 | 9.345 | 9.345 | 9.345 | 2800.0 |
| 2010-07-29 07:19:00 | AAPL | Stock | 9.3518 | 9.3518 | 9.3518 | 9.3518 | 14000.0 |
| 2010-07-29 07:22:00 | AAPL | Stock | 9.3432 | 9.3432 | 9.3429 | 9.3429 | 11536.0 |
| 2010-07-29 07:24:00 | AAPL | Stock | 9.3396 | 9.3396 | 9.3393 | 9.3396 | 42000.0 |
| 2010-07-29 07:25:00 | AAPL | Stock | 9.34 | 9.34 | 9.3393 | 9.3393 | 28000.0 |
| 2010-07-29 07:29:00 | AAPL | Stock | 9.3304 | 9.3357 | 9.3304 | 9.3321 | 11200.0 |
| 2010-07-29 07:30:00 | AAPL | Stock | 9.325 | 9.325 | 9.325 | 9.325 | 2800.0 |
| 2010-07-29 07:31:00 | AAPL | Stock | 9.325 | 9.3268 | 9.325 | 9.3268 | 14000.0 |
| 2010-07-29 07:40:00 | AAPL | Stock | 9.3364 | 9.3454 | 9.3325 | 9.3325 | 148400.0 |
| 2010-07-29 07:41:00 | AAPL | Stock | 9.3393 | 9.3471 | 9.3375 | 9.3386 | 70000.0 |
| 2010-07-29 07:44:00 | AAPL | Stock | 9.3393 | 9.3464 | 9.3393 | 9.3464 | 28000.0 |
| 2010-07-29 07:47:00 | AAPL | Stock | 9.3389 | 9.3389 | 9.3382 | 9.3382 | 5600.0 |
| 2010-07-29 07:52:00 | AAPL | Stock | 9.3371 | 9.3371 | 9.3371 | 9.3371 | 11200.0 |
| 2010-07-29 07:55:00 | AAPL | Stock | 9.3286 | 9.3325 | 9.3286 | 9.3325 | 64400.0 |
| 2010-07-29 07:56:00 | AAPL | Stock | 9.3289 | 9.3289 | 9.325 | 9.3268 | 34300.0 |
| 2010-07-29 07:57:00 | AAPL | Stock | 9.3268 | 9.3268 | 9.3268 | 9.3268 | 2800.0 |
| 2010-07-29 07:58:00 | AAPL | Stock | 9.3293 | 9.3293 | 9.325 | 9.325 | 61600.0 |
| 2010-07-29 08:00:00 | AAPL | Stock | 9.3296 | 9.3311 | 9.3289 | 9.3289 | 62160.0 |
| 2010-07-29 08:01:00 | AAPL | Stock | 9.3329 | 9.3343 | 9.3286 | 9.3304 | 71512.0 |
| 2010-07-29 08:02:00 | AAPL | Stock | 9.3293 | 9.3304 | 9.3254 | 9.3254 | 56000.0 |
| 2010-07-29 08:03:00 | AAPL | Stock | 9.3318 | 9.3318 | 9.3304 | 9.3304 | 5600.0 |
| 2010-07-29 08:05:00 | AAPL | Stock | 9.3289 | 9.3289 | 9.3289 | 9.3289 | 2800.0 |
| 2010-07-29 08:09:00 | AAPL | Stock | 9.3225 | 9.3225 | 9.3161 | 9.3179 | 43960.0 |
| 2010-07-29 08:10:00 | AAPL | Stock | 9.3175 | 9.3175 | 9.3089 | 9.3089 | 5880.0 |
| 2010-07-29 08:11:00 | AAPL | Stock | 9.3093 | 9.3125 | 9.3093 | 9.3125 | 5600.0 |
| 2010-07-29 08:12:00 | AAPL | Stock | 9.3171 | 9.3246 | 9.3171 | 9.3246 | 62048.0 |
| 2010-07-29 08:13:00 | AAPL | Stock | 9.3239 | 9.325 | 9.3214 | 9.3214 | 38080.0 |
| 2010-07-29 08:15:00 | AAPL | Stock | 9.3207 | 9.3207 | 9.3207 | 9.3207 | 3640.0 |
| 2010-07-29 08:16:00 | AAPL | Stock | 9.3214 | 9.3214 | 9.3214 | 9.3214 | 5600.0 |
| 2010-07-29 08:18:00 | AAPL | Stock | 9.3196 | 9.3196 | 9.3196 | 9.3196 | 2800.0 |
| 2010-07-29 08:19:00 | AAPL | Stock | 9.3182 | 9.3182 | 9.3182 | 9.3182 | 8400.0 |
| 2010-07-29 08:20:00 | AAPL | Stock | 9.3182 | 9.3182 | 9.3086 | 9.3086 | 86800.0 |
| 2010-07-29 08:21:00 | AAPL | Stock | 9.3125 | 9.3125 | 9.3125 | 9.3125 | 2800.0 |
| 2010-07-29 08:23:00 | AAPL | Stock | 9.3125 | 9.3125 | 9.3125 | 9.3125 | 8652.0 |
| 2010-07-29 08:25:00 | AAPL | Stock | 9.3125 | 9.3125 | 9.3089 | 9.3089 | 10948.0 |
| 2010-07-29 08:26:00 | AAPL | Stock | 9.3089 | 9.3089 | 9.3054 | 9.3054 | 16800.0 |
| 2010-07-29 08:27:00 | AAPL | Stock | 9.3054 | 9.3054 | 9.3054 | 9.3054 | 2800.0 |
| 2010-07-29 08:28:00 | AAPL | Stock | 9.3054 | 9.3211 | 9.305 | 9.3107 | 82124.0 |
| 2010-07-29 08:29:00 | AAPL | Stock | 9.3179 | 9.3179 | 9.3179 | 9.3179 | 5600.0 |
| 2010-07-29 08:30:00 | AAPL | Stock | 9.3207 | 9.3286 | 9.3196 | 9.3214 | 195020.0 |
| 2010-07-29 08:31:00 | AAPL | Stock | 9.3214 | 9.3214 | 9.3114 | 9.3211 | 53200.0 |
| 2010-07-29 08:32:00 | AAPL | Stock | 9.3193 | 9.3211 | 9.3168 | 9.3207 | 82572.0 |
> showing 50 of 961,678 rows — these rows as CSV