PREVIEW / etf_5min / 2025-07-01
file: by_date/etf_5min/2025/2025-07-01.parquet size: 2.9 MB rows: 145,112
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-01 04:00:00 | SPY | ETF | 617.03 | 617.23 | 616.68 | 616.82 | 11856.0 |
| 2025-07-01 04:05:00 | SPY | ETF | 616.69 | 616.93 | 616.67 | 616.93 | 25183.0 |
| 2025-07-01 04:10:00 | SPY | ETF | 616.94 | 617.01 | 616.86 | 616.86 | 38150.0 |
| 2025-07-01 04:15:00 | SPY | ETF | 616.97 | 617.0 | 616.97 | 617.0 | 870.0 |
| 2025-07-01 04:20:00 | SPY | ETF | 616.95 | 617.22 | 616.95 | 617.22 | 1650.0 |
| 2025-07-01 04:25:00 | SPY | ETF | 617.21 | 617.24 | 617.17 | 617.18 | 1200.0 |
| 2025-07-01 04:30:00 | SPY | ETF | 617.31 | 617.43 | 617.3 | 617.43 | 1130.0 |
| 2025-07-01 04:35:00 | SPY | ETF | 617.46 | 617.46 | 617.1 | 617.14 | 2500.0 |
| 2025-07-01 04:40:00 | SPY | ETF | 617.08 | 617.09 | 616.86 | 616.88 | 6039.0 |
| 2025-07-01 04:45:00 | SPY | ETF | 617.03 | 617.03 | 617.0 | 617.0 | 600.0 |
| 2025-07-01 04:50:00 | SPY | ETF | 617.19 | 617.23 | 617.08 | 617.13 | 7230.0 |
| 2025-07-01 04:55:00 | SPY | ETF | 617.2 | 617.2 | 617.12 | 617.12 | 1400.0 |
| 2025-07-01 05:00:00 | SPY | ETF | 617.2 | 617.21 | 617.1 | 617.1 | 1000.0 |
| 2025-07-01 05:05:00 | SPY | ETF | 617.12 | 617.12 | 616.88 | 616.9 | 5273.0 |
| 2025-07-01 05:10:00 | SPY | ETF | 616.81 | 616.81 | 616.69 | 616.69 | 2492.0 |
| 2025-07-01 05:15:00 | SPY | ETF | 616.74 | 616.99 | 616.68 | 616.99 | 7518.0 |
| 2025-07-01 05:20:00 | SPY | ETF | 616.94 | 616.97 | 616.92 | 616.97 | 600.0 |
| 2025-07-01 05:25:00 | SPY | ETF | 616.97 | 616.97 | 616.86 | 616.86 | 1800.0 |
| 2025-07-01 05:30:00 | SPY | ETF | 616.79 | 616.83 | 616.64 | 616.78 | 1770.0 |
| 2025-07-01 05:35:00 | SPY | ETF | 616.86 | 616.87 | 616.76 | 616.76 | 2087.0 |
| 2025-07-01 05:40:00 | SPY | ETF | 616.81 | 616.81 | 616.74 | 616.74 | 736.0 |
| 2025-07-01 05:45:00 | SPY | ETF | 616.73 | 616.73 | 616.41 | 616.57 | 6806.0 |
| 2025-07-01 05:50:00 | SPY | ETF | 616.52 | 616.58 | 616.5 | 616.57 | 2440.0 |
| 2025-07-01 05:55:00 | SPY | ETF | 616.75 | 616.95 | 616.75 | 616.95 | 3601.0 |
| 2025-07-01 06:00:00 | SPY | ETF | 617.0 | 617.08 | 616.92 | 616.95 | 1610.0 |
| 2025-07-01 06:05:00 | SPY | ETF | 616.95 | 617.04 | 616.95 | 617.04 | 900.0 |
| 2025-07-01 06:10:00 | SPY | ETF | 617.07 | 617.07 | 616.98 | 617.0 | 1103.0 |
| 2025-07-01 06:15:00 | SPY | ETF | 617.03 | 617.03 | 617.03 | 617.03 | 1399.0 |
| 2025-07-01 06:20:00 | SPY | ETF | 616.98 | 616.98 | 616.93 | 616.94 | 800.0 |
| 2025-07-01 06:25:00 | SPY | ETF | 616.82 | 616.82 | 616.82 | 616.82 | 1000.0 |
| 2025-07-01 06:30:00 | SPY | ETF | 616.75 | 616.75 | 616.73 | 616.73 | 940.0 |
| 2025-07-01 06:35:00 | SPY | ETF | 616.74 | 616.79 | 616.7 | 616.79 | 300.0 |
| 2025-07-01 06:40:00 | SPY | ETF | 616.75 | 616.77 | 616.7 | 616.7 | 1319.0 |
| 2025-07-01 06:45:00 | SPY | ETF | 616.76 | 616.76 | 616.72 | 616.73 | 1030.0 |
| 2025-07-01 06:50:00 | SPY | ETF | 616.74 | 616.79 | 616.72 | 616.72 | 1200.0 |
| 2025-07-01 06:55:00 | SPY | ETF | 616.68 | 616.97 | 616.67 | 616.97 | 1700.0 |
| 2025-07-01 07:00:00 | SPY | ETF | 616.96 | 617.14 | 616.91 | 617.05 | 10744.0 |
| 2025-07-01 07:05:00 | SPY | ETF | 617.08 | 617.12 | 616.99 | 617.02 | 11995.0 |
| 2025-07-01 07:10:00 | SPY | ETF | 616.94 | 617.04 | 616.94 | 616.99 | 5800.0 |
| 2025-07-01 07:15:00 | SPY | ETF | 617.01 | 617.11 | 616.8 | 616.85 | 8617.0 |
| 2025-07-01 07:20:00 | SPY | ETF | 616.84 | 617.05 | 616.84 | 616.94 | 1130.0 |
| 2025-07-01 07:25:00 | SPY | ETF | 616.99 | 617.01 | 616.88 | 616.97 | 2500.0 |
| 2025-07-01 07:30:00 | SPY | ETF | 617.09 | 617.1 | 617.02 | 617.1 | 2064.0 |
| 2025-07-01 07:35:00 | SPY | ETF | 617.121 | 617.13 | 617.04 | 617.05 | 6200.0 |
| 2025-07-01 07:40:00 | SPY | ETF | 617.0 | 617.01 | 616.93 | 616.99 | 6968.0 |
| 2025-07-01 07:45:00 | SPY | ETF | 616.96 | 617.02 | 616.9 | 617.02 | 7020.0 |
| 2025-07-01 07:50:00 | SPY | ETF | 616.95 | 616.95 | 616.79 | 616.79 | 4360.0 |
| 2025-07-01 07:55:00 | SPY | ETF | 616.77 | 616.98 | 616.56 | 616.91 | 19709.0 |
| 2025-07-01 08:00:00 | SPY | ETF | 616.94 | 617.51 | 616.61 | 616.86 | 42946.0 |
| 2025-07-01 08:05:00 | SPY | ETF | 616.88 | 616.93 | 616.43 | 616.48 | 7730.0 |
> showing 50 of 145,112 rows — these rows as CSV