PREVIEW / etf_daily / 2001-06-13
file: by_date/etf_daily/2001/2001-06-13.parquet size: 8 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-13 | SPY | ETF | 126.17 | 126.58 | 124.65 | 124.8 | 7629400.0 |
| 2001-06-13 | QQQ | ETF | 46.274 | 46.75 | 44.52 | 44.55 | 68535400.0 |
| 2001-06-13 | IWM | ETF | 50.625 | 51.0 | 50.2 | 50.33 | 759400.0 |
| 2001-06-13 | DIA | ETF | 109.75 | 110.25 | 108.76 | 108.81 | 2241600.0 |
| 2001-06-13 | BBH | ETF | 44.3333 | 45.38 | 44.12 | 44.55 | 3164400.0 |
| 2001-06-13 | BITS | ETF | 10.76 | 11.2 | 10.52 | 10.96 | 12000.0 |
| 2001-06-13 | CEF | ETF | 3.33 | 3.33 | 3.27 | 3.27 | 6900.0 |
| 2001-06-13 | CHB | ETF | 10.64 | 10.64 | 9.5 | 9.65 | 157800.0 |
| 2001-06-13 | CNXT | ETF | 8.77 | 9.2 | 8.49 | 8.52 | 2147800.0 |
| 2001-06-13 | CSB | ETF | 2.15000009536743 | 2.15000009536743 | 2.09999990463257 | 2.09999990463257 | 14700.0 |
| 2001-06-13 | DGT | ETF | 72.16 | 72.2 | 72.16 | 72.2 | 400.0 |
| 2001-06-13 | EWA | ETF | 9.88 | 9.94 | 9.88 | 9.94 | 53000.0 |
| 2001-06-13 | EWC | ETF | 12.2 | 12.2 | 12.09 | 12.14 | 13400.0 |
| 2001-06-13 | EWD | ETF | 13.55 | 13.7 | 13.5 | 13.7 | 3600.0 |
| 2001-06-13 | EWG | ETF | 16.82 | 16.86 | 16.66 | 16.7 | 87900.0 |
| 2001-06-13 | EWH | ETF | 10.6 | 10.6 | 10.46 | 10.47 | 7400.0 |
| 2001-06-13 | EWI | ETF | 37.22 | 37.48 | 37.22 | 37.38 | 5450.0 |
| 2001-06-13 | EWJ | ETF | 41.56 | 41.68 | 41.24 | 41.4 | 32775.0 |
| 2001-06-13 | EWK | ETF | 11.15 | 11.25 | 11.15 | 11.25 | 600.0 |
| 2001-06-13 | EWL | ETF | 14.08 | 14.1 | 14.08 | 14.1 | 6600.0 |
| 2001-06-13 | EWM | ETF | 17.0 | 17.2 | 17.0 | 17.08 | 3225.0 |
| 2001-06-13 | EWN | ETF | 19.89 | 20.0 | 19.85 | 20.0 | 18500.0 |
| 2001-06-13 | EWP | ETF | 22.9 | 22.9 | 22.73 | 22.73 | 24300.0 |
| 2001-06-13 | EWQ | ETF | 20.69 | 20.69 | 20.46 | 20.46 | 34900.0 |
| 2001-06-13 | EWS | ETF | 10.86 | 10.9 | 10.72 | 10.72 | 29050.0 |
| 2001-06-13 | EWT | ETF | 21.64 | 21.64 | 21.24 | 21.4 | 15550.0 |
| 2001-06-13 | EWU | ETF | 31.82 | 32.24 | 31.74 | 31.74 | 10700.0 |
| 2001-06-13 | EWW | ETF | 16.95 | 17.08 | 16.75 | 16.75 | 13300.0 |
| 2001-06-13 | EWY | ETF | 14.86 | 14.95 | 14.86 | 14.95 | 300.0 |
| 2001-06-13 | EZU | ETF | 30.925 | 30.99 | 30.81 | 30.81 | 29600.0 |
| 2001-06-13 | FCTR | ETF | 16.72 | 16.74 | 16.6 | 16.62 | 12700.0 |
| 2001-06-13 | FMAR | ETF | 6.68 | 7.0 | 6.68 | 7.0 | 2800.0 |
| 2001-06-13 | GLDB | ETF | 7.12 | 7.13 | 6.96 | 7.1 | 74800.0 |
| 2001-06-13 | GSIG | ETF | 9.34 | 9.56 | 9.31 | 9.49 | 110100.0 |
| 2001-06-13 | IBB | ETF | 33.6333 | 34.2 | 33.3667 | 33.3667 | 177600.0 |
| 2001-06-13 | ICF | ETF | 20.8675 | 20.8675 | 20.8375 | 20.8375 | 1600.0 |
| 2001-06-13 | IDU | ETF | 40.55 | 40.55 | 40.03 | 40.03 | 3600.0 |
| 2001-06-13 | IEV | ETF | 32.45 | 32.45 | 31.875 | 31.895 | 160600.0 |
| 2001-06-13 | IGLD | ETF | 74.0 | 77.0 | 74.0 | 74.0 | 12.0 |
| 2001-06-13 | IGM | ETF | 10.05 | 10.06 | 10.05 | 10.06 | 15600.0 |
| 2001-06-13 | IJH | ETF | 10.5 | 10.565 | 10.39 | 10.39 | 386000.0 |
| 2001-06-13 | IJJ | ETF | 22.9325 | 23.0425 | 22.8175 | 22.8175 | 39200.0 |
| 2001-06-13 | IJK | ETF | 14.9475 | 15.0588 | 14.7925 | 14.7925 | 58400.0 |
| 2001-06-13 | IJR | ETF | 18.95 | 19.0817 | 18.8167 | 18.8567 | 185400.0 |
| 2001-06-13 | IJS | ETF | 21.205 | 21.35 | 21.0825 | 21.1525 | 137600.0 |
| 2001-06-13 | IJT | ETF | 19.1 | 19.2075 | 19.0075 | 19.0075 | 5200.0 |
| 2001-06-13 | IOO | ETF | 32.37 | 32.42 | 32.055 | 32.055 | 65000.0 |
| 2001-06-13 | IUSG | ETF | 22.955 | 22.955 | 22.635 | 22.645 | 3400.0 |
| 2001-06-13 | IUSV | ETF | 25.2267 | 25.2267 | 25.2267 | 25.2267 | 23400.0 |
| 2001-06-13 | IVE | ETF | 63.17 | 63.38 | 62.62 | 62.66 | 94400.0 |
> showing 50 of 97 rows — these rows as CSV