PREVIEW / etf_daily / 2000-11-02
file: by_date/etf_daily/2000/2000-11-02.parquet size: 8 KB rows: 88
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 |
|---|---|---|---|---|---|---|---|
| 2000-11-02 | SPY | ETF | 143.1562 | 143.9062 | 142.5156 | 142.7031 | 11395100.0 |
| 2000-11-02 | QQQ | ETF | 82.1875 | 83.25 | 81.0625 | 82.0 | 26594300.0 |
| 2000-11-02 | IWM | ETF | 49.8906 | 50.8125 | 49.875 | 50.7188 | 211800.0 |
| 2000-11-02 | DIA | ETF | 109.2188 | 109.625 | 108.625 | 108.6406 | 1556300.0 |
| 2000-11-02 | BBH | ETF | 62.8333 | 64.3958 | 62.3542 | 64.3333 | 1927800.0 |
| 2000-11-02 | BITS | ETF | 12.5 | 13.375 | 11.5 | 12.0 | 11775.0 |
| 2000-11-02 | CEF | ETF | 2.875 | 3.0 | 2.875 | 3.0 | 44300.0 |
| 2000-11-02 | CHB | ETF | 3.5 | 3.5 | 3.0 | 3.19 | 733800.0 |
| 2000-11-02 | CNXT | ETF | 26.62 | 30.87 | 26.25 | 30.62 | 6715090.0 |
| 2000-11-02 | CSB | ETF | 1.14999997615814 | 1.14999997615814 | 1.14999997615814 | 1.14999997615814 | 5000.0 |
| 2000-11-02 | EWA | ETF | 9.125 | 9.1875 | 9.0625 | 9.125 | 24500.0 |
| 2000-11-02 | EWC | ETF | 14.75 | 14.875 | 14.75 | 14.75 | 88900.0 |
| 2000-11-02 | EWD | ETF | 20.125 | 20.5625 | 20.125 | 20.5625 | 10700.0 |
| 2000-11-02 | EWG | ETF | 19.75 | 19.875 | 19.6875 | 19.75 | 138300.0 |
| 2000-11-02 | EWH | ETF | 11.625 | 11.875 | 11.5625 | 11.75 | 59500.0 |
| 2000-11-02 | EWI | ETF | 44.375 | 44.375 | 44.0 | 44.375 | 5600.0 |
| 2000-11-02 | EWJ | ETF | 51.0 | 51.75 | 51.0 | 51.5 | 46525.0 |
| 2000-11-02 | EWK | ETF | 12.9375 | 12.9375 | 12.9375 | 12.9375 | 3500.0 |
| 2000-11-02 | EWL | ETF | 15.1875 | 15.5 | 15.1875 | 15.25 | 7700.0 |
| 2000-11-02 | EWM | ETF | 23.0 | 23.0 | 22.25 | 22.75 | 6400.0 |
| 2000-11-02 | EWN | ETF | 22.3125 | 22.5 | 22.3125 | 22.5 | 2800.0 |
| 2000-11-02 | EWO | ETF | 7.375 | 7.375 | 7.375 | 7.375 | 600.0 |
| 2000-11-02 | EWP | ETF | 23.875 | 23.875 | 23.6875 | 23.875 | 6600.0 |
| 2000-11-02 | EWQ | ETF | 24.5 | 24.625 | 24.375 | 24.5625 | 25900.0 |
| 2000-11-02 | EWS | ETF | 14.125 | 14.25 | 14.125 | 14.25 | 10200.0 |
| 2000-11-02 | EWT | ETF | 25.625 | 25.75 | 25.0 | 25.625 | 20500.0 |
| 2000-11-02 | EWU | ETF | 35.875 | 36.125 | 35.5 | 35.75 | 13500.0 |
| 2000-11-02 | EWW | ETF | 15.4375 | 15.8125 | 15.4375 | 15.75 | 27300.0 |
| 2000-11-02 | EWY | ETF | 14.875 | 15.0 | 14.5625 | 14.9375 | 44200.0 |
| 2000-11-02 | EWZ | ETF | 16.5 | 16.5 | 16.5 | 16.5 | 3100.0 |
| 2000-11-02 | EZU | ETF | 36.4375 | 36.4688 | 36.1562 | 36.4688 | 30400.0 |
| 2000-11-02 | FCTR | ETF | 15.3125 | 15.375 | 14.875 | 15.0156 | 144300.0 |
| 2000-11-02 | FMAR | ETF | 4.5 | 4.5051 | 4.38 | 4.38 | 1700.0 |
| 2000-11-02 | GLDB | ETF | 4.5625 | 4.625 | 4.4688 | 4.5625 | 162300.0 |
| 2000-11-02 | GSIG | ETF | 15.75 | 16.5 | 11.62 | 12.62 | 1574500.0 |
| 2000-11-02 | IDU | ETF | 42.2656 | 42.2656 | 41.6562 | 41.6562 | 27000.0 |
| 2000-11-02 | IEV | ETF | 37.0312 | 37.0312 | 36.6562 | 36.9688 | 33400.0 |
| 2000-11-02 | IGLD | ETF | 293.75 | 293.75 | 287.5 | 287.5 | 693.0 |
| 2000-11-02 | IJH | ETF | 10.5031 | 10.625 | 10.4797 | 10.6188 | 471000.0 |
| 2000-11-02 | IJJ | ETF | 19.5273 | 19.6484 | 19.5273 | 19.6484 | 10000.0 |
| 2000-11-02 | IJK | ETF | 17.4648 | 17.7305 | 17.4648 | 17.7168 | 217600.0 |
| 2000-11-02 | IJR | ETF | 18.099 | 18.3516 | 18.099 | 18.3412 | 131400.0 |
| 2000-11-02 | IJS | ETF | 18.0742 | 18.2578 | 18.0742 | 18.2578 | 14000.0 |
| 2000-11-02 | IJT | ETF | 21.0391 | 21.3242 | 21.0391 | 21.3125 | 8400.0 |
| 2000-11-02 | IUSG | ETF | 31.336 | 31.3516 | 31.336 | 31.3516 | 4200.0 |
| 2000-11-02 | IUSV | ETF | 25.0208 | 25.0208 | 24.9271 | 24.9271 | 4500.0 |
| 2000-11-02 | IVE | ETF | 63.9688 | 64.0 | 63.625 | 63.6562 | 9500.0 |
| 2000-11-02 | IVV | ETF | 143.25 | 143.6875 | 142.6562 | 142.8906 | 117100.0 |
| 2000-11-02 | IVW | ETF | 20.2188 | 20.3516 | 20.125 | 20.2891 | 152000.0 |
| 2000-11-02 | IWB | ETF | 76.52 | 76.7 | 76.4 | 76.7 | 70700.0 |
> showing 50 of 88 rows — these rows as CSV