PREVIEW / stock_1min / 2022-10-19
file: by_date/stock_1min/2022/2022-10-19.parquet size: 20.3 MB rows: 1,279,672 symbols: 1,942
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 |
|---|---|---|---|---|---|---|---|
| 2022-10-19 04:00:00 | AAPL | Stock | 144.06 | 144.15 | 143.4 | 143.47 | 5842.0 |
| 2022-10-19 04:01:00 | AAPL | Stock | 143.41 | 143.41 | 143.22 | 143.27 | 2488.0 |
| 2022-10-19 04:02:00 | AAPL | Stock | 143.42 | 143.5 | 143.26 | 143.28 | 2645.0 |
| 2022-10-19 04:04:00 | AAPL | Stock | 143.35 | 143.36 | 143.31 | 143.35 | 1191.0 |
| 2022-10-19 04:05:00 | AAPL | Stock | 143.29 | 143.3 | 143.26 | 143.3 | 655.0 |
| 2022-10-19 04:06:00 | AAPL | Stock | 143.35 | 143.35 | 143.3 | 143.3 | 301.0 |
| 2022-10-19 04:07:00 | AAPL | Stock | 143.24 | 143.24 | 143.24 | 143.24 | 344.0 |
| 2022-10-19 04:08:00 | AAPL | Stock | 143.25 | 143.26 | 143.1 | 143.1 | 6393.0 |
| 2022-10-19 04:09:00 | AAPL | Stock | 143.05 | 143.05 | 142.99 | 143.03 | 3745.0 |
| 2022-10-19 04:10:00 | AAPL | Stock | 142.94 | 142.94 | 142.79 | 142.79 | 2509.0 |
| 2022-10-19 04:11:00 | AAPL | Stock | 142.77 | 142.87 | 142.77 | 142.87 | 1356.0 |
| 2022-10-19 04:12:00 | AAPL | Stock | 142.88 | 142.88 | 142.88 | 142.88 | 550.0 |
| 2022-10-19 04:13:00 | AAPL | Stock | 143.0 | 143.0 | 143.0 | 143.0 | 161.0 |
| 2022-10-19 04:14:00 | AAPL | Stock | 143.0 | 143.1 | 142.91 | 142.93 | 3954.0 |
| 2022-10-19 04:15:00 | AAPL | Stock | 142.91 | 142.91 | 142.81 | 142.83 | 1307.0 |
| 2022-10-19 04:16:00 | AAPL | Stock | 142.82 | 142.82 | 142.75 | 142.8 | 4274.0 |
| 2022-10-19 04:19:00 | AAPL | Stock | 142.69 | 142.69 | 142.69 | 142.69 | 1200.0 |
| 2022-10-19 04:20:00 | AAPL | Stock | 142.65 | 142.65 | 142.41 | 142.41 | 1454.0 |
| 2022-10-19 04:21:00 | AAPL | Stock | 142.47 | 142.47 | 142.4 | 142.4 | 1808.0 |
| 2022-10-19 04:22:00 | AAPL | Stock | 142.4 | 142.4 | 142.4 | 142.4 | 100.0 |
| 2022-10-19 04:23:00 | AAPL | Stock | 142.41 | 142.59 | 142.41 | 142.59 | 1321.0 |
| 2022-10-19 04:24:00 | AAPL | Stock | 142.6 | 142.6 | 142.53 | 142.53 | 645.0 |
| 2022-10-19 04:25:00 | AAPL | Stock | 142.52 | 142.52 | 142.4 | 142.41 | 1376.0 |
| 2022-10-19 04:27:00 | AAPL | Stock | 142.43 | 142.43 | 142.41 | 142.43 | 793.0 |
| 2022-10-19 04:28:00 | AAPL | Stock | 142.46 | 142.5 | 142.46 | 142.5 | 335.0 |
| 2022-10-19 04:29:00 | AAPL | Stock | 142.55 | 142.55 | 142.55 | 142.55 | 300.0 |
| 2022-10-19 04:30:00 | AAPL | Stock | 142.55 | 142.55 | 142.55 | 142.55 | 400.0 |
| 2022-10-19 04:31:00 | AAPL | Stock | 142.72 | 142.72 | 142.71 | 142.71 | 417.0 |
| 2022-10-19 04:32:00 | AAPL | Stock | 142.71 | 142.71 | 142.71 | 142.71 | 221.0 |
| 2022-10-19 04:33:00 | AAPL | Stock | 142.78 | 142.79 | 142.78 | 142.78 | 1270.0 |
| 2022-10-19 04:34:00 | AAPL | Stock | 142.76 | 142.76 | 142.76 | 142.76 | 448.0 |
| 2022-10-19 04:35:00 | AAPL | Stock | 142.92 | 142.92 | 142.78 | 142.78 | 648.0 |
| 2022-10-19 04:36:00 | AAPL | Stock | 142.78 | 142.78 | 142.7 | 142.7 | 1154.0 |
| 2022-10-19 04:37:00 | AAPL | Stock | 142.62 | 142.62 | 142.62 | 142.62 | 232.0 |
| 2022-10-19 04:38:00 | AAPL | Stock | 142.6 | 142.6 | 142.59 | 142.59 | 464.0 |
| 2022-10-19 04:39:00 | AAPL | Stock | 142.61 | 142.61 | 142.61 | 142.61 | 206.0 |
| 2022-10-19 04:44:00 | AAPL | Stock | 142.87 | 142.87 | 142.87 | 142.87 | 300.0 |
| 2022-10-19 04:45:00 | AAPL | Stock | 142.87 | 142.88 | 142.83 | 142.85 | 1996.0 |
| 2022-10-19 04:46:00 | AAPL | Stock | 142.79 | 142.79 | 142.79 | 142.79 | 429.0 |
| 2022-10-19 04:47:00 | AAPL | Stock | 142.79 | 142.79 | 142.79 | 142.79 | 851.0 |
| 2022-10-19 04:49:00 | AAPL | Stock | 142.8 | 142.8 | 142.8 | 142.8 | 147.0 |
| 2022-10-19 04:50:00 | AAPL | Stock | 142.8 | 142.8 | 142.8 | 142.8 | 100.0 |
| 2022-10-19 04:52:00 | AAPL | Stock | 142.96 | 143.0 | 142.96 | 143.0 | 706.0 |
| 2022-10-19 04:53:00 | AAPL | Stock | 143.1 | 143.1 | 143.1 | 143.1 | 271.0 |
| 2022-10-19 04:55:00 | AAPL | Stock | 143.02 | 143.02 | 143.02 | 143.02 | 355.0 |
| 2022-10-19 05:00:00 | AAPL | Stock | 143.0 | 143.0 | 143.0 | 143.0 | 1123.0 |
| 2022-10-19 05:04:00 | AAPL | Stock | 143.2 | 143.2 | 143.2 | 143.2 | 330.0 |
| 2022-10-19 05:05:00 | AAPL | Stock | 143.19 | 143.19 | 143.19 | 143.19 | 364.0 |
| 2022-10-19 05:09:00 | AAPL | Stock | 143.33 | 143.33 | 143.33 | 143.33 | 110.0 |
| 2022-10-19 05:11:00 | AAPL | Stock | 143.28 | 143.31 | 143.25 | 143.25 | 1631.0 |
> showing 50 of 1,279,672 rows — these rows as CSV