PREVIEW / stock_1min / 2025-01-21
file: by_date/stock_1min/2025/2025-01-21.parquet size: 24.2 MB rows: 1,374,759 symbols: 593
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-01-21 04:00:00 | AAPL | Stock | 227.33 | 228.27 | 226.5 | 226.72 | 20564.0 |
| 2025-01-21 04:01:00 | AAPL | Stock | 226.85 | 226.99 | 226.81 | 226.9 | 3495.0 |
| 2025-01-21 04:02:00 | AAPL | Stock | 226.88 | 227.0 | 226.88 | 227.0 | 1455.0 |
| 2025-01-21 04:03:00 | AAPL | Stock | 227.0 | 227.29 | 227.0 | 227.12 | 3377.0 |
| 2025-01-21 04:04:00 | AAPL | Stock | 227.25 | 227.26 | 227.25 | 227.26 | 383.0 |
| 2025-01-21 04:05:00 | AAPL | Stock | 227.3 | 227.3 | 227.3 | 227.3 | 320.0 |
| 2025-01-21 04:06:00 | AAPL | Stock | 227.36 | 227.36 | 227.23 | 227.23 | 2005.0 |
| 2025-01-21 04:07:00 | AAPL | Stock | 227.21 | 227.36 | 227.17 | 227.36 | 1534.0 |
| 2025-01-21 04:08:00 | AAPL | Stock | 227.4 | 227.4 | 227.11 | 227.15 | 1190.0 |
| 2025-01-21 04:09:00 | AAPL | Stock | 227.16 | 227.17 | 227.16 | 227.17 | 538.0 |
| 2025-01-21 04:10:00 | AAPL | Stock | 227.35 | 227.49 | 227.35 | 227.49 | 518.0 |
| 2025-01-21 04:11:00 | AAPL | Stock | 227.42 | 227.52 | 227.42 | 227.52 | 953.0 |
| 2025-01-21 04:12:00 | AAPL | Stock | 227.61 | 227.61 | 227.61 | 227.61 | 800.0 |
| 2025-01-21 04:13:00 | AAPL | Stock | 227.66 | 227.66 | 227.59 | 227.59 | 200.0 |
| 2025-01-21 04:14:00 | AAPL | Stock | 227.59 | 227.59 | 227.57 | 227.57 | 746.0 |
| 2025-01-21 04:15:00 | AAPL | Stock | 227.59 | 227.69 | 227.59 | 227.68 | 515.0 |
| 2025-01-21 04:16:00 | AAPL | Stock | 227.63 | 227.66 | 227.5 | 227.5 | 2133.0 |
| 2025-01-21 04:17:00 | AAPL | Stock | 227.5 | 227.52 | 227.46 | 227.46 | 2288.0 |
| 2025-01-21 04:18:00 | AAPL | Stock | 227.52 | 227.56 | 227.52 | 227.53 | 300.0 |
| 2025-01-21 04:19:00 | AAPL | Stock | 227.56 | 227.56 | 227.55 | 227.55 | 400.0 |
| 2025-01-21 04:20:00 | AAPL | Stock | 227.54 | 227.54 | 227.51 | 227.52 | 3303.0 |
| 2025-01-21 04:21:00 | AAPL | Stock | 227.52 | 227.56 | 227.52 | 227.55 | 517.0 |
| 2025-01-21 04:23:00 | AAPL | Stock | 227.59 | 227.6 | 227.55 | 227.6 | 1169.0 |
| 2025-01-21 04:24:00 | AAPL | Stock | 227.56 | 227.58 | 227.11 | 227.11 | 4221.0 |
| 2025-01-21 04:25:00 | AAPL | Stock | 227.03 | 227.14 | 227.03 | 227.14 | 300.0 |
| 2025-01-21 04:26:00 | AAPL | Stock | 227.17 | 227.17 | 227.08 | 227.13 | 700.0 |
| 2025-01-21 04:27:00 | AAPL | Stock | 227.13 | 227.14 | 227.13 | 227.14 | 314.0 |
| 2025-01-21 04:28:00 | AAPL | Stock | 227.23 | 227.23 | 227.23 | 227.23 | 100.0 |
| 2025-01-21 04:29:00 | AAPL | Stock | 227.24 | 227.24 | 227.23 | 227.23 | 200.0 |
| 2025-01-21 04:30:00 | AAPL | Stock | 227.25 | 227.27 | 227.23 | 227.27 | 1208.0 |
| 2025-01-21 04:33:00 | AAPL | Stock | 227.34 | 227.34 | 227.34 | 227.34 | 100.0 |
| 2025-01-21 04:34:00 | AAPL | Stock | 227.34 | 227.34 | 227.33 | 227.33 | 394.0 |
| 2025-01-21 04:35:00 | AAPL | Stock | 227.23 | 227.23 | 227.16 | 227.16 | 600.0 |
| 2025-01-21 04:36:00 | AAPL | Stock | 227.15 | 227.21 | 227.03 | 227.15 | 1574.0 |
| 2025-01-21 04:37:00 | AAPL | Stock | 227.2 | 227.2 | 227.15 | 227.15 | 1660.0 |
| 2025-01-21 04:38:00 | AAPL | Stock | 227.14 | 227.18 | 227.14 | 227.18 | 600.0 |
| 2025-01-21 04:39:00 | AAPL | Stock | 227.13 | 227.13 | 227.09 | 227.09 | 600.0 |
| 2025-01-21 04:40:00 | AAPL | Stock | 227.01 | 227.01 | 226.7 | 226.83 | 8623.0 |
| 2025-01-21 04:41:00 | AAPL | Stock | 226.83 | 226.83 | 226.71 | 226.71 | 956.0 |
| 2025-01-21 04:42:00 | AAPL | Stock | 226.77 | 226.77 | 226.65 | 226.65 | 1716.0 |
| 2025-01-21 04:43:00 | AAPL | Stock | 226.68 | 226.68 | 226.68 | 226.68 | 1879.0 |
| 2025-01-21 04:44:00 | AAPL | Stock | 226.68 | 226.68 | 226.68 | 226.68 | 2265.0 |
| 2025-01-21 04:45:00 | AAPL | Stock | 226.86 | 226.87 | 226.78 | 226.87 | 1300.0 |
| 2025-01-21 04:46:00 | AAPL | Stock | 226.87 | 226.9 | 226.87 | 226.9 | 866.0 |
| 2025-01-21 04:47:00 | AAPL | Stock | 226.95 | 226.95 | 226.95 | 226.95 | 896.0 |
| 2025-01-21 04:48:00 | AAPL | Stock | 226.96 | 226.96 | 226.9 | 226.9 | 279.0 |
| 2025-01-21 04:49:00 | AAPL | Stock | 226.99 | 226.99 | 226.91 | 226.91 | 429.0 |
| 2025-01-21 04:52:00 | AAPL | Stock | 226.99 | 226.99 | 226.99 | 226.99 | 100.0 |
| 2025-01-21 04:53:00 | AAPL | Stock | 227.06 | 227.1 | 227.06 | 227.1 | 764.0 |
| 2025-01-21 04:56:00 | AAPL | Stock | 227.03 | 227.03 | 227.03 | 227.03 | 100.0 |
> showing 50 of 1,374,759 rows — these rows as CSV