PREVIEW / stock_1min / 2012-06-08
file: by_date/stock_1min/2012/2012-06-08.parquet size: 12.6 MB rows: 955,308 symbols: 2,828
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-06-08 04:00:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 16660.0 |
| 2012-06-08 04:01:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 5600.0 |
| 2012-06-08 04:02:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 5740.0 |
| 2012-06-08 04:53:00 | AAPL | Stock | 20.3368 | 20.3368 | 20.3368 | 20.3368 | 2800.0 |
| 2012-06-08 05:01:00 | AAPL | Stock | 20.2611 | 20.2611 | 20.2607 | 20.2607 | 9800.0 |
| 2012-06-08 05:09:00 | AAPL | Stock | 20.3207 | 20.3207 | 20.3207 | 20.3207 | 2800.0 |
| 2012-06-08 05:10:00 | AAPL | Stock | 20.3207 | 20.3207 | 20.3207 | 20.3207 | 2800.0 |
| 2012-06-08 05:26:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 2800.0 |
| 2012-06-08 05:30:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 11200.0 |
| 2012-06-08 05:39:00 | AAPL | Stock | 20.3389 | 20.3389 | 20.3389 | 20.3389 | 11200.0 |
| 2012-06-08 05:49:00 | AAPL | Stock | 20.3682 | 20.3682 | 20.3682 | 20.3682 | 2800.0 |
| 2012-06-08 05:54:00 | AAPL | Stock | 20.3682 | 20.3682 | 20.3682 | 20.3682 | 2800.0 |
| 2012-06-08 06:10:00 | AAPL | Stock | 20.3689 | 20.3689 | 20.3689 | 20.3689 | 2800.0 |
| 2012-06-08 06:13:00 | AAPL | Stock | 20.3711 | 20.3711 | 20.3711 | 20.3711 | 2800.0 |
| 2012-06-08 06:25:00 | AAPL | Stock | 20.3711 | 20.3711 | 20.3711 | 20.3711 | 2800.0 |
| 2012-06-08 06:26:00 | AAPL | Stock | 20.3679 | 20.3679 | 20.3679 | 20.3679 | 19348.0 |
| 2012-06-08 06:30:00 | AAPL | Stock | 20.3686 | 20.3686 | 20.3686 | 20.3686 | 2800.0 |
| 2012-06-08 06:41:00 | AAPL | Stock | 20.3464 | 20.3464 | 20.3464 | 20.3464 | 8120.0 |
| 2012-06-08 06:49:00 | AAPL | Stock | 20.3575 | 20.3575 | 20.3575 | 20.3575 | 14000.0 |
| 2012-06-08 07:01:00 | AAPL | Stock | 20.3393 | 20.3393 | 20.3321 | 20.3321 | 13384.0 |
| 2012-06-08 07:02:00 | AAPL | Stock | 20.3568 | 20.3568 | 20.3407 | 20.3407 | 5600.0 |
| 2012-06-08 07:05:00 | AAPL | Stock | 20.3482 | 20.3482 | 20.3482 | 20.3482 | 2800.0 |
| 2012-06-08 07:10:00 | AAPL | Stock | 20.3321 | 20.3321 | 20.3321 | 20.3321 | 18816.0 |
| 2012-06-08 07:11:00 | AAPL | Stock | 20.3286 | 20.3286 | 20.3214 | 20.3214 | 25200.0 |
| 2012-06-08 07:12:00 | AAPL | Stock | 20.3268 | 20.3268 | 20.3268 | 20.3268 | 9800.0 |
| 2012-06-08 07:13:00 | AAPL | Stock | 20.3286 | 20.3286 | 20.3286 | 20.3286 | 5600.0 |
| 2012-06-08 07:18:00 | AAPL | Stock | 20.3325 | 20.3325 | 20.3321 | 20.3321 | 8652.0 |
| 2012-06-08 07:20:00 | AAPL | Stock | 20.3325 | 20.3325 | 20.3325 | 20.3325 | 2800.0 |
| 2012-06-08 07:21:00 | AAPL | Stock | 20.3389 | 20.3389 | 20.3389 | 20.3389 | 2800.0 |
| 2012-06-08 07:22:00 | AAPL | Stock | 20.3393 | 20.3518 | 20.3393 | 20.3518 | 5600.0 |
| 2012-06-08 07:23:00 | AAPL | Stock | 20.3514 | 20.3514 | 20.3514 | 20.3514 | 2800.0 |
| 2012-06-08 07:24:00 | AAPL | Stock | 20.3529 | 20.3575 | 20.3529 | 20.3575 | 21784.0 |
| 2012-06-08 07:25:00 | AAPL | Stock | 20.3743 | 20.375 | 20.3743 | 20.375 | 16800.0 |
| 2012-06-08 07:27:00 | AAPL | Stock | 20.3907 | 20.3907 | 20.3907 | 20.3907 | 2800.0 |
| 2012-06-08 07:28:00 | AAPL | Stock | 20.3875 | 20.3875 | 20.3875 | 20.3875 | 2800.0 |
| 2012-06-08 07:30:00 | AAPL | Stock | 20.3871 | 20.3882 | 20.3871 | 20.3882 | 8400.0 |
| 2012-06-08 07:39:00 | AAPL | Stock | 20.3857 | 20.3857 | 20.3646 | 20.3646 | 19600.0 |
| 2012-06-08 07:44:00 | AAPL | Stock | 20.3832 | 20.3836 | 20.3832 | 20.3836 | 9800.0 |
| 2012-06-08 07:48:00 | AAPL | Stock | 20.3836 | 20.3907 | 20.3836 | 20.3907 | 16800.0 |
| 2012-06-08 07:56:00 | AAPL | Stock | 20.3718 | 20.3718 | 20.3621 | 20.3621 | 22400.0 |
| 2012-06-08 07:57:00 | AAPL | Stock | 20.3764 | 20.3786 | 20.3764 | 20.3786 | 11200.0 |
| 2012-06-08 07:59:00 | AAPL | Stock | 20.3707 | 20.3707 | 20.3707 | 20.3707 | 2800.0 |
| 2012-06-08 08:00:00 | AAPL | Stock | 20.3621 | 20.3721 | 20.355 | 20.3654 | 39200.0 |
| 2012-06-08 08:01:00 | AAPL | Stock | 20.375 | 20.375 | 20.3625 | 20.3625 | 36400.0 |
| 2012-06-08 08:02:00 | AAPL | Stock | 20.3625 | 20.3743 | 20.3625 | 20.3743 | 5600.0 |
| 2012-06-08 08:03:00 | AAPL | Stock | 20.3818 | 20.3893 | 20.3789 | 20.3857 | 24360.0 |
| 2012-06-08 08:04:00 | AAPL | Stock | 20.3886 | 20.3886 | 20.3886 | 20.3886 | 3920.0 |
| 2012-06-08 08:07:00 | AAPL | Stock | 20.3839 | 20.3907 | 20.3839 | 20.3907 | 43400.0 |
| 2012-06-08 08:08:00 | AAPL | Stock | 20.3875 | 20.3921 | 20.3875 | 20.3921 | 14000.0 |
| 2012-06-08 08:09:00 | AAPL | Stock | 20.3921 | 20.3921 | 20.3821 | 20.3821 | 42896.0 |
> showing 50 of 955,308 rows — these rows as CSV