PREVIEW / etf_daily / 2000-05-02
file: by_date/etf_daily/2000/2000-05-02.parquet size: 6 KB rows: 47
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-05-02 | SPY | ETF | 145.5 | 147.125 | 144.125 | 144.125 | 9411900.0 |
| 2000-05-02 | QQQ | ETF | 94.875 | 95.625 | 89.75 | 90.125 | 20307900.0 |
| 2000-05-02 | DIA | ETF | 107.5 | 108.2344 | 106.8125 | 107.0625 | 705000.0 |
| 2000-05-02 | BBH | ETF | 48.0 | 48.8125 | 45.8542 | 46.0 | 1462500.0 |
| 2000-05-02 | BITS | ETF | 23.75 | 27.5 | 23.75 | 26.5 | 43150.0 |
| 2000-05-02 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.5 | 65600.0 |
| 2000-05-02 | CHB | ETF | 6.38 | 6.38 | 6.06 | 6.06 | 72700.0 |
| 2000-05-02 | CNXT | ETF | 59.35 | 60.97 | 55.35 | 55.47 | 2953810.0 |
| 2000-05-02 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 3000.0 |
| 2000-05-02 | EWA | ETF | 9.8125 | 9.9375 | 9.8125 | 9.9375 | 2500.0 |
| 2000-05-02 | EWC | ETF | 18.25 | 18.25 | 17.75 | 17.75 | 16500.0 |
| 2000-05-02 | EWD | ETF | 33.8125 | 33.8125 | 33.625 | 33.8125 | 7500.0 |
| 2000-05-02 | EWG | ETF | 25.125 | 25.375 | 24.875 | 24.875 | 30700.0 |
| 2000-05-02 | EWH | ETF | 12.625 | 12.6875 | 12.375 | 12.375 | 27000.0 |
| 2000-05-02 | EWI | ETF | 47.375 | 47.875 | 47.375 | 47.875 | 4950.0 |
| 2000-05-02 | EWJ | ETF | 62.0 | 62.25 | 61.5 | 61.5 | 52450.0 |
| 2000-05-02 | EWK | ETF | 12.125 | 12.3125 | 12.0625 | 12.3125 | 2900.0 |
| 2000-05-02 | EWL | ETF | 15.125 | 15.125 | 14.8125 | 15.0625 | 3000.0 |
| 2000-05-02 | EWM | ETF | 25.5 | 25.75 | 25.25 | 25.75 | 16000.0 |
| 2000-05-02 | EWN | ETF | 23.125 | 23.3125 | 23.0 | 23.125 | 7000.0 |
| 2000-05-02 | EWO | ETF | 7.5625 | 7.5625 | 7.5625 | 7.5625 | 20800.0 |
| 2000-05-02 | EWP | ETF | 26.9375 | 27.125 | 26.9375 | 27.125 | 14700.0 |
| 2000-05-02 | EWQ | ETF | 27.4375 | 27.5 | 27.375 | 27.5 | 9200.0 |
| 2000-05-02 | EWS | ETF | 15.0 | 15.25 | 15.0 | 15.125 | 27250.0 |
| 2000-05-02 | EWU | ETF | 39.0 | 39.5 | 38.75 | 39.0 | 15450.0 |
| 2000-05-02 | EWW | ETF | 16.5625 | 16.8125 | 16.375 | 16.375 | 5900.0 |
| 2000-05-02 | FCTR | ETF | 14.0625 | 15.875 | 13.9375 | 15.6875 | 134400.0 |
| 2000-05-02 | FMAR | ETF | 5.5 | 5.87 | 5.5 | 5.87 | 1700.0 |
| 2000-05-02 | GLDB | ETF | 6.3906 | 6.3906 | 6.25 | 6.25 | 95600.0 |
| 2000-05-02 | GSIG | ETF | 19.5 | 20.87 | 19.37 | 20.31 | 314500.0 |
| 2000-05-02 | IGLD | ETF | 1137.5 | 1150.0 | 1100.0 | 1100.0 | 742.0 |
| 2000-05-02 | KTEC | ETF | 7.625 | 8.125 | 7.625 | 7.875 | 1800.0 |
| 2000-05-02 | MDY | ETF | 89.125 | 89.6875 | 86.9062 | 86.9062 | 682900.0 |
| 2000-05-02 | MIG | ETF | 5.1875 | 5.1875 | 5.125 | 5.125 | 5100.0 |
| 2000-05-02 | PPH | ETF | 46.7188 | 47.5625 | 46.3438 | 47.0625 | 142200.0 |
| 2000-05-02 | SFY | ETF | 21.0625 | 22.5 | 20.9375 | 22.125 | 109500.0 |
| 2000-05-02 | TDSC | ETF | 5.375 | 5.44 | 5.25 | 5.31 | 95000.0 |
| 2000-05-02 | TINY | ETF | 11.25 | 11.25 | 10.62 | 10.62 | 84200.0 |
| 2000-05-02 | XLB | ETF | 11.125 | 11.4688 | 11.125 | 11.4688 | 54400.0 |
| 2000-05-02 | XLE | ETF | 14.6719 | 15.0 | 14.6719 | 14.8828 | 296000.0 |
| 2000-05-02 | XLF | ETF | 19.2425 | 19.4456 | 19.2044 | 19.2679 | 179480.0 |
| 2000-05-02 | XLI | ETF | 29.9688 | 30.2188 | 29.7188 | 30.0 | 187400.0 |
| 2000-05-02 | XLK | ETF | 27.6562 | 27.7188 | 26.75 | 27.375 | 1365200.0 |
| 2000-05-02 | XLP | ETF | 22.5938 | 22.7812 | 22.3906 | 22.6875 | 19000.0 |
| 2000-05-02 | XLU | ETF | 14.1484 | 14.2188 | 13.6875 | 13.7266 | 48400.0 |
| 2000-05-02 | XLV | ETF | 29.9375 | 29.9375 | 29.6406 | 29.7969 | 3800.0 |
| 2000-05-02 | XLY | ETF | 14.5469 | 14.7188 | 14.5469 | 14.664 | 130600.0 |
> showing 47 of 47 rows — these rows as CSV