PREVIEW / etf_daily / 2025-10-20
file: by_date/etf_daily/2025/2025-10-20.parquet size: 164 KB rows: 4,330
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-10-20 | SPY | ETF | 667.32 | 672.21 | 667.27 | 671.3 | 60479048.0 |
| 2025-10-20 | QQQ | ETF | 607.14 | 612.8 | 607.065 | 611.54 | 45761697.0 |
| 2025-10-20 | IWM | ETF | 246.62 | 248.33 | 246.14 | 248.16 | 32521449.0 |
| 2025-10-20 | DIA | ETF | 463.45 | 467.53 | 463.43 | 467.02 | 4549386.0 |
| 2025-10-20 | GLD | ETF | 397.45 | 403.3 | 394.2 | 403.15 | 34489373.0 |
| 2025-10-20 | TLT | ETF | 91.46 | 91.56 | 91.28 | 91.55 | 28377352.0 |
| 2025-10-20 | AAA | ETF | 25.01 | 25.0599 | 24.95 | 25.005 | 19382.0 |
| 2025-10-20 | AAAU | ETF | 42.63 | 43.26 | 42.38 | 43.23 | 3319445.0 |
| 2025-10-20 | AADR | ETF | 84.19 | 85.62 | 84.19 | 85.245 | 3092.0 |
| 2025-10-20 | AAPB | ETF | 30.115 | 32.0755 | 30.115 | 31.5946 | 335031.0 |
| 2025-10-20 | AAPD | ETF | 13.96 | 13.96 | 13.475 | 13.58 | 3125616.0 |
| 2025-10-20 | AAPR | ETF | 27.96 | 28.03 | 27.96 | 28.01 | 2519.0 |
| 2025-10-20 | AAPU | ETF | 32.51 | 34.6 | 32.43 | 34.08 | 4742063.0 |
| 2025-10-20 | AAPW | ETF | 39.85 | 41.82 | 39.85 | 41.5 | 48099.0 |
| 2025-10-20 | AAPX | ETF | 28.13 | 29.9 | 28.075 | 29.49 | 216570.0 |
| 2025-10-20 | AAPY | ETF | 24.13 | 24.37 | 24.1 | 24.34 | 5262.0 |
| 2025-10-20 | AAVM | ETF | 28.7387 | 28.7387 | 28.7287 | 28.7353 | 2831.0 |
| 2025-10-20 | AAXJ | ETF | 93.52 | 94.335 | 93.52 | 94.18 | 701715.0 |
| 2025-10-20 | ABCS | ETF | 29.92 | 30.0365 | 29.92 | 30.0365 | 2708.0 |
| 2025-10-20 | ABEQ | ETF | 35.34 | 35.4392 | 35.34 | 35.4392 | 999.0 |
| 2025-10-20 | ABFL | ETF | 71.45 | 71.87 | 71.45 | 71.69 | 278825.0 |
| 2025-10-20 | ABLD | ETF | 28.54 | 28.59 | 28.53 | 28.56 | 50062.0 |
| 2025-10-20 | ABLG | ETF | 31.2941 | 31.2941 | 31.2941 | 31.2941 | 104.0 |
| 2025-10-20 | ABNY | ETF | 48.9 | 49.75 | 48.9 | 49.1 | 80286.0 |
| 2025-10-20 | ABOT | ETF | 40.1821 | 40.1821 | 40.1821 | 40.1821 | 28.0 |
| 2025-10-20 | ABXB | ETF | 19.67 | 19.67 | 19.67 | 19.67 | 196.0 |
| 2025-10-20 | ACES | ETF | 35.87 | 36.0056 | 35.5 | 35.81 | 44044.0 |
| 2025-10-20 | ACGR | ETF | 65.7527 | 65.7527 | 65.7527 | 65.7527 | 173.0 |
| 2025-10-20 | ACIO | ETF | 43.54 | 43.8 | 43.54 | 43.75 | 74931.0 |
| 2025-10-20 | ACLC | ETF | 77.49 | 77.65 | 77.44 | 77.6172 | 7946.0 |
| 2025-10-20 | ACSG | ETF | 40.8747 | 40.8747 | 40.67 | 40.8099 | 2873.0 |
| 2025-10-20 | ACSI | ETF | 66.51 | 66.56 | 66.51 | 66.5274 | 540.0 |
| 2025-10-20 | ACTV | ETF | 33.45 | 33.6 | 33.45 | 33.6 | 1002.0 |
| 2025-10-20 | ACVF | ETF | 49.39 | 49.47 | 49.33 | 49.405 | 5240.0 |
| 2025-10-20 | ACWI | ETF | 139.41 | 140.39 | 139.29 | 140.02 | 1957430.0 |
| 2025-10-20 | ACWV | ETF | 120.29 | 120.65 | 120.21 | 120.6 | 71209.0 |
| 2025-10-20 | ACWX | ETF | 66.29 | 66.61 | 66.24 | 66.55 | 1032445.0 |
| 2025-10-20 | ADBG | ETF | 9.73 | 10.275 | 9.73 | 10.2386 | 609153.0 |
| 2025-10-20 | ADFI | ETF | 8.6269 | 8.645 | 8.6269 | 8.645 | 2321.0 |
| 2025-10-20 | ADIV | ETF | 18.32 | 18.38 | 18.1366 | 18.38 | 4658.0 |
| 2025-10-20 | ADME | ETF | 51.29 | 51.4301 | 51.25 | 51.3641 | 7172.0 |
| 2025-10-20 | ADPV | ETF | 44.83 | 45.19 | 44.69 | 45.0655 | 10694.0 |
| 2025-10-20 | ADVE | ETF | 39.38 | 39.39 | 39.3442 | 39.3442 | 709.0 |
| 2025-10-20 | AESR | ETF | 20.67 | 20.8076 | 20.67 | 20.75 | 10092.0 |
| 2025-10-20 | AETH | ETF | 43.0 | 43.0742 | 43.0 | 43.0742 | 852.0 |
| 2025-10-20 | AFIF | ETF | 9.39 | 9.43 | 9.39 | 9.43 | 27221.0 |
| 2025-10-20 | AFIX | ETF | 25.55 | 25.55 | 25.55 | 25.55 | 173.0 |
| 2025-10-20 | AFK | ETF | 24.65 | 24.7 | 24.51 | 24.55 | 20149.0 |
| 2025-10-20 | AFLG | ETF | 38.7 | 38.9216 | 38.7 | 38.867 | 51889.0 |
| 2025-10-20 | AFMC | ETF | 33.81 | 33.81 | 33.53 | 33.787 | 15346.0 |
> showing 50 of 4,330 rows — these rows as CSV