PREVIEW / etf_daily / 2000-06-26
file: by_date/etf_daily/2000/2000-06-26.parquet size: 7 KB rows: 71
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-06-26 | SPY | ETF | 145.375 | 146.25 | 144.875 | 146.2344 | 5201300.0 |
| 2000-06-26 | QQQ | ETF | 93.0625 | 94.4219 | 92.0 | 94.0 | 22169200.0 |
| 2000-06-26 | IWM | ETF | 51.1094 | 51.5312 | 50.875 | 51.5312 | 93600.0 |
| 2000-06-26 | DIA | ETF | 104.9375 | 105.9688 | 104.7188 | 105.9688 | 1014800.0 |
| 2000-06-26 | BBH | ETF | 58.0833 | 59.0833 | 55.5208 | 59.0833 | 3695400.0 |
| 2000-06-26 | BITS | ETF | 28.75 | 28.75 | 27.5 | 27.5 | 7075.0 |
| 2000-06-26 | CEF | ETF | 3.4375 | 3.4375 | 3.375 | 3.4375 | 6900.0 |
| 2000-06-26 | CHB | ETF | 4.69 | 4.75 | 4.5 | 4.69 | 47000.0 |
| 2000-06-26 | CNXT | ETF | 54.81 | 55.0 | 51.6 | 53.31 | 4123840.0 |
| 2000-06-26 | CSB | ETF | 3.5 | 3.5 | 3.5 | 3.5 | 1000.0 |
| 2000-06-26 | EWA | ETF | 10.3125 | 10.3125 | 10.1875 | 10.3125 | 5300.0 |
| 2000-06-26 | EWC | ETF | 19.5625 | 19.5625 | 19.5625 | 19.5625 | 1000.0 |
| 2000-06-26 | EWD | ETF | 30.6875 | 30.75 | 30.5 | 30.6875 | 900.0 |
| 2000-06-26 | EWG | ETF | 23.5 | 23.5625 | 23.25 | 23.5625 | 115500.0 |
| 2000-06-26 | EWH | ETF | 12.4375 | 12.5 | 12.3125 | 12.375 | 16900.0 |
| 2000-06-26 | EWI | ETF | 50.125 | 50.625 | 50.125 | 50.25 | 500.0 |
| 2000-06-26 | EWJ | ETF | 59.75 | 59.75 | 59.0 | 59.5 | 80125.0 |
| 2000-06-26 | EWK | ETF | 13.0 | 13.0 | 13.0 | 13.0 | 100.0 |
| 2000-06-26 | EWL | ETF | 15.6875 | 15.8125 | 15.5625 | 15.8125 | 47700.0 |
| 2000-06-26 | EWM | ETF | 24.25 | 24.5 | 24.25 | 24.5 | 10400.0 |
| 2000-06-26 | EWN | ETF | 24.9375 | 25.0 | 24.75 | 24.9375 | 5200.0 |
| 2000-06-26 | EWO | ETF | 7.75 | 7.9375 | 7.75 | 7.75 | 19400.0 |
| 2000-06-26 | EWP | ETF | 25.3125 | 25.4375 | 25.1875 | 25.375 | 10500.0 |
| 2000-06-26 | EWQ | ETF | 28.875 | 29.0625 | 28.75 | 29.0625 | 31400.0 |
| 2000-06-26 | EWS | ETF | 14.625 | 14.875 | 14.625 | 14.875 | 22950.0 |
| 2000-06-26 | EWT | ETF | 38.0 | 38.0 | 38.0 | 38.0 | 250.0 |
| 2000-06-26 | EWU | ETF | 38.25 | 38.375 | 37.875 | 38.125 | 3350.0 |
| 2000-06-26 | EWW | ETF | 15.25 | 15.375 | 15.1875 | 15.1875 | 16900.0 |
| 2000-06-26 | EWY | ETF | 20.625 | 20.875 | 20.625 | 20.75 | 27200.0 |
| 2000-06-26 | FCTR | ETF | 16.75 | 16.875 | 16.75 | 16.8125 | 17400.0 |
| 2000-06-26 | FMAR | ETF | 5.75 | 5.88 | 5.25 | 5.25 | 10500.0 |
| 2000-06-26 | GLDB | ETF | 6.0625 | 6.1875 | 5.875 | 6.0625 | 161000.0 |
| 2000-06-26 | GSIG | ETF | 28.41 | 28.5 | 26.0 | 27.19 | 1188200.0 |
| 2000-06-26 | IDU | ETF | 34.2031 | 34.2031 | 34.2031 | 34.2031 | 400.0 |
| 2000-06-26 | IGLD | ETF | 840.625 | 900.0 | 800.0 | 850.0 | 285.0 |
| 2000-06-26 | IJH | ETF | 9.8219 | 9.8219 | 9.7625 | 9.7984 | 272000.0 |
| 2000-06-26 | IJR | ETF | 17.1563 | 17.1927 | 17.125 | 17.1328 | 74400.0 |
| 2000-06-26 | IVE | ETF | 59.5312 | 59.5312 | 59.1562 | 59.4062 | 11900.0 |
| 2000-06-26 | IVV | ETF | 145.0312 | 146.0625 | 144.8125 | 146.0625 | 26000.0 |
| 2000-06-26 | IVW | ETF | 22.2188 | 22.3828 | 22.1445 | 22.3828 | 50400.0 |
| 2000-06-26 | IWB | ETF | 77.1094 | 77.1094 | 76.9375 | 76.9375 | 12400.0 |
| 2000-06-26 | IWD | ETF | 55.6719 | 56.0156 | 55.5156 | 55.6094 | 13900.0 |
| 2000-06-26 | IWF | ETF | 21.39845 | 21.453125 | 21.332025 | 21.4414 | 48000.0 |
| 2000-06-26 | IWV | ETF | 79.9531 | 79.9531 | 79.5312 | 79.6406 | 3200.0 |
| 2000-06-26 | IYE | ETF | 16.9167 | 16.9167 | 16.75 | 16.75 | 1500.0 |
| 2000-06-26 | IYF | ETF | 35.8438 | 35.9219 | 35.6562 | 35.9219 | 4000.0 |
| 2000-06-26 | IYG | ETF | 27.2708 | 27.2708 | 27.2604 | 27.2604 | 151800.0 |
| 2000-06-26 | IYH | ETF | 12.6125 | 12.7062 | 12.6125 | 12.675 | 5000.0 |
| 2000-06-26 | IYK | ETF | 13.6042 | 13.6042 | 13.6042 | 13.6042 | 600.0 |
| 2000-06-26 | IYR | ETF | 35.125 | 35.125 | 34.875 | 34.875 | 2000.0 |
> showing 50 of 71 rows — these rows as CSV