PREVIEW / etf_daily / 2026-07-17
file: by_date/etf_daily/2026/2026-07-17.parquet size: 158 KB rows: 4,159
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-17 | SPY | ETF | 742.08 | 747.29 | 740.8 | 743.29 | 62650961.0 |
| 2026-07-17 | QQQ | ETF | 691.65 | 702.3 | 686.76 | 695.33 | 54109267.0 |
| 2026-07-17 | IWM | ETF | 292.03 | 296.13 | 291.64 | 294.04 | 28738549.0 |
| 2026-07-17 | DIA | ETF | 519.64 | 525.36 | 518.9 | 520.81 | 4741258.0 |
| 2026-07-17 | GLD | ETF | 364.11 | 369.21 | 363.6 | 368.41 | 6456632.0 |
| 2026-07-17 | TLT | ETF | 84.62 | 84.82 | 84.49 | 84.52 | 22065623.0 |
| 2026-07-17 | AAA | ETF | 24.9301 | 24.955 | 24.88 | 24.94 | 7090.0 |
| 2026-07-17 | AAAU | ETF | 39.11 | 39.66 | 39.08 | 39.59 | 1462120.0 |
| 2026-07-17 | AADR | ETF | 82.4999 | 82.4999 | 82.115 | 82.115 | 2173.0 |
| 2026-07-17 | AAOG | ETF | 2.65 | 3.27 | 2.425 | 3.06 | 1748202.0 |
| 2026-07-17 | AAOX | ETF | 12.04 | 14.6999 | 10.83 | 13.62 | 5820696.0 |
| 2026-07-17 | AAPB | ETF | 44.43 | 45.055 | 43.56 | 44.8802 | 86289.0 |
| 2026-07-17 | AAPD | ETF | 10.53 | 10.63 | 10.445 | 10.48 | 17118033.0 |
| 2026-07-17 | AAPR | ETF | 29.52 | 29.57 | 29.49 | 29.505 | 5118.0 |
| 2026-07-17 | AAPU | ETF | 45.67 | 46.4 | 44.785 | 46.03 | 2569442.0 |
| 2026-07-17 | AAPW | ETF | 43.485 | 43.82 | 43.035 | 43.82 | 25584.0 |
| 2026-07-17 | AAPX | ETF | 41.05 | 41.83 | 40.51 | 41.5 | 56756.0 |
| 2026-07-17 | AAPY | ETF | 28.14 | 28.47 | 28.14 | 28.435 | 5233.0 |
| 2026-07-17 | AAVM | ETF | 33.1634 | 33.1634 | 33.1634 | 33.1634 | 153.0 |
| 2026-07-17 | AAXJ | ETF | 107.92 | 110.93 | 107.32 | 109.81 | 811477.0 |
| 2026-07-17 | ABCS | ETF | 34.82 | 34.82 | 34.5476 | 34.5476 | 1009.0 |
| 2026-07-17 | ABEQ | ETF | 37.55 | 37.8501 | 37.485 | 37.52 | 6383.0 |
| 2026-07-17 | ABFL | ETF | 81.99 | 82.75 | 81.9801 | 82.24 | 5756.0 |
| 2026-07-17 | ABLD | ETF | 31.17 | 31.17 | 30.1238 | 30.2177 | 7190.0 |
| 2026-07-17 | ABOT | ETF | 40.38 | 40.4372 | 40.38 | 40.4372 | 423.0 |
| 2026-07-17 | ACES | ETF | 31.9 | 32.7 | 31.8 | 32.54 | 47269.0 |
| 2026-07-17 | ACIO | ETF | 45.72 | 46.09 | 45.72 | 45.91 | 179214.0 |
| 2026-07-17 | ACLC | ETF | 84.0598 | 84.215 | 83.7866 | 83.7866 | 2680.0 |
| 2026-07-17 | ACSG | ETF | 48.61 | 48.87 | 48.5682 | 48.5682 | 822.0 |
| 2026-07-17 | ACSI | ETF | 76.269 | 76.48 | 76.0593 | 76.0593 | 1236.0 |
| 2026-07-17 | ACVF | ETF | 53.37 | 53.64 | 53.37 | 53.38 | 8658.0 |
| 2026-07-17 | ACWI | ETF | 154.37 | 155.59 | 153.9 | 155.0 | 5062943.0 |
| 2026-07-17 | ACWV | ETF | 121.97 | 122.675 | 121.62 | 121.72 | 127010.0 |
| 2026-07-17 | ACWX | ETF | 73.4 | 74.275 | 73.2 | 74.01 | 1856315.0 |
| 2026-07-17 | ACYN | ETF | 20.62 | 20.63 | 20.56 | 20.62 | 3364488.0 |
| 2026-07-17 | ADBG | ETF | 3.89 | 4.04 | 3.78 | 3.94 | 15088496.0 |
| 2026-07-17 | ADFI | ETF | 8.43 | 8.45 | 8.41 | 8.435 | 9849.0 |
| 2026-07-17 | ADIV | ETF | 18.92 | 19.03 | 18.92 | 18.9989 | 3078.0 |
| 2026-07-17 | ADME | ETF | 55.37 | 55.37 | 55.11 | 55.1708 | 7913.0 |
| 2026-07-17 | ADPV | ETF | 44.5794 | 45.4 | 44.5794 | 45.27 | 20466.0 |
| 2026-07-17 | AESR | ETF | 19.48 | 19.75 | 19.37 | 19.642 | 24193.0 |
| 2026-07-17 | AFIF | ETF | 9.43 | 9.51 | 9.26 | 9.41 | 707661.0 |
| 2026-07-17 | AFIX | ETF | 24.72 | 24.72 | 24.685 | 24.685 | 8352.0 |
| 2026-07-17 | AFK | ETF | 25.67 | 25.67 | 25.19 | 25.34 | 58029.0 |
| 2026-07-17 | AFLG | ETF | 43.33 | 43.69 | 43.32 | 43.51 | 54719.0 |
| 2026-07-17 | AFMC | ETF | 40.19 | 40.54 | 40.19 | 40.39 | 43151.0 |
| 2026-07-17 | AFSC | ETF | 38.023 | 38.023 | 38.023 | 38.023 | 65.0 |
| 2026-07-17 | AFSM | ETF | 40.085 | 40.21 | 39.86 | 39.9854 | 7271.0 |
| 2026-07-17 | AGEM | ETF | 45.42 | 46.48 | 45.42 | 46.2458 | 1888.0 |
| 2026-07-17 | AGG | ETF | 98.32 | 98.3959 | 98.175 | 98.2 | 6552297.0 |
> showing 50 of 4,159 rows — these rows as CSV