PREVIEW / stock_1min / 2017-11-22
file: by_date/stock_1min/2017/2017-11-22.parquet size: 14.2 MB rows: 1,028,492 symbols: 2,445
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-22 04:10:00 | AAPL | Stock | 43.3 | 43.3 | 43.3 | 43.3 | 800.0 |
| 2017-11-22 04:12:00 | AAPL | Stock | 43.36 | 43.36 | 43.36 | 43.36 | 532.0 |
| 2017-11-22 04:13:00 | AAPL | Stock | 43.3475 | 43.3475 | 43.3475 | 43.3475 | 400.0 |
| 2017-11-22 04:33:00 | AAPL | Stock | 43.3125 | 43.3125 | 43.3125 | 43.3125 | 720.0 |
| 2017-11-22 04:53:00 | AAPL | Stock | 43.3325 | 43.3325 | 43.3325 | 43.3325 | 1944.0 |
| 2017-11-22 04:54:00 | AAPL | Stock | 43.3325 | 43.3325 | 43.3325 | 43.3325 | 656.0 |
| 2017-11-22 04:57:00 | AAPL | Stock | 43.3075 | 43.3075 | 43.3075 | 43.3075 | 400.0 |
| 2017-11-22 05:00:00 | AAPL | Stock | 43.3325 | 43.3325 | 43.3325 | 43.3325 | 3948.0 |
| 2017-11-22 05:02:00 | AAPL | Stock | 43.3325 | 43.3325 | 43.3325 | 43.3325 | 400.0 |
| 2017-11-22 05:07:00 | AAPL | Stock | 43.3325 | 43.3325 | 43.3325 | 43.3325 | 400.0 |
| 2017-11-22 05:13:00 | AAPL | Stock | 43.3325 | 43.3325 | 43.3325 | 43.3325 | 5236.0 |
| 2017-11-22 05:36:00 | AAPL | Stock | 43.3325 | 43.3325 | 43.3325 | 43.3325 | 400.0 |
| 2017-11-22 05:47:00 | AAPL | Stock | 43.325 | 43.325 | 43.325 | 43.325 | 400.0 |
| 2017-11-22 05:51:00 | AAPL | Stock | 43.32 | 43.32 | 43.32 | 43.32 | 1200.0 |
| 2017-11-22 05:59:00 | AAPL | Stock | 43.3025 | 43.3025 | 43.3 | 43.3 | 3276.0 |
| 2017-11-22 06:08:00 | AAPL | Stock | 43.3025 | 43.3025 | 43.3025 | 43.3025 | 800.0 |
| 2017-11-22 06:16:00 | AAPL | Stock | 43.325 | 43.325 | 43.325 | 43.325 | 400.0 |
| 2017-11-22 06:27:00 | AAPL | Stock | 43.305 | 43.305 | 43.305 | 43.305 | 400.0 |
| 2017-11-22 06:57:00 | AAPL | Stock | 43.3175 | 43.3175 | 43.315 | 43.315 | 800.0 |
| 2017-11-22 07:00:00 | AAPL | Stock | 43.305 | 43.3325 | 43.305 | 43.3325 | 6760.0 |
| 2017-11-22 07:01:00 | AAPL | Stock | 43.3475 | 43.3475 | 43.3475 | 43.3475 | 1156.0 |
| 2017-11-22 07:02:00 | AAPL | Stock | 43.36 | 43.375 | 43.36 | 43.375 | 17600.0 |
| 2017-11-22 07:06:00 | AAPL | Stock | 43.375 | 43.375 | 43.375 | 43.375 | 6300.0 |
| 2017-11-22 07:07:00 | AAPL | Stock | 43.3925 | 43.3925 | 43.3925 | 43.3925 | 1600.0 |
| 2017-11-22 07:08:00 | AAPL | Stock | 43.3775 | 43.3775 | 43.375 | 43.375 | 2500.0 |
| 2017-11-22 07:09:00 | AAPL | Stock | 43.375 | 43.375 | 43.375 | 43.375 | 1984.0 |
| 2017-11-22 07:10:00 | AAPL | Stock | 43.375 | 43.375 | 43.365 | 43.365 | 3988.0 |
| 2017-11-22 07:11:00 | AAPL | Stock | 43.3925 | 43.3975 | 43.3925 | 43.3975 | 1860.0 |
| 2017-11-22 07:15:00 | AAPL | Stock | 43.4125 | 43.4125 | 43.4125 | 43.4125 | 800.0 |
| 2017-11-22 07:16:00 | AAPL | Stock | 43.4225 | 43.4225 | 43.4225 | 43.4225 | 772.0 |
| 2017-11-22 07:17:00 | AAPL | Stock | 43.4225 | 43.425 | 43.4225 | 43.425 | 1628.0 |
| 2017-11-22 07:18:00 | AAPL | Stock | 43.4375 | 43.4375 | 43.4375 | 43.4375 | 400.0 |
| 2017-11-22 07:22:00 | AAPL | Stock | 43.425 | 43.425 | 43.425 | 43.425 | 1900.0 |
| 2017-11-22 07:23:00 | AAPL | Stock | 43.43 | 43.435 | 43.43 | 43.435 | 2252.0 |
| 2017-11-22 07:24:00 | AAPL | Stock | 43.4125 | 43.4125 | 43.4125 | 43.4125 | 400.0 |
| 2017-11-22 07:25:00 | AAPL | Stock | 43.4125 | 43.4125 | 43.4125 | 43.4125 | 1564.0 |
| 2017-11-22 07:26:00 | AAPL | Stock | 43.4125 | 43.4125 | 43.4125 | 43.4125 | 2288.0 |
| 2017-11-22 07:29:00 | AAPL | Stock | 43.4125 | 43.4175 | 43.4125 | 43.4125 | 6856.0 |
| 2017-11-22 07:31:00 | AAPL | Stock | 43.39 | 43.3975 | 43.3775 | 43.39 | 7200.0 |
| 2017-11-22 07:33:00 | AAPL | Stock | 43.39 | 43.39 | 43.39 | 43.39 | 2000.0 |
| 2017-11-22 07:34:00 | AAPL | Stock | 43.39 | 43.39 | 43.39 | 43.39 | 800.0 |
| 2017-11-22 07:36:00 | AAPL | Stock | 43.39 | 43.39 | 43.365 | 43.365 | 11792.0 |
| 2017-11-22 07:38:00 | AAPL | Stock | 43.3875 | 43.3875 | 43.3875 | 43.3875 | 400.0 |
| 2017-11-22 07:39:00 | AAPL | Stock | 43.4 | 43.4 | 43.39 | 43.39 | 5560.0 |
| 2017-11-22 07:42:00 | AAPL | Stock | 43.39 | 43.39 | 43.375 | 43.375 | 3852.0 |
| 2017-11-22 07:43:00 | AAPL | Stock | 43.4 | 43.4 | 43.4 | 43.4 | 400.0 |
| 2017-11-22 07:47:00 | AAPL | Stock | 43.41 | 43.41 | 43.41 | 43.41 | 400.0 |
| 2017-11-22 07:50:00 | AAPL | Stock | 43.41 | 43.41 | 43.41 | 43.41 | 400.0 |
| 2017-11-22 07:52:00 | AAPL | Stock | 43.4075 | 43.41 | 43.4075 | 43.41 | 4400.0 |
| 2017-11-22 07:53:00 | AAPL | Stock | 43.41 | 43.41 | 43.4075 | 43.4075 | 7600.0 |
> showing 50 of 1,028,492 rows — these rows as CSV