PREVIEW / etf_daily / 2022-04-21
file: by_date/etf_daily/2022/2022-04-21.parquet size: 102 KB rows: 2,720
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-04-21 | SPY | ETF | 448.54 | 450.01 | 437.1 | 438.06 | 85417300.0 |
| 2022-04-21 | QQQ | ETF | 345.19 | 347.87 | 333.2 | 334.15 | 75801008.0 |
| 2022-04-21 | IWM | ETF | 204.23 | 204.8 | 197.02 | 197.8 | 31547700.0 |
| 2022-04-21 | DIA | ETF | 353.96 | 354.88 | 347.18 | 347.71 | 5369600.0 |
| 2022-04-21 | GLD | ETF | 181.77 | 182.32 | 180.78 | 182.06 | 9639800.0 |
| 2022-04-21 | TLT | ETF | 120.83 | 120.91 | 119.17 | 120.75 | 23323200.0 |
| 2022-04-21 | AAA | ETF | 24.855 | 24.855 | 24.855 | 24.855 | 138.0 |
| 2022-04-21 | AAAU | ETF | 19.35 | 19.41 | 19.25 | 19.38 | 500800.0 |
| 2022-04-21 | AADR | ETF | 58.86 | 59.42 | 57.9 | 58.69 | 1800.0 |
| 2022-04-21 | AAXJ | ETF | 72.18 | 72.4 | 70.74 | 70.92 | 1248600.0 |
| 2022-04-21 | ABEQ | ETF | 30.21 | 30.21 | 29.96 | 29.96 | 7100.0 |
| 2022-04-21 | ACES | ETF | 57.09 | 57.23 | 53.1 | 53.4 | 52100.0 |
| 2022-04-21 | ACIO | ETF | 31.451 | 31.729 | 30.928 | 31.02 | 41800.0 |
| 2022-04-21 | ACSI | ETF | 49.4939 | 49.4939 | 49.4939 | 49.4939 | 120.0 |
| 2022-04-21 | ACT | ETF | 24.79 | 25.1 | 23.59 | 23.7 | 150578.0 |
| 2022-04-21 | ACTV | ETF | 35.26 | 35.27 | 34.96 | 34.9835 | 6154.0 |
| 2022-04-21 | ACVF | ETF | 33.72 | 33.72 | 32.935 | 32.964 | 4900.0 |
| 2022-04-21 | ACWF | ETF | 36.855 | 36.855 | 36.1465 | 36.1465 | 7542.0 |
| 2022-04-21 | ACWI | ETF | 98.85 | 99.07 | 96.37 | 96.55 | 8192900.0 |
| 2022-04-21 | ACWV | ETF | 105.79 | 105.79 | 104.29 | 104.29 | 106100.0 |
| 2022-04-21 | ACWX | ETF | 51.55 | 51.6 | 50.39 | 50.49 | 2145324.0 |
| 2022-04-21 | ADFI | ETF | 8.77 | 8.79 | 8.75 | 8.75 | 21100.0 |
| 2022-04-21 | ADIV | ETF | 15.013 | 15.013 | 15.013 | 15.013 | 100.0 |
| 2022-04-21 | ADME | ETF | 40.79 | 40.79 | 39.59 | 39.63 | 30400.0 |
| 2022-04-21 | ADRE | ETF | 41.36 | 41.36 | 40.25 | 40.28 | 2909.0 |
| 2022-04-21 | AEMB | ETF | 41.638 | 41.638 | 41.638 | 41.638 | 100.0 |
| 2022-04-21 | AESR | ETF | 13.41 | 13.41 | 13.0 | 13.0 | 18700.0 |
| 2022-04-21 | AFIF | ETF | 9.22 | 9.22 | 9.17 | 9.18 | 6623.0 |
| 2022-04-21 | AFK | ETF | 20.97 | 20.97 | 20.32 | 20.32 | 8076.0 |
| 2022-04-21 | AFLG | ETF | 26.46 | 26.46 | 26.46 | 26.46 | 100.0 |
| 2022-04-21 | AFMC | ETF | 24.546 | 24.546 | 24.546 | 24.546 | 100.0 |
| 2022-04-21 | AFSM | ETF | 25.253 | 25.253 | 25.253 | 25.253 | 100.0 |
| 2022-04-21 | AFTY | ETF | 17.47 | 17.47 | 17.3 | 17.309 | 1500.0 |
| 2022-04-21 | AGG | ETF | 103.44 | 103.47 | 102.79 | 103.04 | 11395800.0 |
| 2022-04-21 | AGGY | ETF | 45.94 | 45.94 | 45.61 | 45.73 | 1217400.0 |
| 2022-04-21 | AGNG | ETF | 29.16 | 29.16 | 28.43 | 28.48 | 7800.0 |
| 2022-04-21 | AGOV | ETF | 80.9509 | 80.9509 | 80.9509 | 80.9509 | 61.0 |
| 2022-04-21 | AGOX | ETF | 23.491 | 23.569 | 22.918 | 22.94 | 109300.0 |
| 2022-04-21 | AGQ | ETF | 38.27 | 38.27 | 36.9 | 37.72 | 1196500.0 |
| 2022-04-21 | AGZ | ETF | 110.63 | 110.65 | 110.25 | 110.45 | 45209.0 |
| 2022-04-21 | AGZD | ETF | 23.175 | 23.175 | 23.06 | 23.085 | 187200.0 |
| 2022-04-21 | AHHX | ETF | 9.25 | 9.25 | 9.23 | 9.2399 | 7365.0 |
| 2022-04-21 | AHYB | ETF | 46.31 | 46.31 | 46.195 | 46.195 | 200.0 |
| 2022-04-21 | AIA | ETF | 64.89 | 64.96 | 63.28 | 63.38 | 68000.0 |
| 2022-04-21 | AIEQ | ETF | 36.92 | 36.92 | 36.0 | 36.094 | 8700.0 |
| 2022-04-21 | AIQ | ETF | 25.07 | 25.25 | 24.17 | 24.17 | 20816.0 |
| 2022-04-21 | AIRR | ETF | 42.23 | 42.23 | 40.96 | 40.99 | 16200.0 |
| 2022-04-21 | AIVI | ETF | 40.41 | 40.41 | 39.74 | 39.74 | 20200.0 |
| 2022-04-21 | AIVL | ETF | 101.06 | 101.53 | 99.91 | 99.93 | 5200.0 |
| 2022-04-21 | ALTL | ETF | 46.06 | 46.09 | 45.465 | 45.6 | 72337.0 |
> showing 50 of 2,720 rows — these rows as CSV