PREVIEW / etf_daily / 2000-11-21
file: by_date/etf_daily/2000/2000-11-21.parquet size: 8 KB rows: 86
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-11-21 | SPY | ETF | 134.875 | 136.1875 | 133.5156 | 135.375 | 7684300.0 |
| 2000-11-21 | QQQ | ETF | 70.1875 | 71.125 | 68.4375 | 69.75 | 42128600.0 |
| 2000-11-21 | IWM | ETF | 47.0625 | 47.0625 | 46.4375 | 46.6328 | 84400.0 |
| 2000-11-21 | DIA | ETF | 104.9688 | 105.875 | 104.1875 | 105.375 | 814700.0 |
| 2000-11-21 | BBH | ETF | 52.0417 | 52.2917 | 50.0 | 51.2083 | 4359000.0 |
| 2000-11-21 | BITS | ETF | 10.25 | 10.75 | 9.75 | 9.75 | 9200.0 |
| 2000-11-21 | CEF | ETF | 3.0 | 3.0 | 2.9375 | 2.9375 | 32400.0 |
| 2000-11-21 | CHB | ETF | 3.25 | 3.44 | 3.25 | 3.44 | 29200.0 |
| 2000-11-21 | CNXT | ETF | 28.65 | 29.27 | 26.78 | 26.97 | 2694860.0 |
| 2000-11-21 | DGT | ETF | 80.8438 | 80.8438 | 80.8438 | 80.8438 | 100.0 |
| 2000-11-21 | EWA | ETF | 9.0625 | 9.1875 | 9.0625 | 9.1875 | 132600.0 |
| 2000-11-21 | EWC | ETF | 13.4375 | 13.5625 | 13.375 | 13.5625 | 19300.0 |
| 2000-11-21 | EWD | ETF | 18.0 | 18.0625 | 17.8125 | 18.0625 | 1500.0 |
| 2000-11-21 | EWG | ETF | 18.1875 | 18.3125 | 18.0625 | 18.1875 | 49300.0 |
| 2000-11-21 | EWH | ETF | 11.1875 | 11.25 | 11.125 | 11.1875 | 28300.0 |
| 2000-11-21 | EWI | ETF | 43.375 | 43.625 | 43.125 | 43.125 | 13700.0 |
| 2000-11-21 | EWJ | ETF | 48.0 | 48.25 | 47.25 | 47.5 | 74425.0 |
| 2000-11-21 | EWK | ETF | 12.0 | 12.0 | 12.0 | 12.0 | 5700.0 |
| 2000-11-21 | EWL | ETF | 15.0625 | 15.125 | 15.0 | 15.0 | 11100.0 |
| 2000-11-21 | EWM | ETF | 21.5 | 21.75 | 21.5 | 21.75 | 10350.0 |
| 2000-11-21 | EWN | ETF | 21.9375 | 22.0625 | 21.8125 | 21.8125 | 4300.0 |
| 2000-11-21 | EWO | ETF | 7.25 | 7.25 | 7.0625 | 7.0625 | 600.0 |
| 2000-11-21 | EWP | ETF | 21.4375 | 21.625 | 21.375 | 21.375 | 4700.0 |
| 2000-11-21 | EWQ | ETF | 22.8125 | 23.0625 | 22.8125 | 22.875 | 19900.0 |
| 2000-11-21 | EWS | ETF | 13.25 | 13.25 | 13.0 | 13.0 | 9900.0 |
| 2000-11-21 | EWU | ETF | 34.875 | 35.125 | 34.75 | 34.875 | 6900.0 |
| 2000-11-21 | EWW | ETF | 15.125 | 15.3125 | 15.0 | 15.3125 | 16500.0 |
| 2000-11-21 | EWY | ETF | 13.5 | 13.5 | 13.5 | 13.5 | 15200.0 |
| 2000-11-21 | EZU | ETF | 34.3125 | 34.375 | 34.2188 | 34.2188 | 14000.0 |
| 2000-11-21 | FCTR | ETF | 14.6875 | 14.75 | 14.5625 | 14.75 | 4900.0 |
| 2000-11-21 | FMAR | ETF | 4.38 | 4.69 | 4.1297 | 4.28 | 7900.0 |
| 2000-11-21 | GLDB | ETF | 4.4375 | 4.4375 | 4.0 | 4.375 | 56300.0 |
| 2000-11-21 | GSIG | ETF | 11.12 | 11.94 | 11.12 | 11.87 | 393100.0 |
| 2000-11-21 | IDU | ETF | 42.2344 | 42.2344 | 41.6562 | 41.9062 | 24200.0 |
| 2000-11-21 | IEV | ETF | 36.375 | 36.5547 | 36.375 | 36.5547 | 23600.0 |
| 2000-11-21 | IGLD | ETF | 281.25 | 281.25 | 268.75 | 268.75 | 271.0 |
| 2000-11-21 | IJH | ETF | 9.925 | 9.9469 | 9.8125 | 9.8891 | 682000.0 |
| 2000-11-21 | IJJ | ETF | 19.4219 | 19.4375 | 19.25 | 19.4375 | 18000.0 |
| 2000-11-21 | IJK | ETF | 15.7774 | 15.7774 | 15.6172 | 15.6524 | 14400.0 |
| 2000-11-21 | IJR | ETF | 17.3802 | 17.3802 | 17.1458 | 17.1458 | 70800.0 |
| 2000-11-21 | IJS | ETF | 17.5781 | 17.6133 | 17.5781 | 17.6055 | 7600.0 |
| 2000-11-21 | IJT | ETF | 19.7148 | 19.7148 | 19.3867 | 19.3867 | 31600.0 |
| 2000-11-21 | IUSG | ETF | 28.0781 | 28.0781 | 27.9844 | 27.9844 | 8800.0 |
| 2000-11-21 | IUSV | ETF | 24.0521 | 24.1719 | 23.9948 | 24.1719 | 25200.0 |
| 2000-11-21 | IVE | ETF | 61.1875 | 61.4062 | 60.7188 | 61.3906 | 30100.0 |
| 2000-11-21 | IVV | ETF | 134.8438 | 136.0469 | 133.75 | 135.5781 | 159800.0 |
| 2000-11-21 | IVW | ETF | 18.7344 | 18.9453 | 18.586 | 18.7656 | 186400.0 |
| 2000-11-21 | IWB | ETF | 71.5 | 71.8 | 70.78 | 71.46 | 10500.0 |
| 2000-11-21 | IWD | ETF | 57.0 | 57.4375 | 56.5938 | 57.2969 | 18100.0 |
| 2000-11-21 | IWF | ETF | 17.832025 | 17.886725 | 17.6836 | 17.84765 | 132800.0 |
> showing 50 of 86 rows — these rows as CSV