PREVIEW / stock_1min / 2022-10-27
file: by_date/stock_1min/2022/2022-10-27.parquet size: 20.6 MB rows: 1,302,573 symbols: 1,911
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-27 04:00:00 | AAPL | Stock | 148.94 | 149.05 | 148.71 | 149.0 | 2449.0 |
| 2022-10-27 04:02:00 | AAPL | Stock | 148.9 | 148.9 | 148.9 | 148.9 | 347.0 |
| 2022-10-27 04:03:00 | AAPL | Stock | 149.0 | 149.0 | 149.0 | 149.0 | 416.0 |
| 2022-10-27 04:05:00 | AAPL | Stock | 148.9 | 148.94 | 148.9 | 148.94 | 490.0 |
| 2022-10-27 04:07:00 | AAPL | Stock | 148.87 | 148.87 | 148.86 | 148.86 | 2955.0 |
| 2022-10-27 04:08:00 | AAPL | Stock | 148.79 | 148.79 | 148.65 | 148.7 | 737.0 |
| 2022-10-27 04:09:00 | AAPL | Stock | 148.78 | 148.78 | 148.78 | 148.78 | 330.0 |
| 2022-10-27 04:10:00 | AAPL | Stock | 148.85 | 148.85 | 148.85 | 148.85 | 249.0 |
| 2022-10-27 04:11:00 | AAPL | Stock | 148.79 | 148.83 | 148.79 | 148.8 | 1011.0 |
| 2022-10-27 04:13:00 | AAPL | Stock | 148.89 | 148.93 | 148.89 | 148.93 | 1441.0 |
| 2022-10-27 04:14:00 | AAPL | Stock | 148.89 | 148.99 | 148.89 | 148.99 | 8592.0 |
| 2022-10-27 04:15:00 | AAPL | Stock | 148.99 | 148.99 | 148.84 | 148.99 | 1960.0 |
| 2022-10-27 04:16:00 | AAPL | Stock | 148.97 | 148.98 | 148.92 | 148.98 | 3103.0 |
| 2022-10-27 04:17:00 | AAPL | Stock | 148.98 | 149.01 | 148.87 | 149.01 | 2627.0 |
| 2022-10-27 04:19:00 | AAPL | Stock | 149.1 | 149.1 | 149.1 | 149.1 | 158.0 |
| 2022-10-27 04:20:00 | AAPL | Stock | 149.01 | 149.02 | 149.01 | 149.02 | 353.0 |
| 2022-10-27 04:21:00 | AAPL | Stock | 149.01 | 149.01 | 149.0 | 149.0 | 210.0 |
| 2022-10-27 04:23:00 | AAPL | Stock | 148.93 | 148.93 | 148.85 | 148.85 | 636.0 |
| 2022-10-27 04:24:00 | AAPL | Stock | 148.86 | 148.86 | 148.86 | 148.86 | 300.0 |
| 2022-10-27 04:26:00 | AAPL | Stock | 148.88 | 148.88 | 148.88 | 148.88 | 100.0 |
| 2022-10-27 04:27:00 | AAPL | Stock | 148.9 | 148.96 | 148.9 | 148.96 | 495.0 |
| 2022-10-27 04:28:00 | AAPL | Stock | 149.06 | 149.06 | 149.06 | 149.06 | 354.0 |
| 2022-10-27 04:29:00 | AAPL | Stock | 149.0 | 149.0 | 149.0 | 149.0 | 150.0 |
| 2022-10-27 04:30:00 | AAPL | Stock | 148.94 | 148.94 | 148.94 | 148.94 | 216.0 |
| 2022-10-27 04:35:00 | AAPL | Stock | 149.05 | 149.06 | 149.05 | 149.05 | 1224.0 |
| 2022-10-27 04:40:00 | AAPL | Stock | 148.95 | 148.95 | 148.81 | 148.81 | 894.0 |
| 2022-10-27 04:43:00 | AAPL | Stock | 148.74 | 148.74 | 148.74 | 148.74 | 720.0 |
| 2022-10-27 04:44:00 | AAPL | Stock | 148.8 | 148.82 | 148.8 | 148.82 | 300.0 |
| 2022-10-27 04:48:00 | AAPL | Stock | 148.82 | 148.82 | 148.82 | 148.82 | 350.0 |
| 2022-10-27 04:50:00 | AAPL | Stock | 148.87 | 148.9 | 148.87 | 148.9 | 300.0 |
| 2022-10-27 04:51:00 | AAPL | Stock | 148.92 | 148.92 | 148.92 | 148.92 | 200.0 |
| 2022-10-27 04:53:00 | AAPL | Stock | 148.87 | 148.87 | 148.76 | 148.76 | 290.0 |
| 2022-10-27 04:56:00 | AAPL | Stock | 148.78 | 148.78 | 148.78 | 148.78 | 317.0 |
| 2022-10-27 04:59:00 | AAPL | Stock | 148.75 | 148.8 | 148.75 | 148.8 | 624.0 |
| 2022-10-27 05:00:00 | AAPL | Stock | 148.75 | 148.76 | 148.55 | 148.55 | 1269.0 |
| 2022-10-27 05:01:00 | AAPL | Stock | 148.55 | 148.55 | 148.51 | 148.51 | 1456.0 |
| 2022-10-27 05:05:00 | AAPL | Stock | 148.54 | 148.6 | 148.5 | 148.52 | 1890.0 |
| 2022-10-27 05:06:00 | AAPL | Stock | 148.39 | 148.39 | 148.39 | 148.39 | 200.0 |
| 2022-10-27 05:07:00 | AAPL | Stock | 148.4 | 148.45 | 148.4 | 148.45 | 618.0 |
| 2022-10-27 05:08:00 | AAPL | Stock | 148.45 | 148.45 | 148.41 | 148.41 | 285.0 |
| 2022-10-27 05:09:00 | AAPL | Stock | 148.44 | 148.5 | 148.44 | 148.5 | 300.0 |
| 2022-10-27 05:10:00 | AAPL | Stock | 148.5 | 148.5 | 148.44 | 148.44 | 1695.0 |
| 2022-10-27 05:11:00 | AAPL | Stock | 148.5 | 148.5 | 148.5 | 148.5 | 150.0 |
| 2022-10-27 05:12:00 | AAPL | Stock | 148.5 | 148.5 | 148.5 | 148.5 | 220.0 |
| 2022-10-27 05:13:00 | AAPL | Stock | 148.58 | 148.65 | 148.5 | 148.5 | 1709.0 |
| 2022-10-27 05:14:00 | AAPL | Stock | 148.5 | 148.5 | 148.45 | 148.45 | 1254.0 |
| 2022-10-27 05:17:00 | AAPL | Stock | 148.5 | 148.5 | 148.5 | 148.5 | 200.0 |
| 2022-10-27 05:20:00 | AAPL | Stock | 148.55 | 148.57 | 148.55 | 148.57 | 590.0 |
| 2022-10-27 05:25:00 | AAPL | Stock | 148.51 | 148.51 | 148.51 | 148.51 | 100.0 |
| 2022-10-27 05:27:00 | AAPL | Stock | 148.52 | 148.52 | 148.52 | 148.52 | 200.0 |
> showing 50 of 1,302,573 rows — these rows as CSV