PREVIEW / etf_daily / 2022-06-13
file: by_date/etf_daily/2022/2022-06-13.parquet size: 102 KB rows: 2,764
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-13 | SPY | ETF | 379.85 | 381.81 | 373.3 | 375.0 | 170004900.0 |
| 2022-06-13 | QQQ | ETF | 279.75 | 282.34 | 274.53 | 275.41 | 94442009.0 |
| 2022-06-13 | IWM | ETF | 173.63 | 174.96 | 169.29 | 170.2 | 39712700.0 |
| 2022-06-13 | DIA | ETF | 307.5 | 309.62 | 304.16 | 305.58 | 6317200.0 |
| 2022-06-13 | GLD | ETF | 171.18 | 171.34 | 169.61 | 169.93 | 13265200.0 |
| 2022-06-13 | TLT | ETF | 111.49 | 111.67 | 109.24 | 110.2 | 36968300.0 |
| 2022-06-13 | AAA | ETF | 24.52 | 24.52 | 24.52 | 24.52 | 28.0 |
| 2022-06-13 | AAAU | ETF | 18.24 | 18.26 | 18.07 | 18.11 | 2131300.0 |
| 2022-06-13 | AADR | ETF | 50.49 | 51.17 | 50.34 | 50.62 | 4600.0 |
| 2022-06-13 | AAXJ | ETF | 68.55 | 68.84 | 67.55 | 67.81 | 1533000.0 |
| 2022-06-13 | ABEQ | ETF | 27.436 | 27.7 | 27.38 | 27.384 | 4300.0 |
| 2022-06-13 | ACES | ETF | 50.08 | 50.08 | 47.85 | 48.26 | 262100.0 |
| 2022-06-13 | ACIO | ETF | 28.54 | 28.94 | 28.54 | 28.84 | 29200.0 |
| 2022-06-13 | ACSI | ETF | 41.5 | 41.5001 | 41.1889 | 41.1889 | 469.0 |
| 2022-06-13 | ACT | ETF | 22.29 | 22.9164 | 21.54 | 21.58 | 236750.0 |
| 2022-06-13 | ACTV | ETF | 30.53 | 30.53 | 29.84 | 29.9306 | 6223.0 |
| 2022-06-13 | ACVF | ETF | 29.0 | 29.0 | 28.325 | 28.409 | 8400.0 |
| 2022-06-13 | ACWF | ETF | 31.69 | 31.69 | 31.2517 | 31.2755 | 12040.0 |
| 2022-06-13 | ACWI | ETF | 84.35 | 84.75 | 83.12 | 83.42 | 4217100.0 |
| 2022-06-13 | ACWV | ETF | 93.2 | 93.36 | 91.95 | 92.28 | 331600.0 |
| 2022-06-13 | ACWX | ETF | 45.38 | 45.57 | 44.85 | 44.93 | 5306481.0 |
| 2022-06-13 | ADFI | ETF | 8.4 | 8.44 | 8.37 | 8.378 | 13100.0 |
| 2022-06-13 | ADIV | ETF | 14.07 | 14.07 | 13.98 | 14.029 | 1400.0 |
| 2022-06-13 | ADME | ETF | 34.88 | 35.15 | 34.82 | 34.9 | 24400.0 |
| 2022-06-13 | ADRE | ETF | 39.8 | 39.8 | 38.605 | 38.83 | 5177.0 |
| 2022-06-13 | AEMB | ETF | 38.446 | 38.446 | 38.446 | 38.446 | 200.0 |
| 2022-06-13 | AESR | ETF | 11.28 | 11.34 | 11.06 | 11.13 | 45100.0 |
| 2022-06-13 | AFIF | ETF | 8.92 | 8.935 | 8.9048 | 8.9048 | 10974.0 |
| 2022-06-13 | AFK | ETF | 18.01 | 18.13 | 17.85 | 17.85 | 8299.0 |
| 2022-06-13 | AFLG | ETF | 22.742 | 22.84 | 22.58 | 22.582 | 2700.0 |
| 2022-06-13 | AFMC | ETF | 21.35 | 21.44 | 21.35 | 21.356 | 1000.0 |
| 2022-06-13 | AFSM | ETF | 22.18 | 22.27 | 22.18 | 22.211 | 1100.0 |
| 2022-06-13 | AFTY | ETF | 17.28 | 17.28 | 17.05 | 17.083 | 10300.0 |
| 2022-06-13 | AGG | ETF | 100.1 | 100.35 | 99.13 | 99.6 | 9479000.0 |
| 2022-06-13 | AGGH | ETF | 23.4 | 23.4 | 23.3699 | 23.3699 | 1074.0 |
| 2022-06-13 | AGGY | ETF | 44.27 | 44.38 | 43.69 | 43.96 | 169200.0 |
| 2022-06-13 | AGNG | ETF | 24.31 | 24.338 | 23.9 | 23.94 | 2900.0 |
| 2022-06-13 | AGOV | ETF | 80.05 | 80.05 | 78.3924 | 78.3924 | 207.0 |
| 2022-06-13 | AGOX | ETF | 20.7 | 20.83 | 20.46 | 20.61 | 157500.0 |
| 2022-06-13 | AGQ | ETF | 27.52 | 27.59 | 26.49 | 26.95 | 1001400.0 |
| 2022-06-13 | AGZ | ETF | 108.61 | 108.7 | 107.14 | 107.86 | 33453.0 |
| 2022-06-13 | AGZD | ETF | 22.995 | 23.055 | 22.91 | 23.0 | 220600.0 |
| 2022-06-13 | AHHX | ETF | 8.71 | 8.71 | 8.495 | 8.5224 | 22481.0 |
| 2022-06-13 | AHYB | ETF | 42.369 | 42.89 | 42.369 | 42.519 | 800.0 |
| 2022-06-13 | AIA | ETF | 62.93 | 63.06 | 61.67 | 62.0 | 168277.0 |
| 2022-06-13 | AIEQ | ETF | 31.55 | 31.62 | 30.947 | 31.054 | 12000.0 |
| 2022-06-13 | AIQ | ETF | 21.04 | 21.19 | 20.64 | 20.65 | 28705.0 |
| 2022-06-13 | AIRR | ETF | 38.86 | 38.94 | 38.21 | 38.21 | 33600.0 |
| 2022-06-13 | AIVI | ETF | 36.96 | 37.19 | 36.84 | 36.84 | 1200.0 |
| 2022-06-13 | AIVL | ETF | 89.77 | 90.36 | 89.0 | 89.13 | 10600.0 |
> showing 50 of 2,764 rows — these rows as CSV