PREVIEW / etf_daily / 2000-10-09
file: by_date/etf_daily/2000/2000-10-09.parquet size: 8 KB rows: 87
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-10-09 | SPY | ETF | 141.3125 | 141.3125 | 139.375 | 140.0 | 4508000.0 |
| 2000-10-09 | QQQ | ETF | 82.5625 | 83.8125 | 79.375 | 82.625 | 28834600.0 |
| 2000-10-09 | IWM | ETF | 48.875 | 48.875 | 48.3125 | 48.7344 | 361800.0 |
| 2000-10-09 | DIA | ETF | 106.0312 | 106.5312 | 105.5781 | 105.7969 | 555100.0 |
| 2000-10-09 | BBH | ETF | 58.0208 | 58.3125 | 55.6875 | 58.1667 | 3086700.0 |
| 2000-10-09 | BITS | ETF | 13.25 | 14.0 | 13.125 | 13.375 | 2575.0 |
| 2000-10-09 | CEF | ETF | 3.25 | 3.25 | 3.1875 | 3.1875 | 3200.0 |
| 2000-10-09 | CHB | ETF | 3.94 | 4.0 | 3.63 | 3.69 | 371400.0 |
| 2000-10-09 | CNXT | ETF | 37.69 | 38.81 | 35.63 | 37.19 | 4267660.0 |
| 2000-10-09 | CSB | ETF | 1.04999995231628 | 1.04999995231628 | 1.04999995231628 | 1.04999995231628 | 100.0 |
| 2000-10-09 | DGT | ETF | 83.3906 | 83.3906 | 83.3906 | 83.3906 | 2000.0 |
| 2000-10-09 | EWA | ETF | 9.3125 | 9.3125 | 9.1875 | 9.25 | 11300.0 |
| 2000-10-09 | EWC | ETF | 16.0625 | 16.125 | 16.0 | 16.125 | 18000.0 |
| 2000-10-09 | EWD | ETF | 20.875 | 20.875 | 20.375 | 20.5 | 3000.0 |
| 2000-10-09 | EWG | ETF | 18.75 | 18.8125 | 18.625 | 18.6875 | 15100.0 |
| 2000-10-09 | EWH | ETF | 11.875 | 11.875 | 11.5625 | 11.6875 | 61400.0 |
| 2000-10-09 | EWI | ETF | 41.25 | 41.25 | 41.25 | 41.25 | 350.0 |
| 2000-10-09 | EWJ | ETF | 52.75 | 53.0 | 52.5 | 53.0 | 28475.0 |
| 2000-10-09 | EWK | ETF | 12.25 | 12.25 | 12.25 | 12.25 | 900.0 |
| 2000-10-09 | EWL | ETF | 14.8125 | 14.8125 | 14.75 | 14.75 | 4000.0 |
| 2000-10-09 | EWM | ETF | 20.25 | 20.75 | 20.25 | 20.75 | 5300.0 |
| 2000-10-09 | EWN | ETF | 22.125 | 22.25 | 22.0 | 22.25 | 900.0 |
| 2000-10-09 | EWO | ETF | 7.5625 | 7.5625 | 7.5625 | 7.5625 | 200.0 |
| 2000-10-09 | EWP | ETF | 24.0 | 24.1875 | 23.9375 | 24.0 | 11500.0 |
| 2000-10-09 | EWQ | ETF | 24.0 | 24.0 | 23.625 | 23.625 | 14100.0 |
| 2000-10-09 | EWS | ETF | 13.0 | 13.0 | 12.625 | 12.75 | 16250.0 |
| 2000-10-09 | EWT | ETF | 27.375 | 27.625 | 27.375 | 27.625 | 15150.0 |
| 2000-10-09 | EWU | ETF | 35.0 | 35.25 | 34.875 | 34.875 | 8900.0 |
| 2000-10-09 | EWW | ETF | 14.5625 | 14.5625 | 14.375 | 14.5625 | 12800.0 |
| 2000-10-09 | EWY | ETF | 15.0625 | 15.0625 | 15.0 | 15.0 | 1600.0 |
| 2000-10-09 | EWZ | ETF | 17.1875 | 17.1875 | 17.1875 | 17.1875 | 100.0 |
| 2000-10-09 | EZU | ETF | 35.125 | 35.125 | 35.0 | 35.0 | 1600.0 |
| 2000-10-09 | FCTR | ETF | 14.1875 | 14.1875 | 14.0 | 14.1875 | 11000.0 |
| 2000-10-09 | FMAR | ETF | 5.0 | 5.25 | 5.0 | 5.25 | 8000.0 |
| 2000-10-09 | GLDB | ETF | 5.1094 | 5.25 | 5.0313 | 5.25 | 38200.0 |
| 2000-10-09 | GSIG | ETF | 15.11 | 15.12 | 13.56 | 14.94 | 166200.0 |
| 2000-10-09 | IDU | ETF | 41.8594 | 41.8594 | 41.625 | 41.75 | 2600.0 |
| 2000-10-09 | IEV | ETF | 36.6875 | 36.6875 | 36.625 | 36.6875 | 7600.0 |
| 2000-10-09 | IGLD | ETF | 412.5 | 412.5 | 362.5 | 381.25 | 804.0 |
| 2000-10-09 | IJH | ETF | 10.2594 | 10.275 | 10.0984 | 10.2469 | 480000.0 |
| 2000-10-09 | IJJ | ETF | 19.1406 | 19.1484 | 19.0938 | 19.1406 | 14800.0 |
| 2000-10-09 | IJK | ETF | 16.875 | 17.0566 | 16.875 | 16.9668 | 20000.0 |
| 2000-10-09 | IJR | ETF | 17.2136 | 17.2136 | 16.974 | 17.2083 | 52800.0 |
| 2000-10-09 | IJS | ETF | 17.4297 | 17.4297 | 17.2734 | 17.375 | 110800.0 |
| 2000-10-09 | IJT | ETF | 19.4688 | 19.4688 | 19.4688 | 19.4688 | 1200.0 |
| 2000-10-09 | IUSV | ETF | 24.2708 | 24.2708 | 24.1927 | 24.2031 | 2700.0 |
| 2000-10-09 | IVE | ETF | 62.125 | 62.125 | 61.75 | 61.9844 | 7700.0 |
| 2000-10-09 | IVV | ETF | 141.125 | 141.2031 | 139.6406 | 140.3281 | 29300.0 |
| 2000-10-09 | IVW | ETF | 20.1719 | 20.1992 | 19.9258 | 20.043 | 124000.0 |
| 2000-10-09 | IWB | ETF | 75.16 | 75.16 | 74.62 | 75.15 | 163300.0 |
> showing 50 of 87 rows — these rows as CSV