PREVIEW / etf_daily / 2000-12-27
file: by_date/etf_daily/2000/2000-12-27.parquet size: 8 KB rows: 93
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-12-27 | SPY | ETF | 131.75 | 133.7344 | 131.25 | 133.3125 | 4854100.0 |
| 2000-12-27 | QQQ | ETF | 59.6875 | 62.1875 | 58.9375 | 61.5625 | 33955500.0 |
| 2000-12-27 | IWM | ETF | 46.5 | 47.75 | 46.1875 | 47.75 | 741200.0 |
| 2000-12-27 | DIA | ETF | 107.0 | 108.4375 | 106.3125 | 108.4375 | 1769600.0 |
| 2000-12-27 | BBH | ETF | 57.0833 | 57.8542 | 56.2292 | 57.7708 | 980700.0 |
| 2000-12-27 | BITS | ETF | 8.25 | 9.25 | 8.0 | 9.0 | 42225.0 |
| 2000-12-27 | BOSS | ETF | 23.5 | 23.5 | 22.5 | 22.5 | 600.0 |
| 2000-12-27 | CEF | ETF | 3.125 | 3.3125 | 3.125 | 3.25 | 52000.0 |
| 2000-12-27 | CHB | ETF | 2.75 | 2.75 | 2.5 | 2.75 | 122600.0 |
| 2000-12-27 | CNXT | ETF | 15.031 | 15.282 | 14.154 | 14.969 | 6218630.0 |
| 2000-12-27 | EWA | ETF | 9.4375 | 9.5625 | 9.4375 | 9.5625 | 23200.0 |
| 2000-12-27 | EWC | ETF | 12.875 | 13.0 | 12.875 | 13.0 | 23300.0 |
| 2000-12-27 | EWD | ETF | 17.75 | 18.125 | 17.75 | 18.125 | 2600.0 |
| 2000-12-27 | EWG | ETF | 19.0 | 19.1875 | 18.875 | 19.125 | 113600.0 |
| 2000-12-27 | EWH | ETF | 11.4375 | 11.4375 | 11.3125 | 11.375 | 36000.0 |
| 2000-12-27 | EWI | ETF | 44.625 | 44.625 | 44.375 | 44.625 | 5650.0 |
| 2000-12-27 | EWJ | ETF | 44.0 | 44.5 | 44.0 | 44.5 | 69400.0 |
| 2000-12-27 | EWK | ETF | 12.875 | 12.875 | 12.875 | 12.875 | 3700.0 |
| 2000-12-27 | EWL | ETF | 16.25 | 16.6875 | 16.25 | 16.6875 | 18800.0 |
| 2000-12-27 | EWM | ETF | 20.25 | 20.5 | 20.0 | 20.0 | 11600.0 |
| 2000-12-27 | EWN | ETF | 22.3125 | 22.625 | 22.3125 | 22.5625 | 10800.0 |
| 2000-12-27 | EWO | ETF | 7.625 | 7.625 | 7.4375 | 7.625 | 6200.0 |
| 2000-12-27 | EWP | ETF | 22.9375 | 22.9375 | 22.875 | 22.875 | 3600.0 |
| 2000-12-27 | EWQ | ETF | 24.125 | 24.25 | 24.125 | 24.1875 | 11100.0 |
| 2000-12-27 | EWS | ETF | 12.75 | 12.875 | 12.625 | 12.625 | 29600.0 |
| 2000-12-27 | EWT | ETF | 20.0 | 20.0 | 19.5 | 19.5 | 1900.0 |
| 2000-12-27 | EWU | ETF | 35.0 | 35.875 | 35.0 | 35.75 | 29350.0 |
| 2000-12-27 | EWW | ETF | 13.125 | 13.4375 | 13.0625 | 13.25 | 34700.0 |
| 2000-12-27 | EWY | ETF | 12.0 | 12.25 | 12.0 | 12.0 | 1500.0 |
| 2000-12-27 | EWZ | ETF | 15.875 | 15.875 | 15.875 | 15.875 | 600.0 |
| 2000-12-27 | EZU | ETF | 35.625 | 36.2188 | 35.5938 | 36.2188 | 42200.0 |
| 2000-12-27 | FCTR | ETF | 13.75 | 14.1875 | 13.75 | 14.1875 | 42100.0 |
| 2000-12-27 | FMAR | ETF | 3.88 | 3.9405 | 3.8777 | 3.88 | 9100.0 |
| 2000-12-27 | GLDB | ETF | 4.0625 | 4.3125 | 4.0625 | 4.3125 | 151800.0 |
| 2000-12-27 | GSIG | ETF | 8.12 | 8.25 | 7.62 | 7.94 | 455200.0 |
| 2000-12-27 | IDU | ETF | 44.875 | 44.875 | 44.4531 | 44.6094 | 12200.0 |
| 2000-12-27 | IEV | ETF | 37.4688 | 37.7812 | 37.4688 | 37.6094 | 108000.0 |
| 2000-12-27 | IGLD | ETF | 175.0 | 181.25 | 128.125 | 131.25 | 851.0 |
| 2000-12-27 | IJH | ETF | 10.0562 | 10.2906 | 10.0562 | 10.2906 | 1046000.0 |
| 2000-12-27 | IJJ | ETF | 20.7461 | 20.9688 | 20.7461 | 20.9688 | 25200.0 |
| 2000-12-27 | IJK | ETF | 15.1562 | 15.6367 | 15.1562 | 15.6367 | 33600.0 |
| 2000-12-27 | IJR | ETF | 17.3125 | 17.7708 | 17.3125 | 17.7708 | 197400.0 |
| 2000-12-27 | IJS | ETF | 18.1875 | 18.75 | 18.1875 | 18.75 | 11600.0 |
| 2000-12-27 | IJT | ETF | 18.9062 | 19.5156 | 18.9062 | 19.5 | 77200.0 |
| 2000-12-27 | IOO | ETF | 35.1484 | 35.1484 | 35.0 | 35.1172 | 600.0 |
| 2000-12-27 | IUSG | ETF | 25.6875 | 26.1094 | 25.6875 | 26.1094 | 15600.0 |
| 2000-12-27 | IUSV | ETF | 24.9688 | 25.1823 | 24.9479 | 25.1823 | 32400.0 |
| 2000-12-27 | IVE | ETF | 63.0625 | 63.875 | 63.0 | 63.625 | 323900.0 |
| 2000-12-27 | IVV | ETF | 131.6875 | 133.4844 | 131.4375 | 133.4844 | 166600.0 |
| 2000-12-27 | IVW | ETF | 17.2344 | 17.5586 | 17.1992 | 17.3789 | 414000.0 |
> showing 50 of 93 rows — these rows as CSV