PREVIEW / etf_daily / 2022-02-16
file: by_date/etf_daily/2022/2022-02-16.parquet size: 97 KB rows: 2,605
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-16 | SPY | ETF | 443.93 | 448.06 | 441.94 | 446.6 | 84863600.0 |
| 2022-02-16 | QQQ | ETF | 353.82 | 357.0896 | 350.71 | 356.04 | 58947086.0 |
| 2022-02-16 | IWM | ETF | 205.3 | 207.27 | 204.08 | 206.49 | 30104800.0 |
| 2022-02-16 | DIA | ETF | 348.76 | 350.72 | 346.71 | 349.67 | 4496500.0 |
| 2022-02-16 | GLD | ETF | 173.49 | 174.86 | 173.48 | 174.86 | 12772100.0 |
| 2022-02-16 | TLT | ETF | 135.95 | 136.07 | 134.51 | 135.78 | 16473700.0 |
| 2022-02-16 | AAA | ETF | 25.0 | 25.0001 | 25.0 | 25.0 | 529.0 |
| 2022-02-16 | AAAU | ETF | 18.46 | 18.61 | 18.46 | 18.6 | 192400.0 |
| 2022-02-16 | AADR | ETF | 62.63 | 62.86 | 62.31 | 62.86 | 1900.0 |
| 2022-02-16 | AAXJ | ETF | 82.09 | 83.05 | 82.07 | 82.76 | 1201700.0 |
| 2022-02-16 | ABEQ | ETF | 28.655 | 28.87 | 28.648 | 28.806 | 5700.0 |
| 2022-02-16 | ACES | ETF | 53.06 | 53.67 | 52.725 | 53.53 | 26700.0 |
| 2022-02-16 | ACIO | ETF | 31.48 | 31.48 | 31.1 | 31.33 | 42000.0 |
| 2022-02-16 | ACSI | ETF | 49.55 | 50.0323 | 49.55 | 50.0323 | 148.0 |
| 2022-02-16 | ACT | ETF | 22.16 | 23.09 | 22.1 | 22.63 | 140543.0 |
| 2022-02-16 | ACTV | ETF | 35.87 | 36.12 | 35.81 | 36.09 | 6172.0 |
| 2022-02-16 | ACVF | ETF | 33.165 | 33.434 | 33.149 | 33.434 | 3200.0 |
| 2022-02-16 | ACWF | ETF | 37.21 | 37.5239 | 37.195 | 37.495 | 11622.0 |
| 2022-02-16 | ACWI | ETF | 100.58 | 101.47 | 100.32 | 101.25 | 2676200.0 |
| 2022-02-16 | ACWV | ETF | 102.24 | 102.91 | 101.96 | 102.73 | 298800.0 |
| 2022-02-16 | ACWX | ETF | 54.62 | 55.16 | 54.6 | 55.04 | 2747059.0 |
| 2022-02-16 | ADFI | ETF | 9.18 | 9.19 | 9.16 | 9.18 | 5500.0 |
| 2022-02-16 | ADIV | ETF | 16.7 | 16.7 | 16.665 | 16.665 | 400.0 |
| 2022-02-16 | ADME | ETF | 41.12 | 41.12 | 40.715 | 40.97 | 30100.0 |
| 2022-02-16 | ADRE | ETF | 47.4 | 47.6565 | 47.3513 | 47.6565 | 3932.0 |
| 2022-02-16 | AESR | ETF | 13.16 | 13.27 | 13.16 | 13.254 | 6000.0 |
| 2022-02-16 | AFIF | ETF | 9.39 | 9.39 | 9.35 | 9.38 | 21392.0 |
| 2022-02-16 | AFK | ETF | 21.22 | 21.5195 | 21.22 | 21.4841 | 10584.0 |
| 2022-02-16 | AFLG | ETF | 26.04 | 26.28 | 25.99 | 26.236 | 600.0 |
| 2022-02-16 | AFSM | ETF | 25.75 | 25.776 | 25.633 | 25.776 | 1200.0 |
| 2022-02-16 | AFTY | ETF | 20.06 | 20.164 | 20.06 | 20.164 | 400.0 |
| 2022-02-16 | AGG | ETF | 109.44 | 109.48 | 109.1 | 109.41 | 8116000.0 |
| 2022-02-16 | AGGY | ETF | 49.12 | 49.12 | 48.951 | 49.03 | 121600.0 |
| 2022-02-16 | AGNG | ETF | 26.82 | 27.09 | 26.82 | 27.081 | 7500.0 |
| 2022-02-16 | AGOV | ETF | 96.4 | 96.4 | 96.2774 | 96.2774 | 1606.0 |
| 2022-02-16 | AGOX | ETF | 24.46 | 24.46 | 24.035 | 24.07 | 129400.0 |
| 2022-02-16 | AGQ | ETF | 34.54 | 35.35 | 34.54 | 35.3 | 965800.0 |
| 2022-02-16 | AGZ | ETF | 114.51 | 114.6 | 114.4301 | 114.6 | 50339.0 |
| 2022-02-16 | AGZD | ETF | 23.215 | 23.27 | 23.2 | 23.2 | 28200.0 |
| 2022-02-16 | AHHX | ETF | 9.63 | 9.69 | 9.62 | 9.6798 | 1516.0 |
| 2022-02-16 | AIA | ETF | 77.48 | 78.63 | 77.48 | 78.37 | 104810.0 |
| 2022-02-16 | AIEQ | ETF | 36.686 | 37.19 | 36.626 | 37.06 | 6000.0 |
| 2022-02-16 | AIQ | ETF | 28.04 | 28.25 | 27.79 | 28.17 | 47384.0 |
| 2022-02-16 | AIRR | ETF | 42.58 | 43.07 | 42.314 | 42.84 | 20600.0 |
| 2022-02-16 | AIVI | ETF | 43.0 | 43.33 | 42.98 | 43.24 | 9500.0 |
| 2022-02-16 | AIVL | ETF | 98.71 | 99.29 | 98.35 | 99.13 | 11300.0 |
| 2022-02-16 | ALTL | ETF | 43.45 | 43.68 | 43.15 | 43.57 | 59889.0 |
| 2022-02-16 | ALTY | ETF | 12.803 | 12.88 | 12.76 | 12.88 | 15700.0 |
| 2022-02-16 | AMAX | ETF | 9.38 | 9.38 | 9.24 | 9.251 | 5600.0 |
| 2022-02-16 | AMJ | ETF | 20.58 | 20.975 | 20.49 | 20.49 | 768004.0 |
> showing 50 of 2,605 rows — these rows as CSV