PREVIEW / stock_1min / 2016-08-24
file: by_date/stock_1min/2016/2016-08-24.parquet size: 13.9 MB rows: 1,013,351 symbols: 2,682
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-08-24 04:12:00 | AAPL | Stock | 27.235 | 27.235 | 27.235 | 27.235 | 824.0 |
| 2016-08-24 06:11:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 400.0 |
| 2016-08-24 06:18:00 | AAPL | Stock | 27.2425 | 27.2425 | 27.2425 | 27.2425 | 800.0 |
| 2016-08-24 06:56:00 | AAPL | Stock | 27.2125 | 27.2125 | 27.2125 | 27.2125 | 400.0 |
| 2016-08-24 07:00:00 | AAPL | Stock | 27.215 | 27.215 | 27.215 | 27.215 | 1600.0 |
| 2016-08-24 07:07:00 | AAPL | Stock | 27.205 | 27.245 | 27.205 | 27.245 | 3060.0 |
| 2016-08-24 07:22:00 | AAPL | Stock | 27.205 | 27.205 | 27.205 | 27.205 | 400.0 |
| 2016-08-24 07:41:00 | AAPL | Stock | 27.2075 | 27.2075 | 27.2075 | 27.2075 | 1000.0 |
| 2016-08-24 07:45:00 | AAPL | Stock | 27.2125 | 27.2125 | 27.2125 | 27.2125 | 800.0 |
| 2016-08-24 07:48:00 | AAPL | Stock | 27.2125 | 27.2125 | 27.2125 | 27.2125 | 800.0 |
| 2016-08-24 07:54:00 | AAPL | Stock | 27.2225 | 27.2225 | 27.2225 | 27.2225 | 400.0 |
| 2016-08-24 08:00:00 | AAPL | Stock | 27.215 | 27.215 | 27.215 | 27.215 | 400.0 |
| 2016-08-24 08:03:00 | AAPL | Stock | 27.2175 | 27.2175 | 27.2175 | 27.2175 | 1200.0 |
| 2016-08-24 08:12:00 | AAPL | Stock | 27.2375 | 27.2375 | 27.235 | 27.235 | 1400.0 |
| 2016-08-24 08:13:00 | AAPL | Stock | 27.2325 | 27.2375 | 27.2325 | 27.2375 | 4124.0 |
| 2016-08-24 08:14:00 | AAPL | Stock | 27.2275 | 27.2275 | 27.2275 | 27.2275 | 400.0 |
| 2016-08-24 08:31:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 400.0 |
| 2016-08-24 08:32:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 600.0 |
| 2016-08-24 08:34:00 | AAPL | Stock | 27.23 | 27.2325 | 27.23 | 27.2325 | 2028.0 |
| 2016-08-24 08:35:00 | AAPL | Stock | 27.2275 | 27.2275 | 27.2275 | 27.2275 | 2000.0 |
| 2016-08-24 08:41:00 | AAPL | Stock | 27.2275 | 27.23 | 27.2275 | 27.23 | 1600.0 |
| 2016-08-24 08:42:00 | AAPL | Stock | 27.235 | 27.235 | 27.235 | 27.235 | 2980.0 |
| 2016-08-24 08:43:00 | AAPL | Stock | 27.24 | 27.24 | 27.24 | 27.24 | 800.0 |
| 2016-08-24 08:46:00 | AAPL | Stock | 27.24 | 27.24 | 27.24 | 27.24 | 604.0 |
| 2016-08-24 08:47:00 | AAPL | Stock | 27.24 | 27.24 | 27.2375 | 27.2375 | 2800.0 |
| 2016-08-24 08:48:00 | AAPL | Stock | 27.2375 | 27.2375 | 27.2375 | 27.2375 | 1200.0 |
| 2016-08-24 08:51:00 | AAPL | Stock | 27.24 | 27.24 | 27.24 | 27.24 | 400.0 |
| 2016-08-24 08:53:00 | AAPL | Stock | 27.24 | 27.24 | 27.24 | 27.24 | 2000.0 |
| 2016-08-24 08:55:00 | AAPL | Stock | 27.24 | 27.24 | 27.24 | 27.24 | 1200.0 |
| 2016-08-24 08:56:00 | AAPL | Stock | 27.24 | 27.2425 | 27.24 | 27.2425 | 2000.0 |
| 2016-08-24 08:58:00 | AAPL | Stock | 27.24 | 27.24 | 27.24 | 27.24 | 432.0 |
| 2016-08-24 08:59:00 | AAPL | Stock | 27.24 | 27.24 | 27.2325 | 27.2325 | 1600.0 |
| 2016-08-24 09:02:00 | AAPL | Stock | 27.23 | 27.2325 | 27.2275 | 27.2275 | 14804.0 |
| 2016-08-24 09:03:00 | AAPL | Stock | 27.225 | 27.225 | 27.215 | 27.215 | 5796.0 |
| 2016-08-24 09:06:00 | AAPL | Stock | 27.24 | 27.24 | 27.24 | 27.24 | 800.0 |
| 2016-08-24 09:08:00 | AAPL | Stock | 27.2175 | 27.2175 | 27.215 | 27.215 | 4000.0 |
| 2016-08-24 09:12:00 | AAPL | Stock | 27.2175 | 27.2175 | 27.2175 | 27.2175 | 4000.0 |
| 2016-08-24 09:13:00 | AAPL | Stock | 27.215 | 27.215 | 27.2125 | 27.2125 | 4624.0 |
| 2016-08-24 09:14:00 | AAPL | Stock | 27.2175 | 27.22 | 27.215 | 27.215 | 11200.0 |
| 2016-08-24 09:15:00 | AAPL | Stock | 27.2125 | 27.2125 | 27.2125 | 27.2125 | 2400.0 |
| 2016-08-24 09:23:00 | AAPL | Stock | 27.2075 | 27.2075 | 27.2 | 27.2 | 36160.0 |
| 2016-08-24 09:24:00 | AAPL | Stock | 27.2 | 27.21 | 27.1925 | 27.1925 | 19080.0 |
| 2016-08-24 09:25:00 | AAPL | Stock | 27.18 | 27.18 | 27.175 | 27.175 | 3620.0 |
| 2016-08-24 09:26:00 | AAPL | Stock | 27.1875 | 27.195 | 27.1875 | 27.195 | 3920.0 |
| 2016-08-24 09:27:00 | AAPL | Stock | 27.195 | 27.205 | 27.195 | 27.205 | 6752.0 |
| 2016-08-24 09:28:00 | AAPL | Stock | 27.1875 | 27.1875 | 27.155 | 27.155 | 40848.0 |
| 2016-08-24 09:29:00 | AAPL | Stock | 27.16 | 27.1775 | 27.1425 | 27.1425 | 58256.0 |
| 2016-08-24 09:30:00 | AAPL | Stock | 27.1425 | 27.1525 | 27.0825 | 27.0825 | 2068120.0 |
| 2016-08-24 09:31:00 | AAPL | Stock | 27.0825 | 27.1125 | 27.0775 | 27.0825 | 721212.0 |
| 2016-08-24 09:32:00 | AAPL | Stock | 27.0825 | 27.1875 | 27.0825 | 27.105 | 873960.0 |
> showing 50 of 1,013,351 rows — these rows as CSV