PREVIEW / etf_daily / 2026-07-09
file: by_date/etf_daily/2026/2026-07-09.parquet size: 158 KB rows: 4,166
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-09 | SPY | ETF | 747.35 | 751.97 | 745.59 | 751.71 | 41441718.0 |
| 2026-07-09 | QQQ | ETF | 718.33 | 724.23 | 715.125 | 723.28 | 33654712.0 |
| 2026-07-09 | IWM | ETF | 295.27 | 297.88 | 294.9 | 297.24 | 16466826.0 |
| 2026-07-09 | DIA | ETF | 523.65 | 525.15 | 522.135 | 524.19 | 3056449.0 |
| 2026-07-09 | GLD | ETF | 378.505 | 379.65 | 377.41 | 378.18 | 4754582.0 |
| 2026-07-09 | TLT | ETF | 84.28 | 84.68 | 84.255 | 84.49 | 18625289.0 |
| 2026-07-09 | AAA | ETF | 25.005 | 25.0399 | 24.9701 | 25.0 | 2106.0 |
| 2026-07-09 | AAAU | ETF | 40.66 | 40.78 | 40.56 | 40.64 | 645122.0 |
| 2026-07-09 | AADR | ETF | 83.75 | 84.19 | 83.75 | 84.145 | 719.0 |
| 2026-07-09 | AAOG | ETF | 4.47 | 4.9799 | 4.33 | 4.59 | 2006779.0 |
| 2026-07-09 | AAOX | ETF | 19.83 | 22.3 | 19.3501 | 20.55 | 6057103.0 |
| 2026-07-09 | AAPB | ETF | 38.915 | 40.45 | 38.39 | 40.381 | 45151.0 |
| 2026-07-09 | AAPD | ETF | 11.26 | 11.35 | 11.05 | 11.06 | 4710256.0 |
| 2026-07-09 | AAPR | ETF | 29.56 | 29.5899 | 29.55 | 29.55 | 2166.0 |
| 2026-07-09 | AAPU | ETF | 40.03 | 41.615 | 39.47 | 41.52 | 1159863.0 |
| 2026-07-09 | AAPW | ETF | 40.32 | 41.263 | 40.32 | 41.263 | 13842.0 |
| 2026-07-09 | AAPX | ETF | 36.3 | 37.63 | 35.77 | 37.47 | 69727.0 |
| 2026-07-09 | AAPY | ETF | 26.3 | 26.7999 | 26.3 | 26.7525 | 4556.0 |
| 2026-07-09 | AAVM | ETF | 33.4353 | 33.4353 | 33.4353 | 33.4353 | 52.0 |
| 2026-07-09 | AAXJ | ETF | 115.98 | 116.67 | 115.6 | 116.29 | 618944.0 |
| 2026-07-09 | ABCS | ETF | 33.85 | 34.1 | 33.85 | 34.039 | 2975.0 |
| 2026-07-09 | ABEQ | ETF | 37.27 | 37.34 | 37.23 | 37.27 | 25913.0 |
| 2026-07-09 | ABFL | ETF | 84.3262 | 84.345 | 84.0 | 84.18 | 14208.0 |
| 2026-07-09 | ABLD | ETF | 30.0656 | 30.08 | 29.96 | 29.96 | 8697.0 |
| 2026-07-09 | ACES | ETF | 33.6 | 33.8 | 33.5 | 33.7 | 8989.0 |
| 2026-07-09 | ACIO | ETF | 46.27 | 46.52 | 46.1657 | 46.52 | 141184.0 |
| 2026-07-09 | ACLC | ETF | 84.79 | 85.0499 | 84.5 | 84.9637 | 3816.0 |
| 2026-07-09 | ACSG | ETF | 49.75 | 49.97 | 49.75 | 49.8986 | 1827.0 |
| 2026-07-09 | ACVF | ETF | 54.2 | 54.24 | 54.06 | 54.1317 | 3613.0 |
| 2026-07-09 | ACWI | ETF | 156.51 | 157.26 | 156.09 | 157.02 | 1709031.0 |
| 2026-07-09 | ACWV | ETF | 121.88 | 122.16 | 121.67 | 121.99 | 75204.0 |
| 2026-07-09 | ACWX | ETF | 75.29 | 75.645 | 75.15 | 75.47 | 896285.0 |
| 2026-07-09 | ACYN | ETF | 20.62 | 20.65 | 20.605 | 20.65 | 1745851.0 |
| 2026-07-09 | ADBG | ETF | 3.21 | 3.51 | 3.21 | 3.5 | 3416862.0 |
| 2026-07-09 | ADFI | ETF | 8.36 | 8.47 | 8.36 | 8.47 | 24466.0 |
| 2026-07-09 | ADIV | ETF | 18.99 | 18.99 | 18.955 | 18.955 | 1072.0 |
| 2026-07-09 | ADME | ETF | 55.41 | 55.84 | 55.41 | 55.805 | 5039.0 |
| 2026-07-09 | ADPV | ETF | 46.46 | 46.77 | 46.46 | 46.4937 | 11565.0 |
| 2026-07-09 | ADVE | ETF | 45.9 | 45.9 | 45.777 | 45.777 | 482.0 |
| 2026-07-09 | AESR | ETF | 19.95 | 20.33 | 19.95 | 20.3 | 42014.0 |
| 2026-07-09 | AFIF | ETF | 9.4 | 9.4 | 9.39 | 9.395 | 227752.0 |
| 2026-07-09 | AFIX | ETF | 24.6501 | 24.695 | 24.6501 | 24.675 | 16026.0 |
| 2026-07-09 | AFK | ETF | 25.96 | 25.9999 | 25.77 | 25.92 | 7452.0 |
| 2026-07-09 | AFLG | ETF | 43.49 | 43.68 | 43.43 | 43.59 | 90264.0 |
| 2026-07-09 | AFMC | ETF | 40.09 | 40.44 | 40.09 | 40.23 | 17439.0 |
| 2026-07-09 | AFSC | ETF | 38.25 | 38.25 | 38.1949 | 38.1949 | 388.0 |
| 2026-07-09 | AFSM | ETF | 40.25 | 40.46 | 40.09 | 40.4 | 13180.0 |
| 2026-07-09 | AGEM | ETF | 48.47 | 49.99 | 46.31 | 48.3732 | 32679.0 |
| 2026-07-09 | AGG | ETF | 98.12 | 98.3099 | 98.04 | 98.18 | 9011059.0 |
| 2026-07-09 | AGGA | ETF | 25.01 | 25.04 | 25.009 | 25.01 | 11260.0 |
> showing 50 of 4,166 rows — these rows as CSV