PREVIEW / etf_daily / 2026-07-01
file: by_date/etf_daily/2026/2026-07-01.parquet size: 158 KB rows: 4,159
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-07-01 | SPY | ETF | 745.0 | 749.435 | 742.375 | 745.76 | 47100878.0 |
| 2026-07-01 | QQQ | ETF | 729.19 | 731.92 | 724.6 | 725.17 | 40803791.0 |
| 2026-07-01 | IWM | ETF | 299.93 | 302.72 | 298.92 | 299.32 | 20607882.0 |
| 2026-07-01 | DIA | ETF | 521.43 | 526.72 | 519.62 | 522.4 | 3438379.0 |
| 2026-07-01 | GLD | ETF | 371.205 | 377.78 | 370.21 | 370.6 | 9058287.0 |
| 2026-07-01 | TLT | ETF | 85.48 | 85.79 | 85.425 | 85.52 | 28109797.0 |
| 2026-07-01 | AAA | ETF | 25.005 | 25.03 | 25.005 | 25.005 | 2420.0 |
| 2026-07-01 | AAAU | ETF | 39.87 | 40.565 | 39.775 | 39.82 | 1196246.0 |
| 2026-07-01 | AADR | ETF | 82.145 | 82.145 | 81.13 | 81.6402 | 2937.0 |
| 2026-07-01 | AAPB | ETF | 35.0 | 35.58 | 34.37 | 35.1456 | 42329.0 |
| 2026-07-01 | AAPD | ETF | 11.98 | 12.115 | 11.8101 | 11.9 | 7404516.0 |
| 2026-07-01 | AAPR | ETF | 29.5 | 29.53 | 29.47 | 29.4927 | 1502.0 |
| 2026-07-01 | AAPU | ETF | 35.87 | 36.68 | 34.91 | 36.13 | 1440669.0 |
| 2026-07-01 | AAPW | ETF | 37.8 | 38.1389 | 37.45 | 38.041 | 6215.0 |
| 2026-07-01 | AAPX | ETF | 32.055 | 33.1 | 31.64 | 32.59 | 20068.0 |
| 2026-07-01 | AAPY | ETF | 24.7101 | 25.19 | 24.7101 | 25.1018 | 2695.0 |
| 2026-07-01 | AAVM | ETF | 33.61 | 33.76 | 33.5572 | 33.5572 | 2072.0 |
| 2026-07-01 | AAXJ | ETF | 116.67 | 117.49 | 115.79 | 115.86 | 778231.0 |
| 2026-07-01 | ABCS | ETF | 33.61 | 33.8075 | 33.61 | 33.8075 | 2641.0 |
| 2026-07-01 | ABEQ | ETF | 37.23 | 37.44 | 37.19 | 37.19 | 28614.0 |
| 2026-07-01 | ABFL | ETF | 84.81 | 85.16 | 84.3561 | 84.3561 | 8167.0 |
| 2026-07-01 | ABLD | ETF | 29.97 | 29.97 | 29.7443 | 29.7443 | 4950.0 |
| 2026-07-01 | ABLG | ETF | 32.21 | 32.33 | 31.77 | 32.08 | 11089.0 |
| 2026-07-01 | ACES | ETF | 35.09 | 35.905 | 34.925 | 34.93 | 36310.0 |
| 2026-07-01 | ACIO | ETF | 46.02 | 46.3582 | 45.98 | 46.19 | 135262.0 |
| 2026-07-01 | ACLC | ETF | 83.8 | 84.27 | 83.8 | 84.0458 | 10141.0 |
| 2026-07-01 | ACSG | ETF | 50.2 | 50.75 | 49.8875 | 49.8875 | 6102.0 |
| 2026-07-01 | ACT | ETF | 45.71 | 45.82 | 44.95 | 45.39 | 359934.0 |
| 2026-07-01 | ACVF | ETF | 53.92 | 54.39 | 53.92 | 54.0711 | 6624.0 |
| 2026-07-01 | ACWI | ETF | 156.17 | 156.88 | 155.65 | 156.12 | 4128870.0 |
| 2026-07-01 | ACWV | ETF | 120.06 | 120.91 | 120.06 | 120.62 | 49272.0 |
| 2026-07-01 | ACWX | ETF | 75.13 | 75.485 | 74.95 | 74.99 | 4083906.0 |
| 2026-07-01 | ADBG | ETF | 3.125 | 3.235 | 3.06 | 3.17 | 6229902.0 |
| 2026-07-01 | ADFI | ETF | 8.48 | 8.51 | 8.48 | 8.49 | 15214.0 |
| 2026-07-01 | ADIV | ETF | 18.37 | 18.475 | 18.37 | 18.4254 | 6220.0 |
| 2026-07-01 | ADME | ETF | 55.2832 | 55.66 | 55.2832 | 55.58 | 8965.0 |
| 2026-07-01 | ADPV | ETF | 47.46 | 47.5844 | 46.93 | 47.0461 | 20197.0 |
| 2026-07-01 | AESR | ETF | 20.43 | 20.46 | 20.09 | 20.35 | 38095.0 |
| 2026-07-01 | AFIF | ETF | 9.4 | 9.44 | 9.4 | 9.43 | 68413.0 |
| 2026-07-01 | AFIX | ETF | 24.74 | 24.7799 | 24.73 | 24.7396 | 8533.0 |
| 2026-07-01 | AFK | ETF | 25.75 | 25.79 | 25.5 | 25.77 | 37209.0 |
| 2026-07-01 | AFLG | ETF | 43.26 | 43.455 | 43.15 | 43.25 | 213415.0 |
| 2026-07-01 | AFMC | ETF | 40.9 | 41.0 | 40.63 | 40.63 | 26330.0 |
| 2026-07-01 | AFSC | ETF | 39.21 | 39.27 | 38.9501 | 38.9501 | 1433.0 |
| 2026-07-01 | AFSM | ETF | 41.15 | 41.285 | 40.81 | 40.88 | 12949.0 |
| 2026-07-01 | AGEM | ETF | 47.41 | 48.645 | 47.41 | 48.1851 | 9750.0 |
| 2026-07-01 | AGG | ETF | 98.48 | 98.61 | 98.422 | 98.5 | 10914676.0 |
| 2026-07-01 | AGGA | ETF | 25.125 | 25.14 | 25.1 | 25.115 | 94163.0 |
| 2026-07-01 | AGGH | ETF | 20.24 | 20.24 | 20.11 | 20.112 | 181409.0 |
| 2026-07-01 | AGGY | ETF | 43.39 | 43.46 | 43.36 | 43.415 | 64739.0 |
> showing 50 of 4,159 rows — these rows as CSV