PREVIEW / etf_daily / 2000-08-10
file: by_date/etf_daily/2000/2000-08-10.parquet size: 8 KB rows: 79
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-08-10 | SPY | ETF | 147.5312 | 147.8594 | 146.2812 | 146.7188 | 4193400.0 |
| 2000-08-10 | QQQ | ETF | 91.8125 | 92.2344 | 89.5 | 89.8125 | 15336200.0 |
| 2000-08-10 | IWM | ETF | 50.5469 | 50.5938 | 50.0938 | 50.25 | 43000.0 |
| 2000-08-10 | DIA | ETF | 109.0156 | 109.5938 | 108.8438 | 109.2188 | 429800.0 |
| 2000-08-10 | BBH | ETF | 61.625 | 61.625 | 59.0625 | 59.1875 | 1978500.0 |
| 2000-08-10 | BITS | ETF | 11.25 | 12.0 | 11.125 | 11.75 | 19275.0 |
| 2000-08-10 | BOSS | ETF | 21.0 | 21.0 | 21.0 | 21.0 | 100.0 |
| 2000-08-10 | CEF | ETF | 3.375 | 3.375 | 3.3125 | 3.3125 | 25700.0 |
| 2000-08-10 | CHB | ETF | 5.69 | 6.13 | 5.69 | 5.94 | 90400.0 |
| 2000-08-10 | CNXT | ETF | 29.78 | 30.15 | 27.94 | 28.09 | 3439980.0 |
| 2000-08-10 | EWA | ETF | 10.1875 | 10.375 | 10.1875 | 10.25 | 21000.0 |
| 2000-08-10 | EWC | ETF | 21.4375 | 21.4375 | 21.0 | 21.25 | 82000.0 |
| 2000-08-10 | EWD | ETF | 28.875 | 29.1875 | 28.875 | 29.1875 | 1600.0 |
| 2000-08-10 | EWG | ETF | 24.0 | 24.125 | 23.9375 | 24.0 | 34200.0 |
| 2000-08-10 | EWH | ETF | 13.375 | 13.4375 | 13.3125 | 13.375 | 20600.0 |
| 2000-08-10 | EWI | ETF | 50.625 | 50.75 | 50.25 | 50.75 | 5600.0 |
| 2000-08-10 | EWJ | ETF | 54.75 | 54.75 | 54.25 | 54.75 | 42700.0 |
| 2000-08-10 | EWK | ETF | 14.0625 | 14.0625 | 14.0 | 14.0 | 2000.0 |
| 2000-08-10 | EWL | ETF | 16.25 | 16.25 | 16.0 | 16.0 | 11300.0 |
| 2000-08-10 | EWM | ETF | 24.0 | 24.25 | 23.75 | 24.25 | 39825.0 |
| 2000-08-10 | EWN | ETF | 24.125 | 24.125 | 23.875 | 24.0625 | 900.0 |
| 2000-08-10 | EWO | ETF | 8.0 | 8.0 | 7.9375 | 7.9375 | 10200.0 |
| 2000-08-10 | EWQ | ETF | 27.9375 | 28.0 | 27.8125 | 27.9375 | 24500.0 |
| 2000-08-10 | EWS | ETF | 15.125 | 15.375 | 15.125 | 15.125 | 40100.0 |
| 2000-08-10 | EWT | ETF | 36.875 | 36.875 | 36.75 | 36.875 | 950850.0 |
| 2000-08-10 | EWU | ETF | 38.75 | 38.75 | 38.25 | 38.25 | 10800.0 |
| 2000-08-10 | EWW | ETF | 16.5625 | 16.5625 | 16.3125 | 16.5 | 12900.0 |
| 2000-08-10 | EWY | ETF | 19.0 | 19.5 | 19.0 | 19.1875 | 3800.0 |
| 2000-08-10 | EWZ | ETF | 19.0 | 19.0 | 19.0 | 19.0 | 200.0 |
| 2000-08-10 | EZU | ETF | 38.7812 | 38.7812 | 38.7188 | 38.7188 | 2600.0 |
| 2000-08-10 | FCTR | ETF | 15.0 | 15.25 | 15.0 | 15.1875 | 12100.0 |
| 2000-08-10 | FMAR | ETF | 5.0 | 5.25 | 5.0 | 5.12 | 5200.0 |
| 2000-08-10 | GLDB | ETF | 4.8125 | 4.9688 | 4.75 | 4.9688 | 24400.0 |
| 2000-08-10 | GSIG | ETF | 23.94 | 24.0 | 22.37 | 22.62 | 755800.0 |
| 2000-08-10 | IDU | ETF | 37.8594 | 37.8594 | 37.8359 | 37.8516 | 1800.0 |
| 2000-08-10 | IEV | ETF | 38.75 | 38.75 | 38.3828 | 38.5938 | 14800.0 |
| 2000-08-10 | IGLD | ETF | 675.0 | 687.5 | 643.75 | 662.5 | 734.0 |
| 2000-08-10 | IJH | ETF | 10.1594 | 10.175 | 10.1094 | 10.1094 | 1052000.0 |
| 2000-08-10 | IJJ | ETF | 18.8789 | 18.8789 | 18.8789 | 18.8789 | 800.0 |
| 2000-08-10 | IJK | ETF | 16.9023 | 16.9023 | 16.8281 | 16.8281 | 4800.0 |
| 2000-08-10 | IJR | ETF | 17.4167 | 17.4219 | 17.4063 | 17.4063 | 9600.0 |
| 2000-08-10 | IJT | ETF | 20.2812 | 20.2812 | 20.2734 | 20.2734 | 1200.0 |
| 2000-08-10 | IUSG | ETF | 33.5 | 33.5234 | 33.5 | 33.5234 | 400.0 |
| 2000-08-10 | IVE | ETF | 61.8281 | 61.8281 | 61.5781 | 61.5781 | 8100.0 |
| 2000-08-10 | IVV | ETF | 147.5312 | 147.6094 | 146.3438 | 146.4219 | 118000.0 |
| 2000-08-10 | IVW | ETF | 22.0078 | 22.1094 | 21.875 | 21.875 | 17200.0 |
| 2000-08-10 | IWB | ETF | 77.8594 | 77.9844 | 77.6562 | 77.6562 | 5800.0 |
| 2000-08-10 | IWD | ETF | 56.7188 | 56.7812 | 56.6875 | 56.6875 | 1700.0 |
| 2000-08-10 | IWF | ETF | 21.203125 | 21.3203 | 21.0 | 21.0625 | 48400.0 |
| 2000-08-10 | IWN | ETF | 35.3333 | 35.3333 | 35.3333 | 35.3333 | 2700.0 |
> showing 50 of 79 rows — these rows as CSV