PREVIEW / etf_daily / 2024-11-27
file: by_date/etf_daily/2024/2024-11-27.parquet size: 145 KB rows: 3,779
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-27 | SPY | ETF | 600.46 | 600.85 | 597.28 | 598.83 | 33664591.0 |
| 2024-11-27 | QQQ | ETF | 508.17 | 508.24 | 501.93 | 505.3 | 24957441.0 |
| 2024-11-27 | IWM | ETF | 242.01 | 243.69 | 240.44 | 240.95 | 19392909.0 |
| 2024-11-27 | DIA | ETF | 449.18 | 450.64 | 447.37 | 447.74 | 2815644.0 |
| 2024-11-27 | GLD | ETF | 244.85 | 245.1835 | 243.2 | 243.49 | 6597684.0 |
| 2024-11-27 | TLT | ETF | 93.04 | 93.38 | 92.67 | 93.01 | 39333141.0 |
| 2024-11-27 | AAA | ETF | 25.2199 | 25.22 | 25.1 | 25.16 | 7992.0 |
| 2024-11-27 | AAAU | ETF | 26.225 | 26.255 | 26.04 | 26.07 | 2032962.0 |
| 2024-11-27 | AADR | ETF | 67.93 | 67.93 | 67.87 | 67.87 | 1007.0 |
| 2024-11-27 | AAPB | ETF | 30.0181 | 30.14 | 29.7401 | 30.05 | 57863.0 |
| 2024-11-27 | AAPD | ETF | 16.39 | 16.4601 | 16.3479 | 16.39 | 130506.0 |
| 2024-11-27 | AAPR | ETF | 26.39 | 26.4142 | 26.37 | 26.3969 | 3452.0 |
| 2024-11-27 | AAPU | ETF | 37.87 | 38.18 | 37.6 | 37.97 | 360662.0 |
| 2024-11-27 | AAPX | ETF | 34.57 | 34.58 | 34.3101 | 34.4862 | 6271.0 |
| 2024-11-27 | AAPY | ETF | 27.32 | 27.43 | 27.3104 | 27.3666 | 1737.0 |
| 2024-11-27 | AAXJ | ETF | 74.26 | 74.305 | 73.67 | 74.01 | 257572.0 |
| 2024-11-27 | ABCS | ETF | 30.73 | 30.785 | 30.5976 | 30.5976 | 1384.0 |
| 2024-11-27 | ABEQ | ETF | 33.35 | 33.35 | 33.1866 | 33.2 | 1366.0 |
| 2024-11-27 | ABNY | ETF | 80.649 | 80.649 | 79.3 | 79.65 | 2300.0 |
| 2024-11-27 | ACES | ETF | 27.75 | 28.265 | 27.75 | 27.95 | 12837.0 |
| 2024-11-27 | ACIO | ETF | 40.97 | 40.98 | 40.82 | 40.87 | 244078.0 |
| 2024-11-27 | ACSI | ETF | 62.1678 | 62.1678 | 62.1678 | 62.1678 | 4.0 |
| 2024-11-27 | ACT | ETF | 35.35 | 35.59 | 35.075 | 35.26 | 184818.0 |
| 2024-11-27 | ACTV | ETF | 34.18 | 34.21 | 34.13 | 34.14 | 7602.0 |
| 2024-11-27 | ACVF | ETF | 45.86 | 45.86 | 45.6 | 45.6521 | 4553.0 |
| 2024-11-27 | ACWI | ETF | 121.17 | 121.42 | 120.63 | 120.95 | 1260800.0 |
| 2024-11-27 | ACWV | ETF | 115.02 | 115.4 | 115.02 | 115.11 | 79127.0 |
| 2024-11-27 | ACWX | ETF | 53.94 | 54.0347 | 53.815 | 53.93 | 802207.0 |
| 2024-11-27 | ADFI | ETF | 8.54 | 8.58 | 8.53 | 8.55 | 15355.0 |
| 2024-11-27 | ADIV | ETF | 15.56 | 15.56 | 15.52 | 15.525 | 1551.0 |
| 2024-11-27 | ADME | ETF | 47.95 | 47.95 | 47.67 | 47.6784 | 126521.0 |
| 2024-11-27 | ADPV | ETF | 37.95 | 37.95 | 37.55 | 37.77 | 13649.0 |
| 2024-11-27 | ADVE | ETF | 34.0931 | 34.0931 | 34.0931 | 34.0931 | 91.0 |
| 2024-11-27 | AESR | ETF | 17.69 | 17.7 | 17.62 | 17.69 | 16818.0 |
| 2024-11-27 | AETH | ETF | 44.45 | 46.28 | 44.45 | 46.2745 | 29432.0 |
| 2024-11-27 | AFIF | ETF | 9.16 | 9.19 | 9.16 | 9.16 | 9609.0 |
| 2024-11-27 | AFK | ETF | 16.13 | 16.13 | 15.94 | 16.05 | 13259.0 |
| 2024-11-27 | AFLG | ETF | 36.05 | 36.05 | 35.92 | 35.96 | 24126.0 |
| 2024-11-27 | AFMC | ETF | 34.76 | 34.76 | 34.5402 | 34.5402 | 4822.0 |
| 2024-11-27 | AFSM | ETF | 33.01 | 33.01 | 32.7999 | 32.7999 | 19754.0 |
| 2024-11-27 | AGG | ETF | 98.8 | 98.9299 | 98.65 | 98.81 | 8709915.0 |
| 2024-11-27 | AGGH | ETF | 20.91 | 20.91 | 20.7901 | 20.88 | 36874.0 |
| 2024-11-27 | AGGS | ETF | 41.5227 | 41.5227 | 41.5227 | 41.5227 | 0.0 |
| 2024-11-27 | AGGY | ETF | 43.69 | 43.77 | 43.63 | 43.74 | 64891.0 |
| 2024-11-27 | AGIH | ETF | 24.702 | 24.702 | 24.702 | 24.702 | 4.0 |
| 2024-11-27 | AGIX | ETF | 28.14 | 28.18 | 27.9429 | 28.0206 | 6321.0 |
| 2024-11-27 | AGMI | ETF | 27.3103 | 27.3103 | 27.3103 | 27.3103 | 11.0 |
| 2024-11-27 | AGNG | ETF | 31.7885 | 31.7885 | 31.7885 | 31.7885 | 467.0 |
| 2024-11-27 | AGOX | ETF | 29.83 | 29.83 | 29.15 | 29.41 | 16675.0 |
| 2024-11-27 | AGQ | ETF | 37.73 | 37.9251 | 36.56 | 36.89 | 1650852.0 |
> showing 50 of 3,779 rows — these rows as CSV