PREVIEW / stock_1min / 2016-09-30
file: by_date/stock_1min/2016/2016-09-30.parquet size: 14.7 MB rows: 1,071,297 symbols: 2,638
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-09-30 04:00:00 | AAPL | Stock | 27.9375 | 27.9375 | 27.9375 | 27.9375 | 1200.0 |
| 2016-09-30 04:01:00 | AAPL | Stock | 27.9375 | 27.9375 | 27.9375 | 27.9375 | 580.0 |
| 2016-09-30 04:03:00 | AAPL | Stock | 27.8875 | 27.8875 | 27.8875 | 27.8875 | 400.0 |
| 2016-09-30 04:10:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 400.0 |
| 2016-09-30 04:25:00 | AAPL | Stock | 27.9275 | 27.9275 | 27.9275 | 27.9275 | 400.0 |
| 2016-09-30 04:27:00 | AAPL | Stock | 27.93 | 27.93 | 27.93 | 27.93 | 560.0 |
| 2016-09-30 04:32:00 | AAPL | Stock | 27.93 | 27.93 | 27.93 | 27.93 | 1028.0 |
| 2016-09-30 04:33:00 | AAPL | Stock | 27.93 | 27.93 | 27.93 | 27.93 | 400.0 |
| 2016-09-30 04:40:00 | AAPL | Stock | 27.93 | 27.93 | 27.93 | 27.93 | 400.0 |
| 2016-09-30 04:45:00 | AAPL | Stock | 27.9425 | 27.9425 | 27.9425 | 27.9425 | 400.0 |
| 2016-09-30 04:56:00 | AAPL | Stock | 27.9425 | 27.9425 | 27.9425 | 27.9425 | 600.0 |
| 2016-09-30 05:04:00 | AAPL | Stock | 27.93 | 27.93 | 27.93 | 27.93 | 400.0 |
| 2016-09-30 05:31:00 | AAPL | Stock | 27.9625 | 27.9625 | 27.9625 | 27.9625 | 696.0 |
| 2016-09-30 06:15:00 | AAPL | Stock | 27.975 | 27.975 | 27.975 | 27.975 | 400.0 |
| 2016-09-30 06:18:00 | AAPL | Stock | 27.9975 | 27.9975 | 27.9975 | 27.9975 | 908.0 |
| 2016-09-30 06:34:00 | AAPL | Stock | 27.9775 | 27.9775 | 27.975 | 27.975 | 1480.0 |
| 2016-09-30 06:36:00 | AAPL | Stock | 27.9825 | 27.9825 | 27.9825 | 27.9825 | 400.0 |
| 2016-09-30 06:37:00 | AAPL | Stock | 27.995 | 27.995 | 27.995 | 27.995 | 3748.0 |
| 2016-09-30 06:41:00 | AAPL | Stock | 27.995 | 27.995 | 27.995 | 27.995 | 1200.0 |
| 2016-09-30 06:42:00 | AAPL | Stock | 27.9825 | 27.9825 | 27.98 | 27.98 | 1200.0 |
| 2016-09-30 06:43:00 | AAPL | Stock | 27.9825 | 27.9825 | 27.9825 | 27.9825 | 1600.0 |
| 2016-09-30 06:45:00 | AAPL | Stock | 27.9775 | 27.9775 | 27.975 | 27.975 | 3200.0 |
| 2016-09-30 06:48:00 | AAPL | Stock | 27.9825 | 27.9825 | 27.9825 | 27.9825 | 1600.0 |
| 2016-09-30 06:53:00 | AAPL | Stock | 27.995 | 27.995 | 27.995 | 27.995 | 1200.0 |
| 2016-09-30 06:55:00 | AAPL | Stock | 27.995 | 28.0 | 27.995 | 28.0 | 9996.0 |
| 2016-09-30 07:00:00 | AAPL | Stock | 28.0775 | 28.0775 | 28.0775 | 28.0775 | 400.0 |
| 2016-09-30 07:01:00 | AAPL | Stock | 28.0775 | 28.0775 | 28.0775 | 28.0775 | 400.0 |
| 2016-09-30 07:02:00 | AAPL | Stock | 28.08 | 28.08 | 28.08 | 28.08 | 1600.0 |
| 2016-09-30 07:05:00 | AAPL | Stock | 28.08 | 28.08 | 28.08 | 28.08 | 844.0 |
| 2016-09-30 07:06:00 | AAPL | Stock | 28.1125 | 28.115 | 28.11 | 28.115 | 7700.0 |
| 2016-09-30 07:09:00 | AAPL | Stock | 28.11 | 28.11 | 28.0975 | 28.0975 | 8400.0 |
| 2016-09-30 07:10:00 | AAPL | Stock | 28.08 | 28.08 | 28.08 | 28.08 | 400.0 |
| 2016-09-30 07:13:00 | AAPL | Stock | 28.0825 | 28.0825 | 28.08 | 28.08 | 11920.0 |
| 2016-09-30 07:14:00 | AAPL | Stock | 28.09 | 28.09 | 28.09 | 28.09 | 1800.0 |
| 2016-09-30 07:21:00 | AAPL | Stock | 28.09 | 28.1 | 28.09 | 28.1 | 7800.0 |
| 2016-09-30 07:23:00 | AAPL | Stock | 28.09 | 28.1 | 28.0625 | 28.08 | 10900.0 |
| 2016-09-30 07:24:00 | AAPL | Stock | 28.0925 | 28.1125 | 28.0925 | 28.1125 | 10328.0 |
| 2016-09-30 07:25:00 | AAPL | Stock | 28.125 | 28.1275 | 28.125 | 28.125 | 3996.0 |
| 2016-09-30 07:26:00 | AAPL | Stock | 28.1425 | 28.1475 | 28.1425 | 28.1475 | 7200.0 |
| 2016-09-30 07:27:00 | AAPL | Stock | 28.15 | 28.15 | 28.15 | 28.15 | 3776.0 |
| 2016-09-30 07:29:00 | AAPL | Stock | 28.17 | 28.17 | 28.155 | 28.155 | 3724.0 |
| 2016-09-30 07:31:00 | AAPL | Stock | 28.155 | 28.155 | 28.1475 | 28.1475 | 4000.0 |
| 2016-09-30 07:35:00 | AAPL | Stock | 28.1375 | 28.15 | 28.1375 | 28.15 | 10976.0 |
| 2016-09-30 07:36:00 | AAPL | Stock | 28.16 | 28.16 | 28.16 | 28.16 | 400.0 |
| 2016-09-30 07:37:00 | AAPL | Stock | 28.17 | 28.2125 | 28.1675 | 28.2125 | 16000.0 |
| 2016-09-30 07:42:00 | AAPL | Stock | 28.1525 | 28.1525 | 28.1525 | 28.1525 | 1616.0 |
| 2016-09-30 07:44:00 | AAPL | Stock | 28.14 | 28.14 | 28.1 | 28.1 | 39200.0 |
| 2016-09-30 07:49:00 | AAPL | Stock | 28.1375 | 28.1375 | 28.1375 | 28.1375 | 2416.0 |
| 2016-09-30 07:52:00 | AAPL | Stock | 28.1275 | 28.1275 | 28.1275 | 28.1275 | 800.0 |
| 2016-09-30 07:54:00 | AAPL | Stock | 28.125 | 28.125 | 28.125 | 28.125 | 1960.0 |
> showing 50 of 1,071,297 rows — these rows as CSV