PREVIEW / stock_1min / 2016-11-17
file: by_date/stock_1min/2016/2016-11-17.parquet size: 15.2 MB rows: 1,092,521 symbols: 2,627
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-11-17 04:07:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.4975 | 27.4975 | 780.0 |
| 2016-11-17 04:09:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.4975 | 27.4975 | 1232.0 |
| 2016-11-17 04:21:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.4975 | 27.4975 | 600.0 |
| 2016-11-17 04:32:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.4975 | 27.4975 | 1420.0 |
| 2016-11-17 05:23:00 | AAPL | Stock | 27.46 | 27.46 | 27.46 | 27.46 | 3988.0 |
| 2016-11-17 06:17:00 | AAPL | Stock | 27.45 | 27.45 | 27.45 | 27.45 | 408.0 |
| 2016-11-17 06:19:00 | AAPL | Stock | 27.45 | 27.45 | 27.45 | 27.45 | 3580.0 |
| 2016-11-17 06:45:00 | AAPL | Stock | 27.44 | 27.44 | 27.44 | 27.44 | 1080.0 |
| 2016-11-17 07:15:00 | AAPL | Stock | 27.465 | 27.465 | 27.465 | 27.465 | 1200.0 |
| 2016-11-17 07:22:00 | AAPL | Stock | 27.465 | 27.465 | 27.46 | 27.46 | 800.0 |
| 2016-11-17 07:23:00 | AAPL | Stock | 27.465 | 27.465 | 27.465 | 27.465 | 1840.0 |
| 2016-11-17 07:35:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 960.0 |
| 2016-11-17 07:36:00 | AAPL | Stock | 27.5325 | 27.5325 | 27.5325 | 27.5325 | 656.0 |
| 2016-11-17 07:42:00 | AAPL | Stock | 27.53 | 27.53 | 27.53 | 27.53 | 4000.0 |
| 2016-11-17 07:46:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.5 | 27.5 | 4800.0 |
| 2016-11-17 07:47:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 1820.0 |
| 2016-11-17 07:49:00 | AAPL | Stock | 27.48 | 27.48 | 27.48 | 27.48 | 1380.0 |
| 2016-11-17 08:00:00 | AAPL | Stock | 27.475 | 27.5425 | 27.4425 | 27.4975 | 23632.0 |
| 2016-11-17 08:01:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 2000.0 |
| 2016-11-17 08:03:00 | AAPL | Stock | 27.4875 | 27.4875 | 27.4875 | 27.4875 | 4000.0 |
| 2016-11-17 08:04:00 | AAPL | Stock | 27.4875 | 27.4875 | 27.475 | 27.475 | 6784.0 |
| 2016-11-17 08:05:00 | AAPL | Stock | 27.465 | 27.4875 | 27.465 | 27.4875 | 1200.0 |
| 2016-11-17 08:06:00 | AAPL | Stock | 27.485 | 27.485 | 27.485 | 27.485 | 8000.0 |
| 2016-11-17 08:07:00 | AAPL | Stock | 27.47 | 27.47 | 27.47 | 27.47 | 400.0 |
| 2016-11-17 08:08:00 | AAPL | Stock | 27.485 | 27.485 | 27.485 | 27.485 | 4000.0 |
| 2016-11-17 08:11:00 | AAPL | Stock | 27.475 | 27.48 | 27.475 | 27.48 | 1600.0 |
| 2016-11-17 08:12:00 | AAPL | Stock | 27.485 | 27.4875 | 27.485 | 27.4875 | 9108.0 |
| 2016-11-17 08:13:00 | AAPL | Stock | 27.485 | 27.485 | 27.4775 | 27.4775 | 3200.0 |
| 2016-11-17 08:14:00 | AAPL | Stock | 27.48 | 27.48 | 27.48 | 27.48 | 6932.0 |
| 2016-11-17 08:15:00 | AAPL | Stock | 27.4875 | 27.5 | 27.4875 | 27.5 | 17368.0 |
| 2016-11-17 08:16:00 | AAPL | Stock | 27.52 | 27.52 | 27.52 | 27.52 | 400.0 |
| 2016-11-17 08:18:00 | AAPL | Stock | 27.5025 | 27.5025 | 27.5025 | 27.5025 | 800.0 |
| 2016-11-17 08:23:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.5125 | 27.5125 | 1920.0 |
| 2016-11-17 08:24:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.5125 | 27.5125 | 1200.0 |
| 2016-11-17 08:25:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 19832.0 |
| 2016-11-17 08:27:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 1668.0 |
| 2016-11-17 08:32:00 | AAPL | Stock | 27.48 | 27.48 | 27.475 | 27.475 | 2836.0 |
| 2016-11-17 08:33:00 | AAPL | Stock | 27.5 | 27.5 | 27.475 | 27.475 | 4608.0 |
| 2016-11-17 08:34:00 | AAPL | Stock | 27.4525 | 27.4525 | 27.45 | 27.45 | 2400.0 |
| 2016-11-17 08:36:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 592.0 |
| 2016-11-17 08:37:00 | AAPL | Stock | 27.4875 | 27.4875 | 27.4875 | 27.4875 | 8620.0 |
| 2016-11-17 08:38:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.4875 | 27.4875 | 2532.0 |
| 2016-11-17 08:39:00 | AAPL | Stock | 27.465 | 27.465 | 27.465 | 27.465 | 10000.0 |
| 2016-11-17 08:40:00 | AAPL | Stock | 27.48 | 27.48 | 27.47 | 27.47 | 1608.0 |
| 2016-11-17 08:42:00 | AAPL | Stock | 27.4825 | 27.4875 | 27.4675 | 27.4675 | 5000.0 |
| 2016-11-17 08:44:00 | AAPL | Stock | 27.46 | 27.485 | 27.46 | 27.485 | 2000.0 |
| 2016-11-17 08:46:00 | AAPL | Stock | 27.46 | 27.46 | 27.4575 | 27.4575 | 6820.0 |
| 2016-11-17 08:49:00 | AAPL | Stock | 27.46 | 27.46 | 27.46 | 27.46 | 8000.0 |
| 2016-11-17 08:52:00 | AAPL | Stock | 27.48 | 27.485 | 27.48 | 27.485 | 8000.0 |
| 2016-11-17 08:53:00 | AAPL | Stock | 27.48 | 27.485 | 27.48 | 27.48 | 4800.0 |
> showing 50 of 1,092,521 rows — these rows as CSV