PREVIEW / etf_daily / 2000-11-29
file: by_date/etf_daily/2000/2000-11-29.parquet size: 8 KB rows: 88
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-29 | SPY | ETF | 134.375 | 135.9062 | 133.2656 | 133.4375 | 6914100.0 |
| 2000-11-29 | QQQ | ETF | 65.8125 | 66.75 | 62.5 | 62.9375 | 66199500.0 |
| 2000-11-29 | IWM | ETF | 46.0 | 46.0 | 45.0625 | 45.5312 | 526800.0 |
| 2000-11-29 | DIA | ETF | 105.5312 | 106.6875 | 105.0625 | 105.9688 | 1399600.0 |
| 2000-11-29 | BBH | ETF | 53.3333 | 56.25 | 53.2083 | 53.875 | 3377700.0 |
| 2000-11-29 | BITS | ETF | 8.375 | 9.0 | 8.0 | 8.5 | 10950.0 |
| 2000-11-29 | BOSS | ETF | 27.0 | 28.0 | 27.0 | 28.0 | 200.0 |
| 2000-11-29 | CEF | ETF | 3.0625 | 3.125 | 3.0 | 3.0625 | 27800.0 |
| 2000-11-29 | CHB | ETF | 3.31 | 3.44 | 3.25 | 3.25 | 49900.0 |
| 2000-11-29 | CNXT | ETF | 23.31 | 24.75 | 20.87 | 23.87 | 5485080.0 |
| 2000-11-29 | DGT | ETF | 80.3438 | 80.9062 | 80.3438 | 80.9062 | 200.0 |
| 2000-11-29 | EWA | ETF | 9.0625 | 9.25 | 9.0625 | 9.1875 | 10400.0 |
| 2000-11-29 | EWC | ETF | 13.5 | 13.5625 | 13.25 | 13.25 | 7600.0 |
| 2000-11-29 | EWD | ETF | 17.9375 | 18.0 | 17.75 | 18.0 | 7100.0 |
| 2000-11-29 | EWG | ETF | 18.4375 | 18.625 | 18.25 | 18.4375 | 65800.0 |
| 2000-11-29 | EWH | ETF | 11.25 | 11.25 | 11.0 | 11.0 | 5600.0 |
| 2000-11-29 | EWI | ETF | 44.375 | 44.5 | 44.0 | 44.375 | 9800.0 |
| 2000-11-29 | EWJ | ETF | 47.0 | 47.5 | 46.75 | 47.25 | 77900.0 |
| 2000-11-29 | EWK | ETF | 11.625 | 11.875 | 11.625 | 11.625 | 3300.0 |
| 2000-11-29 | EWL | ETF | 15.25 | 15.4375 | 15.1875 | 15.4375 | 3800.0 |
| 2000-11-29 | EWM | ETF | 21.75 | 21.75 | 21.75 | 21.75 | 5525.0 |
| 2000-11-29 | EWN | ETF | 22.1875 | 22.25 | 21.9375 | 22.125 | 3100.0 |
| 2000-11-29 | EWO | ETF | 7.1875 | 7.1875 | 7.125 | 7.125 | 7000.0 |
| 2000-11-29 | EWP | ETF | 21.625 | 21.6875 | 21.625 | 21.625 | 5600.0 |
| 2000-11-29 | EWQ | ETF | 22.9375 | 23.25 | 22.9375 | 23.125 | 2300.0 |
| 2000-11-29 | EWS | ETF | 13.125 | 13.25 | 13.0 | 13.125 | 11250.0 |
| 2000-11-29 | EWT | ETF | 23.0 | 23.125 | 22.625 | 22.625 | 13350.0 |
| 2000-11-29 | EWU | ETF | 34.875 | 34.875 | 34.0 | 34.125 | 11850.0 |
| 2000-11-29 | EWW | ETF | 14.875 | 14.875 | 14.6875 | 14.8125 | 9300.0 |
| 2000-11-29 | EWY | ETF | 13.0 | 13.0 | 12.75 | 12.75 | 35900.0 |
| 2000-11-29 | EZU | ETF | 34.9375 | 35.125 | 34.875 | 35.0 | 56000.0 |
| 2000-11-29 | FCTR | ETF | 14.0625 | 14.25 | 13.25 | 13.5625 | 24100.0 |
| 2000-11-29 | FMAR | ETF | 4.62 | 4.69 | 4.62 | 4.62 | 24190.0 |
| 2000-11-29 | GLDB | ETF | 4.0625 | 4.0938 | 3.9688 | 4.0 | 135700.0 |
| 2000-11-29 | GSIG | ETF | 10.75 | 11.19 | 10.5 | 10.56 | 767600.0 |
| 2000-11-29 | IDU | ETF | 42.4219 | 42.4375 | 42.0625 | 42.2188 | 5000.0 |
| 2000-11-29 | IEV | ETF | 36.4688 | 36.5 | 36.3125 | 36.4688 | 32600.0 |
| 2000-11-29 | IGLD | ETF | 237.5 | 250.0 | 206.25 | 225.0 | 435.0 |
| 2000-11-29 | IJH | ETF | 9.85 | 9.8656 | 9.7422 | 9.8 | 1565000.0 |
| 2000-11-29 | IJJ | ETF | 19.5391 | 19.6133 | 19.5312 | 19.543 | 7200.0 |
| 2000-11-29 | IJK | ETF | 15.4414 | 15.4414 | 15.1348 | 15.2695 | 45600.0 |
| 2000-11-29 | IJR | ETF | 16.9167 | 16.9167 | 16.6146 | 16.6146 | 115800.0 |
| 2000-11-29 | IJS | ETF | 17.3906 | 17.3906 | 17.25 | 17.25 | 5200.0 |
| 2000-11-29 | IJT | ETF | 18.8398 | 18.8984 | 18.3984 | 18.3984 | 37600.0 |
| 2000-11-29 | IVE | ETF | 61.5 | 61.75 | 61.375 | 61.625 | 33500.0 |
| 2000-11-29 | IVV | ETF | 134.3281 | 135.7031 | 133.5 | 133.6562 | 437000.0 |
| 2000-11-29 | IVW | ETF | 18.5156 | 18.6641 | 18.2812 | 18.4141 | 209200.0 |
| 2000-11-29 | IWB | ETF | 70.78 | 71.12 | 70.38 | 70.62 | 16100.0 |
| 2000-11-29 | IWD | ETF | 57.1562 | 57.8594 | 57.1562 | 57.625 | 49000.0 |
| 2000-11-29 | IWF | ETF | 17.27735 | 17.457025 | 17.0586 | 17.33985 | 105200.0 |
> showing 50 of 88 rows — these rows as CSV