PREVIEW / stock_1min / 2016-01-12
file: by_date/stock_1min/2016/2016-01-12.parquet size: 16.1 MB rows: 1,154,040 symbols: 2,765
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-01-12 04:00:00 | AAPL | Stock | 24.555 | 24.555 | 24.555 | 24.555 | 3996.0 |
| 2016-01-12 04:12:00 | AAPL | Stock | 24.5625 | 24.5625 | 24.5625 | 24.5625 | 400.0 |
| 2016-01-12 04:15:00 | AAPL | Stock | 24.5625 | 24.5625 | 24.555 | 24.555 | 10000.0 |
| 2016-01-12 04:16:00 | AAPL | Stock | 24.6225 | 24.665 | 24.6225 | 24.665 | 4000.0 |
| 2016-01-12 04:17:00 | AAPL | Stock | 24.645 | 24.645 | 24.645 | 24.645 | 400.0 |
| 2016-01-12 04:18:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.6725 | 24.6725 | 800.0 |
| 2016-01-12 04:26:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.6725 | 24.6725 | 520.0 |
| 2016-01-12 04:31:00 | AAPL | Stock | 24.725 | 24.725 | 24.725 | 24.725 | 400.0 |
| 2016-01-12 04:33:00 | AAPL | Stock | 24.7125 | 24.715 | 24.7125 | 24.715 | 3356.0 |
| 2016-01-12 04:34:00 | AAPL | Stock | 24.715 | 24.715 | 24.715 | 24.715 | 1200.0 |
| 2016-01-12 04:35:00 | AAPL | Stock | 24.715 | 24.7175 | 24.715 | 24.7175 | 6800.0 |
| 2016-01-12 04:36:00 | AAPL | Stock | 24.7175 | 24.7175 | 24.7175 | 24.7175 | 400.0 |
| 2016-01-12 04:40:00 | AAPL | Stock | 24.685 | 24.685 | 24.685 | 24.685 | 2000.0 |
| 2016-01-12 05:00:00 | AAPL | Stock | 24.7425 | 24.7425 | 24.7425 | 24.7425 | 1200.0 |
| 2016-01-12 05:02:00 | AAPL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 3488.0 |
| 2016-01-12 05:03:00 | AAPL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 2800.0 |
| 2016-01-12 05:10:00 | AAPL | Stock | 24.7025 | 24.7025 | 24.7025 | 24.7025 | 1200.0 |
| 2016-01-12 05:24:00 | AAPL | Stock | 24.7125 | 24.7125 | 24.7125 | 24.7125 | 1256.0 |
| 2016-01-12 05:30:00 | AAPL | Stock | 24.7125 | 24.7125 | 24.7125 | 24.7125 | 400.0 |
| 2016-01-12 05:35:00 | AAPL | Stock | 24.74 | 24.74 | 24.74 | 24.74 | 400.0 |
| 2016-01-12 05:36:00 | AAPL | Stock | 24.74 | 24.7575 | 24.74 | 24.7575 | 9640.0 |
| 2016-01-12 05:42:00 | AAPL | Stock | 24.7975 | 24.7975 | 24.7975 | 24.7975 | 920.0 |
| 2016-01-12 05:46:00 | AAPL | Stock | 24.8 | 24.8 | 24.8 | 24.8 | 1800.0 |
| 2016-01-12 05:55:00 | AAPL | Stock | 24.805 | 24.805 | 24.805 | 24.805 | 440.0 |
| 2016-01-12 05:58:00 | AAPL | Stock | 24.805 | 24.805 | 24.805 | 24.805 | 460.0 |
| 2016-01-12 06:01:00 | AAPL | Stock | 24.825 | 24.8625 | 24.825 | 24.8475 | 19740.0 |
| 2016-01-12 06:02:00 | AAPL | Stock | 24.85 | 24.8875 | 24.85 | 24.8875 | 23780.0 |
| 2016-01-12 06:03:00 | AAPL | Stock | 24.9 | 24.935 | 24.875 | 24.935 | 73812.0 |
| 2016-01-12 06:04:00 | AAPL | Stock | 24.935 | 25.0 | 24.935 | 24.95 | 137992.0 |
| 2016-01-12 06:05:00 | AAPL | Stock | 24.98 | 25.0025 | 24.98 | 25.0025 | 16380.0 |
| 2016-01-12 06:06:00 | AAPL | Stock | 24.9875 | 25.0375 | 24.9875 | 25.0375 | 13100.0 |
| 2016-01-12 06:07:00 | AAPL | Stock | 25.0025 | 25.075 | 25.0025 | 25.0425 | 91936.0 |
| 2016-01-12 06:08:00 | AAPL | Stock | 25.0375 | 25.0625 | 25.0275 | 25.06 | 43356.0 |
| 2016-01-12 06:09:00 | AAPL | Stock | 25.0725 | 25.0875 | 25.05 | 25.05 | 12000.0 |
| 2016-01-12 06:10:00 | AAPL | Stock | 25.0525 | 25.0525 | 25.0525 | 25.0525 | 400.0 |
| 2016-01-12 06:11:00 | AAPL | Stock | 25.055 | 25.0625 | 25.0525 | 25.0525 | 1200.0 |
| 2016-01-12 06:12:00 | AAPL | Stock | 25.0525 | 25.1125 | 25.0525 | 25.1125 | 15984.0 |
| 2016-01-12 06:13:00 | AAPL | Stock | 25.0875 | 25.0875 | 25.0875 | 25.0875 | 4400.0 |
| 2016-01-12 06:14:00 | AAPL | Stock | 25.1125 | 25.1125 | 25.075 | 25.075 | 1600.0 |
| 2016-01-12 06:16:00 | AAPL | Stock | 25.075 | 25.075 | 25.075 | 25.075 | 2000.0 |
| 2016-01-12 06:17:00 | AAPL | Stock | 25.1 | 25.1 | 25.095 | 25.1 | 5016.0 |
| 2016-01-12 06:18:00 | AAPL | Stock | 25.1075 | 25.125 | 25.1 | 25.125 | 1200.0 |
| 2016-01-12 06:19:00 | AAPL | Stock | 25.1025 | 25.1025 | 25.1 | 25.1 | 1200.0 |
| 2016-01-12 06:20:00 | AAPL | Stock | 25.1 | 25.125 | 25.1 | 25.1 | 4376.0 |
| 2016-01-12 06:23:00 | AAPL | Stock | 25.105 | 25.125 | 25.1 | 25.125 | 16800.0 |
| 2016-01-12 06:24:00 | AAPL | Stock | 25.125 | 25.14 | 25.125 | 25.1375 | 4800.0 |
| 2016-01-12 06:25:00 | AAPL | Stock | 25.125 | 25.125 | 25.1175 | 25.1175 | 4400.0 |
| 2016-01-12 06:26:00 | AAPL | Stock | 25.12 | 25.12 | 25.12 | 25.12 | 400.0 |
| 2016-01-12 06:27:00 | AAPL | Stock | 25.12 | 25.1375 | 25.12 | 25.1375 | 4200.0 |
| 2016-01-12 06:28:00 | AAPL | Stock | 25.1375 | 25.1575 | 25.1375 | 25.1575 | 4216.0 |
> showing 50 of 1,154,040 rows — these rows as CSV