PREVIEW / stock_1min / 2018-10-08
file: by_date/stock_1min/2018/2018-10-08.parquet size: 16.0 MB rows: 1,081,896 symbols: 2,306
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-08 04:05:00 | AAPL | Stock | 55.9975 | 55.9975 | 55.9975 | 55.9975 | 400.0 |
| 2018-10-08 04:09:00 | AAPL | Stock | 55.805 | 55.805 | 55.805 | 55.805 | 1856.0 |
| 2018-10-08 04:31:00 | AAPL | Stock | 55.805 | 55.805 | 55.805 | 55.805 | 520.0 |
| 2018-10-08 04:38:00 | AAPL | Stock | 55.785 | 55.785 | 55.785 | 55.785 | 400.0 |
| 2018-10-08 04:40:00 | AAPL | Stock | 55.775 | 55.775 | 55.775 | 55.775 | 1200.0 |
| 2018-10-08 04:44:00 | AAPL | Stock | 55.72 | 55.72 | 55.72 | 55.72 | 800.0 |
| 2018-10-08 05:03:00 | AAPL | Stock | 55.75 | 55.75 | 55.75 | 55.75 | 1396.0 |
| 2018-10-08 05:40:00 | AAPL | Stock | 55.7775 | 55.7775 | 55.7775 | 55.7775 | 748.0 |
| 2018-10-08 05:41:00 | AAPL | Stock | 55.7925 | 55.81 | 55.7925 | 55.81 | 4560.0 |
| 2018-10-08 05:42:00 | AAPL | Stock | 55.8625 | 55.8625 | 55.8625 | 55.8625 | 2000.0 |
| 2018-10-08 05:43:00 | AAPL | Stock | 55.8625 | 55.8625 | 55.8625 | 55.8625 | 2000.0 |
| 2018-10-08 05:57:00 | AAPL | Stock | 55.9375 | 55.9375 | 55.9375 | 55.9375 | 1616.0 |
| 2018-10-08 05:58:00 | AAPL | Stock | 55.94 | 55.94 | 55.93 | 55.9375 | 8740.0 |
| 2018-10-08 06:01:00 | AAPL | Stock | 55.97 | 55.97 | 55.9 | 55.9 | 3184.0 |
| 2018-10-08 06:02:00 | AAPL | Stock | 55.9175 | 55.9175 | 55.9175 | 55.9175 | 400.0 |
| 2018-10-08 06:03:00 | AAPL | Stock | 55.97 | 55.97 | 55.97 | 55.97 | 1640.0 |
| 2018-10-08 06:07:00 | AAPL | Stock | 55.97 | 55.97 | 55.97 | 55.97 | 1692.0 |
| 2018-10-08 06:15:00 | AAPL | Stock | 55.925 | 55.925 | 55.925 | 55.925 | 400.0 |
| 2018-10-08 06:16:00 | AAPL | Stock | 55.945 | 56.0 | 55.945 | 55.9975 | 10400.0 |
| 2018-10-08 06:20:00 | AAPL | Stock | 55.9125 | 55.9125 | 55.9125 | 55.9125 | 4000.0 |
| 2018-10-08 06:35:00 | AAPL | Stock | 55.9175 | 55.9175 | 55.8675 | 55.9175 | 9064.0 |
| 2018-10-08 06:36:00 | AAPL | Stock | 55.905 | 55.905 | 55.905 | 55.905 | 400.0 |
| 2018-10-08 06:42:00 | AAPL | Stock | 55.9 | 55.9 | 55.9 | 55.9 | 400.0 |
| 2018-10-08 06:43:00 | AAPL | Stock | 55.8825 | 55.8825 | 55.8825 | 55.8825 | 800.0 |
| 2018-10-08 06:48:00 | AAPL | Stock | 55.9475 | 55.9475 | 55.9475 | 55.9475 | 400.0 |
| 2018-10-08 07:00:00 | AAPL | Stock | 55.945 | 55.9575 | 55.9225 | 55.9475 | 28532.0 |
| 2018-10-08 07:01:00 | AAPL | Stock | 55.93 | 55.93 | 55.93 | 55.93 | 1200.0 |
| 2018-10-08 07:02:00 | AAPL | Stock | 55.9325 | 55.9325 | 55.9175 | 55.9175 | 6392.0 |
| 2018-10-08 07:04:00 | AAPL | Stock | 55.8925 | 55.8925 | 55.8925 | 55.8925 | 712.0 |
| 2018-10-08 07:06:00 | AAPL | Stock | 55.9 | 55.9 | 55.9 | 55.9 | 400.0 |
| 2018-10-08 07:07:00 | AAPL | Stock | 55.8925 | 55.8925 | 55.8675 | 55.8675 | 8548.0 |
| 2018-10-08 07:08:00 | AAPL | Stock | 55.8275 | 55.8275 | 55.8275 | 55.8275 | 400.0 |
| 2018-10-08 07:09:00 | AAPL | Stock | 55.85 | 55.85 | 55.85 | 55.85 | 800.0 |
| 2018-10-08 07:10:00 | AAPL | Stock | 55.87 | 55.875 | 55.8525 | 55.8525 | 3956.0 |
| 2018-10-08 07:11:00 | AAPL | Stock | 55.8875 | 55.8875 | 55.875 | 55.875 | 1600.0 |
| 2018-10-08 07:12:00 | AAPL | Stock | 55.8925 | 55.8925 | 55.8925 | 55.8925 | 400.0 |
| 2018-10-08 07:13:00 | AAPL | Stock | 55.8875 | 55.8875 | 55.8875 | 55.8875 | 400.0 |
| 2018-10-08 07:14:00 | AAPL | Stock | 55.8875 | 55.8875 | 55.875 | 55.875 | 800.0 |
| 2018-10-08 07:15:00 | AAPL | Stock | 55.875 | 55.875 | 55.85 | 55.85 | 3372.0 |
| 2018-10-08 07:16:00 | AAPL | Stock | 55.85 | 55.8725 | 55.85 | 55.8725 | 2896.0 |
| 2018-10-08 07:17:00 | AAPL | Stock | 55.8725 | 55.8725 | 55.8725 | 55.8725 | 800.0 |
| 2018-10-08 07:18:00 | AAPL | Stock | 55.8875 | 55.925 | 55.8875 | 55.925 | 12000.0 |
| 2018-10-08 07:19:00 | AAPL | Stock | 55.925 | 55.925 | 55.9125 | 55.9125 | 892.0 |
| 2018-10-08 07:20:00 | AAPL | Stock | 55.9 | 55.9975 | 55.9 | 55.9975 | 42516.0 |
| 2018-10-08 07:21:00 | AAPL | Stock | 55.97 | 55.9725 | 55.97 | 55.9725 | 800.0 |
| 2018-10-08 07:22:00 | AAPL | Stock | 55.945 | 55.975 | 55.945 | 55.975 | 2400.0 |
| 2018-10-08 07:23:00 | AAPL | Stock | 55.9425 | 55.945 | 55.93 | 55.93 | 3600.0 |
| 2018-10-08 07:24:00 | AAPL | Stock | 55.9075 | 55.945 | 55.9075 | 55.945 | 2800.0 |
| 2018-10-08 07:25:00 | AAPL | Stock | 55.9475 | 55.9675 | 55.9475 | 55.9675 | 1100.0 |
| 2018-10-08 07:26:00 | AAPL | Stock | 55.9725 | 56.0575 | 55.9725 | 56.0575 | 57376.0 |
> showing 50 of 1,081,896 rows — these rows as CSV