PREVIEW / etf_daily / 2026-07-07
file: by_date/etf_daily/2026/2026-07-07.parquet size: 161 KB rows: 4,256
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-07 | SPY | ETF | 750.22 | 750.96 | 745.21 | 747.71 | 43721494.0 |
| 2026-07-07 | QQQ | ETF | 714.17 | 716.35 | 704.9 | 709.43 | 42483079.0 |
| 2026-07-07 | IWM | ETF | 299.17 | 299.972 | 295.18 | 296.19 | 18057100.0 |
| 2026-07-07 | DIA | ETF | 532.505 | 532.54 | 527.11 | 528.45 | 4489168.0 |
| 2026-07-07 | GLD | ETF | 382.39 | 383.5999 | 375.52 | 377.49 | 4815434.0 |
| 2026-07-07 | TLT | ETF | 85.115 | 85.1677 | 84.54 | 84.55 | 24816434.0 |
| 2026-07-07 | AAA | ETF | 24.98 | 25.09 | 24.97 | 25.0306 | 11935.0 |
| 2026-07-07 | AAAU | ETF | 41.07 | 41.2 | 40.36 | 40.57 | 1322225.0 |
| 2026-07-07 | AADR | ETF | 83.12 | 83.12 | 82.39 | 83.0 | 1196.0 |
| 2026-07-07 | AAOG | ETF | 4.4 | 4.955 | 3.83 | 4.07 | 1149017.0 |
| 2026-07-07 | AAOX | ETF | 19.56 | 22.2399 | 17.16 | 18.18 | 4499129.0 |
| 2026-07-07 | AAPB | ETF | 40.06 | 40.25 | 38.94 | 39.03 | 49759.0 |
| 2026-07-07 | AAPD | ETF | 11.12 | 11.2798 | 11.09 | 11.26 | 3128574.0 |
| 2026-07-07 | AAPR | ETF | 29.55 | 29.55 | 29.5 | 29.5162 | 2669.0 |
| 2026-07-07 | AAPU | ETF | 41.285 | 41.3642 | 39.98 | 40.09 | 1401755.0 |
| 2026-07-07 | AAPW | ETF | 41.0 | 41.04 | 40.38 | 40.45 | 13911.0 |
| 2026-07-07 | AAPX | ETF | 37.24 | 37.24 | 36.22 | 36.26 | 36542.0 |
| 2026-07-07 | AAVM | ETF | 33.385 | 33.4327 | 33.385 | 33.4327 | 478.0 |
| 2026-07-07 | AAXJ | ETF | 114.58 | 115.18 | 113.235 | 114.25 | 512244.0 |
| 2026-07-07 | ABCS | ETF | 34.29 | 34.34 | 34.1868 | 34.1868 | 1560.0 |
| 2026-07-07 | ABEQ | ETF | 38.035 | 38.035 | 37.67 | 37.7675 | 9442.0 |
| 2026-07-07 | ABFL | ETF | 83.14 | 83.14 | 82.3999 | 82.89 | 13159.0 |
| 2026-07-07 | ABLD | ETF | 30.1 | 30.13 | 29.955 | 30.0511 | 7042.0 |
| 2026-07-07 | ABLG | ETF | 31.502 | 31.5395 | 31.5 | 31.5395 | 1299.0 |
| 2026-07-07 | ACES | ETF | 34.63 | 34.63 | 33.2 | 33.28 | 99014.0 |
| 2026-07-07 | ACIO | ETF | 46.43 | 46.49 | 46.1 | 46.27 | 132695.0 |
| 2026-07-07 | ACLC | ETF | 84.07 | 84.18 | 83.71 | 84.0893 | 4601.0 |
| 2026-07-07 | ACSG | ETF | 49.18 | 49.61 | 49.18 | 49.3766 | 2999.0 |
| 2026-07-07 | ACT | ETF | 46.0 | 46.34 | 45.18 | 45.5 | 219072.0 |
| 2026-07-07 | ACVF | ETF | 54.09 | 54.09 | 53.6701 | 53.78 | 4062.0 |
| 2026-07-07 | ACWI | ETF | 157.41 | 157.55 | 156.06 | 156.46 | 1342205.0 |
| 2026-07-07 | ACWV | ETF | 122.8 | 123.3399 | 122.57 | 122.67 | 70660.0 |
| 2026-07-07 | ACWX | ETF | 75.655 | 75.84 | 74.9 | 75.14 | 1271671.0 |
| 2026-07-07 | ACYN | ETF | 20.62 | 20.62 | 20.55 | 20.58 | 1822884.0 |
| 2026-07-07 | ADBG | ETF | 3.45 | 3.76 | 3.44 | 3.48 | 9726169.0 |
| 2026-07-07 | ADFI | ETF | 8.47 | 8.4899 | 8.46 | 8.48 | 6056.0 |
| 2026-07-07 | ADIV | ETF | 18.78 | 18.78 | 18.68 | 18.715 | 2227.0 |
| 2026-07-07 | ADME | ETF | 55.74 | 55.74 | 55.485 | 55.6202 | 12868.0 |
| 2026-07-07 | ADPV | ETF | 45.77 | 45.77 | 45.2901 | 45.5874 | 3423.0 |
| 2026-07-07 | ADVE | ETF | 45.64 | 45.64 | 45.4769 | 45.4769 | 871.0 |
| 2026-07-07 | AESR | ETF | 20.2 | 20.2 | 19.89 | 19.99 | 26159.0 |
| 2026-07-07 | AFIF | ETF | 9.419 | 9.43 | 9.3801 | 9.43 | 64968.0 |
| 2026-07-07 | AFIX | ETF | 24.74 | 24.74 | 24.6709 | 24.675 | 1271.0 |
| 2026-07-07 | AFK | ETF | 26.25 | 26.505 | 25.9777 | 26.09 | 15585.0 |
| 2026-07-07 | AFLG | ETF | 43.3 | 43.36 | 43.13 | 43.23 | 99559.0 |
| 2026-07-07 | AFMC | ETF | 40.4 | 40.4 | 39.9401 | 40.07 | 26751.0 |
| 2026-07-07 | AFSC | ETF | 38.0201 | 38.1224 | 38.01 | 38.1224 | 695.0 |
| 2026-07-07 | AFSM | ETF | 39.9 | 40.11 | 39.85 | 39.9339 | 8004.0 |
| 2026-07-07 | AGEM | ETF | 47.98 | 48.2621 | 47.8299 | 47.9856 | 7955.0 |
| 2026-07-07 | AGG | ETF | 98.46 | 98.49 | 98.16 | 98.21 | 9137277.0 |
> showing 50 of 4,256 rows — these rows as CSV