PREVIEW / etf_daily / 2022-10-13
file: by_date/etf_daily/2022/2022-10-13.parquet size: 105 KB rows: 2,844
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-10-13 | SPY | ETF | 349.21 | 367.51 | 348.11 | 365.97 | 147254500.0 |
| 2022-10-13 | QQQ | ETF | 255.16 | 270.17 | 254.26 | 268.82 | 112894068.0 |
| 2022-10-13 | IWM | ETF | 164.0 | 172.2 | 162.5 | 171.4 | 45376500.0 |
| 2022-10-13 | DIA | ETF | 287.14 | 301.73 | 286.62 | 300.56 | 7389600.0 |
| 2022-10-13 | GLD | ETF | 153.48 | 155.73 | 152.92 | 154.91 | 7083800.0 |
| 2022-10-13 | TLT | ETF | 98.36 | 100.38 | 98.34 | 99.39 | 30292500.0 |
| 2022-10-13 | AAA | ETF | 24.07 | 24.095 | 24.04 | 24.095 | 7565.0 |
| 2022-10-13 | AAAU | ETF | 16.36 | 16.6 | 16.3 | 16.52 | 490200.0 |
| 2022-10-13 | AADR | ETF | 44.42 | 45.38 | 44.42 | 45.1 | 3300.0 |
| 2022-10-13 | AAPB | ETF | 17.03 | 18.9986 | 17.03 | 18.9986 | 11143.0 |
| 2022-10-13 | AAPD | ETF | 30.06 | 30.17 | 28.28 | 28.39 | 142647.0 |
| 2022-10-13 | AAPU | ETF | 18.17 | 19.9 | 18.08 | 19.82 | 56657.0 |
| 2022-10-13 | AAXJ | ETF | 56.26 | 57.94 | 55.94 | 57.72 | 1655400.0 |
| 2022-10-13 | ABEQ | ETF | 25.03 | 25.83 | 24.88 | 25.74 | 8100.0 |
| 2022-10-13 | ACES | ETF | 48.97 | 51.4 | 48.495 | 51.16 | 213700.0 |
| 2022-10-13 | ACIO | ETF | 27.91 | 28.55 | 27.91 | 28.49 | 41700.0 |
| 2022-10-13 | ACSI | ETF | 41.5653 | 41.5653 | 41.5653 | 41.5653 | 10.0 |
| 2022-10-13 | ACT | ETF | 22.67 | 23.61 | 22.51 | 23.42 | 264237.0 |
| 2022-10-13 | ACTV | ETF | 26.46 | 27.555 | 26.46 | 27.4539 | 6829.0 |
| 2022-10-13 | ACTX | ETF | 0.5 | 0.5 | 0.251 | 0.498 | 2782.0 |
| 2022-10-13 | ACVF | ETF | 26.51 | 27.61 | 26.504 | 27.53 | 2800.0 |
| 2022-10-13 | ACWF | ETF | 29.66 | 30.0951 | 29.66 | 30.0951 | 4592.0 |
| 2022-10-13 | ACWI | ETF | 75.86 | 79.56 | 75.71 | 79.27 | 9384300.0 |
| 2022-10-13 | ACWV | ETF | 86.42 | 89.46 | 86.42 | 89.16 | 390500.0 |
| 2022-10-13 | ACWX | ETF | 38.91 | 40.55 | 38.81 | 40.38 | 5567647.0 |
| 2022-10-13 | ADFI | ETF | 8.15 | 8.17 | 8.15 | 8.165 | 35600.0 |
| 2022-10-13 | ADIV | ETF | 11.52 | 11.603 | 11.52 | 11.603 | 200.0 |
| 2022-10-13 | ADME | ETF | 32.9 | 33.21 | 32.9 | 33.17 | 33800.0 |
| 2022-10-13 | ADRE | ETF | 33.37 | 34.2954 | 33.25 | 34.17 | 5680.0 |
| 2022-10-13 | AEMB | ETF | 34.92 | 35.226 | 34.92 | 35.226 | 5000.0 |
| 2022-10-13 | AESR | ETF | 10.539 | 11.0 | 10.539 | 10.905 | 57600.0 |
| 2022-10-13 | AFIF | ETF | 8.63 | 8.66 | 8.61 | 8.6452 | 35507.0 |
| 2022-10-13 | AFK | ETF | 15.02 | 15.2882 | 14.79 | 15.27 | 4561.0 |
| 2022-10-13 | AFLG | ETF | 22.1 | 22.27 | 22.1 | 22.269 | 400.0 |
| 2022-10-13 | AFSM | ETF | 20.98 | 21.95 | 20.95 | 21.841 | 2400.0 |
| 2022-10-13 | AFTY | ETF | 14.74 | 15.07 | 14.74 | 15.07 | 3000.0 |
| 2022-10-13 | AGG | ETF | 94.23 | 95.44 | 94.18 | 95.18 | 6254400.0 |
| 2022-10-13 | AGGH | ETF | 22.1301 | 22.2408 | 22.1301 | 22.2002 | 3548.0 |
| 2022-10-13 | AGGY | ETF | 41.36 | 41.88 | 41.36 | 41.73 | 135000.0 |
| 2022-10-13 | AGNG | ETF | 23.277 | 24.12 | 23.277 | 24.009 | 1200.0 |
| 2022-10-13 | AGOV | ETF | 76.14 | 76.14 | 76.14 | 76.14 | 20.0 |
| 2022-10-13 | AGOX | ETF | 18.84 | 19.72 | 18.68 | 19.68 | 20100.0 |
| 2022-10-13 | AGQ | ETF | 19.64 | 20.51 | 19.41 | 20.22 | 2253700.0 |
| 2022-10-13 | AGZ | ETF | 105.4307 | 105.91 | 105.4307 | 105.67 | 12612.0 |
| 2022-10-13 | AGZD | ETF | 22.78 | 22.82 | 22.65 | 22.725 | 563400.0 |
| 2022-10-13 | AHHX | ETF | 8.09 | 8.26 | 8.09 | 8.2243 | 11002.0 |
| 2022-10-13 | AHYB | ETF | 41.52 | 41.775 | 41.52 | 41.775 | 400.0 |
| 2022-10-13 | AIA | ETF | 47.69 | 49.56 | 47.43 | 49.26 | 85758.0 |
| 2022-10-13 | AIEQ | ETF | 28.62 | 30.05 | 28.36 | 29.988 | 15200.0 |
| 2022-10-13 | AIQ | ETF | 18.12 | 19.06 | 18.01 | 19.06 | 30614.0 |
> showing 50 of 2,844 rows — these rows as CSV