PREVIEW / etf_daily / 2022-10-26
file: by_date/etf_daily/2022/2022-10-26.parquet size: 105 KB rows: 2,839
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-26 | SPY | ETF | 381.62 | 387.58 | 381.35 | 382.02 | 104087300.0 |
| 2022-10-26 | QQQ | ETF | 278.46 | 283.98 | 277.43 | 277.93 | 63898246.0 |
| 2022-10-26 | IWM | ETF | 179.15 | 182.37 | 178.33 | 179.05 | 37084700.0 |
| 2022-10-26 | DIA | ETF | 317.98 | 321.72 | 317.77 | 318.38 | 4991800.0 |
| 2022-10-26 | GLD | ETF | 154.78 | 155.73 | 154.78 | 154.98 | 4448200.0 |
| 2022-10-26 | TLT | ETF | 95.77 | 96.69 | 95.77 | 96.46 | 24843900.0 |
| 2022-10-26 | AAA | ETF | 24.2 | 24.2 | 24.2 | 24.2 | 0.0 |
| 2022-10-26 | AAAU | ETF | 16.5 | 16.6 | 16.5 | 16.52 | 534700.0 |
| 2022-10-26 | AADR | ETF | 46.98 | 46.98 | 46.74 | 46.74 | 1400.0 |
| 2022-10-26 | AAPB | ETF | 20.65 | 20.79 | 20.45 | 20.45 | 1747.0 |
| 2022-10-26 | AAPD | ETF | 26.8 | 27.29 | 26.63 | 27.07 | 126811.0 |
| 2022-10-26 | AAPU | ETF | 21.45 | 21.63 | 20.851 | 21.13 | 40559.0 |
| 2022-10-26 | AAXJ | ETF | 55.99 | 57.34 | 55.91 | 56.9 | 659100.0 |
| 2022-10-26 | ABEQ | ETF | 26.48 | 26.85 | 26.48 | 26.68 | 9500.0 |
| 2022-10-26 | ACES | ETF | 52.84 | 54.42 | 52.84 | 53.2 | 64300.0 |
| 2022-10-26 | ACIO | ETF | 29.31 | 29.609 | 29.297 | 29.34 | 67400.0 |
| 2022-10-26 | ACSI | ETF | 43.0512 | 43.0512 | 43.0512 | 43.0512 | 12.0 |
| 2022-10-26 | ACT | ETF | 24.94 | 25.205 | 24.6 | 24.98 | 168156.0 |
| 2022-10-26 | ACTV | ETF | 28.685 | 28.99 | 28.66 | 28.68 | 9355.0 |
| 2022-10-26 | ACTX | ETF | 0.3 | 0.3 | 0.29 | 0.29 | 10968.0 |
| 2022-10-26 | ACVF | ETF | 29.02 | 29.02 | 28.875 | 28.875 | 500.0 |
| 2022-10-26 | ACWF | ETF | 31.18 | 31.65 | 31.18 | 31.42 | 9948.0 |
| 2022-10-26 | ACWI | ETF | 82.09 | 83.44 | 82.06 | 82.51 | 6723700.0 |
| 2022-10-26 | ACWV | ETF | 91.46 | 92.43 | 91.46 | 91.72 | 105000.0 |
| 2022-10-26 | ACWX | ETF | 41.38 | 42.16 | 41.35 | 41.86 | 2837588.0 |
| 2022-10-26 | ADFI | ETF | 8.19 | 8.2 | 8.18 | 8.19 | 8500.0 |
| 2022-10-26 | ADIV | ETF | 11.475 | 11.475 | 11.475 | 11.475 | 100.0 |
| 2022-10-26 | ADME | ETF | 34.46 | 35.08 | 34.46 | 34.69 | 25500.0 |
| 2022-10-26 | ADRE | ETF | 32.72 | 33.25 | 32.72 | 32.95 | 2618.0 |
| 2022-10-26 | AEMB | ETF | 35.32 | 35.47 | 35.305 | 35.305 | 900.0 |
| 2022-10-26 | AESR | ETF | 11.49 | 11.54 | 11.385 | 11.42 | 21100.0 |
| 2022-10-26 | AFIF | ETF | 8.6688 | 8.68 | 8.65 | 8.66 | 40965.0 |
| 2022-10-26 | AFK | ETF | 15.4 | 15.6612 | 15.4 | 15.6 | 4316.0 |
| 2022-10-26 | AFLG | ETF | 23.26 | 23.26 | 23.165 | 23.165 | 100.0 |
| 2022-10-26 | AFMC | ETF | 22.11 | 22.11 | 21.962 | 21.962 | 100.0 |
| 2022-10-26 | AFSM | ETF | 22.96 | 22.96 | 22.893 | 22.893 | 200.0 |
| 2022-10-26 | AFTY | ETF | 14.24 | 14.24 | 14.21 | 14.21 | 100.0 |
| 2022-10-26 | AGG | ETF | 94.78 | 95.17 | 94.76 | 94.98 | 7884100.0 |
| 2022-10-26 | AGGY | ETF | 41.38 | 41.56 | 41.38 | 41.47 | 97400.0 |
| 2022-10-26 | AGNG | ETF | 24.72 | 25.17 | 24.72 | 25.0 | 15000.0 |
| 2022-10-26 | AGOV | ETF | 78.47 | 78.9 | 78.36 | 78.9 | 2614.0 |
| 2022-10-26 | AGOX | ETF | 20.31 | 20.57 | 20.306 | 20.344 | 17900.0 |
| 2022-10-26 | AGQ | ETF | 21.4 | 21.88 | 21.4 | 21.52 | 1269300.0 |
| 2022-10-26 | AGZ | ETF | 105.56 | 105.92 | 105.56 | 105.76 | 68063.0 |
| 2022-10-26 | AGZD | ETF | 22.695 | 22.705 | 22.645 | 22.66 | 95400.0 |
| 2022-10-26 | AHHX | ETF | 8.39 | 8.4465 | 8.36 | 8.4 | 4134.0 |
| 2022-10-26 | AHYB | ETF | 42.74 | 42.74 | 42.709 | 42.709 | 300.0 |
| 2022-10-26 | AIA | ETF | 46.02 | 47.58 | 46.02 | 47.16 | 72941.0 |
| 2022-10-26 | AIEQ | ETF | 30.96 | 31.595 | 30.96 | 31.067 | 6100.0 |
| 2022-10-26 | AIQ | ETF | 19.63 | 20.2 | 19.63 | 19.9 | 16347.0 |
> showing 50 of 2,839 rows — these rows as CSV