PREVIEW / etf_daily / 2022-10-25
file: by_date/etf_daily/2022/2022-10-25.parquet size: 106 KB rows: 2,834
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-25 | SPY | ETF | 378.79 | 385.25 | 378.67 | 384.92 | 78846300.0 |
| 2022-10-25 | QQQ | ETF | 279.41 | 284.6 | 277.9 | 284.21 | 59014494.0 |
| 2022-10-25 | IWM | ETF | 173.57 | 178.9 | 173.56 | 178.17 | 33105700.0 |
| 2022-10-25 | DIA | ETF | 314.35 | 318.78 | 314.11 | 318.49 | 6024800.0 |
| 2022-10-25 | GLD | ETF | 153.96 | 154.79 | 153.83 | 154.0 | 3434100.0 |
| 2022-10-25 | TLT | ETF | 94.58 | 95.23 | 94.44 | 95.09 | 31213100.0 |
| 2022-10-25 | AAA | ETF | 24.19 | 24.19 | 24.19 | 24.19 | 93.0 |
| 2022-10-25 | AAAU | ETF | 16.41 | 16.49 | 16.4 | 16.41 | 633200.0 |
| 2022-10-25 | AADR | ETF | 46.56 | 46.56 | 46.56 | 46.56 | 100.0 |
| 2022-10-25 | AAPB | ETF | 20.68 | 21.12 | 20.52 | 21.0869 | 11392.0 |
| 2022-10-25 | AAPD | ETF | 26.94 | 27.0815 | 26.55 | 26.62 | 93004.0 |
| 2022-10-25 | AAPU | ETF | 21.29 | 21.74 | 21.19 | 21.7159 | 74178.0 |
| 2022-10-25 | AAXJ | ETF | 55.22 | 55.76 | 55.22 | 55.71 | 1373200.0 |
| 2022-10-25 | ABEQ | ETF | 26.44 | 26.59 | 26.32 | 26.48 | 29700.0 |
| 2022-10-25 | ACES | ETF | 50.0 | 52.635 | 50.0 | 52.45 | 105900.0 |
| 2022-10-25 | ACIO | ETF | 29.25 | 29.58 | 29.25 | 29.57 | 32900.0 |
| 2022-10-25 | ACSI | ETF | 43.0805 | 43.2719 | 43.0805 | 43.2719 | 107.0 |
| 2022-10-25 | ACT | ETF | 24.43 | 24.995 | 24.34 | 24.78 | 96521.0 |
| 2022-10-25 | ACTV | ETF | 27.94 | 28.53 | 27.94 | 28.45 | 24882.0 |
| 2022-10-25 | ACTX | ETF | 0.5499 | 0.5499 | 0.5499 | 0.5499 | 253.0 |
| 2022-10-25 | ACVF | ETF | 28.855 | 28.904 | 28.84 | 28.904 | 1500.0 |
| 2022-10-25 | ACWF | ETF | 30.75 | 31.2158 | 30.75 | 31.2158 | 5014.0 |
| 2022-10-25 | ACWI | ETF | 81.26 | 82.59 | 81.22 | 82.5 | 5343900.0 |
| 2022-10-25 | ACWV | ETF | 90.46 | 91.44 | 90.46 | 91.36 | 81200.0 |
| 2022-10-25 | ACWX | ETF | 40.86 | 41.4099 | 40.82 | 41.38 | 1978856.0 |
| 2022-10-25 | ADFI | ETF | 8.18 | 8.19 | 8.17 | 8.185 | 5100.0 |
| 2022-10-25 | ADIV | ETF | 11.24 | 11.355 | 11.24 | 11.355 | 1500.0 |
| 2022-10-25 | ADME | ETF | 34.759 | 34.932 | 34.69 | 34.89 | 19200.0 |
| 2022-10-25 | ADRE | ETF | 32.4811 | 32.4811 | 32.2737 | 32.43 | 7206.0 |
| 2022-10-25 | AEMB | ETF | 35.01 | 35.08 | 34.98 | 35.08 | 800.0 |
| 2022-10-25 | AESR | ETF | 11.38 | 11.43 | 11.35 | 11.43 | 12400.0 |
| 2022-10-25 | AFIF | ETF | 8.7 | 8.7 | 8.65 | 8.67 | 127627.0 |
| 2022-10-25 | AFK | ETF | 15.35 | 15.35 | 15.02 | 15.26 | 20715.0 |
| 2022-10-25 | AFSM | ETF | 22.778 | 22.778 | 22.778 | 22.778 | 100.0 |
| 2022-10-25 | AFTY | ETF | 13.89 | 13.95 | 13.89 | 13.94 | 7300.0 |
| 2022-10-25 | AGG | ETF | 94.39 | 94.71 | 94.36 | 94.56 | 11710400.0 |
| 2022-10-25 | AGGY | ETF | 41.18 | 41.36 | 41.18 | 41.28 | 198400.0 |
| 2022-10-25 | AGNG | ETF | 24.21 | 24.594 | 24.21 | 24.594 | 1500.0 |
| 2022-10-25 | AGOV | ETF | 76.8501 | 76.8501 | 76.8501 | 76.8501 | 20.0 |
| 2022-10-25 | AGOX | ETF | 20.11 | 20.36 | 20.11 | 20.36 | 12200.0 |
| 2022-10-25 | AGQ | ETF | 20.94 | 21.36 | 20.89 | 21.28 | 957500.0 |
| 2022-10-25 | AGZ | ETF | 105.53 | 105.67 | 105.4499 | 105.5788 | 62270.0 |
| 2022-10-25 | AGZD | ETF | 22.655 | 22.725 | 22.59 | 22.63 | 185800.0 |
| 2022-10-25 | AHHX | ETF | 8.375 | 8.42 | 8.34 | 8.39 | 2528.0 |
| 2022-10-25 | AHYB | ETF | 42.58 | 42.61 | 42.58 | 42.61 | 200.0 |
| 2022-10-25 | AIA | ETF | 45.46 | 45.87 | 45.46 | 45.76 | 40615.0 |
| 2022-10-25 | AIEQ | ETF | 30.27 | 31.118 | 30.27 | 31.045 | 6200.0 |
| 2022-10-25 | AIQ | ETF | 19.55 | 19.97 | 19.44 | 19.82 | 13143.0 |
| 2022-10-25 | AIRR | ETF | 42.57 | 43.42 | 42.545 | 43.28 | 27500.0 |
| 2022-10-25 | AIVI | ETF | 31.8 | 32.04 | 31.8 | 32.01 | 6900.0 |
> showing 50 of 2,834 rows — these rows as CSV