PREVIEW / etf_daily / 2000-02-23
file: by_date/etf_daily/2000/2000-02-23.parquet size: 6 KB rows: 46
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-02-23 | SPY | ETF | 135.625 | 137.4688 | 134.5 | 136.5625 | 12119000.0 |
| 2000-02-23 | DIA | ETF | 102.9688 | 103.5 | 101.625 | 102.25 | 1558900.0 |
| 2000-02-23 | BBH | ETF | 64.3333 | 68.5417 | 64.0208 | 68.3333 | 1981200.0 |
| 2000-02-23 | BITS | ETF | 35.375 | 36.0 | 33.25 | 33.25 | 50725.0 |
| 2000-02-23 | BOSS | ETF | 11.5 | 11.5 | 11.3 | 11.5 | 700.0 |
| 2000-02-23 | CEF | ETF | 3.6875 | 3.6875 | 3.625 | 3.625 | 8700.0 |
| 2000-02-23 | CHB | ETF | 7.31 | 7.31 | 6.94 | 7.13 | 75900.0 |
| 2000-02-23 | CNXT | ETF | 124.66 | 125.65 | 119.54 | 124.34 | 2888420.0 |
| 2000-02-23 | CSB | ETF | 3.5 | 3.59999990463257 | 3.5 | 3.59999990463257 | 5900.0 |
| 2000-02-23 | EWA | ETF | 10.1875 | 10.375 | 10.1875 | 10.375 | 12800.0 |
| 2000-02-23 | EWC | ETF | 17.6875 | 17.6875 | 17.5 | 17.5 | 4200.0 |
| 2000-02-23 | EWD | ETF | 33.9375 | 33.9375 | 33.5 | 33.875 | 11800.0 |
| 2000-02-23 | EWG | ETF | 29.125 | 29.375 | 29.0 | 29.25 | 166600.0 |
| 2000-02-23 | EWH | ETF | 13.1875 | 13.5 | 13.0625 | 13.5 | 23300.0 |
| 2000-02-23 | EWI | ETF | 54.375 | 55.25 | 53.75 | 55.25 | 74400.0 |
| 2000-02-23 | EWJ | ETF | 58.5 | 58.75 | 58.0 | 58.25 | 174600.0 |
| 2000-02-23 | EWK | ETF | 13.0 | 13.3125 | 13.0 | 13.0625 | 4900.0 |
| 2000-02-23 | EWL | ETF | 15.5625 | 15.5625 | 15.125 | 15.25 | 17800.0 |
| 2000-02-23 | EWM | ETF | 30.75 | 30.75 | 30.5 | 30.5 | 14100.0 |
| 2000-02-23 | EWN | ETF | 24.875 | 24.875 | 24.0 | 24.1875 | 11800.0 |
| 2000-02-23 | EWO | ETF | 7.8125 | 7.9375 | 7.75 | 7.75 | 5600.0 |
| 2000-02-23 | EWP | ETF | 28.625 | 28.875 | 28.375 | 28.75 | 30300.0 |
| 2000-02-23 | EWQ | ETF | 28.125 | 28.125 | 27.8125 | 27.875 | 91700.0 |
| 2000-02-23 | EWS | ETF | 14.875 | 15.0 | 14.625 | 15.0 | 102450.0 |
| 2000-02-23 | EWU | ETF | 38.625 | 38.625 | 37.875 | 38.5 | 105050.0 |
| 2000-02-23 | EWW | ETF | 17.8125 | 18.125 | 17.75 | 18.125 | 20400.0 |
| 2000-02-23 | FCTR | ETF | 13.9375 | 13.9375 | 13.125 | 13.4375 | 25800.0 |
| 2000-02-23 | FMAR | ETF | 6.6233 | 7.061 | 6.6233 | 6.6233 | 2400.0 |
| 2000-02-23 | GLDB | ETF | 8.3438 | 8.375 | 8.1875 | 8.3125 | 36700.0 |
| 2000-02-23 | GSIG | ETF | 17.62 | 17.75 | 16.25 | 16.75 | 597900.0 |
| 2000-02-23 | IGLD | ETF | 2278.125 | 2331.25 | 2087.5 | 2100.0 | 1145.0 |
| 2000-02-23 | KTEC | ETF | 9.0 | 9.625 | 9.0 | 9.125 | 7800.0 |
| 2000-02-23 | MDY | ETF | 80.9062 | 82.5312 | 80.4375 | 82.0625 | 1373600.0 |
| 2000-02-23 | MIG | ETF | 4.75 | 5.0 | 4.75 | 5.0 | 32600.0 |
| 2000-02-23 | PPH | ETF | 42.1562 | 42.1562 | 41.1562 | 41.4375 | 127400.0 |
| 2000-02-23 | SFY | ETF | 10.875 | 11.125 | 10.75 | 10.9375 | 34300.0 |
| 2000-02-23 | TINY | ETF | 17.81 | 18.0 | 17.0 | 18.0 | 193800.0 |
| 2000-02-23 | XLB | ETF | 11.2344 | 11.2734 | 11.0078 | 11.1016 | 112600.0 |
| 2000-02-23 | XLE | ETF | 13.0312 | 13.0312 | 12.7031 | 12.7969 | 152400.0 |
| 2000-02-23 | XLF | ETF | 16.6531 | 16.742 | 16.3738 | 16.5389 | 392443.0 |
| 2000-02-23 | XLI | ETF | 26.3906 | 26.3906 | 26.0156 | 26.0156 | 63100.0 |
| 2000-02-23 | XLK | ETF | 26.8125 | 27.75 | 26.7422 | 27.5625 | 366600.0 |
| 2000-02-23 | XLP | ETF | 21.625 | 21.6406 | 21.1094 | 21.1562 | 103200.0 |
| 2000-02-23 | XLU | ETF | 12.4688 | 12.4688 | 12.1328 | 12.1875 | 103800.0 |
| 2000-02-23 | XLV | ETF | 27.9375 | 28.625 | 27.9375 | 28.4375 | 17500.0 |
| 2000-02-23 | XLY | ETF | 12.6562 | 12.6562 | 12.4219 | 12.4922 | 686000.0 |
> showing 46 of 46 rows — these rows as CSV