PREVIEW / stock_1min / 2013-10-09
file: by_date/stock_1min/2013/2013-10-09.parquet size: 14.1 MB rows: 1,033,329 symbols: 2,874
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-10-09 04:00:00 | AAPL | Stock | 17.2857 | 17.2857 | 17.2679 | 17.2679 | 14560.0 |
| 2013-10-09 04:01:00 | AAPL | Stock | 17.2679 | 17.2679 | 17.2679 | 17.2679 | 2800.0 |
| 2013-10-09 04:03:00 | AAPL | Stock | 17.2536 | 17.2536 | 17.2536 | 17.2536 | 5040.0 |
| 2013-10-09 04:04:00 | AAPL | Stock | 17.2679 | 17.2679 | 17.2679 | 17.2679 | 5600.0 |
| 2013-10-09 04:06:00 | AAPL | Stock | 17.2679 | 17.2679 | 17.2679 | 17.2679 | 5600.0 |
| 2013-10-09 04:41:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 5600.0 |
| 2013-10-09 04:42:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 2800.0 |
| 2013-10-09 04:43:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 2800.0 |
| 2013-10-09 04:48:00 | AAPL | Stock | 17.2721 | 17.2721 | 17.2721 | 17.2721 | 2800.0 |
| 2013-10-09 05:00:00 | AAPL | Stock | 17.2857 | 17.2857 | 17.2857 | 17.2857 | 7112.0 |
| 2013-10-09 05:03:00 | AAPL | Stock | 17.2857 | 17.2857 | 17.2857 | 17.2857 | 2800.0 |
| 2013-10-09 05:17:00 | AAPL | Stock | 17.2879 | 17.2879 | 17.2879 | 17.2879 | 2800.0 |
| 2013-10-09 05:23:00 | AAPL | Stock | 17.3 | 17.3 | 17.3 | 17.3 | 19600.0 |
| 2013-10-09 05:49:00 | AAPL | Stock | 17.33 | 17.3346 | 17.33 | 17.3346 | 5600.0 |
| 2013-10-09 06:02:00 | AAPL | Stock | 17.34 | 17.34 | 17.34 | 17.34 | 2800.0 |
| 2013-10-09 06:21:00 | AAPL | Stock | 17.34 | 17.34 | 17.34 | 17.34 | 7700.0 |
| 2013-10-09 06:22:00 | AAPL | Stock | 17.34 | 17.34 | 17.34 | 17.34 | 2800.0 |
| 2013-10-09 06:43:00 | AAPL | Stock | 17.3475 | 17.3475 | 17.3475 | 17.3475 | 11200.0 |
| 2013-10-09 06:44:00 | AAPL | Stock | 17.3621 | 17.3629 | 17.3621 | 17.3629 | 11200.0 |
| 2013-10-09 06:54:00 | AAPL | Stock | 17.3482 | 17.3482 | 17.3482 | 17.3482 | 8400.0 |
| 2013-10-09 06:59:00 | AAPL | Stock | 17.3393 | 17.3393 | 17.3393 | 17.3393 | 5600.0 |
| 2013-10-09 07:03:00 | AAPL | Stock | 17.3461 | 17.3461 | 17.3461 | 17.3461 | 2800.0 |
| 2013-10-09 07:04:00 | AAPL | Stock | 17.3543 | 17.3543 | 17.34 | 17.34 | 11200.0 |
| 2013-10-09 07:06:00 | AAPL | Stock | 17.34 | 17.34 | 17.34 | 17.34 | 2800.0 |
| 2013-10-09 07:08:00 | AAPL | Stock | 17.3418 | 17.3418 | 17.3418 | 17.3418 | 3640.0 |
| 2013-10-09 07:10:00 | AAPL | Stock | 17.3393 | 17.3393 | 17.3393 | 17.3393 | 2800.0 |
| 2013-10-09 07:12:00 | AAPL | Stock | 17.3321 | 17.3321 | 17.3321 | 17.3321 | 2800.0 |
| 2013-10-09 07:17:00 | AAPL | Stock | 17.3286 | 17.3286 | 17.3286 | 17.3286 | 2800.0 |
| 2013-10-09 07:18:00 | AAPL | Stock | 17.3225 | 17.3225 | 17.3214 | 17.3214 | 9940.0 |
| 2013-10-09 07:19:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3214 | 17.3214 | 2800.0 |
| 2013-10-09 07:22:00 | AAPL | Stock | 17.3339 | 17.3339 | 17.3339 | 17.3339 | 6608.0 |
| 2013-10-09 07:23:00 | AAPL | Stock | 17.3357 | 17.3357 | 17.3357 | 17.3357 | 2800.0 |
| 2013-10-09 07:25:00 | AAPL | Stock | 17.3325 | 17.3325 | 17.3314 | 17.3314 | 7924.0 |
| 2013-10-09 07:27:00 | AAPL | Stock | 17.3304 | 17.3304 | 17.3304 | 17.3304 | 11200.0 |
| 2013-10-09 07:28:00 | AAPL | Stock | 17.3286 | 17.3286 | 17.3121 | 17.3282 | 15288.0 |
| 2013-10-09 07:31:00 | AAPL | Stock | 17.3193 | 17.3193 | 17.3193 | 17.3193 | 14000.0 |
| 2013-10-09 07:33:00 | AAPL | Stock | 17.3132 | 17.3132 | 17.3071 | 17.3071 | 8400.0 |
| 2013-10-09 07:35:00 | AAPL | Stock | 17.3129 | 17.3132 | 17.3129 | 17.3132 | 6552.0 |
| 2013-10-09 07:47:00 | AAPL | Stock | 17.3182 | 17.3304 | 17.3182 | 17.3304 | 22400.0 |
| 2013-10-09 07:48:00 | AAPL | Stock | 17.325 | 17.3357 | 17.325 | 17.3304 | 56000.0 |
| 2013-10-09 07:49:00 | AAPL | Stock | 17.3371 | 17.3371 | 17.3361 | 17.3361 | 8400.0 |
| 2013-10-09 07:51:00 | AAPL | Stock | 17.3357 | 17.3357 | 17.3357 | 17.3357 | 5600.0 |
| 2013-10-09 07:52:00 | AAPL | Stock | 17.3389 | 17.3393 | 17.3389 | 17.3393 | 14000.0 |
| 2013-10-09 07:54:00 | AAPL | Stock | 17.3393 | 17.3393 | 17.3339 | 17.3339 | 15680.0 |
| 2013-10-09 07:56:00 | AAPL | Stock | 17.3146 | 17.3304 | 17.3146 | 17.3304 | 13160.0 |
| 2013-10-09 07:58:00 | AAPL | Stock | 17.3196 | 17.3214 | 17.3196 | 17.3214 | 22736.0 |
| 2013-10-09 07:59:00 | AAPL | Stock | 17.3157 | 17.3157 | 17.3157 | 17.3157 | 8400.0 |
| 2013-10-09 08:00:00 | AAPL | Stock | 17.3114 | 17.3571 | 17.2964 | 17.2975 | 247744.0 |
| 2013-10-09 08:01:00 | AAPL | Stock | 17.1786 | 17.3157 | 17.1786 | 17.3021 | 27272.0 |
| 2013-10-09 08:02:00 | AAPL | Stock | 17.3011 | 17.3157 | 17.3 | 17.3157 | 19600.0 |
> showing 50 of 1,033,329 rows — these rows as CSV