PREVIEW / etf_daily / 2000-07-12
file: by_date/etf_daily/2000/2000-07-12.parquet size: 7 KB rows: 68
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-12 | SPY | ETF | 149.2812 | 150.125 | 148.6875 | 149.125 | 5883000.0 |
| 2000-07-12 | QQQ | ETF | 95.4375 | 97.75 | 94.625 | 97.25 | 18252600.0 |
| 2000-07-12 | IWM | ETF | 53.3125 | 54.0938 | 53.25 | 54.0938 | 45200.0 |
| 2000-07-12 | DIA | ETF | 108.1562 | 108.5938 | 107.5469 | 107.8125 | 977100.0 |
| 2000-07-12 | BBH | ETF | 66.9583 | 67.3333 | 64.4375 | 64.8125 | 2108100.0 |
| 2000-07-12 | BITS | ETF | 20.75 | 22.5 | 19.125 | 20.0 | 30600.0 |
| 2000-07-12 | CEF | ETF | 3.375 | 3.375 | 3.375 | 3.375 | 18400.0 |
| 2000-07-12 | CHB | ETF | 5.44 | 5.44 | 5.38 | 5.44 | 31200.0 |
| 2000-07-12 | CNXT | ETF | 50.66 | 52.79 | 49.1 | 52.66 | 3752580.0 |
| 2000-07-12 | EWA | ETF | 10.625 | 10.75 | 10.5625 | 10.75 | 8400.0 |
| 2000-07-12 | EWC | ETF | 20.25 | 20.5 | 20.25 | 20.375 | 44400.0 |
| 2000-07-12 | EWD | ETF | 31.625 | 31.875 | 31.4375 | 31.875 | 3000.0 |
| 2000-07-12 | EWG | ETF | 24.4375 | 24.625 | 24.125 | 24.4375 | 56400.0 |
| 2000-07-12 | EWH | ETF | 13.5625 | 13.9375 | 13.5625 | 13.875 | 195500.0 |
| 2000-07-12 | EWI | ETF | 54.0 | 54.0 | 53.125 | 53.25 | 7000.0 |
| 2000-07-12 | EWJ | ETF | 60.25 | 60.25 | 59.5 | 60.25 | 74000.0 |
| 2000-07-12 | EWK | ETF | 14.0 | 14.125 | 14.0 | 14.125 | 3700.0 |
| 2000-07-12 | EWL | ETF | 16.3125 | 16.375 | 16.125 | 16.375 | 11500.0 |
| 2000-07-12 | EWM | ETF | 25.75 | 26.25 | 25.75 | 26.25 | 23700.0 |
| 2000-07-12 | EWN | ETF | 24.8125 | 25.0 | 24.75 | 25.0 | 5500.0 |
| 2000-07-12 | EWO | ETF | 7.6875 | 7.8125 | 7.6875 | 7.8125 | 11000.0 |
| 2000-07-12 | EWP | ETF | 26.75 | 27.0625 | 26.375 | 26.375 | 2500.0 |
| 2000-07-12 | EWQ | ETF | 29.25 | 29.25 | 28.8125 | 29.0 | 30000.0 |
| 2000-07-12 | EWS | ETF | 15.375 | 15.5 | 15.25 | 15.5 | 19750.0 |
| 2000-07-12 | EWT | ETF | 36.75 | 36.75 | 36.75 | 36.75 | 100.0 |
| 2000-07-12 | EWU | ETF | 39.875 | 39.875 | 39.375 | 39.5 | 17850.0 |
| 2000-07-12 | EWW | ETF | 18.0625 | 18.1875 | 17.8125 | 18.0625 | 18200.0 |
| 2000-07-12 | EWY | ETF | 21.25 | 21.625 | 21.25 | 21.5625 | 21300.0 |
| 2000-07-12 | FCTR | ETF | 15.6875 | 15.875 | 15.1875 | 15.875 | 11600.0 |
| 2000-07-12 | FMAR | ETF | 5.5 | 5.75 | 5.499 | 5.56 | 7900.0 |
| 2000-07-12 | GLDB | ETF | 4.7969 | 5.125 | 4.625 | 4.9375 | 182000.0 |
| 2000-07-12 | GSIG | ETF | 33.59 | 37.31 | 33.44 | 37.06 | 1117300.0 |
| 2000-07-12 | IDU | ETF | 35.0 | 35.0 | 34.9375 | 34.9375 | 400.0 |
| 2000-07-12 | IGLD | ETF | 903.125 | 981.25 | 887.5 | 962.5 | 2311.0 |
| 2000-07-12 | IJH | ETF | 10.2188 | 10.2844 | 10.2 | 10.2812 | 1243000.0 |
| 2000-07-12 | IJR | ETF | 18.2396 | 18.3203 | 18.2396 | 18.2943 | 18600.0 |
| 2000-07-12 | IVE | ETF | 61.0625 | 61.0938 | 60.6875 | 60.6875 | 29600.0 |
| 2000-07-12 | IVV | ETF | 149.25 | 149.9375 | 148.875 | 149.0938 | 2642100.0 |
| 2000-07-12 | IVW | ETF | 22.836 | 23.0156 | 22.7578 | 22.918 | 108800.0 |
| 2000-07-12 | IWB | ETF | 79.0625 | 79.2812 | 79.0625 | 79.2812 | 700.0 |
| 2000-07-12 | IWD | ETF | 56.1406 | 56.1406 | 55.7656 | 55.7656 | 1000.0 |
| 2000-07-12 | IWF | ETF | 22.105475 | 22.261725 | 22.02345 | 22.230475 | 82000.0 |
| 2000-07-12 | IWV | ETF | 81.875 | 81.9375 | 81.7812 | 81.9219 | 1300.0 |
| 2000-07-12 | IYE | ETF | 16.5833 | 16.5833 | 16.25 | 16.25 | 32700.0 |
| 2000-07-12 | IYF | ETF | 37.6875 | 38.125 | 37.6875 | 37.9219 | 3400.0 |
| 2000-07-12 | IYG | ETF | 28.8333 | 29.1875 | 28.8333 | 28.8958 | 22200.0 |
| 2000-07-12 | IYH | ETF | 13.6687 | 13.6687 | 13.4625 | 13.5312 | 560000.0 |
| 2000-07-12 | IYR | ETF | 36.25 | 36.25 | 36.0625 | 36.0625 | 8800.0 |
| 2000-07-12 | IYW | ETF | 32.1094 | 32.6406 | 31.9844 | 32.6172 | 47200.0 |
| 2000-07-12 | IYY | ETF | 34.8281 | 35.0547 | 34.8203 | 35.0156 | 4200.0 |
> showing 50 of 68 rows — these rows as CSV