PREVIEW / etf_daily / 2022-11-15
file: by_date/etf_daily/2022/2022-11-15.parquet size: 107 KB rows: 2,863
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-11-15 | SPY | ETF | 401.15 | 402.31 | 394.49 | 398.49 | 93194500.0 |
| 2022-11-15 | QQQ | ETF | 292.21 | 293.26 | 285.97 | 289.39 | 73985372.0 |
| 2022-11-15 | IWM | ETF | 187.84 | 189.56 | 186.11 | 187.55 | 26128800.0 |
| 2022-11-15 | DIA | ETF | 338.49 | 340.12 | 333.42 | 336.21 | 4824100.0 |
| 2022-11-15 | GLD | ETF | 165.27 | 166.23 | 164.56 | 165.5 | 9903500.0 |
| 2022-11-15 | TLT | ETF | 98.25 | 99.3 | 98.11 | 99.23 | 26608200.0 |
| 2022-11-15 | AAA | ETF | 24.22 | 24.22 | 24.2 | 24.22 | 1935.0 |
| 2022-11-15 | AAAU | ETF | 17.63 | 17.72 | 17.54 | 17.65 | 3244600.0 |
| 2022-11-15 | AADR | ETF | 49.17 | 49.17 | 48.99 | 48.99 | 800.0 |
| 2022-11-15 | AAPB | ETF | 20.75 | 20.97 | 20.01 | 20.213 | 9164.0 |
| 2022-11-15 | AAPD | ETF | 26.05 | 26.71 | 25.81 | 26.4589 | 95969.0 |
| 2022-11-15 | AAPU | ETF | 21.52 | 21.8 | 20.7999 | 21.09 | 93171.0 |
| 2022-11-15 | AAXJ | ETF | 65.29 | 65.63 | 64.71 | 65.13 | 1153700.0 |
| 2022-11-15 | ABEQ | ETF | 27.82 | 27.82 | 27.71 | 27.718 | 3600.0 |
| 2022-11-15 | ACES | ETF | 57.73 | 57.98 | 56.76 | 57.0 | 32000.0 |
| 2022-11-15 | ACIO | ETF | 29.86 | 29.97 | 29.76 | 29.9 | 103100.0 |
| 2022-11-15 | ACSI | ETF | 44.2966 | 44.2966 | 44.2966 | 44.2966 | 41.0 |
| 2022-11-15 | ACT | ETF | 25.85 | 25.99 | 25.64 | 25.74 | 196343.0 |
| 2022-11-15 | ACTV | ETF | 30.92 | 31.11 | 30.59 | 30.6303 | 9794.0 |
| 2022-11-15 | ACTX | ETF | 0.51 | 0.54 | 0.51 | 0.54 | 1881.0 |
| 2022-11-15 | ACVF | ETF | 30.675 | 30.675 | 30.46 | 30.507 | 2000.0 |
| 2022-11-15 | ACWF | ETF | 33.54 | 33.54 | 33.11 | 33.26 | 4655.0 |
| 2022-11-15 | ACWI | ETF | 88.29 | 88.47 | 86.86 | 87.64 | 5437000.0 |
| 2022-11-15 | ACWV | ETF | 95.86 | 96.23 | 94.82 | 95.61 | 85000.0 |
| 2022-11-15 | ACWX | ETF | 46.23 | 46.25 | 45.43 | 45.78 | 3644656.0 |
| 2022-11-15 | ADFI | ETF | 8.345 | 8.37 | 8.345 | 8.364 | 2000.0 |
| 2022-11-15 | ADIV | ETF | 13.03 | 13.05 | 12.96 | 12.98 | 900.0 |
| 2022-11-15 | ADME | ETF | 35.34 | 35.34 | 35.02 | 35.19 | 46700.0 |
| 2022-11-15 | ADPV | ETF | 25.05 | 25.07 | 25.01 | 25.045 | 22376.0 |
| 2022-11-15 | ADRE | ETF | 38.07 | 38.275 | 37.7411 | 38.05 | 17621.0 |
| 2022-11-15 | AEMB | ETF | 36.77 | 37.109 | 36.77 | 37.109 | 400.0 |
| 2022-11-15 | AESR | ETF | 11.85 | 11.85 | 11.735 | 11.79 | 11900.0 |
| 2022-11-15 | AFIF | ETF | 8.73 | 8.73 | 8.72 | 8.725 | 13684.0 |
| 2022-11-15 | AFK | ETF | 17.0 | 17.0 | 16.83 | 16.89 | 8189.0 |
| 2022-11-15 | AFLG | ETF | 24.095 | 24.095 | 24.095 | 24.095 | 100.0 |
| 2022-11-15 | AFMC | ETF | 23.062 | 23.062 | 23.062 | 23.062 | 100.0 |
| 2022-11-15 | AFSM | ETF | 23.813 | 23.813 | 23.813 | 23.813 | 100.0 |
| 2022-11-15 | AFTY | ETF | 15.28 | 15.293 | 15.28 | 15.293 | 600.0 |
| 2022-11-15 | AGG | ETF | 96.8 | 96.95 | 96.61 | 96.95 | 7962000.0 |
| 2022-11-15 | AGGH | ETF | 22.3 | 22.31 | 22.15 | 22.15 | 914.0 |
| 2022-11-15 | AGGY | ETF | 42.52 | 42.68 | 42.485 | 42.68 | 729100.0 |
| 2022-11-15 | AGNG | ETF | 26.07 | 26.14 | 25.79 | 26.05 | 2000.0 |
| 2022-11-15 | AGOV | ETF | 81.17 | 82.1705 | 80.5 | 81.9208 | 11708.0 |
| 2022-11-15 | AGOX | ETF | 21.64 | 21.68 | 21.475 | 21.545 | 11700.0 |
| 2022-11-15 | AGQ | ETF | 27.09 | 27.11 | 25.99 | 26.47 | 1381200.0 |
| 2022-11-15 | AGZ | ETF | 106.61 | 106.79 | 106.49 | 106.75 | 21623.0 |
| 2022-11-15 | AGZD | ETF | 22.88 | 22.945 | 22.875 | 22.89 | 169200.0 |
| 2022-11-15 | AHHX | ETF | 8.6 | 8.6 | 8.57 | 8.58 | 304.0 |
| 2022-11-15 | AHYB | ETF | 43.375 | 43.452 | 43.26 | 43.452 | 800.0 |
| 2022-11-15 | AIA | ETF | 57.01 | 57.24 | 56.32 | 56.85 | 89045.0 |
> showing 50 of 2,863 rows — these rows as CSV