PREVIEW / stock_1min / 2022-05-27
file: by_date/stock_1min/2022/2022-05-27.parquet size: 22.1 MB rows: 1,377,410 symbols: 2,086
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-05-27 04:00:00 | AAPL | Stock | 143.99 | 143.99 | 143.13 | 143.26 | 2401.0 |
| 2022-05-27 04:01:00 | AAPL | Stock | 143.25 | 143.25 | 143.2 | 143.23 | 922.0 |
| 2022-05-27 04:02:00 | AAPL | Stock | 143.3 | 143.3 | 143.0 | 143.2 | 2180.0 |
| 2022-05-27 04:03:00 | AAPL | Stock | 143.07 | 143.07 | 143.07 | 143.07 | 206.0 |
| 2022-05-27 04:04:00 | AAPL | Stock | 143.07 | 143.14 | 143.02 | 143.12 | 1157.0 |
| 2022-05-27 04:05:00 | AAPL | Stock | 143.17 | 143.17 | 143.17 | 143.17 | 100.0 |
| 2022-05-27 04:06:00 | AAPL | Stock | 143.17 | 143.18 | 143.17 | 143.18 | 686.0 |
| 2022-05-27 04:07:00 | AAPL | Stock | 143.28 | 143.3 | 143.28 | 143.3 | 250.0 |
| 2022-05-27 04:09:00 | AAPL | Stock | 143.32 | 143.32 | 143.26 | 143.26 | 420.0 |
| 2022-05-27 04:10:00 | AAPL | Stock | 143.4 | 143.41 | 143.4 | 143.41 | 500.0 |
| 2022-05-27 04:11:00 | AAPL | Stock | 143.38 | 143.38 | 143.38 | 143.38 | 174.0 |
| 2022-05-27 04:12:00 | AAPL | Stock | 143.5 | 143.5 | 143.5 | 143.5 | 100.0 |
| 2022-05-27 04:14:00 | AAPL | Stock | 143.5 | 143.5 | 143.5 | 143.5 | 470.0 |
| 2022-05-27 04:15:00 | AAPL | Stock | 143.64 | 143.64 | 143.64 | 143.64 | 343.0 |
| 2022-05-27 04:23:00 | AAPL | Stock | 143.7 | 143.7 | 143.7 | 143.7 | 200.0 |
| 2022-05-27 04:24:00 | AAPL | Stock | 143.67 | 143.8 | 143.63 | 143.8 | 392.0 |
| 2022-05-27 04:25:00 | AAPL | Stock | 143.83 | 143.83 | 143.83 | 143.83 | 100.0 |
| 2022-05-27 04:26:00 | AAPL | Stock | 143.81 | 143.81 | 143.81 | 143.81 | 100.0 |
| 2022-05-27 04:27:00 | AAPL | Stock | 143.85 | 143.91 | 143.82 | 143.91 | 788.0 |
| 2022-05-27 04:28:00 | AAPL | Stock | 143.83 | 143.83 | 143.83 | 143.83 | 399.0 |
| 2022-05-27 04:29:00 | AAPL | Stock | 143.81 | 143.81 | 143.81 | 143.81 | 271.0 |
| 2022-05-27 04:30:00 | AAPL | Stock | 143.9 | 143.93 | 143.9 | 143.93 | 573.0 |
| 2022-05-27 04:31:00 | AAPL | Stock | 143.94 | 143.99 | 143.93 | 143.98 | 1096.0 |
| 2022-05-27 04:32:00 | AAPL | Stock | 143.97 | 144.16 | 143.97 | 144.16 | 3608.0 |
| 2022-05-27 04:33:00 | AAPL | Stock | 144.17 | 144.24 | 144.16 | 144.19 | 1125.0 |
| 2022-05-27 04:34:00 | AAPL | Stock | 144.19 | 144.19 | 144.02 | 144.02 | 776.0 |
| 2022-05-27 04:36:00 | AAPL | Stock | 144.11 | 144.11 | 144.1 | 144.1 | 1838.0 |
| 2022-05-27 04:37:00 | AAPL | Stock | 144.02 | 144.02 | 144.02 | 144.02 | 185.0 |
| 2022-05-27 04:38:00 | AAPL | Stock | 144.08 | 144.1 | 144.08 | 144.1 | 502.0 |
| 2022-05-27 04:40:00 | AAPL | Stock | 144.07 | 144.07 | 144.07 | 144.07 | 183.0 |
| 2022-05-27 04:41:00 | AAPL | Stock | 144.08 | 144.08 | 144.08 | 144.08 | 480.0 |
| 2022-05-27 04:42:00 | AAPL | Stock | 144.11 | 144.16 | 144.11 | 144.15 | 1198.0 |
| 2022-05-27 04:44:00 | AAPL | Stock | 144.0 | 144.0 | 143.96 | 143.96 | 212.0 |
| 2022-05-27 04:46:00 | AAPL | Stock | 143.91 | 143.91 | 143.91 | 143.91 | 100.0 |
| 2022-05-27 04:47:00 | AAPL | Stock | 143.98 | 143.98 | 143.93 | 143.93 | 668.0 |
| 2022-05-27 04:49:00 | AAPL | Stock | 143.97 | 143.97 | 143.93 | 143.93 | 859.0 |
| 2022-05-27 04:52:00 | AAPL | Stock | 143.91 | 143.91 | 143.87 | 143.87 | 423.0 |
| 2022-05-27 04:58:00 | AAPL | Stock | 144.03 | 144.03 | 144.03 | 144.03 | 167.0 |
| 2022-05-27 04:59:00 | AAPL | Stock | 144.06 | 144.06 | 144.06 | 144.06 | 412.0 |
| 2022-05-27 05:01:00 | AAPL | Stock | 144.0 | 144.0 | 144.0 | 144.0 | 100.0 |
| 2022-05-27 05:03:00 | AAPL | Stock | 143.99 | 143.99 | 143.9 | 143.92 | 2214.0 |
| 2022-05-27 05:10:00 | AAPL | Stock | 143.91 | 143.91 | 143.91 | 143.91 | 500.0 |
| 2022-05-27 05:14:00 | AAPL | Stock | 143.85 | 143.85 | 143.85 | 143.85 | 231.0 |
| 2022-05-27 05:21:00 | AAPL | Stock | 143.98 | 143.98 | 143.97 | 143.97 | 364.0 |
| 2022-05-27 05:26:00 | AAPL | Stock | 143.94 | 143.94 | 143.94 | 143.94 | 428.0 |
| 2022-05-27 05:29:00 | AAPL | Stock | 143.97 | 143.97 | 143.97 | 143.97 | 200.0 |
| 2022-05-27 05:31:00 | AAPL | Stock | 144.05 | 144.05 | 144.05 | 144.05 | 127.0 |
| 2022-05-27 05:34:00 | AAPL | Stock | 144.03 | 144.03 | 144.03 | 144.03 | 200.0 |
| 2022-05-27 05:36:00 | AAPL | Stock | 144.01 | 144.01 | 144.01 | 144.01 | 161.0 |
| 2022-05-27 05:38:00 | AAPL | Stock | 144.04 | 144.05 | 144.04 | 144.05 | 500.0 |
> showing 50 of 1,377,410 rows — these rows as CSV