PREVIEW / stock_1min / 2016-11-09
file: by_date/stock_1min/2016/2016-11-09.parquet size: 16.6 MB rows: 1,169,924 symbols: 2,617
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-09 04:00:00 | AAPL | Stock | 26.9975 | 27.0025 | 26.98 | 27.0025 | 88316.0 |
| 2016-11-09 04:01:00 | AAPL | Stock | 27.0025 | 27.0025 | 26.925 | 27.0025 | 137976.0 |
| 2016-11-09 04:02:00 | AAPL | Stock | 27.1225 | 27.1225 | 27.0025 | 27.0625 | 8888.0 |
| 2016-11-09 04:03:00 | AAPL | Stock | 27.105 | 27.1125 | 27.105 | 27.1125 | 18180.0 |
| 2016-11-09 04:04:00 | AAPL | Stock | 27.135 | 27.15 | 27.125 | 27.15 | 7972.0 |
| 2016-11-09 04:05:00 | AAPL | Stock | 27.15 | 27.1725 | 27.15 | 27.1725 | 6088.0 |
| 2016-11-09 04:06:00 | AAPL | Stock | 27.1475 | 27.1475 | 27.125 | 27.125 | 8440.0 |
| 2016-11-09 04:07:00 | AAPL | Stock | 27.15 | 27.15 | 27.15 | 27.15 | 400.0 |
| 2016-11-09 04:08:00 | AAPL | Stock | 27.175 | 27.2 | 27.175 | 27.1875 | 15868.0 |
| 2016-11-09 04:09:00 | AAPL | Stock | 27.155 | 27.155 | 27.155 | 27.155 | 400.0 |
| 2016-11-09 04:10:00 | AAPL | Stock | 27.135 | 27.2 | 27.13 | 27.2 | 11624.0 |
| 2016-11-09 04:11:00 | AAPL | Stock | 27.1625 | 27.2125 | 27.125 | 27.2125 | 15724.0 |
| 2016-11-09 04:12:00 | AAPL | Stock | 27.2 | 27.2125 | 27.1625 | 27.2 | 47080.0 |
| 2016-11-09 04:13:00 | AAPL | Stock | 27.22 | 27.23 | 27.22 | 27.225 | 34388.0 |
| 2016-11-09 04:14:00 | AAPL | Stock | 27.225 | 27.2625 | 27.225 | 27.2625 | 10000.0 |
| 2016-11-09 04:16:00 | AAPL | Stock | 27.2 | 27.2 | 27.175 | 27.175 | 6072.0 |
| 2016-11-09 04:17:00 | AAPL | Stock | 27.1275 | 27.1275 | 27.125 | 27.125 | 4000.0 |
| 2016-11-09 04:18:00 | AAPL | Stock | 27.1475 | 27.1475 | 27.1275 | 27.1275 | 800.0 |
| 2016-11-09 04:20:00 | AAPL | Stock | 27.155 | 27.16 | 27.155 | 27.1575 | 4280.0 |
| 2016-11-09 04:21:00 | AAPL | Stock | 27.1775 | 27.205 | 27.1775 | 27.205 | 7800.0 |
| 2016-11-09 04:22:00 | AAPL | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 800.0 |
| 2016-11-09 04:23:00 | AAPL | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 3400.0 |
| 2016-11-09 04:24:00 | AAPL | Stock | 27.1525 | 27.2 | 27.145 | 27.2 | 22680.0 |
| 2016-11-09 04:26:00 | AAPL | Stock | 27.1225 | 27.1225 | 27.1225 | 27.1225 | 588.0 |
| 2016-11-09 04:27:00 | AAPL | Stock | 27.1225 | 27.1225 | 27.1225 | 27.1225 | 720.0 |
| 2016-11-09 04:31:00 | AAPL | Stock | 27.1125 | 27.1375 | 27.1125 | 27.1375 | 4156.0 |
| 2016-11-09 04:32:00 | AAPL | Stock | 27.15 | 27.2 | 27.15 | 27.2 | 5748.0 |
| 2016-11-09 04:37:00 | AAPL | Stock | 27.1825 | 27.1875 | 27.1775 | 27.1875 | 10520.0 |
| 2016-11-09 04:38:00 | AAPL | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 8376.0 |
| 2016-11-09 04:41:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 6804.0 |
| 2016-11-09 04:42:00 | AAPL | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 800.0 |
| 2016-11-09 04:43:00 | AAPL | Stock | 27.2 | 27.2 | 27.1875 | 27.1875 | 10500.0 |
| 2016-11-09 04:44:00 | AAPL | Stock | 27.2375 | 27.25 | 27.2 | 27.25 | 14308.0 |
| 2016-11-09 04:45:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 400.0 |
| 2016-11-09 04:47:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 1952.0 |
| 2016-11-09 04:48:00 | AAPL | Stock | 27.265 | 27.265 | 27.265 | 27.265 | 1840.0 |
| 2016-11-09 04:52:00 | AAPL | Stock | 27.3175 | 27.3175 | 27.3175 | 27.3175 | 2004.0 |
| 2016-11-09 04:55:00 | AAPL | Stock | 27.2825 | 27.2825 | 27.2825 | 27.2825 | 400.0 |
| 2016-11-09 04:57:00 | AAPL | Stock | 27.27 | 27.27 | 27.27 | 27.27 | 1200.0 |
| 2016-11-09 04:58:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 400.0 |
| 2016-11-09 05:00:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 400.0 |
| 2016-11-09 05:01:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 1260.0 |
| 2016-11-09 05:02:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 24640.0 |
| 2016-11-09 05:03:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 5200.0 |
| 2016-11-09 05:04:00 | AAPL | Stock | 27.25 | 27.2525 | 27.225 | 27.225 | 27876.0 |
| 2016-11-09 05:06:00 | AAPL | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 1200.0 |
| 2016-11-09 05:15:00 | AAPL | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 5200.0 |
| 2016-11-09 05:18:00 | AAPL | Stock | 27.205 | 27.205 | 27.205 | 27.205 | 400.0 |
| 2016-11-09 05:19:00 | AAPL | Stock | 27.205 | 27.205 | 27.2 | 27.2 | 10680.0 |
| 2016-11-09 05:20:00 | AAPL | Stock | 27.2 | 27.2 | 27.1875 | 27.1875 | 19140.0 |
> showing 50 of 1,169,924 rows — these rows as CSV