PREVIEW / etf_5min / 2025-07-23
file: by_date/etf_5min/2025/2025-07-23.parquet size: 2.9 MB rows: 142,147
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-23 04:00:00 | SPY | ETF | 630.48 | 630.73 | 630.48 | 630.73 | 2133.0 |
| 2025-07-23 04:05:00 | SPY | ETF | 630.78 | 630.87 | 630.69 | 630.78 | 2510.0 |
| 2025-07-23 04:10:00 | SPY | ETF | 630.81 | 631.09 | 630.8 | 631.04 | 1793.0 |
| 2025-07-23 04:15:00 | SPY | ETF | 631.01 | 631.04 | 630.97 | 631.04 | 1420.0 |
| 2025-07-23 04:20:00 | SPY | ETF | 631.04 | 631.24 | 630.95 | 631.17 | 6911.0 |
| 2025-07-23 04:25:00 | SPY | ETF | 631.31 | 631.34 | 631.18 | 631.19 | 1820.0 |
| 2025-07-23 04:30:00 | SPY | ETF | 631.17 | 631.17 | 631.08 | 631.11 | 1919.0 |
| 2025-07-23 04:35:00 | SPY | ETF | 631.11 | 631.12 | 631.06 | 631.06 | 5624.0 |
| 2025-07-23 04:40:00 | SPY | ETF | 631.1 | 631.25 | 631.05 | 631.25 | 4820.0 |
| 2025-07-23 04:45:00 | SPY | ETF | 631.26 | 631.53 | 631.21 | 631.42 | 4103.0 |
| 2025-07-23 04:50:00 | SPY | ETF | 631.43 | 631.43 | 631.34 | 631.38 | 1895.0 |
| 2025-07-23 04:55:00 | SPY | ETF | 631.32 | 631.5 | 631.32 | 631.46 | 6939.0 |
| 2025-07-23 05:00:00 | SPY | ETF | 631.48 | 631.64 | 631.47 | 631.55 | 14074.0 |
| 2025-07-23 05:05:00 | SPY | ETF | 631.53 | 631.63 | 631.53 | 631.62 | 3881.0 |
| 2025-07-23 05:10:00 | SPY | ETF | 631.52 | 631.57 | 631.41 | 631.41 | 3974.0 |
| 2025-07-23 05:15:00 | SPY | ETF | 631.47 | 631.54 | 631.47 | 631.49 | 1500.0 |
| 2025-07-23 05:20:00 | SPY | ETF | 631.44 | 631.45 | 631.39 | 631.41 | 12685.0 |
| 2025-07-23 05:25:00 | SPY | ETF | 631.35 | 631.35 | 631.27 | 631.27 | 2308.0 |
| 2025-07-23 05:30:00 | SPY | ETF | 631.22 | 631.26 | 631.18 | 631.26 | 1990.0 |
| 2025-07-23 05:35:00 | SPY | ETF | 631.22 | 631.35 | 631.22 | 631.33 | 400.0 |
| 2025-07-23 05:40:00 | SPY | ETF | 631.31 | 631.38 | 631.29 | 631.37 | 1146.0 |
| 2025-07-23 05:45:00 | SPY | ETF | 631.35 | 631.36 | 631.35 | 631.36 | 300.0 |
| 2025-07-23 05:50:00 | SPY | ETF | 631.42 | 631.51 | 631.41 | 631.49 | 16986.0 |
| 2025-07-23 05:55:00 | SPY | ETF | 631.5 | 631.59 | 631.5 | 631.58 | 1225.0 |
| 2025-07-23 06:00:00 | SPY | ETF | 631.53 | 631.65 | 631.53 | 631.61 | 1130.0 |
| 2025-07-23 06:05:00 | SPY | ETF | 631.53 | 631.54 | 631.43 | 631.43 | 3232.0 |
| 2025-07-23 06:10:00 | SPY | ETF | 631.47 | 631.49 | 631.41 | 631.41 | 3698.0 |
| 2025-07-23 06:15:00 | SPY | ETF | 631.41 | 631.41 | 631.37 | 631.39 | 12961.0 |
| 2025-07-23 06:20:00 | SPY | ETF | 631.62 | 631.77 | 631.51 | 631.51 | 3810.0 |
| 2025-07-23 06:25:00 | SPY | ETF | 631.59 | 631.6 | 631.56 | 631.56 | 502.0 |
| 2025-07-23 06:30:00 | SPY | ETF | 631.59 | 631.74 | 631.58 | 631.59 | 14084.0 |
| 2025-07-23 06:35:00 | SPY | ETF | 631.56 | 631.63 | 631.56 | 631.57 | 5211.0 |
| 2025-07-23 06:40:00 | SPY | ETF | 631.6 | 631.62 | 631.56 | 631.6 | 1962.0 |
| 2025-07-23 06:45:00 | SPY | ETF | 631.59 | 631.62 | 631.5 | 631.5 | 4818.0 |
| 2025-07-23 06:50:00 | SPY | ETF | 631.5 | 631.53 | 631.34 | 631.34 | 16023.0 |
| 2025-07-23 06:55:00 | SPY | ETF | 631.37 | 631.55 | 631.36 | 631.37 | 12228.0 |
| 2025-07-23 07:00:00 | SPY | ETF | 631.37 | 631.38 | 631.34 | 631.34 | 2722.0 |
| 2025-07-23 07:05:00 | SPY | ETF | 631.35 | 631.4 | 630.77 | 630.85 | 9024.0 |
| 2025-07-23 07:10:00 | SPY | ETF | 630.88 | 631.25 | 630.79 | 631.0 | 8364.0 |
| 2025-07-23 07:15:00 | SPY | ETF | 630.98 | 631.07 | 630.8 | 631.05 | 45784.0 |
| 2025-07-23 07:20:00 | SPY | ETF | 630.99 | 631.21 | 630.98 | 631.18 | 4395.0 |
| 2025-07-23 07:25:00 | SPY | ETF | 631.12 | 631.2 | 631.07 | 631.07 | 5203.0 |
| 2025-07-23 07:30:00 | SPY | ETF | 631.08 | 631.17 | 631.0 | 631.08 | 35070.0 |
| 2025-07-23 07:35:00 | SPY | ETF | 631.06 | 631.35 | 631.06 | 631.3 | 4830.0 |
| 2025-07-23 07:40:00 | SPY | ETF | 631.34 | 631.41 | 631.11 | 631.17 | 31193.0 |
| 2025-07-23 07:45:00 | SPY | ETF | 631.25 | 631.28 | 631.19 | 631.28 | 7338.0 |
| 2025-07-23 07:50:00 | SPY | ETF | 631.29 | 631.35 | 631.29 | 631.3 | 4231.0 |
| 2025-07-23 07:55:00 | SPY | ETF | 631.29 | 631.38 | 631.271 | 631.33 | 14445.0 |
| 2025-07-23 08:00:00 | SPY | ETF | 631.38 | 631.65 | 630.09 | 631.53 | 84165.0 |
| 2025-07-23 08:05:00 | SPY | ETF | 631.51 | 631.56 | 631.33 | 631.33 | 10374.0 |
> showing 50 of 142,147 rows — these rows as CSV