PREVIEW / stock_1min / 2012-05-30
file: by_date/stock_1min/2012/2012-05-30.parquet size: 12.7 MB rows: 952,510 symbols: 2,863
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-30 04:00:00 | AAPL | Stock | 20.3668 | 20.3668 | 20.3536 | 20.3536 | 8400.0 |
| 2012-05-30 04:15:00 | AAPL | Stock | 20.3218 | 20.3218 | 20.3218 | 20.3218 | 2800.0 |
| 2012-05-30 04:17:00 | AAPL | Stock | 20.3482 | 20.3482 | 20.3482 | 20.3482 | 5600.0 |
| 2012-05-30 04:23:00 | AAPL | Stock | 20.3482 | 20.3482 | 20.3482 | 20.3482 | 2800.0 |
| 2012-05-30 04:25:00 | AAPL | Stock | 20.3482 | 20.3482 | 20.3482 | 20.3482 | 2800.0 |
| 2012-05-30 04:29:00 | AAPL | Stock | 20.3482 | 20.3482 | 20.3482 | 20.3482 | 5768.0 |
| 2012-05-30 04:53:00 | AAPL | Stock | 20.3218 | 20.3218 | 20.3214 | 20.3214 | 5712.0 |
| 2012-05-30 05:02:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 22400.0 |
| 2012-05-30 05:20:00 | AAPL | Stock | 20.2975 | 20.2975 | 20.2975 | 20.2975 | 2800.0 |
| 2012-05-30 05:26:00 | AAPL | Stock | 20.2975 | 20.2975 | 20.2975 | 20.2975 | 2800.0 |
| 2012-05-30 05:29:00 | AAPL | Stock | 20.3357 | 20.3357 | 20.3357 | 20.3357 | 5600.0 |
| 2012-05-30 05:30:00 | AAPL | Stock | 20.3357 | 20.3357 | 20.3357 | 20.3357 | 2800.0 |
| 2012-05-30 05:33:00 | AAPL | Stock | 20.3107 | 20.3107 | 20.3107 | 20.3107 | 8400.0 |
| 2012-05-30 06:27:00 | AAPL | Stock | 20.3179 | 20.3179 | 20.3179 | 20.3179 | 16800.0 |
| 2012-05-30 06:30:00 | AAPL | Stock | 20.305 | 20.305 | 20.305 | 20.305 | 2800.0 |
| 2012-05-30 06:32:00 | AAPL | Stock | 20.3018 | 20.3018 | 20.3018 | 20.3018 | 8400.0 |
| 2012-05-30 06:34:00 | AAPL | Stock | 20.3036 | 20.3036 | 20.3036 | 20.3036 | 2800.0 |
| 2012-05-30 06:58:00 | AAPL | Stock | 20.2907 | 20.2907 | 20.2907 | 20.2907 | 2800.0 |
| 2012-05-30 07:00:00 | AAPL | Stock | 20.29 | 20.29 | 20.2543 | 20.29 | 14000.0 |
| 2012-05-30 07:01:00 | AAPL | Stock | 20.3171 | 20.3571 | 20.3079 | 20.3518 | 123648.0 |
| 2012-05-30 07:02:00 | AAPL | Stock | 20.3268 | 20.3571 | 20.3268 | 20.3414 | 19600.0 |
| 2012-05-30 07:03:00 | AAPL | Stock | 20.3304 | 20.3304 | 20.3214 | 20.3214 | 8400.0 |
| 2012-05-30 07:04:00 | AAPL | Stock | 20.3304 | 20.3482 | 20.3304 | 20.3482 | 28000.0 |
| 2012-05-30 07:05:00 | AAPL | Stock | 20.3393 | 20.3714 | 20.3393 | 20.3571 | 33824.0 |
| 2012-05-30 07:06:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 16800.0 |
| 2012-05-30 07:07:00 | AAPL | Stock | 20.3836 | 20.3836 | 20.3589 | 20.3589 | 8400.0 |
| 2012-05-30 07:10:00 | AAPL | Stock | 20.3304 | 20.3304 | 20.3211 | 20.3211 | 41860.0 |
| 2012-05-30 07:11:00 | AAPL | Stock | 20.3493 | 20.3661 | 20.3493 | 20.3661 | 53172.0 |
| 2012-05-30 07:12:00 | AAPL | Stock | 20.3239 | 20.3239 | 20.3239 | 20.3239 | 5600.0 |
| 2012-05-30 07:13:00 | AAPL | Stock | 20.3325 | 20.3325 | 20.3325 | 20.3325 | 5600.0 |
| 2012-05-30 07:14:00 | AAPL | Stock | 20.3393 | 20.3396 | 20.3304 | 20.3304 | 126532.0 |
| 2012-05-30 07:15:00 | AAPL | Stock | 20.3536 | 20.3536 | 20.3229 | 20.3232 | 8400.0 |
| 2012-05-30 07:16:00 | AAPL | Stock | 20.3221 | 20.3221 | 20.3214 | 20.3214 | 25200.0 |
| 2012-05-30 07:17:00 | AAPL | Stock | 20.3146 | 20.3146 | 20.3146 | 20.3146 | 2800.0 |
| 2012-05-30 07:19:00 | AAPL | Stock | 20.3125 | 20.3125 | 20.3125 | 20.3125 | 11228.0 |
| 2012-05-30 07:20:00 | AAPL | Stock | 20.3211 | 20.3214 | 20.3211 | 20.3214 | 16800.0 |
| 2012-05-30 07:22:00 | AAPL | Stock | 20.3393 | 20.3393 | 20.3393 | 20.3393 | 2800.0 |
| 2012-05-30 07:24:00 | AAPL | Stock | 20.3461 | 20.3461 | 20.3461 | 20.3461 | 2800.0 |
| 2012-05-30 07:25:00 | AAPL | Stock | 20.3457 | 20.3457 | 20.3457 | 20.3457 | 8540.0 |
| 2012-05-30 07:26:00 | AAPL | Stock | 20.3386 | 20.3454 | 20.3386 | 20.3454 | 8400.0 |
| 2012-05-30 07:27:00 | AAPL | Stock | 20.3411 | 20.3411 | 20.3411 | 20.3411 | 2800.0 |
| 2012-05-30 07:30:00 | AAPL | Stock | 20.3314 | 20.3339 | 20.3214 | 20.3339 | 47600.0 |
| 2012-05-30 07:31:00 | AAPL | Stock | 20.3211 | 20.3393 | 20.3211 | 20.3393 | 16800.0 |
| 2012-05-30 07:32:00 | AAPL | Stock | 20.3357 | 20.3357 | 20.3339 | 20.3339 | 5600.0 |
| 2012-05-30 07:33:00 | AAPL | Stock | 20.325 | 20.325 | 20.3214 | 20.3214 | 31500.0 |
| 2012-05-30 07:34:00 | AAPL | Stock | 20.3321 | 20.3357 | 20.3214 | 20.3357 | 22400.0 |
| 2012-05-30 07:36:00 | AAPL | Stock | 20.3386 | 20.3393 | 20.3386 | 20.3393 | 5600.0 |
| 2012-05-30 07:37:00 | AAPL | Stock | 20.3386 | 20.3386 | 20.3386 | 20.3386 | 5600.0 |
| 2012-05-30 07:39:00 | AAPL | Stock | 20.3254 | 20.35 | 20.3254 | 20.35 | 96180.0 |
| 2012-05-30 07:40:00 | AAPL | Stock | 20.3514 | 20.3514 | 20.3514 | 20.3514 | 11200.0 |
> showing 50 of 952,510 rows — these rows as CSV