PREVIEW / etf_daily / 2000-11-08
file: by_date/etf_daily/2000/2000-11-08.parquet size: 8 KB rows: 87
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-11-08 | SPY | ETF | 144.0625 | 144.0625 | 140.5625 | 140.5625 | 6123300.0 |
| 2000-11-08 | QQQ | ETF | 82.125 | 82.25 | 75.625 | 75.7031 | 40338200.0 |
| 2000-11-08 | IWM | ETF | 50.7188 | 50.75 | 49.7812 | 49.7812 | 192600.0 |
| 2000-11-08 | DIA | ETF | 110.0938 | 110.2188 | 108.7656 | 108.7656 | 1464300.0 |
| 2000-11-08 | BBH | ETF | 63.5833 | 64.6667 | 61.9167 | 62.1875 | 1466700.0 |
| 2000-11-08 | BITS | ETF | 12.0 | 13.875 | 12.0 | 13.0 | 10275.0 |
| 2000-11-08 | CEF | ETF | 2.9375 | 3.0 | 2.9375 | 3.0 | 24700.0 |
| 2000-11-08 | CHB | ETF | 3.31 | 3.5 | 3.13 | 3.31 | 87500.0 |
| 2000-11-08 | CNXT | ETF | 28.56 | 28.69 | 26.19 | 26.19 | 2198090.0 |
| 2000-11-08 | CSB | ETF | 1.20000004768372 | 1.20000004768372 | 1.20000004768372 | 1.20000004768372 | 10000.0 |
| 2000-11-08 | EWA | ETF | 9.5 | 9.5 | 9.3125 | 9.3125 | 7600.0 |
| 2000-11-08 | EWC | ETF | 14.75 | 14.8125 | 14.5 | 14.5 | 11300.0 |
| 2000-11-08 | EWD | ETF | 19.625 | 19.625 | 19.375 | 19.375 | 3700.0 |
| 2000-11-08 | EWG | ETF | 19.5 | 19.625 | 19.3125 | 19.3125 | 58900.0 |
| 2000-11-08 | EWH | ETF | 11.75 | 11.75 | 11.375 | 11.375 | 27900.0 |
| 2000-11-08 | EWI | ETF | 44.5 | 44.75 | 44.0 | 44.375 | 1450.0 |
| 2000-11-08 | EWJ | ETF | 52.25 | 52.25 | 51.75 | 51.75 | 40825.0 |
| 2000-11-08 | EWK | ETF | 12.9375 | 12.9375 | 12.625 | 12.625 | 900.0 |
| 2000-11-08 | EWL | ETF | 15.3125 | 15.375 | 15.1875 | 15.1875 | 21700.0 |
| 2000-11-08 | EWM | ETF | 23.0 | 23.0 | 22.75 | 23.0 | 8375.0 |
| 2000-11-08 | EWN | ETF | 22.4375 | 22.4375 | 22.1875 | 22.1875 | 4100.0 |
| 2000-11-08 | EWO | ETF | 7.3125 | 7.3125 | 7.3125 | 7.3125 | 10000.0 |
| 2000-11-08 | EWP | ETF | 24.0 | 24.0 | 23.4375 | 23.4375 | 1900.0 |
| 2000-11-08 | EWQ | ETF | 24.25 | 24.4375 | 24.0 | 24.1875 | 10200.0 |
| 2000-11-08 | EWS | ETF | 14.0 | 14.0624 | 13.875 | 13.875 | 32350.0 |
| 2000-11-08 | EWT | ETF | 27.75 | 27.75 | 27.25 | 27.5 | 45100.0 |
| 2000-11-08 | EWU | ETF | 35.625 | 35.625 | 35.25 | 35.25 | 6050.0 |
| 2000-11-08 | EWW | ETF | 15.5625 | 15.5625 | 15.3125 | 15.3125 | 8200.0 |
| 2000-11-08 | EWY | ETF | 14.5 | 14.9375 | 14.5 | 14.5 | 5300.0 |
| 2000-11-08 | EWZ | ETF | 16.6875 | 16.6875 | 16.0 | 16.0 | 7300.0 |
| 2000-11-08 | EZU | ETF | 36.25 | 36.25 | 35.6875 | 35.875 | 11800.0 |
| 2000-11-08 | FCTR | ETF | 14.6875 | 15.125 | 14.625 | 14.8125 | 31300.0 |
| 2000-11-08 | FMAR | ETF | 4.44 | 4.4972 | 4.06 | 4.25 | 6000.0 |
| 2000-11-08 | GLDB | ETF | 4.4375 | 4.5625 | 4.4375 | 4.5625 | 25400.0 |
| 2000-11-08 | GSIG | ETF | 13.25 | 13.25 | 12.56 | 12.94 | 510500.0 |
| 2000-11-08 | IDU | ETF | 41.7266 | 41.7266 | 41.5156 | 41.5156 | 2800.0 |
| 2000-11-08 | IEV | ETF | 37.25 | 37.25 | 37.0625 | 37.125 | 25000.0 |
| 2000-11-08 | IGLD | ETF | 303.125 | 303.125 | 293.75 | 300.0 | 250.0 |
| 2000-11-08 | IJH | ETF | 10.6 | 10.625 | 10.4156 | 10.4156 | 1889000.0 |
| 2000-11-08 | IJJ | ETF | 19.6875 | 19.6875 | 19.625 | 19.625 | 19600.0 |
| 2000-11-08 | IJK | ETF | 17.7109 | 17.7422 | 17.3203 | 17.3203 | 72000.0 |
| 2000-11-08 | IJR | ETF | 18.3021 | 18.3125 | 17.9662 | 17.9662 | 152400.0 |
| 2000-11-08 | IJS | ETF | 18.2891 | 18.3438 | 18.2617 | 18.2617 | 29200.0 |
| 2000-11-08 | IJT | ETF | 21.2266 | 21.2266 | 20.6875 | 20.6875 | 126000.0 |
| 2000-11-08 | IUSV | ETF | 25.0 | 25.099 | 24.9635 | 25.026 | 23100.0 |
| 2000-11-08 | IVE | ETF | 64.125 | 64.125 | 63.375 | 63.375 | 41400.0 |
| 2000-11-08 | IVV | ETF | 144.0469 | 144.0469 | 140.7656 | 140.7656 | 40700.0 |
| 2000-11-08 | IVW | ETF | 20.3672 | 20.4297 | 19.6172 | 19.6172 | 629600.0 |
| 2000-11-08 | IWB | ETF | 76.26 | 76.26 | 75.56 | 75.56 | 5000.0 |
| 2000-11-08 | IWD | ETF | 59.1719 | 59.4062 | 59.1719 | 59.25 | 19000.0 |
> showing 50 of 87 rows — these rows as CSV