PREVIEW / stock_1min / 2019-12-17
file: by_date/stock_1min/2019/2019-12-17.parquet size: 17.2 MB rows: 1,163,858 symbols: 2,131
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-17 04:00:00 | AAPL | Stock | 70.075 | 70.075 | 70.075 | 70.075 | 604.0 |
| 2019-12-17 04:02:00 | AAPL | Stock | 70.05 | 70.05 | 70.05 | 70.05 | 400.0 |
| 2019-12-17 04:13:00 | AAPL | Stock | 69.965 | 69.965 | 69.965 | 69.965 | 400.0 |
| 2019-12-17 04:17:00 | AAPL | Stock | 69.95 | 69.95 | 69.95 | 69.95 | 612.0 |
| 2019-12-17 04:22:00 | AAPL | Stock | 69.9 | 69.9 | 69.9 | 69.9 | 904.0 |
| 2019-12-17 04:28:00 | AAPL | Stock | 69.9025 | 69.9025 | 69.9025 | 69.9025 | 1620.0 |
| 2019-12-17 04:34:00 | AAPL | Stock | 69.9175 | 69.9175 | 69.9175 | 69.9175 | 2000.0 |
| 2019-12-17 04:40:00 | AAPL | Stock | 69.9425 | 69.9425 | 69.9425 | 69.9425 | 400.0 |
| 2019-12-17 04:41:00 | AAPL | Stock | 69.8725 | 69.8725 | 69.8725 | 69.8725 | 400.0 |
| 2019-12-17 04:48:00 | AAPL | Stock | 69.9125 | 69.9125 | 69.9125 | 69.9125 | 1108.0 |
| 2019-12-17 05:08:00 | AAPL | Stock | 69.9375 | 69.9375 | 69.935 | 69.9375 | 2260.0 |
| 2019-12-17 05:09:00 | AAPL | Stock | 69.92 | 69.92 | 69.92 | 69.92 | 4944.0 |
| 2019-12-17 05:13:00 | AAPL | Stock | 69.9375 | 69.9375 | 69.9375 | 69.9375 | 1600.0 |
| 2019-12-17 05:14:00 | AAPL | Stock | 69.9475 | 69.9475 | 69.9475 | 69.9475 | 1408.0 |
| 2019-12-17 05:27:00 | AAPL | Stock | 69.975 | 69.975 | 69.975 | 69.975 | 400.0 |
| 2019-12-17 05:29:00 | AAPL | Stock | 69.995 | 70.0 | 69.995 | 70.0 | 932.0 |
| 2019-12-17 05:33:00 | AAPL | Stock | 70.03 | 70.03 | 70.03 | 70.03 | 400.0 |
| 2019-12-17 05:36:00 | AAPL | Stock | 69.9875 | 69.9875 | 69.9875 | 69.9875 | 1200.0 |
| 2019-12-17 05:38:00 | AAPL | Stock | 69.9925 | 69.9925 | 69.98 | 69.98 | 3460.0 |
| 2019-12-17 05:40:00 | AAPL | Stock | 69.9625 | 69.9625 | 69.9625 | 69.9625 | 7160.0 |
| 2019-12-17 05:42:00 | AAPL | Stock | 69.975 | 69.975 | 69.9725 | 69.9725 | 1400.0 |
| 2019-12-17 05:47:00 | AAPL | Stock | 69.975 | 69.975 | 69.975 | 69.975 | 400.0 |
| 2019-12-17 05:48:00 | AAPL | Stock | 69.975 | 69.975 | 69.975 | 69.975 | 4400.0 |
| 2019-12-17 05:57:00 | AAPL | Stock | 69.9675 | 69.9675 | 69.9675 | 69.9675 | 1480.0 |
| 2019-12-17 06:00:00 | AAPL | Stock | 69.965 | 69.965 | 69.965 | 69.965 | 1772.0 |
| 2019-12-17 06:02:00 | AAPL | Stock | 69.9875 | 69.9875 | 69.9875 | 69.9875 | 400.0 |
| 2019-12-17 06:09:00 | AAPL | Stock | 69.985 | 70.0225 | 69.985 | 70.0 | 6868.0 |
| 2019-12-17 06:10:00 | AAPL | Stock | 70.0175 | 70.0525 | 70.0175 | 70.0525 | 800.0 |
| 2019-12-17 06:11:00 | AAPL | Stock | 70.055 | 70.1475 | 69.895 | 70.0275 | 13060.0 |
| 2019-12-17 06:12:00 | AAPL | Stock | 70.015 | 70.015 | 70.0 | 70.0 | 5200.0 |
| 2019-12-17 06:13:00 | AAPL | Stock | 70.0 | 70.0 | 70.0 | 70.0 | 1200.0 |
| 2019-12-17 06:18:00 | AAPL | Stock | 69.9625 | 69.965 | 69.9625 | 69.965 | 1480.0 |
| 2019-12-17 06:22:00 | AAPL | Stock | 70.02 | 70.02 | 70.02 | 70.02 | 400.0 |
| 2019-12-17 06:24:00 | AAPL | Stock | 70.02 | 70.0225 | 70.02 | 70.0225 | 1812.0 |
| 2019-12-17 06:29:00 | AAPL | Stock | 70.025 | 70.025 | 70.025 | 70.025 | 400.0 |
| 2019-12-17 06:32:00 | AAPL | Stock | 70.025 | 70.025 | 69.95 | 69.95 | 5100.0 |
| 2019-12-17 06:33:00 | AAPL | Stock | 69.9125 | 70.0 | 69.9125 | 70.0 | 8176.0 |
| 2019-12-17 06:34:00 | AAPL | Stock | 69.8825 | 69.8825 | 69.79 | 69.79 | 4500.0 |
| 2019-12-17 06:37:00 | AAPL | Stock | 69.7625 | 69.7625 | 69.7525 | 69.7525 | 2556.0 |
| 2019-12-17 06:40:00 | AAPL | Stock | 69.715 | 69.715 | 69.66 | 69.66 | 2716.0 |
| 2019-12-17 06:41:00 | AAPL | Stock | 69.655 | 69.655 | 69.6175 | 69.6175 | 4460.0 |
| 2019-12-17 06:42:00 | AAPL | Stock | 69.6 | 69.6325 | 69.6 | 69.61 | 11560.0 |
| 2019-12-17 06:43:00 | AAPL | Stock | 69.625 | 69.625 | 69.625 | 69.625 | 800.0 |
| 2019-12-17 06:46:00 | AAPL | Stock | 69.6375 | 69.6375 | 69.63 | 69.63 | 1940.0 |
| 2019-12-17 06:50:00 | AAPL | Stock | 69.675 | 69.675 | 69.675 | 69.675 | 400.0 |
| 2019-12-17 06:52:00 | AAPL | Stock | 69.6775 | 69.6775 | 69.6775 | 69.6775 | 400.0 |
| 2019-12-17 06:54:00 | AAPL | Stock | 69.6675 | 69.6675 | 69.665 | 69.665 | 3200.0 |
| 2019-12-17 06:55:00 | AAPL | Stock | 69.665 | 69.665 | 69.6375 | 69.6375 | 5668.0 |
| 2019-12-17 06:56:00 | AAPL | Stock | 69.6375 | 69.6375 | 69.6025 | 69.6025 | 4544.0 |
| 2019-12-17 06:57:00 | AAPL | Stock | 69.6125 | 69.6125 | 69.6125 | 69.6125 | 3200.0 |
> showing 50 of 1,163,858 rows — these rows as CSV