PREVIEW / etf_daily / 2025-08-07
file: by_date/etf_daily/2025/2025-08-07.parquet size: 162 KB rows: 4,233
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-08-07 | SPY | ETF | 636.24 | 636.98 | 629.11 | 632.25 | 74593022.0 |
| 2025-08-07 | QQQ | ETF | 571.67 | 573.32 | 565.11 | 569.24 | 44462972.0 |
| 2025-08-07 | IWM | ETF | 222.76 | 222.84 | 218.505 | 219.84 | 37067689.0 |
| 2025-08-07 | DIA | ETF | 444.27 | 445.01 | 437.98 | 439.72 | 5213773.0 |
| 2025-08-07 | GLD | ETF | 311.72 | 313.135 | 310.7 | 313.12 | 10849928.0 |
| 2025-08-07 | TLT | ETF | 87.915 | 88.25 | 87.59 | 87.67 | 29211525.0 |
| 2025-08-07 | AAA | ETF | 25.03 | 25.03 | 24.88 | 24.9696 | 5055.0 |
| 2025-08-07 | AAAU | ETF | 33.42 | 33.58 | 33.32 | 33.58 | 2209741.0 |
| 2025-08-07 | AADR | ETF | 80.91 | 81.31 | 80.8267 | 80.8267 | 1374.0 |
| 2025-08-07 | AAPB | ETF | 22.62 | 23.0 | 22.2 | 22.85 | 996071.0 |
| 2025-08-07 | AAPD | ETF | 16.44 | 16.6345 | 16.3063 | 16.36 | 1822673.0 |
| 2025-08-07 | AAPR | ETF | 27.52 | 27.5255 | 27.46 | 27.4961 | 10753.0 |
| 2025-08-07 | AAPU | ETF | 24.63 | 25.005 | 24.08 | 24.84 | 8917446.0 |
| 2025-08-07 | AAPW | ETF | 36.42 | 36.72 | 36.013 | 36.67 | 111612.0 |
| 2025-08-07 | AAPX | ETF | 21.22 | 21.57 | 20.8 | 21.46 | 475180.0 |
| 2025-08-07 | AAPY | ETF | 22.49 | 22.66 | 22.47 | 22.611 | 2690.0 |
| 2025-08-07 | AAVM | ETF | 27.36 | 27.36 | 27.06 | 27.15 | 2865.0 |
| 2025-08-07 | AAXJ | ETF | 85.33 | 85.47 | 84.85 | 85.04 | 366766.0 |
| 2025-08-07 | ABCS | ETF | 28.88 | 28.88 | 28.6772 | 28.6772 | 2065.0 |
| 2025-08-07 | ABEQ | ETF | 34.64 | 34.65 | 34.335 | 34.44 | 21822.0 |
| 2025-08-07 | ABFL | ETF | 69.17 | 69.17 | 68.0826 | 68.57 | 15987.0 |
| 2025-08-07 | ABLD | ETF | 28.4208 | 28.4208 | 28.37 | 28.3841 | 1588.0 |
| 2025-08-07 | ABLG | ETF | 29.4 | 29.4514 | 29.4 | 29.4514 | 5052.0 |
| 2025-08-07 | ABNY | ETF | 52.15 | 52.35 | 50.05 | 51.045 | 11140.0 |
| 2025-08-07 | ABOT | ETF | 38.1039 | 38.1039 | 38.1039 | 38.1039 | 4.0 |
| 2025-08-07 | ABXB | ETF | 19.6333 | 19.6333 | 19.6333 | 19.6333 | 34.0 |
| 2025-08-07 | ACES | ETF | 26.91 | 27.2418 | 26.73 | 26.83 | 33051.0 |
| 2025-08-07 | ACGR | ETF | 62.3 | 62.3 | 61.7325 | 61.7325 | 204.0 |
| 2025-08-07 | ACIO | ETF | 42.025 | 42.075 | 41.66 | 41.83 | 98523.0 |
| 2025-08-07 | ACLC | ETF | 73.7963 | 73.7963 | 73.17 | 73.3558 | 3790.0 |
| 2025-08-07 | ACSI | ETF | 64.1834 | 64.1834 | 64.1834 | 64.1834 | 127.0 |
| 2025-08-07 | ACTV | ETF | 32.19 | 32.2206 | 32.19 | 32.2206 | 630.0 |
| 2025-08-07 | ACVF | ETF | 48.13 | 48.13 | 47.61 | 47.6148 | 1560.0 |
| 2025-08-07 | ACWI | ETF | 131.7 | 131.83 | 130.455 | 131.09 | 2776128.0 |
| 2025-08-07 | ACWV | ETF | 118.35 | 118.4 | 117.52 | 118.03 | 72908.0 |
| 2025-08-07 | ACWX | ETF | 61.96 | 61.96 | 61.5046 | 61.77 | 913791.0 |
| 2025-08-07 | ADBG | ETF | 10.73 | 10.899 | 10.007 | 10.3456 | 191956.0 |
| 2025-08-07 | ADFI | ETF | 8.55 | 8.59 | 8.53 | 8.59 | 14373.0 |
| 2025-08-07 | ADIV | ETF | 18.41 | 18.41 | 18.08 | 18.11 | 22760.0 |
| 2025-08-07 | ADME | ETF | 49.07 | 49.07 | 48.67 | 48.92 | 9727.0 |
| 2025-08-07 | ADPV | ETF | 40.8 | 40.8 | 40.08 | 40.4011 | 19567.0 |
| 2025-08-07 | ADVE | ETF | 36.5993 | 36.5993 | 36.5993 | 36.5993 | 34.0 |
| 2025-08-07 | AESR | ETF | 19.42 | 19.42 | 19.17 | 19.3 | 9757.0 |
| 2025-08-07 | AETH | ETF | 50.0 | 50.09 | 49.8001 | 49.96 | 3657.0 |
| 2025-08-07 | AFIF | ETF | 9.37 | 9.37 | 9.35 | 9.367 | 34272.0 |
| 2025-08-07 | AFIX | ETF | 25.11 | 25.11 | 25.06 | 25.07 | 1926.0 |
| 2025-08-07 | AFK | ETF | 21.6 | 21.9 | 21.6 | 21.709 | 11967.0 |
| 2025-08-07 | AFLG | ETF | 37.19 | 37.19 | 36.825 | 36.97 | 44405.0 |
| 2025-08-07 | AFMC | ETF | 32.1901 | 32.2399 | 31.9501 | 32.0576 | 57139.0 |
| 2025-08-07 | AFSC | ETF | 28.26 | 28.26 | 28.09 | 28.0999 | 2603.0 |
> showing 50 of 4,233 rows — these rows as CSV