PREVIEW / stock_1min / 2022-04-27
file: by_date/stock_1min/2022/2022-04-27.parquet size: 22.7 MB rows: 1,436,887 symbols: 2,206
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-04-27 04:00:00 | AAPL | Stock | 157.2 | 158.11 | 157.2 | 157.73 | 2860.0 |
| 2022-04-27 04:01:00 | AAPL | Stock | 157.55 | 157.57 | 156.69 | 157.57 | 6823.0 |
| 2022-04-27 04:02:00 | AAPL | Stock | 157.63 | 157.98 | 157.6 | 157.98 | 10193.0 |
| 2022-04-27 04:03:00 | AAPL | Stock | 157.91 | 157.92 | 157.62 | 157.69 | 1100.0 |
| 2022-04-27 04:04:00 | AAPL | Stock | 157.69 | 157.95 | 157.58 | 157.89 | 5440.0 |
| 2022-04-27 04:05:00 | AAPL | Stock | 157.8 | 157.8 | 157.6 | 157.6 | 2379.0 |
| 2022-04-27 04:06:00 | AAPL | Stock | 157.6 | 157.8 | 157.6 | 157.69 | 2051.0 |
| 2022-04-27 04:07:00 | AAPL | Stock | 157.59 | 157.7 | 157.59 | 157.7 | 1170.0 |
| 2022-04-27 04:08:00 | AAPL | Stock | 157.73 | 157.73 | 157.73 | 157.73 | 399.0 |
| 2022-04-27 04:09:00 | AAPL | Stock | 157.65 | 157.65 | 157.59 | 157.65 | 4968.0 |
| 2022-04-27 04:10:00 | AAPL | Stock | 157.7 | 157.8 | 157.65 | 157.79 | 4913.0 |
| 2022-04-27 04:11:00 | AAPL | Stock | 157.8 | 157.88 | 157.79 | 157.84 | 1540.0 |
| 2022-04-27 04:12:00 | AAPL | Stock | 157.83 | 158.1 | 157.83 | 158.0 | 1635.0 |
| 2022-04-27 04:13:00 | AAPL | Stock | 158.15 | 158.15 | 158.14 | 158.14 | 244.0 |
| 2022-04-27 04:14:00 | AAPL | Stock | 158.1 | 158.4 | 158.1 | 158.4 | 1772.0 |
| 2022-04-27 04:16:00 | AAPL | Stock | 158.23 | 158.23 | 158.2 | 158.21 | 2640.0 |
| 2022-04-27 04:17:00 | AAPL | Stock | 158.2 | 158.4 | 158.2 | 158.4 | 1744.0 |
| 2022-04-27 04:18:00 | AAPL | Stock | 158.38 | 158.38 | 158.38 | 158.38 | 100.0 |
| 2022-04-27 04:19:00 | AAPL | Stock | 158.35 | 158.35 | 158.35 | 158.35 | 412.0 |
| 2022-04-27 04:20:00 | AAPL | Stock | 158.2 | 158.2 | 158.15 | 158.15 | 350.0 |
| 2022-04-27 04:21:00 | AAPL | Stock | 158.12 | 158.15 | 158.12 | 158.15 | 350.0 |
| 2022-04-27 04:22:00 | AAPL | Stock | 158.12 | 158.34 | 158.12 | 158.27 | 5227.0 |
| 2022-04-27 04:23:00 | AAPL | Stock | 158.28 | 158.3 | 158.25 | 158.29 | 1250.0 |
| 2022-04-27 04:24:00 | AAPL | Stock | 158.25 | 158.25 | 158.18 | 158.18 | 443.0 |
| 2022-04-27 04:25:00 | AAPL | Stock | 158.1 | 158.1 | 158.0 | 158.0 | 300.0 |
| 2022-04-27 04:26:00 | AAPL | Stock | 158.0 | 158.13 | 157.95 | 158.13 | 1375.0 |
| 2022-04-27 04:29:00 | AAPL | Stock | 158.07 | 158.07 | 158.07 | 158.07 | 156.0 |
| 2022-04-27 04:30:00 | AAPL | Stock | 158.14 | 158.14 | 158.14 | 158.14 | 100.0 |
| 2022-04-27 04:31:00 | AAPL | Stock | 158.14 | 158.14 | 158.13 | 158.13 | 400.0 |
| 2022-04-27 04:32:00 | AAPL | Stock | 157.99 | 158.0 | 157.99 | 158.0 | 456.0 |
| 2022-04-27 04:33:00 | AAPL | Stock | 158.0 | 158.05 | 158.0 | 158.05 | 625.0 |
| 2022-04-27 04:34:00 | AAPL | Stock | 158.04 | 158.04 | 157.93 | 157.98 | 1029.0 |
| 2022-04-27 04:35:00 | AAPL | Stock | 157.8 | 157.96 | 157.8 | 157.96 | 796.0 |
| 2022-04-27 04:36:00 | AAPL | Stock | 157.84 | 158.0 | 157.84 | 157.98 | 819.0 |
| 2022-04-27 04:37:00 | AAPL | Stock | 158.0 | 158.0 | 158.0 | 158.0 | 100.0 |
| 2022-04-27 04:38:00 | AAPL | Stock | 157.95 | 157.95 | 157.95 | 157.95 | 100.0 |
| 2022-04-27 04:39:00 | AAPL | Stock | 158.0 | 158.0 | 158.0 | 158.0 | 441.0 |
| 2022-04-27 04:40:00 | AAPL | Stock | 158.04 | 158.11 | 158.04 | 158.11 | 961.0 |
| 2022-04-27 04:42:00 | AAPL | Stock | 158.15 | 158.16 | 158.1 | 158.1 | 710.0 |
| 2022-04-27 04:44:00 | AAPL | Stock | 158.07 | 158.08 | 158.06 | 158.06 | 663.0 |
| 2022-04-27 04:46:00 | AAPL | Stock | 157.89 | 157.89 | 157.8 | 157.8 | 760.0 |
| 2022-04-27 04:47:00 | AAPL | Stock | 157.84 | 157.88 | 157.71 | 157.71 | 706.0 |
| 2022-04-27 04:48:00 | AAPL | Stock | 157.61 | 157.63 | 157.6 | 157.6 | 3353.0 |
| 2022-04-27 04:50:00 | AAPL | Stock | 157.5 | 157.51 | 157.4 | 157.4 | 900.0 |
| 2022-04-27 04:51:00 | AAPL | Stock | 157.4 | 157.57 | 157.4 | 157.57 | 334.0 |
| 2022-04-27 04:52:00 | AAPL | Stock | 157.6 | 157.6 | 157.6 | 157.6 | 391.0 |
| 2022-04-27 04:53:00 | AAPL | Stock | 157.57 | 157.57 | 157.57 | 157.57 | 140.0 |
| 2022-04-27 04:54:00 | AAPL | Stock | 157.67 | 157.67 | 157.67 | 157.67 | 740.0 |
| 2022-04-27 04:56:00 | AAPL | Stock | 157.7 | 157.8 | 157.64 | 157.8 | 4239.0 |
| 2022-04-27 05:02:00 | AAPL | Stock | 157.85 | 157.85 | 157.82 | 157.82 | 1108.0 |
> showing 50 of 1,436,887 rows — these rows as CSV