PREVIEW / etf_daily / 2000-10-02
file: by_date/etf_daily/2000/2000-10-02.parquet size: 8 KB rows: 88
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-10-02 | SPY | ETF | 144.2812 | 144.9062 | 143.1406 | 143.8438 | 5517800.0 |
| 2000-10-02 | QQQ | ETF | 90.25 | 90.25 | 86.0 | 86.75 | 24968200.0 |
| 2000-10-02 | IWM | ETF | 52.2031 | 52.2031 | 50.9688 | 50.9688 | 169600.0 |
| 2000-10-02 | DIA | ETF | 106.9844 | 107.3594 | 106.3438 | 107.0938 | 481400.0 |
| 2000-10-02 | BBH | ETF | 64.75 | 64.75 | 61.0833 | 61.0833 | 2093400.0 |
| 2000-10-02 | BITS | ETF | 14.875 | 15.875 | 13.75 | 13.75 | 6750.0 |
| 2000-10-02 | CEF | ETF | 3.25 | 3.3125 | 3.25 | 3.3125 | 17200.0 |
| 2000-10-02 | CHB | ETF | 4.13 | 4.19 | 3.88 | 3.94 | 112900.0 |
| 2000-10-02 | CNXT | ETF | 42.31 | 43.25 | 38.88 | 39.13 | 3161810.0 |
| 2000-10-02 | DGT | ETF | 84.9375 | 85.2344 | 84.9375 | 85.1094 | 3900.0 |
| 2000-10-02 | EWA | ETF | 9.5 | 9.75 | 9.5 | 9.75 | 4300.0 |
| 2000-10-02 | EWC | ETF | 16.1875 | 16.5 | 16.125 | 16.125 | 33100.0 |
| 2000-10-02 | EWD | ETF | 22.25 | 22.25 | 22.0 | 22.0 | 1400.0 |
| 2000-10-02 | EWG | ETF | 19.3125 | 19.625 | 19.25 | 19.4375 | 24400.0 |
| 2000-10-02 | EWH | ETF | 12.125 | 12.1875 | 11.875 | 11.875 | 57300.0 |
| 2000-10-02 | EWI | ETF | 42.5 | 42.5 | 42.5 | 42.5 | 3850.0 |
| 2000-10-02 | EWJ | ETF | 53.5 | 53.75 | 53.0 | 53.0 | 30175.0 |
| 2000-10-02 | EWK | ETF | 12.75 | 12.8125 | 12.6875 | 12.6875 | 4600.0 |
| 2000-10-02 | EWL | ETF | 15.0625 | 15.1875 | 15.0 | 15.1875 | 6200.0 |
| 2000-10-02 | EWM | ETF | 20.5 | 20.75 | 20.5 | 20.75 | 23725.0 |
| 2000-10-02 | EWN | ETF | 22.5625 | 22.6875 | 22.5625 | 22.6875 | 500.0 |
| 2000-10-02 | EWO | ETF | 7.6875 | 7.75 | 7.4375 | 7.4375 | 17900.0 |
| 2000-10-02 | EWP | ETF | 24.8125 | 24.8125 | 24.4375 | 24.6875 | 2800.0 |
| 2000-10-02 | EWQ | ETF | 24.8125 | 25.0625 | 24.75 | 24.875 | 1900.0 |
| 2000-10-02 | EWS | ETF | 13.5 | 13.5 | 13.125 | 13.375 | 26150.0 |
| 2000-10-02 | EWT | ETF | 28.25 | 28.25 | 26.375 | 26.5 | 272950.0 |
| 2000-10-02 | EWU | ETF | 35.875 | 36.0 | 35.5 | 35.5 | 5250.0 |
| 2000-10-02 | EWW | ETF | 15.1875 | 15.5625 | 14.875 | 15.125 | 144700.0 |
| 2000-10-02 | EWY | ETF | 16.0 | 16.0 | 15.3125 | 15.3125 | 7800.0 |
| 2000-10-02 | EWZ | ETF | 18.0625 | 18.0625 | 17.625 | 17.8125 | 500.0 |
| 2000-10-02 | EZU | ETF | 36.3125 | 36.4375 | 36.2188 | 36.4062 | 16200.0 |
| 2000-10-02 | FCTR | ETF | 14.25 | 14.4375 | 14.1875 | 14.3125 | 28200.0 |
| 2000-10-02 | FMAR | ETF | 4.88 | 5.25 | 4.84 | 5.0 | 5900.0 |
| 2000-10-02 | GLDB | ETF | 5.1875 | 5.1875 | 4.875 | 4.875 | 79800.0 |
| 2000-10-02 | GSIG | ETF | 16.78 | 17.0 | 14.94 | 15.06 | 625000.0 |
| 2000-10-02 | IDU | ETF | 43.625 | 43.75 | 43.1875 | 43.75 | 85800.0 |
| 2000-10-02 | IEV | ETF | 38.4062 | 38.4688 | 38.4062 | 38.4609 | 6800.0 |
| 2000-10-02 | IGLD | ETF | 537.5 | 550.0 | 525.0 | 525.0 | 397.0 |
| 2000-10-02 | IJH | ETF | 10.825 | 10.825 | 10.6391 | 10.6406 | 1963000.0 |
| 2000-10-02 | IJJ | ETF | 19.6406 | 19.6562 | 19.5625 | 19.5938 | 13200.0 |
| 2000-10-02 | IJK | ETF | 18.1055 | 18.168 | 17.9941 | 17.9941 | 32000.0 |
| 2000-10-02 | IJR | ETF | 18.1745 | 18.1745 | 17.8568 | 17.9167 | 77400.0 |
| 2000-10-02 | IJS | ETF | 18.0508 | 18.0508 | 17.8281 | 17.8281 | 1620800.0 |
| 2000-10-02 | IJT | ETF | 21.0781 | 21.0781 | 20.9766 | 20.9766 | 25600.0 |
| 2000-10-02 | IUSG | ETF | 32.5625 | 32.5625 | 32.5625 | 32.5625 | 200.0 |
| 2000-10-02 | IVE | ETF | 63.0312 | 63.4219 | 62.5625 | 63.4219 | 15500.0 |
| 2000-10-02 | IVV | ETF | 144.5 | 144.875 | 143.5 | 143.875 | 223700.0 |
| 2000-10-02 | IVW | ETF | 20.8164 | 20.9453 | 20.6289 | 20.6953 | 269200.0 |
| 2000-10-02 | IWB | ETF | 77.55 | 77.55 | 76.9 | 77.0 | 7100.0 |
| 2000-10-02 | IWD | ETF | 57.9062 | 58.2188 | 57.875 | 58.1875 | 33000.0 |
> showing 50 of 88 rows — these rows as CSV