PREVIEW / etf_daily / 2022-12-08
file: by_date/etf_daily/2022/2022-12-08.parquet size: 107 KB rows: 2,868
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-12-08 | SPY | ETF | 395.14 | 397.36 | 393.27 | 396.24 | 60737900.0 |
| 2022-12-08 | QQQ | ETF | 281.91 | 284.84 | 279.79 | 283.85 | 42594913.0 |
| 2022-12-08 | IWM | ETF | 180.77 | 182.63 | 179.51 | 180.84 | 20971400.0 |
| 2022-12-08 | DIA | ETF | 337.74 | 339.65 | 337.06 | 338.46 | 3278400.0 |
| 2022-12-08 | GLD | ETF | 166.58 | 167.05 | 166.07 | 166.47 | 3217900.0 |
| 2022-12-08 | TLT | ETF | 108.7 | 109.45 | 108.47 | 109.17 | 13377300.0 |
| 2022-12-08 | AAA | ETF | 24.335 | 24.335 | 24.335 | 24.335 | 90.0 |
| 2022-12-08 | AAAU | ETF | 17.76 | 17.81 | 17.71 | 17.75 | 472300.0 |
| 2022-12-08 | AADR | ETF | 48.36 | 48.71 | 48.36 | 48.45 | 2600.0 |
| 2022-12-08 | AAPB | ETF | 18.3576 | 18.3576 | 18.3576 | 18.3576 | 30.0 |
| 2022-12-08 | AAPD | ETF | 27.78 | 28.03 | 27.58 | 27.71 | 188985.0 |
| 2022-12-08 | AAPU | ETF | 19.41 | 19.55 | 19.19 | 19.41 | 65222.0 |
| 2022-12-08 | AAXJ | ETF | 66.53 | 66.96 | 66.41 | 66.86 | 723600.0 |
| 2022-12-08 | ABEQ | ETF | 28.1 | 28.1 | 27.95 | 27.99 | 15100.0 |
| 2022-12-08 | ACES | ETF | 51.66 | 52.209 | 51.15 | 51.6 | 51900.0 |
| 2022-12-08 | ACIO | ETF | 29.74 | 29.74 | 29.53 | 29.57 | 55000.0 |
| 2022-12-08 | ACSI | ETF | 44.0552 | 44.0552 | 44.0552 | 44.0552 | 8.0 |
| 2022-12-08 | ACT | ETF | 23.98 | 24.77 | 23.94 | 24.43 | 134471.0 |
| 2022-12-08 | ACTV | ETF | 30.13 | 30.55 | 30.13 | 30.39 | 1723.0 |
| 2022-12-08 | ACTX | ETF | 0.4499 | 0.45 | 0.4499 | 0.45 | 432.0 |
| 2022-12-08 | ACVF | ETF | 30.66 | 30.68 | 30.605 | 30.655 | 8400.0 |
| 2022-12-08 | ACWF | ETF | 33.03 | 33.2099 | 32.98 | 33.1004 | 8214.0 |
| 2022-12-08 | ACWI | ETF | 87.47 | 87.96 | 87.16 | 87.76 | 2221000.0 |
| 2022-12-08 | ACWV | ETF | 97.34 | 97.97 | 97.34 | 97.97 | 88300.0 |
| 2022-12-08 | ACWX | ETF | 46.41 | 46.69 | 46.33 | 46.64 | 2866893.0 |
| 2022-12-08 | ADFI | ETF | 8.511 | 8.54 | 8.51 | 8.525 | 14100.0 |
| 2022-12-08 | ADIV | ETF | 13.181 | 13.181 | 13.181 | 13.181 | 200.0 |
| 2022-12-08 | ADME | ETF | 34.825 | 34.96 | 34.82 | 34.89 | 26000.0 |
| 2022-12-08 | ADPV | ETF | 25.1 | 25.63 | 25.1 | 25.11 | 31599.0 |
| 2022-12-08 | ADRE | ETF | 39.2 | 39.5559 | 39.2 | 39.53 | 5354.0 |
| 2022-12-08 | AEMB | ETF | 38.4 | 38.4 | 38.4 | 38.4 | 100.0 |
| 2022-12-08 | AESR | ETF | 11.836 | 11.87 | 11.8 | 11.86 | 24300.0 |
| 2022-12-08 | AFIF | ETF | 8.79 | 8.7999 | 8.78 | 8.79 | 8332.0 |
| 2022-12-08 | AFK | ETF | 17.38 | 17.38 | 17.23 | 17.25 | 5856.0 |
| 2022-12-08 | AFLG | ETF | 24.02 | 24.026 | 24.02 | 24.026 | 100.0 |
| 2022-12-08 | AFMC | ETF | 22.95 | 22.954 | 22.95 | 22.954 | 100.0 |
| 2022-12-08 | AFSM | ETF | 23.428 | 23.428 | 23.428 | 23.428 | 100.0 |
| 2022-12-08 | AFTY | ETF | 16.215 | 16.231 | 16.196 | 16.196 | 800.0 |
| 2022-12-08 | AGG | ETF | 99.39 | 99.6 | 99.24 | 99.38 | 6307200.0 |
| 2022-12-08 | AGGH | ETF | 22.93 | 22.93 | 22.901 | 22.901 | 170.0 |
| 2022-12-08 | AGGY | ETF | 43.8 | 43.88 | 43.725 | 43.77 | 122600.0 |
| 2022-12-08 | AGNG | ETF | 26.74 | 26.74 | 26.74 | 26.74 | 200.0 |
| 2022-12-08 | AGOV | ETF | 81.89 | 82.317 | 81.825 | 82.317 | 491.0 |
| 2022-12-08 | AGOX | ETF | 21.139 | 21.16 | 21.04 | 21.075 | 42700.0 |
| 2022-12-08 | AGQ | ETF | 30.15 | 30.29 | 29.64 | 29.87 | 574900.0 |
| 2022-12-08 | AGRH | ETF | 25.3 | 25.41 | 25.3 | 25.365 | 508.0 |
| 2022-12-08 | AGZ | ETF | 107.26 | 107.37 | 106.9 | 107.22 | 47717.0 |
| 2022-12-08 | AGZD | ETF | 21.925 | 21.925 | 21.72 | 21.795 | 195400.0 |
| 2022-12-08 | AHHX | ETF | 8.545 | 8.55 | 8.5037 | 8.5037 | 6497.0 |
| 2022-12-08 | AHYB | ETF | 43.657 | 43.657 | 43.657 | 43.657 | 200.0 |
> showing 50 of 2,868 rows — these rows as CSV