PREVIEW / etf_daily / 2026-07-28
file: by_date/etf_daily/2026/2026-07-28.parquet size: 158 KB rows: 4,169
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-28 | SPY | ETF | 739.19 | 742.7901 | 735.98 | 740.86 | 47322247.0 |
| 2026-07-28 | QQQ | ETF | 676.23 | 679.4 | 667.88 | 675.49 | 51398741.0 |
| 2026-07-28 | IWM | ETF | 293.16 | 293.77 | 290.375 | 293.37 | 20531085.0 |
| 2026-07-28 | DIA | ETF | 526.19 | 528.47 | 523.67 | 526.89 | 5157908.0 |
| 2026-07-28 | GLD | ETF | 369.605 | 371.23 | 367.98 | 369.37 | 4819262.0 |
| 2026-07-28 | TLT | ETF | 83.86 | 84.34 | 83.845 | 84.24 | 25366895.0 |
| 2026-07-28 | AAA | ETF | 25.0 | 25.02 | 24.9601 | 25.02 | 1704.0 |
| 2026-07-28 | AAAU | ETF | 39.71 | 39.895 | 39.55 | 39.705 | 685277.0 |
| 2026-07-28 | AADR | ETF | 80.97 | 81.29 | 80.8701 | 81.29 | 520.0 |
| 2026-07-28 | AAOG | ETF | 2.38 | 2.39 | 1.78 | 2.13 | 2591019.0 |
| 2026-07-28 | AAOX | ETF | 10.62 | 10.7 | 7.98 | 9.53 | 6316217.0 |
| 2026-07-28 | AAPB | ETF | 46.43 | 46.8 | 45.2101 | 46.28 | 49529.0 |
| 2026-07-28 | AAPD | ETF | 10.27 | 10.4182 | 10.1999 | 10.27 | 12945665.0 |
| 2026-07-28 | AAPR | ETF | 29.485 | 29.495 | 29.46 | 29.485 | 1399.0 |
| 2026-07-28 | AAPU | ETF | 47.72 | 48.4 | 46.4099 | 47.71 | 1341619.0 |
| 2026-07-28 | AAPW | ETF | 44.0 | 44.323 | 43.36 | 44.0296 | 18558.0 |
| 2026-07-28 | AAPX | ETF | 43.0 | 43.44 | 41.935 | 42.91 | 30451.0 |
| 2026-07-28 | AAPY | ETF | 28.76 | 28.8299 | 28.48 | 28.7689 | 9051.0 |
| 2026-07-28 | AAVM | ETF | 33.34 | 33.34 | 33.2478 | 33.2478 | 2298.0 |
| 2026-07-28 | AAXJ | ETF | 107.32 | 108.46 | 106.43 | 107.81 | 497751.0 |
| 2026-07-28 | ABCS | ETF | 35.49 | 35.78 | 35.4899 | 35.7539 | 3992.0 |
| 2026-07-28 | ABEQ | ETF | 38.54 | 38.84 | 38.54 | 38.6699 | 6204.0 |
| 2026-07-28 | ABFL | ETF | 80.77 | 81.6 | 80.77 | 81.49 | 13990.0 |
| 2026-07-28 | ABLD | ETF | 30.8264 | 30.8264 | 30.71 | 30.7311 | 7738.0 |
| 2026-07-28 | ABOT | ETF | 40.98 | 41.3389 | 40.98 | 41.3389 | 137.0 |
| 2026-07-28 | ACES | ETF | 30.43 | 30.52 | 29.8926 | 30.51 | 396169.0 |
| 2026-07-28 | ACIO | ETF | 45.52 | 45.77 | 45.425 | 45.61 | 163039.0 |
| 2026-07-28 | ACLC | ETF | 82.6098 | 83.27 | 82.545 | 83.0 | 9210.0 |
| 2026-07-28 | ACSG | ETF | 47.57 | 48.08 | 47.57 | 48.0671 | 3855.0 |
| 2026-07-28 | ACVF | ETF | 53.3699 | 53.6899 | 53.305 | 53.6237 | 4481.0 |
| 2026-07-28 | ACWI | ETF | 153.96 | 154.97 | 153.35 | 154.54 | 2029153.0 |
| 2026-07-28 | ACWV | ETF | 123.81 | 125.04 | 123.81 | 124.65 | 131122.0 |
| 2026-07-28 | ACWX | ETF | 73.43 | 74.255 | 73.33 | 73.94 | 2593821.0 |
| 2026-07-28 | ACYN | ETF | 20.56 | 20.59 | 20.48 | 20.57 | 1814513.0 |
| 2026-07-28 | ADBG | ETF | 4.075 | 4.45 | 4.05 | 4.29 | 12405880.0 |
| 2026-07-28 | ADIV | ETF | 19.33 | 19.43 | 19.33 | 19.4091 | 7220.0 |
| 2026-07-28 | ADME | ETF | 54.57 | 54.93 | 54.57 | 54.841 | 58262.0 |
| 2026-07-28 | ADPV | ETF | 44.465 | 44.5979 | 44.0 | 44.5979 | 3393.0 |
| 2026-07-28 | ADVE | ETF | 44.88 | 44.9572 | 44.88 | 44.9572 | 840.0 |
| 2026-07-28 | AESR | ETF | 19.5 | 19.5 | 19.18 | 19.4075 | 32051.0 |
| 2026-07-28 | AETH | ETF | 31.085 | 31.2803 | 31.085 | 31.2803 | 194.0 |
| 2026-07-28 | AFIF | ETF | 9.34 | 9.39 | 9.34 | 9.385 | 77572.0 |
| 2026-07-28 | AFIX | ETF | 24.48 | 24.53 | 24.48 | 24.495 | 15034.0 |
| 2026-07-28 | AFK | ETF | 25.63 | 26.12 | 25.5 | 25.5828 | 7510.0 |
| 2026-07-28 | AFLG | ETF | 43.53 | 43.815 | 43.405 | 43.76 | 36684.0 |
| 2026-07-28 | AFMC | ETF | 40.64 | 40.8896 | 40.59 | 40.88 | 17604.0 |
| 2026-07-28 | AFSC | ETF | 37.9396 | 37.9396 | 37.9396 | 37.9396 | 18.0 |
| 2026-07-28 | AFSM | ETF | 39.67 | 39.96 | 39.6 | 39.88 | 21163.0 |
| 2026-07-28 | AGEM | ETF | 45.755 | 45.9799 | 45.7 | 45.7508 | 3713.0 |
| 2026-07-28 | AGG | ETF | 97.79 | 98.01 | 97.765 | 97.92 | 12020859.0 |
> showing 50 of 4,169 rows — these rows as CSV