PREVIEW / stock_1min / 2014-06-03
file: by_date/stock_1min/2014/2014-06-03.parquet size: 14.6 MB rows: 1,077,846 symbols: 2,864
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-03 04:43:00 | AAPL | Stock | 22.3464 | 22.3464 | 22.3254 | 22.3254 | 8400.0 |
| 2014-06-03 04:54:00 | AAPL | Stock | 22.3232 | 22.3232 | 22.3232 | 22.3232 | 2800.0 |
| 2014-06-03 05:24:00 | AAPL | Stock | 22.3214 | 22.3214 | 22.3214 | 22.3214 | 5600.0 |
| 2014-06-03 05:34:00 | AAPL | Stock | 22.3214 | 22.3214 | 22.3214 | 22.3214 | 8400.0 |
| 2014-06-03 05:35:00 | AAPL | Stock | 22.3214 | 22.3214 | 22.3214 | 22.3214 | 2800.0 |
| 2014-06-03 05:47:00 | AAPL | Stock | 22.3361 | 22.3361 | 22.3361 | 22.3361 | 2828.0 |
| 2014-06-03 05:56:00 | AAPL | Stock | 22.3271 | 22.3271 | 22.3271 | 22.3271 | 2800.0 |
| 2014-06-03 06:14:00 | AAPL | Stock | 22.3325 | 22.3325 | 22.3325 | 22.3325 | 5600.0 |
| 2014-06-03 06:15:00 | AAPL | Stock | 22.3339 | 22.3339 | 22.3339 | 22.3339 | 5516.0 |
| 2014-06-03 06:26:00 | AAPL | Stock | 22.3304 | 22.3304 | 22.3304 | 22.3304 | 2800.0 |
| 2014-06-03 06:34:00 | AAPL | Stock | 22.3357 | 22.3357 | 22.3357 | 22.3357 | 7000.0 |
| 2014-06-03 06:48:00 | AAPL | Stock | 22.3539 | 22.3539 | 22.3539 | 22.3539 | 7000.0 |
| 2014-06-03 06:49:00 | AAPL | Stock | 22.3539 | 22.3539 | 22.3539 | 22.3539 | 11648.0 |
| 2014-06-03 06:57:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3571 | 22.3571 | 2800.0 |
| 2014-06-03 07:03:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3571 | 22.3571 | 2800.0 |
| 2014-06-03 07:04:00 | AAPL | Stock | 22.3357 | 22.3396 | 22.3357 | 22.3396 | 5600.0 |
| 2014-06-03 07:05:00 | AAPL | Stock | 22.3357 | 22.3357 | 22.3339 | 22.3339 | 9800.0 |
| 2014-06-03 07:06:00 | AAPL | Stock | 22.3393 | 22.3393 | 22.3393 | 22.3393 | 5236.0 |
| 2014-06-03 07:07:00 | AAPL | Stock | 22.3304 | 22.3304 | 22.3304 | 22.3304 | 2800.0 |
| 2014-06-03 07:12:00 | AAPL | Stock | 22.3321 | 22.3321 | 22.3321 | 22.3321 | 5600.0 |
| 2014-06-03 07:19:00 | AAPL | Stock | 22.3357 | 22.3361 | 22.3296 | 22.3361 | 36120.0 |
| 2014-06-03 07:23:00 | AAPL | Stock | 22.3393 | 22.3393 | 22.3393 | 22.3393 | 5600.0 |
| 2014-06-03 07:25:00 | AAPL | Stock | 22.345 | 22.345 | 22.345 | 22.345 | 2800.0 |
| 2014-06-03 07:26:00 | AAPL | Stock | 22.3536 | 22.3679 | 22.3536 | 22.3679 | 29148.0 |
| 2014-06-03 07:27:00 | AAPL | Stock | 22.3711 | 22.3711 | 22.3643 | 22.3643 | 30800.0 |
| 2014-06-03 07:29:00 | AAPL | Stock | 22.365 | 22.365 | 22.3643 | 22.3643 | 30800.0 |
| 2014-06-03 07:34:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3571 | 22.3571 | 2800.0 |
| 2014-06-03 07:35:00 | AAPL | Stock | 22.3568 | 22.3568 | 22.3457 | 22.3457 | 48748.0 |
| 2014-06-03 07:36:00 | AAPL | Stock | 22.34 | 22.34 | 22.34 | 22.34 | 2800.0 |
| 2014-06-03 07:38:00 | AAPL | Stock | 22.3418 | 22.3418 | 22.3418 | 22.3418 | 4732.0 |
| 2014-06-03 07:40:00 | AAPL | Stock | 22.3482 | 22.3482 | 22.3482 | 22.3482 | 5600.0 |
| 2014-06-03 07:41:00 | AAPL | Stock | 22.3393 | 22.3393 | 22.3393 | 22.3393 | 5600.0 |
| 2014-06-03 07:43:00 | AAPL | Stock | 22.3414 | 22.3414 | 22.3414 | 22.3414 | 2800.0 |
| 2014-06-03 07:44:00 | AAPL | Stock | 22.3414 | 22.3421 | 22.3414 | 22.3421 | 11200.0 |
| 2014-06-03 07:45:00 | AAPL | Stock | 22.3564 | 22.3564 | 22.3564 | 22.3564 | 5600.0 |
| 2014-06-03 07:47:00 | AAPL | Stock | 22.345 | 22.345 | 22.3429 | 22.3429 | 25200.0 |
| 2014-06-03 07:58:00 | AAPL | Stock | 22.35 | 22.35 | 22.35 | 22.35 | 2800.0 |
| 2014-06-03 08:00:00 | AAPL | Stock | 22.3554 | 22.3714 | 22.3379 | 22.3393 | 109900.0 |
| 2014-06-03 08:01:00 | AAPL | Stock | 22.3325 | 22.3371 | 22.3325 | 22.3357 | 30800.0 |
| 2014-06-03 08:03:00 | AAPL | Stock | 22.3436 | 22.3436 | 22.3425 | 22.3429 | 23072.0 |
| 2014-06-03 08:04:00 | AAPL | Stock | 22.3429 | 22.3429 | 22.3429 | 22.3429 | 12068.0 |
| 2014-06-03 08:06:00 | AAPL | Stock | 22.3411 | 22.3411 | 22.3411 | 22.3411 | 4200.0 |
| 2014-06-03 08:08:00 | AAPL | Stock | 22.3393 | 22.3393 | 22.3393 | 22.3393 | 11900.0 |
| 2014-06-03 08:10:00 | AAPL | Stock | 22.3446 | 22.3446 | 22.3446 | 22.3446 | 2800.0 |
| 2014-06-03 08:12:00 | AAPL | Stock | 22.3414 | 22.3468 | 22.3414 | 22.3468 | 7308.0 |
| 2014-06-03 08:14:00 | AAPL | Stock | 22.3468 | 22.3536 | 22.3468 | 22.3536 | 41776.0 |
| 2014-06-03 08:18:00 | AAPL | Stock | 22.3571 | 22.3661 | 22.3571 | 22.3661 | 11200.0 |
| 2014-06-03 08:19:00 | AAPL | Stock | 22.3696 | 22.3696 | 22.3671 | 22.3696 | 19600.0 |
| 2014-06-03 08:20:00 | AAPL | Stock | 22.3746 | 22.3746 | 22.3571 | 22.3571 | 60760.0 |
| 2014-06-03 08:21:00 | AAPL | Stock | 22.3625 | 22.3625 | 22.3625 | 22.3625 | 11340.0 |
> showing 50 of 1,077,846 rows — these rows as CSV