PREVIEW / etf_daily / 2000-10-19
file: by_date/etf_daily/2000/2000-10-19.parquet size: 8 KB rows: 82
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-19 | SPY | ETF | 136.8438 | 139.4531 | 136.4375 | 139.3125 | 8767300.0 |
| 2000-10-19 | QQQ | ETF | 82.3906 | 85.1094 | 81.4375 | 85.0625 | 42447400.0 |
| 2000-10-19 | IWM | ETF | 47.2812 | 48.0938 | 47.2812 | 47.9688 | 150600.0 |
| 2000-10-19 | DIA | ETF | 101.25 | 101.875 | 100.5156 | 101.8438 | 1539600.0 |
| 2000-10-19 | BBH | ETF | 59.9167 | 59.9167 | 58.3542 | 59.625 | 2380500.0 |
| 2000-10-19 | BITS | ETF | 9.5 | 9.875 | 7.125 | 8.0 | 15900.0 |
| 2000-10-19 | CEF | ETF | 3.125 | 3.125 | 3.0625 | 3.0625 | 9600.0 |
| 2000-10-19 | CHB | ETF | 3.31 | 3.5 | 3.25 | 3.25 | 395200.0 |
| 2000-10-19 | CNXT | ETF | 24.43 | 29.87 | 24.37 | 29.49 | 21584910.0 |
| 2000-10-19 | DGT | ETF | 81.5938 | 81.8906 | 81.1094 | 81.8906 | 1000.0 |
| 2000-10-19 | EWA | ETF | 8.9375 | 9.125 | 8.75 | 9.125 | 43700.0 |
| 2000-10-19 | EWC | ETF | 15.3125 | 15.75 | 15.3125 | 15.75 | 19700.0 |
| 2000-10-19 | EWD | ETF | 19.5 | 20.3125 | 19.5 | 20.125 | 10400.0 |
| 2000-10-19 | EWG | ETF | 17.8125 | 18.0625 | 17.8125 | 18.0625 | 34100.0 |
| 2000-10-19 | EWH | ETF | 10.8125 | 11.375 | 10.8125 | 11.25 | 75500.0 |
| 2000-10-19 | EWI | ETF | 40.375 | 41.0 | 40.375 | 41.0 | 10800.0 |
| 2000-10-19 | EWJ | ETF | 50.5 | 51.25 | 50.5 | 51.25 | 109975.0 |
| 2000-10-19 | EWK | ETF | 11.875 | 12.3125 | 11.8125 | 12.3125 | 2100.0 |
| 2000-10-19 | EWL | ETF | 14.5 | 14.8125 | 14.4375 | 14.8125 | 6200.0 |
| 2000-10-19 | EWM | ETF | 22.25 | 22.5 | 22.25 | 22.25 | 16700.0 |
| 2000-10-19 | EWN | ETF | 21.1875 | 21.9375 | 21.1875 | 21.9375 | 2600.0 |
| 2000-10-19 | EWO | ETF | 6.8125 | 6.875 | 6.75 | 6.875 | 12500.0 |
| 2000-10-19 | EWP | ETF | 22.5 | 23.4375 | 22.4375 | 23.4375 | 9000.0 |
| 2000-10-19 | EWQ | ETF | 22.5625 | 23.0 | 22.5625 | 23.0 | 30400.0 |
| 2000-10-19 | EWS | ETF | 12.875 | 13.25 | 12.75 | 13.25 | 46500.0 |
| 2000-10-19 | EWT | ETF | 22.5 | 23.75 | 22.125 | 23.5 | 29900.0 |
| 2000-10-19 | EWU | ETF | 35.125 | 35.5 | 34.5 | 35.5 | 8700.0 |
| 2000-10-19 | EWW | ETF | 14.25 | 14.625 | 14.1875 | 14.625 | 43100.0 |
| 2000-10-19 | EWY | ETF | 13.4375 | 13.6875 | 13.4375 | 13.6875 | 13300.0 |
| 2000-10-19 | EWZ | ETF | 17.1875 | 17.1875 | 17.1875 | 17.1875 | 2000.0 |
| 2000-10-19 | EZU | ETF | 33.6875 | 33.8438 | 33.5625 | 33.8438 | 3200.0 |
| 2000-10-19 | FCTR | ETF | 14.625 | 15.6875 | 14.625 | 15.5 | 45500.0 |
| 2000-10-19 | FMAR | ETF | 5.0 | 5.0 | 5.0 | 5.0 | 2200.0 |
| 2000-10-19 | GLDB | ETF | 3.875 | 4.0 | 3.875 | 3.9375 | 145200.0 |
| 2000-10-19 | GSIG | ETF | 13.12 | 13.62 | 13.12 | 13.37 | 272200.0 |
| 2000-10-19 | IDU | ETF | 40.8125 | 41.0 | 40.4844 | 41.0 | 10600.0 |
| 2000-10-19 | IEV | ETF | 35.9688 | 36.1562 | 35.8438 | 36.0938 | 30200.0 |
| 2000-10-19 | IGLD | ETF | 300.0 | 303.125 | 287.5 | 293.75 | 436.0 |
| 2000-10-19 | IJH | ETF | 10.0125 | 10.175 | 10.0094 | 10.175 | 1049000.0 |
| 2000-10-19 | IJJ | ETF | 18.5312 | 18.6562 | 18.5312 | 18.6562 | 13600.0 |
| 2000-10-19 | IJK | ETF | 16.5625 | 17.0078 | 16.5625 | 16.9297 | 2546400.0 |
| 2000-10-19 | IJR | ETF | 16.9375 | 17.2162 | 16.9375 | 17.2162 | 30000.0 |
| 2000-10-19 | IJS | ETF | 16.9219 | 16.9766 | 16.8633 | 16.9766 | 1200.0 |
| 2000-10-19 | IJT | ETF | 19.8633 | 20.0 | 19.8633 | 20.0 | 1200.0 |
| 2000-10-19 | IUSG | ETF | 30.25 | 30.5469 | 30.25 | 30.5469 | 3200.0 |
| 2000-10-19 | IUSV | ETF | 23.4219 | 23.6406 | 23.4219 | 23.6406 | 1200.0 |
| 2000-10-19 | IVE | ETF | 59.875 | 60.75 | 59.875 | 60.375 | 182200.0 |
| 2000-10-19 | IVV | ETF | 136.75 | 139.1875 | 136.7031 | 139.1875 | 73300.0 |
| 2000-10-19 | IVW | ETF | 19.711 | 20.0938 | 19.6367 | 20.0938 | 175200.0 |
| 2000-10-19 | IWB | ETF | 73.02 | 74.14 | 73.02 | 74.14 | 19500.0 |
> showing 50 of 82 rows — these rows as CSV