PREVIEW / etf_daily / 2000-12-20
file: by_date/etf_daily/2000/2000-12-20.parquet size: 8 KB rows: 92
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-20 | SPY | ETF | 128.625 | 128.9375 | 126.0938 | 126.25 | 9994300.0 |
| 2000-12-20 | QQQ | ETF | 57.3125 | 58.375 | 54.75 | 55.7344 | 81432100.0 |
| 2000-12-20 | IWM | ETF | 44.7344 | 45.0 | 43.9062 | 44.0625 | 261400.0 |
| 2000-12-20 | DIA | ETF | 104.0938 | 104.9062 | 102.9531 | 102.9531 | 2413500.0 |
| 2000-12-20 | BBH | ETF | 55.3333 | 55.9792 | 52.5417 | 52.9583 | 3485100.0 |
| 2000-12-20 | BITS | ETF | 11.5 | 12.5 | 11.0 | 12.0 | 11750.0 |
| 2000-12-20 | CEF | ETF | 3.0 | 3.25 | 3.0 | 3.0625 | 68500.0 |
| 2000-12-20 | CHB | ETF | 2.81 | 2.81 | 2.63 | 2.69 | 77600.0 |
| 2000-12-20 | CNXT | ETF | 20.37 | 22.25 | 20.12 | 20.37 | 5102350.0 |
| 2000-12-20 | DGT | ETF | 75.875 | 75.875 | 75.7656 | 75.7656 | 400.0 |
| 2000-12-20 | EWA | ETF | 9.4375 | 9.4375 | 9.25 | 9.3125 | 7600.0 |
| 2000-12-20 | EWC | ETF | 12.875 | 13.0 | 12.625 | 12.625 | 5800.0 |
| 2000-12-20 | EWD | ETF | 17.375 | 17.375 | 17.0 | 17.0 | 1700.0 |
| 2000-12-20 | EWG | ETF | 18.375 | 18.5 | 18.25 | 18.3125 | 55100.0 |
| 2000-12-20 | EWH | ETF | 11.125 | 11.1875 | 10.6875 | 10.875 | 118200.0 |
| 2000-12-20 | EWI | ETF | 43.0 | 43.25 | 42.875 | 42.875 | 8950.0 |
| 2000-12-20 | EWJ | ETF | 44.5 | 44.5 | 43.5 | 43.75 | 262350.0 |
| 2000-12-20 | EWK | ETF | 12.25 | 12.25 | 12.25 | 12.25 | 400.0 |
| 2000-12-20 | EWL | ETF | 15.875 | 15.875 | 15.5 | 15.5 | 7700.0 |
| 2000-12-20 | EWM | ETF | 20.75 | 21.0 | 20.75 | 21.0 | 12550.0 |
| 2000-12-20 | EWN | ETF | 21.3125 | 21.5 | 21.125 | 21.25 | 8500.0 |
| 2000-12-20 | EWO | ETF | 7.3125 | 7.3125 | 7.3125 | 7.3125 | 100.0 |
| 2000-12-20 | EWP | ETF | 22.25 | 22.25 | 21.5625 | 21.6875 | 5800.0 |
| 2000-12-20 | EWQ | ETF | 23.25 | 23.4375 | 23.1875 | 23.3125 | 34500.0 |
| 2000-12-20 | EWS | ETF | 13.25 | 13.25 | 12.875 | 12.875 | 48200.0 |
| 2000-12-20 | EWT | ETF | 21.5 | 21.5 | 20.875 | 20.875 | 13200.0 |
| 2000-12-20 | EWU | ETF | 34.5 | 34.875 | 34.25 | 34.75 | 27900.0 |
| 2000-12-20 | EWW | ETF | 13.5 | 13.5 | 12.4375 | 12.75 | 29300.0 |
| 2000-12-20 | EWY | ETF | 12.875 | 12.875 | 12.875 | 12.875 | 3200.0 |
| 2000-12-20 | EWZ | ETF | 15.8125 | 15.8125 | 15.8125 | 15.8125 | 700.0 |
| 2000-12-20 | EZU | ETF | 34.8125 | 34.9062 | 34.7188 | 34.75 | 5400.0 |
| 2000-12-20 | FCTR | ETF | 13.875 | 14.0 | 13.75 | 13.875 | 107400.0 |
| 2000-12-20 | FMAR | ETF | 3.81 | 4.0 | 3.75 | 3.88 | 10900.0 |
| 2000-12-20 | GLDB | ETF | 4.0938 | 4.1875 | 4.0 | 4.0625 | 103200.0 |
| 2000-12-20 | GSIG | ETF | 7.87 | 8.0 | 7.5 | 7.84 | 561500.0 |
| 2000-12-20 | IDU | ETF | 42.4062 | 43.1562 | 42.4062 | 43.1562 | 4800.0 |
| 2000-12-20 | IEV | ETF | 36.75 | 36.7812 | 36.5 | 36.6562 | 27600.0 |
| 2000-12-20 | IGLD | ETF | 193.75 | 193.75 | 175.0 | 175.0 | 535.0 |
| 2000-12-20 | IJH | ETF | 9.7125 | 9.7125 | 9.5641 | 9.5844 | 703000.0 |
| 2000-12-20 | IJJ | ETF | 19.7422 | 19.7734 | 19.6016 | 19.6836 | 82800.0 |
| 2000-12-20 | IJK | ETF | 14.8828 | 14.8828 | 14.4414 | 14.5859 | 191200.0 |
| 2000-12-20 | IJR | ETF | 16.8177 | 16.8177 | 16.4922 | 16.5443 | 468000.0 |
| 2000-12-20 | IJS | ETF | 17.5469 | 17.5469 | 17.2812 | 17.3633 | 44000.0 |
| 2000-12-20 | IJT | ETF | 18.5234 | 18.5234 | 17.9883 | 18.125 | 127600.0 |
| 2000-12-20 | IOO | ETF | 34.2969 | 34.2969 | 34.0 | 34.0 | 600.0 |
| 2000-12-20 | IUSG | ETF | 25.2031 | 25.2031 | 24.6562 | 24.6562 | 43600.0 |
| 2000-12-20 | IUSV | ETF | 24.1771 | 24.1927 | 24.099 | 24.099 | 1800.0 |
| 2000-12-20 | IVE | ETF | 60.75 | 61.1562 | 60.3281 | 60.5 | 75400.0 |
| 2000-12-20 | IVV | ETF | 128.3125 | 128.6406 | 126.2812 | 126.3125 | 369500.0 |
| 2000-12-20 | IVW | ETF | 16.8828 | 17.0273 | 16.5391 | 16.711 | 108800.0 |
> showing 50 of 92 rows — these rows as CSV