PREVIEW / stock_1min / 2016-07-19
file: by_date/stock_1min/2016/2016-07-19.parquet size: 13.7 MB rows: 999,228 symbols: 2,678
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-07-19 04:13:00 | AAPL | Stock | 24.8625 | 24.8625 | 24.8125 | 24.825 | 9600.0 |
| 2016-07-19 04:15:00 | AAPL | Stock | 24.815 | 24.815 | 24.815 | 24.815 | 960.0 |
| 2016-07-19 04:16:00 | AAPL | Stock | 24.8075 | 24.8075 | 24.8075 | 24.8075 | 2616.0 |
| 2016-07-19 05:09:00 | AAPL | Stock | 24.8 | 24.8 | 24.8 | 24.8 | 400.0 |
| 2016-07-19 05:51:00 | AAPL | Stock | 24.8475 | 24.8475 | 24.8475 | 24.8475 | 1120.0 |
| 2016-07-19 06:00:00 | AAPL | Stock | 24.8475 | 24.8475 | 24.8475 | 24.8475 | 800.0 |
| 2016-07-19 06:04:00 | AAPL | Stock | 24.8475 | 24.8475 | 24.8475 | 24.8475 | 1920.0 |
| 2016-07-19 06:14:00 | AAPL | Stock | 24.8275 | 24.8275 | 24.8275 | 24.8275 | 2000.0 |
| 2016-07-19 06:21:00 | AAPL | Stock | 24.8275 | 24.8275 | 24.8275 | 24.8275 | 1600.0 |
| 2016-07-19 06:24:00 | AAPL | Stock | 24.8275 | 24.8275 | 24.8275 | 24.8275 | 800.0 |
| 2016-07-19 07:06:00 | AAPL | Stock | 24.8625 | 24.8625 | 24.8625 | 24.8625 | 6300.0 |
| 2016-07-19 07:17:00 | AAPL | Stock | 24.875 | 24.875 | 24.875 | 24.875 | 400.0 |
| 2016-07-19 07:19:00 | AAPL | Stock | 24.875 | 24.875 | 24.875 | 24.875 | 1600.0 |
| 2016-07-19 07:20:00 | AAPL | Stock | 24.8775 | 24.8775 | 24.875 | 24.875 | 4000.0 |
| 2016-07-19 07:23:00 | AAPL | Stock | 24.8625 | 24.8625 | 24.8625 | 24.8625 | 400.0 |
| 2016-07-19 07:25:00 | AAPL | Stock | 24.8625 | 24.8625 | 24.8625 | 24.8625 | 5600.0 |
| 2016-07-19 07:35:00 | AAPL | Stock | 24.88 | 24.88 | 24.88 | 24.88 | 400.0 |
| 2016-07-19 07:36:00 | AAPL | Stock | 24.88 | 24.88 | 24.88 | 24.88 | 400.0 |
| 2016-07-19 07:43:00 | AAPL | Stock | 24.8625 | 24.8625 | 24.8625 | 24.8625 | 1360.0 |
| 2016-07-19 07:51:00 | AAPL | Stock | 24.8575 | 24.8575 | 24.8575 | 24.8575 | 400.0 |
| 2016-07-19 07:52:00 | AAPL | Stock | 24.8575 | 24.8575 | 24.8575 | 24.8575 | 800.0 |
| 2016-07-19 07:54:00 | AAPL | Stock | 24.8575 | 24.8575 | 24.8575 | 24.8575 | 1700.0 |
| 2016-07-19 07:55:00 | AAPL | Stock | 24.855 | 24.855 | 24.855 | 24.855 | 1516.0 |
| 2016-07-19 07:56:00 | AAPL | Stock | 24.8575 | 24.8575 | 24.8575 | 24.8575 | 2000.0 |
| 2016-07-19 07:59:00 | AAPL | Stock | 24.8575 | 24.8575 | 24.8525 | 24.8525 | 4400.0 |
| 2016-07-19 08:00:00 | AAPL | Stock | 24.8525 | 24.8575 | 24.85 | 24.85 | 41340.0 |
| 2016-07-19 08:01:00 | AAPL | Stock | 24.855 | 24.855 | 24.85 | 24.85 | 3640.0 |
| 2016-07-19 08:03:00 | AAPL | Stock | 24.85 | 24.85 | 24.85 | 24.85 | 640.0 |
| 2016-07-19 08:04:00 | AAPL | Stock | 24.855 | 24.855 | 24.855 | 24.855 | 3200.0 |
| 2016-07-19 08:05:00 | AAPL | Stock | 24.8575 | 24.86 | 24.8575 | 24.86 | 8364.0 |
| 2016-07-19 08:07:00 | AAPL | Stock | 24.8725 | 24.8725 | 24.8725 | 24.8725 | 1200.0 |
| 2016-07-19 08:08:00 | AAPL | Stock | 24.875 | 24.875 | 24.875 | 24.875 | 2800.0 |
| 2016-07-19 08:14:00 | AAPL | Stock | 24.885 | 24.8875 | 24.885 | 24.8875 | 800.0 |
| 2016-07-19 08:16:00 | AAPL | Stock | 24.8825 | 24.8825 | 24.8775 | 24.8825 | 11200.0 |
| 2016-07-19 08:17:00 | AAPL | Stock | 24.8775 | 24.8825 | 24.8775 | 24.8825 | 3160.0 |
| 2016-07-19 08:18:00 | AAPL | Stock | 24.88 | 24.8825 | 24.88 | 24.8825 | 3264.0 |
| 2016-07-19 08:20:00 | AAPL | Stock | 24.8825 | 24.8825 | 24.8825 | 24.8825 | 2740.0 |
| 2016-07-19 08:21:00 | AAPL | Stock | 24.8825 | 24.8825 | 24.8825 | 24.8825 | 400.0 |
| 2016-07-19 08:22:00 | AAPL | Stock | 24.88 | 24.88 | 24.875 | 24.88 | 14000.0 |
| 2016-07-19 08:24:00 | AAPL | Stock | 24.8625 | 24.88 | 24.8625 | 24.88 | 12000.0 |
| 2016-07-19 08:28:00 | AAPL | Stock | 24.875 | 24.875 | 24.875 | 24.875 | 800.0 |
| 2016-07-19 08:32:00 | AAPL | Stock | 24.87 | 24.87 | 24.87 | 24.87 | 2800.0 |
| 2016-07-19 08:33:00 | AAPL | Stock | 24.87 | 24.87 | 24.87 | 24.87 | 4000.0 |
| 2016-07-19 08:36:00 | AAPL | Stock | 24.87 | 24.87 | 24.87 | 24.87 | 440.0 |
| 2016-07-19 08:40:00 | AAPL | Stock | 24.865 | 24.865 | 24.865 | 24.865 | 1600.0 |
| 2016-07-19 08:41:00 | AAPL | Stock | 24.865 | 24.865 | 24.865 | 24.865 | 400.0 |
| 2016-07-19 08:44:00 | AAPL | Stock | 24.87 | 24.875 | 24.87 | 24.87 | 10360.0 |
| 2016-07-19 08:45:00 | AAPL | Stock | 24.87 | 24.875 | 24.87 | 24.87 | 4000.0 |
| 2016-07-19 08:46:00 | AAPL | Stock | 24.875 | 24.88 | 24.875 | 24.8775 | 1300.0 |
| 2016-07-19 08:47:00 | AAPL | Stock | 24.875 | 24.875 | 24.875 | 24.875 | 400.0 |
> showing 50 of 999,228 rows — these rows as CSV