PREVIEW / etf_daily / 2022-05-04
file: by_date/etf_daily/2022/2022-05-04.parquet size: 103 KB rows: 2,726
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-05-04 | SPY | ETF | 417.08 | 429.66 | 413.71 | 429.06 | 144247900.0 |
| 2022-05-04 | QQQ | ETF | 319.31 | 330.29 | 313.891 | 329.6 | 116083395.0 |
| 2022-05-04 | IWM | ETF | 189.05 | 193.93 | 185.69 | 193.52 | 38834700.0 |
| 2022-05-04 | DIA | ETF | 331.8 | 341.17 | 330.2 | 340.59 | 10569700.0 |
| 2022-05-04 | GLD | ETF | 174.32 | 176.35 | 173.67 | 175.8 | 10491700.0 |
| 2022-05-04 | TLT | ETF | 117.97 | 118.97 | 117.35 | 118.62 | 25575700.0 |
| 2022-05-04 | AAA | ETF | 24.7209 | 24.73 | 24.7 | 24.73 | 1107.0 |
| 2022-05-04 | AAAU | ETF | 18.56 | 18.78 | 18.49 | 18.72 | 1766000.0 |
| 2022-05-04 | AADR | ETF | 55.0 | 56.18 | 54.85 | 56.18 | 800.0 |
| 2022-05-04 | AAXJ | ETF | 70.95 | 72.43 | 70.46 | 72.28 | 1919800.0 |
| 2022-05-04 | ABEQ | ETF | 28.67 | 29.22 | 28.66 | 29.22 | 21000.0 |
| 2022-05-04 | ACES | ETF | 52.62 | 55.34 | 52.25 | 55.29 | 36800.0 |
| 2022-05-04 | ACIO | ETF | 29.89 | 30.77 | 29.89 | 30.76 | 89500.0 |
| 2022-05-04 | ACSI | ETF | 46.45 | 47.7653 | 46.45 | 47.7653 | 172.0 |
| 2022-05-04 | ACT | ETF | 24.06 | 24.67 | 22.94 | 24.39 | 485621.0 |
| 2022-05-04 | ACTV | ETF | 33.24 | 33.9 | 32.98 | 33.9 | 17229.0 |
| 2022-05-04 | ACTX | ETF | 0.99 | 0.99 | 0.9 | 0.9 | 420.0 |
| 2022-05-04 | ACVF | ETF | 31.4 | 32.29 | 31.148 | 32.234 | 2600.0 |
| 2022-05-04 | ACWF | ETF | 34.81 | 35.73 | 34.55 | 35.69 | 44173.0 |
| 2022-05-04 | ACWI | ETF | 92.47 | 94.97 | 91.73 | 94.77 | 4135800.0 |
| 2022-05-04 | ACWV | ETF | 99.79 | 101.85 | 99.42 | 101.4 | 152500.0 |
| 2022-05-04 | ACWX | ETF | 48.94 | 49.94 | 48.45 | 49.82 | 6393752.0 |
| 2022-05-04 | ADFI | ETF | 8.695 | 8.765 | 8.695 | 8.765 | 600.0 |
| 2022-05-04 | ADIV | ETF | 14.77 | 15.07 | 14.76 | 15.07 | 1200.0 |
| 2022-05-04 | ADME | ETF | 38.205 | 39.25 | 37.97 | 39.02 | 126100.0 |
| 2022-05-04 | ADRE | ETF | 40.16 | 41.46 | 39.99 | 41.46 | 14508.0 |
| 2022-05-04 | AEMB | ETF | 40.57 | 41.117 | 40.57 | 41.117 | 600.0 |
| 2022-05-04 | AESR | ETF | 12.32 | 12.71 | 12.29 | 12.71 | 10200.0 |
| 2022-05-04 | AFIF | ETF | 9.15 | 9.21 | 9.15 | 9.21 | 8668.0 |
| 2022-05-04 | AFK | ETF | 19.62 | 19.74 | 19.22 | 19.74 | 15839.0 |
| 2022-05-04 | AFLG | ETF | 25.07 | 25.735 | 25.07 | 25.735 | 200.0 |
| 2022-05-04 | AFMC | ETF | 24.279 | 24.279 | 24.279 | 24.279 | 100.0 |
| 2022-05-04 | AFSM | ETF | 24.12 | 24.878 | 24.12 | 24.878 | 100.0 |
| 2022-05-04 | AFTY | ETF | 17.04 | 17.266 | 16.98 | 17.266 | 7000.0 |
| 2022-05-04 | AGG | ETF | 102.32 | 103.05 | 102.12 | 103.02 | 14656400.0 |
| 2022-05-04 | AGGY | ETF | 45.18 | 45.56 | 45.159 | 45.51 | 254800.0 |
| 2022-05-04 | AGNG | ETF | 26.44 | 27.0 | 26.18 | 26.95 | 6100.0 |
| 2022-05-04 | AGOV | ETF | 80.0 | 80.0 | 79.658 | 79.658 | 634.0 |
| 2022-05-04 | AGOX | ETF | 22.195 | 22.81 | 22.016 | 22.81 | 21600.0 |
| 2022-05-04 | AGQ | ETF | 30.77 | 32.57 | 30.16 | 32.48 | 1190500.0 |
| 2022-05-04 | AGZ | ETF | 110.02 | 110.53 | 109.83 | 110.36 | 35259.0 |
| 2022-05-04 | AGZD | ETF | 23.035 | 23.085 | 22.855 | 23.04 | 49600.0 |
| 2022-05-04 | AHHX | ETF | 9.12 | 9.18 | 9.11 | 9.12 | 46475.0 |
| 2022-05-04 | AHYB | ETF | 45.98 | 45.98 | 45.98 | 45.98 | 300.0 |
| 2022-05-04 | AIA | ETF | 64.5 | 65.73 | 63.935 | 65.65 | 242018.0 |
| 2022-05-04 | AIEQ | ETF | 34.198 | 35.215 | 34.053 | 35.215 | 14200.0 |
| 2022-05-04 | AIQ | ETF | 23.54 | 24.34 | 23.18 | 24.33 | 26222.0 |
| 2022-05-04 | AIRR | ETF | 39.286 | 40.458 | 39.05 | 40.337 | 35300.0 |
| 2022-05-04 | AIVI | ETF | 38.8 | 39.59 | 38.76 | 39.51 | 4000.0 |
| 2022-05-04 | AIVL | ETF | 95.36 | 97.98 | 95.36 | 97.87 | 7900.0 |
> showing 50 of 2,726 rows — these rows as CSV