PREVIEW / etf_daily / 2022-01-10
file: by_date/etf_daily/2022/2022-01-10.parquet size: 99 KB rows: 2,646
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-01-10 | SPY | ETF | 462.7 | 465.74 | 456.6 | 465.51 | 119362000.0 |
| 2022-01-10 | QQQ | ETF | 374.82 | 380.64 | 369.31 | 380.11 | 91770497.0 |
| 2022-01-10 | IWM | ETF | 214.77 | 215.39 | 211.11 | 215.32 | 45778100.0 |
| 2022-01-10 | DIA | ETF | 361.07 | 361.22 | 356.44 | 360.79 | 8091800.0 |
| 2022-01-10 | GLD | ETF | 167.36 | 168.3 | 167.31 | 168.26 | 7026500.0 |
| 2022-01-10 | TLT | ETF | 141.65 | 142.81 | 141.36 | 142.61 | 13775800.0 |
| 2022-01-10 | AAA | ETF | 24.995 | 25.0 | 24.991 | 25.0 | 3641.0 |
| 2022-01-10 | AAAU | ETF | 17.82 | 17.91 | 17.81 | 17.91 | 134900.0 |
| 2022-01-10 | AADR | ETF | 63.23 | 63.23 | 62.8 | 63.19 | 1600.0 |
| 2022-01-10 | AAXJ | ETF | 82.54 | 82.94 | 82.09 | 82.68 | 1055100.0 |
| 2022-01-10 | ABEQ | ETF | 28.752 | 28.8 | 28.59 | 28.796 | 3400.0 |
| 2022-01-10 | ACES | ETF | 59.07 | 59.07 | 57.31 | 58.74 | 83800.0 |
| 2022-01-10 | ACIO | ETF | 31.75 | 31.99 | 31.73 | 31.95 | 36100.0 |
| 2022-01-10 | ACSI | ETF | 50.91 | 51.7104 | 50.91 | 51.7104 | 168.0 |
| 2022-01-10 | ACT | ETF | 22.14 | 22.28 | 21.665 | 22.14 | 163516.0 |
| 2022-01-10 | ACTV | ETF | 36.255 | 36.6771 | 36.255 | 36.6771 | 14720.0 |
| 2022-01-10 | ACTX | ETF | 1.4199 | 1.42 | 1.4199 | 1.42 | 480.0 |
| 2022-01-10 | ACVF | ETF | 34.74 | 34.754 | 34.26 | 34.754 | 5800.0 |
| 2022-01-10 | ACWF | ETF | 38.52 | 38.69 | 38.15 | 38.69 | 10466.0 |
| 2022-01-10 | ACWI | ETF | 103.55 | 103.98 | 102.31 | 103.98 | 12844900.0 |
| 2022-01-10 | ACWV | ETF | 105.42 | 105.66 | 104.94 | 105.61 | 246900.0 |
| 2022-01-10 | ACWX | ETF | 55.2 | 55.3 | 54.78 | 55.22 | 6468281.0 |
| 2022-01-10 | ADFI | ETF | 9.44 | 9.45 | 9.43 | 9.45 | 1000.0 |
| 2022-01-10 | ADIV | ETF | 16.6 | 16.6 | 16.5 | 16.596 | 4300.0 |
| 2022-01-10 | ADME | ETF | 41.706 | 42.12 | 41.706 | 42.08 | 28400.0 |
| 2022-01-10 | ADRE | ETF | 46.86 | 46.86 | 46.25 | 46.66 | 15357.0 |
| 2022-01-10 | AEMB | ETF | 47.58 | 47.58 | 47.58 | 47.58 | 100.0 |
| 2022-01-10 | AESR | ETF | 13.62 | 13.727 | 13.54 | 13.727 | 4100.0 |
| 2022-01-10 | AFIF | ETF | 9.5 | 9.51 | 9.5 | 9.51 | 24253.0 |
| 2022-01-10 | AFK | ETF | 20.32 | 20.39 | 20.194 | 20.3719 | 6202.0 |
| 2022-01-10 | AFLG | ETF | 27.06 | 27.333 | 27.06 | 27.333 | 100.0 |
| 2022-01-10 | AFMC | ETF | 25.7 | 25.914 | 25.7 | 25.914 | 100.0 |
| 2022-01-10 | AFSM | ETF | 26.36 | 26.725 | 26.36 | 26.725 | 100.0 |
| 2022-01-10 | AFTY | ETF | 20.34 | 20.39 | 20.34 | 20.372 | 2100.0 |
| 2022-01-10 | AGG | ETF | 112.23 | 112.42 | 112.14 | 112.39 | 8074900.0 |
| 2022-01-10 | AGGY | ETF | 50.65 | 50.71 | 50.608 | 50.71 | 127600.0 |
| 2022-01-10 | AGNG | ETF | 27.55 | 27.69 | 27.31 | 27.69 | 4100.0 |
| 2022-01-10 | AGOV | ETF | 96.92 | 97.045 | 96.92 | 97.045 | 2549.0 |
| 2022-01-10 | AGOX | ETF | 24.695 | 24.89 | 24.494 | 24.89 | 26900.0 |
| 2022-01-10 | AGQ | ETF | 31.63 | 32.35 | 31.55 | 32.21 | 695500.0 |
| 2022-01-10 | AGZ | ETF | 116.18 | 116.29 | 116.18 | 116.25 | 14182.0 |
| 2022-01-10 | AGZD | ETF | 23.35 | 23.37 | 23.325 | 23.33 | 46200.0 |
| 2022-01-10 | AHHX | ETF | 10.175 | 10.175 | 10.1493 | 10.1697 | 1739.0 |
| 2022-01-10 | AHYB | ETF | 49.602 | 49.61 | 49.602 | 49.61 | 500.0 |
| 2022-01-10 | AIA | ETF | 76.8 | 76.9 | 76.1026 | 76.7 | 64081.0 |
| 2022-01-10 | AIEQ | ETF | 38.54 | 39.029 | 38.09 | 38.96 | 38300.0 |
| 2022-01-10 | AIQ | ETF | 29.78 | 30.17 | 29.3 | 30.11 | 49139.0 |
| 2022-01-10 | AIRR | ETF | 44.16 | 44.16 | 43.55 | 44.027 | 22400.0 |
| 2022-01-10 | AIVI | ETF | 42.32 | 42.53 | 42.24 | 42.52 | 11300.0 |
| 2022-01-10 | ALTL | ETF | 46.31 | 46.31 | 45.73 | 45.92 | 549009.0 |
> showing 50 of 2,646 rows — these rows as CSV