PREVIEW / etf_daily / 2001-08-27
file: by_date/etf_daily/2001/2001-08-27.parquet size: 9 KB rows: 106
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-08-27 | SPY | ETF | 118.97 | 119.2 | 118.26 | 118.31 | 7425100.0 |
| 2001-08-27 | QQQ | ETF | 39.28 | 39.9 | 38.83 | 39.35 | 50927500.0 |
| 2001-08-27 | IWM | ETF | 48.05 | 48.225 | 47.675 | 47.875 | 249400.0 |
| 2001-08-27 | DIA | ETF | 104.5 | 104.61 | 103.91 | 103.91 | 2574400.0 |
| 2001-08-27 | BBH | ETF | 42.2833 | 42.6633 | 41.8767 | 42.2667 | 1698000.0 |
| 2001-08-27 | BITS | ETF | 16.16 | 16.2 | 15.08 | 16.0 | 3375.0 |
| 2001-08-27 | CEF | ETF | 3.2 | 3.23 | 3.14 | 3.19 | 12300.0 |
| 2001-08-27 | CHB | ETF | 10.14 | 10.35 | 10.1 | 10.35 | 282600.0 |
| 2001-08-27 | CNXT | ETF | 11.7 | 12.66 | 11.54 | 12.46 | 5444420.0 |
| 2001-08-27 | CSB | ETF | 3.29999995231628 | 3.29999995231628 | 3.29999995231628 | 3.29999995231628 | 16400.0 |
| 2001-08-27 | DGT | ETF | 67.65 | 67.95 | 67.65 | 67.86 | 4200.0 |
| 2001-08-27 | EFA | ETF | 42.9167 | 42.9167 | 42.76 | 42.8333 | 37500.0 |
| 2001-08-27 | EWA | ETF | 9.5 | 9.65 | 9.5 | 9.56 | 113900.0 |
| 2001-08-27 | EWC | ETF | 11.1 | 11.25 | 11.06 | 11.06 | 13300.0 |
| 2001-08-27 | EWD | ETF | 14.02 | 14.06 | 13.85 | 13.91 | 40700.0 |
| 2001-08-27 | EWG | ETF | 15.82 | 16.0 | 15.75 | 15.76 | 49800.0 |
| 2001-08-27 | EWH | ETF | 9.03 | 9.11 | 8.96 | 8.96 | 131600.0 |
| 2001-08-27 | EWI | ETF | 36.4 | 36.8 | 36.4 | 36.42 | 5900.0 |
| 2001-08-27 | EWJ | ETF | 37.6 | 38.0 | 37.44 | 37.68 | 279850.0 |
| 2001-08-27 | EWK | ETF | 11.85 | 11.85 | 11.85 | 11.85 | 2400.0 |
| 2001-08-27 | EWL | ETF | 13.24 | 13.26 | 13.24 | 13.24 | 700.0 |
| 2001-08-27 | EWM | ETF | 19.6 | 19.84 | 19.6 | 19.8 | 8150.0 |
| 2001-08-27 | EWN | ETF | 19.35 | 19.4 | 19.21 | 19.26 | 38500.0 |
| 2001-08-27 | EWP | ETF | 22.0 | 22.2 | 21.86 | 21.96 | 5700.0 |
| 2001-08-27 | EWQ | ETF | 20.4 | 20.55 | 20.3 | 20.35 | 17900.0 |
| 2001-08-27 | EWS | ETF | 10.56 | 10.76 | 10.56 | 10.64 | 11650.0 |
| 2001-08-27 | EWT | ETF | 18.1 | 18.1 | 17.68 | 17.68 | 2350.0 |
| 2001-08-27 | EWU | ETF | 30.88 | 31.08 | 30.56 | 30.88 | 54250.0 |
| 2001-08-27 | EWW | ETF | 15.7 | 15.95 | 15.7 | 15.95 | 4400.0 |
| 2001-08-27 | EWY | ETF | 14.3 | 14.3 | 13.96 | 13.96 | 362100.0 |
| 2001-08-27 | EWZ | ETF | 11.3 | 11.4 | 11.17 | 11.34 | 15900.0 |
| 2001-08-27 | EZU | ETF | 29.765 | 29.765 | 29.35 | 29.46 | 402600.0 |
| 2001-08-27 | FCTR | ETF | 18.38 | 18.44 | 18.05 | 18.15 | 12900.0 |
| 2001-08-27 | FMAR | ETF | 9.04 | 9.04 | 9.02 | 9.02 | 4300.0 |
| 2001-08-27 | GLDB | ETF | 7.75 | 7.85 | 7.58 | 7.65 | 11100.0 |
| 2001-08-27 | GRNB | ETF | 17.2771 | 18.6514 | 17.2771 | 17.2771 | 13323.0 |
| 2001-08-27 | GSIG | ETF | 8.42 | 8.54 | 8.24 | 8.26 | 29400.0 |
| 2001-08-27 | IBB | ETF | 30.0833 | 30.4667 | 29.8833 | 30.34 | 1090500.0 |
| 2001-08-27 | ICF | ETF | 22.2925 | 22.3075 | 22.14 | 22.14 | 8800.0 |
| 2001-08-27 | IDU | ETF | 37.01 | 37.415 | 37.01 | 37.39 | 4200.0 |
| 2001-08-27 | IEV | ETF | 31.45 | 31.49 | 31.18 | 31.3 | 36800.0 |
| 2001-08-27 | IGLD | ETF | 61.0 | 62.0 | 61.0 | 62.0 | 82.0 |
| 2001-08-27 | IGM | ETF | 8.5083 | 8.675 | 8.5083 | 8.6333 | 178800.0 |
| 2001-08-27 | IGN | ETF | 34.0 | 34.5 | 34.0 | 34.5 | 1300.0 |
| 2001-08-27 | IGV | ETF | 8.41 | 8.59 | 8.41 | 8.59 | 25500.0 |
| 2001-08-27 | IJH | ETF | 10.084 | 10.119 | 10.028 | 10.092 | 152000.0 |
| 2001-08-27 | IJJ | ETF | 22.7 | 22.745 | 22.55 | 22.6175 | 82400.0 |
| 2001-08-27 | IJK | ETF | 13.8625 | 13.9788 | 13.8488 | 13.96 | 87200.0 |
| 2001-08-27 | IJR | ETF | 18.8333 | 18.9217 | 18.8 | 18.8217 | 484800.0 |
| 2001-08-27 | IJS | ETF | 21.2325 | 21.315 | 21.1475 | 21.25 | 51600.0 |
> showing 50 of 106 rows — these rows as CSV