PREVIEW / etf_daily / 2000-08-02
file: by_date/etf_daily/2000/2000-08-02.parquet size: 8 KB rows: 78
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-08-02 | SPY | ETF | 143.875 | 145.4062 | 143.625 | 144.5938 | 7439800.0 |
| 2000-08-02 | QQQ | ETF | 87.875 | 90.3906 | 86.5 | 86.6875 | 23578200.0 |
| 2000-08-02 | IWM | ETF | 49.625 | 50.2812 | 49.5 | 50.0 | 388600.0 |
| 2000-08-02 | DIA | ETF | 105.9062 | 107.25 | 105.875 | 107.0 | 724600.0 |
| 2000-08-02 | BBH | ETF | 58.6667 | 60.9583 | 58.25 | 59.6667 | 1189800.0 |
| 2000-08-02 | BITS | ETF | 16.0 | 16.25 | 15.0 | 16.0 | 7400.0 |
| 2000-08-02 | CEF | ETF | 3.375 | 3.375 | 3.375 | 3.375 | 7600.0 |
| 2000-08-02 | CHB | ETF | 5.5 | 5.81 | 5.44 | 5.63 | 137400.0 |
| 2000-08-02 | CNXT | ETF | 32.0 | 34.88 | 31.0 | 31.75 | 4356160.0 |
| 2000-08-02 | CSB | ETF | 2.70000004768372 | 2.70000004768372 | 2.59999990463257 | 2.59999990463257 | 21000.0 |
| 2000-08-02 | EWA | ETF | 10.125 | 10.375 | 10.125 | 10.25 | 10000.0 |
| 2000-08-02 | EWC | ETF | 20.0625 | 20.625 | 20.0625 | 20.5625 | 38800.0 |
| 2000-08-02 | EWD | ETF | 28.625 | 29.125 | 28.625 | 28.875 | 4800.0 |
| 2000-08-02 | EWG | ETF | 23.4375 | 23.625 | 23.375 | 23.5 | 27300.0 |
| 2000-08-02 | EWH | ETF | 13.3125 | 13.4375 | 13.25 | 13.25 | 48200.0 |
| 2000-08-02 | EWI | ETF | 49.25 | 49.375 | 49.125 | 49.125 | 3100.0 |
| 2000-08-02 | EWJ | ETF | 54.25 | 55.25 | 54.25 | 54.5 | 49350.0 |
| 2000-08-02 | EWK | ETF | 13.625 | 13.75 | 13.625 | 13.625 | 25700.0 |
| 2000-08-02 | EWL | ETF | 16.1875 | 16.25 | 15.9375 | 16.0 | 8300.0 |
| 2000-08-02 | EWM | ETF | 23.75 | 24.25 | 23.75 | 23.75 | 13100.0 |
| 2000-08-02 | EWN | ETF | 23.75 | 23.9375 | 23.625 | 23.625 | 4400.0 |
| 2000-08-02 | EWO | ETF | 8.125 | 8.125 | 7.9375 | 7.9375 | 3800.0 |
| 2000-08-02 | EWP | ETF | 25.1875 | 25.625 | 25.1875 | 25.3125 | 2900.0 |
| 2000-08-02 | EWQ | ETF | 27.625 | 28.125 | 27.625 | 27.8125 | 29600.0 |
| 2000-08-02 | EWS | ETF | 14.875 | 15.125 | 14.75 | 15.0 | 26250.0 |
| 2000-08-02 | EWU | ETF | 38.625 | 38.75 | 38.375 | 38.375 | 13850.0 |
| 2000-08-02 | EWW | ETF | 16.5 | 16.8125 | 16.5 | 16.75 | 17600.0 |
| 2000-08-02 | EWY | ETF | 19.0 | 19.1875 | 18.875 | 18.875 | 36300.0 |
| 2000-08-02 | EWZ | ETF | 19.0 | 19.0 | 19.0 | 19.0 | 100.0 |
| 2000-08-02 | EZU | ETF | 38.4062 | 38.4375 | 38.4062 | 38.4375 | 4600.0 |
| 2000-08-02 | FCTR | ETF | 13.875 | 14.25 | 13.875 | 13.875 | 11100.0 |
| 2000-08-02 | GLDB | ETF | 4.9375 | 4.9375 | 4.8438 | 4.8438 | 61100.0 |
| 2000-08-02 | GSIG | ETF | 26.06 | 26.37 | 23.56 | 24.0 | 856500.0 |
| 2000-08-02 | IDU | ETF | 36.1406 | 36.3906 | 36.1406 | 36.3906 | 2400.0 |
| 2000-08-02 | IEV | ETF | 38.2344 | 38.5312 | 38.2344 | 38.4609 | 8200.0 |
| 2000-08-02 | IGLD | ETF | 700.0 | 725.0 | 693.75 | 700.0 | 268.0 |
| 2000-08-02 | IJH | ETF | 9.8188 | 9.9766 | 9.8062 | 9.9766 | 59000.0 |
| 2000-08-02 | IJK | ETF | 16.6582 | 16.6582 | 16.625 | 16.625 | 8800.0 |
| 2000-08-02 | IJR | ETF | 17.2734 | 17.2943 | 17.2708 | 17.2708 | 12600.0 |
| 2000-08-02 | IJS | ETF | 17.211 | 17.2383 | 17.211 | 17.2383 | 4000.0 |
| 2000-08-02 | IJT | ETF | 20.0 | 20.0 | 20.0 | 20.0 | 1600.0 |
| 2000-08-02 | IUSG | ETF | 33.1016 | 33.1016 | 33.0859 | 33.0859 | 1200.0 |
| 2000-08-02 | IVE | ETF | 59.9531 | 60.4375 | 59.9531 | 60.4375 | 31700.0 |
| 2000-08-02 | IVV | ETF | 144.6562 | 145.3281 | 144.0938 | 144.3594 | 505900.0 |
| 2000-08-02 | IVW | ETF | 21.5898 | 21.8828 | 21.5898 | 21.5977 | 64800.0 |
| 2000-08-02 | IWB | ETF | 75.9219 | 76.6875 | 75.9219 | 76.6406 | 3500.0 |
| 2000-08-02 | IWD | ETF | 55.4375 | 55.7969 | 55.4375 | 55.75 | 11400.0 |
| 2000-08-02 | IWF | ETF | 20.671875 | 21.02735 | 20.66405 | 20.66405 | 34000.0 |
| 2000-08-02 | IWN | ETF | 34.75 | 34.8906 | 34.75 | 34.8906 | 1500.0 |
| 2000-08-02 | IWO | ETF | 76.0 | 77.0938 | 75.9219 | 75.9219 | 1000.0 |
> showing 50 of 78 rows — these rows as CSV