PREVIEW / etf_daily / 2022-02-17
file: by_date/etf_daily/2022/2022-02-17.parquet size: 100 KB rows: 2,656
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 |
|---|---|---|---|---|---|---|---|
| 2022-02-17 | SPY | ETF | 443.22 | 446.57 | 436.42 | 437.06 | 102259100.0 |
| 2022-02-17 | QQQ | ETF | 352.74 | 353.46 | 345.02 | 345.45 | 61801353.0 |
| 2022-02-17 | IWM | ETF | 204.55 | 205.03 | 200.78 | 201.2 | 27140200.0 |
| 2022-02-17 | DIA | ETF | 347.43 | 347.71 | 342.86 | 343.68 | 4433500.0 |
| 2022-02-17 | GLD | ETF | 176.7 | 177.53 | 176.39 | 177.25 | 18612500.0 |
| 2022-02-17 | TLT | ETF | 136.45 | 137.57 | 135.9 | 136.79 | 24508200.0 |
| 2022-02-17 | AAA | ETF | 25.0001 | 25.01 | 25.0001 | 25.01 | 1694.0 |
| 2022-02-17 | AAAU | ETF | 18.81 | 18.89 | 18.78 | 18.88 | 735900.0 |
| 2022-02-17 | AADR | ETF | 61.83 | 62.04 | 61.51 | 61.51 | 1300.0 |
| 2022-02-17 | AAXJ | ETF | 82.59 | 82.8 | 81.89 | 82.01 | 1092000.0 |
| 2022-02-17 | ABEQ | ETF | 28.56 | 28.85 | 28.56 | 28.747 | 5800.0 |
| 2022-02-17 | ACES | ETF | 52.93 | 53.225 | 51.92 | 52.05 | 74100.0 |
| 2022-02-17 | ACIO | ETF | 31.19 | 31.327 | 30.88 | 30.91 | 49700.0 |
| 2022-02-17 | ACSI | ETF | 49.019 | 49.019 | 49.019 | 49.019 | 32.0 |
| 2022-02-17 | ACT | ETF | 22.51 | 22.64 | 21.91 | 22.11 | 84611.0 |
| 2022-02-17 | ACTV | ETF | 35.91 | 35.91 | 35.2 | 35.29 | 13584.0 |
| 2022-02-17 | ACTX | ETF | 0.95 | 0.95 | 0.85 | 0.85 | 254.0 |
| 2022-02-17 | ACVF | ETF | 33.3 | 33.3 | 32.766 | 32.777 | 7400.0 |
| 2022-02-17 | ACWF | ETF | 37.27 | 37.34 | 36.873 | 36.873 | 21565.0 |
| 2022-02-17 | ACWI | ETF | 100.54 | 100.6 | 99.17 | 99.29 | 3720400.0 |
| 2022-02-17 | ACWV | ETF | 102.11 | 102.33 | 101.74 | 101.89 | 144000.0 |
| 2022-02-17 | ACWX | ETF | 54.65 | 54.72 | 54.18 | 54.26 | 2508437.0 |
| 2022-02-17 | ADFI | ETF | 9.22 | 9.22 | 9.181 | 9.195 | 4300.0 |
| 2022-02-17 | ADIV | ETF | 16.57 | 16.57 | 16.448 | 16.448 | 100.0 |
| 2022-02-17 | ADME | ETF | 40.53 | 40.76 | 40.33 | 40.34 | 63600.0 |
| 2022-02-17 | ADRE | ETF | 47.04 | 47.39 | 46.69 | 46.74 | 12649.0 |
| 2022-02-17 | AESR | ETF | 13.16 | 13.24 | 13.052 | 13.08 | 218200.0 |
| 2022-02-17 | AFIF | ETF | 9.3945 | 9.3999 | 9.37 | 9.3799 | 90001.0 |
| 2022-02-17 | AFK | ETF | 21.59 | 21.59 | 21.35 | 21.35 | 5241.0 |
| 2022-02-17 | AFLG | ETF | 25.835 | 25.835 | 25.762 | 25.762 | 200.0 |
| 2022-02-17 | AFMC | ETF | 24.63 | 24.63 | 24.63 | 24.63 | 100.0 |
| 2022-02-17 | AFSM | ETF | 25.53 | 25.53 | 25.178 | 25.178 | 900.0 |
| 2022-02-17 | AFTY | ETF | 20.11 | 20.11 | 20.057 | 20.057 | 400.0 |
| 2022-02-17 | AGG | ETF | 109.58 | 109.81 | 109.51 | 109.64 | 10217000.0 |
| 2022-02-17 | AGGH | ETF | 25.0699 | 25.07 | 25.0548 | 25.0548 | 500.0 |
| 2022-02-17 | AGGY | ETF | 49.1 | 49.22 | 49.072 | 49.14 | 192600.0 |
| 2022-02-17 | AGNG | ETF | 26.61 | 26.725 | 26.529 | 26.529 | 2200.0 |
| 2022-02-17 | AGOV | ETF | 96.21 | 96.2242 | 96.08 | 96.2242 | 742.0 |
| 2022-02-17 | AGOX | ETF | 24.11 | 24.11 | 23.62 | 23.62 | 108700.0 |
| 2022-02-17 | AGQ | ETF | 35.38 | 36.12 | 35.28 | 35.87 | 1184900.0 |
| 2022-02-17 | AGZ | ETF | 114.8002 | 114.84 | 114.56 | 114.76 | 82687.0 |
| 2022-02-17 | AGZD | ETF | 23.215 | 23.295 | 23.165 | 23.22 | 128800.0 |
| 2022-02-17 | AHHX | ETF | 9.64 | 9.75 | 9.63 | 9.6898 | 4368.0 |
| 2022-02-17 | AHYB | ETF | 47.94 | 47.975 | 47.94 | 47.97 | 600.0 |
| 2022-02-17 | AIA | ETF | 78.09 | 78.415 | 77.4 | 77.45 | 33467.0 |
| 2022-02-17 | AIEQ | ETF | 36.84 | 36.84 | 35.89 | 35.89 | 23200.0 |
| 2022-02-17 | AIQ | ETF | 27.94 | 28.01 | 27.24 | 27.3 | 17757.0 |
| 2022-02-17 | AIRR | ETF | 42.48 | 42.56 | 41.962 | 42.08 | 11700.0 |
| 2022-02-17 | AIVI | ETF | 42.86 | 42.87 | 42.69 | 42.69 | 3200.0 |
| 2022-02-17 | AIVL | ETF | 98.69 | 98.69 | 97.59 | 97.74 | 9200.0 |
> showing 50 of 2,656 rows — these rows as CSV