PREVIEW / etf_daily / 2000-05-03
file: by_date/etf_daily/2000/2000-05-03.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-03 | SPY | ETF | 144.0 | 144.0 | 139.7812 | 140.75 | 12630700.0 |
| 2000-05-03 | QQQ | ETF | 89.5 | 90.25 | 85.5156 | 89.125 | 26589700.0 |
| 2000-05-03 | DIA | ETF | 106.5156 | 106.7188 | 103.75 | 104.8125 | 2333500.0 |
| 2000-05-03 | BBH | ETF | 45.0833 | 45.3333 | 43.75 | 45.0 | 1368000.0 |
| 2000-05-03 | BITS | ETF | 27.25 | 27.5 | 24.125 | 25.25 | 23800.0 |
| 2000-05-03 | BOSS | ETF | 14.5 | 14.8 | 14.5 | 14.8 | 200.0 |
| 2000-05-03 | CEF | ETF | 3.5625 | 3.5625 | 3.4375 | 3.4375 | 29500.0 |
| 2000-05-03 | CHB | ETF | 5.81 | 6.19 | 5.81 | 6.06 | 104500.0 |
| 2000-05-03 | CNXT | ETF | 55.0 | 55.38 | 49.25 | 51.94 | 4015390.0 |
| 2000-05-03 | EWA | ETF | 9.8125 | 9.9375 | 9.75 | 9.875 | 6400.0 |
| 2000-05-03 | EWC | ETF | 17.9375 | 17.9375 | 17.5625 | 17.5625 | 16200.0 |
| 2000-05-03 | EWD | ETF | 33.375 | 33.375 | 33.125 | 33.125 | 1900.0 |
| 2000-05-03 | EWG | ETF | 24.5625 | 24.6875 | 24.1875 | 24.375 | 52100.0 |
| 2000-05-03 | EWH | ETF | 12.25 | 12.3125 | 12.125 | 12.25 | 24300.0 |
| 2000-05-03 | EWI | ETF | 46.625 | 46.625 | 45.75 | 46.0 | 11600.0 |
| 2000-05-03 | EWJ | ETF | 61.5 | 61.75 | 60.5 | 60.75 | 33225.0 |
| 2000-05-03 | EWK | ETF | 12.0 | 12.125 | 11.6875 | 11.6875 | 5500.0 |
| 2000-05-03 | EWL | ETF | 15.0625 | 15.0625 | 14.5625 | 14.6875 | 14700.0 |
| 2000-05-03 | EWM | ETF | 25.5 | 25.5 | 25.25 | 25.25 | 8450.0 |
| 2000-05-03 | EWN | ETF | 22.5 | 22.5 | 22.1875 | 22.1875 | 3800.0 |
| 2000-05-03 | EWO | ETF | 7.25 | 7.4375 | 7.25 | 7.3125 | 5800.0 |
| 2000-05-03 | EWP | ETF | 26.5625 | 26.625 | 26.0 | 26.0 | 5600.0 |
| 2000-05-03 | EWQ | ETF | 26.75 | 26.75 | 26.25 | 26.25 | 30200.0 |
| 2000-05-03 | EWS | ETF | 14.875 | 14.875 | 14.5 | 14.5 | 26200.0 |
| 2000-05-03 | EWU | ETF | 38.875 | 38.875 | 37.5 | 37.75 | 13100.0 |
| 2000-05-03 | EWW | ETF | 16.0 | 16.0 | 15.5 | 15.5625 | 43800.0 |
| 2000-05-03 | FCTR | ETF | 15.3125 | 16.0 | 14.875 | 15.875 | 78500.0 |
| 2000-05-03 | FMAR | ETF | 6.0 | 6.38 | 5.87 | 6.2549 | 1900.0 |
| 2000-05-03 | GLDB | ETF | 6.375 | 6.4375 | 6.1875 | 6.2813 | 69400.0 |
| 2000-05-03 | GSIG | ETF | 20.0 | 20.0 | 18.62 | 18.87 | 217800.0 |
| 2000-05-03 | IGLD | ETF | 1106.25 | 1137.5 | 1100.0 | 1100.0 | 318.0 |
| 2000-05-03 | KTEC | ETF | 7.6875 | 7.75 | 7.125 | 7.125 | 10500.0 |
| 2000-05-03 | MDY | ETF | 86.8438 | 87.0625 | 84.25 | 85.6562 | 384000.0 |
| 2000-05-03 | MIG | ETF | 5.125 | 5.125 | 5.125 | 5.125 | 2000.0 |
| 2000-05-03 | PPH | ETF | 47.8125 | 47.8125 | 46.6875 | 46.9688 | 133000.0 |
| 2000-05-03 | SFY | ETF | 22.4375 | 22.75 | 20.5 | 20.75 | 181700.0 |
| 2000-05-03 | TDSC | ETF | 5.19 | 5.19 | 4.625 | 4.81 | 60400.0 |
| 2000-05-03 | TINY | ETF | 10.62 | 10.69 | 9.62 | 9.81 | 58800.0 |
| 2000-05-03 | XLB | ETF | 11.4219 | 11.4219 | 11.125 | 11.2812 | 178800.0 |
| 2000-05-03 | XLE | ETF | 14.875 | 14.875 | 14.5 | 14.5 | 158200.0 |
| 2000-05-03 | XLF | ETF | 19.3187 | 19.4837 | 18.7602 | 18.9252 | 425311.0 |
| 2000-05-03 | XLI | ETF | 29.5938 | 29.6875 | 28.8438 | 29.0 | 52900.0 |
| 2000-05-03 | XLK | ETF | 26.4062 | 26.6562 | 25.5 | 26.1875 | 1533200.0 |
| 2000-05-03 | XLP | ETF | 22.9375 | 22.9688 | 22.5 | 22.6875 | 309800.0 |
| 2000-05-03 | XLU | ETF | 13.75 | 14.25 | 13.6797 | 13.7734 | 367200.0 |
| 2000-05-03 | XLV | ETF | 29.3125 | 29.4062 | 28.6875 | 28.9688 | 10600.0 |
| 2000-05-03 | XLY | ETF | 14.0781 | 14.2031 | 13.8906 | 13.9688 | 334600.0 |
> showing 47 of 47 rows — these rows as CSV