PREVIEW / etf_daily / 2000-09-05
file: by_date/etf_daily/2000/2000-09-05.parquet size: 8 KB rows: 84
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-09-05 | SPY | ETF | 151.875 | 152.2031 | 150.8125 | 151.2812 | 3470800.0 |
| 2000-09-05 | QQQ | ETF | 101.625 | 101.75 | 99.4219 | 99.5 | 16348300.0 |
| 2000-09-05 | IWM | ETF | 54.1172 | 54.2812 | 53.8125 | 53.8125 | 110400.0 |
| 2000-09-05 | DIA | ETF | 111.9375 | 113.125 | 111.8125 | 112.8594 | 375700.0 |
| 2000-09-05 | BBH | ETF | 67.6042 | 67.7917 | 64.6667 | 64.6667 | 1554900.0 |
| 2000-09-05 | BITS | ETF | 19.5 | 22.75 | 18.625 | 19.875 | 36050.0 |
| 2000-09-05 | CEF | ETF | 3.3125 | 3.375 | 3.3125 | 3.3125 | 15800.0 |
| 2000-09-05 | CHB | ETF | 6.0 | 6.0 | 5.81 | 5.81 | 45800.0 |
| 2000-09-05 | CNXT | ETF | 37.69 | 38.75 | 35.25 | 35.37 | 3639630.0 |
| 2000-09-05 | EWA | ETF | 9.9375 | 10.25 | 9.9375 | 10.0 | 56000.0 |
| 2000-09-05 | EWC | ETF | 17.25 | 17.375 | 17.125 | 17.3125 | 90100.0 |
| 2000-09-05 | EWD | ETF | 25.1875 | 25.1875 | 24.75 | 24.8125 | 12400.0 |
| 2000-09-05 | EWG | ETF | 21.125 | 21.1875 | 20.9375 | 20.9375 | 50000.0 |
| 2000-09-05 | EWH | ETF | 13.6875 | 13.6875 | 13.5625 | 13.5625 | 19300.0 |
| 2000-09-05 | EWI | ETF | 45.125 | 45.375 | 45.125 | 45.125 | 8000.0 |
| 2000-09-05 | EWJ | ETF | 55.25 | 55.25 | 54.5 | 54.5 | 161525.0 |
| 2000-09-05 | EWK | ETF | 13.0625 | 13.3125 | 13.0625 | 13.125 | 27400.0 |
| 2000-09-05 | EWL | ETF | 15.6875 | 15.6875 | 15.4375 | 15.4375 | 58700.0 |
| 2000-09-05 | EWM | ETF | 23.0 | 23.25 | 22.75 | 22.75 | 18475.0 |
| 2000-09-05 | EWN | ETF | 24.0625 | 24.125 | 23.8125 | 23.875 | 19800.0 |
| 2000-09-05 | EWO | ETF | 7.875 | 7.875 | 7.8125 | 7.8125 | 13300.0 |
| 2000-09-05 | EWP | ETF | 24.75 | 25.0625 | 24.75 | 24.8125 | 22200.0 |
| 2000-09-05 | EWQ | ETF | 27.5 | 27.5625 | 27.25 | 27.25 | 51900.0 |
| 2000-09-05 | EWS | ETF | 15.125 | 15.375 | 15.0 | 15.125 | 39250.0 |
| 2000-09-05 | EWT | ETF | 33.5 | 33.5 | 33.5 | 33.5 | 750.0 |
| 2000-09-05 | EWU | ETF | 37.75 | 37.75 | 37.125 | 37.125 | 35300.0 |
| 2000-09-05 | EWW | ETF | 16.75 | 17.1875 | 16.6875 | 17.0625 | 27200.0 |
| 2000-09-05 | EWY | ETF | 18.25 | 18.5625 | 18.25 | 18.4375 | 16600.0 |
| 2000-09-05 | EWZ | ETF | 19.625 | 19.625 | 19.625 | 19.625 | 300.0 |
| 2000-09-05 | EZU | ETF | 39.0312 | 39.0312 | 39.0312 | 39.0312 | 200.0 |
| 2000-09-05 | FCTR | ETF | 16.0625 | 16.0625 | 15.875 | 16.0625 | 29200.0 |
| 2000-09-05 | FMAR | ETF | 5.25 | 5.5 | 5.125 | 5.5 | 2500.0 |
| 2000-09-05 | GLDB | ETF | 5.3125 | 5.3125 | 5.25 | 5.2813 | 76400.0 |
| 2000-09-05 | GSIG | ETF | 26.94 | 28.62 | 26.31 | 26.5 | 243000.0 |
| 2000-09-05 | IDU | ETF | 40.2188 | 40.4844 | 40.2188 | 40.4375 | 2800.0 |
| 2000-09-05 | IEV | ETF | 40.0 | 40.0938 | 39.9297 | 40.0312 | 16800.0 |
| 2000-09-05 | IGLD | ETF | 600.0 | 653.125 | 562.5 | 653.125 | 2526.0 |
| 2000-09-05 | IJH | ETF | 10.9625 | 10.9625 | 10.8797 | 10.8813 | 276000.0 |
| 2000-09-05 | IJJ | ETF | 19.6133 | 19.6133 | 19.5586 | 19.5586 | 2000.0 |
| 2000-09-05 | IJK | ETF | 18.9023 | 18.9023 | 18.582 | 18.582 | 39200.0 |
| 2000-09-05 | IJR | ETF | 18.7396 | 18.7396 | 18.5365 | 18.5547 | 160200.0 |
| 2000-09-05 | IJS | ETF | 18.1211 | 18.1211 | 18.1211 | 18.1211 | 400.0 |
| 2000-09-05 | IJT | ETF | 22.5 | 22.5 | 22.0938 | 22.0938 | 23600.0 |
| 2000-09-05 | IUSG | ETF | 35.7812 | 35.7812 | 35.6875 | 35.6875 | 2000.0 |
| 2000-09-05 | IUSV | ETF | 24.5729 | 24.5729 | 24.5 | 24.5 | 8400.0 |
| 2000-09-05 | IVE | ETF | 63.3594 | 63.5938 | 63.3125 | 63.5312 | 8400.0 |
| 2000-09-05 | IVV | ETF | 151.7812 | 152.0312 | 150.875 | 151.3594 | 140700.0 |
| 2000-09-05 | IVW | ETF | 22.8242 | 22.8242 | 22.5352 | 22.6172 | 25200.0 |
| 2000-09-05 | IWB | ETF | 81.25 | 81.2812 | 80.75 | 80.75 | 18000.0 |
| 2000-09-05 | IWD | ETF | 57.8438 | 58.0312 | 57.8438 | 57.9375 | 1600.0 |
> showing 50 of 84 rows — these rows as CSV