PREVIEW / stock_1min / 2018-06-12
file: by_date/stock_1min/2018/2018-06-12.parquet size: 15.4 MB rows: 1,095,731 symbols: 2,355
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-06-12 04:03:00 | AAPL | Stock | 47.8725 | 47.8725 | 47.8725 | 47.8725 | 400.0 |
| 2018-06-12 04:06:00 | AAPL | Stock | 47.8725 | 47.8725 | 47.8725 | 47.8725 | 400.0 |
| 2018-06-12 04:24:00 | AAPL | Stock | 47.8425 | 47.8425 | 47.8425 | 47.8425 | 400.0 |
| 2018-06-12 04:33:00 | AAPL | Stock | 47.83 | 47.83 | 47.83 | 47.83 | 400.0 |
| 2018-06-12 07:00:00 | AAPL | Stock | 47.75 | 47.7925 | 47.75 | 47.7925 | 3888.0 |
| 2018-06-12 07:01:00 | AAPL | Stock | 47.775 | 47.775 | 47.775 | 47.775 | 952.0 |
| 2018-06-12 07:05:00 | AAPL | Stock | 47.775 | 47.775 | 47.775 | 47.775 | 1600.0 |
| 2018-06-12 07:10:00 | AAPL | Stock | 47.78 | 47.78 | 47.78 | 47.78 | 400.0 |
| 2018-06-12 07:11:00 | AAPL | Stock | 47.7975 | 47.83 | 47.7975 | 47.83 | 16400.0 |
| 2018-06-12 07:19:00 | AAPL | Stock | 47.7875 | 47.79 | 47.7875 | 47.79 | 1364.0 |
| 2018-06-12 07:20:00 | AAPL | Stock | 47.7875 | 47.8025 | 47.7875 | 47.8025 | 2400.0 |
| 2018-06-12 07:24:00 | AAPL | Stock | 47.7625 | 47.765 | 47.7625 | 47.765 | 3568.0 |
| 2018-06-12 07:28:00 | AAPL | Stock | 47.775 | 47.775 | 47.775 | 47.775 | 400.0 |
| 2018-06-12 07:29:00 | AAPL | Stock | 47.7625 | 47.7625 | 47.7625 | 47.7625 | 400.0 |
| 2018-06-12 07:30:00 | AAPL | Stock | 47.8 | 47.8075 | 47.8 | 47.8075 | 5564.0 |
| 2018-06-12 07:31:00 | AAPL | Stock | 47.78 | 47.78 | 47.755 | 47.755 | 2388.0 |
| 2018-06-12 07:38:00 | AAPL | Stock | 47.8075 | 47.8075 | 47.8075 | 47.8075 | 1276.0 |
| 2018-06-12 07:39:00 | AAPL | Stock | 47.79 | 47.79 | 47.79 | 47.79 | 400.0 |
| 2018-06-12 07:40:00 | AAPL | Stock | 47.8075 | 47.8075 | 47.8075 | 47.8075 | 7860.0 |
| 2018-06-12 07:47:00 | AAPL | Stock | 47.8 | 47.8 | 47.8 | 47.8 | 400.0 |
| 2018-06-12 07:54:00 | AAPL | Stock | 47.8175 | 47.825 | 47.8175 | 47.825 | 9880.0 |
| 2018-06-12 08:00:00 | AAPL | Stock | 47.8075 | 47.9125 | 47.7525 | 47.8325 | 36504.0 |
| 2018-06-12 08:01:00 | AAPL | Stock | 47.8 | 47.8325 | 47.8 | 47.8325 | 4820.0 |
| 2018-06-12 08:03:00 | AAPL | Stock | 47.83 | 47.83 | 47.83 | 47.83 | 5000.0 |
| 2018-06-12 08:06:00 | AAPL | Stock | 47.8325 | 47.8375 | 47.8325 | 47.8375 | 7572.0 |
| 2018-06-12 08:07:00 | AAPL | Stock | 47.8375 | 47.8375 | 47.8375 | 47.8375 | 800.0 |
| 2018-06-12 08:08:00 | AAPL | Stock | 47.8325 | 47.8325 | 47.825 | 47.8325 | 2080.0 |
| 2018-06-12 08:09:00 | AAPL | Stock | 47.8325 | 47.835 | 47.8325 | 47.835 | 1444.0 |
| 2018-06-12 08:11:00 | AAPL | Stock | 47.835 | 47.835 | 47.835 | 47.835 | 956.0 |
| 2018-06-12 08:12:00 | AAPL | Stock | 47.8375 | 47.8375 | 47.8375 | 47.8375 | 400.0 |
| 2018-06-12 08:13:00 | AAPL | Stock | 47.83 | 47.83 | 47.83 | 47.83 | 800.0 |
| 2018-06-12 08:14:00 | AAPL | Stock | 47.8275 | 47.8275 | 47.825 | 47.825 | 800.0 |
| 2018-06-12 08:15:00 | AAPL | Stock | 47.83 | 47.83 | 47.8125 | 47.8175 | 5052.0 |
| 2018-06-12 08:17:00 | AAPL | Stock | 47.825 | 47.825 | 47.8125 | 47.8125 | 4488.0 |
| 2018-06-12 08:19:00 | AAPL | Stock | 47.8125 | 47.8175 | 47.8125 | 47.8125 | 3352.0 |
| 2018-06-12 08:20:00 | AAPL | Stock | 47.8125 | 47.8125 | 47.8125 | 47.8125 | 1300.0 |
| 2018-06-12 08:21:00 | AAPL | Stock | 47.8125 | 47.8175 | 47.8125 | 47.8175 | 11000.0 |
| 2018-06-12 08:23:00 | AAPL | Stock | 47.8175 | 47.8175 | 47.8175 | 47.8175 | 4000.0 |
| 2018-06-12 08:24:00 | AAPL | Stock | 47.815 | 47.8325 | 47.815 | 47.83 | 3600.0 |
| 2018-06-12 08:25:00 | AAPL | Stock | 47.8325 | 47.8325 | 47.8325 | 47.8325 | 1032.0 |
| 2018-06-12 08:26:00 | AAPL | Stock | 47.835 | 47.835 | 47.8325 | 47.8325 | 900.0 |
| 2018-06-12 08:27:00 | AAPL | Stock | 47.8325 | 47.8375 | 47.8325 | 47.8375 | 4956.0 |
| 2018-06-12 08:28:00 | AAPL | Stock | 47.8375 | 47.85 | 47.8375 | 47.85 | 36388.0 |
| 2018-06-12 08:29:00 | AAPL | Stock | 47.825 | 47.825 | 47.825 | 47.825 | 1320.0 |
| 2018-06-12 08:31:00 | AAPL | Stock | 47.835 | 47.8625 | 47.835 | 47.855 | 4860.0 |
| 2018-06-12 08:33:00 | AAPL | Stock | 47.8625 | 47.8625 | 47.8625 | 47.8625 | 4000.0 |
| 2018-06-12 08:37:00 | AAPL | Stock | 47.8375 | 47.8375 | 47.8275 | 47.8275 | 6600.0 |
| 2018-06-12 08:38:00 | AAPL | Stock | 47.8375 | 47.85 | 47.8375 | 47.85 | 1264.0 |
| 2018-06-12 08:39:00 | AAPL | Stock | 47.8475 | 47.8475 | 47.8475 | 47.8475 | 800.0 |
| 2018-06-12 08:40:00 | AAPL | Stock | 47.8475 | 47.8475 | 47.8475 | 47.8475 | 400.0 |
> showing 50 of 1,095,731 rows — these rows as CSV