PREVIEW / etf_daily / 2000-06-30
file: by_date/etf_daily/2000/2000-06-30.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-06-30 | SPY | ETF | 143.9375 | 145.5938 | 143.8906 | 145.2812 | 7420200.0 |
| 2000-06-30 | QQQ | ETF | 91.8125 | 93.9531 | 91.3125 | 93.4375 | 15153100.0 |
| 2000-06-30 | IWM | ETF | 51.2188 | 51.6797 | 50.7969 | 51.6797 | 1171800.0 |
| 2000-06-30 | DIA | ETF | 103.5469 | 104.5 | 103.3438 | 104.375 | 655200.0 |
| 2000-06-30 | BBH | ETF | 58.875 | 59.5833 | 58.0625 | 59.25 | 1235700.0 |
| 2000-06-30 | BITS | ETF | 23.0 | 25.25 | 22.75 | 25.25 | 19625.0 |
| 2000-06-30 | CEF | ETF | 3.4375 | 3.5625 | 3.4375 | 3.5 | 20000.0 |
| 2000-06-30 | CHB | ETF | 5.69 | 5.69 | 5.0 | 5.13 | 168700.0 |
| 2000-06-30 | CNXT | ETF | 49.56 | 51.56 | 46.81 | 48.63 | 4295470.0 |
| 2000-06-30 | EWA | ETF | 10.6875 | 10.8125 | 10.625 | 10.8125 | 13700.0 |
| 2000-06-30 | EWC | ETF | 19.6875 | 19.9375 | 19.6875 | 19.9375 | 2600.0 |
| 2000-06-30 | EWD | ETF | 31.3125 | 31.375 | 31.125 | 31.125 | 2200.0 |
| 2000-06-30 | EWG | ETF | 24.25 | 24.375 | 24.125 | 24.25 | 19900.0 |
| 2000-06-30 | EWH | ETF | 12.375 | 12.4375 | 12.25 | 12.4375 | 19300.0 |
| 2000-06-30 | EWI | ETF | 51.5 | 52.0 | 51.25 | 52.0 | 13550.0 |
| 2000-06-30 | EWJ | ETF | 60.5 | 61.0 | 60.5 | 60.75 | 68650.0 |
| 2000-06-30 | EWK | ETF | 13.5 | 13.75 | 13.5 | 13.5 | 1700.0 |
| 2000-06-30 | EWL | ETF | 16.0625 | 16.0625 | 15.8125 | 15.9375 | 7800.0 |
| 2000-06-30 | EWM | ETF | 25.0 | 25.25 | 25.0 | 25.0 | 3450.0 |
| 2000-06-30 | EWN | ETF | 25.0 | 25.0 | 24.6875 | 24.9375 | 3000.0 |
| 2000-06-30 | EWO | ETF | 8.0625 | 8.0625 | 7.9375 | 7.9375 | 400.0 |
| 2000-06-30 | EWP | ETF | 26.1875 | 26.25 | 25.9375 | 26.0 | 2500.0 |
| 2000-06-30 | EWQ | ETF | 28.875 | 28.875 | 28.625 | 28.8125 | 41000.0 |
| 2000-06-30 | EWS | ETF | 14.875 | 14.875 | 14.625 | 14.875 | 13800.0 |
| 2000-06-30 | EWT | ETF | 37.5 | 37.5 | 37.5 | 37.5 | 12150.0 |
| 2000-06-30 | EWU | ETF | 38.0 | 38.375 | 37.625 | 38.375 | 10200.0 |
| 2000-06-30 | EWW | ETF | 16.5625 | 16.8125 | 16.375 | 16.4375 | 22500.0 |
| 2000-06-30 | EWY | ETF | 21.0 | 21.0 | 21.0 | 21.0 | 10000.0 |
| 2000-06-30 | FCTR | ETF | 16.8125 | 16.9375 | 15.625 | 15.75 | 81200.0 |
| 2000-06-30 | FMAR | ETF | 5.5 | 5.5 | 5.4375 | 5.5 | 3100.0 |
| 2000-06-30 | GLDB | ETF | 6.125 | 6.125 | 4.0 | 5.0 | 824200.0 |
| 2000-06-30 | GSIG | ETF | 34.56 | 36.0 | 33.25 | 35.12 | 2542100.0 |
| 2000-06-30 | IDU | ETF | 33.4531 | 33.4531 | 32.8906 | 32.8906 | 2600.0 |
| 2000-06-30 | IGLD | ETF | 818.75 | 843.75 | 750.0 | 818.75 | 210.0 |
| 2000-06-30 | IJH | ETF | 9.6875 | 9.7031 | 9.6875 | 9.7031 | 43000.0 |
| 2000-06-30 | IJR | ETF | 17.5781 | 17.6094 | 17.4844 | 17.5521 | 460800.0 |
| 2000-06-30 | IVE | ETF | 59.0 | 59.0625 | 58.5 | 58.5156 | 27000.0 |
| 2000-06-30 | IVV | ETF | 143.9844 | 145.4844 | 143.9844 | 145.4844 | 16800.0 |
| 2000-06-30 | IVW | ETF | 22.0625 | 22.332 | 22.0625 | 22.332 | 16000.0 |
| 2000-06-30 | IWB | ETF | 76.6875 | 76.6875 | 76.6875 | 76.6875 | 100.0 |
| 2000-06-30 | IWD | ETF | 55.3125 | 55.3281 | 54.8125 | 54.8125 | 7700.0 |
| 2000-06-30 | IWF | ETF | 21.25 | 21.6328 | 21.25 | 21.6328 | 74400.0 |
| 2000-06-30 | IWV | ETF | 79.5312 | 79.5312 | 78.9688 | 78.9688 | 800.0 |
| 2000-06-30 | IYC | ETF | 14.8594 | 14.8594 | 14.8594 | 14.8594 | 800.0 |
| 2000-06-30 | IYE | ETF | 16.4792 | 16.5208 | 16.2917 | 16.2917 | 4200.0 |
| 2000-06-30 | IYF | ETF | 35.8125 | 35.8125 | 35.7812 | 35.8125 | 600.0 |
| 2000-06-30 | IYG | ETF | 27.1042 | 27.1042 | 26.7083 | 26.7083 | 3900.0 |
| 2000-06-30 | IYH | ETF | 13.0062 | 13.025 | 12.925 | 12.95 | 441000.0 |
| 2000-06-30 | IYR | ETF | 35.7969 | 35.8125 | 35.375 | 35.375 | 2800.0 |
| 2000-06-30 | IYW | ETF | 31.6328 | 31.8906 | 31.625 | 31.8906 | 710400.0 |
> showing 50 of 69 rows — these rows as CSV