PREVIEW / etf_5min / 2025-07-29
file: by_date/etf_5min/2025/2025-07-29.parquet size: 2.8 MB rows: 139,847
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-29 04:00:00 | SPY | ETF | 638.44 | 638.49 | 638.1 | 638.45 | 4516.0 |
| 2025-07-29 04:05:00 | SPY | ETF | 638.44 | 638.61 | 638.42 | 638.55 | 12645.0 |
| 2025-07-29 04:10:00 | SPY | ETF | 638.56 | 638.56 | 638.47 | 638.47 | 536.0 |
| 2025-07-29 04:15:00 | SPY | ETF | 638.53 | 638.53 | 638.43 | 638.49 | 1844.0 |
| 2025-07-29 04:20:00 | SPY | ETF | 638.53 | 638.53 | 638.53 | 638.53 | 100.0 |
| 2025-07-29 04:25:00 | SPY | ETF | 638.54 | 638.55 | 638.52 | 638.55 | 300.0 |
| 2025-07-29 04:30:00 | SPY | ETF | 638.5 | 638.51 | 638.49 | 638.51 | 548.0 |
| 2025-07-29 04:35:00 | SPY | ETF | 638.52 | 638.52 | 638.46 | 638.48 | 673.0 |
| 2025-07-29 04:40:00 | SPY | ETF | 638.47 | 638.5 | 638.43 | 638.46 | 2238.0 |
| 2025-07-29 04:45:00 | SPY | ETF | 638.42 | 638.43 | 638.25 | 638.29 | 19901.0 |
| 2025-07-29 04:50:00 | SPY | ETF | 638.27 | 638.41 | 638.27 | 638.37 | 1700.0 |
| 2025-07-29 04:55:00 | SPY | ETF | 638.34 | 638.34 | 638.32 | 638.32 | 300.0 |
| 2025-07-29 05:00:00 | SPY | ETF | 638.34 | 638.42 | 638.34 | 638.42 | 1589.0 |
| 2025-07-29 05:05:00 | SPY | ETF | 638.48 | 638.49 | 638.46 | 638.47 | 2108.0 |
| 2025-07-29 05:10:00 | SPY | ETF | 638.48 | 638.57 | 638.47 | 638.57 | 3047.0 |
| 2025-07-29 05:15:00 | SPY | ETF | 638.65 | 638.65 | 638.44 | 638.45 | 1210.0 |
| 2025-07-29 05:20:00 | SPY | ETF | 638.37 | 638.38 | 638.3 | 638.36 | 2011.0 |
| 2025-07-29 05:25:00 | SPY | ETF | 638.4 | 638.4 | 638.35 | 638.36 | 463.0 |
| 2025-07-29 05:30:00 | SPY | ETF | 638.46 | 638.5 | 638.44 | 638.5 | 1152.0 |
| 2025-07-29 05:40:00 | SPY | ETF | 638.55 | 638.55 | 638.48 | 638.48 | 1400.0 |
| 2025-07-29 05:45:00 | SPY | ETF | 638.46 | 638.47 | 638.46 | 638.46 | 430.0 |
| 2025-07-29 05:50:00 | SPY | ETF | 638.64 | 638.74 | 638.64 | 638.64 | 11271.0 |
| 2025-07-29 05:55:00 | SPY | ETF | 638.64 | 638.73 | 638.32 | 638.56 | 9150.0 |
| 2025-07-29 06:00:00 | SPY | ETF | 638.65 | 638.75 | 638.65 | 638.67 | 2512.0 |
| 2025-07-29 06:05:00 | SPY | ETF | 638.69 | 638.69 | 638.59 | 638.65 | 1410.0 |
| 2025-07-29 06:10:00 | SPY | ETF | 638.66 | 638.69 | 638.63 | 638.63 | 1300.0 |
| 2025-07-29 06:15:00 | SPY | ETF | 638.6 | 638.65 | 638.57 | 638.59 | 1310.0 |
| 2025-07-29 06:20:00 | SPY | ETF | 638.58 | 638.58 | 638.58 | 638.58 | 140.0 |
| 2025-07-29 06:25:00 | SPY | ETF | 638.61 | 638.66 | 638.61 | 638.65 | 1500.0 |
| 2025-07-29 06:30:00 | SPY | ETF | 638.65 | 638.8 | 638.65 | 638.73 | 12986.0 |
| 2025-07-29 06:35:00 | SPY | ETF | 638.7 | 638.78 | 638.65 | 638.75 | 1518.0 |
| 2025-07-29 06:40:00 | SPY | ETF | 638.75 | 638.75 | 638.7 | 638.7 | 1100.0 |
| 2025-07-29 06:45:00 | SPY | ETF | 638.76 | 638.76 | 638.75 | 638.75 | 300.0 |
| 2025-07-29 06:50:00 | SPY | ETF | 638.7 | 638.75 | 638.7 | 638.75 | 792.0 |
| 2025-07-29 06:55:00 | SPY | ETF | 638.71 | 638.73 | 638.68 | 638.71 | 980.0 |
| 2025-07-29 07:00:00 | SPY | ETF | 638.69 | 638.89 | 638.69 | 638.73 | 16897.0 |
| 2025-07-29 07:05:00 | SPY | ETF | 638.7 | 638.72 | 638.59 | 638.64 | 14994.0 |
| 2025-07-29 07:10:00 | SPY | ETF | 638.61 | 638.64 | 638.6 | 638.601 | 4571.0 |
| 2025-07-29 07:15:00 | SPY | ETF | 638.61 | 638.63 | 638.51 | 638.51 | 800.0 |
| 2025-07-29 07:20:00 | SPY | ETF | 638.5 | 638.54 | 638.43 | 638.53 | 3291.0 |
| 2025-07-29 07:25:00 | SPY | ETF | 638.549 | 638.549 | 638.49 | 638.51 | 1800.0 |
| 2025-07-29 07:30:00 | SPY | ETF | 638.49 | 638.6 | 638.42 | 638.42 | 2998.0 |
| 2025-07-29 07:35:00 | SPY | ETF | 638.4 | 638.41 | 638.27 | 638.27 | 12900.0 |
| 2025-07-29 07:40:00 | SPY | ETF | 638.239 | 638.45 | 638.239 | 638.45 | 8900.0 |
| 2025-07-29 07:45:00 | SPY | ETF | 638.48 | 638.52 | 638.43 | 638.45 | 13722.0 |
| 2025-07-29 07:50:00 | SPY | ETF | 638.51 | 638.54 | 638.47 | 638.5 | 3444.0 |
| 2025-07-29 07:55:00 | SPY | ETF | 638.46 | 638.53 | 638.46 | 638.5 | 1660.0 |
| 2025-07-29 08:00:00 | SPY | ETF | 638.8 | 638.8683 | 637.82 | 638.55 | 31284.0 |
| 2025-07-29 08:05:00 | SPY | ETF | 638.58 | 638.7 | 638.56 | 638.58 | 3308.0 |
| 2025-07-29 08:10:00 | SPY | ETF | 638.57 | 638.589 | 638.48 | 638.49 | 4156.0 |
> showing 50 of 139,847 rows — these rows as CSV