PREVIEW / etf_daily / 2000-02-17
file: by_date/etf_daily/2000/2000-02-17.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-17 | SPY | ETF | 140.4375 | 140.4375 | 138.2188 | 138.2812 | 7584200.0 |
| 2000-02-17 | DIA | ETF | 106.7812 | 106.8594 | 104.6562 | 104.7812 | 1164100.0 |
| 2000-02-17 | BBH | ETF | 65.25 | 69.5833 | 64.5 | 67.3333 | 4031100.0 |
| 2000-02-17 | BITS | ETF | 34.25 | 35.5 | 32.75 | 32.75 | 46700.0 |
| 2000-02-17 | CEF | ETF | 3.6875 | 3.75 | 3.625 | 3.625 | 12900.0 |
| 2000-02-17 | CHB | ETF | 6.75 | 7.19 | 6.63 | 7.13 | 160000.0 |
| 2000-02-17 | CNXT | ETF | 125.06 | 129.88 | 119.95 | 122.81 | 4354700.0 |
| 2000-02-17 | CSB | ETF | 3.0 | 3.20000004768372 | 3.0 | 3.20000004768372 | 19900.0 |
| 2000-02-17 | EWA | ETF | 10.3125 | 10.5625 | 10.3125 | 10.5625 | 22800.0 |
| 2000-02-17 | EWC | ETF | 18.25 | 18.375 | 18.25 | 18.25 | 3000.0 |
| 2000-02-17 | EWD | ETF | 33.0 | 33.3125 | 33.0 | 33.0625 | 3200.0 |
| 2000-02-17 | EWG | ETF | 28.5625 | 28.5625 | 28.125 | 28.4375 | 38000.0 |
| 2000-02-17 | EWH | ETF | 13.875 | 13.875 | 13.625 | 13.75 | 62300.0 |
| 2000-02-17 | EWI | ETF | 54.25 | 54.25 | 52.75 | 53.25 | 4200.0 |
| 2000-02-17 | EWJ | ETF | 61.25 | 61.5 | 60.5 | 60.75 | 69175.0 |
| 2000-02-17 | EWK | ETF | 13.5 | 13.5625 | 13.25 | 13.5625 | 3700.0 |
| 2000-02-17 | EWL | ETF | 14.875 | 15.0 | 14.6875 | 14.875 | 18500.0 |
| 2000-02-17 | EWM | ETF | 30.5 | 31.25 | 30.5 | 31.0 | 12775.0 |
| 2000-02-17 | EWN | ETF | 24.375 | 24.625 | 24.1875 | 24.5 | 7500.0 |
| 2000-02-17 | EWO | ETF | 7.875 | 8.0625 | 7.875 | 8.0625 | 8500.0 |
| 2000-02-17 | EWP | ETF | 28.3125 | 28.4375 | 27.9375 | 28.0625 | 23300.0 |
| 2000-02-17 | EWQ | ETF | 28.3125 | 28.4375 | 27.9375 | 28.125 | 20100.0 |
| 2000-02-17 | EWS | ETF | 15.625 | 15.875 | 15.25 | 15.25 | 42400.0 |
| 2000-02-17 | EWU | ETF | 38.625 | 38.75 | 37.75 | 38.125 | 27700.0 |
| 2000-02-17 | EWW | ETF | 19.0 | 19.0 | 18.5625 | 18.75 | 13700.0 |
| 2000-02-17 | FCTR | ETF | 13.625 | 13.625 | 13.5 | 13.5625 | 61600.0 |
| 2000-02-17 | FMAR | ETF | 7.0 | 7.25 | 6.75 | 6.75 | 3000.0 |
| 2000-02-17 | GLDB | ETF | 8.25 | 8.5 | 8.25 | 8.3125 | 31600.0 |
| 2000-02-17 | GSIG | ETF | 12.37 | 13.75 | 12.37 | 13.56 | 312400.0 |
| 2000-02-17 | IGLD | ETF | 2031.25 | 2162.5 | 1950.0 | 2137.5 | 1889.0 |
| 2000-02-17 | KTEC | ETF | 9.5 | 9.5 | 9.125 | 9.25 | 9300.0 |
| 2000-02-17 | MDY | ETF | 82.5625 | 83.4375 | 81.9375 | 83.0 | 348300.0 |
| 2000-02-17 | MIG | ETF | 5.0 | 5.0 | 4.875 | 5.0 | 2700.0 |
| 2000-02-17 | PPH | ETF | 43.25 | 43.5 | 42.3438 | 42.5312 | 172200.0 |
| 2000-02-17 | SFY | ETF | 11.25 | 11.4375 | 11.0 | 11.0 | 77100.0 |
| 2000-02-17 | TDSC | ETF | 5.06 | 5.095 | 4.53 | 4.75 | 210800.0 |
| 2000-02-17 | TINY | ETF | 18.44 | 19.0 | 18.06 | 18.62 | 460800.0 |
| 2000-02-17 | XLB | ETF | 11.375 | 11.4844 | 11.1953 | 11.2266 | 91400.0 |
| 2000-02-17 | XLE | ETF | 13.7031 | 13.7422 | 13.4688 | 13.6562 | 176000.0 |
| 2000-02-17 | XLF | ETF | 17.567 | 17.567 | 16.8816 | 17.0593 | 611807.0 |
| 2000-02-17 | XLI | ETF | 26.375 | 26.4375 | 26.1406 | 26.375 | 16400.0 |
| 2000-02-17 | XLK | ETF | 27.4922 | 27.8125 | 27.0938 | 27.75 | 462400.0 |
| 2000-02-17 | XLP | ETF | 21.875 | 22.0625 | 21.5312 | 21.5312 | 113700.0 |
| 2000-02-17 | XLU | ETF | 13.039 | 13.039 | 12.9375 | 12.9688 | 21400.0 |
| 2000-02-17 | XLV | ETF | 29.1562 | 29.2969 | 28.875 | 29.0 | 15300.0 |
| 2000-02-17 | XLY | ETF | 13.1562 | 13.1562 | 12.625 | 12.6875 | 134000.0 |
> showing 46 of 46 rows — these rows as CSV