PREVIEW / stock_1min / 2022-11-09
file: by_date/stock_1min/2022/2022-11-09.parquet size: 20.7 MB rows: 1,331,690 symbols: 1,891
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-11-09 04:00:00 | AAPL | Stock | 140.05 | 140.05 | 139.76 | 139.76 | 560.0 |
| 2022-11-09 04:01:00 | AAPL | Stock | 139.78 | 139.78 | 139.78 | 139.78 | 100.0 |
| 2022-11-09 04:02:00 | AAPL | Stock | 139.8 | 139.8 | 139.68 | 139.68 | 490.0 |
| 2022-11-09 04:03:00 | AAPL | Stock | 139.8 | 139.8 | 139.75 | 139.8 | 949.0 |
| 2022-11-09 04:06:00 | AAPL | Stock | 139.71 | 139.71 | 139.68 | 139.69 | 1050.0 |
| 2022-11-09 04:08:00 | AAPL | Stock | 139.75 | 139.75 | 139.75 | 139.75 | 1130.0 |
| 2022-11-09 04:09:00 | AAPL | Stock | 139.75 | 139.75 | 139.65 | 139.65 | 613.0 |
| 2022-11-09 04:10:00 | AAPL | Stock | 139.63 | 139.63 | 139.61 | 139.61 | 896.0 |
| 2022-11-09 04:11:00 | AAPL | Stock | 139.64 | 139.64 | 139.64 | 139.64 | 100.0 |
| 2022-11-09 04:13:00 | AAPL | Stock | 139.62 | 139.62 | 139.55 | 139.55 | 1100.0 |
| 2022-11-09 04:14:00 | AAPL | Stock | 139.55 | 139.55 | 139.55 | 139.55 | 208.0 |
| 2022-11-09 04:15:00 | AAPL | Stock | 139.51 | 139.51 | 139.47 | 139.47 | 322.0 |
| 2022-11-09 04:16:00 | AAPL | Stock | 139.33 | 139.33 | 139.22 | 139.25 | 2226.0 |
| 2022-11-09 04:17:00 | AAPL | Stock | 139.17 | 139.25 | 139.17 | 139.25 | 1840.0 |
| 2022-11-09 04:18:00 | AAPL | Stock | 139.22 | 139.22 | 139.22 | 139.22 | 100.0 |
| 2022-11-09 04:19:00 | AAPL | Stock | 139.22 | 139.23 | 139.22 | 139.23 | 200.0 |
| 2022-11-09 04:20:00 | AAPL | Stock | 139.2 | 139.2 | 139.2 | 139.2 | 191.0 |
| 2022-11-09 04:22:00 | AAPL | Stock | 139.2 | 139.21 | 139.2 | 139.2 | 1400.0 |
| 2022-11-09 04:23:00 | AAPL | Stock | 139.23 | 139.23 | 139.2 | 139.2 | 2064.0 |
| 2022-11-09 04:25:00 | AAPL | Stock | 139.28 | 139.28 | 139.28 | 139.28 | 100.0 |
| 2022-11-09 04:29:00 | AAPL | Stock | 139.26 | 139.26 | 139.25 | 139.25 | 1389.0 |
| 2022-11-09 04:32:00 | AAPL | Stock | 139.21 | 139.21 | 139.21 | 139.21 | 150.0 |
| 2022-11-09 04:40:00 | AAPL | Stock | 139.28 | 139.28 | 139.28 | 139.28 | 200.0 |
| 2022-11-09 04:41:00 | AAPL | Stock | 139.27 | 139.27 | 139.23 | 139.23 | 300.0 |
| 2022-11-09 04:43:00 | AAPL | Stock | 139.11 | 139.11 | 139.03 | 139.03 | 901.0 |
| 2022-11-09 04:44:00 | AAPL | Stock | 139.0 | 139.03 | 139.0 | 139.03 | 1559.0 |
| 2022-11-09 04:45:00 | AAPL | Stock | 139.04 | 139.04 | 139.0 | 139.0 | 1952.0 |
| 2022-11-09 04:49:00 | AAPL | Stock | 138.82 | 138.82 | 138.61 | 138.61 | 1823.0 |
| 2022-11-09 04:50:00 | AAPL | Stock | 138.63 | 138.63 | 138.63 | 138.63 | 150.0 |
| 2022-11-09 04:51:00 | AAPL | Stock | 138.66 | 138.66 | 138.65 | 138.66 | 10066.0 |
| 2022-11-09 04:55:00 | AAPL | Stock | 138.67 | 138.67 | 138.67 | 138.67 | 300.0 |
| 2022-11-09 04:57:00 | AAPL | Stock | 138.66 | 138.66 | 138.5 | 138.5 | 1627.0 |
| 2022-11-09 04:58:00 | AAPL | Stock | 138.4 | 138.4 | 138.4 | 138.4 | 150.0 |
| 2022-11-09 05:00:00 | AAPL | Stock | 138.63 | 138.63 | 138.42 | 138.42 | 1400.0 |
| 2022-11-09 05:02:00 | AAPL | Stock | 138.54 | 138.54 | 138.52 | 138.52 | 860.0 |
| 2022-11-09 05:03:00 | AAPL | Stock | 138.54 | 138.54 | 138.54 | 138.54 | 281.0 |
| 2022-11-09 05:07:00 | AAPL | Stock | 138.52 | 138.52 | 138.52 | 138.52 | 445.0 |
| 2022-11-09 05:08:00 | AAPL | Stock | 138.51 | 138.51 | 138.51 | 138.51 | 165.0 |
| 2022-11-09 05:14:00 | AAPL | Stock | 138.57 | 138.59 | 138.57 | 138.59 | 418.0 |
| 2022-11-09 05:15:00 | AAPL | Stock | 138.53 | 138.53 | 138.5 | 138.5 | 1950.0 |
| 2022-11-09 05:16:00 | AAPL | Stock | 138.5 | 138.5 | 138.5 | 138.5 | 370.0 |
| 2022-11-09 05:18:00 | AAPL | Stock | 138.52 | 138.52 | 138.52 | 138.52 | 200.0 |
| 2022-11-09 05:19:00 | AAPL | Stock | 138.54 | 138.54 | 138.54 | 138.54 | 200.0 |
| 2022-11-09 05:29:00 | AAPL | Stock | 138.69 | 138.69 | 138.6 | 138.6 | 1922.0 |
| 2022-11-09 05:35:00 | AAPL | Stock | 138.8 | 138.88 | 138.8 | 138.88 | 436.0 |
| 2022-11-09 05:36:00 | AAPL | Stock | 138.85 | 138.85 | 138.85 | 138.85 | 160.0 |
| 2022-11-09 05:40:00 | AAPL | Stock | 138.85 | 138.88 | 138.85 | 138.88 | 1050.0 |
| 2022-11-09 05:43:00 | AAPL | Stock | 138.97 | 138.97 | 138.95 | 138.97 | 728.0 |
| 2022-11-09 05:44:00 | AAPL | Stock | 138.97 | 138.97 | 138.97 | 138.97 | 100.0 |
| 2022-11-09 05:45:00 | AAPL | Stock | 138.92 | 138.92 | 138.91 | 138.92 | 1100.0 |
> showing 50 of 1,331,690 rows — these rows as CSV