PREVIEW / etf_daily / 2025-12-31
file: by_date/etf_daily/2025/2025-12-31.parquet size: 166 KB rows: 4,382
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-12-31 | SPY | ETF | 687.14 | 687.36 | 681.71 | 681.92 | 74282667.0 |
| 2025-12-31 | QQQ | ETF | 619.65 | 619.96 | 614.05 | 614.31 | 40746527.0 |
| 2025-12-31 | IWM | ETF | 248.18 | 248.28 | 246.01 | 246.16 | 35416168.0 |
| 2025-12-31 | DIA | ETF | 483.65 | 483.81 | 480.36 | 480.57 | 3441183.0 |
| 2025-12-31 | GLD | ETF | 398.6 | 400.13 | 395.59 | 396.31 | 10192443.0 |
| 2025-12-31 | TLT | ETF | 87.68 | 87.91 | 87.13 | 87.16 | 36496787.0 |
| 2025-12-31 | AAA | ETF | 24.95 | 25.02 | 24.92 | 25.0 | 23815.0 |
| 2025-12-31 | AAAU | ETF | 42.78 | 42.95 | 42.455 | 42.55 | 1604883.0 |
| 2025-12-31 | AADR | ETF | 86.576 | 86.93 | 86.255 | 86.255 | 1387.0 |
| 2025-12-31 | AAPB | ETF | 32.25 | 32.34 | 32.0 | 32.0648 | 36309.0 |
| 2025-12-31 | AAPD | ETF | 13.04 | 13.1121 | 13.03 | 13.11 | 398043.0 |
| 2025-12-31 | AAPR | ETF | 28.3901 | 28.4143 | 28.3901 | 28.4143 | 383.0 |
| 2025-12-31 | AAPU | ETF | 33.84 | 34.015 | 33.57 | 33.58 | 451367.0 |
| 2025-12-31 | AAPW | ETF | 40.35 | 40.6 | 40.35 | 40.4362 | 6564.0 |
| 2025-12-31 | AAPX | ETF | 30.72 | 30.78 | 30.43 | 30.48 | 46706.0 |
| 2025-12-31 | AAPY | ETF | 24.93 | 24.945 | 24.8877 | 24.8877 | 2115.0 |
| 2025-12-31 | AAVM | ETF | 29.56 | 29.64 | 29.51 | 29.52 | 6418.0 |
| 2025-12-31 | AAXJ | ETF | 93.6 | 93.6 | 93.04 | 93.12 | 143357.0 |
| 2025-12-31 | ABCS | ETF | 30.55 | 30.55 | 30.4235 | 30.4235 | 3235.0 |
| 2025-12-31 | ABEQ | ETF | 36.0 | 36.0 | 35.85 | 35.85 | 4756.0 |
| 2025-12-31 | ABFL | ETF | 71.84 | 71.84 | 71.37 | 71.37 | 21182.0 |
| 2025-12-31 | ABLD | ETF | 29.18 | 29.18 | 29.09 | 29.09 | 9110.0 |
| 2025-12-31 | ABLG | ETF | 31.66 | 31.97 | 31.59 | 31.7076 | 1282.0 |
| 2025-12-31 | ABNY | ETF | 47.69 | 47.69 | 47.385 | 47.3972 | 2037.0 |
| 2025-12-31 | ABOT | ETF | 39.27 | 39.27 | 39.0959 | 39.0959 | 550.0 |
| 2025-12-31 | ABXB | ETF | 19.6028 | 19.6028 | 19.6028 | 19.6028 | 95.0 |
| 2025-12-31 | ACES | ETF | 32.63 | 32.69 | 32.32 | 32.42 | 24312.0 |
| 2025-12-31 | ACGR | ETF | 66.46 | 66.46 | 66.044 | 66.044 | 2267.0 |
| 2025-12-31 | ACIO | ETF | 43.92 | 43.99 | 43.7 | 43.7 | 120411.0 |
| 2025-12-31 | ACLC | ETF | 78.7686 | 78.7686 | 78.35 | 78.35 | 6784.0 |
| 2025-12-31 | ACSI | ETF | 66.6987 | 66.6987 | 66.6987 | 66.6987 | 9.0 |
| 2025-12-31 | ACVF | ETF | 49.69 | 49.69 | 49.38 | 49.3919 | 3518.0 |
| 2025-12-31 | ACVT | ETF | 26.83 | 26.83 | 26.7625 | 26.7625 | 332.0 |
| 2025-12-31 | ACWI | ETF | 142.55 | 142.9 | 141.48 | 141.49 | 4227656.0 |
| 2025-12-31 | ACWV | ETF | 119.1 | 119.18 | 118.67 | 118.75 | 165656.0 |
| 2025-12-31 | ACWX | ETF | 67.42 | 67.42 | 67.1 | 67.13 | 4284537.0 |
| 2025-12-31 | ADBG | ETF | 10.25 | 10.3499 | 10.2 | 10.22 | 155915.0 |
| 2025-12-31 | ADFI | ETF | 8.56 | 8.6 | 8.56 | 8.5749 | 17768.0 |
| 2025-12-31 | ADIV | ETF | 18.1646 | 18.18 | 18.13 | 18.13 | 7533.0 |
| 2025-12-31 | ADME | ETF | 51.57 | 51.58 | 51.31 | 51.31 | 10374.0 |
| 2025-12-31 | ADPV | ETF | 43.16 | 43.16 | 42.84 | 42.84 | 8954.0 |
| 2025-12-31 | ADVE | ETF | 39.155 | 39.22 | 39.155 | 39.1553 | 1119.0 |
| 2025-12-31 | AESR | ETF | 17.045 | 17.09 | 16.93 | 16.953 | 21255.0 |
| 2025-12-31 | AETH | ETF | 36.13 | 36.16 | 36.13 | 36.15 | 1305.0 |
| 2025-12-31 | AFIF | ETF | 9.43 | 9.43 | 9.383 | 9.41 | 55117.0 |
| 2025-12-31 | AFIX | ETF | 25.14 | 25.15 | 25.095 | 25.095 | 448.0 |
| 2025-12-31 | AFK | ETF | 26.62 | 26.8198 | 26.5101 | 26.75 | 41711.0 |
| 2025-12-31 | AFLG | ETF | 39.53 | 39.53 | 39.1 | 39.1 | 68819.0 |
| 2025-12-31 | AFMC | ETF | 34.87 | 34.87 | 34.472 | 34.472 | 12056.0 |
| 2025-12-31 | AFSC | ETF | 30.63 | 30.63 | 30.41 | 30.4403 | 2757.0 |
> showing 50 of 4,382 rows — these rows as CSV