PREVIEW / etf_daily / 2022-11-11
file: by_date/etf_daily/2022/2022-11-11.parquet size: 106 KB rows: 2,850
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-11 | SPY | ETF | 395.59 | 399.35 | 393.61 | 398.51 | 93839900.0 |
| 2022-11-11 | QQQ | ETF | 282.56 | 288.64 | 281.19 | 287.96 | 66961751.0 |
| 2022-11-11 | IWM | ETF | 185.76 | 188.84 | 185.69 | 186.9 | 28765400.0 |
| 2022-11-11 | DIA | ETF | 337.9 | 338.37 | 334.14 | 337.79 | 5190700.0 |
| 2022-11-11 | GLD | ETF | 163.91 | 164.58 | 163.42 | 164.56 | 4622400.0 |
| 2022-11-11 | TLT | ETF | 97.57 | 98.37 | 97.54 | 97.89 | 15943100.0 |
| 2022-11-11 | AAA | ETF | 24.19 | 24.19 | 24.165 | 24.165 | 611.0 |
| 2022-11-11 | AAAU | ETF | 17.48 | 17.55 | 17.43 | 17.54 | 2085300.0 |
| 2022-11-11 | AADR | ETF | 48.51 | 48.83 | 48.51 | 48.83 | 900.0 |
| 2022-11-11 | AAPB | ETF | 19.31 | 20.14 | 18.97 | 20.14 | 4519.0 |
| 2022-11-11 | AAPD | ETF | 27.14 | 27.4702 | 26.45 | 26.5234 | 145123.0 |
| 2022-11-11 | AAPU | ETF | 20.24 | 21.045 | 19.9 | 21.04 | 53956.0 |
| 2022-11-11 | AAXJ | ETF | 62.59 | 63.49 | 62.59 | 63.45 | 6564900.0 |
| 2022-11-11 | ABEQ | ETF | 27.74 | 27.82 | 27.66 | 27.748 | 6500.0 |
| 2022-11-11 | ACES | ETF | 56.43 | 57.86 | 56.43 | 57.02 | 42500.0 |
| 2022-11-11 | ACIO | ETF | 29.781 | 29.9 | 29.65 | 29.81 | 67900.0 |
| 2022-11-11 | ACSI | ETF | 44.4249 | 44.4249 | 44.4249 | 44.4249 | 380.0 |
| 2022-11-11 | ACT | ETF | 26.25 | 26.57 | 25.69 | 25.75 | 108199.0 |
| 2022-11-11 | ACTV | ETF | 30.38 | 31.07 | 30.38 | 30.9929 | 1511.0 |
| 2022-11-11 | ACTX | ETF | 0.5499 | 0.5499 | 0.475 | 0.5499 | 1640.0 |
| 2022-11-11 | ACVF | ETF | 30.18 | 30.61 | 30.18 | 30.56 | 5000.0 |
| 2022-11-11 | ACWF | ETF | 33.09 | 33.3 | 33.02 | 33.295 | 22241.0 |
| 2022-11-11 | ACWI | ETF | 86.78 | 87.73 | 86.47 | 87.59 | 8577000.0 |
| 2022-11-11 | ACWV | ETF | 96.04 | 96.04 | 94.78 | 95.4 | 237800.0 |
| 2022-11-11 | ACWX | ETF | 45.34 | 45.8 | 45.165 | 45.71 | 3729020.0 |
| 2022-11-11 | ADFI | ETF | 8.33 | 8.36 | 8.33 | 8.359 | 3500.0 |
| 2022-11-11 | ADIV | ETF | 12.635 | 12.635 | 12.634 | 12.634 | 100.0 |
| 2022-11-11 | ADME | ETF | 35.08 | 35.28 | 35.0 | 35.16 | 135800.0 |
| 2022-11-11 | ADPV | ETF | 25.02 | 25.08 | 25.02 | 25.07 | 29934.0 |
| 2022-11-11 | ADRE | ETF | 35.92 | 36.25 | 35.7561 | 36.23 | 3101.0 |
| 2022-11-11 | AESR | ETF | 11.72 | 11.82 | 11.67 | 11.81 | 24000.0 |
| 2022-11-11 | AFIF | ETF | 8.7201 | 8.74 | 8.7 | 8.735 | 59764.0 |
| 2022-11-11 | AFK | ETF | 16.79 | 16.99 | 16.79 | 16.95 | 11142.0 |
| 2022-11-11 | AFLG | ETF | 24.14 | 24.14 | 24.09 | 24.09 | 100.0 |
| 2022-11-11 | AFSM | ETF | 23.78 | 23.78 | 23.654 | 23.654 | 300.0 |
| 2022-11-11 | AFTY | ETF | 15.04 | 15.07 | 15.008 | 15.008 | 1600.0 |
| 2022-11-11 | AGG | ETF | 96.23 | 96.61 | 96.23 | 96.51 | 4953100.0 |
| 2022-11-11 | AGGY | ETF | 42.29 | 42.5 | 42.28 | 42.45 | 1157300.0 |
| 2022-11-11 | AGNG | ETF | 25.872 | 26.035 | 25.83 | 26.035 | 1300.0 |
| 2022-11-11 | AGOV | ETF | 81.53 | 81.53 | 80.1925 | 81.0 | 2454.0 |
| 2022-11-11 | AGOX | ETF | 21.44 | 21.598 | 20.74 | 21.52 | 70400.0 |
| 2022-11-11 | AGQ | ETF | 26.17 | 26.66 | 25.9 | 26.63 | 816000.0 |
| 2022-11-11 | AGZ | ETF | 106.31 | 106.55 | 106.31 | 106.46 | 21085.0 |
| 2022-11-11 | AGZD | ETF | 22.85 | 22.85 | 22.71 | 22.835 | 204600.0 |
| 2022-11-11 | AHHX | ETF | 8.5821 | 8.5993 | 8.54 | 8.585 | 11357.0 |
| 2022-11-11 | AHYB | ETF | 43.383 | 43.383 | 43.383 | 43.383 | 100.0 |
| 2022-11-11 | AIA | ETF | 54.15 | 54.64 | 53.963 | 54.56 | 25080.0 |
| 2022-11-11 | AIEQ | ETF | 31.4 | 32.11 | 31.4 | 31.932 | 31700.0 |
| 2022-11-11 | AIQ | ETF | 20.5 | 21.05 | 20.4679 | 20.94 | 12604.0 |
| 2022-11-11 | AIRR | ETF | 46.18 | 46.839 | 46.06 | 46.07 | 69000.0 |
> showing 50 of 2,850 rows — these rows as CSV