PREVIEW / stock_1min / 2013-11-08
file: by_date/stock_1min/2013/2013-11-08.parquet size: 14.4 MB rows: 1,053,849 symbols: 2,875
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-08 04:28:00 | AAPL | Stock | 18.3496 | 18.3496 | 18.3496 | 18.3496 | 2800.0 |
| 2013-11-08 05:47:00 | AAPL | Stock | 18.3393 | 18.3393 | 18.3393 | 18.3393 | 2800.0 |
| 2013-11-08 06:05:00 | AAPL | Stock | 18.35 | 18.35 | 18.35 | 18.35 | 2800.0 |
| 2013-11-08 06:27:00 | AAPL | Stock | 18.3618 | 18.3618 | 18.3618 | 18.3618 | 2800.0 |
| 2013-11-08 06:30:00 | AAPL | Stock | 18.3596 | 18.3746 | 18.3596 | 18.3746 | 21224.0 |
| 2013-11-08 06:31:00 | AAPL | Stock | 18.3743 | 18.3743 | 18.3743 | 18.3743 | 5600.0 |
| 2013-11-08 06:41:00 | AAPL | Stock | 18.3714 | 18.3714 | 18.3714 | 18.3714 | 5600.0 |
| 2013-11-08 06:44:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
| 2013-11-08 06:49:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 5600.0 |
| 2013-11-08 07:00:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 2800.0 |
| 2013-11-08 07:09:00 | AAPL | Stock | 18.3654 | 18.3679 | 18.3654 | 18.3679 | 8400.0 |
| 2013-11-08 07:10:00 | AAPL | Stock | 18.37 | 18.3807 | 18.3661 | 18.3661 | 48244.0 |
| 2013-11-08 07:12:00 | AAPL | Stock | 18.3582 | 18.3582 | 18.3582 | 18.3582 | 3416.0 |
| 2013-11-08 07:14:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 2800.0 |
| 2013-11-08 07:24:00 | AAPL | Stock | 18.3564 | 18.3607 | 18.3536 | 18.3568 | 36596.0 |
| 2013-11-08 07:36:00 | AAPL | Stock | 18.3561 | 18.3561 | 18.3482 | 18.3482 | 5600.0 |
| 2013-11-08 07:37:00 | AAPL | Stock | 18.3482 | 18.3482 | 18.345 | 18.345 | 7700.0 |
| 2013-11-08 07:41:00 | AAPL | Stock | 18.3404 | 18.3404 | 18.3339 | 18.3339 | 25396.0 |
| 2013-11-08 07:44:00 | AAPL | Stock | 18.3304 | 18.3304 | 18.3304 | 18.3304 | 2800.0 |
| 2013-11-08 07:45:00 | AAPL | Stock | 18.3389 | 18.3389 | 18.3221 | 18.3221 | 8400.0 |
| 2013-11-08 07:47:00 | AAPL | Stock | 18.3432 | 18.3432 | 18.3432 | 18.3432 | 2800.0 |
| 2013-11-08 07:48:00 | AAPL | Stock | 18.3304 | 18.3304 | 18.3304 | 18.3304 | 5600.0 |
| 2013-11-08 07:51:00 | AAPL | Stock | 18.3314 | 18.3314 | 18.3314 | 18.3314 | 5600.0 |
| 2013-11-08 07:54:00 | AAPL | Stock | 18.3304 | 18.3304 | 18.3304 | 18.3304 | 5600.0 |
| 2013-11-08 07:57:00 | AAPL | Stock | 18.3304 | 18.3304 | 18.3232 | 18.3232 | 28000.0 |
| 2013-11-08 07:59:00 | AAPL | Stock | 18.3336 | 18.3336 | 18.3336 | 18.3336 | 2800.0 |
| 2013-11-08 08:00:00 | AAPL | Stock | 18.3325 | 18.3654 | 18.3243 | 18.3339 | 83720.0 |
| 2013-11-08 08:01:00 | AAPL | Stock | 18.3232 | 18.3232 | 18.3036 | 18.3036 | 11200.0 |
| 2013-11-08 08:02:00 | AAPL | Stock | 18.3033 | 18.3243 | 18.3033 | 18.3232 | 156660.0 |
| 2013-11-08 08:03:00 | AAPL | Stock | 18.3239 | 18.3239 | 18.3232 | 18.3232 | 5600.0 |
| 2013-11-08 08:05:00 | AAPL | Stock | 18.3354 | 18.3354 | 18.3354 | 18.3354 | 14000.0 |
| 2013-11-08 08:06:00 | AAPL | Stock | 18.3354 | 18.3354 | 18.3354 | 18.3354 | 12040.0 |
| 2013-11-08 08:07:00 | AAPL | Stock | 18.3304 | 18.3304 | 18.3304 | 18.3304 | 5320.0 |
| 2013-11-08 08:08:00 | AAPL | Stock | 18.3321 | 18.3354 | 18.3268 | 18.3354 | 20188.0 |
| 2013-11-08 08:09:00 | AAPL | Stock | 18.3357 | 18.3357 | 18.3357 | 18.3357 | 8540.0 |
| 2013-11-08 08:10:00 | AAPL | Stock | 18.3429 | 18.3429 | 18.3361 | 18.3361 | 5600.0 |
| 2013-11-08 08:11:00 | AAPL | Stock | 18.3389 | 18.3389 | 18.3389 | 18.3389 | 2800.0 |
| 2013-11-08 08:12:00 | AAPL | Stock | 18.3393 | 18.3443 | 18.3393 | 18.3439 | 25200.0 |
| 2013-11-08 08:14:00 | AAPL | Stock | 18.3464 | 18.3507 | 18.3464 | 18.3464 | 19740.0 |
| 2013-11-08 08:16:00 | AAPL | Stock | 18.3482 | 18.3482 | 18.3482 | 18.3482 | 5936.0 |
| 2013-11-08 08:18:00 | AAPL | Stock | 18.3511 | 18.3625 | 18.3511 | 18.3625 | 56644.0 |
| 2013-11-08 08:19:00 | AAPL | Stock | 18.3711 | 18.3711 | 18.3711 | 18.3711 | 2800.0 |
| 2013-11-08 08:20:00 | AAPL | Stock | 18.3554 | 18.3554 | 18.3554 | 18.3554 | 2800.0 |
| 2013-11-08 08:21:00 | AAPL | Stock | 18.3657 | 18.3675 | 18.3657 | 18.3675 | 25340.0 |
| 2013-11-08 08:23:00 | AAPL | Stock | 18.3579 | 18.3579 | 18.3571 | 18.3571 | 14840.0 |
| 2013-11-08 08:24:00 | AAPL | Stock | 18.3564 | 18.3564 | 18.3564 | 18.3564 | 3388.0 |
| 2013-11-08 08:25:00 | AAPL | Stock | 18.3564 | 18.3564 | 18.3514 | 18.3529 | 34944.0 |
| 2013-11-08 08:27:00 | AAPL | Stock | 18.3521 | 18.3521 | 18.3425 | 18.3425 | 23240.0 |
| 2013-11-08 08:28:00 | AAPL | Stock | 18.3511 | 18.3518 | 18.35 | 18.35 | 46928.0 |
| 2013-11-08 08:29:00 | AAPL | Stock | 18.3457 | 18.3489 | 18.3429 | 18.3489 | 32032.0 |
> showing 50 of 1,053,849 rows — these rows as CSV