PREVIEW / etf_daily / 2025-08-19
file: by_date/etf_daily/2025/2025-08-19.parquet size: 162 KB rows: 4,255
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-19 | SPY | ETF | 643.12 | 644.105 | 638.48 | 639.81 | 69733598.0 |
| 2025-08-19 | QQQ | ETF | 576.39 | 576.56 | 568.25 | 569.28 | 53752635.0 |
| 2025-08-19 | IWM | ETF | 228.02 | 228.98 | 225.685 | 226.21 | 24979083.0 |
| 2025-08-19 | DIA | ETF | 449.85 | 452.15 | 448.21 | 449.29 | 5791719.0 |
| 2025-08-19 | GLD | ETF | 306.76 | 307.4788 | 305.19 | 305.27 | 5010782.0 |
| 2025-08-19 | TLT | ETF | 86.45 | 86.75 | 86.445 | 86.65 | 28780425.0 |
| 2025-08-19 | AAA | ETF | 25.0 | 25.004 | 24.95 | 24.995 | 5530.0 |
| 2025-08-19 | AAAU | ETF | 32.9 | 32.9754 | 32.7349 | 32.74 | 1678409.0 |
| 2025-08-19 | AADR | ETF | 81.6 | 81.6 | 81.24 | 81.24 | 714.0 |
| 2025-08-19 | AAPB | ETF | 25.15 | 25.49 | 24.76 | 24.99 | 356565.0 |
| 2025-08-19 | AAPD | ETF | 15.55 | 15.68 | 15.45 | 15.61 | 755606.0 |
| 2025-08-19 | AAPR | ETF | 27.61 | 27.61 | 27.595 | 27.595 | 196.0 |
| 2025-08-19 | AAPU | ETF | 27.36 | 27.73 | 26.92 | 27.18 | 2273088.0 |
| 2025-08-19 | AAPW | ETF | 38.17 | 38.45 | 37.81 | 38.06 | 29517.0 |
| 2025-08-19 | AAPX | ETF | 23.55 | 23.9 | 23.21 | 23.45 | 133113.0 |
| 2025-08-19 | AAPY | ETF | 23.4 | 23.4 | 23.14 | 23.1767 | 7842.0 |
| 2025-08-19 | AAVM | ETF | 27.7198 | 27.7198 | 27.61 | 27.66 | 914.0 |
| 2025-08-19 | AAXJ | ETF | 86.37 | 86.38 | 85.75 | 85.87 | 602834.0 |
| 2025-08-19 | ABCS | ETF | 29.85 | 29.97 | 29.795 | 29.8242 | 4063.0 |
| 2025-08-19 | ABEQ | ETF | 34.71 | 34.73 | 34.6244 | 34.6961 | 7504.0 |
| 2025-08-19 | ABFL | ETF | 69.15 | 69.22 | 68.67 | 68.67 | 13235.0 |
| 2025-08-19 | ABLD | ETF | 28.45 | 28.5309 | 28.44 | 28.5309 | 3369.0 |
| 2025-08-19 | ABLG | ETF | 29.74 | 29.985 | 29.74 | 29.8 | 18104.0 |
| 2025-08-19 | ABNY | ETF | 53.25 | 53.7445 | 52.875 | 53.25 | 4026.0 |
| 2025-08-19 | ABOT | ETF | 38.2241 | 38.2241 | 38.2241 | 38.2241 | 73.0 |
| 2025-08-19 | ABXB | ETF | 19.6542 | 19.6542 | 19.6542 | 19.6542 | 22.0 |
| 2025-08-19 | ACES | ETF | 29.06 | 29.09 | 28.73 | 28.87 | 20504.0 |
| 2025-08-19 | ACGR | ETF | 62.0551 | 62.0551 | 62.0551 | 62.0551 | 4.0 |
| 2025-08-19 | ACIO | ETF | 42.35 | 42.45 | 42.2182 | 42.28 | 122866.0 |
| 2025-08-19 | ACLC | ETF | 74.931 | 74.931 | 74.3274 | 74.429 | 5983.0 |
| 2025-08-19 | ACSI | ETF | 65.6263 | 65.6263 | 65.6263 | 65.6263 | 239.0 |
| 2025-08-19 | ACTV | ETF | 32.82 | 32.82 | 32.71 | 32.744 | 1040.0 |
| 2025-08-19 | ACVF | ETF | 48.19 | 48.42 | 48.05 | 48.1019 | 14709.0 |
| 2025-08-19 | ACWI | ETF | 133.43 | 133.56 | 132.53 | 132.7 | 3361866.0 |
| 2025-08-19 | ACWV | ETF | 119.41 | 120.02 | 119.4085 | 119.87 | 86749.0 |
| 2025-08-19 | ACWX | ETF | 63.05 | 63.11 | 62.7525 | 62.82 | 555680.0 |
| 2025-08-19 | ADBG | ETF | 11.57 | 11.92 | 11.52 | 11.7022 | 196936.0 |
| 2025-08-19 | ADFI | ETF | 8.49 | 8.52 | 8.4838 | 8.505 | 32431.0 |
| 2025-08-19 | ADIV | ETF | 18.29 | 18.29 | 18.15 | 18.2007 | 6010.0 |
| 2025-08-19 | ADME | ETF | 49.55 | 49.55 | 49.1973 | 49.31 | 5384.0 |
| 2025-08-19 | ADPV | ETF | 40.02 | 40.0214 | 39.1 | 39.23 | 11486.0 |
| 2025-08-19 | ADVE | ETF | 37.1 | 37.1 | 36.8538 | 36.8538 | 280.0 |
| 2025-08-19 | AESR | ETF | 19.59 | 19.62 | 19.48 | 19.49 | 26119.0 |
| 2025-08-19 | AETH | ETF | 52.94 | 52.94 | 50.81 | 50.8185 | 3697.0 |
| 2025-08-19 | AFIF | ETF | 9.36 | 9.36 | 9.34 | 9.345 | 529165.0 |
| 2025-08-19 | AFIX | ETF | 24.99 | 25.01 | 24.99 | 25.01 | 2217.0 |
| 2025-08-19 | AFK | ETF | 21.8 | 21.8 | 21.12 | 21.5063 | 28184.0 |
| 2025-08-19 | AFLG | ETF | 37.4 | 37.5149 | 37.28 | 37.3208 | 23153.0 |
| 2025-08-19 | AFMC | ETF | 33.01 | 33.16 | 32.87 | 32.93 | 10490.0 |
| 2025-08-19 | AFSC | ETF | 29.32 | 29.4 | 29.12 | 29.1994 | 324.0 |
> showing 50 of 4,255 rows — these rows as CSV