PREVIEW / etf_daily / 2022-03-04
file: by_date/etf_daily/2022/2022-03-04.parquet size: 100 KB rows: 2,665
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-03-04 | SPY | ETF | 431.75 | 433.37 | 427.88 | 432.17 | 113978200.0 |
| 2022-03-04 | QQQ | ETF | 339.84 | 341.31 | 334.92 | 337.3 | 77009763.0 |
| 2022-03-04 | IWM | ETF | 199.7 | 200.86 | 196.98 | 198.66 | 31610400.0 |
| 2022-03-04 | DIA | ETF | 334.61 | 336.87 | 332.8 | 336.47 | 6025000.0 |
| 2022-03-04 | GLD | ETF | 182.11 | 183.98 | 181.36 | 183.68 | 22390100.0 |
| 2022-03-04 | TLT | ETF | 140.36 | 140.82 | 139.31 | 140.24 | 25853100.0 |
| 2022-03-04 | AAA | ETF | 24.919 | 24.919 | 24.87 | 24.9 | 4076.0 |
| 2022-03-04 | AAAU | ETF | 19.39 | 19.58 | 19.31 | 19.56 | 1330900.0 |
| 2022-03-04 | AADR | ETF | 56.44 | 56.44 | 54.32 | 54.52 | 9600.0 |
| 2022-03-04 | AAXJ | ETF | 75.52 | 75.91 | 74.83 | 75.19 | 2727300.0 |
| 2022-03-04 | ABEQ | ETF | 28.8 | 28.95 | 28.66 | 28.95 | 23300.0 |
| 2022-03-04 | ACES | ETF | 55.03 | 55.88 | 54.315 | 54.88 | 49900.0 |
| 2022-03-04 | ACIO | ETF | 30.57 | 30.88 | 30.57 | 30.85 | 33800.0 |
| 2022-03-04 | ACSI | ETF | 48.2 | 48.3909 | 48.2 | 48.3909 | 208.0 |
| 2022-03-04 | ACT | ETF | 20.28 | 20.775 | 19.764 | 20.19 | 103284.0 |
| 2022-03-04 | ACTV | ETF | 34.04 | 34.07 | 33.72 | 34.03 | 9390.0 |
| 2022-03-04 | ACTX | ETF | 0.7262 | 0.7262 | 0.7262 | 0.7262 | 175.0 |
| 2022-03-04 | ACVF | ETF | 32.231 | 32.41 | 32.11 | 32.41 | 4600.0 |
| 2022-03-04 | ACWF | ETF | 36.07 | 36.135 | 35.74 | 36.08 | 25608.0 |
| 2022-03-04 | ACWI | ETF | 95.24 | 95.42 | 94.35 | 95.18 | 3623000.0 |
| 2022-03-04 | ACWV | ETF | 101.11 | 102.38 | 101.11 | 102.38 | 129000.0 |
| 2022-03-04 | ACWX | ETF | 49.89 | 49.97 | 49.44 | 49.86 | 3622724.0 |
| 2022-03-04 | ADFI | ETF | 9.22 | 9.22 | 9.18 | 9.18 | 4900.0 |
| 2022-03-04 | ADIV | ETF | 15.471 | 15.546 | 15.471 | 15.542 | 1400.0 |
| 2022-03-04 | ADME | ETF | 39.79 | 39.8 | 39.491 | 39.8 | 27600.0 |
| 2022-03-04 | ADRE | ETF | 42.92 | 43.315 | 42.5 | 42.58 | 7744.0 |
| 2022-03-04 | AEMB | ETF | 42.455 | 42.455 | 42.455 | 42.455 | 100.0 |
| 2022-03-04 | AESR | ETF | 12.7 | 12.75 | 12.66 | 12.73 | 18500.0 |
| 2022-03-04 | AFIF | ETF | 9.44 | 9.44 | 9.411 | 9.43 | 28830.0 |
| 2022-03-04 | AFK | ETF | 20.99 | 21.0 | 20.72 | 20.8751 | 10708.0 |
| 2022-03-04 | AFLG | ETF | 25.82 | 25.906 | 25.82 | 25.906 | 100.0 |
| 2022-03-04 | AFMC | ETF | 24.473 | 24.473 | 24.473 | 24.473 | 100.0 |
| 2022-03-04 | AFSM | ETF | 25.281 | 25.406 | 25.281 | 25.406 | 100.0 |
| 2022-03-04 | AFTY | ETF | 19.04 | 19.177 | 19.04 | 19.177 | 1700.0 |
| 2022-03-04 | AGG | ETF | 110.4 | 110.55 | 110.23 | 110.3 | 7838500.0 |
| 2022-03-04 | AGGY | ETF | 49.33 | 49.45 | 49.281 | 49.31 | 91600.0 |
| 2022-03-04 | AGNG | ETF | 26.68 | 26.68 | 26.6 | 26.6 | 900.0 |
| 2022-03-04 | AGOV | ETF | 85.32 | 85.69 | 85.32 | 85.3379 | 3071.0 |
| 2022-03-04 | AGOX | ETF | 23.514 | 23.58 | 23.282 | 23.34 | 33900.0 |
| 2022-03-04 | AGQ | ETF | 40.48 | 41.95 | 40.36 | 41.54 | 1529400.0 |
| 2022-03-04 | AGZ | ETF | 115.16 | 115.3 | 115.157 | 115.29 | 34548.0 |
| 2022-03-04 | AGZD | ETF | 23.095 | 23.095 | 23.03 | 23.05 | 36800.0 |
| 2022-03-04 | AHHX | ETF | 9.71 | 9.77 | 9.65 | 9.7171 | 21968.0 |
| 2022-03-04 | AHYB | ETF | 47.807 | 47.807 | 47.775 | 47.775 | 200.0 |
| 2022-03-04 | AIA | ETF | 69.4 | 69.53 | 68.5752 | 68.82 | 41589.0 |
| 2022-03-04 | AIEQ | ETF | 35.66 | 35.66 | 35.13 | 35.33 | 11200.0 |
| 2022-03-04 | AIQ | ETF | 25.87 | 26.06 | 25.45 | 25.57 | 221508.0 |
| 2022-03-04 | AIRR | ETF | 41.72 | 41.72 | 41.168 | 41.449 | 43200.0 |
| 2022-03-04 | AIVI | ETF | 38.75 | 38.75 | 37.9 | 38.14 | 47200.0 |
| 2022-03-04 | AIVL | ETF | 97.33 | 97.89 | 96.83 | 97.88 | 3900.0 |
> showing 50 of 2,665 rows — these rows as CSV