PREVIEW / stock_1min / 2018-02-07
file: by_date/stock_1min/2018/2018-02-07.parquet size: 16.4 MB rows: 1,150,792 symbols: 2,400
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-07 04:00:00 | AAPL | Stock | 40.4125 | 40.45 | 40.4125 | 40.45 | 3732.0 |
| 2018-02-07 04:01:00 | AAPL | Stock | 40.4125 | 40.4125 | 40.4125 | 40.4125 | 1600.0 |
| 2018-02-07 04:03:00 | AAPL | Stock | 40.35 | 40.35 | 40.35 | 40.35 | 2000.0 |
| 2018-02-07 04:05:00 | AAPL | Stock | 40.35 | 40.35 | 40.35 | 40.35 | 2000.0 |
| 2018-02-07 04:07:00 | AAPL | Stock | 40.41 | 40.41 | 40.37 | 40.37 | 1600.0 |
| 2018-02-07 04:08:00 | AAPL | Stock | 40.3875 | 40.3875 | 40.3875 | 40.3875 | 800.0 |
| 2018-02-07 04:21:00 | AAPL | Stock | 40.325 | 40.325 | 40.325 | 40.325 | 800.0 |
| 2018-02-07 04:22:00 | AAPL | Stock | 40.35 | 40.35 | 40.35 | 40.35 | 2552.0 |
| 2018-02-07 04:26:00 | AAPL | Stock | 40.35 | 40.4 | 40.35 | 40.4 | 3808.0 |
| 2018-02-07 04:27:00 | AAPL | Stock | 40.4125 | 40.42 | 40.4125 | 40.42 | 1200.0 |
| 2018-02-07 04:29:00 | AAPL | Stock | 40.4375 | 40.45 | 40.4375 | 40.45 | 2968.0 |
| 2018-02-07 04:52:00 | AAPL | Stock | 40.39 | 40.39 | 40.39 | 40.39 | 400.0 |
| 2018-02-07 04:58:00 | AAPL | Stock | 40.315 | 40.315 | 40.315 | 40.315 | 400.0 |
| 2018-02-07 05:03:00 | AAPL | Stock | 40.375 | 40.375 | 40.375 | 40.375 | 1600.0 |
| 2018-02-07 05:04:00 | AAPL | Stock | 40.375 | 40.375 | 40.375 | 40.375 | 400.0 |
| 2018-02-07 05:08:00 | AAPL | Stock | 40.405 | 40.405 | 40.405 | 40.405 | 1200.0 |
| 2018-02-07 05:09:00 | AAPL | Stock | 40.3925 | 40.395 | 40.3925 | 40.395 | 2800.0 |
| 2018-02-07 05:10:00 | AAPL | Stock | 40.405 | 40.4075 | 40.405 | 40.4075 | 4800.0 |
| 2018-02-07 05:13:00 | AAPL | Stock | 40.445 | 40.445 | 40.445 | 40.445 | 400.0 |
| 2018-02-07 05:15:00 | AAPL | Stock | 40.47 | 40.47 | 40.47 | 40.47 | 1648.0 |
| 2018-02-07 05:16:00 | AAPL | Stock | 40.475 | 40.475 | 40.475 | 40.475 | 2000.0 |
| 2018-02-07 05:19:00 | AAPL | Stock | 40.4925 | 40.4925 | 40.4925 | 40.4925 | 400.0 |
| 2018-02-07 05:23:00 | AAPL | Stock | 40.4675 | 40.4675 | 40.4675 | 40.4675 | 400.0 |
| 2018-02-07 05:28:00 | AAPL | Stock | 40.43 | 40.43 | 40.43 | 40.43 | 800.0 |
| 2018-02-07 05:31:00 | AAPL | Stock | 40.4425 | 40.4425 | 40.4425 | 40.4425 | 400.0 |
| 2018-02-07 05:33:00 | AAPL | Stock | 40.4425 | 40.4425 | 40.4425 | 40.4425 | 2000.0 |
| 2018-02-07 05:34:00 | AAPL | Stock | 40.4425 | 40.445 | 40.4425 | 40.445 | 4000.0 |
| 2018-02-07 05:36:00 | AAPL | Stock | 40.415 | 40.415 | 40.39 | 40.39 | 2000.0 |
| 2018-02-07 05:37:00 | AAPL | Stock | 40.39 | 40.39 | 40.3675 | 40.3675 | 800.0 |
| 2018-02-07 05:39:00 | AAPL | Stock | 40.375 | 40.375 | 40.37 | 40.37 | 2528.0 |
| 2018-02-07 05:46:00 | AAPL | Stock | 40.4075 | 40.445 | 40.4075 | 40.445 | 1200.0 |
| 2018-02-07 05:53:00 | AAPL | Stock | 40.4675 | 40.4675 | 40.415 | 40.415 | 2280.0 |
| 2018-02-07 05:56:00 | AAPL | Stock | 40.365 | 40.395 | 40.365 | 40.395 | 2000.0 |
| 2018-02-07 05:57:00 | AAPL | Stock | 40.3875 | 40.4125 | 40.3875 | 40.4125 | 2000.0 |
| 2018-02-07 06:02:00 | AAPL | Stock | 40.4075 | 40.4075 | 40.4075 | 40.4075 | 1000.0 |
| 2018-02-07 06:03:00 | AAPL | Stock | 40.4075 | 40.4075 | 40.4075 | 40.4075 | 1268.0 |
| 2018-02-07 06:04:00 | AAPL | Stock | 40.295 | 40.295 | 40.25 | 40.25 | 2400.0 |
| 2018-02-07 06:07:00 | AAPL | Stock | 40.3125 | 40.3125 | 40.3125 | 40.3125 | 400.0 |
| 2018-02-07 06:08:00 | AAPL | Stock | 40.37 | 40.395 | 40.37 | 40.395 | 800.0 |
| 2018-02-07 06:09:00 | AAPL | Stock | 40.4125 | 40.4125 | 40.4125 | 40.4125 | 400.0 |
| 2018-02-07 06:12:00 | AAPL | Stock | 40.4125 | 40.4125 | 40.4125 | 40.4125 | 1408.0 |
| 2018-02-07 06:26:00 | AAPL | Stock | 40.47 | 40.475 | 40.47 | 40.475 | 1572.0 |
| 2018-02-07 06:29:00 | AAPL | Stock | 40.475 | 40.475 | 40.475 | 40.475 | 400.0 |
| 2018-02-07 06:32:00 | AAPL | Stock | 40.4625 | 40.4625 | 40.4625 | 40.4625 | 400.0 |
| 2018-02-07 06:37:00 | AAPL | Stock | 40.5 | 40.5 | 40.5 | 40.5 | 3600.0 |
| 2018-02-07 06:39:00 | AAPL | Stock | 40.5 | 40.5 | 40.5 | 40.5 | 1600.0 |
| 2018-02-07 06:40:00 | AAPL | Stock | 40.475 | 40.475 | 40.475 | 40.475 | 400.0 |
| 2018-02-07 06:42:00 | AAPL | Stock | 40.5325 | 40.5375 | 40.5325 | 40.5375 | 4532.0 |
| 2018-02-07 06:44:00 | AAPL | Stock | 40.5525 | 40.575 | 40.5525 | 40.575 | 5188.0 |
| 2018-02-07 06:47:00 | AAPL | Stock | 40.5625 | 40.5725 | 40.5625 | 40.5725 | 980.0 |
> showing 50 of 1,150,792 rows — these rows as CSV