PREVIEW / etf_daily / 2000-02-09
file: by_date/etf_daily/2000/2000-02-09.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-09 | SPY | ETF | 144.4688 | 144.4688 | 141.2656 | 141.2812 | 8511500.0 |
| 2000-02-09 | DIA | ETF | 109.1875 | 109.375 | 106.7812 | 106.9062 | 819900.0 |
| 2000-02-09 | BBH | ETF | 62.25 | 62.5417 | 60.0208 | 60.2083 | 1731000.0 |
| 2000-02-09 | BITS | ETF | 31.0 | 32.0 | 29.25 | 31.25 | 57575.0 |
| 2000-02-09 | CEF | ETF | 3.75 | 3.75 | 3.6875 | 3.6875 | 15600.0 |
| 2000-02-09 | CHB | ETF | 7.81 | 7.88 | 7.81 | 7.81 | 76400.0 |
| 2000-02-09 | CNXT | ETF | 112.87 | 112.93 | 103.0 | 104.94 | 4272440.0 |
| 2000-02-09 | CSB | ETF | 3.0 | 3.0 | 3.0 | 3.0 | 9000.0 |
| 2000-02-09 | EWA | ETF | 10.75 | 10.75 | 10.5 | 10.6875 | 101500.0 |
| 2000-02-09 | EWC | ETF | 18.0 | 18.125 | 17.9375 | 17.9375 | 4400.0 |
| 2000-02-09 | EWD | ETF | 33.75 | 33.75 | 33.3125 | 33.5 | 25500.0 |
| 2000-02-09 | EWG | ETF | 29.125 | 29.125 | 28.5 | 28.625 | 180100.0 |
| 2000-02-09 | EWH | ETF | 13.4375 | 13.5 | 13.3125 | 13.3125 | 69900.0 |
| 2000-02-09 | EWI | ETF | 52.125 | 52.5 | 52.0 | 52.0 | 4500.0 |
| 2000-02-09 | EWJ | ETF | 62.25 | 62.5 | 61.75 | 62.0 | 129150.0 |
| 2000-02-09 | EWK | ETF | 13.75 | 13.75 | 13.5 | 13.625 | 2400.0 |
| 2000-02-09 | EWL | ETF | 14.9375 | 15.0625 | 14.8125 | 15.0 | 12300.0 |
| 2000-02-09 | EWM | ETF | 32.0 | 32.25 | 31.75 | 32.0 | 33525.0 |
| 2000-02-09 | EWN | ETF | 23.75 | 24.0625 | 23.75 | 23.8125 | 6400.0 |
| 2000-02-09 | EWO | ETF | 8.0 | 8.125 | 8.0 | 8.125 | 104900.0 |
| 2000-02-09 | EWP | ETF | 28.5625 | 28.5625 | 28.125 | 28.4375 | 25900.0 |
| 2000-02-09 | EWQ | ETF | 28.8125 | 29.0625 | 28.5625 | 28.8125 | 95200.0 |
| 2000-02-09 | EWS | ETF | 16.25 | 16.25 | 15.75 | 16.0 | 44500.0 |
| 2000-02-09 | EWU | ETF | 38.875 | 39.5 | 38.875 | 39.5 | 33150.0 |
| 2000-02-09 | EWW | ETF | 18.6875 | 19.0625 | 18.5625 | 18.5625 | 16800.0 |
| 2000-02-09 | FCTR | ETF | 13.1875 | 13.4375 | 13.0625 | 13.1875 | 16800.0 |
| 2000-02-09 | FMAR | ETF | 6.73 | 7.1 | 6.7281 | 7.1 | 1200.0 |
| 2000-02-09 | GLDB | ETF | 8.5 | 8.5 | 8.25 | 8.25 | 23000.0 |
| 2000-02-09 | GSIG | ETF | 12.84 | 13.25 | 12.37 | 12.44 | 132600.0 |
| 2000-02-09 | IGLD | ETF | 1975.0 | 2000.0 | 1881.25 | 1887.5 | 781.0 |
| 2000-02-09 | KTEC | ETF | 9.3125 | 9.8125 | 9.1875 | 9.75 | 40900.0 |
| 2000-02-09 | MDY | ETF | 83.375 | 83.375 | 81.0625 | 81.5 | 1005600.0 |
| 2000-02-09 | MIG | ETF | 5.9375 | 5.9375 | 5.625 | 5.625 | 6300.0 |
| 2000-02-09 | PPH | ETF | 46.0625 | 46.0625 | 44.7812 | 44.875 | 257200.0 |
| 2000-02-09 | SFY | ETF | 11.3125 | 11.3125 | 10.9375 | 11.125 | 111200.0 |
| 2000-02-09 | TDSC | ETF | 5.0 | 5.0 | 4.75 | 4.75 | 62600.0 |
| 2000-02-09 | TINY | ETF | 17.5 | 17.75 | 15.0 | 15.75 | 693100.0 |
| 2000-02-09 | XLB | ETF | 11.4453 | 11.5078 | 11.2266 | 11.2266 | 67000.0 |
| 2000-02-09 | XLE | ETF | 13.0625 | 13.0625 | 12.75 | 12.75 | 172400.0 |
| 2000-02-09 | XLF | ETF | 18.354 | 18.354 | 17.7955 | 17.9224 | 223550.0 |
| 2000-02-09 | XLI | ETF | 26.7344 | 26.7344 | 26.375 | 26.4688 | 58400.0 |
| 2000-02-09 | XLK | ETF | 27.875 | 28.0625 | 27.125 | 27.2812 | 3246600.0 |
| 2000-02-09 | XLP | ETF | 22.9844 | 23.0 | 22.5156 | 22.7656 | 90900.0 |
| 2000-02-09 | XLU | ETF | 13.5781 | 13.625 | 13.4844 | 13.5469 | 32600.0 |
| 2000-02-09 | XLV | ETF | 31.4375 | 31.4375 | 30.7656 | 30.9062 | 19000.0 |
| 2000-02-09 | XLY | ETF | 14.0938 | 14.0938 | 13.789 | 13.8125 | 57200.0 |
> showing 46 of 46 rows — these rows as CSV