PREVIEW / etf_daily / 2000-07-06
file: by_date/etf_daily/2000/2000-07-06.parquet size: 7 KB rows: 69
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-07-06 | SPY | ETF | 144.9375 | 146.4688 | 144.2188 | 145.75 | 5963200.0 |
| 2000-07-06 | QQQ | ETF | 91.5625 | 94.75 | 90.0625 | 94.0 | 23594800.0 |
| 2000-07-06 | IWM | ETF | 51.8281 | 52.4219 | 51.3438 | 52.4219 | 154600.0 |
| 2000-07-06 | DIA | ETF | 105.3438 | 105.4531 | 104.0625 | 105.0938 | 330700.0 |
| 2000-07-06 | BBH | ETF | 61.7917 | 64.0 | 61.3542 | 64.0 | 3051600.0 |
| 2000-07-06 | BITS | ETF | 24.75 | 24.75 | 22.125 | 22.75 | 7975.0 |
| 2000-07-06 | CEF | ETF | 3.375 | 3.375 | 3.375 | 3.375 | 1400.0 |
| 2000-07-06 | CHB | ETF | 5.63 | 5.88 | 5.63 | 5.75 | 70800.0 |
| 2000-07-06 | CNXT | ETF | 46.06 | 47.39 | 43.38 | 47.0 | 4711700.0 |
| 2000-07-06 | EWA | ETF | 10.4375 | 10.625 | 10.4375 | 10.5 | 3100.0 |
| 2000-07-06 | EWC | ETF | 19.75 | 19.9375 | 19.625 | 19.8125 | 15400.0 |
| 2000-07-06 | EWD | ETF | 31.375 | 31.4375 | 31.25 | 31.25 | 1400.0 |
| 2000-07-06 | EWG | ETF | 24.375 | 24.375 | 24.1875 | 24.3125 | 20100.0 |
| 2000-07-06 | EWH | ETF | 12.5 | 12.75 | 12.5 | 12.6875 | 31900.0 |
| 2000-07-06 | EWI | ETF | 52.375 | 52.375 | 52.0 | 52.125 | 1800.0 |
| 2000-07-06 | EWJ | ETF | 59.75 | 60.25 | 59.5 | 60.25 | 99100.0 |
| 2000-07-06 | EWK | ETF | 13.5625 | 13.5625 | 13.5 | 13.5 | 31200.0 |
| 2000-07-06 | EWL | ETF | 16.5625 | 16.5625 | 16.3125 | 16.5625 | 8100.0 |
| 2000-07-06 | EWM | ETF | 24.5 | 24.75 | 24.25 | 24.75 | 12225.0 |
| 2000-07-06 | EWN | ETF | 24.5 | 24.625 | 24.375 | 24.5625 | 1400.0 |
| 2000-07-06 | EWO | ETF | 7.8125 | 7.8125 | 7.8125 | 7.8125 | 7300.0 |
| 2000-07-06 | EWP | ETF | 26.875 | 26.875 | 26.625 | 26.625 | 30300.0 |
| 2000-07-06 | EWQ | ETF | 28.6875 | 28.8125 | 28.625 | 28.8125 | 29100.0 |
| 2000-07-06 | EWS | ETF | 14.875 | 15.0 | 14.75 | 14.875 | 47200.0 |
| 2000-07-06 | EWT | ETF | 37.875 | 38.375 | 37.875 | 38.375 | 25300.0 |
| 2000-07-06 | EWU | ETF | 38.875 | 39.375 | 38.5 | 39.375 | 15250.0 |
| 2000-07-06 | EWW | ETF | 18.1875 | 19.1875 | 17.5625 | 17.625 | 119900.0 |
| 2000-07-06 | EWY | ETF | 21.4375 | 21.4375 | 21.375 | 21.375 | 2700.0 |
| 2000-07-06 | FCTR | ETF | 15.5 | 16.5 | 15.5 | 16.5 | 42400.0 |
| 2000-07-06 | FMAR | ETF | 5.47 | 5.47 | 5.47 | 5.47 | 600.0 |
| 2000-07-06 | GLDB | ETF | 5.0938 | 5.1563 | 4.875 | 5.0625 | 219600.0 |
| 2000-07-06 | GSIG | ETF | 35.62 | 38.5 | 35.5 | 36.56 | 1159300.0 |
| 2000-07-06 | IDU | ETF | 33.5938 | 33.5938 | 33.5938 | 33.5938 | 200.0 |
| 2000-07-06 | IGLD | ETF | 825.0 | 837.5 | 812.5 | 825.0 | 306.0 |
| 2000-07-06 | IJH | ETF | 9.7219 | 9.8141 | 9.6969 | 9.8141 | 4076000.0 |
| 2000-07-06 | IJR | ETF | 17.5391 | 17.7188 | 17.375 | 17.7188 | 416400.0 |
| 2000-07-06 | IVE | ETF | 59.3281 | 59.4219 | 58.9844 | 59.1562 | 5300.0 |
| 2000-07-06 | IVV | ETF | 144.875 | 146.125 | 144.2188 | 145.8125 | 40100.0 |
| 2000-07-06 | IVW | ETF | 22.1172 | 22.4141 | 22.1172 | 22.4141 | 21200.0 |
| 2000-07-06 | IWB | ETF | 76.5 | 77.1719 | 76.2188 | 77.1719 | 2100.0 |
| 2000-07-06 | IWD | ETF | 54.9844 | 55.125 | 54.8125 | 54.8125 | 12500.0 |
| 2000-07-06 | IWF | ETF | 21.234375 | 21.53905 | 21.046875 | 21.515625 | 182000.0 |
| 2000-07-06 | IWV | ETF | 79.1406 | 79.7969 | 79.1406 | 79.7969 | 3000.0 |
| 2000-07-06 | IYC | ETF | 15.1875 | 15.1875 | 15.1875 | 15.1875 | 400.0 |
| 2000-07-06 | IYE | ETF | 15.9583 | 16.0938 | 15.8958 | 16.0313 | 6600.0 |
| 2000-07-06 | IYF | ETF | 36.0 | 36.4844 | 35.9844 | 36.4844 | 1800.0 |
| 2000-07-06 | IYG | ETF | 27.1667 | 27.1667 | 27.1667 | 27.1667 | 1500.0 |
| 2000-07-06 | IYH | ETF | 13.3625 | 13.3625 | 13.25 | 13.3125 | 20500.0 |
| 2000-07-06 | IYR | ETF | 35.75 | 36.125 | 35.75 | 36.0156 | 6600.0 |
| 2000-07-06 | IYW | ETF | 30.7812 | 31.4688 | 30.3125 | 31.4688 | 8400.0 |
> showing 50 of 69 rows — these rows as CSV