PREVIEW / stock_1min / 2018-01-02
file: by_date/stock_1min/2018/2018-01-02.parquet size: 16.6 MB rows: 1,125,640 symbols: 2,432
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-01-02 04:00:00 | AAPL | Stock | 42.275 | 42.275 | 42.275 | 42.275 | 3600.0 |
| 2018-01-02 04:05:00 | AAPL | Stock | 42.2775 | 42.2775 | 42.2775 | 42.2775 | 3748.0 |
| 2018-01-02 04:42:00 | AAPL | Stock | 42.3 | 42.3 | 42.3 | 42.3 | 4000.0 |
| 2018-01-02 04:52:00 | AAPL | Stock | 42.29 | 42.29 | 42.29 | 42.29 | 672.0 |
| 2018-01-02 04:55:00 | AAPL | Stock | 42.285 | 42.285 | 42.275 | 42.275 | 11972.0 |
| 2018-01-02 04:56:00 | AAPL | Stock | 42.275 | 42.275 | 42.275 | 42.275 | 1248.0 |
| 2018-01-02 04:57:00 | AAPL | Stock | 42.275 | 42.275 | 42.275 | 42.275 | 4800.0 |
| 2018-01-02 04:58:00 | AAPL | Stock | 42.275 | 42.275 | 42.275 | 42.275 | 2000.0 |
| 2018-01-02 04:59:00 | AAPL | Stock | 42.295 | 42.295 | 42.295 | 42.295 | 400.0 |
| 2018-01-02 05:00:00 | AAPL | Stock | 42.3125 | 42.3125 | 42.3125 | 42.3125 | 400.0 |
| 2018-01-02 05:02:00 | AAPL | Stock | 42.3125 | 42.3125 | 42.3125 | 42.3125 | 400.0 |
| 2018-01-02 05:05:00 | AAPL | Stock | 42.2875 | 42.2875 | 42.275 | 42.275 | 4000.0 |
| 2018-01-02 05:07:00 | AAPL | Stock | 42.2775 | 42.2775 | 42.2775 | 42.2775 | 600.0 |
| 2018-01-02 05:08:00 | AAPL | Stock | 42.28 | 42.3225 | 42.275 | 42.275 | 5624.0 |
| 2018-01-02 05:09:00 | AAPL | Stock | 42.2525 | 42.2525 | 42.25 | 42.25 | 2696.0 |
| 2018-01-02 05:15:00 | AAPL | Stock | 42.2575 | 42.2575 | 42.2575 | 42.2575 | 1996.0 |
| 2018-01-02 05:16:00 | AAPL | Stock | 42.2575 | 42.2575 | 42.2575 | 42.2575 | 400.0 |
| 2018-01-02 05:19:00 | AAPL | Stock | 42.2975 | 42.2975 | 42.2975 | 42.2975 | 400.0 |
| 2018-01-02 05:23:00 | AAPL | Stock | 42.295 | 42.295 | 42.295 | 42.295 | 1200.0 |
| 2018-01-02 05:25:00 | AAPL | Stock | 42.295 | 42.2975 | 42.295 | 42.2975 | 1392.0 |
| 2018-01-02 05:45:00 | AAPL | Stock | 42.3375 | 42.3375 | 42.3375 | 42.3375 | 400.0 |
| 2018-01-02 06:06:00 | AAPL | Stock | 42.335 | 42.335 | 42.335 | 42.335 | 800.0 |
| 2018-01-02 06:07:00 | AAPL | Stock | 42.335 | 42.335 | 42.335 | 42.335 | 4656.0 |
| 2018-01-02 06:08:00 | AAPL | Stock | 42.335 | 42.335 | 42.335 | 42.335 | 14000.0 |
| 2018-01-02 06:44:00 | AAPL | Stock | 42.37 | 42.3725 | 42.37 | 42.3725 | 2464.0 |
| 2018-01-02 06:49:00 | AAPL | Stock | 42.3725 | 42.3725 | 42.3725 | 42.3725 | 1200.0 |
| 2018-01-02 06:50:00 | AAPL | Stock | 42.3725 | 42.3725 | 42.3725 | 42.3725 | 1200.0 |
| 2018-01-02 06:53:00 | AAPL | Stock | 42.3725 | 42.3725 | 42.3725 | 42.3725 | 1384.0 |
| 2018-01-02 06:54:00 | AAPL | Stock | 42.385 | 42.385 | 42.385 | 42.385 | 400.0 |
| 2018-01-02 06:57:00 | AAPL | Stock | 42.395 | 42.4175 | 42.395 | 42.4175 | 19456.0 |
| 2018-01-02 07:00:00 | AAPL | Stock | 42.38 | 42.4 | 42.3775 | 42.3875 | 16068.0 |
| 2018-01-02 07:02:00 | AAPL | Stock | 42.4 | 42.4 | 42.4 | 42.4 | 400.0 |
| 2018-01-02 07:04:00 | AAPL | Stock | 42.4075 | 42.4075 | 42.4075 | 42.4075 | 400.0 |
| 2018-01-02 07:05:00 | AAPL | Stock | 42.4125 | 42.4125 | 42.4125 | 42.4125 | 2400.0 |
| 2018-01-02 07:06:00 | AAPL | Stock | 42.42 | 42.42 | 42.42 | 42.42 | 800.0 |
| 2018-01-02 07:07:00 | AAPL | Stock | 42.42 | 42.42 | 42.42 | 42.42 | 6400.0 |
| 2018-01-02 07:10:00 | AAPL | Stock | 42.425 | 42.425 | 42.425 | 42.425 | 400.0 |
| 2018-01-02 07:11:00 | AAPL | Stock | 42.4475 | 42.4475 | 42.44 | 42.44 | 4800.0 |
| 2018-01-02 07:12:00 | AAPL | Stock | 42.4525 | 42.4525 | 42.4525 | 42.4525 | 4560.0 |
| 2018-01-02 07:17:00 | AAPL | Stock | 42.455 | 42.455 | 42.455 | 42.455 | 400.0 |
| 2018-01-02 07:18:00 | AAPL | Stock | 42.4525 | 42.4525 | 42.4525 | 42.4525 | 1016.0 |
| 2018-01-02 07:19:00 | AAPL | Stock | 42.4625 | 42.4625 | 42.4625 | 42.4625 | 2000.0 |
| 2018-01-02 07:20:00 | AAPL | Stock | 42.4625 | 42.4625 | 42.4625 | 42.4625 | 1240.0 |
| 2018-01-02 07:22:00 | AAPL | Stock | 42.455 | 42.455 | 42.455 | 42.455 | 400.0 |
| 2018-01-02 07:23:00 | AAPL | Stock | 42.4625 | 42.4625 | 42.4625 | 42.4625 | 600.0 |
| 2018-01-02 07:25:00 | AAPL | Stock | 42.4525 | 42.4525 | 42.4525 | 42.4525 | 2968.0 |
| 2018-01-02 07:28:00 | AAPL | Stock | 42.4625 | 42.4625 | 42.4625 | 42.4625 | 7068.0 |
| 2018-01-02 07:30:00 | AAPL | Stock | 42.4875 | 42.4875 | 42.4875 | 42.4875 | 2716.0 |
| 2018-01-02 07:31:00 | AAPL | Stock | 42.495 | 42.5025 | 42.495 | 42.5025 | 6428.0 |
| 2018-01-02 07:32:00 | AAPL | Stock | 42.5025 | 42.51 | 42.5 | 42.51 | 3200.0 |
> showing 50 of 1,125,640 rows — these rows as CSV