PREVIEW / etf_daily / 2026-07-29
file: by_date/etf_daily/2026/2026-07-29.parquet size: 160 KB rows: 4,193
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-29 | SPY | ETF | 739.97 | 742.68 | 729.1 | 729.46 | 70697215.0 |
| 2026-07-29 | QQQ | ETF | 675.505 | 680.05 | 661.14 | 661.73 | 57233269.0 |
| 2026-07-29 | IWM | ETF | 292.49 | 293.665 | 288.26 | 288.57 | 33297418.0 |
| 2026-07-29 | DIA | ETF | 522.46 | 523.17 | 514.82 | 515.41 | 7369396.0 |
| 2026-07-29 | GLD | ETF | 368.29 | 377.62 | 366.526 | 371.08 | 11839935.0 |
| 2026-07-29 | TLT | ETF | 84.1 | 84.1513 | 82.7 | 82.85 | 41445198.0 |
| 2026-07-29 | AAA | ETF | 24.9 | 25.05 | 24.9 | 25.02 | 1173.0 |
| 2026-07-29 | AAAU | ETF | 39.57 | 40.57 | 39.4 | 39.86 | 1910045.0 |
| 2026-07-29 | AADR | ETF | 81.22 | 81.22 | 80.6341 | 80.6341 | 1486.0 |
| 2026-07-29 | AAOG | ETF | 2.13 | 2.135 | 1.55 | 1.57 | 2179168.0 |
| 2026-07-29 | AAOX | ETF | 9.54 | 9.59 | 6.94 | 7.01 | 7132226.0 |
| 2026-07-29 | AAPB | ETF | 46.35 | 47.6294 | 45.09 | 45.728 | 65291.0 |
| 2026-07-29 | AAPD | ETF | 10.28 | 10.3581 | 10.14 | 10.33 | 10587675.0 |
| 2026-07-29 | AAPR | ETF | 29.425 | 29.505 | 29.39 | 29.4322 | 4998.0 |
| 2026-07-29 | AAPU | ETF | 47.62 | 48.8901 | 46.91 | 47.14 | 1781277.0 |
| 2026-07-29 | AAPW | ETF | 43.86 | 44.65 | 43.715 | 43.715 | 38723.0 |
| 2026-07-29 | AAPX | ETF | 43.06 | 44.0 | 42.42 | 42.42 | 43294.0 |
| 2026-07-29 | AAPY | ETF | 28.782 | 29.12 | 28.5901 | 28.5901 | 6317.0 |
| 2026-07-29 | AAVM | ETF | 32.87 | 33.12 | 32.87 | 33.0137 | 683.0 |
| 2026-07-29 | AAXJ | ETF | 106.87 | 108.53 | 105.07 | 105.65 | 465955.0 |
| 2026-07-29 | ABCS | ETF | 35.85 | 35.85 | 35.7083 | 35.7083 | 1142.0 |
| 2026-07-29 | ABEQ | ETF | 38.73 | 38.73 | 38.56 | 38.5633 | 7004.0 |
| 2026-07-29 | ABFL | ETF | 81.0 | 81.3738 | 79.7698 | 79.7698 | 21007.0 |
| 2026-07-29 | ABLD | ETF | 30.84 | 30.94 | 30.5951 | 30.6356 | 6214.0 |
| 2026-07-29 | ACES | ETF | 30.51 | 30.63 | 29.4 | 29.59 | 140059.0 |
| 2026-07-29 | ACGR | ETF | 65.155 | 65.155 | 64.6382 | 64.6382 | 247.0 |
| 2026-07-29 | ACIO | ETF | 45.6 | 45.7188 | 45.04 | 45.04 | 115118.0 |
| 2026-07-29 | ACLC | ETF | 82.79 | 83.0 | 82.038 | 82.038 | 18434.0 |
| 2026-07-29 | ACSG | ETF | 46.88 | 47.62 | 46.88 | 46.92 | 12481.0 |
| 2026-07-29 | ACSI | ETF | 77.34 | 77.34 | 76.1505 | 76.1505 | 543.0 |
| 2026-07-29 | ACVF | ETF | 53.61 | 53.61 | 52.82 | 52.8207 | 1964.0 |
| 2026-07-29 | ACVT | ETF | 28.06 | 28.06 | 27.985 | 27.985 | 346.0 |
| 2026-07-29 | ACWI | ETF | 154.16 | 155.34 | 151.42 | 152.47 | 2624912.0 |
| 2026-07-29 | ACWV | ETF | 124.93 | 125.745 | 124.77 | 124.93 | 217124.0 |
| 2026-07-29 | ACWX | ETF | 73.74 | 74.48 | 72.875 | 73.17 | 1933336.0 |
| 2026-07-29 | ACYN | ETF | 20.62 | 20.63 | 20.51 | 20.51 | 2164081.0 |
| 2026-07-29 | ADBG | ETF | 4.31 | 4.8699 | 4.27 | 4.78 | 12161538.0 |
| 2026-07-29 | ADIV | ETF | 19.45 | 19.57 | 19.39 | 19.4002 | 34676.0 |
| 2026-07-29 | ADME | ETF | 55.0 | 55.0 | 54.1022 | 54.1022 | 10788.0 |
| 2026-07-29 | ADPV | ETF | 44.53 | 44.53 | 43.6858 | 43.6858 | 6380.0 |
| 2026-07-29 | ADVE | ETF | 44.77 | 44.77 | 44.4081 | 44.4081 | 888.0 |
| 2026-07-29 | AESR | ETF | 19.375 | 19.375 | 18.905 | 18.93 | 53300.0 |
| 2026-07-29 | AETH | ETF | 31.23 | 31.93 | 30.7747 | 30.7747 | 624.0 |
| 2026-07-29 | AFIF | ETF | 9.33 | 9.41 | 9.33 | 9.39 | 171204.0 |
| 2026-07-29 | AFIX | ETF | 24.45 | 24.48 | 24.3843 | 24.3843 | 11034.0 |
| 2026-07-29 | AFK | ETF | 25.52 | 25.92 | 25.3 | 25.7008 | 48736.0 |
| 2026-07-29 | AFLG | ETF | 43.75 | 44.04 | 43.32 | 43.33 | 56424.0 |
| 2026-07-29 | AFMC | ETF | 40.96 | 40.96 | 40.31 | 40.38 | 11853.0 |
| 2026-07-29 | AFSC | ETF | 37.2459 | 37.2459 | 37.2459 | 37.2459 | 21.0 |
| 2026-07-29 | AFSM | ETF | 39.659 | 39.71 | 39.44 | 39.4767 | 8141.0 |
> showing 50 of 4,193 rows — these rows as CSV