PREVIEW / stock_1min / 2014-04-03
file: by_date/stock_1min/2014/2014-04-03.parquet size: 14.4 MB rows: 1,060,986 symbols: 2,866
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-04-03 06:24:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 2800.0 |
| 2014-04-03 06:50:00 | AAPL | Stock | 19.3918 | 19.3918 | 19.3918 | 19.3918 | 2800.0 |
| 2014-04-03 07:11:00 | AAPL | Stock | 19.3779 | 19.3779 | 19.3779 | 19.3779 | 2800.0 |
| 2014-04-03 07:36:00 | AAPL | Stock | 19.3682 | 19.3682 | 19.295 | 19.295 | 55748.0 |
| 2014-04-03 07:40:00 | AAPL | Stock | 19.3389 | 19.3389 | 19.3389 | 19.3389 | 2800.0 |
| 2014-04-03 07:41:00 | AAPL | Stock | 19.3364 | 19.3364 | 19.3364 | 19.3364 | 2800.0 |
| 2014-04-03 07:53:00 | AAPL | Stock | 19.3475 | 19.3475 | 19.3475 | 19.3475 | 2800.0 |
| 2014-04-03 07:58:00 | AAPL | Stock | 19.3568 | 19.3568 | 19.3568 | 19.3568 | 2800.0 |
| 2014-04-03 08:00:00 | AAPL | Stock | 19.3464 | 19.3464 | 19.3464 | 19.3464 | 8400.0 |
| 2014-04-03 08:02:00 | AAPL | Stock | 19.375 | 19.375 | 19.375 | 19.375 | 11200.0 |
| 2014-04-03 08:04:00 | AAPL | Stock | 19.3571 | 19.3571 | 19.3536 | 19.3536 | 18228.0 |
| 2014-04-03 08:05:00 | AAPL | Stock | 19.3529 | 19.3529 | 19.3482 | 19.3482 | 22400.0 |
| 2014-04-03 08:07:00 | AAPL | Stock | 19.3446 | 19.3446 | 19.3375 | 19.3375 | 42924.0 |
| 2014-04-03 08:08:00 | AAPL | Stock | 19.3239 | 19.3239 | 19.3239 | 19.3239 | 6076.0 |
| 2014-04-03 08:09:00 | AAPL | Stock | 19.3239 | 19.3239 | 19.3214 | 19.3214 | 38640.0 |
| 2014-04-03 08:13:00 | AAPL | Stock | 19.3393 | 19.3393 | 19.3393 | 19.3393 | 2800.0 |
| 2014-04-03 08:14:00 | AAPL | Stock | 19.3304 | 19.3464 | 19.3236 | 19.3464 | 31640.0 |
| 2014-04-03 08:17:00 | AAPL | Stock | 19.3236 | 19.325 | 19.3236 | 19.325 | 5600.0 |
| 2014-04-03 08:18:00 | AAPL | Stock | 19.325 | 19.325 | 19.325 | 19.325 | 2800.0 |
| 2014-04-03 08:20:00 | AAPL | Stock | 19.325 | 19.325 | 19.3243 | 19.325 | 16380.0 |
| 2014-04-03 08:21:00 | AAPL | Stock | 19.325 | 19.3293 | 19.325 | 19.325 | 98000.0 |
| 2014-04-03 08:22:00 | AAPL | Stock | 19.325 | 19.325 | 19.3243 | 19.325 | 67200.0 |
| 2014-04-03 08:23:00 | AAPL | Stock | 19.3232 | 19.325 | 19.3232 | 19.325 | 8400.0 |
| 2014-04-03 08:24:00 | AAPL | Stock | 19.325 | 19.325 | 19.3232 | 19.325 | 150920.0 |
| 2014-04-03 08:25:00 | AAPL | Stock | 19.325 | 19.325 | 19.3214 | 19.3214 | 56476.0 |
| 2014-04-03 08:26:00 | AAPL | Stock | 19.325 | 19.325 | 19.325 | 19.325 | 36400.0 |
| 2014-04-03 08:27:00 | AAPL | Stock | 19.325 | 19.325 | 19.3232 | 19.3232 | 121072.0 |
| 2014-04-03 08:28:00 | AAPL | Stock | 19.3232 | 19.3232 | 19.3214 | 19.3214 | 106400.0 |
| 2014-04-03 08:30:00 | AAPL | Stock | 19.3168 | 19.3168 | 19.3146 | 19.3157 | 11200.0 |
| 2014-04-03 08:31:00 | AAPL | Stock | 19.3232 | 19.3246 | 19.3232 | 19.3246 | 24276.0 |
| 2014-04-03 08:33:00 | AAPL | Stock | 19.3161 | 19.3161 | 19.3143 | 19.3143 | 5600.0 |
| 2014-04-03 08:34:00 | AAPL | Stock | 19.3161 | 19.3161 | 19.3161 | 19.3161 | 5152.0 |
| 2014-04-03 08:35:00 | AAPL | Stock | 19.3232 | 19.3346 | 19.3232 | 19.3346 | 33124.0 |
| 2014-04-03 08:37:00 | AAPL | Stock | 19.3268 | 19.3268 | 19.3268 | 19.3268 | 2800.0 |
| 2014-04-03 08:38:00 | AAPL | Stock | 19.3389 | 19.3389 | 19.3332 | 19.3332 | 5600.0 |
| 2014-04-03 08:39:00 | AAPL | Stock | 19.3404 | 19.3411 | 19.3404 | 19.3411 | 5936.0 |
| 2014-04-03 08:40:00 | AAPL | Stock | 19.3321 | 19.3321 | 19.3321 | 19.3321 | 8680.0 |
| 2014-04-03 08:42:00 | AAPL | Stock | 19.3321 | 19.3321 | 19.3321 | 19.3321 | 2800.0 |
| 2014-04-03 08:44:00 | AAPL | Stock | 19.3389 | 19.3389 | 19.3389 | 19.3389 | 5740.0 |
| 2014-04-03 08:52:00 | AAPL | Stock | 19.3232 | 19.3232 | 19.3225 | 19.3225 | 5600.0 |
| 2014-04-03 08:53:00 | AAPL | Stock | 19.3225 | 19.3225 | 19.3225 | 19.3225 | 11200.0 |
| 2014-04-03 08:57:00 | AAPL | Stock | 19.3225 | 19.3225 | 19.32 | 19.32 | 34216.0 |
| 2014-04-03 09:00:00 | AAPL | Stock | 19.3246 | 19.3246 | 19.3246 | 19.3246 | 2800.0 |
| 2014-04-03 09:01:00 | AAPL | Stock | 19.3321 | 19.3321 | 19.3321 | 19.3321 | 2800.0 |
| 2014-04-03 09:02:00 | AAPL | Stock | 19.3321 | 19.3321 | 19.3243 | 19.3314 | 8400.0 |
| 2014-04-03 09:03:00 | AAPL | Stock | 19.3314 | 19.3314 | 19.3214 | 19.3214 | 14196.0 |
| 2014-04-03 09:04:00 | AAPL | Stock | 19.33 | 19.33 | 19.3286 | 19.33 | 25172.0 |
| 2014-04-03 09:05:00 | AAPL | Stock | 19.33 | 19.3321 | 19.3286 | 19.3321 | 8400.0 |
| 2014-04-03 09:09:00 | AAPL | Stock | 19.3218 | 19.3218 | 19.3218 | 19.3218 | 2800.0 |
| 2014-04-03 09:10:00 | AAPL | Stock | 19.3207 | 19.3207 | 19.3207 | 19.3207 | 2800.0 |
> showing 50 of 1,060,986 rows — these rows as CSV