PREVIEW / etf_daily / 2025-07-01
file: by_date/etf_daily/2025/2025-07-01.parquet size: 157 KB rows: 4,199
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-01 | SPY | ETF | 616.36 | 618.83 | 615.52 | 617.65 | 70054321.0 |
| 2025-07-01 | QQQ | ETF | 549.73 | 550.71 | 544.66 | 546.99 | 56166736.0 |
| 2025-07-01 | IWM | ETF | 214.62 | 220.525 | 214.1499 | 218.01 | 43876151.0 |
| 2025-07-01 | DIA | ETF | 440.19 | 445.9698 | 440.0 | 444.89 | 4524697.0 |
| 2025-07-01 | GLD | ETF | 308.555 | 309.0 | 307.36 | 307.55 | 9332777.0 |
| 2025-07-01 | TLT | ETF | 88.13 | 88.31 | 87.66 | 88.14 | 38956168.0 |
| 2025-07-01 | AAA | ETF | 24.96 | 25.01 | 24.85 | 24.935 | 18927.0 |
| 2025-07-01 | AAAU | ETF | 33.08 | 33.13 | 32.95 | 32.97 | 2871736.0 |
| 2025-07-01 | AADR | ETF | 78.31 | 78.44 | 77.44 | 77.73 | 6913.0 |
| 2025-07-01 | AAPB | ETF | 20.5 | 21.1004 | 20.365 | 20.67 | 554517.0 |
| 2025-07-01 | AAPD | ETF | 17.39 | 17.43 | 17.1047 | 17.32 | 957609.0 |
| 2025-07-01 | AAPR | ETF | 27.2101 | 27.28 | 27.2101 | 27.25 | 11290.0 |
| 2025-07-01 | AAPU | ETF | 22.26 | 23.0 | 22.16 | 22.48 | 10097170.0 |
| 2025-07-01 | AAPW | ETF | 36.22 | 36.7285 | 36.06 | 36.365 | 12949.0 |
| 2025-07-01 | AAPX | ETF | 19.19 | 19.88 | 19.15 | 19.46 | 311379.0 |
| 2025-07-01 | AAPY | ETF | 21.6595 | 21.86 | 21.6595 | 21.74 | 7949.0 |
| 2025-07-01 | AAVM | ETF | 27.18 | 27.18 | 26.98 | 26.98 | 2808.0 |
| 2025-07-01 | AAXJ | ETF | 82.72 | 82.98 | 82.59 | 82.79 | 417070.0 |
| 2025-07-01 | ABCS | ETF | 28.92 | 29.3601 | 28.92 | 29.2041 | 5546.0 |
| 2025-07-01 | ABEQ | ETF | 34.25 | 34.56 | 34.25 | 34.5553 | 14439.0 |
| 2025-07-01 | ABFL | ETF | 70.8 | 70.8 | 70.45 | 70.5565 | 11020.0 |
| 2025-07-01 | ABLD | ETF | 28.49 | 28.9 | 28.49 | 28.84 | 8437.0 |
| 2025-07-01 | ABLG | ETF | 30.8974 | 30.9281 | 30.8974 | 30.9281 | 819.0 |
| 2025-07-01 | ABNY | ETF | 58.2995 | 59.0 | 57.95 | 58.627 | 2891.0 |
| 2025-07-01 | ABOT | ETF | 38.66 | 38.66 | 38.4964 | 38.4964 | 210.0 |
| 2025-07-01 | ABXB | ETF | 19.58 | 19.58 | 19.58 | 19.58 | 21.0 |
| 2025-07-01 | ACES | ETF | 25.62 | 26.36 | 25.28 | 26.05 | 12857.0 |
| 2025-07-01 | ACGR | ETF | 59.36 | 59.43 | 59.3067 | 59.3067 | 1187.0 |
| 2025-07-01 | ACIO | ETF | 41.28 | 41.46 | 41.2454 | 41.38 | 211344.0 |
| 2025-07-01 | ACLC | ETF | 72.225 | 72.3207 | 72.121 | 72.2886 | 2326.0 |
| 2025-07-01 | ACSI | ETF | 63.6594 | 63.6594 | 63.6594 | 63.6594 | 93.0 |
| 2025-07-01 | ACT | ETF | 37.0 | 37.95 | 36.965 | 37.67 | 568387.0 |
| 2025-07-01 | ACTV | ETF | 31.51 | 31.84 | 31.51 | 31.778 | 2946.0 |
| 2025-07-01 | ACVF | ETF | 47.12 | 47.28 | 46.991 | 47.1996 | 3628.0 |
| 2025-07-01 | ACVT | ETF | 26.06 | 26.12 | 26.06 | 26.0812 | 2400.0 |
| 2025-07-01 | ACWI | ETF | 128.19 | 128.71 | 128.09 | 128.53 | 3795485.0 |
| 2025-07-01 | ACWV | ETF | 118.43 | 119.2119 | 118.43 | 118.95 | 91065.0 |
| 2025-07-01 | ACWX | ETF | 60.89 | 61.015 | 60.77 | 60.93 | 576355.0 |
| 2025-07-01 | ADBG | ETF | 13.6 | 14.23 | 13.44 | 14.23 | 37789.0 |
| 2025-07-01 | ADFI | ETF | 8.52 | 8.54 | 8.515 | 8.5255 | 11096.0 |
| 2025-07-01 | ADIV | ETF | 17.67 | 17.67 | 17.6 | 17.6326 | 7776.0 |
| 2025-07-01 | ADME | ETF | 48.235 | 48.235 | 47.97 | 48.0705 | 12009.0 |
| 2025-07-01 | ADPV | ETF | 36.85 | 37.04 | 36.27 | 36.35 | 19298.0 |
| 2025-07-01 | ADVE | ETF | 35.8277 | 35.8277 | 35.8277 | 35.8277 | 35.0 |
| 2025-07-01 | AESR | ETF | 19.04 | 19.04 | 18.94 | 18.9632 | 15534.0 |
| 2025-07-01 | AETH | ETF | 35.65 | 35.65 | 35.65 | 35.65 | 679.0 |
| 2025-07-01 | AFIF | ETF | 9.31 | 9.34 | 9.31 | 9.3189 | 11370.0 |
| 2025-07-01 | AFIX | ETF | 25.01 | 25.01 | 24.9492 | 24.986 | 1926.0 |
| 2025-07-01 | AFK | ETF | 20.21 | 20.4999 | 20.21 | 20.425 | 22965.0 |
| 2025-07-01 | AFLG | ETF | 36.19 | 36.44 | 36.19 | 36.35 | 36391.0 |
> showing 50 of 4,199 rows — these rows as CSV