PREVIEW / etf_daily / 2026-01-27
file: by_date/etf_daily/2026/2026-01-27.parquet size: 167 KB rows: 4,384
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-27 | SPY | ETF | 694.18 | 696.53 | 693.57 | 695.49 | 55487877.0 |
| 2026-01-27 | QQQ | ETF | 628.91 | 632.0427 | 627.34 | 631.13 | 38997212.0 |
| 2026-01-27 | IWM | ETF | 264.05 | 264.86 | 262.66 | 264.73 | 26929196.0 |
| 2026-01-27 | DIA | ETF | 490.69 | 491.59 | 488.56 | 490.06 | 5969178.0 |
| 2026-01-27 | GLD | ETF | 465.07 | 476.49 | 463.95 | 476.1 | 28372204.0 |
| 2026-01-27 | TLT | ETF | 88.11 | 88.25 | 87.68 | 87.8 | 35177640.0 |
| 2026-01-27 | AAA | ETF | 25.01 | 25.08 | 25.01 | 25.055 | 3158.0 |
| 2026-01-27 | AAAU | ETF | 49.94 | 51.15 | 49.82 | 51.08 | 7303100.0 |
| 2026-01-27 | AADR | ETF | 96.16 | 96.895 | 96.16 | 96.495 | 861.0 |
| 2026-01-27 | AAPB | ETF | 28.85 | 29.431 | 28.64 | 28.65 | 397928.0 |
| 2026-01-27 | AAPD | ETF | 13.78 | 13.825 | 13.62 | 13.82 | 4803766.0 |
| 2026-01-27 | AAPR | ETF | 28.54 | 28.54 | 28.53 | 28.53 | 6136.0 |
| 2026-01-27 | AAPU | ETF | 30.18 | 30.86 | 30.01 | 30.02 | 3317780.0 |
| 2026-01-27 | AAPW | ETF | 37.76 | 37.77 | 37.2001 | 37.32 | 34013.0 |
| 2026-01-27 | AAPX | ETF | 27.39 | 27.905 | 27.17 | 27.2 | 201517.0 |
| 2026-01-27 | AAPY | ETF | 23.485 | 23.51 | 23.2266 | 23.2266 | 2052.0 |
| 2026-01-27 | AAVM | ETF | 32.04 | 32.2145 | 32.04 | 32.2145 | 1763.0 |
| 2026-01-27 | AAXJ | ETF | 101.4 | 102.0755 | 101.32 | 102.01 | 494885.0 |
| 2026-01-27 | ABCS | ETF | 31.12 | 31.12 | 31.011 | 31.035 | 5421.0 |
| 2026-01-27 | ABEQ | ETF | 37.29 | 37.435 | 37.28 | 37.42 | 10945.0 |
| 2026-01-27 | ABFL | ETF | 73.37 | 73.5199 | 73.06 | 73.41 | 17906.0 |
| 2026-01-27 | ABLD | ETF | 31.43 | 31.607 | 31.43 | 31.607 | 2411.0 |
| 2026-01-27 | ABLG | ETF | 33.04 | 33.1201 | 33.04 | 33.1201 | 917.0 |
| 2026-01-27 | ABNY | ETF | 45.24 | 45.24 | 45.04 | 45.1941 | 2453.0 |
| 2026-01-27 | ABOT | ETF | 37.4245 | 37.4245 | 37.4245 | 37.4245 | 15.0 |
| 2026-01-27 | ABXB | ETF | 19.76 | 19.7904 | 19.76 | 19.7904 | 322.0 |
| 2026-01-27 | ACES | ETF | 36.15 | 36.695 | 35.99 | 36.5 | 19627.0 |
| 2026-01-27 | ACGR | ETF | 66.0862 | 66.0862 | 66.0862 | 66.0862 | 50.0 |
| 2026-01-27 | ACIO | ETF | 43.99 | 44.1 | 43.96 | 44.065 | 132867.0 |
| 2026-01-27 | ACLC | ETF | 79.59 | 79.92 | 79.56 | 79.85 | 11457.0 |
| 2026-01-27 | ACSG | ETF | 42.9 | 43.18 | 42.9 | 42.9438 | 6172.0 |
| 2026-01-27 | ACSI | ETF | 66.9214 | 66.9214 | 66.9214 | 66.9214 | 21.0 |
| 2026-01-27 | ACVF | ETF | 50.27 | 50.4124 | 50.27 | 50.4107 | 2397.0 |
| 2026-01-27 | ACVT | ETF | 27.0614 | 27.0902 | 27.0614 | 27.0902 | 297.0 |
| 2026-01-27 | ACWI | ETF | 146.45 | 147.16 | 146.44 | 147.06 | 3690070.0 |
| 2026-01-27 | ACWV | ETF | 121.09 | 121.36 | 120.55 | 121.36 | 116563.0 |
| 2026-01-27 | ACWX | ETF | 71.52 | 72.05 | 71.52 | 71.97 | 3105411.0 |
| 2026-01-27 | ADBG | ETF | 7.59 | 7.59 | 7.02 | 7.24 | 753177.0 |
| 2026-01-27 | ADFI | ETF | 8.585 | 8.6 | 8.585 | 8.6 | 11286.0 |
| 2026-01-27 | ADIV | ETF | 18.75 | 18.83 | 18.74 | 18.8078 | 3937.0 |
| 2026-01-27 | ADME | ETF | 52.15 | 52.31 | 52.1115 | 52.29 | 9296.0 |
| 2026-01-27 | ADPV | ETF | 45.38 | 45.42 | 45.02 | 45.42 | 7575.0 |
| 2026-01-27 | ADVE | ETF | 42.16 | 42.4488 | 42.16 | 42.4488 | 844.0 |
| 2026-01-27 | AESR | ETF | 17.72 | 17.79 | 17.72 | 17.76 | 21004.0 |
| 2026-01-27 | AETH | ETF | 35.13 | 35.13 | 35.0299 | 35.0299 | 511.0 |
| 2026-01-27 | AFIF | ETF | 9.41 | 9.45 | 9.41 | 9.44 | 37330.0 |
| 2026-01-27 | AFIX | ETF | 25.118 | 25.13 | 25.118 | 25.125 | 577.0 |
| 2026-01-27 | AFK | ETF | 29.45 | 29.73 | 29.21 | 29.55 | 102464.0 |
| 2026-01-27 | AFLG | ETF | 40.3 | 40.46 | 40.23 | 40.41 | 68933.0 |
| 2026-01-27 | AFMC | ETF | 36.32 | 36.32 | 36.07 | 36.16 | 14374.0 |
> showing 50 of 4,384 rows — these rows as CSV