PREVIEW / stock_1min / 2015-11-23
file: by_date/stock_1min/2015/2015-11-23.parquet size: 14.8 MB rows: 1,070,824 symbols: 2,794
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-23 04:00:00 | AAPL | Stock | 29.825 | 29.825 | 29.825 | 29.825 | 2000.0 |
| 2015-11-23 04:07:00 | AAPL | Stock | 29.7625 | 29.7625 | 29.7075 | 29.7075 | 11072.0 |
| 2015-11-23 04:08:00 | AAPL | Stock | 29.6275 | 29.6275 | 29.6275 | 29.6275 | 1200.0 |
| 2015-11-23 04:13:00 | AAPL | Stock | 29.775 | 29.775 | 29.75 | 29.75 | 1020.0 |
| 2015-11-23 04:57:00 | AAPL | Stock | 29.7925 | 29.7925 | 29.7925 | 29.7925 | 400.0 |
| 2015-11-23 05:24:00 | AAPL | Stock | 29.765 | 29.765 | 29.7625 | 29.7625 | 1200.0 |
| 2015-11-23 06:24:00 | AAPL | Stock | 29.77 | 29.77 | 29.77 | 29.77 | 800.0 |
| 2015-11-23 06:28:00 | AAPL | Stock | 29.7625 | 29.7625 | 29.7625 | 29.7625 | 1132.0 |
| 2015-11-23 06:38:00 | AAPL | Stock | 29.7425 | 29.7425 | 29.7425 | 29.7425 | 400.0 |
| 2015-11-23 06:43:00 | AAPL | Stock | 29.7625 | 29.7625 | 29.7625 | 29.7625 | 800.0 |
| 2015-11-23 06:44:00 | AAPL | Stock | 29.7425 | 29.7425 | 29.7425 | 29.7425 | 776.0 |
| 2015-11-23 07:04:00 | AAPL | Stock | 29.7975 | 29.7975 | 29.79 | 29.79 | 4000.0 |
| 2015-11-23 07:05:00 | AAPL | Stock | 29.7975 | 29.8125 | 29.7975 | 29.8125 | 10800.0 |
| 2015-11-23 07:06:00 | AAPL | Stock | 29.86 | 29.8625 | 29.86 | 29.86 | 3200.0 |
| 2015-11-23 07:07:00 | AAPL | Stock | 29.845 | 29.85 | 29.845 | 29.85 | 4000.0 |
| 2015-11-23 07:08:00 | AAPL | Stock | 29.85 | 29.85 | 29.85 | 29.85 | 400.0 |
| 2015-11-23 07:10:00 | AAPL | Stock | 29.9125 | 29.9125 | 29.9125 | 29.9125 | 5208.0 |
| 2015-11-23 07:11:00 | AAPL | Stock | 29.9125 | 29.925 | 29.9125 | 29.925 | 1600.0 |
| 2015-11-23 07:12:00 | AAPL | Stock | 29.945 | 29.945 | 29.945 | 29.945 | 400.0 |
| 2015-11-23 07:19:00 | AAPL | Stock | 29.9275 | 29.9275 | 29.9275 | 29.9275 | 2000.0 |
| 2015-11-23 07:34:00 | AAPL | Stock | 29.92 | 29.92 | 29.92 | 29.92 | 400.0 |
| 2015-11-23 07:36:00 | AAPL | Stock | 29.9225 | 29.9225 | 29.9225 | 29.9225 | 404.0 |
| 2015-11-23 07:38:00 | AAPL | Stock | 29.925 | 29.9375 | 29.9225 | 29.935 | 10200.0 |
| 2015-11-23 07:40:00 | AAPL | Stock | 29.9275 | 29.9275 | 29.9275 | 29.9275 | 800.0 |
| 2015-11-23 07:41:00 | AAPL | Stock | 29.9375 | 29.9375 | 29.9375 | 29.9375 | 1200.0 |
| 2015-11-23 07:43:00 | AAPL | Stock | 29.915 | 29.915 | 29.915 | 29.915 | 400.0 |
| 2015-11-23 07:44:00 | AAPL | Stock | 29.915 | 29.915 | 29.915 | 29.915 | 400.0 |
| 2015-11-23 07:45:00 | AAPL | Stock | 29.9125 | 29.9125 | 29.885 | 29.885 | 16544.0 |
| 2015-11-23 07:48:00 | AAPL | Stock | 29.885 | 29.885 | 29.885 | 29.885 | 1200.0 |
| 2015-11-23 07:49:00 | AAPL | Stock | 29.885 | 29.885 | 29.885 | 29.885 | 400.0 |
| 2015-11-23 07:50:00 | AAPL | Stock | 29.8825 | 29.8825 | 29.8825 | 29.8825 | 400.0 |
| 2015-11-23 07:51:00 | AAPL | Stock | 29.88 | 29.88 | 29.88 | 29.88 | 920.0 |
| 2015-11-23 07:53:00 | AAPL | Stock | 29.8825 | 29.8825 | 29.8825 | 29.8825 | 516.0 |
| 2015-11-23 07:55:00 | AAPL | Stock | 29.8825 | 29.885 | 29.8825 | 29.885 | 3484.0 |
| 2015-11-23 07:59:00 | AAPL | Stock | 29.9075 | 29.9075 | 29.9075 | 29.9075 | 11788.0 |
| 2015-11-23 08:00:00 | AAPL | Stock | 29.905 | 29.93 | 29.775 | 29.91 | 14644.0 |
| 2015-11-23 08:02:00 | AAPL | Stock | 29.9125 | 29.92 | 29.905 | 29.9175 | 22108.0 |
| 2015-11-23 08:03:00 | AAPL | Stock | 29.905 | 29.9225 | 29.905 | 29.9225 | 2640.0 |
| 2015-11-23 08:04:00 | AAPL | Stock | 29.9225 | 29.9225 | 29.9225 | 29.9225 | 860.0 |
| 2015-11-23 08:05:00 | AAPL | Stock | 29.95 | 29.95 | 29.9175 | 29.9175 | 22868.0 |
| 2015-11-23 08:06:00 | AAPL | Stock | 29.9175 | 29.9175 | 29.9175 | 29.9175 | 3404.0 |
| 2015-11-23 08:08:00 | AAPL | Stock | 29.9075 | 29.9075 | 29.9 | 29.9 | 7988.0 |
| 2015-11-23 08:09:00 | AAPL | Stock | 29.885 | 29.885 | 29.885 | 29.885 | 3944.0 |
| 2015-11-23 08:10:00 | AAPL | Stock | 29.8875 | 29.8875 | 29.8775 | 29.8775 | 10108.0 |
| 2015-11-23 08:11:00 | AAPL | Stock | 29.895 | 29.915 | 29.895 | 29.9075 | 5600.0 |
| 2015-11-23 08:12:00 | AAPL | Stock | 29.915 | 29.92 | 29.915 | 29.92 | 2400.0 |
| 2015-11-23 08:13:00 | AAPL | Stock | 29.885 | 29.915 | 29.885 | 29.915 | 6000.0 |
| 2015-11-23 08:15:00 | AAPL | Stock | 29.905 | 29.905 | 29.9025 | 29.905 | 1600.0 |
| 2015-11-23 08:16:00 | AAPL | Stock | 29.9075 | 29.915 | 29.9 | 29.915 | 7600.0 |
| 2015-11-23 08:17:00 | AAPL | Stock | 29.9175 | 29.925 | 29.9175 | 29.925 | 1200.0 |
> showing 50 of 1,070,824 rows — these rows as CSV