PREVIEW / etf_daily / 2022-04-12
file: by_date/etf_daily/2022/2022-04-12.parquet size: 101 KB rows: 2,695
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-12 | SPY | ETF | 443.08 | 445.75 | 436.65 | 438.29 | 84363600.0 |
| 2022-04-12 | QQQ | ETF | 345.76 | 347.69 | 338.035 | 339.45 | 72790215.0 |
| 2022-04-12 | IWM | ETF | 198.7 | 201.68 | 196.42 | 197.16 | 33699800.0 |
| 2022-04-12 | DIA | ETF | 344.41 | 346.75 | 341.0 | 342.22 | 4501400.0 |
| 2022-04-12 | GLD | ETF | 184.04 | 184.64 | 182.96 | 183.77 | 12024600.0 |
| 2022-04-12 | TLT | ETF | 124.05 | 124.16 | 122.67 | 122.97 | 23124200.0 |
| 2022-04-12 | AAA | ETF | 24.89 | 24.89 | 24.855 | 24.855 | 301.0 |
| 2022-04-12 | AAAU | ETF | 19.58 | 19.66 | 19.48 | 19.57 | 1059300.0 |
| 2022-04-12 | AADR | ETF | 58.29 | 58.29 | 57.35 | 57.38 | 1800.0 |
| 2022-04-12 | AAXJ | ETF | 73.92 | 74.06 | 73.08 | 73.14 | 2263200.0 |
| 2022-04-12 | ABEQ | ETF | 30.165 | 30.29 | 30.02 | 30.038 | 26000.0 |
| 2022-04-12 | ACES | ETF | 59.08 | 59.45 | 57.251 | 57.44 | 213500.0 |
| 2022-04-12 | ACIO | ETF | 30.85 | 31.25 | 30.85 | 31.03 | 70600.0 |
| 2022-04-12 | ACSI | ETF | 49.68 | 49.7 | 49.1824 | 49.1824 | 447.0 |
| 2022-04-12 | ACT | ETF | 21.33 | 22.1 | 21.1 | 21.37 | 89211.0 |
| 2022-04-12 | ACTV | ETF | 35.35 | 35.38 | 34.9017 | 35.07 | 17744.0 |
| 2022-04-12 | ACTX | ETF | 1.0 | 1.0 | 1.0 | 1.0 | 347.0 |
| 2022-04-12 | ACVF | ETF | 33.41 | 33.48 | 32.89 | 32.921 | 4200.0 |
| 2022-04-12 | ACWF | ETF | 36.39 | 36.4 | 35.98 | 36.0275 | 5299.0 |
| 2022-04-12 | ACWI | ETF | 98.05 | 98.47 | 96.71 | 96.97 | 2964600.0 |
| 2022-04-12 | ACWV | ETF | 106.36 | 106.36 | 105.09 | 105.33 | 157200.0 |
| 2022-04-12 | ACWX | ETF | 51.44 | 51.525 | 50.86 | 50.89 | 5816691.0 |
| 2022-04-12 | ADFI | ETF | 9.15 | 9.15 | 8.87 | 8.875 | 16900.0 |
| 2022-04-12 | ADIV | ETF | 15.27 | 15.27 | 15.27 | 15.27 | 200.0 |
| 2022-04-12 | ADME | ETF | 40.285 | 40.298 | 39.835 | 39.87 | 26300.0 |
| 2022-04-12 | ADRE | ETF | 43.45 | 43.45 | 42.43 | 42.46 | 13057.0 |
| 2022-04-12 | AEMB | ETF | 42.4 | 42.43 | 42.2 | 42.2 | 6400.0 |
| 2022-04-12 | AESR | ETF | 13.083 | 13.12 | 12.94 | 12.98 | 40800.0 |
| 2022-04-12 | AFIF | ETF | 9.281 | 9.31 | 9.27 | 9.2899 | 12161.0 |
| 2022-04-12 | AFK | ETF | 21.16 | 21.29 | 21.13 | 21.14 | 48651.0 |
| 2022-04-12 | AFLG | ETF | 26.56 | 26.56 | 26.241 | 26.241 | 200.0 |
| 2022-04-12 | AFMC | ETF | 23.993 | 23.993 | 23.993 | 23.993 | 100.0 |
| 2022-04-12 | AFSM | ETF | 25.27 | 25.27 | 24.914 | 24.914 | 100.0 |
| 2022-04-12 | AFTY | ETF | 18.31 | 18.33 | 18.282 | 18.282 | 500.0 |
| 2022-04-12 | AGG | ETF | 104.8 | 104.92 | 104.58 | 104.61 | 8498700.0 |
| 2022-04-12 | AGGY | ETF | 46.53 | 46.63 | 46.45 | 46.54 | 585000.0 |
| 2022-04-12 | AGNG | ETF | 28.88 | 28.955 | 28.6 | 28.6 | 4100.0 |
| 2022-04-12 | AGOV | ETF | 82.4 | 83.59 | 82.4 | 82.47 | 9611.0 |
| 2022-04-12 | AGOX | ETF | 23.454 | 23.481 | 23.07 | 23.128 | 28000.0 |
| 2022-04-12 | AGQ | ETF | 40.24 | 41.18 | 39.73 | 40.53 | 1202100.0 |
| 2022-04-12 | AGZ | ETF | 111.11 | 111.39 | 111.11 | 111.31 | 110783.0 |
| 2022-04-12 | AGZD | ETF | 23.265 | 23.315 | 23.14 | 23.19 | 206800.0 |
| 2022-04-12 | AHHX | ETF | 9.24 | 9.253 | 9.21 | 9.253 | 15208.0 |
| 2022-04-12 | AHYB | ETF | 46.63 | 46.63 | 46.457 | 46.457 | 300.0 |
| 2022-04-12 | AIA | ETF | 66.8 | 66.83 | 65.85 | 65.95 | 98731.0 |
| 2022-04-12 | AIEQ | ETF | 35.9 | 36.27 | 35.73 | 35.753 | 6000.0 |
| 2022-04-12 | AIQ | ETF | 25.57 | 25.7175 | 24.96 | 25.11 | 20239.0 |
| 2022-04-12 | AIRR | ETF | 40.76 | 41.34 | 40.37 | 40.56 | 24600.0 |
| 2022-04-12 | AIVI | ETF | 39.64 | 39.69 | 39.33 | 39.41 | 13300.0 |
| 2022-04-12 | AIVL | ETF | 99.64 | 99.93 | 98.53 | 98.63 | 2900.0 |
> showing 50 of 2,695 rows — these rows as CSV