PREVIEW / etf_daily / 2022-12-01
file: by_date/etf_daily/2022/2022-12-01.parquet size: 107 KB rows: 2,890
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-01 | SPY | ETF | 408.77 | 410.0 | 404.75 | 407.38 | 76398200.0 |
| 2022-12-01 | QQQ | ETF | 293.69 | 295.75 | 290.88 | 293.72 | 51547332.0 |
| 2022-12-01 | IWM | ETF | 188.15 | 189.24 | 186.13 | 186.96 | 21996400.0 |
| 2022-12-01 | DIA | ETF | 346.75 | 346.76 | 341.69 | 344.41 | 5325900.0 |
| 2022-12-01 | GLD | ETF | 167.48 | 167.95 | 166.98 | 167.84 | 8625800.0 |
| 2022-12-01 | TLT | ETF | 103.15 | 105.81 | 103.1 | 105.76 | 53156800.0 |
| 2022-12-01 | AAA | ETF | 24.285 | 24.285 | 24.285 | 24.285 | 0.0 |
| 2022-12-01 | AAAU | ETF | 17.85 | 17.91 | 17.8 | 17.89 | 3189000.0 |
| 2022-12-01 | AADR | ETF | 50.15 | 50.24 | 49.88 | 50.0 | 2900.0 |
| 2022-12-01 | AAPB | ETF | 19.5801 | 19.7094 | 19.58 | 19.7094 | 596.0 |
| 2022-12-01 | AAPD | ETF | 26.67 | 26.959 | 26.56 | 26.68 | 99704.0 |
| 2022-12-01 | AAPU | ETF | 20.63 | 20.74 | 20.33 | 20.64 | 63371.0 |
| 2022-12-01 | AAXJ | ETF | 66.86 | 67.12 | 66.4 | 66.64 | 760900.0 |
| 2022-12-01 | ABEQ | ETF | 28.55 | 28.62 | 28.504 | 28.562 | 20400.0 |
| 2022-12-01 | ACES | ETF | 55.93 | 55.98 | 54.516 | 54.64 | 56200.0 |
| 2022-12-01 | ACIO | ETF | 30.386 | 30.45 | 30.14 | 30.26 | 124100.0 |
| 2022-12-01 | ACSI | ETF | 45.4201 | 45.4201 | 45.408 | 45.408 | 423.0 |
| 2022-12-01 | ACT | ETF | 24.91 | 25.095 | 24.665 | 24.8 | 113302.0 |
| 2022-12-01 | ACTV | ETF | 30.95 | 31.15 | 30.95 | 31.11 | 5876.0 |
| 2022-12-01 | ACTX | ETF | 0.4009 | 0.4009 | 0.4009 | 0.4009 | 200.0 |
| 2022-12-01 | ACVF | ETF | 31.43 | 31.53 | 31.315 | 31.51 | 7800.0 |
| 2022-12-01 | ACWF | ETF | 34.04 | 34.04 | 33.85 | 33.8987 | 9310.0 |
| 2022-12-01 | ACWI | ETF | 90.09 | 90.37 | 89.31 | 89.8 | 5332300.0 |
| 2022-12-01 | ACWV | ETF | 98.94 | 99.29 | 98.56 | 98.79 | 190000.0 |
| 2022-12-01 | ACWX | ETF | 47.39 | 47.46 | 47.0 | 47.23 | 1718373.0 |
| 2022-12-01 | ADFI | ETF | 8.48 | 8.514 | 8.48 | 8.514 | 2400.0 |
| 2022-12-01 | ADIV | ETF | 13.279 | 13.279 | 13.279 | 13.279 | 100.0 |
| 2022-12-01 | ADME | ETF | 35.27 | 35.53 | 35.26 | 35.49 | 103600.0 |
| 2022-12-01 | ADPV | ETF | 25.12 | 25.13 | 25.11 | 25.12 | 25886.0 |
| 2022-12-01 | ADRE | ETF | 39.47 | 39.5867 | 39.12 | 39.34 | 8106.0 |
| 2022-12-01 | AEMB | ETF | 38.615 | 38.615 | 38.615 | 38.615 | 100.0 |
| 2022-12-01 | AESR | ETF | 12.12 | 12.12 | 12.07 | 12.12 | 11600.0 |
| 2022-12-01 | AFIF | ETF | 8.79 | 8.82 | 8.79 | 8.815 | 22041.0 |
| 2022-12-01 | AFK | ETF | 17.51 | 17.51 | 17.23 | 17.24 | 5914.0 |
| 2022-12-01 | AFLG | ETF | 24.71 | 24.71 | 24.67 | 24.68 | 800.0 |
| 2022-12-01 | AFSM | ETF | 24.2 | 24.212 | 24.153 | 24.153 | 5500.0 |
| 2022-12-01 | AFTY | ETF | 15.63 | 15.63 | 15.53 | 15.568 | 2400.0 |
| 2022-12-01 | AGG | ETF | 98.3 | 98.89 | 98.17 | 98.88 | 12471300.0 |
| 2022-12-01 | AGGH | ETF | 22.675 | 22.675 | 22.67 | 22.67 | 734.0 |
| 2022-12-01 | AGGY | ETF | 43.22 | 43.5 | 43.18 | 43.48 | 93600.0 |
| 2022-12-01 | AGNG | ETF | 26.77 | 26.77 | 26.71 | 26.751 | 2100.0 |
| 2022-12-01 | AGOV | ETF | 81.34 | 82.73 | 81.01 | 81.93 | 10870.0 |
| 2022-12-01 | AGOX | ETF | 21.58 | 21.75 | 21.569 | 21.701 | 20900.0 |
| 2022-12-01 | AGQ | ETF | 28.34 | 29.27 | 28.23 | 29.24 | 1384200.0 |
| 2022-12-01 | AGZ | ETF | 106.86 | 107.35 | 106.86 | 107.35 | 29101.0 |
| 2022-12-01 | AGZD | ETF | 22.955 | 23.11 | 22.955 | 22.99 | 534000.0 |
| 2022-12-01 | AHHX | ETF | 8.6742 | 8.7 | 8.6177 | 8.6375 | 19429.0 |
| 2022-12-01 | AHYB | ETF | 43.79 | 43.942 | 43.79 | 43.942 | 300.0 |
| 2022-12-01 | AIA | ETF | 58.39 | 58.48 | 57.8 | 57.97 | 179178.0 |
| 2022-12-01 | AIEQ | ETF | 31.56 | 31.68 | 31.25 | 31.262 | 5400.0 |
> showing 50 of 2,890 rows — these rows as CSV