PREVIEW / etf_daily / 2026-01-02
file: by_date/etf_daily/2026/2026-01-02.parquet size: 166 KB rows: 4,386
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-01-02 | SPY | ETF | 685.71 | 686.87 | 679.82 | 683.17 | 89314272.0 |
| 2026-01-02 | QQQ | ETF | 620.06 | 622.85 | 610.15 | 613.12 | 61859163.0 |
| 2026-01-02 | IWM | ETF | 247.63 | 249.09 | 245.86 | 248.78 | 39939622.0 |
| 2026-01-02 | DIA | ETF | 481.85 | 483.95 | 478.38 | 483.63 | 7014718.0 |
| 2026-01-02 | GLD | ETF | 401.62 | 401.82 | 396.25 | 398.28 | 10369350.0 |
| 2026-01-02 | TLT | ETF | 87.4 | 87.41 | 87.0201 | 87.03 | 40726636.0 |
| 2026-01-02 | AAA | ETF | 24.98 | 25.0 | 24.95 | 24.95 | 6358.0 |
| 2026-01-02 | AAAU | ETF | 43.12 | 43.12 | 42.54 | 42.74 | 1624485.0 |
| 2026-01-02 | AADR | ETF | 87.205 | 87.67 | 86.4301 | 87.665 | 866.0 |
| 2026-01-02 | AAPB | ETF | 32.0 | 33.3209 | 31.41 | 31.85 | 61537.0 |
| 2026-01-02 | AAPD | ETF | 13.11 | 13.25 | 12.84 | 13.17 | 2548874.0 |
| 2026-01-02 | AAPR | ETF | 28.42 | 28.425 | 28.39 | 28.425 | 1557.0 |
| 2026-01-02 | AAPU | ETF | 33.715 | 35.03 | 32.89 | 33.35 | 1425346.0 |
| 2026-01-02 | AAPW | ETF | 40.43 | 41.52 | 39.94 | 40.11 | 12717.0 |
| 2026-01-02 | AAPX | ETF | 30.505 | 31.68 | 29.785 | 30.17 | 182922.0 |
| 2026-01-02 | AAPY | ETF | 25.01 | 25.19 | 24.677 | 24.7671 | 3724.0 |
| 2026-01-02 | AAVM | ETF | 29.77 | 29.91 | 29.77 | 29.8808 | 1292.0 |
| 2026-01-02 | AAXJ | ETF | 95.22 | 96.07 | 95.22 | 96.03 | 506156.0 |
| 2026-01-02 | ABCS | ETF | 30.48 | 30.73 | 30.45 | 30.6155 | 3290.0 |
| 2026-01-02 | ABEQ | ETF | 35.72 | 35.855 | 35.69 | 35.855 | 3790.0 |
| 2026-01-02 | ABFL | ETF | 71.71 | 71.9699 | 71.47 | 71.91 | 31447.0 |
| 2026-01-02 | ABLD | ETF | 29.1 | 29.35 | 29.1 | 29.3239 | 5676.0 |
| 2026-01-02 | ABLG | ETF | 31.76 | 31.9255 | 31.76 | 31.9255 | 1216.0 |
| 2026-01-02 | ABNY | ETF | 46.98 | 46.98 | 45.99 | 45.99 | 3463.0 |
| 2026-01-02 | ABOT | ETF | 39.03 | 39.03 | 38.57 | 38.57 | 744.0 |
| 2026-01-02 | ABXB | ETF | 19.5955 | 19.5955 | 19.5955 | 19.5955 | 27.0 |
| 2026-01-02 | ACES | ETF | 32.95 | 33.923 | 32.95 | 33.8659 | 12079.0 |
| 2026-01-02 | ACGR | ETF | 66.32 | 66.32 | 65.6186 | 65.6186 | 871.0 |
| 2026-01-02 | ACIO | ETF | 43.92 | 43.94 | 43.56 | 43.73 | 88259.0 |
| 2026-01-02 | ACLC | ETF | 78.74 | 78.74 | 78.14 | 78.5042 | 5173.0 |
| 2026-01-02 | ACSI | ETF | 66.7 | 66.81 | 66.6739 | 66.6739 | 2150.0 |
| 2026-01-02 | ACTX | ETF | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 6311.0 |
| 2026-01-02 | ACVF | ETF | 49.45 | 49.565 | 49.36 | 49.4891 | 5772.0 |
| 2026-01-02 | ACWI | ETF | 142.77 | 142.95 | 141.49 | 142.49 | 5204221.0 |
| 2026-01-02 | ACWV | ETF | 119.02 | 119.02 | 118.265 | 118.68 | 118622.0 |
| 2026-01-02 | ACWX | ETF | 68.01 | 68.13 | 67.76 | 68.13 | 3503203.0 |
| 2026-01-02 | ADBG | ETF | 10.27 | 10.27 | 9.1455 | 9.25 | 668316.0 |
| 2026-01-02 | ADFI | ETF | 8.56 | 8.58 | 8.5533 | 8.57 | 9603.0 |
| 2026-01-02 | ADIV | ETF | 18.33 | 18.34 | 18.24 | 18.34 | 5468.0 |
| 2026-01-02 | ADME | ETF | 51.83 | 51.83 | 51.15 | 51.2794 | 4767.0 |
| 2026-01-02 | ADPV | ETF | 43.2585 | 43.73 | 43.11 | 43.73 | 36081.0 |
| 2026-01-02 | ADVE | ETF | 39.975 | 40.0716 | 39.93 | 40.0716 | 782.0 |
| 2026-01-02 | AESR | ETF | 17.08 | 17.17 | 17.05 | 17.167 | 12964.0 |
| 2026-01-02 | AETH | ETF | 36.2 | 36.2 | 36.09 | 36.1952 | 2651.0 |
| 2026-01-02 | AFIF | ETF | 9.44 | 9.44 | 9.39 | 9.4054 | 46833.0 |
| 2026-01-02 | AFIX | ETF | 25.075 | 25.075 | 25.075 | 25.075 | 29.0 |
| 2026-01-02 | AFK | ETF | 26.98 | 27.0 | 26.01 | 26.49 | 187098.0 |
| 2026-01-02 | AFLG | ETF | 39.37 | 39.443 | 39.17 | 39.32 | 123686.0 |
| 2026-01-02 | AFMC | ETF | 34.6099 | 35.0 | 34.567 | 34.9243 | 10722.0 |
| 2026-01-02 | AFSC | ETF | 30.6796 | 30.6796 | 30.6796 | 30.6796 | 326.0 |
> showing 50 of 4,386 rows — these rows as CSV