PREVIEW / stock_1min / 2016-09-26
file: by_date/stock_1min/2016/2016-09-26.parquet size: 13.6 MB rows: 1,008,415 symbols: 2,654
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-26 04:00:00 | AAPL | Stock | 27.8225 | 27.8225 | 27.8225 | 27.8225 | 400.0 |
| 2016-09-26 04:01:00 | AAPL | Stock | 27.8875 | 27.9225 | 27.8875 | 27.9225 | 3200.0 |
| 2016-09-26 04:05:00 | AAPL | Stock | 27.9225 | 27.9225 | 27.9225 | 27.9225 | 1200.0 |
| 2016-09-26 04:07:00 | AAPL | Stock | 27.875 | 27.875 | 27.875 | 27.875 | 1596.0 |
| 2016-09-26 04:12:00 | AAPL | Stock | 27.8475 | 27.8475 | 27.8475 | 27.8475 | 400.0 |
| 2016-09-26 04:14:00 | AAPL | Stock | 27.8225 | 27.8225 | 27.8225 | 27.8225 | 1200.0 |
| 2016-09-26 04:16:00 | AAPL | Stock | 27.7775 | 27.7775 | 27.7775 | 27.7775 | 1240.0 |
| 2016-09-26 04:20:00 | AAPL | Stock | 27.755 | 27.7575 | 27.755 | 27.7575 | 800.0 |
| 2016-09-26 04:25:00 | AAPL | Stock | 27.8125 | 27.8125 | 27.8125 | 27.8125 | 400.0 |
| 2016-09-26 04:27:00 | AAPL | Stock | 27.85 | 27.86 | 27.85 | 27.85 | 19504.0 |
| 2016-09-26 04:28:00 | AAPL | Stock | 27.825 | 27.825 | 27.825 | 27.825 | 3028.0 |
| 2016-09-26 04:29:00 | AAPL | Stock | 27.83 | 27.83 | 27.825 | 27.825 | 2800.0 |
| 2016-09-26 04:32:00 | AAPL | Stock | 27.86 | 27.86 | 27.86 | 27.86 | 400.0 |
| 2016-09-26 04:33:00 | AAPL | Stock | 27.8625 | 27.865 | 27.8625 | 27.865 | 4448.0 |
| 2016-09-26 04:34:00 | AAPL | Stock | 27.8625 | 27.8625 | 27.8625 | 27.8625 | 2096.0 |
| 2016-09-26 04:39:00 | AAPL | Stock | 27.8825 | 27.8825 | 27.88 | 27.8825 | 10000.0 |
| 2016-09-26 04:44:00 | AAPL | Stock | 27.92 | 27.92 | 27.92 | 27.92 | 2000.0 |
| 2016-09-26 04:46:00 | AAPL | Stock | 27.885 | 27.885 | 27.885 | 27.885 | 584.0 |
| 2016-09-26 04:52:00 | AAPL | Stock | 27.88 | 27.88 | 27.88 | 27.88 | 4000.0 |
| 2016-09-26 04:53:00 | AAPL | Stock | 27.88 | 27.88 | 27.88 | 27.88 | 1200.0 |
| 2016-09-26 04:55:00 | AAPL | Stock | 27.85 | 27.85 | 27.85 | 27.85 | 492.0 |
| 2016-09-26 04:56:00 | AAPL | Stock | 27.85 | 27.85 | 27.85 | 27.85 | 1180.0 |
| 2016-09-26 05:07:00 | AAPL | Stock | 27.875 | 27.9 | 27.875 | 27.9 | 6508.0 |
| 2016-09-26 05:08:00 | AAPL | Stock | 27.9025 | 27.9075 | 27.9025 | 27.9075 | 8000.0 |
| 2016-09-26 05:11:00 | AAPL | Stock | 27.84 | 27.84 | 27.84 | 27.84 | 436.0 |
| 2016-09-26 05:30:00 | AAPL | Stock | 27.875 | 27.875 | 27.875 | 27.875 | 2000.0 |
| 2016-09-26 05:50:00 | AAPL | Stock | 27.8625 | 27.8625 | 27.85 | 27.85 | 3300.0 |
| 2016-09-26 05:58:00 | AAPL | Stock | 27.8775 | 27.8775 | 27.8775 | 27.8775 | 724.0 |
| 2016-09-26 06:02:00 | AAPL | Stock | 27.8975 | 27.9 | 27.8975 | 27.9 | 6000.0 |
| 2016-09-26 06:03:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.895 | 27.895 | 1208.0 |
| 2016-09-26 06:08:00 | AAPL | Stock | 27.9 | 27.9125 | 27.9 | 27.9125 | 4924.0 |
| 2016-09-26 06:09:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 3992.0 |
| 2016-09-26 06:12:00 | AAPL | Stock | 27.925 | 27.9375 | 27.925 | 27.9375 | 7760.0 |
| 2016-09-26 06:14:00 | AAPL | Stock | 27.9425 | 27.9425 | 27.9425 | 27.9425 | 1600.0 |
| 2016-09-26 06:15:00 | AAPL | Stock | 27.945 | 27.95 | 27.945 | 27.945 | 8820.0 |
| 2016-09-26 06:16:00 | AAPL | Stock | 27.925 | 27.925 | 27.8775 | 27.8775 | 3152.0 |
| 2016-09-26 06:25:00 | AAPL | Stock | 27.925 | 27.9375 | 27.8875 | 27.9375 | 12800.0 |
| 2016-09-26 06:27:00 | AAPL | Stock | 27.9625 | 27.9625 | 27.9625 | 27.9625 | 608.0 |
| 2016-09-26 06:30:00 | AAPL | Stock | 27.8975 | 27.9375 | 27.8975 | 27.9375 | 3200.0 |
| 2016-09-26 06:33:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 2800.0 |
| 2016-09-26 06:34:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 5200.0 |
| 2016-09-26 06:39:00 | AAPL | Stock | 27.935 | 27.935 | 27.935 | 27.935 | 1424.0 |
| 2016-09-26 06:45:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 4000.0 |
| 2016-09-26 06:54:00 | AAPL | Stock | 27.93 | 27.93 | 27.93 | 27.93 | 800.0 |
| 2016-09-26 07:03:00 | AAPL | Stock | 27.95 | 27.9625 | 27.95 | 27.9625 | 8052.0 |
| 2016-09-26 07:04:00 | AAPL | Stock | 27.9625 | 27.985 | 27.9625 | 27.985 | 11632.0 |
| 2016-09-26 07:05:00 | AAPL | Stock | 27.99 | 28.0 | 27.99 | 28.0 | 10400.0 |
| 2016-09-26 07:07:00 | AAPL | Stock | 28.0375 | 28.0375 | 28.0375 | 28.0375 | 5420.0 |
| 2016-09-26 07:08:00 | AAPL | Stock | 28.025 | 28.025 | 28.0 | 28.0 | 11200.0 |
| 2016-09-26 07:09:00 | AAPL | Stock | 27.995 | 27.995 | 27.985 | 27.985 | 15284.0 |
> showing 50 of 1,008,415 rows — these rows as CSV