PREVIEW / etf_daily / 2022-07-11
file: by_date/etf_daily/2022/2022-07-11.parquet size: 102 KB rows: 2,743
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-07-11 | SPY | ETF | 385.85 | 386.87 | 383.5 | 384.23 | 58366900.0 |
| 2022-07-11 | QQQ | ETF | 292.88 | 293.11 | 288.14 | 289.04 | 55273920.0 |
| 2022-07-11 | IWM | ETF | 174.26 | 174.97 | 171.6 | 172.06 | 22031500.0 |
| 2022-07-11 | DIA | ETF | 311.66 | 313.74 | 311.17 | 311.7 | 2633200.0 |
| 2022-07-11 | GLD | ETF | 161.93 | 162.44 | 161.38 | 161.43 | 4321700.0 |
| 2022-07-11 | TLT | ETF | 113.79 | 114.79 | 113.7 | 114.44 | 13639900.0 |
| 2022-07-11 | AAA | ETF | 24.295 | 24.295 | 24.295 | 24.295 | 0.0 |
| 2022-07-11 | AAAU | ETF | 17.25 | 17.31 | 17.19 | 17.19 | 1072900.0 |
| 2022-07-11 | AADR | ETF | 47.64 | 47.75 | 47.62 | 47.74 | 4400.0 |
| 2022-07-11 | AAXJ | ETF | 67.71 | 67.74 | 67.01 | 67.24 | 799100.0 |
| 2022-07-11 | ABEQ | ETF | 26.54 | 26.9 | 26.54 | 26.805 | 14600.0 |
| 2022-07-11 | ACES | ETF | 52.06 | 52.06 | 49.72 | 49.8 | 57000.0 |
| 2022-07-11 | ACIO | ETF | 29.15 | 29.26 | 29.105 | 29.11 | 21300.0 |
| 2022-07-11 | ACSI | ETF | 43.04 | 43.04 | 43.04 | 43.04 | 25.0 |
| 2022-07-11 | ACT | ETF | 21.58 | 21.93 | 21.58 | 21.88 | 106017.0 |
| 2022-07-11 | ACTV | ETF | 30.8 | 30.8 | 30.5357 | 30.5357 | 3609.0 |
| 2022-07-11 | ACTX | ETF | 0.8 | 0.8 | 0.78 | 0.8 | 1743.0 |
| 2022-07-11 | ACVF | ETF | 29.01 | 29.095 | 28.967 | 28.967 | 2400.0 |
| 2022-07-11 | ACWF | ETF | 31.095 | 31.2601 | 31.04 | 31.0794 | 30992.0 |
| 2022-07-11 | ACWI | ETF | 84.68 | 84.77 | 84.09 | 84.24 | 4357500.0 |
| 2022-07-11 | ACWV | ETF | 95.03 | 95.67 | 95.03 | 95.19 | 184100.0 |
| 2022-07-11 | ACWX | ETF | 44.25 | 44.29 | 43.98 | 44.03 | 2352113.0 |
| 2022-07-11 | ADFI | ETF | 8.52 | 8.54 | 8.52 | 8.536 | 18500.0 |
| 2022-07-11 | ADIV | ETF | 13.75 | 13.8 | 13.715 | 13.715 | 1400.0 |
| 2022-07-11 | ADME | ETF | 34.87 | 35.041 | 34.843 | 34.89 | 19100.0 |
| 2022-07-11 | ADRE | ETF | 38.48 | 38.48 | 38.05 | 38.13 | 3316.0 |
| 2022-07-11 | AEMB | ETF | 36.975 | 36.975 | 36.975 | 36.975 | 100.0 |
| 2022-07-11 | AESR | ETF | 11.22 | 11.28 | 11.2 | 11.24 | 19500.0 |
| 2022-07-11 | AFIF | ETF | 8.88 | 8.88 | 8.85 | 8.85 | 9224.0 |
| 2022-07-11 | AFK | ETF | 16.69 | 16.8 | 16.64 | 16.64 | 17567.0 |
| 2022-07-11 | AFLG | ETF | 22.985 | 22.994 | 22.922 | 22.922 | 7700.0 |
| 2022-07-11 | AFMC | ETF | 21.26 | 21.32 | 21.197 | 21.197 | 500.0 |
| 2022-07-11 | AFSM | ETF | 22.105 | 22.105 | 21.983 | 21.983 | 100.0 |
| 2022-07-11 | AFTY | ETF | 18.23 | 18.34 | 18.23 | 18.302 | 2100.0 |
| 2022-07-11 | AGG | ETF | 101.67 | 101.92 | 101.6 | 101.7 | 5758400.0 |
| 2022-07-11 | AGGY | ETF | 44.97 | 45.02 | 44.73 | 44.89 | 136100.0 |
| 2022-07-11 | AGNG | ETF | 25.64 | 25.82 | 25.64 | 25.65 | 4000.0 |
| 2022-07-11 | AGOV | ETF | 79.03 | 80.2 | 78.81 | 79.3178 | 4303.0 |
| 2022-07-11 | AGOX | ETF | 20.34 | 20.427 | 20.24 | 20.26 | 60300.0 |
| 2022-07-11 | AGQ | ETF | 21.94 | 22.19 | 21.6 | 21.63 | 554000.0 |
| 2022-07-11 | AGZ | ETF | 109.85 | 110.11 | 109.85 | 110.02 | 13441.0 |
| 2022-07-11 | AGZD | ETF | 22.95 | 22.985 | 22.88 | 22.95 | 61800.0 |
| 2022-07-11 | AHHX | ETF | 8.48 | 8.51 | 8.42 | 8.47 | 2941.0 |
| 2022-07-11 | AHYB | ETF | 43.095 | 43.1 | 43.095 | 43.1 | 200.0 |
| 2022-07-11 | AIA | ETF | 60.94 | 60.94 | 60.22 | 60.4 | 62365.0 |
| 2022-07-11 | AIEQ | ETF | 32.52 | 32.52 | 31.58 | 31.58 | 15000.0 |
| 2022-07-11 | AIQ | ETF | 21.39 | 21.39 | 21.06 | 21.07 | 14903.0 |
| 2022-07-11 | AIRR | ETF | 37.571 | 37.67 | 37.408 | 37.455 | 9800.0 |
| 2022-07-11 | AIVI | ETF | 34.51 | 34.69 | 34.51 | 34.52 | 500.0 |
| 2022-07-11 | AIVL | ETF | 89.55 | 89.55 | 89.15 | 89.22 | 5200.0 |
> showing 50 of 2,743 rows — these rows as CSV