PREVIEW / etf_daily / 2022-04-04
file: by_date/etf_daily/2022/2022-04-04.parquet size: 100 KB rows: 2,693
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-04-04 | SPY | ETF | 453.13 | 456.91 | 452.26 | 456.8 | 59601000.0 |
| 2022-04-04 | QQQ | ETF | 362.71 | 369.31 | 362.44 | 369.3 | 45950171.0 |
| 2022-04-04 | IWM | ETF | 207.87 | 208.43 | 205.88 | 207.91 | 20333900.0 |
| 2022-04-04 | DIA | ETF | 347.64 | 349.28 | 346.03 | 349.24 | 3829900.0 |
| 2022-04-04 | GLD | ETF | 180.24 | 180.81 | 179.58 | 180.37 | 7063100.0 |
| 2022-04-04 | TLT | ETF | 131.93 | 131.98 | 130.71 | 131.46 | 13609900.0 |
| 2022-04-04 | AAA | ETF | 24.85 | 24.85 | 24.81 | 24.81 | 1331.0 |
| 2022-04-04 | AAAU | ETF | 19.2 | 19.25 | 19.13 | 19.2 | 1292300.0 |
| 2022-04-04 | AADR | ETF | 60.11 | 60.27 | 60.11 | 60.27 | 1800.0 |
| 2022-04-04 | AAXJ | ETF | 77.38 | 78.01 | 77.07 | 77.92 | 2893100.0 |
| 2022-04-04 | ABEQ | ETF | 29.99 | 30.08 | 29.97 | 30.043 | 10900.0 |
| 2022-04-04 | ACES | ETF | 63.5 | 65.179 | 63.5 | 65.05 | 102000.0 |
| 2022-04-04 | ACIO | ETF | 31.47 | 31.56 | 31.421 | 31.56 | 37400.0 |
| 2022-04-04 | ACSI | ETF | 50.81 | 50.9165 | 50.81 | 50.9165 | 1873.0 |
| 2022-04-04 | ACT | ETF | 22.34 | 23.03 | 21.83 | 21.97 | 49927.0 |
| 2022-04-04 | ACTV | ETF | 36.1 | 36.35 | 36.1 | 36.3181 | 5453.0 |
| 2022-04-04 | ACTX | ETF | 1.0 | 1.0 | 0.98 | 0.98 | 391.0 |
| 2022-04-04 | ACVF | ETF | 34.01 | 34.084 | 33.94 | 34.084 | 7500.0 |
| 2022-04-04 | ACWF | ETF | 37.06 | 37.2349 | 37.06 | 37.2154 | 4679.0 |
| 2022-04-04 | ACWI | ETF | 100.63 | 101.4 | 100.46 | 101.4 | 5179000.0 |
| 2022-04-04 | ACWV | ETF | 106.04 | 106.2 | 105.63 | 106.2 | 186500.0 |
| 2022-04-04 | ACWX | ETF | 52.97 | 53.23 | 52.87 | 53.2 | 2896761.0 |
| 2022-04-04 | ADFI | ETF | 9.02 | 9.045 | 9.02 | 9.045 | 2200.0 |
| 2022-04-04 | ADIV | ETF | 15.75 | 15.88 | 15.75 | 15.88 | 2500.0 |
| 2022-04-04 | ADME | ETF | 40.92 | 41.15 | 40.92 | 41.15 | 27000.0 |
| 2022-04-04 | ADRE | ETF | 45.86 | 46.05 | 45.7469 | 46.05 | 4726.0 |
| 2022-04-04 | AEMB | ETF | 43.755 | 43.755 | 43.755 | 43.755 | 100.0 |
| 2022-04-04 | AESR | ETF | 13.4 | 13.49 | 13.4 | 13.45 | 21200.0 |
| 2022-04-04 | AFIF | ETF | 9.235 | 9.25 | 9.23 | 9.24 | 25143.0 |
| 2022-04-04 | AFK | ETF | 21.89 | 21.89 | 21.644 | 21.69 | 10416.0 |
| 2022-04-04 | AFLG | ETF | 26.74 | 26.84 | 26.74 | 26.825 | 2200.0 |
| 2022-04-04 | AFMC | ETF | 24.68 | 24.68 | 24.656 | 24.656 | 2000.0 |
| 2022-04-04 | AFSM | ETF | 25.73 | 25.79 | 25.712 | 25.712 | 900.0 |
| 2022-04-04 | AFTY | ETF | 18.579 | 18.622 | 18.576 | 18.622 | 2000.0 |
| 2022-04-04 | AGG | ETF | 106.84 | 106.87 | 106.56 | 106.84 | 9956400.0 |
| 2022-04-04 | AGGH | ETF | 21.93 | 24.3529 | 21.93 | 24.3529 | 361.0 |
| 2022-04-04 | AGGY | ETF | 47.81 | 47.89 | 47.69 | 47.89 | 121500.0 |
| 2022-04-04 | AGNG | ETF | 29.01 | 29.09 | 28.95 | 28.97 | 6900.0 |
| 2022-04-04 | AGOV | ETF | 83.17 | 83.475 | 83.17 | 83.475 | 718.0 |
| 2022-04-04 | AGOX | ETF | 24.01 | 24.19 | 24.01 | 24.09 | 18600.0 |
| 2022-04-04 | AGQ | ETF | 37.67 | 38.13 | 36.78 | 37.5 | 675700.0 |
| 2022-04-04 | AGZ | ETF | 111.98 | 112.0055 | 111.85 | 111.93 | 25127.0 |
| 2022-04-04 | AGZD | ETF | 23.285 | 23.325 | 23.265 | 23.285 | 377400.0 |
| 2022-04-04 | AHHX | ETF | 9.44 | 9.55 | 9.42 | 9.42 | 19931.0 |
| 2022-04-04 | AHYB | ETF | 47.535 | 47.685 | 47.535 | 47.685 | 300.0 |
| 2022-04-04 | AIA | ETF | 70.45 | 71.26 | 70.36 | 71.235 | 154520.0 |
| 2022-04-04 | AIEQ | ETF | 36.88 | 37.26 | 36.86 | 37.196 | 14500.0 |
| 2022-04-04 | AIQ | ETF | 27.29 | 27.8 | 27.251 | 27.8 | 9020.0 |
| 2022-04-04 | AIRR | ETF | 42.78 | 42.78 | 42.195 | 42.28 | 32300.0 |
| 2022-04-04 | AIVI | ETF | 40.44 | 40.44 | 40.38 | 40.42 | 2300.0 |
> showing 50 of 2,693 rows — these rows as CSV