PREVIEW / etf_daily / 2026-07-06
file: by_date/etf_daily/2026/2026-07-06.parquet size: 157 KB rows: 4,166
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-06 | SPY | ETF | 748.74 | 752.41 | 747.41 | 751.28 | 50673310.0 |
| 2026-07-06 | QQQ | ETF | 719.93 | 726.08 | 718.45 | 722.82 | 30220428.0 |
| 2026-07-06 | IWM | ETF | 297.75 | 300.41 | 297.62 | 298.9 | 18581286.0 |
| 2026-07-06 | DIA | ETF | 528.72 | 530.09 | 525.85 | 530.09 | 3236864.0 |
| 2026-07-06 | GLD | ETF | 380.21 | 382.43 | 378.83 | 382.13 | 3906524.0 |
| 2026-07-06 | TLT | ETF | 85.43 | 85.48 | 85.18 | 85.45 | 17940936.0 |
| 2026-07-06 | AAA | ETF | 24.81 | 25.1 | 24.81 | 25.0368 | 43861.0 |
| 2026-07-06 | AAAU | ETF | 40.84 | 41.085 | 40.71 | 41.04 | 689606.0 |
| 2026-07-06 | AADR | ETF | 81.9 | 84.1672 | 81.9 | 84.1672 | 1374.0 |
| 2026-07-06 | AAPB | ETF | 38.27 | 39.82 | 38.23 | 39.56 | 79261.0 |
| 2026-07-06 | AAPD | ETF | 11.4 | 11.4 | 11.1387 | 11.18 | 5077984.0 |
| 2026-07-06 | AAPR | ETF | 29.57 | 29.57 | 29.55 | 29.555 | 1464.0 |
| 2026-07-06 | AAPU | ETF | 39.29 | 41.02 | 39.19 | 40.66 | 1092029.0 |
| 2026-07-06 | AAPW | ETF | 39.66 | 40.9 | 39.66 | 40.66 | 11138.0 |
| 2026-07-06 | AAPX | ETF | 35.46 | 37.08 | 35.46 | 36.78 | 23515.0 |
| 2026-07-06 | AAPY | ETF | 26.25 | 26.54 | 26.25 | 26.5 | 2217.0 |
| 2026-07-06 | AAVM | ETF | 33.85 | 33.9 | 33.85 | 33.889 | 830.0 |
| 2026-07-06 | AAXJ | ETF | 117.26 | 117.98 | 116.9 | 117.57 | 760465.0 |
| 2026-07-06 | ABCS | ETF | 34.045 | 34.12 | 34.045 | 34.0979 | 1956.0 |
| 2026-07-06 | ABEQ | ETF | 37.74 | 37.74 | 37.61 | 37.6642 | 12780.0 |
| 2026-07-06 | ABFL | ETF | 84.29 | 84.69 | 84.05 | 84.05 | 9965.0 |
| 2026-07-06 | ABLD | ETF | 30.25 | 30.3 | 30.1851 | 30.1851 | 9975.0 |
| 2026-07-06 | ABOT | ETF | 40.17 | 40.2063 | 40.17 | 40.2063 | 3334.0 |
| 2026-07-06 | ABXB | ETF | 19.24 | 19.331 | 19.24 | 19.331 | 6228.0 |
| 2026-07-06 | ACES | ETF | 34.19 | 35.18 | 34.19 | 34.96 | 425659.0 |
| 2026-07-06 | ACIO | ETF | 46.38 | 46.51 | 46.26 | 46.48 | 126769.0 |
| 2026-07-06 | ACLC | ETF | 84.44 | 84.6534 | 84.4102 | 84.6534 | 2817.0 |
| 2026-07-06 | ACSG | ETF | 50.07 | 50.07 | 49.7891 | 49.7891 | 2203.0 |
| 2026-07-06 | ACT | ETF | 45.33 | 45.74 | 45.295 | 45.69 | 199378.0 |
| 2026-07-06 | ACVF | ETF | 54.02 | 54.2 | 54.02 | 54.1224 | 3212.0 |
| 2026-07-06 | ACVT | ETF | 28.23 | 28.2746 | 28.23 | 28.2746 | 464.0 |
| 2026-07-06 | ACWI | ETF | 157.245 | 158.12 | 157.12 | 157.97 | 3335196.0 |
| 2026-07-06 | ACWV | ETF | 122.36 | 122.36 | 121.75 | 122.17 | 74265.0 |
| 2026-07-06 | ACWX | ETF | 75.95 | 76.47 | 75.95 | 76.43 | 1203776.0 |
| 2026-07-06 | ADBG | ETF | 3.3 | 3.42 | 3.2101 | 3.36 | 6421299.0 |
| 2026-07-06 | ADFI | ETF | 8.39 | 8.4999 | 8.39 | 8.4979 | 12691.0 |
| 2026-07-06 | ADIV | ETF | 18.9 | 18.9 | 18.8403 | 18.8671 | 2412.0 |
| 2026-07-06 | ADME | ETF | 55.74 | 55.96 | 55.716 | 55.8498 | 5573.0 |
| 2026-07-06 | ADPV | ETF | 46.19 | 46.53 | 46.06 | 46.06 | 9278.0 |
| 2026-07-06 | ADVE | ETF | 46.31 | 46.31 | 46.2697 | 46.2697 | 320.0 |
| 2026-07-06 | AESR | ETF | 20.02 | 20.46 | 20.02 | 20.38 | 37934.0 |
| 2026-07-06 | AETH | ETF | 29.2 | 29.2756 | 29.2 | 29.2756 | 468.0 |
| 2026-07-06 | AFIF | ETF | 9.36 | 9.45 | 9.36 | 9.42 | 121086.0 |
| 2026-07-06 | AFIX | ETF | 24.78 | 24.785 | 24.7698 | 24.785 | 1243.0 |
| 2026-07-06 | AFK | ETF | 26.31 | 26.51 | 26.31 | 26.51 | 14031.0 |
| 2026-07-06 | AFLG | ETF | 43.38 | 43.4 | 43.28 | 43.3323 | 32489.0 |
| 2026-07-06 | AFMC | ETF | 40.48 | 40.61 | 40.3868 | 40.46 | 30404.0 |
| 2026-07-06 | AFSC | ETF | 38.68 | 38.68 | 38.6271 | 38.6271 | 528.0 |
| 2026-07-06 | AFSM | ETF | 40.585 | 40.6399 | 40.37 | 40.3702 | 4806.0 |
| 2026-07-06 | AGEM | ETF | 49.24 | 49.4692 | 49.24 | 49.4226 | 3350.0 |
> showing 50 of 4,166 rows — these rows as CSV