PREVIEW / etf_daily / 2025-07-24
file: by_date/etf_daily/2025/2025-07-24.parquet size: 161 KB rows: 4,223
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-24 | SPY | ETF | 634.6 | 636.15 | 633.99 | 634.42 | 71419252.0 |
| 2025-07-24 | QQQ | ETF | 565.13 | 566.24 | 563.295 | 565.01 | 42275541.0 |
| 2025-07-24 | IWM | ETF | 225.515 | 225.8499 | 223.48 | 223.55 | 29414806.0 |
| 2025-07-24 | DIA | ETF | 447.01 | 449.1299 | 446.75 | 447.11 | 5076129.0 |
| 2025-07-24 | GLD | ETF | 309.29 | 310.99 | 309.06 | 310.27 | 7695149.0 |
| 2025-07-24 | TLT | ETF | 85.55 | 86.24 | 85.51 | 85.89 | 25118628.0 |
| 2025-07-24 | AAA | ETF | 24.96 | 25.06 | 24.94 | 24.9906 | 8801.0 |
| 2025-07-24 | AAAU | ETF | 33.16 | 33.35 | 33.13 | 33.275 | 2467724.0 |
| 2025-07-24 | AADR | ETF | 80.3599 | 80.3599 | 79.36 | 79.73 | 1991.0 |
| 2025-07-24 | AAPB | ETF | 21.7 | 22.06 | 21.7 | 21.71 | 189544.0 |
| 2025-07-24 | AAPD | ETF | 16.85 | 16.8926 | 16.74 | 16.88 | 980243.0 |
| 2025-07-24 | AAPR | ETF | 27.47 | 27.4713 | 27.47 | 27.47 | 2851.0 |
| 2025-07-24 | AAPU | ETF | 23.66 | 24.05 | 23.59 | 23.64 | 3349811.0 |
| 2025-07-24 | AAPW | ETF | 36.11 | 36.49 | 36.05 | 36.14 | 39271.0 |
| 2025-07-24 | AAPX | ETF | 20.4 | 20.73 | 20.39 | 20.39 | 132978.0 |
| 2025-07-24 | AAPY | ETF | 22.05 | 22.1 | 22.0 | 22.0 | 2521.0 |
| 2025-07-24 | AAVM | ETF | 27.23 | 27.23 | 27.1938 | 27.1938 | 392.0 |
| 2025-07-24 | AAXJ | ETF | 85.86 | 86.005 | 85.67 | 85.71 | 525752.0 |
| 2025-07-24 | ABCS | ETF | 29.525 | 29.54 | 29.2701 | 29.2701 | 2002.0 |
| 2025-07-24 | ABEQ | ETF | 34.77 | 34.78 | 34.6939 | 34.6939 | 12370.0 |
| 2025-07-24 | ABFL | ETF | 70.91 | 70.93 | 70.6821 | 70.81 | 14600.0 |
| 2025-07-24 | ABLD | ETF | 29.15 | 29.17 | 29.1117 | 29.1117 | 6929.0 |
| 2025-07-24 | ABLG | ETF | 30.8221 | 30.8221 | 30.8161 | 30.8161 | 144.0 |
| 2025-07-24 | ABNY | ETF | 58.25 | 59.6 | 58.25 | 59.25 | 2271.0 |
| 2025-07-24 | ABOT | ETF | 39.27 | 39.27 | 39.176 | 39.21 | 811.0 |
| 2025-07-24 | ABXB | ETF | 19.5748 | 19.5748 | 19.5748 | 19.5748 | 26.0 |
| 2025-07-24 | ACES | ETF | 28.98 | 29.11 | 28.481 | 28.6 | 12168.0 |
| 2025-07-24 | ACGR | ETF | 61.35 | 61.4772 | 61.35 | 61.4772 | 106.0 |
| 2025-07-24 | ACIO | ETF | 41.9 | 41.9879 | 41.8832 | 41.895 | 70979.0 |
| 2025-07-24 | ACLC | ETF | 73.81 | 73.81 | 73.68 | 73.7122 | 1900.0 |
| 2025-07-24 | ACSI | ETF | 64.1903 | 64.1903 | 64.1903 | 64.1903 | 199.0 |
| 2025-07-24 | ACTV | ETF | 32.59 | 32.65 | 32.59 | 32.5986 | 1149.0 |
| 2025-07-24 | ACVF | ETF | 48.28 | 48.28 | 48.1844 | 48.1844 | 1188.0 |
| 2025-07-24 | ACWI | ETF | 131.8 | 131.95 | 131.6 | 131.63 | 1663392.0 |
| 2025-07-24 | ACWV | ETF | 118.74 | 119.01 | 118.56 | 118.59 | 119438.0 |
| 2025-07-24 | ACWX | ETF | 62.325 | 62.45 | 62.18 | 62.19 | 624966.0 |
| 2025-07-24 | ADBG | ETF | 12.62 | 12.8702 | 12.53 | 12.57 | 59111.0 |
| 2025-07-24 | ADFI | ETF | 8.49 | 8.529 | 8.4239 | 8.46 | 13037.0 |
| 2025-07-24 | ADIV | ETF | 18.14 | 18.19 | 18.1 | 18.124 | 15270.0 |
| 2025-07-24 | ADME | ETF | 48.99 | 49.03 | 48.8556 | 48.8556 | 6577.0 |
| 2025-07-24 | ADPV | ETF | 40.13 | 40.13 | 39.8201 | 39.8897 | 14078.0 |
| 2025-07-24 | ADVE | ETF | 36.7264 | 36.7264 | 36.7264 | 36.7264 | 26.0 |
| 2025-07-24 | AESR | ETF | 19.53 | 19.55 | 19.49 | 19.495 | 12816.0 |
| 2025-07-24 | AETH | ETF | 51.45 | 51.45 | 51.1231 | 51.1231 | 3306.0 |
| 2025-07-24 | AFIF | ETF | 9.36 | 9.36 | 9.32 | 9.33 | 16729.0 |
| 2025-07-24 | AFIX | ETF | 24.8718 | 24.875 | 24.8718 | 24.875 | 3203.0 |
| 2025-07-24 | AFK | ETF | 21.41 | 21.7199 | 21.335 | 21.55 | 11698.0 |
| 2025-07-24 | AFLG | ETF | 36.93 | 37.03 | 36.9 | 36.9199 | 53146.0 |
| 2025-07-24 | AFMC | ETF | 32.95 | 32.95 | 32.55 | 32.55 | 8114.0 |
| 2025-07-24 | AFSC | ETF | 28.92 | 28.92 | 28.7936 | 28.7936 | 392.0 |
> showing 50 of 4,223 rows — these rows as CSV