PREVIEW / etf_daily / 2022-08-15
file: by_date/etf_daily/2022/2022-08-15.parquet size: 103 KB rows: 2,780
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-08-15 | SPY | ETF | 424.77 | 429.41 | 424.71 | 428.86 | 54048300.0 |
| 2022-08-15 | QQQ | ETF | 329.42 | 333.5652 | 329.4 | 333.06 | 38266614.0 |
| 2022-08-15 | IWM | ETF | 198.8 | 201.16 | 198.22 | 201.07 | 17414800.0 |
| 2022-08-15 | DIA | ETF | 336.11 | 339.85 | 336.06 | 339.37 | 1936500.0 |
| 2022-08-15 | GLD | ETF | 165.99 | 166.25 | 165.44 | 165.71 | 5236100.0 |
| 2022-08-15 | TLT | ETF | 116.33 | 116.75 | 115.45 | 115.45 | 9031800.0 |
| 2022-08-15 | AAA | ETF | 24.36 | 24.36 | 24.36 | 24.36 | 7.0 |
| 2022-08-15 | AAAU | ETF | 17.68 | 17.71 | 17.63 | 17.66 | 877400.0 |
| 2022-08-15 | AADR | ETF | 52.11 | 52.21 | 52.02 | 52.2 | 1300.0 |
| 2022-08-15 | AAPB | ETF | 26.82 | 27.22 | 26.81 | 27.1563 | 14825.0 |
| 2022-08-15 | AAPD | ETF | 24.0099 | 24.0099 | 23.78 | 23.8056 | 36507.0 |
| 2022-08-15 | AAPU | ETF | 26.52 | 26.91 | 26.52 | 26.91 | 22420.0 |
| 2022-08-15 | AAXJ | ETF | 68.75 | 69.04 | 68.61 | 68.87 | 327700.0 |
| 2022-08-15 | ABEQ | ETF | 27.572 | 27.84 | 27.57 | 27.819 | 19500.0 |
| 2022-08-15 | ACES | ETF | 67.01 | 67.925 | 66.17 | 67.31 | 135100.0 |
| 2022-08-15 | ACIO | ETF | 31.137 | 31.32 | 31.135 | 31.32 | 36600.0 |
| 2022-08-15 | ACSI | ETF | 48.7593 | 48.7593 | 48.7593 | 48.7593 | 51.0 |
| 2022-08-15 | ACT | ETF | 26.8 | 27.05 | 26.57 | 26.76 | 145123.0 |
| 2022-08-15 | ACTV | ETF | 32.86 | 33.05 | 32.83 | 32.9865 | 5351.0 |
| 2022-08-15 | ACTX | ETF | 0.381 | 0.648 | 0.381 | 0.648 | 5607.0 |
| 2022-08-15 | ACVF | ETF | 31.97 | 32.2 | 31.97 | 32.186 | 6100.0 |
| 2022-08-15 | ACWF | ETF | 33.8899 | 34.0897 | 33.82 | 34.0381 | 9056.0 |
| 2022-08-15 | ACWI | ETF | 92.05 | 92.73 | 92.01 | 92.63 | 7124300.0 |
| 2022-08-15 | ACWV | ETF | 99.15 | 99.86 | 99.15 | 99.77 | 439400.0 |
| 2022-08-15 | ACWX | ETF | 46.95 | 47.115 | 46.87 | 47.08 | 1715991.0 |
| 2022-08-15 | ADFI | ETF | 8.76 | 8.76 | 8.73 | 8.745 | 13700.0 |
| 2022-08-15 | ADIV | ETF | 13.951 | 13.951 | 13.951 | 13.951 | 100.0 |
| 2022-08-15 | ADME | ETF | 37.18 | 37.69 | 37.18 | 37.61 | 20900.0 |
| 2022-08-15 | ADRE | ETF | 40.54 | 41.04 | 40.54 | 41.04 | 2410.0 |
| 2022-08-15 | AEMB | ETF | 39.63 | 39.81 | 39.59 | 39.71 | 3900.0 |
| 2022-08-15 | AESR | ETF | 12.26 | 12.39 | 12.26 | 12.365 | 19100.0 |
| 2022-08-15 | AFIF | ETF | 9.0 | 9.0 | 8.98 | 8.9899 | 10739.0 |
| 2022-08-15 | AFK | ETF | 18.18 | 18.18 | 17.8 | 17.9 | 4435.0 |
| 2022-08-15 | AFLG | ETF | 25.21 | 25.217 | 25.21 | 25.217 | 100.0 |
| 2022-08-15 | AFMC | ETF | 23.664 | 23.664 | 23.664 | 23.664 | 100.0 |
| 2022-08-15 | AFSM | ETF | 24.787 | 24.787 | 24.787 | 24.787 | 100.0 |
| 2022-08-15 | AFTY | ETF | 17.305 | 17.32 | 17.23 | 17.254 | 2100.0 |
| 2022-08-15 | AGG | ETF | 103.37 | 103.45 | 103.24 | 103.25 | 3782900.0 |
| 2022-08-15 | AGGY | ETF | 45.76 | 45.84 | 45.76 | 45.8 | 63100.0 |
| 2022-08-15 | AGIH | ETF | 25.74 | 25.86 | 25.74 | 25.825 | 215.0 |
| 2022-08-15 | AGNG | ETF | 26.72 | 26.72 | 26.69 | 26.69 | 700.0 |
| 2022-08-15 | AGOV | ETF | 83.3149 | 83.3149 | 83.3149 | 83.3149 | 90.0 |
| 2022-08-15 | AGOX | ETF | 22.52 | 22.74 | 22.52 | 22.67 | 36200.0 |
| 2022-08-15 | AGQ | ETF | 24.04 | 24.37 | 23.71 | 24.09 | 905800.0 |
| 2022-08-15 | AGZ | ETF | 110.42 | 110.42 | 110.2821 | 110.38 | 49562.0 |
| 2022-08-15 | AGZD | ETF | 23.025 | 23.065 | 23.02 | 23.045 | 44000.0 |
| 2022-08-15 | AHHX | ETF | 8.91 | 8.9592 | 8.88 | 8.92 | 17196.0 |
| 2022-08-15 | AHYB | ETF | 45.53 | 45.53 | 45.53 | 45.53 | 100.0 |
| 2022-08-15 | AIA | ETF | 60.4 | 60.83 | 60.4 | 60.64 | 265745.0 |
| 2022-08-15 | AIEQ | ETF | 36.16 | 36.59 | 36.135 | 36.524 | 6400.0 |
> showing 50 of 2,780 rows — these rows as CSV