PREVIEW / etf_daily / 2026-07-02
file: by_date/etf_daily/2026/2026-07-02.parquet size: 157 KB rows: 4,134
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2026-07-02 | SPY | ETF | 747.4 | 751.31 | 740.03 | 744.78 | 57505953.0 |
| 2026-07-02 | QQQ | ETF | 725.58 | 730.83 | 707.56 | 712.6 | 51086080.0 |
| 2026-07-02 | IWM | ETF | 300.54 | 302.23 | 294.98 | 297.58 | 21236397.0 |
| 2026-07-02 | DIA | ETF | 525.49 | 528.26 | 523.73 | 527.88 | 3536644.0 |
| 2026-07-02 | GLD | ETF | 377.435 | 380.27 | 376.2862 | 378.13 | 7607967.0 |
| 2026-07-02 | TLT | ETF | 85.38 | 85.78 | 85.37 | 85.51 | 20957228.0 |
| 2026-07-02 | AAA | ETF | 25.0 | 25.0 | 24.94 | 24.9476 | 2481.0 |
| 2026-07-02 | AAAU | ETF | 40.55 | 40.85 | 40.43 | 40.63 | 1181970.0 |
| 2026-07-02 | AADR | ETF | 83.58 | 83.58 | 81.98 | 82.4841 | 1209.0 |
| 2026-07-02 | AAPB | ETF | 37.0 | 38.6299 | 37.0 | 38.5334 | 75365.0 |
| 2026-07-02 | AAPD | ETF | 11.93 | 11.93 | 11.31 | 11.36 | 9770095.0 |
| 2026-07-02 | AAPR | ETF | 29.57 | 29.57 | 29.5052 | 29.5052 | 146.0 |
| 2026-07-02 | AAPU | ETF | 36.1 | 39.8 | 35.96 | 39.48 | 2527462.0 |
| 2026-07-02 | AAPW | ETF | 37.87 | 40.15 | 37.86 | 40.15 | 20735.0 |
| 2026-07-02 | AAPX | ETF | 32.58 | 35.89 | 32.58 | 35.78 | 54322.0 |
| 2026-07-02 | AAPY | ETF | 26.0 | 26.2284 | 26.0 | 26.2284 | 29926.0 |
| 2026-07-02 | AAVM | ETF | 33.52 | 33.6245 | 33.52 | 33.6245 | 880.0 |
| 2026-07-02 | AAXJ | ETF | 115.8 | 116.81 | 112.43 | 113.94 | 567001.0 |
| 2026-07-02 | ABCS | ETF | 33.99 | 34.13 | 33.99 | 34.1029 | 2017.0 |
| 2026-07-02 | ABEQ | ETF | 37.46 | 37.83 | 37.3905 | 37.8277 | 15790.0 |
| 2026-07-02 | ABFL | ETF | 85.03 | 85.03 | 82.695 | 83.1202 | 6486.0 |
| 2026-07-02 | ABLD | ETF | 30.0 | 30.09 | 29.85 | 30.05 | 5732.0 |
| 2026-07-02 | ABLG | ETF | 31.8 | 31.8 | 31.4 | 31.6218 | 12380.0 |
| 2026-07-02 | ACES | ETF | 35.26 | 35.76 | 33.66 | 34.13 | 61398.0 |
| 2026-07-02 | ACIO | ETF | 46.15 | 46.4399 | 45.87 | 46.15 | 171417.0 |
| 2026-07-02 | ACLC | ETF | 84.42 | 84.58 | 83.525 | 84.12 | 4562.0 |
| 2026-07-02 | ACSG | ETF | 49.46 | 49.46 | 49.3684 | 49.3684 | 346.0 |
| 2026-07-02 | ACSI | ETF | 74.83 | 74.9266 | 74.645 | 74.9266 | 1246.0 |
| 2026-07-02 | ACT | ETF | 45.56 | 45.785 | 44.73 | 45.34 | 241535.0 |
| 2026-07-02 | ACVF | ETF | 54.27 | 54.27 | 53.45 | 53.8155 | 3667.0 |
| 2026-07-02 | ACWI | ETF | 156.89 | 157.77 | 155.03 | 156.15 | 3202347.0 |
| 2026-07-02 | ACWV | ETF | 121.28 | 122.075 | 121.28 | 122.055 | 120826.0 |
| 2026-07-02 | ACWX | ETF | 75.74 | 76.2 | 74.61 | 75.23 | 2674919.0 |
| 2026-07-02 | ADBG | ETF | 3.3 | 3.495 | 3.245 | 3.43 | 8275614.0 |
| 2026-07-02 | ADFI | ETF | 8.49 | 8.4946 | 8.48 | 8.4946 | 10318.0 |
| 2026-07-02 | ADIV | ETF | 18.76 | 18.76 | 18.4 | 18.44 | 2514.0 |
| 2026-07-02 | ADME | ETF | 55.88 | 55.88 | 55.1301 | 55.37 | 4495.0 |
| 2026-07-02 | ADPV | ETF | 47.125 | 47.125 | 45.69 | 45.91 | 11701.0 |
| 2026-07-02 | ADVE | ETF | 45.26 | 45.26 | 44.9475 | 44.9475 | 445.0 |
| 2026-07-02 | AESR | ETF | 20.485 | 20.485 | 19.91 | 20.0 | 30945.0 |
| 2026-07-02 | AFIF | ETF | 9.42 | 9.43 | 9.395 | 9.429 | 29601.0 |
| 2026-07-02 | AFIX | ETF | 24.74 | 24.82 | 24.74 | 24.7599 | 13001.0 |
| 2026-07-02 | AFK | ETF | 26.19 | 26.265 | 25.81 | 26.11 | 31461.0 |
| 2026-07-02 | AFLG | ETF | 43.37 | 43.52 | 42.85 | 43.165 | 36656.0 |
| 2026-07-02 | AFMC | ETF | 40.93 | 40.93 | 39.96 | 40.28 | 18017.0 |
| 2026-07-02 | AFSC | ETF | 38.97 | 38.97 | 38.37 | 38.4005 | 491.0 |
| 2026-07-02 | AFSM | ETF | 41.19 | 41.19 | 39.79 | 40.19 | 15327.0 |
| 2026-07-02 | AGEM | ETF | 47.99 | 48.27 | 46.97 | 47.6027 | 2263.0 |
| 2026-07-02 | AGG | ETF | 98.54 | 98.66 | 98.49 | 98.61 | 8407130.0 |
| 2026-07-02 | AGGA | ETF | 25.12 | 25.1423 | 25.12 | 25.1423 | 24995.0 |
> showing 50 of 4,134 rows — these rows as CSV