PREVIEW / stock_1min / 2016-05-23
file: by_date/stock_1min/2016/2016-05-23.parquet size: 14.1 MB rows: 1,047,266 symbols: 2,691
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-05-23 04:04:00 | AAPL | Stock | 23.875 | 23.925 | 23.875 | 23.925 | 7892.0 |
| 2016-05-23 04:12:00 | AAPL | Stock | 23.925 | 23.945 | 23.925 | 23.945 | 1996.0 |
| 2016-05-23 04:16:00 | AAPL | Stock | 23.9475 | 23.9475 | 23.9475 | 23.9475 | 960.0 |
| 2016-05-23 04:21:00 | AAPL | Stock | 23.9475 | 23.96 | 23.9475 | 23.96 | 8440.0 |
| 2016-05-23 04:22:00 | AAPL | Stock | 23.95 | 23.95 | 23.95 | 23.95 | 800.0 |
| 2016-05-23 04:23:00 | AAPL | Stock | 23.975 | 23.975 | 23.975 | 23.975 | 6400.0 |
| 2016-05-23 04:30:00 | AAPL | Stock | 23.9525 | 23.9525 | 23.9425 | 23.9425 | 1900.0 |
| 2016-05-23 05:50:00 | AAPL | Stock | 23.9675 | 23.9675 | 23.9675 | 23.9675 | 4000.0 |
| 2016-05-23 05:52:00 | AAPL | Stock | 23.935 | 23.935 | 23.925 | 23.925 | 1420.0 |
| 2016-05-23 05:53:00 | AAPL | Stock | 23.915 | 23.915 | 23.915 | 23.915 | 400.0 |
| 2016-05-23 05:54:00 | AAPL | Stock | 23.915 | 23.915 | 23.915 | 23.915 | 2400.0 |
| 2016-05-23 06:03:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.8875 | 23.8875 | 2280.0 |
| 2016-05-23 06:04:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.8875 | 23.8875 | 400.0 |
| 2016-05-23 06:05:00 | AAPL | Stock | 23.8775 | 23.8775 | 23.875 | 23.875 | 7376.0 |
| 2016-05-23 06:06:00 | AAPL | Stock | 23.855 | 23.855 | 23.855 | 23.855 | 1000.0 |
| 2016-05-23 06:08:00 | AAPL | Stock | 23.87 | 23.87 | 23.8625 | 23.8625 | 5000.0 |
| 2016-05-23 06:10:00 | AAPL | Stock | 23.8825 | 23.91 | 23.8825 | 23.91 | 1696.0 |
| 2016-05-23 06:16:00 | AAPL | Stock | 23.885 | 23.885 | 23.885 | 23.885 | 1200.0 |
| 2016-05-23 06:19:00 | AAPL | Stock | 23.885 | 23.885 | 23.885 | 23.885 | 640.0 |
| 2016-05-23 06:21:00 | AAPL | Stock | 23.9 | 23.9 | 23.8725 | 23.8725 | 2600.0 |
| 2016-05-23 06:22:00 | AAPL | Stock | 23.875 | 23.875 | 23.875 | 23.875 | 2076.0 |
| 2016-05-23 06:23:00 | AAPL | Stock | 23.8975 | 23.8975 | 23.8975 | 23.8975 | 400.0 |
| 2016-05-23 06:24:00 | AAPL | Stock | 23.875 | 23.875 | 23.875 | 23.875 | 400.0 |
| 2016-05-23 06:25:00 | AAPL | Stock | 23.8975 | 23.905 | 23.8875 | 23.8875 | 2800.0 |
| 2016-05-23 06:28:00 | AAPL | Stock | 23.9 | 23.91 | 23.9 | 23.91 | 4200.0 |
| 2016-05-23 06:29:00 | AAPL | Stock | 23.91 | 23.9125 | 23.91 | 23.9125 | 5604.0 |
| 2016-05-23 06:33:00 | AAPL | Stock | 23.89 | 23.89 | 23.89 | 23.89 | 800.0 |
| 2016-05-23 06:35:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.8875 | 23.8875 | 1200.0 |
| 2016-05-23 06:38:00 | AAPL | Stock | 23.9 | 23.9 | 23.875 | 23.875 | 800.0 |
| 2016-05-23 06:42:00 | AAPL | Stock | 23.89 | 23.89 | 23.89 | 23.89 | 800.0 |
| 2016-05-23 06:43:00 | AAPL | Stock | 23.905 | 23.91 | 23.905 | 23.91 | 1200.0 |
| 2016-05-23 06:47:00 | AAPL | Stock | 23.9025 | 23.9025 | 23.9025 | 23.9025 | 400.0 |
| 2016-05-23 06:49:00 | AAPL | Stock | 23.8975 | 23.8975 | 23.8925 | 23.8925 | 2700.0 |
| 2016-05-23 06:51:00 | AAPL | Stock | 23.8925 | 23.8925 | 23.8925 | 23.8925 | 4400.0 |
| 2016-05-23 06:52:00 | AAPL | Stock | 23.8925 | 23.8925 | 23.8925 | 23.8925 | 800.0 |
| 2016-05-23 06:54:00 | AAPL | Stock | 23.8925 | 23.8925 | 23.8925 | 23.8925 | 400.0 |
| 2016-05-23 06:55:00 | AAPL | Stock | 23.8925 | 23.8925 | 23.8925 | 23.8925 | 800.0 |
| 2016-05-23 06:56:00 | AAPL | Stock | 23.8925 | 23.8925 | 23.8925 | 23.8925 | 1568.0 |
| 2016-05-23 06:59:00 | AAPL | Stock | 23.89 | 23.8925 | 23.89 | 23.8925 | 3996.0 |
| 2016-05-23 07:00:00 | AAPL | Stock | 23.88 | 23.88 | 23.8775 | 23.8775 | 5124.0 |
| 2016-05-23 07:02:00 | AAPL | Stock | 23.8925 | 23.8925 | 23.8925 | 23.8925 | 804.0 |
| 2016-05-23 07:03:00 | AAPL | Stock | 23.8975 | 23.955 | 23.8975 | 23.955 | 33756.0 |
| 2016-05-23 07:04:00 | AAPL | Stock | 23.9625 | 23.97 | 23.9375 | 23.9375 | 4800.0 |
| 2016-05-23 07:05:00 | AAPL | Stock | 23.9625 | 23.9625 | 23.96 | 23.9625 | 10800.0 |
| 2016-05-23 07:06:00 | AAPL | Stock | 23.96 | 23.96 | 23.9375 | 23.9375 | 42728.0 |
| 2016-05-23 07:07:00 | AAPL | Stock | 23.955 | 23.955 | 23.925 | 23.925 | 1712.0 |
| 2016-05-23 07:08:00 | AAPL | Stock | 23.925 | 23.925 | 23.925 | 23.925 | 1000.0 |
| 2016-05-23 07:09:00 | AAPL | Stock | 23.9075 | 23.9075 | 23.9075 | 23.9075 | 3920.0 |
| 2016-05-23 07:11:00 | AAPL | Stock | 23.9075 | 23.9075 | 23.9075 | 23.9075 | 1600.0 |
| 2016-05-23 07:12:00 | AAPL | Stock | 23.93 | 23.93 | 23.93 | 23.93 | 800.0 |
> showing 50 of 1,047,266 rows — these rows as CSV