PREVIEW / etf_daily / 2026-07-16
file: by_date/etf_daily/2026/2026-07-16.parquet size: 157 KB rows: 4,160
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-16 | SPY | ETF | 752.76 | 754.57 | 747.88 | 750.72 | 46409814.0 |
| 2026-07-16 | QQQ | ETF | 712.01 | 713.599 | 702.61 | 705.94 | 39402024.0 |
| 2026-07-16 | IWM | ETF | 294.65 | 297.81 | 294.345 | 295.59 | 24081328.0 |
| 2026-07-16 | DIA | ETF | 526.81 | 527.93 | 523.07 | 524.83 | 3173322.0 |
| 2026-07-16 | GLD | ETF | 367.45 | 368.43 | 364.05 | 364.96 | 9048047.0 |
| 2026-07-16 | TLT | ETF | 83.84 | 84.22 | 83.79 | 84.21 | 20817836.0 |
| 2026-07-16 | AAA | ETF | 24.99 | 24.99 | 24.95 | 24.96 | 1899.0 |
| 2026-07-16 | AAAU | ETF | 39.47 | 39.59 | 39.13 | 39.22 | 1051779.0 |
| 2026-07-16 | AADR | ETF | 81.79 | 84.15 | 81.79 | 82.22 | 1157.0 |
| 2026-07-16 | AAOG | ETF | 3.205 | 3.36 | 2.79 | 2.94 | 1616954.0 |
| 2026-07-16 | AAOX | ETF | 14.5 | 15.1499 | 12.48 | 13.18 | 5254177.0 |
| 2026-07-16 | AAPB | ETF | 43.53 | 45.02 | 43.15 | 44.7085 | 57566.0 |
| 2026-07-16 | AAPD | ETF | 10.64 | 10.695 | 10.45 | 10.49 | 16684771.0 |
| 2026-07-16 | AAPR | ETF | 29.52 | 29.5551 | 29.52 | 29.5551 | 511.0 |
| 2026-07-16 | AAPU | ETF | 44.68 | 46.35 | 44.28 | 45.95 | 2659542.0 |
| 2026-07-16 | AAPW | ETF | 42.75 | 43.7999 | 42.75 | 43.53 | 14718.0 |
| 2026-07-16 | AAPX | ETF | 40.29 | 41.71 | 40.09 | 41.43 | 94920.0 |
| 2026-07-16 | AAPY | ETF | 28.075 | 28.3798 | 28.0 | 28.3798 | 6067.0 |
| 2026-07-16 | AAVM | ETF | 33.43 | 33.43 | 33.3071 | 33.3071 | 2894.0 |
| 2026-07-16 | AAXJ | ETF | 112.46 | 112.475 | 110.8319 | 111.31 | 498159.0 |
| 2026-07-16 | ABCS | ETF | 34.57 | 34.7262 | 34.57 | 34.7262 | 1514.0 |
| 2026-07-16 | ABEQ | ETF | 37.36 | 37.45 | 37.32 | 37.42 | 8836.0 |
| 2026-07-16 | ABFL | ETF | 82.28 | 82.94 | 82.25 | 82.61 | 36183.0 |
| 2026-07-16 | ABLD | ETF | 30.13 | 30.23 | 30.12 | 30.1823 | 3847.0 |
| 2026-07-16 | ACES | ETF | 33.04 | 33.07 | 32.19 | 32.38 | 46943.0 |
| 2026-07-16 | ACGR | ETF | 68.61 | 68.61 | 67.9405 | 67.9405 | 128.0 |
| 2026-07-16 | ACIO | ETF | 46.56 | 46.56 | 46.1401 | 46.31 | 157269.0 |
| 2026-07-16 | ACLC | ETF | 85.01 | 85.01 | 84.58 | 84.7581 | 1917.0 |
| 2026-07-16 | ACSG | ETF | 48.5005 | 48.5725 | 48.5 | 48.5725 | 1289.0 |
| 2026-07-16 | ACVF | ETF | 53.695 | 53.8301 | 53.625 | 53.82 | 3575.0 |
| 2026-07-16 | ACVT | ETF | 28.145 | 28.157 | 28.145 | 28.157 | 189.0 |
| 2026-07-16 | ACWI | ETF | 156.45 | 157.055 | 155.79 | 156.36 | 3653192.0 |
| 2026-07-16 | ACWV | ETF | 120.96 | 122.12 | 120.96 | 122.0 | 80040.0 |
| 2026-07-16 | ACWX | ETF | 74.69 | 74.93 | 74.34 | 74.58 | 862708.0 |
| 2026-07-16 | ACYN | ETF | 20.68 | 20.69 | 20.63 | 20.67 | 1910642.0 |
| 2026-07-16 | ADBG | ETF | 3.67 | 3.89 | 3.4735 | 3.88 | 8780180.0 |
| 2026-07-16 | ADFI | ETF | 8.42 | 8.43 | 8.41 | 8.4199 | 23602.0 |
| 2026-07-16 | ADIV | ETF | 18.89 | 19.08 | 18.89 | 19.005 | 5118.0 |
| 2026-07-16 | ADME | ETF | 55.73 | 55.85 | 55.39 | 55.62 | 4860.0 |
| 2026-07-16 | ADPV | ETF | 45.43 | 45.43 | 44.76 | 44.83 | 22559.0 |
| 2026-07-16 | ADVE | ETF | 45.39 | 45.3901 | 45.227 | 45.227 | 230.0 |
| 2026-07-16 | AESR | ETF | 19.96 | 20.0 | 19.75 | 19.8 | 34853.0 |
| 2026-07-16 | AETH | ETF | 30.78 | 30.78 | 30.5685 | 30.5685 | 409.0 |
| 2026-07-16 | AFIF | ETF | 9.41 | 9.43 | 9.41 | 9.42 | 111980.0 |
| 2026-07-16 | AFIX | ETF | 24.655 | 24.6599 | 24.65 | 24.655 | 1602.0 |
| 2026-07-16 | AFK | ETF | 25.6 | 25.79 | 25.335 | 25.75 | 277129.0 |
| 2026-07-16 | AFLG | ETF | 43.79 | 43.9799 | 43.655 | 43.75 | 48937.0 |
| 2026-07-16 | AFMC | ETF | 40.34 | 40.645 | 40.34 | 40.55 | 50616.0 |
| 2026-07-16 | AFSC | ETF | 38.37 | 38.37 | 38.2266 | 38.2266 | 169.0 |
| 2026-07-16 | AFSM | ETF | 40.29 | 40.38 | 39.93 | 40.0013 | 7117.0 |
> showing 50 of 4,160 rows — these rows as CSV