PREVIEW / etf_daily / 2025-07-14
file: by_date/etf_daily/2025/2025-07-14.parquet size: 158 KB rows: 4,191
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 |
|---|---|---|---|---|---|---|---|
| 2025-07-14 | SPY | ETF | 623.16 | 625.1581 | 621.7999 | 624.81 | 51885493.0 |
| 2025-07-14 | QQQ | ETF | 553.99 | 556.945 | 551.63 | 556.21 | 36453314.0 |
| 2025-07-14 | IWM | ETF | 221.37 | 223.335 | 221.06 | 223.19 | 24627383.0 |
| 2025-07-14 | DIA | ETF | 443.11 | 444.76 | 442.475 | 444.58 | 2242360.0 |
| 2025-07-14 | GLD | ETF | 309.07 | 309.38 | 307.73 | 308.01 | 5771461.0 |
| 2025-07-14 | TLT | ETF | 85.54 | 85.88 | 85.315 | 85.61 | 24608105.0 |
| 2025-07-14 | AAA | ETF | 24.99 | 24.99 | 24.92 | 24.975 | 9904.0 |
| 2025-07-14 | AAAU | ETF | 33.15 | 33.1751 | 33.0 | 33.02 | 2307597.0 |
| 2025-07-14 | AADR | ETF | 78.24 | 78.79 | 78.11 | 78.11 | 3064.0 |
| 2025-07-14 | AAPB | ETF | 21.0 | 21.161 | 20.525 | 20.73 | 236891.0 |
| 2025-07-14 | AAPD | ETF | 17.15 | 17.35 | 17.09 | 17.27 | 841857.0 |
| 2025-07-14 | AAPR | ETF | 27.32 | 27.335 | 27.32 | 27.335 | 231.0 |
| 2025-07-14 | AAPU | ETF | 22.84 | 23.07 | 22.3301 | 22.56 | 5565976.0 |
| 2025-07-14 | AAPW | ETF | 35.66 | 35.99 | 35.32 | 35.53 | 57691.0 |
| 2025-07-14 | AAPX | ETF | 19.76 | 19.92 | 19.3 | 19.47 | 144634.0 |
| 2025-07-14 | AAPY | ETF | 22.02 | 22.02 | 21.68 | 21.8448 | 8865.0 |
| 2025-07-14 | AAVM | ETF | 26.68 | 26.82 | 26.68 | 26.82 | 556.0 |
| 2025-07-14 | AAXJ | ETF | 82.83 | 82.98 | 82.665 | 82.95 | 183131.0 |
| 2025-07-14 | ABCS | ETF | 29.18 | 29.26 | 29.1735 | 29.235 | 1844.0 |
| 2025-07-14 | ABEQ | ETF | 34.18 | 34.29 | 34.18 | 34.29 | 10320.0 |
| 2025-07-14 | ABFL | ETF | 69.2875 | 69.74 | 69.2875 | 69.66 | 11115.0 |
| 2025-07-14 | ABLD | ETF | 29.04 | 29.1 | 28.97 | 29.0604 | 4204.0 |
| 2025-07-14 | ABLG | ETF | 30.5099 | 30.5099 | 30.5099 | 30.5099 | 18.0 |
| 2025-07-14 | ABNY | ETF | 58.9 | 60.0 | 58.9 | 60.0 | 1499.0 |
| 2025-07-14 | ABOT | ETF | 38.22 | 38.28 | 38.2094 | 38.2094 | 990.0 |
| 2025-07-14 | ABXB | ETF | 19.4745 | 19.4745 | 19.4731 | 19.4731 | 173.0 |
| 2025-07-14 | ACES | ETF | 27.24 | 27.45 | 27.11 | 27.33 | 12113.0 |
| 2025-07-14 | ACGR | ETF | 60.1862 | 60.1862 | 60.1862 | 60.1862 | 11.0 |
| 2025-07-14 | ACIO | ETF | 41.45 | 41.63 | 41.38 | 41.58 | 226202.0 |
| 2025-07-14 | ACLC | ETF | 72.56 | 72.85 | 72.56 | 72.85 | 3675.0 |
| 2025-07-14 | ACSI | ETF | 63.4577 | 63.4577 | 63.4577 | 63.4577 | 94.0 |
| 2025-07-14 | ACTV | ETF | 31.94 | 32.02 | 31.85 | 32.0033 | 2169.0 |
| 2025-07-14 | ACVF | ETF | 47.41 | 47.52 | 47.4099 | 47.4964 | 3773.0 |
| 2025-07-14 | ACVT | ETF | 26.245 | 26.245 | 26.235 | 26.2368 | 951.0 |
| 2025-07-14 | ACWI | ETF | 129.1 | 129.475 | 128.89 | 129.38 | 3144379.0 |
| 2025-07-14 | ACWV | ETF | 117.13 | 117.675 | 117.02 | 117.64 | 134667.0 |
| 2025-07-14 | ACWX | ETF | 60.76 | 60.8863 | 60.56 | 60.85 | 541724.0 |
| 2025-07-14 | ADBG | ETF | 12.02 | 12.3899 | 11.9696 | 12.36 | 45859.0 |
| 2025-07-14 | ADFI | ETF | 8.57 | 8.57 | 8.38 | 8.4647 | 24991.0 |
| 2025-07-14 | ADIV | ETF | 17.69 | 17.86 | 17.69 | 17.79 | 2159.0 |
| 2025-07-14 | ADME | ETF | 48.21 | 48.3984 | 48.21 | 48.3564 | 11330.0 |
| 2025-07-14 | ADPV | ETF | 38.2615 | 38.85 | 38.2615 | 38.8482 | 12875.0 |
| 2025-07-14 | ADVE | ETF | 35.777 | 35.777 | 35.777 | 35.777 | 4.0 |
| 2025-07-14 | AESR | ETF | 19.01 | 19.22 | 19.01 | 19.2111 | 28080.0 |
| 2025-07-14 | AETH | ETF | 41.63 | 41.78 | 40.97 | 41.0008 | 3704.0 |
| 2025-07-14 | AFIF | ETF | 9.31 | 9.32 | 9.3 | 9.31 | 14540.0 |
| 2025-07-14 | AFIX | ETF | 24.8 | 24.8 | 24.767 | 24.795 | 1522.0 |
| 2025-07-14 | AFK | ETF | 20.62 | 20.87 | 20.52 | 20.7303 | 29843.0 |
| 2025-07-14 | AFLG | ETF | 36.44 | 36.515 | 36.34 | 36.5 | 63470.0 |
| 2025-07-14 | AFMC | ETF | 32.42 | 32.539 | 32.33 | 32.526 | 10431.0 |
> showing 50 of 4,191 rows — these rows as CSV