PREVIEW / etf_daily / 2026-07-24
file: by_date/etf_daily/2026/2026-07-24.parquet size: 158 KB rows: 4,138
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-24 | SPY | ETF | 738.51 | 743.72 | 737.29 | 738.93 | 44781983.0 |
| 2026-07-24 | QQQ | ETF | 690.41 | 692.63 | 682.48 | 684.23 | 42876658.0 |
| 2026-07-24 | IWM | ETF | 293.41 | 293.97 | 290.48 | 291.17 | 19771042.0 |
| 2026-07-24 | DIA | ETF | 517.28 | 520.5599 | 516.27 | 518.76 | 3328437.0 |
| 2026-07-24 | GLD | ETF | 371.26 | 374.49 | 371.03 | 371.9 | 3852356.0 |
| 2026-07-24 | TLT | ETF | 83.31 | 83.655 | 83.225 | 83.25 | 15105997.0 |
| 2026-07-24 | AAA | ETF | 24.88 | 25.05 | 24.88 | 25.04 | 8821.0 |
| 2026-07-24 | AAAU | ETF | 39.88 | 40.235 | 39.88 | 39.96 | 951323.0 |
| 2026-07-24 | AADR | ETF | 82.58 | 82.58 | 82.58 | 82.58 | 123.0 |
| 2026-07-24 | AAOG | ETF | 3.4 | 3.4136 | 2.75 | 2.8116 | 1393877.0 |
| 2026-07-24 | AAOX | ETF | 15.065 | 15.2741 | 12.3501 | 12.5 | 4812589.0 |
| 2026-07-24 | AAPB | ETF | 41.7 | 44.765 | 41.65 | 44.45 | 62439.0 |
| 2026-07-24 | AAPD | ETF | 10.86 | 10.87 | 10.45 | 10.49 | 10461281.0 |
| 2026-07-24 | AAPR | ETF | 29.5 | 29.5 | 29.435 | 29.435 | 4448.0 |
| 2026-07-24 | AAPU | ETF | 42.74 | 46.08 | 42.69 | 45.71 | 1490691.0 |
| 2026-07-24 | AAPW | ETF | 41.4 | 43.415 | 41.4 | 43.3 | 18810.0 |
| 2026-07-24 | AAPX | ETF | 38.69 | 41.55 | 38.69 | 41.25 | 36560.0 |
| 2026-07-24 | AAPY | ETF | 27.84 | 28.1301 | 27.84 | 28.1301 | 3471.0 |
| 2026-07-24 | AAVM | ETF | 33.515 | 33.515 | 33.4061 | 33.4061 | 275.0 |
| 2026-07-24 | AAXJ | ETF | 111.01 | 111.27 | 109.73 | 109.86 | 396484.0 |
| 2026-07-24 | ABCS | ETF | 34.46 | 34.6628 | 34.46 | 34.6628 | 2007.0 |
| 2026-07-24 | ABEQ | ETF | 37.79 | 38.13 | 37.79 | 38.1184 | 5966.0 |
| 2026-07-24 | ABFL | ETF | 83.17 | 83.3799 | 82.52 | 82.6124 | 11134.0 |
| 2026-07-24 | ABLD | ETF | 30.99 | 30.99 | 30.87 | 30.8793 | 9018.0 |
| 2026-07-24 | ABLG | ETF | 30.59 | 30.5958 | 30.59 | 30.5958 | 328.0 |
| 2026-07-24 | ABOT | ETF | 39.54 | 39.54 | 39.4441 | 39.4441 | 724.0 |
| 2026-07-24 | ABXB | ETF | 18.99 | 19.065 | 18.99 | 19.065 | 152.0 |
| 2026-07-24 | ACES | ETF | 31.41 | 31.44 | 30.48 | 30.56 | 138022.0 |
| 2026-07-24 | ACGR | ETF | 66.15 | 66.18 | 65.7977 | 65.7977 | 2373.0 |
| 2026-07-24 | ACIO | ETF | 45.64 | 45.96 | 45.64 | 45.72 | 202194.0 |
| 2026-07-24 | ACLC | ETF | 82.56 | 82.7054 | 82.56 | 82.7054 | 2377.0 |
| 2026-07-24 | ACSG | ETF | 48.03 | 48.2 | 47.7335 | 47.7335 | 971.0 |
| 2026-07-24 | ACSI | ETF | 74.68 | 75.6361 | 74.68 | 75.6361 | 127.0 |
| 2026-07-24 | ACVF | ETF | 53.36 | 53.4801 | 53.215 | 53.3009 | 3732.0 |
| 2026-07-24 | ACWI | ETF | 154.26 | 155.375 | 154.02 | 154.3 | 2232378.0 |
| 2026-07-24 | ACWV | ETF | 121.42 | 122.36 | 121.42 | 122.19 | 63817.0 |
| 2026-07-24 | ACWX | ETF | 74.43 | 74.68 | 73.995 | 74.1 | 1381316.0 |
| 2026-07-24 | ACYN | ETF | 20.61 | 20.61 | 20.5215 | 20.54 | 2046985.0 |
| 2026-07-24 | ADBG | ETF | 3.275 | 3.57 | 3.27 | 3.52 | 4823448.0 |
| 2026-07-24 | ADIV | ETF | 19.21 | 19.2394 | 19.205 | 19.205 | 3211.0 |
| 2026-07-24 | ADME | ETF | 54.95 | 55.21 | 54.76 | 54.84 | 8668.0 |
| 2026-07-24 | ADPV | ETF | 46.5 | 46.53 | 45.73 | 45.8 | 17500.0 |
| 2026-07-24 | ADVE | ETF | 45.32 | 45.3221 | 45.32 | 45.3221 | 594.0 |
| 2026-07-24 | AESR | ETF | 19.67 | 19.775 | 19.53 | 19.55 | 9565.0 |
| 2026-07-24 | AFIF | ETF | 9.37 | 9.375 | 9.35 | 9.365 | 28625.0 |
| 2026-07-24 | AFIX | ETF | 24.41 | 24.41 | 24.385 | 24.385 | 964.0 |
| 2026-07-24 | AFK | ETF | 25.5 | 25.74 | 25.0 | 25.66 | 417224.0 |
| 2026-07-24 | AFLG | ETF | 43.31 | 43.69 | 43.31 | 43.46 | 100053.0 |
| 2026-07-24 | AFMC | ETF | 40.39 | 40.76 | 40.3801 | 40.54 | 23003.0 |
| 2026-07-24 | AFSC | ETF | 37.67 | 37.6701 | 37.5271 | 37.5271 | 394.0 |
> showing 50 of 4,138 rows — these rows as CSV