PREVIEW / etf_daily / 2024-11-01
file: by_date/etf_daily/2024/2024-11-01.parquet size: 144 KB rows: 3,764
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-01 | SPY | ETF | 571.32 | 575.55 | 570.62 | 571.04 | 44896620.0 |
| 2024-11-01 | QQQ | ETF | 485.5 | 490.7507 | 485.2 | 487.43 | 33655757.0 |
| 2024-11-01 | IWM | ETF | 219.5 | 220.97 | 218.34 | 218.98 | 21489753.0 |
| 2024-11-01 | DIA | ETF | 419.67 | 423.2996 | 419.31 | 420.42 | 3714060.0 |
| 2024-11-01 | GLD | ETF | 254.33 | 254.86 | 252.435 | 252.47 | 6420690.0 |
| 2024-11-01 | TLT | ETF | 92.26 | 92.515 | 90.8 | 90.84 | 79682053.0 |
| 2024-11-01 | AAA | ETF | 25.0498 | 25.05 | 25.03 | 25.04 | 14783.0 |
| 2024-11-01 | AAAU | ETF | 27.24 | 27.29 | 27.025 | 27.035 | 1445289.0 |
| 2024-11-01 | AADR | ETF | 64.685 | 64.931 | 64.14 | 64.14 | 706.0 |
| 2024-11-01 | AAPB | ETF | 26.6 | 27.6898 | 26.52 | 27.15 | 178684.0 |
| 2024-11-01 | AAPD | ETF | 17.4 | 17.43 | 17.06 | 17.23 | 458052.0 |
| 2024-11-01 | AAPR | ETF | 26.11 | 26.18 | 26.09 | 26.115 | 27749.0 |
| 2024-11-01 | AAPU | ETF | 33.75 | 35.1188 | 33.54 | 34.39 | 811827.0 |
| 2024-11-01 | AAPX | ETF | 30.88 | 31.88 | 30.6 | 31.31 | 29134.0 |
| 2024-11-01 | AAPY | ETF | 26.62 | 26.72 | 26.62 | 26.6676 | 1378.0 |
| 2024-11-01 | AAXJ | ETF | 76.69 | 76.88 | 76.22 | 76.3 | 1236636.0 |
| 2024-11-01 | ABCS | ETF | 28.28 | 28.45 | 28.2255 | 28.2255 | 1404.0 |
| 2024-11-01 | ABEQ | ETF | 32.66 | 32.72 | 32.5765 | 32.5765 | 1519.0 |
| 2024-11-01 | ABNY | ETF | 81.9 | 82.498 | 81.8995 | 82.3885 | 705.0 |
| 2024-11-01 | ACES | ETF | 27.98 | 28.3 | 27.83 | 27.94 | 10344.0 |
| 2024-11-01 | ACIO | ETF | 39.66 | 39.81 | 39.59 | 39.62 | 83047.0 |
| 2024-11-01 | ACSI | ETF | 58.245 | 58.28 | 58.0852 | 58.0852 | 641.0 |
| 2024-11-01 | ACT | ETF | 34.04 | 34.04 | 32.34 | 32.38 | 591077.0 |
| 2024-11-01 | ACTV | ETF | 32.36 | 32.42 | 32.19 | 32.2008 | 3575.0 |
| 2024-11-01 | ACVF | ETF | 43.4466 | 43.73 | 43.4244 | 43.4244 | 2726.0 |
| 2024-11-01 | ACWI | ETF | 117.73 | 118.32 | 117.42 | 117.5 | 1898699.0 |
| 2024-11-01 | ACWV | ETF | 112.23 | 112.52 | 111.96 | 112.01 | 100863.0 |
| 2024-11-01 | ACWX | ETF | 55.01 | 55.04 | 54.6301 | 54.69 | 541519.0 |
| 2024-11-01 | ADFI | ETF | 8.51 | 8.55 | 8.49 | 8.5 | 20812.0 |
| 2024-11-01 | ADIV | ETF | 15.82 | 15.8491 | 15.7582 | 15.7582 | 1079.0 |
| 2024-11-01 | ADME | ETF | 45.9979 | 46.62 | 40.81 | 45.8 | 970251.0 |
| 2024-11-01 | ADPV | ETF | 32.87 | 32.91 | 32.3622 | 32.3622 | 4800.0 |
| 2024-11-01 | ADVE | ETF | 34.5683 | 34.5683 | 34.5683 | 34.5683 | 14.0 |
| 2024-11-01 | AESR | ETF | 17.0 | 17.09 | 16.96 | 16.96 | 18054.0 |
| 2024-11-01 | AETH | ETF | 32.3 | 32.9 | 31.8 | 32.0759 | 6952.0 |
| 2024-11-01 | AFIF | ETF | 9.165 | 9.18 | 9.155 | 9.155 | 6958.0 |
| 2024-11-01 | AFK | ETF | 16.78 | 16.97 | 16.51 | 16.68 | 14218.0 |
| 2024-11-01 | AFLG | ETF | 33.93 | 34.09 | 33.791 | 33.801 | 30213.0 |
| 2024-11-01 | AFMC | ETF | 32.16 | 32.22 | 31.8288 | 31.8288 | 93903.0 |
| 2024-11-01 | AFSM | ETF | 30.49 | 30.54 | 30.18 | 30.24 | 30921.0 |
| 2024-11-01 | AGG | ETF | 98.29 | 98.38 | 97.6801 | 97.72 | 10377196.0 |
| 2024-11-01 | AGGH | ETF | 20.78 | 20.8099 | 20.6 | 20.6 | 70482.0 |
| 2024-11-01 | AGGS | ETF | 41.36 | 41.36 | 41.185 | 41.185 | 500.0 |
| 2024-11-01 | AGGY | ETF | 43.59 | 43.6079 | 43.305 | 43.3199 | 47106.0 |
| 2024-11-01 | AGIH | ETF | 24.5478 | 24.5478 | 24.5478 | 24.5478 | 1.0 |
| 2024-11-01 | AGIX | ETF | 25.892 | 26.1 | 25.892 | 25.985 | 920.0 |
| 2024-11-01 | AGMI | ETF | 31.16 | 31.23 | 30.45 | 30.45 | 351.0 |
| 2024-11-01 | AGNG | ETF | 32.19 | 32.25 | 31.9 | 32.2 | 6774.0 |
| 2024-11-01 | AGOX | ETF | 27.405 | 28.49 | 27.405 | 27.91 | 18876.0 |
| 2024-11-01 | AGQ | ETF | 44.59 | 44.915 | 42.85 | 42.98 | 2160772.0 |
> showing 50 of 3,764 rows — these rows as CSV