PREVIEW / etf_daily / 2024-11-26
file: by_date/etf_daily/2024/2024-11-26.parquet size: 144 KB rows: 3,789
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-26 | SPY | ETF | 598.8 | 601.33 | 598.07 | 600.65 | 45269712.0 |
| 2024-11-26 | QQQ | ETF | 508.08 | 510.14 | 507.23 | 509.31 | 26557061.0 |
| 2024-11-26 | IWM | ETF | 241.18 | 241.6068 | 239.429 | 240.62 | 22149414.0 |
| 2024-11-26 | DIA | ETF | 446.56 | 449.33 | 444.66 | 448.88 | 4002813.0 |
| 2024-11-26 | GLD | ETF | 242.71 | 243.09 | 241.58 | 242.95 | 4766506.0 |
| 2024-11-26 | TLT | ETF | 92.16 | 92.44 | 91.81 | 92.37 | 30300555.0 |
| 2024-11-26 | AAA | ETF | 25.19 | 25.22 | 25.12 | 25.195 | 8980.0 |
| 2024-11-26 | AAAU | ETF | 26.0 | 26.03 | 25.87 | 26.015 | 2408291.0 |
| 2024-11-26 | AADR | ETF | 67.66 | 67.66 | 67.66 | 67.66 | 29.0 |
| 2024-11-26 | AAPB | ETF | 29.72 | 30.1599 | 29.67 | 30.08 | 63650.0 |
| 2024-11-26 | AAPD | ETF | 16.46 | 16.4606 | 16.3399 | 16.38 | 199704.0 |
| 2024-11-26 | AAPR | ETF | 26.37 | 26.425 | 26.37 | 26.425 | 20156.0 |
| 2024-11-26 | AAPU | ETF | 37.54 | 38.1507 | 37.54 | 37.97 | 398582.0 |
| 2024-11-26 | AAPX | ETF | 34.02 | 34.7052 | 34.02 | 34.58 | 9978.0 |
| 2024-11-26 | AAPY | ETF | 27.43 | 27.43 | 27.32 | 27.3421 | 1261.0 |
| 2024-11-26 | AAXJ | ETF | 74.02 | 74.02 | 73.51 | 73.63 | 510791.0 |
| 2024-11-26 | ABCS | ETF | 30.638 | 30.64 | 30.54 | 30.5951 | 1215.0 |
| 2024-11-26 | ABEQ | ETF | 32.9659 | 33.0975 | 32.95 | 33.07 | 9123.0 |
| 2024-11-26 | ABNY | ETF | 79.7 | 81.15 | 79.7 | 80.0 | 3513.0 |
| 2024-11-26 | ACES | ETF | 27.96 | 27.96 | 27.5301 | 27.54 | 33738.0 |
| 2024-11-26 | ACIO | ETF | 40.83 | 41.02 | 40.7901 | 41.01 | 65585.0 |
| 2024-11-26 | ACSI | ETF | 62.1999 | 62.1999 | 62.1999 | 62.1999 | 15.0 |
| 2024-11-26 | ACT | ETF | 35.15 | 35.275 | 34.69 | 35.25 | 209426.0 |
| 2024-11-26 | ACTV | ETF | 33.99 | 33.99 | 33.71 | 33.96 | 36051.0 |
| 2024-11-26 | ACVF | ETF | 45.85 | 45.8621 | 45.6515 | 45.8621 | 19621.0 |
| 2024-11-26 | ACWI | ETF | 121.04 | 121.19 | 120.61 | 121.04 | 1582175.0 |
| 2024-11-26 | ACWV | ETF | 114.27 | 114.773 | 114.085 | 114.63 | 59126.0 |
| 2024-11-26 | ACWX | ETF | 53.89 | 53.89 | 53.57 | 53.69 | 795363.0 |
| 2024-11-26 | ADFI | ETF | 8.19 | 8.58 | 8.19 | 8.53 | 31181.0 |
| 2024-11-26 | ADIV | ETF | 15.4066 | 15.4066 | 15.38 | 15.3835 | 2744.0 |
| 2024-11-26 | ADME | ETF | 47.4301 | 47.92 | 47.4301 | 47.915 | 11374.0 |
| 2024-11-26 | ADPV | ETF | 37.7 | 37.85 | 37.49 | 37.7921 | 17251.0 |
| 2024-11-26 | ADVE | ETF | 33.9 | 33.9492 | 33.9 | 33.9492 | 378.0 |
| 2024-11-26 | AESR | ETF | 17.72 | 17.78 | 17.7001 | 17.77 | 26035.0 |
| 2024-11-26 | AETH | ETF | 42.2 | 42.75 | 41.61 | 42.2795 | 13558.0 |
| 2024-11-26 | AFIF | ETF | 9.17 | 9.18 | 9.15 | 9.165 | 11806.0 |
| 2024-11-26 | AFK | ETF | 16.08 | 16.1782 | 16.0 | 16.06 | 6611.0 |
| 2024-11-26 | AFLG | ETF | 35.959 | 36.1673 | 35.93 | 36.16 | 26356.0 |
| 2024-11-26 | AFMC | ETF | 34.88 | 34.88 | 34.425 | 34.7047 | 11187.0 |
| 2024-11-26 | AFSM | ETF | 32.714 | 33.0396 | 32.714 | 32.9158 | 5440.0 |
| 2024-11-26 | AGG | ETF | 98.49 | 98.54 | 98.3 | 98.54 | 11303149.0 |
| 2024-11-26 | AGGH | ETF | 20.78 | 20.83 | 20.77 | 20.83 | 27756.0 |
| 2024-11-26 | AGGS | ETF | 41.3975 | 41.3975 | 41.3975 | 41.3975 | 2.0 |
| 2024-11-26 | AGGY | ETF | 43.57 | 43.59 | 43.48 | 43.57 | 77971.0 |
| 2024-11-26 | AGIH | ETF | 24.64 | 24.64 | 24.64 | 24.64 | 5.0 |
| 2024-11-26 | AGIX | ETF | 28.43 | 28.48 | 28.4 | 28.4651 | 4121.0 |
| 2024-11-26 | AGMI | ETF | 27.36 | 27.36 | 27.2166 | 27.2166 | 800.0 |
| 2024-11-26 | AGNG | ETF | 31.35 | 31.42 | 31.17 | 31.41 | 4433.0 |
| 2024-11-26 | AGOX | ETF | 29.37 | 30.44 | 29.24 | 29.5297 | 33601.0 |
| 2024-11-26 | AGQ | ETF | 37.85 | 37.91 | 37.29 | 37.83 | 842139.0 |
> showing 50 of 3,789 rows — these rows as CSV