PREVIEW / stock_1min / 2025-07-31
file: by_date/stock_1min/2025/2025-07-31.parquet size: 24.4 MB rows: 1,412,153 symbols: 358
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 |
|---|---|---|---|---|---|---|---|
| 2025-07-31 04:00:00 | AAPL | Stock | 209.49 | 209.52 | 209.22 | 209.24 | 1608.0 |
| 2025-07-31 04:01:00 | AAPL | Stock | 209.21 | 209.21 | 208.97 | 208.97 | 3559.0 |
| 2025-07-31 04:02:00 | AAPL | Stock | 208.94 | 208.97 | 208.9 | 208.9 | 1040.0 |
| 2025-07-31 04:03:00 | AAPL | Stock | 208.89 | 208.89 | 208.89 | 208.89 | 100.0 |
| 2025-07-31 04:04:00 | AAPL | Stock | 208.91 | 208.91 | 208.91 | 208.91 | 300.0 |
| 2025-07-31 04:05:00 | AAPL | Stock | 208.86 | 208.86 | 208.86 | 208.86 | 333.0 |
| 2025-07-31 04:06:00 | AAPL | Stock | 208.85 | 208.85 | 208.85 | 208.85 | 124.0 |
| 2025-07-31 04:07:00 | AAPL | Stock | 208.9 | 208.99 | 208.88 | 208.91 | 1071.0 |
| 2025-07-31 04:08:00 | AAPL | Stock | 209.0 | 209.0 | 208.99 | 209.0 | 855.0 |
| 2025-07-31 04:10:00 | AAPL | Stock | 208.95 | 208.95 | 208.95 | 208.95 | 161.0 |
| 2025-07-31 04:11:00 | AAPL | Stock | 209.0 | 209.0 | 208.95 | 208.95 | 1085.0 |
| 2025-07-31 04:12:00 | AAPL | Stock | 208.89 | 208.89 | 208.85 | 208.85 | 467.0 |
| 2025-07-31 04:13:00 | AAPL | Stock | 208.99 | 209.0 | 208.99 | 209.0 | 300.0 |
| 2025-07-31 04:14:00 | AAPL | Stock | 208.98 | 209.05 | 208.98 | 209.04 | 2506.0 |
| 2025-07-31 04:15:00 | AAPL | Stock | 209.01 | 209.01 | 209.0 | 209.0 | 700.0 |
| 2025-07-31 04:16:00 | AAPL | Stock | 208.99 | 209.0 | 208.99 | 209.0 | 784.0 |
| 2025-07-31 04:17:00 | AAPL | Stock | 208.95 | 208.95 | 208.85 | 208.85 | 822.0 |
| 2025-07-31 04:18:00 | AAPL | Stock | 208.98 | 208.98 | 208.98 | 208.98 | 100.0 |
| 2025-07-31 04:19:00 | AAPL | Stock | 208.97 | 208.97 | 208.97 | 208.97 | 100.0 |
| 2025-07-31 04:20:00 | AAPL | Stock | 209.01 | 209.33 | 209.01 | 209.33 | 700.0 |
| 2025-07-31 04:21:00 | AAPL | Stock | 209.1 | 209.1 | 209.09 | 209.1 | 2050.0 |
| 2025-07-31 04:22:00 | AAPL | Stock | 209.1 | 209.17 | 209.1 | 209.17 | 677.0 |
| 2025-07-31 04:23:00 | AAPL | Stock | 209.17 | 209.2 | 209.17 | 209.2 | 1821.0 |
| 2025-07-31 04:25:00 | AAPL | Stock | 209.3 | 209.3 | 209.3 | 209.3 | 119.0 |
| 2025-07-31 04:26:00 | AAPL | Stock | 209.25 | 209.25 | 209.25 | 209.25 | 136.0 |
| 2025-07-31 04:27:00 | AAPL | Stock | 209.23 | 209.35 | 209.23 | 209.35 | 645.0 |
| 2025-07-31 04:28:00 | AAPL | Stock | 209.33 | 209.42 | 209.31 | 209.42 | 1394.0 |
| 2025-07-31 04:29:00 | AAPL | Stock | 209.42 | 209.42 | 209.41 | 209.42 | 506.0 |
| 2025-07-31 04:31:00 | AAPL | Stock | 209.45 | 209.48 | 209.34 | 209.34 | 589.0 |
| 2025-07-31 04:32:00 | AAPL | Stock | 209.37 | 209.37 | 209.3 | 209.3 | 610.0 |
| 2025-07-31 04:34:00 | AAPL | Stock | 209.37 | 209.37 | 209.19 | 209.35 | 3697.0 |
| 2025-07-31 04:35:00 | AAPL | Stock | 209.38 | 209.41 | 209.3 | 209.3 | 3705.0 |
| 2025-07-31 04:36:00 | AAPL | Stock | 209.38 | 209.5 | 209.38 | 209.5 | 1421.0 |
| 2025-07-31 04:37:00 | AAPL | Stock | 209.55 | 209.6 | 209.5 | 209.6 | 2482.0 |
| 2025-07-31 04:38:00 | AAPL | Stock | 209.5 | 209.61 | 209.5 | 209.61 | 355.0 |
| 2025-07-31 04:39:00 | AAPL | Stock | 209.69 | 209.8 | 209.6 | 209.6 | 6045.0 |
| 2025-07-31 04:40:00 | AAPL | Stock | 209.63 | 209.64 | 209.63 | 209.64 | 2293.0 |
| 2025-07-31 04:41:00 | AAPL | Stock | 209.65 | 209.65 | 209.62 | 209.62 | 1243.0 |
| 2025-07-31 04:42:00 | AAPL | Stock | 209.62 | 209.62 | 209.59 | 209.62 | 645.0 |
| 2025-07-31 04:43:00 | AAPL | Stock | 209.57 | 209.57 | 209.57 | 209.57 | 100.0 |
| 2025-07-31 04:44:00 | AAPL | Stock | 209.55 | 209.55 | 209.5 | 209.5 | 638.0 |
| 2025-07-31 04:45:00 | AAPL | Stock | 209.41 | 209.41 | 209.4 | 209.4 | 321.0 |
| 2025-07-31 04:46:00 | AAPL | Stock | 209.5 | 209.56 | 209.5 | 209.56 | 649.0 |
| 2025-07-31 04:47:00 | AAPL | Stock | 209.52 | 209.52 | 209.52 | 209.52 | 158.0 |
| 2025-07-31 04:48:00 | AAPL | Stock | 209.52 | 209.56 | 209.52 | 209.53 | 416.0 |
| 2025-07-31 04:49:00 | AAPL | Stock | 209.6 | 209.65 | 209.6 | 209.65 | 1066.0 |
| 2025-07-31 04:50:00 | AAPL | Stock | 209.65 | 209.65 | 209.65 | 209.65 | 100.0 |
| 2025-07-31 04:52:00 | AAPL | Stock | 209.53 | 209.53 | 209.53 | 209.53 | 100.0 |
| 2025-07-31 04:53:00 | AAPL | Stock | 209.51 | 209.51 | 209.35 | 209.35 | 2643.0 |
| 2025-07-31 04:54:00 | AAPL | Stock | 209.31 | 209.4 | 209.31 | 209.4 | 3047.0 |
> showing 50 of 1,412,153 rows — these rows as CSV