PREVIEW / etf_daily / 2026-01-07
file: by_date/etf_daily/2026/2026-01-07.parquet size: 166 KB rows: 4,395
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-01-07 | SPY | ETF | 692.19 | 693.96 | 689.32 | 689.58 | 75447581.0 |
| 2026-01-07 | QQQ | ETF | 623.04 | 627.94 | 622.56 | 624.02 | 44880339.0 |
| 2026-01-07 | IWM | ETF | 256.4 | 256.795 | 253.97 | 255.48 | 33000315.0 |
| 2026-01-07 | DIA | ETF | 495.65 | 496.25 | 489.5 | 489.96 | 5601908.0 |
| 2026-01-07 | GLD | ETF | 408.63 | 410.81 | 406.65 | 409.23 | 10674151.0 |
| 2026-01-07 | TLT | ETF | 87.84 | 88.005 | 87.48 | 87.79 | 39925232.0 |
| 2026-01-07 | AAA | ETF | 24.9999 | 25.0 | 24.93 | 24.955 | 14394.0 |
| 2026-01-07 | AAAU | ETF | 43.86 | 44.0906 | 43.66 | 43.95 | 1858767.0 |
| 2026-01-07 | AADR | ETF | 90.46 | 90.46 | 88.88 | 89.275 | 1896.0 |
| 2026-01-07 | AAPB | ETF | 29.7 | 29.9 | 29.19 | 29.2762 | 156972.0 |
| 2026-01-07 | AAPD | ETF | 13.53 | 13.72 | 13.53 | 13.7 | 3235770.0 |
| 2026-01-07 | AAPR | ETF | 28.43 | 28.465 | 28.43 | 28.465 | 364.0 |
| 2026-01-07 | AAPU | ETF | 31.435 | 31.5475 | 30.61 | 30.76 | 2113731.0 |
| 2026-01-07 | AAPW | ETF | 38.83 | 38.83 | 37.98 | 38.3 | 13149.0 |
| 2026-01-07 | AAPX | ETF | 28.43 | 28.57 | 27.74 | 27.82 | 91388.0 |
| 2026-01-07 | AAPY | ETF | 24.02 | 24.04 | 23.8334 | 23.8334 | 4739.0 |
| 2026-01-07 | AAVM | ETF | 30.52 | 30.52 | 30.43 | 30.47 | 3278.0 |
| 2026-01-07 | AAXJ | ETF | 97.55 | 97.595 | 97.12 | 97.18 | 636739.0 |
| 2026-01-07 | ABCS | ETF | 31.23 | 31.23 | 31.0354 | 31.0354 | 3198.0 |
| 2026-01-07 | ABEQ | ETF | 36.18 | 36.18 | 35.984 | 36.05 | 7953.0 |
| 2026-01-07 | ABFL | ETF | 72.97 | 73.12 | 72.85 | 72.9 | 19702.0 |
| 2026-01-07 | ABLD | ETF | 29.98 | 29.98 | 29.62 | 29.6468 | 1999.0 |
| 2026-01-07 | ABLG | ETF | 32.49 | 32.49 | 32.46 | 32.4702 | 1411.0 |
| 2026-01-07 | ABNY | ETF | 47.54 | 47.675 | 47.28 | 47.28 | 3795.0 |
| 2026-01-07 | ABOT | ETF | 39.4713 | 39.4713 | 39.4713 | 39.4713 | 13.0 |
| 2026-01-07 | ABXB | ETF | 19.63 | 19.63 | 19.6058 | 19.6058 | 754.0 |
| 2026-01-07 | ACES | ETF | 34.47 | 34.47 | 33.7 | 33.86 | 67061.0 |
| 2026-01-07 | ACGR | ETF | 66.74 | 67.1284 | 66.6849 | 66.6849 | 338.0 |
| 2026-01-07 | ACIO | ETF | 44.05 | 44.19 | 43.9201 | 43.97 | 174961.0 |
| 2026-01-07 | ACLC | ETF | 79.33 | 79.46 | 79.0004 | 79.0004 | 11779.0 |
| 2026-01-07 | ACSI | ETF | 67.3314 | 67.3314 | 67.3314 | 67.3314 | 48.0 |
| 2026-01-07 | ACVF | ETF | 50.3 | 50.33 | 50.0554 | 50.0554 | 5560.0 |
| 2026-01-07 | ACWI | ETF | 144.23 | 144.49 | 143.73 | 143.81 | 2905636.0 |
| 2026-01-07 | ACWV | ETF | 119.37 | 119.54 | 118.71 | 118.84 | 139593.0 |
| 2026-01-07 | ACWX | ETF | 69.0 | 69.0 | 68.69 | 68.75 | 2657464.0 |
| 2026-01-07 | ADBG | ETF | 9.41 | 9.74 | 9.3 | 9.5 | 410094.0 |
| 2026-01-07 | ADFI | ETF | 8.6 | 8.61 | 8.59 | 8.6 | 27865.0 |
| 2026-01-07 | ADIV | ETF | 18.53 | 18.57 | 18.41 | 18.42 | 102056.0 |
| 2026-01-07 | ADME | ETF | 51.88 | 52.0351 | 51.7168 | 51.73 | 11152.0 |
| 2026-01-07 | ADPV | ETF | 44.8416 | 45.02 | 44.69 | 44.8 | 7385.0 |
| 2026-01-07 | ADVE | ETF | 40.51 | 40.51 | 40.15 | 40.226 | 6392.0 |
| 2026-01-07 | AESR | ETF | 17.45 | 17.47 | 17.3478 | 17.375 | 40039.0 |
| 2026-01-07 | AETH | ETF | 36.5707 | 36.59 | 36.2948 | 36.2948 | 1119.0 |
| 2026-01-07 | AFIF | ETF | 9.4058 | 9.45 | 9.4058 | 9.44 | 150321.0 |
| 2026-01-07 | AFIX | ETF | 25.16 | 25.19 | 25.155 | 25.155 | 8083.0 |
| 2026-01-07 | AFK | ETF | 27.85 | 27.85 | 27.02 | 27.4 | 99717.0 |
| 2026-01-07 | AFLG | ETF | 39.92 | 39.92 | 39.68 | 39.74 | 68500.0 |
| 2026-01-07 | AFMC | ETF | 35.86 | 35.86 | 35.28 | 35.43 | 13017.0 |
| 2026-01-07 | AFSC | ETF | 31.4017 | 31.5891 | 31.4017 | 31.5891 | 819.0 |
| 2026-01-07 | AFSM | ETF | 33.535 | 33.8 | 33.535 | 33.77 | 16026.0 |
> showing 50 of 4,395 rows — these rows as CSV