PREVIEW / etf_daily / 2000-11-27
file: by_date/etf_daily/2000/2000-11-27.parquet size: 8 KB rows: 89
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-11-27 | SPY | ETF | 136.4688 | 136.6875 | 135.3125 | 136.0312 | 5992000.0 |
| 2000-11-27 | QQQ | ETF | 72.5625 | 72.9375 | 68.75 | 69.5625 | 35416600.0 |
| 2000-11-27 | IWM | ETF | 47.9062 | 48.0547 | 47.0625 | 47.0703 | 235600.0 |
| 2000-11-27 | DIA | ETF | 106.1875 | 106.4688 | 105.4688 | 105.875 | 777600.0 |
| 2000-11-27 | BBH | ETF | 56.3333 | 56.9583 | 55.7083 | 56.75 | 3216000.0 |
| 2000-11-27 | BITS | ETF | 9.25 | 9.25 | 8.25 | 8.625 | 6750.0 |
| 2000-11-27 | CEF | ETF | 3.0 | 3.0625 | 3.0 | 3.0 | 50700.0 |
| 2000-11-27 | CHB | ETF | 3.38 | 3.44 | 3.13 | 3.44 | 173100.0 |
| 2000-11-27 | CNXT | ETF | 29.84 | 29.91 | 25.53 | 25.53 | 2761840.0 |
| 2000-11-27 | CSB | ETF | 1.0 | 1.0 | 1.0 | 1.0 | 33500.0 |
| 2000-11-27 | DGT | ETF | 82.0 | 82.0 | 81.25 | 81.25 | 2200.0 |
| 2000-11-27 | EWA | ETF | 9.125 | 9.375 | 9.125 | 9.25 | 75700.0 |
| 2000-11-27 | EWC | ETF | 13.8125 | 13.875 | 13.8125 | 13.875 | 5100.0 |
| 2000-11-27 | EWD | ETF | 17.625 | 18.1875 | 17.625 | 18.0625 | 10800.0 |
| 2000-11-27 | EWG | ETF | 18.4375 | 18.625 | 18.375 | 18.4375 | 45800.0 |
| 2000-11-27 | EWH | ETF | 11.25 | 11.5625 | 11.25 | 11.5 | 77000.0 |
| 2000-11-27 | EWI | ETF | 43.75 | 43.875 | 43.625 | 43.625 | 8300.0 |
| 2000-11-27 | EWJ | ETF | 48.25 | 48.5 | 47.5 | 47.75 | 169500.0 |
| 2000-11-27 | EWK | ETF | 11.6875 | 11.8125 | 11.6875 | 11.8125 | 9500.0 |
| 2000-11-27 | EWL | ETF | 15.0 | 15.25 | 15.0 | 15.125 | 26100.0 |
| 2000-11-27 | EWM | ETF | 21.5 | 22.0 | 21.5 | 21.75 | 30175.0 |
| 2000-11-27 | EWN | ETF | 21.8125 | 22.25 | 21.8125 | 22.25 | 4900.0 |
| 2000-11-27 | EWO | ETF | 7.125 | 7.125 | 7.0625 | 7.125 | 41500.0 |
| 2000-11-27 | EWP | ETF | 21.625 | 21.875 | 21.4375 | 21.5 | 19400.0 |
| 2000-11-27 | EWQ | ETF | 23.375 | 23.4375 | 23.25 | 23.4375 | 21300.0 |
| 2000-11-27 | EWS | ETF | 12.875 | 13.5 | 12.875 | 13.375 | 33600.0 |
| 2000-11-27 | EWT | ETF | 24.0 | 24.0 | 23.5 | 23.625 | 14600.0 |
| 2000-11-27 | EWU | ETF | 35.375 | 35.5 | 34.875 | 35.375 | 94750.0 |
| 2000-11-27 | EWW | ETF | 15.3125 | 15.3125 | 14.9375 | 15.0625 | 17700.0 |
| 2000-11-27 | EWY | ETF | 14.0 | 14.125 | 14.0 | 14.125 | 15100.0 |
| 2000-11-27 | EWZ | ETF | 15.5625 | 15.5625 | 15.3125 | 15.3125 | 7800.0 |
| 2000-11-27 | EZU | ETF | 34.8125 | 34.8438 | 34.75 | 34.8438 | 169000.0 |
| 2000-11-27 | FCTR | ETF | 14.5625 | 14.75 | 14.25 | 14.3125 | 26500.0 |
| 2000-11-27 | FMAR | ETF | 4.41 | 4.75 | 4.34 | 4.75 | 7600.0 |
| 2000-11-27 | GLDB | ETF | 4.0625 | 4.4375 | 4.0 | 4.0 | 98900.0 |
| 2000-11-27 | GSIG | ETF | 12.5 | 13.0 | 12.25 | 12.5 | 401100.0 |
| 2000-11-27 | IDU | ETF | 41.875 | 41.875 | 41.7188 | 41.875 | 4600.0 |
| 2000-11-27 | IEV | ETF | 36.7812 | 36.8125 | 36.6641 | 36.7812 | 28400.0 |
| 2000-11-27 | IGLD | ETF | 256.25 | 281.25 | 237.5 | 237.5 | 381.0 |
| 2000-11-27 | IJH | ETF | 10.1656 | 10.2016 | 10.0781 | 10.0781 | 664000.0 |
| 2000-11-27 | IJJ | ETF | 19.6406 | 19.7305 | 19.625 | 19.6562 | 338000.0 |
| 2000-11-27 | IJK | ETF | 16.3438 | 16.3438 | 16.0801 | 16.1738 | 215200.0 |
| 2000-11-27 | IJR | ETF | 17.5313 | 17.599 | 17.3984 | 17.4245 | 138000.0 |
| 2000-11-27 | IJS | ETF | 17.8398 | 17.8398 | 17.7539 | 17.7891 | 3200.0 |
| 2000-11-27 | IJT | ETF | 19.836 | 19.836 | 19.75 | 19.8281 | 3200.0 |
| 2000-11-27 | IUSG | ETF | 28.6562 | 28.6562 | 28.414 | 28.5078 | 2200.0 |
| 2000-11-27 | IUSV | ETF | 24.276 | 24.276 | 24.276 | 24.276 | 600.0 |
| 2000-11-27 | IVE | ETF | 61.4375 | 61.5312 | 61.2188 | 61.5312 | 12100.0 |
| 2000-11-27 | IVV | ETF | 136.2969 | 136.5938 | 135.4219 | 135.6719 | 68100.0 |
| 2000-11-27 | IVW | ETF | 19.0312 | 19.125 | 18.875 | 18.9375 | 118000.0 |
> showing 50 of 89 rows — these rows as CSV