PREVIEW / etf_daily / 2000-10-16
file: by_date/etf_daily/2000/2000-10-16.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-16 | SPY | ETF | 137.4062 | 138.2344 | 136.6875 | 138.1875 | 5659000.0 |
| 2000-10-16 | QQQ | ETF | 81.125 | 82.3125 | 79.75 | 82.0 | 27644900.0 |
| 2000-10-16 | IWM | ETF | 48.0 | 48.5312 | 47.7188 | 48.125 | 1098000.0 |
| 2000-10-16 | DIA | ETF | 102.2344 | 102.9375 | 102.0156 | 102.7031 | 566400.0 |
| 2000-10-16 | BBH | ETF | 56.0833 | 57.8958 | 55.6875 | 57.8125 | 2864400.0 |
| 2000-10-16 | BITS | ETF | 9.25 | 11.5 | 8.5 | 8.75 | 34275.0 |
| 2000-10-16 | CEF | ETF | 3.1875 | 3.25 | 3.1875 | 3.25 | 12600.0 |
| 2000-10-16 | CHB | ETF | 3.0 | 3.06 | 2.88 | 3.0 | 215000.0 |
| 2000-10-16 | CNXT | ETF | 35.11 | 35.94 | 33.75 | 35.0 | 3984990.0 |
| 2000-10-16 | EWA | ETF | 9.0 | 9.125 | 9.0 | 9.0625 | 30600.0 |
| 2000-10-16 | EWC | ETF | 15.6875 | 15.9375 | 15.6875 | 15.8125 | 186800.0 |
| 2000-10-16 | EWD | ETF | 20.1875 | 20.1875 | 20.0 | 20.0 | 2000.0 |
| 2000-10-16 | EWG | ETF | 18.125 | 18.1875 | 17.9375 | 18.1875 | 21600.0 |
| 2000-10-16 | EWH | ETF | 11.5 | 11.5 | 11.25 | 11.25 | 21000.0 |
| 2000-10-16 | EWI | ETF | 40.25 | 40.5 | 40.0 | 40.375 | 2950.0 |
| 2000-10-16 | EWJ | ETF | 51.75 | 52.0 | 51.25 | 51.75 | 46375.0 |
| 2000-10-16 | EWK | ETF | 12.0625 | 12.125 | 12.0625 | 12.125 | 1800.0 |
| 2000-10-16 | EWL | ETF | 14.625 | 14.625 | 14.25 | 14.25 | 8100.0 |
| 2000-10-16 | EWM | ETF | 22.0 | 22.25 | 22.0 | 22.25 | 2025.0 |
| 2000-10-16 | EWN | ETF | 21.5 | 21.5 | 21.5 | 21.5 | 1600.0 |
| 2000-10-16 | EWO | ETF | 7.1875 | 7.1875 | 7.0 | 7.1875 | 4700.0 |
| 2000-10-16 | EWP | ETF | 23.125 | 23.1875 | 22.875 | 23.125 | 7400.0 |
| 2000-10-16 | EWQ | ETF | 23.0625 | 23.125 | 22.875 | 23.125 | 9200.0 |
| 2000-10-16 | EWS | ETF | 12.75 | 12.75 | 12.625 | 12.625 | 7250.0 |
| 2000-10-16 | EWT | ETF | 25.0 | 25.0 | 24.25 | 24.25 | 51450.0 |
| 2000-10-16 | EWU | ETF | 35.0 | 35.0 | 34.375 | 34.75 | 19750.0 |
| 2000-10-16 | EWW | ETF | 14.125 | 14.375 | 14.0625 | 14.0625 | 42900.0 |
| 2000-10-16 | EWY | ETF | 14.0625 | 14.0625 | 14.0 | 14.0 | 700.0 |
| 2000-10-16 | EWZ | ETF | 17.4375 | 17.4375 | 17.4375 | 17.4375 | 5800.0 |
| 2000-10-16 | EZU | ETF | 33.7188 | 33.9062 | 33.7188 | 33.9062 | 40200.0 |
| 2000-10-16 | FCTR | ETF | 14.0 | 14.125 | 14.0 | 14.0 | 30800.0 |
| 2000-10-16 | GLDB | ETF | 4.2344 | 4.5625 | 4.1875 | 4.375 | 74900.0 |
| 2000-10-16 | GSIG | ETF | 14.25 | 14.5 | 13.87 | 14.06 | 410200.0 |
| 2000-10-16 | IDU | ETF | 42.1328 | 42.2656 | 42.125 | 42.1719 | 4200.0 |
| 2000-10-16 | IEV | ETF | 35.9688 | 35.9688 | 35.6562 | 35.9688 | 14800.0 |
| 2000-10-16 | IGLD | ETF | 337.5 | 350.0 | 306.25 | 312.5 | 408.0 |
| 2000-10-16 | IJH | ETF | 10.025 | 10.1109 | 9.9719 | 10.0875 | 289000.0 |
| 2000-10-16 | IJJ | ETF | 18.6914 | 18.7656 | 18.6914 | 18.7656 | 8000.0 |
| 2000-10-16 | IJK | ETF | 16.4844 | 16.7344 | 16.4844 | 16.6914 | 110400.0 |
| 2000-10-16 | IJR | ETF | 17.2396 | 17.2943 | 17.1511 | 17.2031 | 25200.0 |
| 2000-10-16 | IJS | ETF | 17.25 | 17.332 | 17.25 | 17.2773 | 17200.0 |
| 2000-10-16 | IJT | ETF | 19.8828 | 20.0781 | 19.7812 | 20.0781 | 6400.0 |
| 2000-10-16 | IUSG | ETF | 30.6094 | 30.7266 | 30.2969 | 30.7266 | 7000.0 |
| 2000-10-16 | IUSV | ETF | 23.625 | 23.6302 | 23.6198 | 23.6198 | 3600.0 |
| 2000-10-16 | IVE | ETF | 60.125 | 60.4062 | 60.125 | 60.2188 | 176100.0 |
| 2000-10-16 | IVV | ETF | 137.5625 | 138.1406 | 136.7812 | 138.0625 | 349600.0 |
| 2000-10-16 | IVW | ETF | 19.7188 | 19.9062 | 19.6172 | 19.8281 | 502400.0 |
| 2000-10-16 | IWB | ETF | 73.25 | 73.68 | 73.25 | 73.64 | 7200.0 |
| 2000-10-16 | IWD | ETF | 55.9219 | 56.0312 | 55.7812 | 55.7969 | 27000.0 |
| 2000-10-16 | IWF | ETF | 19.207025 | 19.4414 | 19.16015 | 19.3047 | 93600.0 |
> showing 50 of 87 rows — these rows as CSV