PREVIEW / etf_daily / 2022-02-22
file: by_date/etf_daily/2022/2022-02-22.parquet size: 100 KB rows: 2,688
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-22 | SPY | ETF | 431.89 | 435.5 | 425.86 | 429.57 | 124391800.0 |
| 2022-02-22 | QQQ | ETF | 338.49 | 344.04 | 334.35 | 338.08 | 85967095.0 |
| 2022-02-22 | IWM | ETF | 198.48 | 200.45 | 195.35 | 196.66 | 31847100.0 |
| 2022-02-22 | DIA | ETF | 338.79 | 340.26 | 333.58 | 336.01 | 7942700.0 |
| 2022-02-22 | GLD | ETF | 177.67 | 178.07 | 176.82 | 177.49 | 14960500.0 |
| 2022-02-22 | TLT | ETF | 137.69 | 138.67 | 137.47 | 138.59 | 19534000.0 |
| 2022-02-22 | AAA | ETF | 24.995 | 25.0 | 24.995 | 25.0 | 2694.0 |
| 2022-02-22 | AAAU | ETF | 18.92 | 18.95 | 18.83 | 18.89 | 419400.0 |
| 2022-02-22 | AADR | ETF | 60.52 | 61.02 | 59.75 | 59.75 | 3200.0 |
| 2022-02-22 | AAXJ | ETF | 80.23 | 80.67 | 79.65 | 80.06 | 968100.0 |
| 2022-02-22 | ABEQ | ETF | 28.65 | 28.75 | 28.51 | 28.63 | 17100.0 |
| 2022-02-22 | ACES | ETF | 50.2 | 50.761 | 49.0 | 49.4 | 50300.0 |
| 2022-02-22 | ACIO | ETF | 30.65 | 30.849 | 30.39 | 30.51 | 102000.0 |
| 2022-02-22 | ACSI | ETF | 48.1378 | 48.1378 | 48.1378 | 48.1378 | 23.0 |
| 2022-02-22 | ACT | ETF | 21.48 | 21.615 | 20.87 | 21.1 | 120742.0 |
| 2022-02-22 | ACTV | ETF | 34.84 | 35.02 | 34.385 | 34.5154 | 25857.0 |
| 2022-02-22 | ACTX | ETF | 0.8 | 0.8 | 0.8 | 0.8 | 103.0 |
| 2022-02-22 | ACVF | ETF | 32.32 | 32.347 | 32.16 | 32.16 | 5400.0 |
| 2022-02-22 | ACWF | ETF | 36.61 | 36.79 | 36.1906 | 36.3167 | 7940.0 |
| 2022-02-22 | ACWI | ETF | 97.85 | 98.56 | 96.67 | 97.41 | 6770900.0 |
| 2022-02-22 | ACWV | ETF | 101.04 | 101.46 | 100.34 | 100.88 | 225700.0 |
| 2022-02-22 | ACWX | ETF | 53.36 | 53.66 | 52.88 | 53.25 | 4061109.0 |
| 2022-02-22 | ADFI | ETF | 9.17 | 9.17 | 9.16 | 9.166 | 10400.0 |
| 2022-02-22 | ADIV | ETF | 16.4 | 16.41 | 16.273 | 16.307 | 500.0 |
| 2022-02-22 | ADME | ETF | 39.955 | 40.08 | 39.629 | 39.75 | 91200.0 |
| 2022-02-22 | ADRE | ETF | 45.53 | 46.11 | 45.2821 | 45.44 | 7594.0 |
| 2022-02-22 | AEMB | ETF | 45.261 | 45.261 | 45.261 | 45.261 | 100.0 |
| 2022-02-22 | AESR | ETF | 12.8 | 12.89 | 12.682 | 12.76 | 16700.0 |
| 2022-02-22 | AFIF | ETF | 9.36 | 9.38 | 9.36 | 9.365 | 18135.0 |
| 2022-02-22 | AFK | ETF | 20.9 | 21.065 | 20.79 | 20.95 | 12679.0 |
| 2022-02-22 | AFLG | ETF | 25.35 | 25.36 | 25.303 | 25.303 | 200.0 |
| 2022-02-22 | AFMC | ETF | 24.163 | 24.163 | 24.163 | 24.163 | 100.0 |
| 2022-02-22 | AFSM | ETF | 25.13 | 25.13 | 24.708 | 24.708 | 300.0 |
| 2022-02-22 | AFTY | ETF | 19.85 | 19.87 | 19.78 | 19.789 | 2600.0 |
| 2022-02-22 | AGG | ETF | 109.68 | 109.78 | 109.56 | 109.75 | 7604400.0 |
| 2022-02-22 | AGGH | ETF | 25.1499 | 25.15 | 25.0916 | 25.0916 | 371.0 |
| 2022-02-22 | AGGY | ETF | 49.14 | 49.18 | 49.07 | 49.18 | 125500.0 |
| 2022-02-22 | AGNG | ETF | 26.27 | 26.491 | 26.22 | 26.31 | 6200.0 |
| 2022-02-22 | AGOV | ETF | 94.99 | 95.28 | 94.84 | 95.01 | 3066.0 |
| 2022-02-22 | AGOX | ETF | 23.62 | 23.62 | 23.18 | 23.22 | 37700.0 |
| 2022-02-22 | AGQ | ETF | 37.1 | 37.44 | 36.73 | 36.82 | 1116100.0 |
| 2022-02-22 | AGZ | ETF | 114.75 | 114.82 | 114.6466 | 114.74 | 58228.0 |
| 2022-02-22 | AGZD | ETF | 23.115 | 23.145 | 23.11 | 23.12 | 57200.0 |
| 2022-02-22 | AHHX | ETF | 9.77 | 9.77 | 9.6301 | 9.6896 | 6731.0 |
| 2022-02-22 | AHYB | ETF | 47.94 | 47.984 | 47.85 | 47.87 | 1500.0 |
| 2022-02-22 | AIA | ETF | 74.82 | 75.06 | 74.07 | 74.49 | 133251.0 |
| 2022-02-22 | AIEQ | ETF | 35.44 | 35.966 | 35.135 | 35.2 | 13300.0 |
| 2022-02-22 | AIQ | ETF | 26.31 | 26.66 | 25.9501 | 26.15 | 58944.0 |
| 2022-02-22 | AIRR | ETF | 41.51 | 41.799 | 40.87 | 40.91 | 39800.0 |
| 2022-02-22 | AIVI | ETF | 41.84 | 41.99 | 41.65 | 41.69 | 14100.0 |
> showing 50 of 2,688 rows — these rows as CSV