PREVIEW / stock_1min / 2016-12-07
file: by_date/stock_1min/2016/2016-12-07.parquet size: 15.8 MB rows: 1,121,459 symbols: 2,610
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 |
|---|---|---|---|---|---|---|---|
| 2016-12-07 04:29:00 | AAPL | Stock | 27.52 | 27.52 | 27.52 | 27.52 | 400.0 |
| 2016-12-07 04:58:00 | AAPL | Stock | 27.52 | 27.52 | 27.52 | 27.52 | 400.0 |
| 2016-12-07 05:26:00 | AAPL | Stock | 27.525 | 27.525 | 27.525 | 27.525 | 1596.0 |
| 2016-12-07 05:34:00 | AAPL | Stock | 27.56 | 27.5625 | 27.56 | 27.5625 | 900.0 |
| 2016-12-07 06:00:00 | AAPL | Stock | 27.525 | 27.525 | 27.525 | 27.525 | 3944.0 |
| 2016-12-07 06:15:00 | AAPL | Stock | 27.5325 | 27.5325 | 27.5325 | 27.5325 | 400.0 |
| 2016-12-07 06:18:00 | AAPL | Stock | 27.525 | 27.525 | 27.525 | 27.525 | 648.0 |
| 2016-12-07 07:07:00 | AAPL | Stock | 27.5225 | 27.5225 | 27.5225 | 27.5225 | 1376.0 |
| 2016-12-07 07:11:00 | AAPL | Stock | 27.485 | 27.485 | 27.485 | 27.485 | 3956.0 |
| 2016-12-07 07:12:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 424.0 |
| 2016-12-07 07:20:00 | AAPL | Stock | 27.4975 | 27.5 | 27.4975 | 27.5 | 1720.0 |
| 2016-12-07 07:22:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.4975 | 27.4975 | 400.0 |
| 2016-12-07 07:30:00 | AAPL | Stock | 27.51 | 27.51 | 27.51 | 27.51 | 400.0 |
| 2016-12-07 07:31:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.4875 | 27.4875 | 3292.0 |
| 2016-12-07 07:34:00 | AAPL | Stock | 27.48 | 27.48 | 27.41 | 27.41 | 10568.0 |
| 2016-12-07 07:35:00 | AAPL | Stock | 27.4275 | 27.4275 | 27.4275 | 27.4275 | 10892.0 |
| 2016-12-07 07:36:00 | AAPL | Stock | 27.425 | 27.425 | 27.375 | 27.4 | 21012.0 |
| 2016-12-07 07:37:00 | AAPL | Stock | 27.355 | 27.355 | 27.35 | 27.35 | 4000.0 |
| 2016-12-07 07:39:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 400.0 |
| 2016-12-07 07:41:00 | AAPL | Stock | 27.3525 | 27.3525 | 27.35 | 27.35 | 4060.0 |
| 2016-12-07 07:43:00 | AAPL | Stock | 27.3625 | 27.3825 | 27.3625 | 27.3825 | 4800.0 |
| 2016-12-07 07:44:00 | AAPL | Stock | 27.3825 | 27.3875 | 27.3825 | 27.3875 | 17000.0 |
| 2016-12-07 07:45:00 | AAPL | Stock | 27.3625 | 27.3625 | 27.3625 | 27.3625 | 1160.0 |
| 2016-12-07 07:49:00 | AAPL | Stock | 27.375 | 27.4025 | 27.3725 | 27.4025 | 4736.0 |
| 2016-12-07 07:50:00 | AAPL | Stock | 27.4 | 27.4 | 27.4 | 27.4 | 2440.0 |
| 2016-12-07 07:51:00 | AAPL | Stock | 27.4 | 27.4 | 27.4 | 27.4 | 1000.0 |
| 2016-12-07 07:52:00 | AAPL | Stock | 27.4 | 27.4 | 27.4 | 27.4 | 400.0 |
| 2016-12-07 07:53:00 | AAPL | Stock | 27.3975 | 27.3975 | 27.3975 | 27.3975 | 400.0 |
| 2016-12-07 07:54:00 | AAPL | Stock | 27.375 | 27.375 | 27.35 | 27.35 | 11860.0 |
| 2016-12-07 07:55:00 | AAPL | Stock | 27.35 | 27.35 | 27.34 | 27.34 | 2000.0 |
| 2016-12-07 07:58:00 | AAPL | Stock | 27.3275 | 27.3275 | 27.3275 | 27.3275 | 800.0 |
| 2016-12-07 07:59:00 | AAPL | Stock | 27.3275 | 27.3275 | 27.2625 | 27.2625 | 40380.0 |
| 2016-12-07 08:00:00 | AAPL | Stock | 27.31 | 27.515 | 27.31 | 27.325 | 23268.0 |
| 2016-12-07 08:01:00 | AAPL | Stock | 27.3125 | 27.3125 | 27.3125 | 27.3125 | 984.0 |
| 2016-12-07 08:02:00 | AAPL | Stock | 27.3175 | 27.3175 | 27.3125 | 27.3175 | 5600.0 |
| 2016-12-07 08:03:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 400.0 |
| 2016-12-07 08:04:00 | AAPL | Stock | 27.325 | 27.325 | 27.2725 | 27.2725 | 12600.0 |
| 2016-12-07 08:05:00 | AAPL | Stock | 27.2675 | 27.2875 | 27.2625 | 27.2875 | 21688.0 |
| 2016-12-07 08:06:00 | AAPL | Stock | 27.2825 | 27.2825 | 27.265 | 27.265 | 1872.0 |
| 2016-12-07 08:07:00 | AAPL | Stock | 27.275 | 27.2825 | 27.2625 | 27.2625 | 6060.0 |
| 2016-12-07 08:08:00 | AAPL | Stock | 27.2625 | 27.275 | 27.2525 | 27.2525 | 15068.0 |
| 2016-12-07 08:09:00 | AAPL | Stock | 27.2525 | 27.2525 | 27.25 | 27.25 | 5688.0 |
| 2016-12-07 08:11:00 | AAPL | Stock | 27.265 | 27.265 | 27.2075 | 27.2075 | 23596.0 |
| 2016-12-07 08:12:00 | AAPL | Stock | 27.2375 | 27.2475 | 27.2375 | 27.2375 | 3472.0 |
| 2016-12-07 08:13:00 | AAPL | Stock | 27.25 | 27.25 | 27.2375 | 27.2475 | 3664.0 |
| 2016-12-07 08:14:00 | AAPL | Stock | 27.2475 | 27.2675 | 27.2475 | 27.2675 | 6176.0 |
| 2016-12-07 08:15:00 | AAPL | Stock | 27.2625 | 27.27 | 27.25 | 27.25 | 5880.0 |
| 2016-12-07 08:16:00 | AAPL | Stock | 27.25 | 27.27 | 27.25 | 27.27 | 3120.0 |
| 2016-12-07 08:17:00 | AAPL | Stock | 27.2875 | 27.3125 | 27.2875 | 27.295 | 8400.0 |
| 2016-12-07 08:18:00 | AAPL | Stock | 27.2975 | 27.35 | 27.2875 | 27.2875 | 45064.0 |
> showing 50 of 1,121,459 rows — these rows as CSV