PREVIEW / etf_daily / 2022-06-15
file: by_date/etf_daily/2022/2022-06-15.parquet size: 102 KB rows: 2,753
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-06-15 | SPY | ETF | 377.36 | 383.9 | 372.12 | 379.2 | 125666800.0 |
| 2022-06-15 | QQQ | ETF | 279.415 | 286.83 | 276.61 | 282.8 | 86051428.0 |
| 2022-06-15 | IWM | ETF | 171.21 | 174.06 | 168.66 | 171.86 | 32150500.0 |
| 2022-06-15 | DIA | ETF | 306.4 | 310.68 | 302.26 | 307.23 | 7060900.0 |
| 2022-06-15 | GLD | ETF | 170.4 | 171.84 | 169.08 | 170.77 | 9000300.0 |
| 2022-06-15 | TLT | ETF | 110.09 | 110.99 | 109.03 | 110.84 | 25202800.0 |
| 2022-06-15 | AAA | ETF | 24.43 | 24.45 | 24.43 | 24.45 | 113.0 |
| 2022-06-15 | AAAU | ETF | 18.15 | 18.29 | 18.02 | 18.19 | 1233300.0 |
| 2022-06-15 | AADR | ETF | 51.31 | 51.66 | 50.38 | 51.36 | 5700.0 |
| 2022-06-15 | AAXJ | ETF | 68.99 | 70.11 | 68.67 | 69.62 | 2122700.0 |
| 2022-06-15 | ABEQ | ETF | 27.404 | 27.48 | 26.981 | 27.234 | 5900.0 |
| 2022-06-15 | ACES | ETF | 48.07 | 49.96 | 47.8 | 49.48 | 72200.0 |
| 2022-06-15 | ACIO | ETF | 28.88 | 29.07 | 28.54 | 28.87 | 40400.0 |
| 2022-06-15 | ACSI | ETF | 42.1935 | 42.1935 | 42.1935 | 42.1935 | 7.0 |
| 2022-06-15 | ACT | ETF | 22.37 | 22.99 | 22.25 | 22.7 | 1032428.0 |
| 2022-06-15 | ACTV | ETF | 29.86 | 30.25 | 29.86 | 30.1067 | 11827.0 |
| 2022-06-15 | ACTX | ETF | 0.8075 | 0.95 | 0.8075 | 0.95 | 1118.0 |
| 2022-06-15 | ACVF | ETF | 28.43 | 28.96 | 28.26 | 28.654 | 7100.0 |
| 2022-06-15 | ACWF | ETF | 31.57 | 31.77 | 31.22 | 31.6905 | 22507.0 |
| 2022-06-15 | ACWI | ETF | 83.94 | 85.34 | 82.91 | 84.44 | 3660600.0 |
| 2022-06-15 | ACWV | ETF | 92.44 | 93.08 | 91.12 | 92.27 | 199100.0 |
| 2022-06-15 | ACWX | ETF | 45.3 | 45.89 | 44.77 | 45.63 | 5533783.0 |
| 2022-06-15 | ADFI | ETF | 8.44 | 8.49 | 8.43 | 8.465 | 20400.0 |
| 2022-06-15 | ADIV | ETF | 14.293 | 14.293 | 14.293 | 14.293 | 100.0 |
| 2022-06-15 | ADME | ETF | 34.75 | 34.876 | 34.57 | 34.62 | 208300.0 |
| 2022-06-15 | ADRE | ETF | 40.16 | 40.7481 | 39.97 | 40.5136 | 3958.0 |
| 2022-06-15 | AEMB | ETF | 38.75 | 39.21 | 38.67 | 39.21 | 67800.0 |
| 2022-06-15 | AESR | ETF | 11.16 | 11.34 | 11.06 | 11.2 | 40300.0 |
| 2022-06-15 | AFIF | ETF | 8.93 | 8.96 | 8.92 | 8.95 | 34404.0 |
| 2022-06-15 | AFK | ETF | 17.7 | 17.76 | 17.57 | 17.7367 | 28638.0 |
| 2022-06-15 | AFLG | ETF | 22.771 | 22.771 | 22.771 | 22.771 | 100.0 |
| 2022-06-15 | AFMC | ETF | 21.47 | 21.47 | 21.464 | 21.464 | 100.0 |
| 2022-06-15 | AFSM | ETF | 22.45 | 22.477 | 22.45 | 22.477 | 100.0 |
| 2022-06-15 | AFTY | ETF | 17.95 | 18.17 | 17.93 | 18.135 | 2600.0 |
| 2022-06-15 | AGG | ETF | 99.69 | 100.16 | 99.18 | 100.11 | 10979000.0 |
| 2022-06-15 | AGGY | ETF | 43.89 | 44.09 | 43.619 | 44.0 | 199500.0 |
| 2022-06-15 | AGNG | ETF | 23.82 | 24.057 | 23.795 | 24.057 | 1200.0 |
| 2022-06-15 | AGOV | ETF | 78.6026 | 78.6026 | 78.0611 | 78.0611 | 316.0 |
| 2022-06-15 | AGOX | ETF | 20.765 | 21.0 | 20.512 | 20.804 | 215900.0 |
| 2022-06-15 | AGQ | ETF | 28.03 | 28.85 | 27.49 | 28.36 | 933300.0 |
| 2022-06-15 | AGZ | ETF | 108.05 | 108.36 | 107.76 | 108.36 | 19204.0 |
| 2022-06-15 | AGZD | ETF | 23.02 | 23.11 | 22.935 | 22.97 | 38000.0 |
| 2022-06-15 | AHHX | ETF | 8.64 | 8.6418 | 8.63 | 8.6418 | 2372.0 |
| 2022-06-15 | AHYB | ETF | 43.344 | 43.525 | 43.11 | 43.484 | 1700.0 |
| 2022-06-15 | AIA | ETF | 63.5 | 64.405 | 63.16 | 63.99 | 56201.0 |
| 2022-06-15 | AIEQ | ETF | 31.15 | 31.45 | 30.92 | 31.254 | 13400.0 |
| 2022-06-15 | AIQ | ETF | 21.04 | 21.51 | 20.93 | 21.315 | 31276.0 |
| 2022-06-15 | AIRR | ETF | 38.55 | 38.975 | 38.22 | 38.57 | 23100.0 |
| 2022-06-15 | AIVI | ETF | 37.1 | 37.34 | 36.64 | 37.21 | 4400.0 |
| 2022-06-15 | AIVL | ETF | 89.33 | 89.36 | 88.13 | 88.75 | 7700.0 |
> showing 50 of 2,753 rows — these rows as CSV