PREVIEW / etf_daily / 2026-01-06
file: by_date/etf_daily/2026/2026-01-06.parquet size: 167 KB rows: 4,394
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-06 | SPY | ETF | 687.93 | 692.315 | 687.78 | 691.81 | 69648868.0 |
| 2026-01-06 | QQQ | ETF | 619.23 | 624.0213 | 618.54 | 623.42 | 43137520.0 |
| 2026-01-06 | IWM | ETF | 252.24 | 256.25 | 251.52 | 256.08 | 40737185.0 |
| 2026-01-06 | DIA | ETF | 489.33 | 495.12 | 488.96 | 494.61 | 6056160.0 |
| 2026-01-06 | GLD | ETF | 410.67 | 413.48 | 410.31 | 413.18 | 11647083.0 |
| 2026-01-06 | TLT | ETF | 87.15 | 87.34 | 86.9 | 87.28 | 39007787.0 |
| 2026-01-06 | AAA | ETF | 24.97 | 25.0 | 24.96 | 25.0 | 7300.0 |
| 2026-01-06 | AAAU | ETF | 44.09 | 44.385 | 44.05 | 44.34 | 1982500.0 |
| 2026-01-06 | AADR | ETF | 90.0 | 90.3199 | 89.375 | 89.375 | 1560.0 |
| 2026-01-06 | AAPB | ETF | 30.8 | 30.91 | 29.73 | 29.76 | 182762.0 |
| 2026-01-06 | AAPD | ETF | 13.35 | 13.6 | 13.335 | 13.58 | 4365716.0 |
| 2026-01-06 | AAPR | ETF | 28.475 | 28.475 | 28.475 | 28.475 | 42.0 |
| 2026-01-06 | AAPU | ETF | 32.32 | 32.465 | 31.185 | 31.22 | 2200384.0 |
| 2026-01-06 | AAPW | ETF | 39.22 | 39.22 | 38.35 | 38.35 | 25821.0 |
| 2026-01-06 | AAPX | ETF | 29.29 | 29.33 | 28.26 | 28.29 | 128306.0 |
| 2026-01-06 | AAPY | ETF | 24.258 | 24.258 | 24.0472 | 24.0472 | 4469.0 |
| 2026-01-06 | AAVM | ETF | 30.52 | 30.5623 | 30.52 | 30.55 | 1347.0 |
| 2026-01-06 | AAXJ | ETF | 97.83 | 98.09 | 97.62 | 97.88 | 631841.0 |
| 2026-01-06 | ABCS | ETF | 31.1442 | 31.38 | 31.1442 | 31.3454 | 2514.0 |
| 2026-01-06 | ABEQ | ETF | 36.085 | 36.3 | 36.049 | 36.2777 | 3508.0 |
| 2026-01-06 | ABFL | ETF | 72.102 | 72.9148 | 72.022 | 72.83 | 16408.0 |
| 2026-01-06 | ABLD | ETF | 29.7101 | 29.91 | 29.7101 | 29.8636 | 2228.0 |
| 2026-01-06 | ABLG | ETF | 32.5411 | 32.6519 | 32.5411 | 32.6519 | 423.0 |
| 2026-01-06 | ABNY | ETF | 46.56 | 47.2 | 46.56 | 47.2 | 2952.0 |
| 2026-01-06 | ABOT | ETF | 39.0436 | 39.0436 | 39.0436 | 39.0436 | 33.0 |
| 2026-01-06 | ABXB | ETF | 19.62 | 19.62 | 19.62 | 19.62 | 88.0 |
| 2026-01-06 | ACES | ETF | 34.16 | 34.5114 | 33.91 | 34.39 | 31468.0 |
| 2026-01-06 | ACGR | ETF | 65.85 | 66.2471 | 65.85 | 66.2471 | 302.0 |
| 2026-01-06 | ACIO | ETF | 43.91 | 44.07 | 43.89 | 44.06 | 123469.0 |
| 2026-01-06 | ACLC | ETF | 78.9 | 79.875 | 78.9 | 79.875 | 7597.0 |
| 2026-01-06 | ACSI | ETF | 67.6649 | 67.6649 | 67.6649 | 67.6649 | 35.0 |
| 2026-01-06 | ACVF | ETF | 49.91 | 50.2935 | 49.91 | 50.2935 | 5150.0 |
| 2026-01-06 | ACVT | ETF | 27.02 | 27.09 | 27.02 | 27.0454 | 18859.0 |
| 2026-01-06 | ACWI | ETF | 143.83 | 144.47 | 143.805 | 144.35 | 3309903.0 |
| 2026-01-06 | ACWV | ETF | 118.86 | 119.43 | 118.81 | 119.25 | 105744.0 |
| 2026-01-06 | ACWX | ETF | 69.14 | 69.255 | 69.02 | 69.14 | 1975367.0 |
| 2026-01-06 | ADBG | ETF | 9.08 | 9.395 | 9.02 | 9.36 | 561572.0 |
| 2026-01-06 | ADFI | ETF | 8.59 | 8.59 | 8.56 | 8.5839 | 33756.0 |
| 2026-01-06 | ADIV | ETF | 18.5399 | 18.5399 | 18.523 | 18.523 | 1295.0 |
| 2026-01-06 | ADME | ETF | 51.73 | 51.93 | 51.67 | 51.9096 | 6473.0 |
| 2026-01-06 | ADPV | ETF | 44.75 | 45.285 | 44.75 | 45.26 | 19520.0 |
| 2026-01-06 | ADVE | ETF | 40.68 | 40.68 | 40.48 | 40.5543 | 4156.0 |
| 2026-01-06 | AESR | ETF | 17.35 | 17.52 | 17.35 | 17.52 | 56177.0 |
| 2026-01-06 | AETH | ETF | 38.03 | 38.03 | 37.12 | 37.5748 | 734.0 |
| 2026-01-06 | AFIF | ETF | 9.4299 | 9.44 | 9.41 | 9.437 | 67648.0 |
| 2026-01-06 | AFIX | ETF | 25.0984 | 25.115 | 25.0699 | 25.115 | 524.0 |
| 2026-01-06 | AFK | ETF | 27.6 | 28.1078 | 27.6 | 27.97 | 110423.0 |
| 2026-01-06 | AFLG | ETF | 39.57 | 39.9001 | 39.57 | 39.885 | 35639.0 |
| 2026-01-06 | AFMC | ETF | 35.4 | 35.75 | 35.185 | 35.75 | 21139.0 |
| 2026-01-06 | AFSC | ETF | 31.3375 | 31.5448 | 31.3375 | 31.5448 | 567.0 |
> showing 50 of 4,394 rows — these rows as CSV