PREVIEW / stock_1min / 2023-11-21
file: by_date/stock_1min/2023/2023-11-21.parquet size: 19.6 MB rows: 1,206,173 symbols: 1,277
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-11-21 04:05:00 | AAPL | Stock | 191.41 | 191.41 | 191.41 | 191.41 | 163.0 |
| 2023-11-21 04:15:00 | AAPL | Stock | 191.34 | 191.34 | 191.34 | 191.34 | 100.0 |
| 2023-11-21 04:17:00 | AAPL | Stock | 191.35 | 191.35 | 191.35 | 191.35 | 167.0 |
| 2023-11-21 04:19:00 | AAPL | Stock | 191.35 | 191.35 | 191.35 | 191.35 | 130.0 |
| 2023-11-21 04:24:00 | AAPL | Stock | 191.4 | 191.4 | 191.4 | 191.4 | 123.0 |
| 2023-11-21 04:34:00 | AAPL | Stock | 191.32 | 191.32 | 191.32 | 191.32 | 138.0 |
| 2023-11-21 04:37:00 | AAPL | Stock | 191.33 | 191.33 | 191.33 | 191.33 | 100.0 |
| 2023-11-21 04:43:00 | AAPL | Stock | 191.3 | 191.3 | 191.3 | 191.3 | 200.0 |
| 2023-11-21 04:44:00 | AAPL | Stock | 191.22 | 191.22 | 191.1 | 191.1 | 3266.0 |
| 2023-11-21 04:47:00 | AAPL | Stock | 191.13 | 191.13 | 191.13 | 191.13 | 113.0 |
| 2023-11-21 04:49:00 | AAPL | Stock | 191.12 | 191.12 | 191.12 | 191.12 | 150.0 |
| 2023-11-21 05:11:00 | AAPL | Stock | 191.2 | 191.2 | 191.2 | 191.2 | 204.0 |
| 2023-11-21 05:30:00 | AAPL | Stock | 191.18 | 191.18 | 191.18 | 191.18 | 150.0 |
| 2023-11-21 06:00:00 | AAPL | Stock | 191.2 | 191.2 | 191.2 | 191.2 | 700.0 |
| 2023-11-21 06:02:00 | AAPL | Stock | 191.18 | 191.18 | 191.17 | 191.17 | 418.0 |
| 2023-11-21 06:05:00 | AAPL | Stock | 191.2 | 191.2 | 191.2 | 191.2 | 493.0 |
| 2023-11-21 06:07:00 | AAPL | Stock | 191.15 | 191.15 | 191.15 | 191.15 | 100.0 |
| 2023-11-21 06:11:00 | AAPL | Stock | 191.12 | 191.12 | 191.12 | 191.12 | 783.0 |
| 2023-11-21 06:13:00 | AAPL | Stock | 191.11 | 191.11 | 191.02 | 191.02 | 306.0 |
| 2023-11-21 06:14:00 | AAPL | Stock | 191.12 | 191.12 | 191.11 | 191.11 | 504.0 |
| 2023-11-21 06:17:00 | AAPL | Stock | 191.01 | 191.01 | 191.01 | 191.01 | 1300.0 |
| 2023-11-21 06:18:00 | AAPL | Stock | 190.92 | 190.92 | 190.92 | 190.92 | 200.0 |
| 2023-11-21 06:20:00 | AAPL | Stock | 191.0 | 191.0 | 191.0 | 191.0 | 300.0 |
| 2023-11-21 06:21:00 | AAPL | Stock | 191.0 | 191.0 | 191.0 | 191.0 | 220.0 |
| 2023-11-21 06:35:00 | AAPL | Stock | 191.05 | 191.05 | 191.05 | 191.05 | 778.0 |
| 2023-11-21 06:38:00 | AAPL | Stock | 191.05 | 191.05 | 191.0 | 191.0 | 1300.0 |
| 2023-11-21 06:39:00 | AAPL | Stock | 191.06 | 191.06 | 191.02 | 191.02 | 424.0 |
| 2023-11-21 06:42:00 | AAPL | Stock | 191.1 | 191.1 | 191.1 | 191.1 | 733.0 |
| 2023-11-21 06:43:00 | AAPL | Stock | 191.13 | 191.13 | 191.13 | 191.13 | 115.0 |
| 2023-11-21 06:47:00 | AAPL | Stock | 191.18 | 191.18 | 191.13 | 191.13 | 335.0 |
| 2023-11-21 06:48:00 | AAPL | Stock | 191.13 | 191.16 | 191.13 | 191.16 | 347.0 |
| 2023-11-21 06:52:00 | AAPL | Stock | 191.08 | 191.08 | 191.08 | 191.08 | 106.0 |
| 2023-11-21 06:54:00 | AAPL | Stock | 191.25 | 191.25 | 191.24 | 191.25 | 412.0 |
| 2023-11-21 06:55:00 | AAPL | Stock | 191.25 | 191.25 | 191.16 | 191.16 | 549.0 |
| 2023-11-21 06:58:00 | AAPL | Stock | 191.13 | 191.13 | 191.13 | 191.13 | 100.0 |
| 2023-11-21 06:59:00 | AAPL | Stock | 191.13 | 191.13 | 191.13 | 191.13 | 930.0 |
| 2023-11-21 07:00:00 | AAPL | Stock | 191.15 | 191.16 | 191.05 | 191.15 | 1220.0 |
| 2023-11-21 07:01:00 | AAPL | Stock | 191.2 | 191.2 | 191.2 | 191.2 | 149.0 |
| 2023-11-21 07:03:00 | AAPL | Stock | 191.2 | 191.23 | 191.2 | 191.22 | 518.0 |
| 2023-11-21 07:05:00 | AAPL | Stock | 191.23 | 191.23 | 191.23 | 191.23 | 417.0 |
| 2023-11-21 07:06:00 | AAPL | Stock | 191.24 | 191.27 | 191.24 | 191.27 | 574.0 |
| 2023-11-21 07:08:00 | AAPL | Stock | 191.29 | 191.29 | 191.21 | 191.21 | 1264.0 |
| 2023-11-21 07:12:00 | AAPL | Stock | 191.21 | 191.21 | 191.21 | 191.21 | 197.0 |
| 2023-11-21 07:15:00 | AAPL | Stock | 191.21 | 191.21 | 191.21 | 191.21 | 228.0 |
| 2023-11-21 07:18:00 | AAPL | Stock | 191.23 | 191.27 | 191.23 | 191.27 | 3630.0 |
| 2023-11-21 07:21:00 | AAPL | Stock | 191.26 | 191.26 | 191.26 | 191.26 | 1100.0 |
| 2023-11-21 07:25:00 | AAPL | Stock | 191.33 | 191.33 | 191.33 | 191.33 | 125.0 |
| 2023-11-21 07:26:00 | AAPL | Stock | 191.36 | 191.36 | 191.36 | 191.36 | 125.0 |
| 2023-11-21 07:29:00 | AAPL | Stock | 191.27 | 191.27 | 191.27 | 191.27 | 710.0 |
| 2023-11-21 07:30:00 | AAPL | Stock | 191.31 | 191.31 | 191.31 | 191.31 | 620.0 |
> showing 50 of 1,206,173 rows — these rows as CSV