PREVIEW / stock_1min / 2023-12-18
file: by_date/stock_1min/2023/2023-12-18.parquet size: 23.0 MB rows: 1,332,284 symbols: 1,249
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-18 04:00:00 | AAPL | Stock | 196.32 | 196.32 | 196.32 | 196.32 | 171.0 |
| 2023-12-18 04:02:00 | AAPL | Stock | 196.4 | 196.4 | 196.4 | 196.4 | 900.0 |
| 2023-12-18 04:03:00 | AAPL | Stock | 196.49 | 196.49 | 196.49 | 196.49 | 200.0 |
| 2023-12-18 04:06:00 | AAPL | Stock | 196.48 | 196.49 | 196.48 | 196.49 | 804.0 |
| 2023-12-18 04:10:00 | AAPL | Stock | 196.46 | 196.46 | 196.46 | 196.46 | 100.0 |
| 2023-12-18 04:15:00 | AAPL | Stock | 196.42 | 196.42 | 196.41 | 196.41 | 615.0 |
| 2023-12-18 04:16:00 | AAPL | Stock | 196.21 | 196.21 | 196.12 | 196.12 | 790.0 |
| 2023-12-18 04:17:00 | AAPL | Stock | 196.0 | 196.0 | 195.9 | 195.9 | 1222.0 |
| 2023-12-18 04:18:00 | AAPL | Stock | 196.05 | 196.06 | 195.83 | 195.83 | 635.0 |
| 2023-12-18 04:19:00 | AAPL | Stock | 195.98 | 195.98 | 195.98 | 195.98 | 145.0 |
| 2023-12-18 04:20:00 | AAPL | Stock | 196.02 | 196.02 | 196.02 | 196.02 | 100.0 |
| 2023-12-18 04:21:00 | AAPL | Stock | 196.02 | 196.02 | 196.02 | 196.02 | 100.0 |
| 2023-12-18 04:22:00 | AAPL | Stock | 195.94 | 195.94 | 195.94 | 195.94 | 195.0 |
| 2023-12-18 04:23:00 | AAPL | Stock | 195.94 | 195.94 | 195.94 | 195.94 | 783.0 |
| 2023-12-18 04:26:00 | AAPL | Stock | 195.97 | 195.97 | 195.97 | 195.97 | 100.0 |
| 2023-12-18 04:27:00 | AAPL | Stock | 195.97 | 195.97 | 195.97 | 195.97 | 100.0 |
| 2023-12-18 04:28:00 | AAPL | Stock | 196.03 | 196.03 | 196.03 | 196.03 | 268.0 |
| 2023-12-18 04:31:00 | AAPL | Stock | 196.0 | 196.01 | 195.97 | 195.97 | 1827.0 |
| 2023-12-18 04:37:00 | AAPL | Stock | 196.02 | 196.02 | 196.02 | 196.02 | 125.0 |
| 2023-12-18 04:38:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 100.0 |
| 2023-12-18 04:39:00 | AAPL | Stock | 196.05 | 196.05 | 196.05 | 196.05 | 150.0 |
| 2023-12-18 04:44:00 | AAPL | Stock | 195.91 | 195.96 | 195.5 | 195.5 | 8028.0 |
| 2023-12-18 04:45:00 | AAPL | Stock | 195.61 | 195.61 | 195.61 | 195.61 | 200.0 |
| 2023-12-18 04:47:00 | AAPL | Stock | 195.61 | 195.61 | 195.6 | 195.6 | 696.0 |
| 2023-12-18 04:49:00 | AAPL | Stock | 195.59 | 195.59 | 195.59 | 195.59 | 350.0 |
| 2023-12-18 04:50:00 | AAPL | Stock | 195.6 | 195.6 | 195.6 | 195.6 | 600.0 |
| 2023-12-18 04:58:00 | AAPL | Stock | 195.77 | 195.77 | 195.77 | 195.77 | 106.0 |
| 2023-12-18 05:02:00 | AAPL | Stock | 195.8 | 195.8 | 195.8 | 195.8 | 212.0 |
| 2023-12-18 05:04:00 | AAPL | Stock | 195.89 | 195.89 | 195.89 | 195.89 | 200.0 |
| 2023-12-18 05:07:00 | AAPL | Stock | 195.9 | 195.9 | 195.9 | 195.9 | 547.0 |
| 2023-12-18 05:14:00 | AAPL | Stock | 195.8 | 195.85 | 195.8 | 195.85 | 322.0 |
| 2023-12-18 05:18:00 | AAPL | Stock | 195.91 | 195.91 | 195.91 | 195.91 | 300.0 |
| 2023-12-18 05:20:00 | AAPL | Stock | 195.92 | 195.95 | 195.92 | 195.95 | 750.0 |
| 2023-12-18 05:21:00 | AAPL | Stock | 195.99 | 196.0 | 195.99 | 196.0 | 282.0 |
| 2023-12-18 05:24:00 | AAPL | Stock | 196.08 | 196.1 | 196.08 | 196.1 | 200.0 |
| 2023-12-18 05:27:00 | AAPL | Stock | 196.03 | 196.03 | 196.03 | 196.03 | 439.0 |
| 2023-12-18 05:31:00 | AAPL | Stock | 196.1 | 196.1 | 196.1 | 196.1 | 229.0 |
| 2023-12-18 05:32:00 | AAPL | Stock | 196.2 | 196.2 | 196.15 | 196.15 | 538.0 |
| 2023-12-18 05:33:00 | AAPL | Stock | 196.18 | 196.2 | 196.18 | 196.18 | 656.0 |
| 2023-12-18 05:36:00 | AAPL | Stock | 196.12 | 196.13 | 196.12 | 196.13 | 451.0 |
| 2023-12-18 05:39:00 | AAPL | Stock | 196.06 | 196.06 | 196.06 | 196.06 | 100.0 |
| 2023-12-18 05:44:00 | AAPL | Stock | 196.1 | 196.1 | 196.06 | 196.06 | 200.0 |
| 2023-12-18 05:46:00 | AAPL | Stock | 196.1 | 196.1 | 196.1 | 196.1 | 116.0 |
| 2023-12-18 05:53:00 | AAPL | Stock | 196.0 | 196.0 | 195.99 | 195.99 | 299.0 |
| 2023-12-18 05:54:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 251.0 |
| 2023-12-18 05:55:00 | AAPL | Stock | 196.0 | 196.05 | 196.0 | 196.05 | 442.0 |
| 2023-12-18 06:01:00 | AAPL | Stock | 196.07 | 196.07 | 196.05 | 196.07 | 1597.0 |
| 2023-12-18 06:04:00 | AAPL | Stock | 196.04 | 196.04 | 196.04 | 196.04 | 150.0 |
| 2023-12-18 06:07:00 | AAPL | Stock | 196.02 | 196.02 | 196.0 | 196.0 | 979.0 |
| 2023-12-18 06:15:00 | AAPL | Stock | 195.95 | 195.95 | 195.95 | 195.95 | 149.0 |
> showing 50 of 1,332,284 rows — these rows as CSV