PREVIEW / stock_1min / 2019-10-17
file: by_date/stock_1min/2019/2019-10-17.parquet size: 14.8 MB rows: 1,061,602 symbols: 2,124
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-10-17 04:00:00 | AAPL | Stock | 58.6925 | 58.6925 | 58.6925 | 58.6925 | 800.0 |
| 2019-10-17 04:05:00 | AAPL | Stock | 58.6475 | 58.6475 | 58.6475 | 58.6475 | 684.0 |
| 2019-10-17 04:06:00 | AAPL | Stock | 58.6225 | 58.6225 | 58.6225 | 58.6225 | 780.0 |
| 2019-10-17 04:10:00 | AAPL | Stock | 58.65 | 58.65 | 58.65 | 58.65 | 400.0 |
| 2019-10-17 04:38:00 | AAPL | Stock | 58.7075 | 58.7075 | 58.7075 | 58.7075 | 3600.0 |
| 2019-10-17 04:39:00 | AAPL | Stock | 58.7075 | 58.7375 | 58.7075 | 58.7375 | 2000.0 |
| 2019-10-17 04:44:00 | AAPL | Stock | 58.7925 | 58.7925 | 58.7 | 58.7 | 2580.0 |
| 2019-10-17 05:17:00 | AAPL | Stock | 58.6875 | 58.6875 | 58.6875 | 58.6875 | 1600.0 |
| 2019-10-17 05:22:00 | AAPL | Stock | 58.72 | 58.72 | 58.72 | 58.72 | 400.0 |
| 2019-10-17 05:31:00 | AAPL | Stock | 58.7975 | 58.7975 | 58.7975 | 58.7975 | 1728.0 |
| 2019-10-17 05:32:00 | AAPL | Stock | 58.8575 | 58.875 | 58.8575 | 58.875 | 1692.0 |
| 2019-10-17 05:34:00 | AAPL | Stock | 58.95 | 58.95 | 58.95 | 58.95 | 800.0 |
| 2019-10-17 05:36:00 | AAPL | Stock | 58.9075 | 58.9075 | 58.9075 | 58.9075 | 800.0 |
| 2019-10-17 05:38:00 | AAPL | Stock | 58.96 | 58.965 | 58.875 | 58.875 | 2292.0 |
| 2019-10-17 05:39:00 | AAPL | Stock | 58.9125 | 58.9125 | 58.8825 | 58.8825 | 3900.0 |
| 2019-10-17 05:40:00 | AAPL | Stock | 58.89 | 58.89 | 58.89 | 58.89 | 400.0 |
| 2019-10-17 05:42:00 | AAPL | Stock | 58.875 | 58.875 | 58.875 | 58.875 | 2000.0 |
| 2019-10-17 05:43:00 | AAPL | Stock | 58.935 | 58.935 | 58.935 | 58.935 | 1200.0 |
| 2019-10-17 05:44:00 | AAPL | Stock | 58.925 | 58.925 | 58.925 | 58.925 | 1700.0 |
| 2019-10-17 05:46:00 | AAPL | Stock | 58.92 | 58.92 | 58.92 | 58.92 | 400.0 |
| 2019-10-17 05:47:00 | AAPL | Stock | 58.9 | 58.925 | 58.9 | 58.925 | 3428.0 |
| 2019-10-17 05:49:00 | AAPL | Stock | 58.88 | 58.88 | 58.875 | 58.875 | 800.0 |
| 2019-10-17 05:53:00 | AAPL | Stock | 58.9 | 58.9125 | 58.9 | 58.9125 | 5080.0 |
| 2019-10-17 05:54:00 | AAPL | Stock | 58.9375 | 58.9375 | 58.9375 | 58.9375 | 800.0 |
| 2019-10-17 06:07:00 | AAPL | Stock | 58.925 | 58.925 | 58.925 | 58.925 | 3600.0 |
| 2019-10-17 06:09:00 | AAPL | Stock | 58.9575 | 58.96 | 58.925 | 58.925 | 3608.0 |
| 2019-10-17 06:10:00 | AAPL | Stock | 58.95 | 58.95 | 58.95 | 58.95 | 2000.0 |
| 2019-10-17 06:11:00 | AAPL | Stock | 58.96 | 58.96 | 58.96 | 58.96 | 1708.0 |
| 2019-10-17 06:17:00 | AAPL | Stock | 58.9275 | 58.9275 | 58.9275 | 58.9275 | 400.0 |
| 2019-10-17 06:24:00 | AAPL | Stock | 58.9275 | 58.9275 | 58.9275 | 58.9275 | 400.0 |
| 2019-10-17 06:26:00 | AAPL | Stock | 58.925 | 58.9275 | 58.925 | 58.9275 | 7912.0 |
| 2019-10-17 06:29:00 | AAPL | Stock | 58.95 | 58.95 | 58.95 | 58.95 | 800.0 |
| 2019-10-17 06:30:00 | AAPL | Stock | 58.935 | 58.935 | 58.89 | 58.89 | 8300.0 |
| 2019-10-17 06:35:00 | AAPL | Stock | 58.9 | 58.9 | 58.9 | 58.9 | 400.0 |
| 2019-10-17 06:39:00 | AAPL | Stock | 58.9325 | 58.9325 | 58.9325 | 58.9325 | 400.0 |
| 2019-10-17 06:46:00 | AAPL | Stock | 58.93 | 58.93 | 58.93 | 58.93 | 2400.0 |
| 2019-10-17 06:47:00 | AAPL | Stock | 58.93 | 58.93 | 58.93 | 58.93 | 400.0 |
| 2019-10-17 06:49:00 | AAPL | Stock | 58.93 | 58.9325 | 58.93 | 58.9325 | 904.0 |
| 2019-10-17 06:54:00 | AAPL | Stock | 58.92 | 58.9325 | 58.92 | 58.925 | 6800.0 |
| 2019-10-17 06:57:00 | AAPL | Stock | 58.9125 | 58.9125 | 58.9125 | 58.9125 | 400.0 |
| 2019-10-17 07:00:00 | AAPL | Stock | 58.9725 | 58.9775 | 58.8275 | 58.94 | 36420.0 |
| 2019-10-17 07:01:00 | AAPL | Stock | 58.93 | 58.93 | 58.88 | 58.88 | 5760.0 |
| 2019-10-17 07:03:00 | AAPL | Stock | 58.92 | 58.92 | 58.92 | 58.92 | 400.0 |
| 2019-10-17 07:04:00 | AAPL | Stock | 58.9175 | 58.9175 | 58.9175 | 58.9175 | 400.0 |
| 2019-10-17 07:05:00 | AAPL | Stock | 58.875 | 58.875 | 58.8275 | 58.8275 | 24628.0 |
| 2019-10-17 07:09:00 | AAPL | Stock | 58.8625 | 58.8625 | 58.8625 | 58.8625 | 1600.0 |
| 2019-10-17 07:10:00 | AAPL | Stock | 58.8625 | 58.8675 | 58.8625 | 58.8675 | 1600.0 |
| 2019-10-17 07:12:00 | AAPL | Stock | 58.8625 | 58.8625 | 58.8625 | 58.8625 | 1000.0 |
| 2019-10-17 07:13:00 | AAPL | Stock | 58.8625 | 58.8625 | 58.8625 | 58.8625 | 1600.0 |
| 2019-10-17 07:14:00 | AAPL | Stock | 58.8725 | 58.875 | 58.8725 | 58.875 | 2168.0 |
> showing 50 of 1,061,602 rows — these rows as CSV