PREVIEW / etf_daily / 2025-07-17
file: by_date/etf_daily/2025/2025-07-17.parquet size: 160 KB rows: 4,196
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-07-17 | SPY | ETF | 624.4 | 628.4048 | 624.18 | 628.04 | 68872065.0 |
| 2025-07-17 | QQQ | ETF | 558.02 | 562.31 | 557.21 | 561.8 | 40423778.0 |
| 2025-07-17 | IWM | ETF | 221.08 | 224.2 | 220.71 | 223.92 | 43539021.0 |
| 2025-07-17 | DIA | ETF | 442.05 | 445.61 | 441.98 | 445.22 | 3788867.0 |
| 2025-07-17 | GLD | ETF | 305.5 | 307.665 | 305.12 | 307.59 | 6646341.0 |
| 2025-07-17 | TLT | ETF | 85.22 | 85.485 | 84.99 | 85.11 | 31874860.0 |
| 2025-07-17 | AAA | ETF | 24.94 | 24.955 | 24.92 | 24.955 | 1901.0 |
| 2025-07-17 | AAAU | ETF | 32.74 | 32.9903 | 32.71 | 32.97 | 2629554.0 |
| 2025-07-17 | AADR | ETF | 78.6528 | 79.005 | 78.6528 | 79.005 | 851.0 |
| 2025-07-17 | AAPB | ETF | 21.15 | 21.32 | 20.92 | 21.04 | 279140.0 |
| 2025-07-17 | AAPD | ETF | 17.1 | 17.18 | 17.0226 | 17.16 | 721069.0 |
| 2025-07-17 | AAPR | ETF | 27.33 | 27.3717 | 27.33 | 27.3717 | 1318.0 |
| 2025-07-17 | AAPU | ETF | 23.0 | 23.24 | 22.7621 | 22.87 | 2843268.0 |
| 2025-07-17 | AAPW | ETF | 36.0 | 36.199 | 35.68 | 35.95 | 97507.0 |
| 2025-07-17 | AAPX | ETF | 19.82 | 20.04 | 19.67 | 19.78 | 96847.0 |
| 2025-07-17 | AAPY | ETF | 21.65 | 21.7499 | 21.65 | 21.6838 | 3821.0 |
| 2025-07-17 | AAVM | ETF | 26.69 | 26.7098 | 26.66 | 26.7098 | 6399.0 |
| 2025-07-17 | AAXJ | ETF | 84.1 | 84.67 | 83.98 | 84.59 | 219310.0 |
| 2025-07-17 | ABCS | ETF | 28.85 | 29.0847 | 28.85 | 29.0847 | 1606.0 |
| 2025-07-17 | ABEQ | ETF | 33.95 | 34.27 | 33.95 | 34.27 | 4374.0 |
| 2025-07-17 | ABFL | ETF | 69.31 | 69.97 | 69.31 | 69.89 | 11601.0 |
| 2025-07-17 | ABLD | ETF | 28.86 | 28.93 | 28.84 | 28.8964 | 6426.0 |
| 2025-07-17 | ABLG | ETF | 30.58 | 30.6883 | 30.58 | 30.6883 | 1000.0 |
| 2025-07-17 | ABNY | ETF | 59.6 | 60.2 | 59.6 | 60.139 | 938.0 |
| 2025-07-17 | ABOT | ETF | 38.41 | 38.6225 | 38.41 | 38.6225 | 342.0 |
| 2025-07-17 | ABXB | ETF | 19.455 | 19.455 | 19.455 | 19.455 | 3.0 |
| 2025-07-17 | ACES | ETF | 27.74 | 28.2404 | 27.74 | 27.98 | 66113.0 |
| 2025-07-17 | ACGR | ETF | 60.8086 | 60.8086 | 60.8086 | 60.8086 | 5.0 |
| 2025-07-17 | ACIO | ETF | 41.57 | 41.69 | 41.511 | 41.645 | 127838.0 |
| 2025-07-17 | ACLC | ETF | 72.88 | 73.17 | 72.86 | 73.0986 | 10910.0 |
| 2025-07-17 | ACSI | ETF | 63.01 | 63.0777 | 63.01 | 63.0777 | 174.0 |
| 2025-07-17 | ACTV | ETF | 32.01 | 32.18 | 32.01 | 32.1487 | 5194.0 |
| 2025-07-17 | ACVF | ETF | 47.53 | 47.79 | 47.53 | 47.7582 | 7461.0 |
| 2025-07-17 | ACWI | ETF | 129.26 | 129.9499 | 129.2 | 129.86 | 7461445.0 |
| 2025-07-17 | ACWV | ETF | 117.13 | 117.52 | 116.86 | 117.47 | 107739.0 |
| 2025-07-17 | ACWX | ETF | 60.71 | 61.038 | 60.64 | 61.01 | 1106462.0 |
| 2025-07-17 | ADBG | ETF | 11.84 | 12.29 | 11.84 | 12.22 | 54208.0 |
| 2025-07-17 | ADFI | ETF | 8.41 | 8.47 | 8.395 | 8.4557 | 14062.0 |
| 2025-07-17 | ADIV | ETF | 17.93 | 17.9936 | 17.91 | 17.9784 | 1262.0 |
| 2025-07-17 | ADME | ETF | 48.47 | 48.63 | 48.4519 | 48.5612 | 8671.0 |
| 2025-07-17 | ADPV | ETF | 39.52 | 40.41 | 39.52 | 40.29 | 26721.0 |
| 2025-07-17 | ADVE | ETF | 36.16 | 36.16 | 36.12 | 36.1469 | 576.0 |
| 2025-07-17 | AESR | ETF | 19.1 | 19.31 | 19.1 | 19.2944 | 92714.0 |
| 2025-07-17 | AETH | ETF | 46.77 | 47.11 | 46.51 | 46.6622 | 3795.0 |
| 2025-07-17 | AFIF | ETF | 9.315 | 9.34 | 9.31 | 9.335 | 12732.0 |
| 2025-07-17 | AFIX | ETF | 24.8 | 24.8 | 24.785 | 24.785 | 335.0 |
| 2025-07-17 | AFK | ETF | 20.5 | 20.78 | 20.5 | 20.76 | 9640.0 |
| 2025-07-17 | AFLG | ETF | 36.26 | 36.5334 | 36.26 | 36.51 | 47392.0 |
| 2025-07-17 | AFMC | ETF | 32.26 | 32.4673 | 32.26 | 32.44 | 6028.0 |
| 2025-07-17 | AFSC | ETF | 28.86 | 28.96 | 28.86 | 28.93 | 418.0 |
> showing 50 of 4,196 rows — these rows as CSV