PREVIEW / etf_daily / 2026-08-27
file: by_date/etf_daily/2026/2026-08-27.parquet size: 156 KB rows: 4,117
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-08-27 | SPY | ETF | 768.5 | 772.355 | 767.16 | 771.1 | 34557064.0 |
| 2026-08-27 | QQQ | ETF | 716.93 | 721.35 | 714.525 | 721.11 | 28723451.0 |
| 2026-08-27 | IWM | ETF | 298.77 | 300.315 | 298.14 | 299.81 | 13668343.0 |
| 2026-08-27 | DIA | ETF | 533.56 | 536.63 | 532.92 | 535.22 | 2508817.0 |
| 2026-08-27 | GLD | ETF | 420.815 | 423.35 | 418.43 | 422.6 | 7088987.0 |
| 2026-08-27 | TLT | ETF | 83.2 | 83.35 | 83.0 | 83.13 | 17361883.0 |
| 2026-08-27 | AAA | ETF | 24.95 | 24.96 | 24.93 | 24.9385 | 3943.0 |
| 2026-08-27 | AAAU | ETF | 45.24 | 45.5 | 44.98 | 45.43 | 965981.0 |
| 2026-08-27 | AADR | ETF | 84.14 | 84.1595 | 84.0201 | 84.1595 | 2363.0 |
| 2026-08-27 | AAOG | ETF | 3.0 | 3.1 | 2.72 | 2.82 | 2635340.0 |
| 2026-08-27 | AAOX | ETF | 13.58 | 13.94 | 12.2201 | 12.66 | 6401434.0 |
| 2026-08-27 | AAPB | ETF | 38.03 | 39.3 | 38.03 | 39.1756 | 12200.0 |
| 2026-08-27 | AAPD | ETF | 11.2 | 11.25 | 11.045 | 11.07 | 5764324.0 |
| 2026-08-27 | AAPR | ETF | 29.805 | 29.805 | 29.7701 | 29.79 | 1448.0 |
| 2026-08-27 | AAPU | ETF | 39.12 | 40.32 | 38.8116 | 40.1 | 923835.0 |
| 2026-08-27 | AAPW | ETF | 38.77 | 39.4144 | 38.64 | 39.3115 | 7522.0 |
| 2026-08-27 | AAPX | ETF | 35.51 | 36.35 | 35.08 | 36.28 | 72668.0 |
| 2026-08-27 | AAPY | ETF | 25.94 | 26.23 | 25.825 | 26.1757 | 3318.0 |
| 2026-08-27 | AAVM | ETF | 34.8098 | 34.8098 | 34.8098 | 34.8098 | 97.0 |
| 2026-08-27 | AAXJ | ETF | 117.43 | 117.595 | 116.76 | 117.49 | 354363.0 |
| 2026-08-27 | ABCS | ETF | 36.19 | 36.219 | 36.19 | 36.193 | 2281.0 |
| 2026-08-27 | ABEQ | ETF | 39.17 | 39.27 | 39.07 | 39.1901 | 21246.0 |
| 2026-08-27 | ABFL | ETF | 83.36 | 83.4 | 83.01 | 83.34 | 10618.0 |
| 2026-08-27 | ABLD | ETF | 32.89 | 33.13 | 32.86 | 33.08 | 21731.0 |
| 2026-08-27 | ABLG | ETF | 31.88 | 31.8916 | 31.88 | 31.8916 | 213.0 |
| 2026-08-27 | ACES | ETF | 30.8873 | 31.06 | 30.76 | 31.04 | 10756.0 |
| 2026-08-27 | ACIO | ETF | 47.22 | 47.22 | 46.985 | 47.14 | 217486.0 |
| 2026-08-27 | ACLC | ETF | 86.435 | 86.7358 | 86.435 | 86.7358 | 4654.0 |
| 2026-08-27 | ACSG | ETF | 49.71 | 49.87 | 49.7 | 49.87 | 367770.0 |
| 2026-08-27 | ACVF | ETF | 55.9 | 56.0962 | 55.89 | 56.0185 | 4925.0 |
| 2026-08-27 | ACVT | ETF | 28.87 | 28.87 | 28.825 | 28.825 | 177180.0 |
| 2026-08-27 | ACWI | ETF | 161.44 | 161.79 | 160.94 | 161.53 | 2863134.0 |
| 2026-08-27 | ACWV | ETF | 127.28 | 127.615 | 126.97 | 127.48 | 75839.0 |
| 2026-08-27 | ACWX | ETF | 78.035 | 78.07 | 77.66 | 77.96 | 1920941.0 |
| 2026-08-27 | ACYN | ETF | 20.78 | 20.83 | 20.77 | 20.81 | 2019955.0 |
| 2026-08-27 | ADBG | ETF | 5.2 | 5.66 | 5.2 | 5.58 | 3402803.0 |
| 2026-08-27 | ADIV | ETF | 20.015 | 20.0257 | 20.015 | 20.0257 | 700.0 |
| 2026-08-27 | ADME | ETF | 56.405 | 56.73 | 56.405 | 56.617 | 7990.0 |
| 2026-08-27 | ADPV | ETF | 45.27 | 45.4 | 45.12 | 45.3344 | 4854.0 |
| 2026-08-27 | AESR | ETF | 20.04 | 20.18 | 20.04 | 20.13 | 31811.0 |
| 2026-08-27 | AETH | ETF | 38.76 | 38.8899 | 38.6601 | 38.8899 | 3827.0 |
| 2026-08-27 | AFIF | ETF | 9.4 | 9.415 | 9.39 | 9.41 | 102307.0 |
| 2026-08-27 | AFIX | ETF | 24.47 | 24.49 | 24.45 | 24.4506 | 20011.0 |
| 2026-08-27 | AFK | ETF | 29.7364 | 29.7364 | 29.225 | 29.6 | 40654.0 |
| 2026-08-27 | AFLG | ETF | 44.88 | 45.14 | 44.865 | 45.07 | 54033.0 |
| 2026-08-27 | AFMC | ETF | 41.52 | 41.52 | 41.11 | 41.29 | 29210.0 |
| 2026-08-27 | AFSC | ETF | 38.36 | 38.57 | 38.36 | 38.515 | 1006.0 |
| 2026-08-27 | AFSM | ETF | 40.86 | 40.87 | 40.61 | 40.8217 | 33244.0 |
| 2026-08-27 | AGEM | ETF | 49.45 | 49.55 | 49.2 | 49.4566 | 8610.0 |
| 2026-08-27 | AGG | ETF | 97.86 | 97.9199 | 97.7445 | 97.83 | 6002650.0 |
> showing 50 of 4,117 rows — these rows as CSV