PREVIEW / etf_daily / 2026-01-09
file: by_date/etf_daily/2026/2026-01-09.parquet size: 167 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-09 | SPY | ETF | 690.63 | 695.31 | 689.18 | 694.07 | 79091902.0 |
| 2026-01-09 | QQQ | ETF | 621.41 | 627.89 | 619.06 | 626.65 | 49688734.0 |
| 2026-01-09 | IWM | ETF | 259.58 | 261.56 | 258.09 | 260.23 | 35871751.0 |
| 2026-01-09 | DIA | ETF | 492.86 | 495.66 | 491.91 | 495.02 | 5940660.0 |
| 2026-01-09 | GLD | ETF | 413.215 | 415.29 | 411.8 | 414.47 | 13669158.0 |
| 2026-01-09 | TLT | ETF | 87.3 | 87.99 | 87.12 | 87.93 | 55108027.0 |
| 2026-01-09 | AAA | ETF | 24.92 | 24.95 | 24.92 | 24.945 | 6010.0 |
| 2026-01-09 | AAAU | ETF | 44.36 | 44.57 | 44.2099 | 44.48 | 2012128.0 |
| 2026-01-09 | AADR | ETF | 89.12 | 90.06 | 89.12 | 89.64 | 4206.0 |
| 2026-01-09 | AAPB | ETF | 29.13 | 29.25 | 28.4026 | 29.07 | 174803.0 |
| 2026-01-09 | AAPD | ETF | 13.77 | 13.91 | 13.715 | 13.75 | 4494155.0 |
| 2026-01-09 | AAPR | ETF | 28.4675 | 28.495 | 28.4675 | 28.495 | 705.0 |
| 2026-01-09 | AAPU | ETF | 30.39 | 30.68 | 29.7598 | 30.49 | 2331654.0 |
| 2026-01-09 | AAPW | ETF | 37.9 | 38.0499 | 37.4 | 37.83 | 23585.0 |
| 2026-01-09 | AAPX | ETF | 27.54 | 27.77 | 26.945 | 27.62 | 121768.0 |
| 2026-01-09 | AAPY | ETF | 23.69 | 23.835 | 23.5445 | 23.7614 | 3710.0 |
| 2026-01-09 | AAVM | ETF | 30.92 | 30.92 | 30.92 | 30.92 | 113.0 |
| 2026-01-09 | AAXJ | ETF | 97.4 | 97.655 | 96.89 | 97.61 | 620458.0 |
| 2026-01-09 | ABCS | ETF | 31.3499 | 31.49 | 31.3499 | 31.4775 | 2990.0 |
| 2026-01-09 | ABEQ | ETF | 36.45 | 36.59 | 36.45 | 36.4901 | 6871.0 |
| 2026-01-09 | ABFL | ETF | 72.57 | 72.6099 | 72.36 | 72.56 | 16580.0 |
| 2026-01-09 | ABLD | ETF | 29.98 | 30.2 | 29.98 | 30.19 | 5541.0 |
| 2026-01-09 | ABLG | ETF | 32.49 | 32.49 | 32.4775 | 32.4775 | 4372.0 |
| 2026-01-09 | ABNY | ETF | 46.05 | 47.78 | 46.05 | 47.4363 | 5046.0 |
| 2026-01-09 | ABOT | ETF | 38.6998 | 38.6998 | 38.6998 | 38.6998 | 43.0 |
| 2026-01-09 | ABXB | ETF | 19.62 | 19.635 | 19.62 | 19.635 | 502.0 |
| 2026-01-09 | ACES | ETF | 34.34 | 34.34 | 33.97 | 34.16 | 8626.0 |
| 2026-01-09 | ACGR | ETF | 66.453 | 66.453 | 66.453 | 66.453 | 109.0 |
| 2026-01-09 | ACIO | ETF | 43.94 | 44.2393 | 43.94 | 44.15 | 98445.0 |
| 2026-01-09 | ACLC | ETF | 79.79 | 80.01 | 79.79 | 79.9699 | 4558.0 |
| 2026-01-09 | ACSI | ETF | 68.3302 | 68.3302 | 68.3302 | 68.3302 | 333.0 |
| 2026-01-09 | ACVF | ETF | 50.12 | 50.4 | 50.0509 | 50.31 | 3713.0 |
| 2026-01-09 | ACVT | ETF | 27.12 | 27.13 | 27.0728 | 27.1128 | 400.0 |
| 2026-01-09 | ACWI | ETF | 144.09 | 144.965 | 143.87 | 144.75 | 2243897.0 |
| 2026-01-09 | ACWV | ETF | 119.49 | 119.73 | 119.42 | 119.47 | 99932.0 |
| 2026-01-09 | ACWX | ETF | 68.92 | 69.3 | 68.8853 | 69.25 | 2818386.0 |
| 2026-01-09 | ADBG | ETF | 9.345 | 9.345 | 8.91 | 9.23 | 477102.0 |
| 2026-01-09 | ADFI | ETF | 8.57 | 8.6 | 8.57 | 8.6 | 15031.0 |
| 2026-01-09 | ADIV | ETF | 18.3 | 18.75 | 18.2975 | 18.4834 | 12970.0 |
| 2026-01-09 | ADME | ETF | 51.92 | 52.21 | 51.92 | 52.11 | 3064.0 |
| 2026-01-09 | ADPV | ETF | 45.08 | 45.4016 | 45.02 | 45.2847 | 8231.0 |
| 2026-01-09 | ADVE | ETF | 40.31 | 40.5406 | 40.24 | 40.53 | 2318.0 |
| 2026-01-09 | AESR | ETF | 17.4 | 17.53 | 17.37 | 17.46 | 16790.0 |
| 2026-01-09 | AETH | ETF | 36.25 | 36.25 | 35.4852 | 35.4852 | 462.0 |
| 2026-01-09 | AFIF | ETF | 9.4402 | 9.45 | 9.43 | 9.447 | 52526.0 |
| 2026-01-09 | AFIX | ETF | 25.19 | 25.19 | 25.16 | 25.1875 | 1107.0 |
| 2026-01-09 | AFK | ETF | 27.71 | 27.71 | 27.35 | 27.36 | 51130.0 |
| 2026-01-09 | AFLG | ETF | 39.89 | 40.13 | 39.8 | 40.07 | 37925.0 |
| 2026-01-09 | AFMC | ETF | 35.905 | 36.02 | 35.881 | 35.96 | 25371.0 |
| 2026-01-09 | AFSC | ETF | 32.04 | 32.11 | 31.935 | 32.1019 | 2418.0 |
> showing 50 of 4,395 rows — these rows as CSV