PREVIEW / etf_daily / 2000-07-10
file: by_date/etf_daily/2000/2000-07-10.parquet size: 7 KB rows: 69
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-07-10 | SPY | ETF | 147.875 | 148.9062 | 147.5312 | 147.8438 | 2816100.0 |
| 2000-07-10 | QQQ | ETF | 94.6875 | 95.875 | 94.0 | 94.4844 | 12659400.0 |
| 2000-07-10 | IWM | ETF | 52.7188 | 53.2812 | 52.7188 | 53.0938 | 44800.0 |
| 2000-07-10 | DIA | ETF | 106.0625 | 107.2188 | 106.0625 | 106.5 | 387500.0 |
| 2000-07-10 | BBH | ETF | 65.75 | 66.875 | 64.3542 | 65.4375 | 2561400.0 |
| 2000-07-10 | BITS | ETF | 23.75 | 23.75 | 21.875 | 22.25 | 19650.0 |
| 2000-07-10 | CEF | ETF | 3.4375 | 3.4375 | 3.375 | 3.4375 | 35100.0 |
| 2000-07-10 | CHB | ETF | 5.56 | 5.63 | 5.31 | 5.63 | 64200.0 |
| 2000-07-10 | CNXT | ETF | 48.88 | 50.0 | 46.5 | 46.63 | 1994900.0 |
| 2000-07-10 | EWA | ETF | 10.75 | 10.75 | 10.625 | 10.75 | 3700.0 |
| 2000-07-10 | EWC | ETF | 20.1875 | 20.1875 | 20.0625 | 20.125 | 34800.0 |
| 2000-07-10 | EWD | ETF | 31.4375 | 31.6875 | 31.375 | 31.5 | 2900.0 |
| 2000-07-10 | EWG | ETF | 24.75 | 24.75 | 24.625 | 24.75 | 13600.0 |
| 2000-07-10 | EWH | ETF | 13.25 | 13.375 | 13.1875 | 13.375 | 61900.0 |
| 2000-07-10 | EWI | ETF | 53.5 | 53.5 | 53.25 | 53.25 | 1950.0 |
| 2000-07-10 | EWJ | ETF | 60.5 | 61.0 | 60.5 | 60.75 | 70450.0 |
| 2000-07-10 | EWK | ETF | 13.9375 | 14.0 | 13.875 | 14.0 | 2400.0 |
| 2000-07-10 | EWL | ETF | 16.5 | 16.5 | 16.25 | 16.25 | 3800.0 |
| 2000-07-10 | EWM | ETF | 25.0 | 25.5 | 25.0 | 25.0 | 7600.0 |
| 2000-07-10 | EWN | ETF | 25.0 | 25.0 | 24.75 | 24.9375 | 1300.0 |
| 2000-07-10 | EWO | ETF | 7.75 | 7.9375 | 7.75 | 7.75 | 11500.0 |
| 2000-07-10 | EWP | ETF | 26.875 | 26.875 | 26.875 | 26.875 | 300.0 |
| 2000-07-10 | EWQ | ETF | 29.25 | 29.25 | 29.125 | 29.25 | 13600.0 |
| 2000-07-10 | EWS | ETF | 15.625 | 15.625 | 15.125 | 15.375 | 41300.0 |
| 2000-07-10 | EWT | ETF | 37.25 | 37.25 | 37.25 | 37.25 | 100.0 |
| 2000-07-10 | EWU | ETF | 39.5 | 39.5 | 39.0 | 39.375 | 3600.0 |
| 2000-07-10 | EWW | ETF | 18.0625 | 18.125 | 17.8125 | 18.0 | 26300.0 |
| 2000-07-10 | EWY | ETF | 21.75 | 21.75 | 21.75 | 21.75 | 3000.0 |
| 2000-07-10 | FCTR | ETF | 16.9375 | 17.0 | 15.25 | 15.5 | 40500.0 |
| 2000-07-10 | FMAR | ETF | 5.25 | 5.5 | 5.2475 | 5.31 | 3600.0 |
| 2000-07-10 | GLDB | ETF | 5.2188 | 5.375 | 4.9688 | 5.0 | 121200.0 |
| 2000-07-10 | GSIG | ETF | 39.69 | 40.87 | 35.94 | 36.87 | 1379500.0 |
| 2000-07-10 | IDU | ETF | 34.1094 | 34.7656 | 34.1094 | 34.7656 | 1200.0 |
| 2000-07-10 | IGLD | ETF | 831.25 | 862.5 | 800.0 | 806.25 | 500.0 |
| 2000-07-10 | IJH | ETF | 10.0172 | 10.0859 | 10.0094 | 10.0766 | 1022000.0 |
| 2000-07-10 | IJR | ETF | 18.0 | 18.1563 | 17.9688 | 18.1094 | 67200.0 |
| 2000-07-10 | IVE | ETF | 60.2969 | 60.3281 | 60.0781 | 60.0781 | 22900.0 |
| 2000-07-10 | IVV | ETF | 147.6562 | 148.6562 | 147.6562 | 147.7188 | 77500.0 |
| 2000-07-10 | IVW | ETF | 22.6875 | 22.7695 | 22.6172 | 22.6953 | 17600.0 |
| 2000-07-10 | IWB | ETF | 78.4531 | 78.5312 | 78.2344 | 78.4219 | 2100.0 |
| 2000-07-10 | IWD | ETF | 55.6875 | 55.7656 | 55.5 | 55.5 | 64200.0 |
| 2000-07-10 | IWF | ETF | 21.83595 | 22.0625 | 21.8164 | 21.8164 | 129600.0 |
| 2000-07-10 | IWV | ETF | 81.2656 | 81.2656 | 81.0 | 81.0 | 200.0 |
| 2000-07-10 | IYE | ETF | 15.8333 | 15.8333 | 15.8333 | 15.8333 | 1800.0 |
| 2000-07-10 | IYF | ETF | 37.2031 | 37.375 | 37.2031 | 37.2969 | 3800.0 |
| 2000-07-10 | IYG | ETF | 28.3021 | 28.3958 | 28.3021 | 28.3958 | 1800.0 |
| 2000-07-10 | IYH | ETF | 13.4187 | 13.6 | 13.4 | 13.5062 | 23500.0 |
| 2000-07-10 | IYK | ETF | 13.75 | 13.75 | 13.75 | 13.75 | 600.0 |
| 2000-07-10 | IYR | ETF | 36.3594 | 36.375 | 36.25 | 36.25 | 10400.0 |
| 2000-07-10 | IYW | ETF | 32.2109 | 32.2109 | 31.8164 | 31.8164 | 16400.0 |
> showing 50 of 69 rows — these rows as CSV