PREVIEW / etf_daily / 2000-06-23
file: by_date/etf_daily/2000/2000-06-23.parquet size: 7 KB rows: 68
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-23 | SPY | ETF | 145.8125 | 146.125 | 143.875 | 144.375 | 4863300.0 |
| 2000-06-23 | QQQ | ETF | 95.0 | 95.5 | 91.375 | 91.5 | 24888100.0 |
| 2000-06-23 | IWM | ETF | 51.75 | 51.75 | 50.5 | 50.9062 | 235800.0 |
| 2000-06-23 | DIA | ETF | 104.2188 | 104.9844 | 103.7812 | 104.4375 | 726800.0 |
| 2000-06-23 | BBH | ETF | 59.2917 | 59.9583 | 56.6875 | 57.1667 | 2388000.0 |
| 2000-06-23 | BITS | ETF | 28.25 | 29.75 | 28.0 | 29.25 | 14600.0 |
| 2000-06-23 | CEF | ETF | 3.4375 | 3.4375 | 3.375 | 3.375 | 6700.0 |
| 2000-06-23 | CHB | ETF | 4.88 | 4.88 | 4.0 | 4.63 | 137700.0 |
| 2000-06-23 | CNXT | ETF | 56.63 | 57.0 | 52.5 | 53.19 | 4028030.0 |
| 2000-06-23 | CSB | ETF | 3.09999990463257 | 3.5 | 3.09999990463257 | 3.5 | 42000.0 |
| 2000-06-23 | EWA | ETF | 10.1875 | 10.3125 | 10.1875 | 10.25 | 4200.0 |
| 2000-06-23 | EWC | ETF | 19.625 | 19.625 | 19.5 | 19.5 | 31800.0 |
| 2000-06-23 | EWD | ETF | 30.875 | 30.9375 | 30.6875 | 30.6875 | 9300.0 |
| 2000-06-23 | EWG | ETF | 24.4375 | 24.4375 | 23.9375 | 24.0 | 36100.0 |
| 2000-06-23 | EWH | ETF | 12.0625 | 12.25 | 12.0625 | 12.1875 | 52700.0 |
| 2000-06-23 | EWI | ETF | 49.75 | 49.875 | 49.75 | 49.875 | 2450.0 |
| 2000-06-23 | EWJ | ETF | 60.25 | 60.5 | 59.5 | 59.5 | 116025.0 |
| 2000-06-23 | EWK | ETF | 13.0 | 13.25 | 13.0 | 13.25 | 23600.0 |
| 2000-06-23 | EWL | ETF | 15.75 | 15.75 | 15.3125 | 15.3125 | 8800.0 |
| 2000-06-23 | EWM | ETF | 24.5 | 24.5 | 24.25 | 24.5 | 5550.0 |
| 2000-06-23 | EWN | ETF | 24.5625 | 24.8125 | 24.5625 | 24.6875 | 48900.0 |
| 2000-06-23 | EWO | ETF | 7.8125 | 8.0 | 7.8125 | 8.0 | 65100.0 |
| 2000-06-23 | EWP | ETF | 25.375 | 25.5 | 25.375 | 25.4375 | 5300.0 |
| 2000-06-23 | EWQ | ETF | 28.625 | 28.8125 | 28.5625 | 28.625 | 15600.0 |
| 2000-06-23 | EWS | ETF | 14.625 | 14.875 | 14.5 | 14.625 | 62300.0 |
| 2000-06-23 | EWT | ETF | 77.5 | 77.5 | 77.5 | 77.5 | 200.0 |
| 2000-06-23 | EWU | ETF | 38.375 | 38.375 | 37.875 | 38.25 | 9450.0 |
| 2000-06-23 | EWW | ETF | 15.375 | 15.375 | 14.9375 | 15.25 | 3300.0 |
| 2000-06-23 | EWY | ETF | 20.125 | 20.25 | 20.125 | 20.25 | 2000.0 |
| 2000-06-23 | FCTR | ETF | 16.8125 | 16.875 | 16.625 | 16.875 | 56300.0 |
| 2000-06-23 | FMAR | ETF | 5.75 | 5.75 | 5.75 | 5.75 | 5800.0 |
| 2000-06-23 | GLDB | ETF | 6.5 | 6.5 | 6.0 | 6.125 | 105600.0 |
| 2000-06-23 | GSIG | ETF | 27.62 | 29.12 | 25.87 | 28.5 | 888000.0 |
| 2000-06-23 | IGLD | ETF | 887.5 | 893.75 | 825.0 | 837.5 | 219.0 |
| 2000-06-23 | IJH | ETF | 9.8297 | 9.8516 | 9.7391 | 9.75 | 1505000.0 |
| 2000-06-23 | IJR | ETF | 17.1641 | 17.1641 | 17.1511 | 17.1511 | 6000.0 |
| 2000-06-23 | IVE | ETF | 59.6094 | 59.6094 | 59.0156 | 59.0156 | 20100.0 |
| 2000-06-23 | IVV | ETF | 145.5 | 145.875 | 144.0 | 144.3906 | 238200.0 |
| 2000-06-23 | IVW | ETF | 22.1641 | 22.2695 | 22.1641 | 22.1758 | 14000.0 |
| 2000-06-23 | IWB | ETF | 77.25 | 77.25 | 76.4688 | 76.4688 | 13500.0 |
| 2000-06-23 | IWD | ETF | 55.8281 | 55.9219 | 55.5 | 55.5 | 1700.0 |
| 2000-06-23 | IWF | ETF | 21.359375 | 21.359375 | 21.3125 | 21.33595 | 2800.0 |
| 2000-06-23 | IWV | ETF | 78.9375 | 79.7031 | 78.9375 | 79.7031 | 300.0 |
| 2000-06-23 | IYE | ETF | 16.9583 | 17.0156 | 16.8802 | 16.8802 | 1500.0 |
| 2000-06-23 | IYF | ETF | 35.9688 | 36.0312 | 35.625 | 35.625 | 3800.0 |
| 2000-06-23 | IYG | ETF | 27.3177 | 27.4167 | 27.3177 | 27.4167 | 1200.0 |
| 2000-06-23 | IYH | ETF | 12.5812 | 12.5812 | 12.5062 | 12.5437 | 3000.0 |
| 2000-06-23 | IYM | ETF | 34.25 | 34.25 | 34.25 | 34.25 | 20000.0 |
| 2000-06-23 | IYW | ETF | 32.5 | 32.5 | 31.5 | 31.7344 | 13200.0 |
| 2000-06-23 | IYY | ETF | 33.875 | 33.875 | 33.5625 | 33.6172 | 9800.0 |
> showing 50 of 68 rows — these rows as CSV