PREVIEW / stock_1min / 2014-11-19
file: by_date/stock_1min/2014/2014-11-19.parquet size: 14.4 MB rows: 1,059,572 symbols: 2,906
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-19 04:14:00 | AAPL | Stock | 28.8475 | 28.8475 | 28.8475 | 28.8475 | 400.0 |
| 2014-11-19 04:46:00 | AAPL | Stock | 28.8725 | 28.8725 | 28.8725 | 28.8725 | 1600.0 |
| 2014-11-19 04:51:00 | AAPL | Stock | 28.8825 | 28.8825 | 28.8825 | 28.8825 | 1200.0 |
| 2014-11-19 04:54:00 | AAPL | Stock | 28.8825 | 28.8825 | 28.8825 | 28.8825 | 400.0 |
| 2014-11-19 04:56:00 | AAPL | Stock | 28.8825 | 28.8825 | 28.8825 | 28.8825 | 800.0 |
| 2014-11-19 04:58:00 | AAPL | Stock | 28.8675 | 28.8675 | 28.8675 | 28.8675 | 4000.0 |
| 2014-11-19 05:02:00 | AAPL | Stock | 28.865 | 28.865 | 28.8625 | 28.8625 | 800.0 |
| 2014-11-19 05:06:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 11200.0 |
| 2014-11-19 05:10:00 | AAPL | Stock | 28.85 | 28.85 | 28.85 | 28.85 | 4000.0 |
| 2014-11-19 05:13:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 800.0 |
| 2014-11-19 05:17:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 2400.0 |
| 2014-11-19 05:26:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 2400.0 |
| 2014-11-19 05:30:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 400.0 |
| 2014-11-19 05:31:00 | AAPL | Stock | 28.85 | 28.85 | 28.85 | 28.85 | 6000.0 |
| 2014-11-19 05:34:00 | AAPL | Stock | 28.86 | 28.86 | 28.86 | 28.86 | 400.0 |
| 2014-11-19 05:59:00 | AAPL | Stock | 28.86 | 28.86 | 28.86 | 28.86 | 400.0 |
| 2014-11-19 06:01:00 | AAPL | Stock | 28.86 | 28.86 | 28.86 | 28.86 | 400.0 |
| 2014-11-19 06:07:00 | AAPL | Stock | 28.845 | 28.845 | 28.845 | 28.845 | 4400.0 |
| 2014-11-19 06:15:00 | AAPL | Stock | 28.85 | 28.8575 | 28.85 | 28.8575 | 8676.0 |
| 2014-11-19 06:19:00 | AAPL | Stock | 28.845 | 28.845 | 28.845 | 28.845 | 1300.0 |
| 2014-11-19 06:21:00 | AAPL | Stock | 28.855 | 28.8625 | 28.855 | 28.855 | 14268.0 |
| 2014-11-19 06:26:00 | AAPL | Stock | 28.86 | 28.86 | 28.86 | 28.86 | 400.0 |
| 2014-11-19 06:28:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 3200.0 |
| 2014-11-19 06:29:00 | AAPL | Stock | 28.8675 | 28.87 | 28.8675 | 28.8675 | 4112.0 |
| 2014-11-19 06:30:00 | AAPL | Stock | 28.8675 | 28.8675 | 28.8675 | 28.8675 | 2804.0 |
| 2014-11-19 06:33:00 | AAPL | Stock | 28.87 | 28.885 | 28.87 | 28.885 | 8648.0 |
| 2014-11-19 06:34:00 | AAPL | Stock | 28.875 | 28.875 | 28.875 | 28.875 | 5200.0 |
| 2014-11-19 06:36:00 | AAPL | Stock | 28.8775 | 28.8775 | 28.875 | 28.875 | 2400.0 |
| 2014-11-19 06:37:00 | AAPL | Stock | 28.875 | 28.875 | 28.875 | 28.875 | 1200.0 |
| 2014-11-19 06:38:00 | AAPL | Stock | 28.875 | 28.875 | 28.875 | 28.875 | 400.0 |
| 2014-11-19 06:39:00 | AAPL | Stock | 28.8775 | 28.8775 | 28.875 | 28.875 | 1200.0 |
| 2014-11-19 06:42:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 588.0 |
| 2014-11-19 06:47:00 | AAPL | Stock | 28.85 | 28.85 | 28.85 | 28.85 | 400.0 |
| 2014-11-19 06:49:00 | AAPL | Stock | 28.8575 | 28.8575 | 28.8575 | 28.8575 | 400.0 |
| 2014-11-19 06:53:00 | AAPL | Stock | 28.85 | 28.85 | 28.85 | 28.85 | 2800.0 |
| 2014-11-19 06:56:00 | AAPL | Stock | 28.855 | 28.855 | 28.8525 | 28.8525 | 2000.0 |
| 2014-11-19 07:00:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 2000.0 |
| 2014-11-19 07:04:00 | AAPL | Stock | 28.8675 | 28.875 | 28.8675 | 28.875 | 16400.0 |
| 2014-11-19 07:11:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 1600.0 |
| 2014-11-19 07:13:00 | AAPL | Stock | 28.865 | 28.865 | 28.865 | 28.865 | 532.0 |
| 2014-11-19 07:14:00 | AAPL | Stock | 28.865 | 28.865 | 28.865 | 28.865 | 5468.0 |
| 2014-11-19 07:17:00 | AAPL | Stock | 28.865 | 28.865 | 28.8625 | 28.8625 | 4000.0 |
| 2014-11-19 07:18:00 | AAPL | Stock | 28.86 | 28.86 | 28.86 | 28.86 | 5840.0 |
| 2014-11-19 07:19:00 | AAPL | Stock | 28.865 | 28.865 | 28.865 | 28.865 | 3200.0 |
| 2014-11-19 07:21:00 | AAPL | Stock | 28.8675 | 28.8675 | 28.8675 | 28.8675 | 6368.0 |
| 2014-11-19 07:23:00 | AAPL | Stock | 28.8675 | 28.8675 | 28.8675 | 28.8675 | 7800.0 |
| 2014-11-19 07:24:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.86 | 28.86 | 14684.0 |
| 2014-11-19 07:27:00 | AAPL | Stock | 28.86 | 28.86 | 28.86 | 28.86 | 1872.0 |
| 2014-11-19 07:31:00 | AAPL | Stock | 28.86 | 28.86 | 28.86 | 28.86 | 1032.0 |
| 2014-11-19 07:33:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 1940.0 |
> showing 50 of 1,059,572 rows — these rows as CSV