PREVIEW / etf_daily / 2000-12-18
file: by_date/etf_daily/2000/2000-12-18.parquet size: 8 KB rows: 91
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-18 | SPY | ETF | 132.0625 | 133.4688 | 131.7656 | 132.7188 | 7235400.0 |
| 2000-12-18 | QQQ | ETF | 65.1563 | 65.9688 | 62.5625 | 64.0 | 42950000.0 |
| 2000-12-18 | IWM | ETF | 45.8438 | 46.4688 | 45.8125 | 46.3125 | 239600.0 |
| 2000-12-18 | DIA | ETF | 105.4375 | 106.7969 | 105.4062 | 106.6406 | 2611500.0 |
| 2000-12-18 | BBH | ETF | 56.9167 | 58.625 | 56.3542 | 57.6042 | 4722900.0 |
| 2000-12-18 | BITS | ETF | 12.0 | 13.75 | 12.0 | 12.75 | 38175.0 |
| 2000-12-18 | CEF | ETF | 3.0625 | 3.125 | 3.0 | 3.0625 | 29400.0 |
| 2000-12-18 | CHB | ETF | 3.0 | 3.19 | 2.81 | 2.94 | 202500.0 |
| 2000-12-18 | CNXT | ETF | 25.36 | 25.94 | 21.25 | 22.94 | 6197970.0 |
| 2000-12-18 | DGT | ETF | 79.1875 | 79.1875 | 78.0 | 78.0625 | 2900.0 |
| 2000-12-18 | EWA | ETF | 9.3125 | 9.4375 | 9.25 | 9.4375 | 6300.0 |
| 2000-12-18 | EWC | ETF | 13.5625 | 13.6875 | 13.5625 | 13.5625 | 2500.0 |
| 2000-12-18 | EWD | ETF | 18.125 | 18.25 | 18.0 | 18.25 | 226200.0 |
| 2000-12-18 | EWG | ETF | 18.5 | 18.625 | 18.25 | 18.3125 | 331200.0 |
| 2000-12-18 | EWH | ETF | 11.3125 | 11.375 | 11.25 | 11.375 | 57000.0 |
| 2000-12-18 | EWI | ETF | 43.25 | 43.25 | 42.375 | 42.375 | 16300.0 |
| 2000-12-18 | EWJ | ETF | 46.75 | 47.25 | 46.25 | 46.5 | 498700.0 |
| 2000-12-18 | EWK | ETF | 12.125 | 12.125 | 12.125 | 12.125 | 1300.0 |
| 2000-12-18 | EWL | ETF | 15.875 | 16.0625 | 15.8125 | 16.0625 | 123500.0 |
| 2000-12-18 | EWM | ETF | 21.25 | 21.25 | 21.25 | 21.25 | 9250.0 |
| 2000-12-18 | EWN | ETF | 21.5 | 21.625 | 21.375 | 21.375 | 3900.0 |
| 2000-12-18 | EWO | ETF | 7.25 | 7.25 | 7.25 | 7.25 | 1000.0 |
| 2000-12-18 | EWP | ETF | 21.875 | 22.125 | 21.8125 | 21.8125 | 29100.0 |
| 2000-12-18 | EWQ | ETF | 23.5625 | 23.5625 | 23.3125 | 23.3125 | 40900.0 |
| 2000-12-18 | EWS | ETF | 13.375 | 13.75 | 13.375 | 13.75 | 70600.0 |
| 2000-12-18 | EWT | ETF | 21.875 | 22.125 | 21.875 | 22.0 | 4800.0 |
| 2000-12-18 | EWU | ETF | 35.75 | 35.75 | 34.5 | 34.875 | 210900.0 |
| 2000-12-18 | EWW | ETF | 13.9375 | 14.0 | 13.75 | 13.75 | 13300.0 |
| 2000-12-18 | EWY | ETF | 13.5625 | 13.75 | 13.4375 | 13.75 | 18900.0 |
| 2000-12-18 | EWZ | ETF | 16.375 | 16.375 | 16.375 | 16.375 | 700.0 |
| 2000-12-18 | EZU | ETF | 35.25 | 35.3125 | 34.8125 | 34.8125 | 10000.0 |
| 2000-12-18 | FCTR | ETF | 13.5 | 14.0 | 13.0 | 13.9375 | 48500.0 |
| 2000-12-18 | FMAR | ETF | 3.75 | 4.05 | 3.75 | 3.94 | 5900.0 |
| 2000-12-18 | GLDB | ETF | 4.25 | 4.4688 | 4.25 | 4.375 | 133400.0 |
| 2000-12-18 | GSIG | ETF | 9.0 | 9.06 | 8.0 | 8.06 | 327400.0 |
| 2000-12-18 | IDU | ETF | 42.5 | 42.5312 | 42.5 | 42.5312 | 1000.0 |
| 2000-12-18 | IEV | ETF | 37.125 | 37.2812 | 37.0312 | 37.25 | 229200.0 |
| 2000-12-18 | IGLD | ETF | 200.0 | 200.0 | 187.5 | 190.625 | 240.0 |
| 2000-12-18 | IJH | ETF | 9.9781 | 10.0609 | 9.9656 | 9.9906 | 670000.0 |
| 2000-12-18 | IJJ | ETF | 19.7812 | 19.9727 | 19.7812 | 19.9688 | 31200.0 |
| 2000-12-18 | IJK | ETF | 15.75 | 15.752 | 15.5625 | 15.5625 | 33600.0 |
| 2000-12-18 | IJR | ETF | 17.1927 | 17.3333 | 17.1667 | 17.224 | 757200.0 |
| 2000-12-18 | IJS | ETF | 17.6953 | 17.875 | 17.6406 | 17.8438 | 54400.0 |
| 2000-12-18 | IJT | ETF | 19.2422 | 19.5078 | 19.2031 | 19.2461 | 18800.0 |
| 2000-12-18 | IOO | ETF | 35.1797 | 35.2656 | 34.8906 | 34.8906 | 7000.0 |
| 2000-12-18 | IUSG | ETF | 27.1172 | 27.1172 | 26.6172 | 26.6172 | 7000.0 |
| 2000-12-18 | IUSV | ETF | 24.2708 | 24.6667 | 24.2708 | 24.5625 | 21000.0 |
| 2000-12-18 | IVE | ETF | 61.625 | 62.375 | 61.5625 | 62.1562 | 21200.0 |
| 2000-12-18 | IVV | ETF | 132.5312 | 133.2344 | 131.9531 | 132.1406 | 141700.0 |
| 2000-12-18 | IVW | ETF | 18.0391 | 18.0391 | 17.6406 | 17.75 | 127600.0 |
> showing 50 of 91 rows — these rows as CSV