PREVIEW / etf_daily / 2000-06-29
file: by_date/etf_daily/2000/2000-06-29.parquet size: 7 KB rows: 66
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-06-29 | SPY | ETF | 144.75 | 145.75 | 143.5156 | 144.1875 | 6345700.0 |
| 2000-06-29 | QQQ | ETF | 92.9375 | 93.375 | 90.625 | 91.6406 | 21355800.0 |
| 2000-06-29 | IWM | ETF | 51.75 | 51.8438 | 51.0312 | 51.1875 | 212200.0 |
| 2000-06-29 | DIA | ETF | 104.6094 | 105.3125 | 103.625 | 104.25 | 444300.0 |
| 2000-06-29 | BBH | ETF | 59.5 | 59.875 | 57.9375 | 58.75 | 1747200.0 |
| 2000-06-29 | BITS | ETF | 26.25 | 26.375 | 22.25 | 22.5 | 32725.0 |
| 2000-06-29 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.5 | 9200.0 |
| 2000-06-29 | CHB | ETF | 5.5 | 5.88 | 5.31 | 5.75 | 118300.0 |
| 2000-06-29 | CNXT | ETF | 51.31 | 51.5 | 48.06 | 48.63 | 3381620.0 |
| 2000-06-29 | EWA | ETF | 10.625 | 10.6875 | 10.5 | 10.5 | 5000.0 |
| 2000-06-29 | EWC | ETF | 19.75 | 19.75 | 19.5625 | 19.5625 | 1800.0 |
| 2000-06-29 | EWD | ETF | 30.4375 | 30.5 | 30.3125 | 30.3125 | 2700.0 |
| 2000-06-29 | EWG | ETF | 24.0625 | 24.1875 | 23.8125 | 23.8125 | 13400.0 |
| 2000-06-29 | EWH | ETF | 12.1875 | 12.625 | 12.125 | 12.4375 | 96700.0 |
| 2000-06-29 | EWI | ETF | 51.0 | 51.375 | 50.75 | 50.75 | 2850.0 |
| 2000-06-29 | EWJ | ETF | 60.75 | 64.75 | 60.75 | 64.75 | 67125.0 |
| 2000-06-29 | EWK | ETF | 13.4375 | 13.4375 | 13.375 | 13.375 | 500.0 |
| 2000-06-29 | EWL | ETF | 15.8125 | 15.9375 | 15.75 | 15.75 | 7500.0 |
| 2000-06-29 | EWM | ETF | 25.25 | 25.25 | 25.0 | 25.25 | 5575.0 |
| 2000-06-29 | EWN | ETF | 24.625 | 24.75 | 24.4375 | 24.4375 | 2200.0 |
| 2000-06-29 | EWO | ETF | 8.0625 | 8.0625 | 7.875 | 7.875 | 500.0 |
| 2000-06-29 | EWP | ETF | 25.5 | 25.625 | 25.4375 | 25.4375 | 5500.0 |
| 2000-06-29 | EWQ | ETF | 29.0 | 29.0 | 28.375 | 28.375 | 15700.0 |
| 2000-06-29 | EWS | ETF | 14.875 | 14.875 | 14.625 | 14.875 | 13750.0 |
| 2000-06-29 | EWU | ETF | 37.625 | 38.0 | 37.5 | 37.5 | 7650.0 |
| 2000-06-29 | EWW | ETF | 15.4375 | 15.9375 | 15.4375 | 15.9375 | 5400.0 |
| 2000-06-29 | EWY | ETF | 20.875 | 20.9375 | 20.875 | 20.9375 | 1600.0 |
| 2000-06-29 | FCTR | ETF | 16.875 | 17.0 | 16.0625 | 16.8125 | 37900.0 |
| 2000-06-29 | FMAR | ETF | 5.5 | 5.5 | 5.5 | 5.5 | 410.0 |
| 2000-06-29 | GLDB | ETF | 6.6563 | 6.9688 | 6.0 | 6.0625 | 237000.0 |
| 2000-06-29 | GSIG | ETF | 28.06 | 33.75 | 28.06 | 32.19 | 2518200.0 |
| 2000-06-29 | IDU | ETF | 33.4375 | 34.2344 | 33.4375 | 33.875 | 1000.0 |
| 2000-06-29 | IGLD | ETF | 843.75 | 859.375 | 787.5 | 812.5 | 362.0 |
| 2000-06-29 | IJH | ETF | 9.8031 | 9.9 | 9.7734 | 9.8938 | 1820000.0 |
| 2000-06-29 | IJR | ETF | 17.625 | 17.7083 | 17.5313 | 17.5833 | 112200.0 |
| 2000-06-29 | IVE | ETF | 59.0 | 59.1562 | 58.7344 | 58.7344 | 11000.0 |
| 2000-06-29 | IVV | ETF | 144.6406 | 145.25 | 143.5625 | 144.1562 | 48500.0 |
| 2000-06-29 | IVW | ETF | 22.082 | 22.336 | 22.0586 | 22.336 | 54400.0 |
| 2000-06-29 | IWB | ETF | 76.3906 | 76.3906 | 76.3906 | 76.3906 | 5000.0 |
| 2000-06-29 | IWD | ETF | 55.0 | 55.2031 | 55.0 | 55.2031 | 300.0 |
| 2000-06-29 | IWF | ETF | 21.3203 | 21.46095 | 21.171875 | 21.292975 | 96400.0 |
| 2000-06-29 | IWV | ETF | 79.0 | 79.875 | 79.0 | 79.2812 | 10500.0 |
| 2000-06-29 | IYE | ETF | 16.4479 | 16.5938 | 16.4479 | 16.5938 | 3300.0 |
| 2000-06-29 | IYF | ETF | 36.1094 | 36.1797 | 36.1094 | 36.1797 | 800.0 |
| 2000-06-29 | IYH | ETF | 13.05 | 13.0562 | 12.95 | 13.0562 | 4000.0 |
| 2000-06-29 | IYW | ETF | 31.4453 | 31.5898 | 31.1562 | 31.5898 | 1200.0 |
| 2000-06-29 | IYY | ETF | 33.5 | 33.8281 | 33.5 | 33.6719 | 6400.0 |
| 2000-06-29 | IYZ | ETF | 60.0 | 60.1875 | 59.3125 | 60.1875 | 1600.0 |
| 2000-06-29 | KTEC | ETF | 8.4375 | 8.625 | 8.4375 | 8.5625 | 37300.0 |
| 2000-06-29 | MBND | ETF | 6.0 | 6.5 | 6.0 | 6.25 | 1500.0 |
> showing 50 of 66 rows — these rows as CSV