PREVIEW / stock_1min / 2020-12-31
file: by_date/stock_1min/2020/2020-12-31.parquet size: 22.6 MB rows: 1,313,061 symbols: 2,283
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-31 04:00:00 | AAPL | Stock | 133.81 | 133.81 | 133.56 | 133.56 | 390.0 |
| 2020-12-31 04:03:00 | AAPL | Stock | 133.7 | 133.7 | 133.7 | 133.7 | 227.0 |
| 2020-12-31 04:04:00 | AAPL | Stock | 133.6 | 133.6 | 133.6 | 133.6 | 422.0 |
| 2020-12-31 04:07:00 | AAPL | Stock | 133.57 | 133.57 | 133.57 | 133.57 | 100.0 |
| 2020-12-31 04:10:00 | AAPL | Stock | 133.54 | 133.54 | 133.54 | 133.54 | 323.0 |
| 2020-12-31 04:15:00 | AAPL | Stock | 133.4 | 133.4 | 133.4 | 133.4 | 639.0 |
| 2020-12-31 04:16:00 | AAPL | Stock | 133.44 | 133.45 | 133.44 | 133.45 | 467.0 |
| 2020-12-31 04:18:00 | AAPL | Stock | 133.42 | 133.42 | 133.39 | 133.39 | 623.0 |
| 2020-12-31 04:22:00 | AAPL | Stock | 133.42 | 133.42 | 133.42 | 133.42 | 100.0 |
| 2020-12-31 04:26:00 | AAPL | Stock | 133.43 | 133.43 | 133.38 | 133.38 | 381.0 |
| 2020-12-31 04:30:00 | AAPL | Stock | 133.38 | 133.38 | 133.38 | 133.38 | 150.0 |
| 2020-12-31 04:32:00 | AAPL | Stock | 133.4 | 133.4 | 133.4 | 133.4 | 121.0 |
| 2020-12-31 04:34:00 | AAPL | Stock | 133.4 | 133.4 | 133.4 | 133.4 | 115.0 |
| 2020-12-31 04:36:00 | AAPL | Stock | 133.43 | 133.43 | 133.43 | 133.43 | 100.0 |
| 2020-12-31 04:39:00 | AAPL | Stock | 133.43 | 133.43 | 133.43 | 133.43 | 146.0 |
| 2020-12-31 05:00:00 | AAPL | Stock | 133.61 | 133.61 | 133.61 | 133.61 | 100.0 |
| 2020-12-31 05:07:00 | AAPL | Stock | 133.61 | 133.61 | 133.61 | 133.61 | 146.0 |
| 2020-12-31 05:18:00 | AAPL | Stock | 133.68 | 133.68 | 133.68 | 133.68 | 450.0 |
| 2020-12-31 05:19:00 | AAPL | Stock | 133.72 | 133.72 | 133.72 | 133.72 | 405.0 |
| 2020-12-31 05:22:00 | AAPL | Stock | 133.7 | 133.7 | 133.68 | 133.68 | 477.0 |
| 2020-12-31 05:26:00 | AAPL | Stock | 133.53 | 133.53 | 133.53 | 133.53 | 153.0 |
| 2020-12-31 05:32:00 | AAPL | Stock | 133.53 | 133.53 | 133.53 | 133.53 | 110.0 |
| 2020-12-31 05:37:00 | AAPL | Stock | 133.57 | 133.57 | 133.53 | 133.53 | 220.0 |
| 2020-12-31 05:40:00 | AAPL | Stock | 133.56 | 133.56 | 133.56 | 133.56 | 282.0 |
| 2020-12-31 05:50:00 | AAPL | Stock | 133.57 | 133.57 | 133.57 | 133.57 | 118.0 |
| 2020-12-31 05:53:00 | AAPL | Stock | 133.69 | 133.69 | 133.69 | 133.69 | 100.0 |
| 2020-12-31 05:54:00 | AAPL | Stock | 133.72 | 133.72 | 133.72 | 133.72 | 401.0 |
| 2020-12-31 05:57:00 | AAPL | Stock | 133.72 | 133.72 | 133.72 | 133.72 | 100.0 |
| 2020-12-31 06:12:00 | AAPL | Stock | 133.71 | 133.71 | 133.71 | 133.71 | 105.0 |
| 2020-12-31 06:26:00 | AAPL | Stock | 133.72 | 133.75 | 133.72 | 133.75 | 1746.0 |
| 2020-12-31 06:28:00 | AAPL | Stock | 133.8 | 133.8 | 133.8 | 133.8 | 212.0 |
| 2020-12-31 06:30:00 | AAPL | Stock | 133.81 | 133.81 | 133.81 | 133.81 | 150.0 |
| 2020-12-31 06:31:00 | AAPL | Stock | 133.9 | 133.9 | 133.9 | 133.9 | 195.0 |
| 2020-12-31 06:37:00 | AAPL | Stock | 133.89 | 133.89 | 133.88 | 133.88 | 244.0 |
| 2020-12-31 06:45:00 | AAPL | Stock | 133.8 | 133.8 | 133.8 | 133.8 | 511.0 |
| 2020-12-31 06:46:00 | AAPL | Stock | 133.82 | 133.82 | 133.82 | 133.82 | 109.0 |
| 2020-12-31 06:52:00 | AAPL | Stock | 133.89 | 133.9 | 133.89 | 133.9 | 205.0 |
| 2020-12-31 06:53:00 | AAPL | Stock | 133.91 | 133.91 | 133.91 | 133.91 | 150.0 |
| 2020-12-31 06:54:00 | AAPL | Stock | 133.92 | 133.92 | 133.92 | 133.92 | 442.0 |
| 2020-12-31 06:55:00 | AAPL | Stock | 133.91 | 133.91 | 133.91 | 133.91 | 645.0 |
| 2020-12-31 06:56:00 | AAPL | Stock | 133.99 | 133.99 | 133.97 | 133.97 | 302.0 |
| 2020-12-31 07:00:00 | AAPL | Stock | 133.82 | 134.06 | 133.82 | 134.06 | 20541.0 |
| 2020-12-31 07:01:00 | AAPL | Stock | 134.08 | 134.3 | 134.08 | 134.25 | 14890.0 |
| 2020-12-31 07:02:00 | AAPL | Stock | 134.25 | 134.32 | 134.23 | 134.32 | 5320.0 |
| 2020-12-31 07:03:00 | AAPL | Stock | 134.29 | 134.29 | 134.24 | 134.25 | 1500.0 |
| 2020-12-31 07:04:00 | AAPL | Stock | 134.19 | 134.21 | 134.12 | 134.12 | 2187.0 |
| 2020-12-31 07:05:00 | AAPL | Stock | 134.07 | 134.16 | 134.07 | 134.16 | 4859.0 |
| 2020-12-31 07:06:00 | AAPL | Stock | 134.19 | 134.19 | 134.19 | 134.19 | 1359.0 |
| 2020-12-31 07:07:00 | AAPL | Stock | 134.18 | 134.23 | 134.18 | 134.23 | 2541.0 |
| 2020-12-31 07:08:00 | AAPL | Stock | 134.25 | 134.28 | 134.25 | 134.28 | 6531.0 |
> showing 50 of 1,313,061 rows — these rows as CSV