PREVIEW / etf_daily / 2026-07-14
file: by_date/etf_daily/2026/2026-07-14.parquet size: 157 KB rows: 4,154
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-14 | SPY | ETF | 750.91 | 753.34 | 748.66 | 751.83 | 35143138.0 |
| 2026-07-14 | QQQ | ETF | 720.22 | 722.29 | 714.34 | 719.69 | 29448117.0 |
| 2026-07-14 | IWM | ETF | 295.49 | 296.065 | 293.75 | 294.51 | 18326926.0 |
| 2026-07-14 | DIA | ETF | 523.32 | 526.72 | 522.56 | 524.69 | 3664023.0 |
| 2026-07-14 | GLD | ETF | 374.53 | 376.28 | 370.92 | 372.15 | 6303383.0 |
| 2026-07-14 | TLT | ETF | 84.18 | 84.5 | 84.035 | 84.08 | 23793453.0 |
| 2026-07-14 | AAA | ETF | 24.9302 | 24.975 | 24.9302 | 24.965 | 1211.0 |
| 2026-07-14 | AAAU | ETF | 40.24 | 40.42 | 39.86 | 39.99 | 1242075.0 |
| 2026-07-14 | AADR | ETF | 83.21 | 83.64 | 83.21 | 83.3978 | 707.0 |
| 2026-07-14 | AAOG | ETF | 4.39 | 4.92 | 4.22 | 4.76 | 1557503.0 |
| 2026-07-14 | AAOX | ETF | 19.31 | 22.14 | 18.9 | 21.26 | 5587262.0 |
| 2026-07-14 | AAPB | ETF | 39.55 | 40.35 | 39.26 | 40.0492 | 30040.0 |
| 2026-07-14 | AAPD | ETF | 11.14 | 11.22 | 11.075 | 11.12 | 11115204.0 |
| 2026-07-14 | AAPR | ETF | 29.5799 | 29.5799 | 29.5549 | 29.5549 | 5176.0 |
| 2026-07-14 | AAPU | ETF | 40.835 | 41.461 | 40.37 | 41.15 | 1104871.0 |
| 2026-07-14 | AAPW | ETF | 40.515 | 40.97 | 40.29 | 40.759 | 10278.0 |
| 2026-07-14 | AAPX | ETF | 36.8 | 37.44 | 36.25 | 37.195 | 21365.0 |
| 2026-07-14 | AAPY | ETF | 26.62 | 26.6967 | 26.5499 | 26.6967 | 1194.0 |
| 2026-07-14 | AAVM | ETF | 33.73 | 33.7311 | 33.6643 | 33.6643 | 1109.0 |
| 2026-07-14 | AAXJ | ETF | 113.75 | 114.235 | 112.95 | 113.94 | 530590.0 |
| 2026-07-14 | ABCS | ETF | 34.25 | 34.26 | 34.1357 | 34.1357 | 3458.0 |
| 2026-07-14 | ABEQ | ETF | 37.42 | 37.42 | 37.1801 | 37.2056 | 2770.0 |
| 2026-07-14 | ABFL | ETF | 83.62 | 83.62 | 83.365 | 83.5 | 7928.0 |
| 2026-07-14 | ABLD | ETF | 30.325 | 30.38 | 30.2 | 30.3076 | 6971.0 |
| 2026-07-14 | ACES | ETF | 33.21 | 33.56 | 32.84 | 33.19 | 13803.0 |
| 2026-07-14 | ACIO | ETF | 46.58 | 46.58 | 46.31 | 46.5 | 144480.0 |
| 2026-07-14 | ACLC | ETF | 84.575 | 84.775 | 84.44 | 84.5756 | 1585.0 |
| 2026-07-14 | ACSG | ETF | 49.2 | 49.2 | 49.02 | 49.1437 | 2554.0 |
| 2026-07-14 | ACSI | ETF | 76.45 | 76.518 | 76.37 | 76.518 | 1355.0 |
| 2026-07-14 | ACVF | ETF | 54.21 | 54.25 | 54.12 | 54.1259 | 3940.0 |
| 2026-07-14 | ACWI | ETF | 156.75 | 157.4 | 156.46 | 156.94 | 1987353.0 |
| 2026-07-14 | ACWV | ETF | 122.13 | 122.29 | 121.69 | 121.74 | 53731.0 |
| 2026-07-14 | ACWX | ETF | 75.33 | 75.54 | 75.085 | 75.15 | 807660.0 |
| 2026-07-14 | ACYN | ETF | 20.53 | 20.6899 | 20.53 | 20.66 | 2068138.0 |
| 2026-07-14 | ADBG | ETF | 3.45 | 3.55 | 3.36 | 3.43 | 7970019.0 |
| 2026-07-14 | ADFI | ETF | 8.41 | 8.43 | 8.3806 | 8.415 | 8392.0 |
| 2026-07-14 | ADIV | ETF | 19.01 | 19.06 | 18.95 | 18.99 | 2162.0 |
| 2026-07-14 | ADME | ETF | 55.73 | 55.89 | 55.73 | 55.8285 | 6045.0 |
| 2026-07-14 | ADPV | ETF | 46.16 | 46.29 | 45.8787 | 46.0918 | 5205.0 |
| 2026-07-14 | ADVE | ETF | 45.98 | 45.98 | 45.7984 | 45.7984 | 192.0 |
| 2026-07-14 | AESR | ETF | 20.18 | 20.25 | 20.1199 | 20.1675 | 18350.0 |
| 2026-07-14 | AETH | ETF | 30.65 | 30.6506 | 30.57 | 30.6506 | 429.0 |
| 2026-07-14 | AFIF | ETF | 9.38 | 9.44 | 9.38 | 9.41 | 427203.0 |
| 2026-07-14 | AFIX | ETF | 24.605 | 24.66 | 24.605 | 24.625 | 814361.0 |
| 2026-07-14 | AFK | ETF | 25.74 | 26.11 | 25.7 | 25.89 | 24469.0 |
| 2026-07-14 | AFLG | ETF | 43.74 | 43.77 | 43.5774 | 43.74 | 81304.0 |
| 2026-07-14 | AFMC | ETF | 40.5 | 40.5 | 40.17 | 40.3084 | 14660.0 |
| 2026-07-14 | AFSC | ETF | 37.9851 | 37.9851 | 37.9851 | 37.9851 | 164.0 |
| 2026-07-14 | AFSM | ETF | 40.1137 | 40.255 | 39.988 | 40.08 | 4653.0 |
| 2026-07-14 | AGEM | ETF | 47.68 | 47.73 | 47.59 | 47.7123 | 10052.0 |
> showing 50 of 4,154 rows — these rows as CSV