PREVIEW / stock_1min / 2016-11-25
file: by_date/stock_1min/2016/2016-11-25.parquet size: 7.8 MB rows: 550,520 symbols: 2,551
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-25 04:25:00 | AAPL | Stock | 27.6775 | 27.6775 | 27.6775 | 27.6775 | 400.0 |
| 2016-11-25 04:31:00 | AAPL | Stock | 27.6125 | 27.6125 | 27.6125 | 27.6125 | 800.0 |
| 2016-11-25 04:50:00 | AAPL | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 800.0 |
| 2016-11-25 06:04:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 960.0 |
| 2016-11-25 06:14:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 960.0 |
| 2016-11-25 06:31:00 | AAPL | Stock | 27.7425 | 27.7425 | 27.7425 | 27.7425 | 1760.0 |
| 2016-11-25 07:02:00 | AAPL | Stock | 27.745 | 27.7475 | 27.745 | 27.7475 | 1200.0 |
| 2016-11-25 07:21:00 | AAPL | Stock | 27.7475 | 27.75 | 27.7475 | 27.75 | 1816.0 |
| 2016-11-25 07:31:00 | AAPL | Stock | 27.7675 | 27.7675 | 27.7675 | 27.7675 | 1200.0 |
| 2016-11-25 07:56:00 | AAPL | Stock | 27.7625 | 27.7625 | 27.7625 | 27.7625 | 752.0 |
| 2016-11-25 07:58:00 | AAPL | Stock | 27.7625 | 27.7625 | 27.76 | 27.76 | 3400.0 |
| 2016-11-25 08:02:00 | AAPL | Stock | 27.78 | 27.785 | 27.78 | 27.785 | 2144.0 |
| 2016-11-25 08:04:00 | AAPL | Stock | 27.78 | 27.795 | 27.78 | 27.795 | 2320.0 |
| 2016-11-25 08:05:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 996.0 |
| 2016-11-25 08:07:00 | AAPL | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 2052.0 |
| 2016-11-25 08:08:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.775 | 27.78 | 5084.0 |
| 2016-11-25 08:09:00 | AAPL | Stock | 27.785 | 27.785 | 27.785 | 27.785 | 540.0 |
| 2016-11-25 08:15:00 | AAPL | Stock | 27.78 | 27.78 | 27.78 | 27.78 | 400.0 |
| 2016-11-25 08:19:00 | AAPL | Stock | 27.78 | 27.78 | 27.78 | 27.78 | 600.0 |
| 2016-11-25 08:21:00 | AAPL | Stock | 27.7975 | 27.8 | 27.7975 | 27.8 | 1600.0 |
| 2016-11-25 08:25:00 | AAPL | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 8000.0 |
| 2016-11-25 08:28:00 | AAPL | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 400.0 |
| 2016-11-25 08:31:00 | AAPL | Stock | 27.7975 | 27.8 | 27.7975 | 27.8 | 4200.0 |
| 2016-11-25 08:36:00 | AAPL | Stock | 27.795 | 27.7975 | 27.795 | 27.7975 | 800.0 |
| 2016-11-25 08:38:00 | AAPL | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 400.0 |
| 2016-11-25 08:39:00 | AAPL | Stock | 27.7975 | 27.7975 | 27.7975 | 27.7975 | 4400.0 |
| 2016-11-25 08:41:00 | AAPL | Stock | 27.7975 | 27.7975 | 27.7975 | 27.7975 | 400.0 |
| 2016-11-25 08:42:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.78 | 27.78 | 3800.0 |
| 2016-11-25 08:43:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.775 | 27.775 | 6400.0 |
| 2016-11-25 08:44:00 | AAPL | Stock | 27.78 | 27.78 | 27.78 | 27.78 | 3600.0 |
| 2016-11-25 08:49:00 | AAPL | Stock | 27.78 | 27.78 | 27.78 | 27.78 | 2000.0 |
| 2016-11-25 08:50:00 | AAPL | Stock | 27.78 | 27.78 | 27.78 | 27.78 | 432.0 |
| 2016-11-25 08:54:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 600.0 |
| 2016-11-25 08:57:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 800.0 |
| 2016-11-25 08:58:00 | AAPL | Stock | 27.78 | 27.78 | 27.78 | 27.78 | 2000.0 |
| 2016-11-25 08:59:00 | AAPL | Stock | 27.78 | 27.7825 | 27.78 | 27.7825 | 1840.0 |
| 2016-11-25 09:02:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7775 | 27.7775 | 5200.0 |
| 2016-11-25 09:04:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 1772.0 |
| 2016-11-25 09:06:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 2688.0 |
| 2016-11-25 09:08:00 | AAPL | Stock | 27.7925 | 27.7925 | 27.7925 | 27.7925 | 2000.0 |
| 2016-11-25 09:11:00 | AAPL | Stock | 27.8125 | 27.8125 | 27.8125 | 27.8125 | 4000.0 |
| 2016-11-25 09:12:00 | AAPL | Stock | 27.805 | 27.805 | 27.805 | 27.805 | 4000.0 |
| 2016-11-25 09:13:00 | AAPL | Stock | 27.805 | 27.805 | 27.805 | 27.805 | 2640.0 |
| 2016-11-25 09:14:00 | AAPL | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 400.0 |
| 2016-11-25 09:20:00 | AAPL | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 512.0 |
| 2016-11-25 09:23:00 | AAPL | Stock | 27.8025 | 27.8025 | 27.8025 | 27.8025 | 4000.0 |
| 2016-11-25 09:24:00 | AAPL | Stock | 27.815 | 27.8425 | 27.815 | 27.82 | 13296.0 |
| 2016-11-25 09:25:00 | AAPL | Stock | 27.8225 | 27.8225 | 27.8225 | 27.8225 | 6704.0 |
| 2016-11-25 09:27:00 | AAPL | Stock | 27.8225 | 27.8325 | 27.8225 | 27.8325 | 800.0 |
| 2016-11-25 09:28:00 | AAPL | Stock | 27.8125 | 27.8125 | 27.7875 | 27.7875 | 65216.0 |
> showing 50 of 550,520 rows — these rows as CSV