PREVIEW / etf_1min / 2025-09-18
file: by_date/etf_1min/2025/2025-09-18.parquet size: 6.8 MB rows: 387,876
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-09-18 04:00:00 | SPY | ETF | 663.11 | 663.2 | 663.04 | 663.2 | 1880.0 |
| 2025-09-18 04:01:00 | SPY | ETF | 663.23 | 663.24 | 663.23 | 663.23 | 1029.0 |
| 2025-09-18 04:02:00 | SPY | ETF | 663.3 | 663.35 | 663.3 | 663.35 | 1730.0 |
| 2025-09-18 04:03:00 | SPY | ETF | 663.33 | 663.42 | 663.33 | 663.36 | 2833.0 |
| 2025-09-18 04:04:00 | SPY | ETF | 663.4 | 663.5 | 663.36 | 663.5 | 3095.0 |
| 2025-09-18 04:05:00 | SPY | ETF | 663.49 | 663.49 | 663.49 | 663.49 | 100.0 |
| 2025-09-18 04:06:00 | SPY | ETF | 663.5 | 663.5 | 663.42 | 663.5 | 1338.0 |
| 2025-09-18 04:07:00 | SPY | ETF | 663.39 | 663.39 | 663.27 | 663.27 | 1318.0 |
| 2025-09-18 04:08:00 | SPY | ETF | 663.32 | 663.49 | 663.32 | 663.49 | 1400.0 |
| 2025-09-18 04:09:00 | SPY | ETF | 663.29 | 663.37 | 663.29 | 663.36 | 700.0 |
| 2025-09-18 04:12:00 | SPY | ETF | 663.66 | 663.73 | 663.66 | 663.73 | 1800.0 |
| 2025-09-18 04:13:00 | SPY | ETF | 663.7 | 663.71 | 663.66 | 663.66 | 1439.0 |
| 2025-09-18 04:14:00 | SPY | ETF | 663.65 | 663.65 | 663.65 | 663.65 | 100.0 |
| 2025-09-18 04:15:00 | SPY | ETF | 663.6 | 663.6 | 663.6 | 663.6 | 3394.0 |
| 2025-09-18 04:16:00 | SPY | ETF | 663.59 | 663.59 | 663.54 | 663.57 | 400.0 |
| 2025-09-18 04:17:00 | SPY | ETF | 663.57 | 663.6 | 663.54 | 663.6 | 6357.0 |
| 2025-09-18 04:18:00 | SPY | ETF | 663.7 | 663.75 | 663.7 | 663.75 | 4074.0 |
| 2025-09-18 04:19:00 | SPY | ETF | 663.71 | 663.73 | 663.7 | 663.7 | 4261.0 |
| 2025-09-18 04:20:00 | SPY | ETF | 663.66 | 663.66 | 663.66 | 663.66 | 131.0 |
| 2025-09-18 04:21:00 | SPY | ETF | 663.64 | 663.66 | 663.64 | 663.66 | 400.0 |
| 2025-09-18 04:22:00 | SPY | ETF | 663.59 | 663.59 | 663.59 | 663.59 | 220.0 |
| 2025-09-18 04:23:00 | SPY | ETF | 663.7 | 663.7 | 663.7 | 663.7 | 220.0 |
| 2025-09-18 04:24:00 | SPY | ETF | 663.7 | 663.7 | 663.7 | 663.7 | 8798.0 |
| 2025-09-18 04:25:00 | SPY | ETF | 663.75 | 663.79 | 663.75 | 663.77 | 939.0 |
| 2025-09-18 04:26:00 | SPY | ETF | 663.81 | 663.82 | 663.76 | 663.76 | 2220.0 |
| 2025-09-18 04:27:00 | SPY | ETF | 663.68 | 663.78 | 663.68 | 663.74 | 1060.0 |
| 2025-09-18 04:29:00 | SPY | ETF | 663.88 | 663.88 | 663.88 | 663.88 | 300.0 |
| 2025-09-18 04:30:00 | SPY | ETF | 663.86 | 663.86 | 663.86 | 663.86 | 100.0 |
| 2025-09-18 04:31:00 | SPY | ETF | 663.89 | 663.95 | 663.89 | 663.95 | 303.0 |
| 2025-09-18 04:32:00 | SPY | ETF | 664.0 | 664.03 | 663.88 | 663.93 | 2280.0 |
| 2025-09-18 04:33:00 | SPY | ETF | 663.94 | 663.95 | 663.81 | 663.81 | 600.0 |
| 2025-09-18 04:34:00 | SPY | ETF | 663.96 | 663.96 | 663.96 | 663.96 | 100.0 |
| 2025-09-18 04:35:00 | SPY | ETF | 663.95 | 663.95 | 663.95 | 663.95 | 100.0 |
| 2025-09-18 04:37:00 | SPY | ETF | 664.0 | 664.0 | 663.96 | 663.96 | 200.0 |
| 2025-09-18 04:38:00 | SPY | ETF | 664.15 | 664.15 | 664.15 | 664.15 | 487.0 |
| 2025-09-18 04:40:00 | SPY | ETF | 664.11 | 664.11 | 664.11 | 664.11 | 250.0 |
| 2025-09-18 04:43:00 | SPY | ETF | 664.1 | 664.1 | 664.1 | 664.1 | 167.0 |
| 2025-09-18 04:44:00 | SPY | ETF | 664.1 | 664.1 | 664.09 | 664.09 | 2642.0 |
| 2025-09-18 04:46:00 | SPY | ETF | 664.16 | 664.19 | 664.16 | 664.19 | 200.0 |
| 2025-09-18 04:47:00 | SPY | ETF | 664.24 | 664.24 | 664.24 | 664.24 | 113.0 |
| 2025-09-18 04:48:00 | SPY | ETF | 664.29 | 664.51 | 664.29 | 664.49 | 4927.0 |
| 2025-09-18 04:49:00 | SPY | ETF | 664.51 | 664.55 | 664.51 | 664.55 | 800.0 |
| 2025-09-18 04:50:00 | SPY | ETF | 664.66 | 664.74 | 664.66 | 664.74 | 2096.0 |
| 2025-09-18 04:51:00 | SPY | ETF | 664.77 | 664.81 | 664.75 | 664.8 | 13576.0 |
| 2025-09-18 04:52:00 | SPY | ETF | 664.74 | 664.82 | 664.74 | 664.82 | 200.0 |
| 2025-09-18 04:53:00 | SPY | ETF | 664.76 | 664.76 | 664.67 | 664.69 | 974.0 |
| 2025-09-18 04:54:00 | SPY | ETF | 664.79 | 664.81 | 664.78 | 664.81 | 700.0 |
| 2025-09-18 04:55:00 | SPY | ETF | 664.81 | 664.98 | 664.81 | 664.94 | 5173.0 |
| 2025-09-18 04:56:00 | SPY | ETF | 664.79 | 664.81 | 664.79 | 664.81 | 400.0 |
| 2025-09-18 04:58:00 | SPY | ETF | 664.9 | 665.02 | 664.9 | 665.01 | 3954.0 |
> showing 50 of 387,876 rows — these rows as CSV