PREVIEW / stock_1min / 2020-11-05
file: by_date/stock_1min/2020/2020-11-05.parquet size: 21.1 MB rows: 1,277,970 symbols: 2,140
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-11-05 04:00:00 | AAPL | Stock | 117.7 | 118.01 | 117.51 | 117.74 | 12197.0 |
| 2020-11-05 04:01:00 | AAPL | Stock | 117.78 | 117.8 | 117.7 | 117.71 | 1733.0 |
| 2020-11-05 04:02:00 | AAPL | Stock | 117.71 | 117.74 | 117.5 | 117.6 | 12785.0 |
| 2020-11-05 04:03:00 | AAPL | Stock | 117.62 | 117.75 | 117.6 | 117.7 | 2002.0 |
| 2020-11-05 04:04:00 | AAPL | Stock | 117.71 | 117.71 | 117.61 | 117.61 | 563.0 |
| 2020-11-05 04:05:00 | AAPL | Stock | 117.61 | 117.7 | 117.61 | 117.64 | 2380.0 |
| 2020-11-05 04:06:00 | AAPL | Stock | 117.64 | 117.74 | 117.63 | 117.74 | 3214.0 |
| 2020-11-05 04:07:00 | AAPL | Stock | 117.74 | 117.97 | 117.69 | 117.84 | 1820.0 |
| 2020-11-05 04:08:00 | AAPL | Stock | 117.84 | 117.9 | 117.84 | 117.9 | 499.0 |
| 2020-11-05 04:09:00 | AAPL | Stock | 117.9 | 117.9 | 117.86 | 117.9 | 2138.0 |
| 2020-11-05 04:10:00 | AAPL | Stock | 117.87 | 117.87 | 117.84 | 117.84 | 1866.0 |
| 2020-11-05 04:11:00 | AAPL | Stock | 117.8 | 117.86 | 117.8 | 117.85 | 492.0 |
| 2020-11-05 04:12:00 | AAPL | Stock | 117.86 | 117.86 | 117.83 | 117.85 | 720.0 |
| 2020-11-05 04:13:00 | AAPL | Stock | 117.85 | 117.87 | 117.83 | 117.83 | 1759.0 |
| 2020-11-05 04:14:00 | AAPL | Stock | 117.83 | 117.83 | 117.83 | 117.83 | 100.0 |
| 2020-11-05 04:15:00 | AAPL | Stock | 117.81 | 117.81 | 117.81 | 117.81 | 114.0 |
| 2020-11-05 04:16:00 | AAPL | Stock | 117.82 | 117.96 | 117.82 | 117.96 | 2033.0 |
| 2020-11-05 04:17:00 | AAPL | Stock | 118.0 | 118.05 | 117.97 | 118.05 | 3679.0 |
| 2020-11-05 04:18:00 | AAPL | Stock | 118.1 | 118.14 | 118.1 | 118.14 | 711.0 |
| 2020-11-05 04:19:00 | AAPL | Stock | 118.14 | 118.17 | 118.14 | 118.17 | 594.0 |
| 2020-11-05 04:20:00 | AAPL | Stock | 118.17 | 118.17 | 118.08 | 118.08 | 1233.0 |
| 2020-11-05 04:21:00 | AAPL | Stock | 118.11 | 118.11 | 118.08 | 118.09 | 683.0 |
| 2020-11-05 04:22:00 | AAPL | Stock | 118.05 | 118.05 | 118.0 | 118.0 | 1002.0 |
| 2020-11-05 04:23:00 | AAPL | Stock | 118.0 | 118.05 | 118.0 | 118.05 | 445.0 |
| 2020-11-05 04:24:00 | AAPL | Stock | 118.0 | 118.0 | 117.97 | 117.97 | 1099.0 |
| 2020-11-05 04:25:00 | AAPL | Stock | 118.01 | 118.01 | 118.01 | 118.01 | 100.0 |
| 2020-11-05 04:26:00 | AAPL | Stock | 117.96 | 117.96 | 117.92 | 117.92 | 550.0 |
| 2020-11-05 04:28:00 | AAPL | Stock | 117.87 | 117.9 | 117.87 | 117.9 | 540.0 |
| 2020-11-05 04:29:00 | AAPL | Stock | 117.85 | 118.05 | 117.85 | 118.0 | 2598.0 |
| 2020-11-05 04:30:00 | AAPL | Stock | 118.0 | 118.0 | 117.96 | 117.96 | 8628.0 |
| 2020-11-05 04:31:00 | AAPL | Stock | 117.97 | 117.99 | 117.97 | 117.99 | 957.0 |
| 2020-11-05 04:32:00 | AAPL | Stock | 117.9 | 117.9 | 117.9 | 117.9 | 334.0 |
| 2020-11-05 04:33:00 | AAPL | Stock | 117.91 | 117.91 | 117.88 | 117.9 | 1052.0 |
| 2020-11-05 04:34:00 | AAPL | Stock | 117.9 | 117.9 | 117.9 | 117.9 | 269.0 |
| 2020-11-05 04:35:00 | AAPL | Stock | 117.93 | 117.94 | 117.9 | 117.94 | 765.0 |
| 2020-11-05 04:36:00 | AAPL | Stock | 117.97 | 117.97 | 117.96 | 117.96 | 448.0 |
| 2020-11-05 04:37:00 | AAPL | Stock | 117.97 | 117.99 | 117.97 | 117.99 | 1863.0 |
| 2020-11-05 04:38:00 | AAPL | Stock | 117.99 | 117.99 | 117.99 | 117.99 | 300.0 |
| 2020-11-05 04:39:00 | AAPL | Stock | 117.99 | 118.0 | 117.99 | 117.99 | 1487.0 |
| 2020-11-05 04:40:00 | AAPL | Stock | 117.99 | 117.99 | 117.98 | 117.99 | 650.0 |
| 2020-11-05 04:41:00 | AAPL | Stock | 117.98 | 117.98 | 117.98 | 117.98 | 177.0 |
| 2020-11-05 04:42:00 | AAPL | Stock | 117.98 | 118.4 | 117.98 | 118.2 | 8801.0 |
| 2020-11-05 04:43:00 | AAPL | Stock | 118.22 | 118.25 | 118.21 | 118.25 | 700.0 |
| 2020-11-05 04:44:00 | AAPL | Stock | 118.25 | 118.25 | 118.19 | 118.19 | 925.0 |
| 2020-11-05 04:45:00 | AAPL | Stock | 118.19 | 118.2 | 118.19 | 118.2 | 582.0 |
| 2020-11-05 04:46:00 | AAPL | Stock | 118.19 | 118.19 | 118.19 | 118.19 | 200.0 |
| 2020-11-05 04:47:00 | AAPL | Stock | 118.19 | 118.19 | 118.16 | 118.16 | 258.0 |
| 2020-11-05 04:49:00 | AAPL | Stock | 118.01 | 118.02 | 118.01 | 118.02 | 580.0 |
| 2020-11-05 04:50:00 | AAPL | Stock | 118.02 | 118.09 | 118.02 | 118.09 | 599.0 |
| 2020-11-05 04:51:00 | AAPL | Stock | 118.1 | 118.18 | 118.09 | 118.18 | 1389.0 |
> showing 50 of 1,277,970 rows — these rows as CSV