PREVIEW / etf_daily / 2001-07-06
file: by_date/etf_daily/2001/2001-07-06.parquet size: 8 KB rows: 96
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-07-06 | SPY | ETF | 121.31 | 121.49 | 119.05 | 119.05 | 11665900.0 |
| 2001-07-06 | QQQ | ETF | 43.01 | 43.11 | 41.49 | 41.65 | 53437400.0 |
| 2001-07-06 | IWM | ETF | 48.55 | 48.725 | 47.775 | 47.95 | 588600.0 |
| 2001-07-06 | DIA | ETF | 104.63 | 104.63 | 102.32 | 102.56 | 2707600.0 |
| 2001-07-06 | BBH | ETF | 41.8667 | 41.8767 | 40.67 | 41.1733 | 4354800.0 |
| 2001-07-06 | BITS | ETF | 12.4 | 13.2 | 12.28 | 12.44 | 3775.0 |
| 2001-07-06 | BOSS | ETF | 29.5 | 29.5 | 29.2 | 29.2 | 1000.0 |
| 2001-07-06 | CEF | ETF | 3.2 | 3.28 | 3.15 | 3.16 | 40100.0 |
| 2001-07-06 | CHB | ETF | 11.4 | 11.4 | 10.7 | 11.0 | 103200.0 |
| 2001-07-06 | CNXT | ETF | 7.76 | 7.94 | 7.25 | 7.35 | 1676500.0 |
| 2001-07-06 | CSB | ETF | 2.04999995231628 | 2.20000004768372 | 2.04999995231628 | 2.04999995231628 | 3500.0 |
| 2001-07-06 | DGT | ETF | 68.52 | 68.52 | 68.5 | 68.5 | 1100.0 |
| 2001-07-06 | EWA | ETF | 9.38 | 9.38 | 9.21 | 9.21 | 3400.0 |
| 2001-07-06 | EWC | ETF | 11.26 | 11.5 | 11.2 | 11.2 | 6700.0 |
| 2001-07-06 | EWD | ETF | 12.85 | 12.85 | 12.5 | 12.5 | 3400.0 |
| 2001-07-06 | EWG | ETF | 16.1 | 16.1 | 15.85 | 15.87 | 6400.0 |
| 2001-07-06 | EWH | ETF | 9.85 | 9.92 | 9.79 | 9.8 | 63900.0 |
| 2001-07-06 | EWI | ETF | 35.4 | 35.4 | 35.3 | 35.3 | 2150.0 |
| 2001-07-06 | EWJ | ETF | 39.0 | 39.04 | 38.4 | 38.44 | 137925.0 |
| 2001-07-06 | EWL | ETF | 13.05 | 13.05 | 13.05 | 13.05 | 3300.0 |
| 2001-07-06 | EWM | ETF | 18.0 | 18.4 | 18.0 | 18.0 | 11100.0 |
| 2001-07-06 | EWN | ETF | 18.95 | 19.0 | 18.95 | 19.0 | 2200.0 |
| 2001-07-06 | EWO | ETF | 7.65 | 7.66 | 7.65 | 7.66 | 200.0 |
| 2001-07-06 | EWP | ETF | 20.28 | 20.5 | 20.28 | 20.5 | 1300.0 |
| 2001-07-06 | EWQ | ETF | 19.1 | 19.2 | 19.0 | 19.08 | 7700.0 |
| 2001-07-06 | EWS | ETF | 10.38 | 10.38 | 10.24 | 10.32 | 12850.0 |
| 2001-07-06 | EWT | ETF | 19.68 | 19.68 | 19.4 | 19.4 | 2500.0 |
| 2001-07-06 | EWU | ETF | 30.34 | 30.44 | 29.8 | 30.36 | 23050.0 |
| 2001-07-06 | EWW | ETF | 16.85 | 16.85 | 16.4 | 16.4 | 13700.0 |
| 2001-07-06 | EWY | ETF | 13.76 | 13.76 | 13.75 | 13.75 | 2900.0 |
| 2001-07-06 | EWZ | ETF | 12.93 | 13.15 | 12.77 | 13.15 | 236100.0 |
| 2001-07-06 | EZU | ETF | 29.0 | 29.14 | 28.9 | 28.905 | 1800.0 |
| 2001-07-06 | FCTR | ETF | 17.3 | 17.3 | 16.8 | 16.83 | 19800.0 |
| 2001-07-06 | FMAR | ETF | 5.75 | 6.2 | 5.75 | 6.2 | 900.0 |
| 2001-07-06 | GLDB | ETF | 7.8 | 7.8 | 7.3 | 7.45 | 42500.0 |
| 2001-07-06 | GSIG | ETF | 8.81 | 8.9 | 8.75 | 8.84 | 35400.0 |
| 2001-07-06 | IBB | ETF | 31.26 | 31.26 | 30.5333 | 30.8667 | 583500.0 |
| 2001-07-06 | ICF | ETF | 21.29 | 21.3 | 21.25 | 21.25 | 104000.0 |
| 2001-07-06 | IDU | ETF | 40.165 | 40.19 | 40.03 | 40.19 | 8200.0 |
| 2001-07-06 | IEV | ETF | 30.55 | 30.71 | 30.205 | 30.5 | 24600.0 |
| 2001-07-06 | IGM | ETF | 9.1667 | 9.1667 | 9.0 | 9.0417 | 16200.0 |
| 2001-07-06 | IJH | ETF | 10.187 | 10.187 | 10.025 | 10.105 | 76000.0 |
| 2001-07-06 | IJJ | ETF | 22.6825 | 22.6875 | 22.3275 | 22.385 | 374800.0 |
| 2001-07-06 | IJK | ETF | 14.175 | 14.175 | 13.9625 | 13.975 | 34400.0 |
| 2001-07-06 | IJR | ETF | 18.6417 | 18.6417 | 18.3083 | 18.3633 | 144600.0 |
| 2001-07-06 | IJS | ETF | 20.825 | 20.825 | 20.53 | 20.6375 | 78400.0 |
| 2001-07-06 | IJT | ETF | 18.775 | 18.775 | 18.415 | 18.45 | 19600.0 |
| 2001-07-06 | IOO | ETF | 30.755 | 30.755 | 30.27 | 30.4 | 30400.0 |
| 2001-07-06 | IUSG | ETF | 21.66 | 21.66 | 21.325 | 21.335 | 2800.0 |
| 2001-07-06 | IUSV | ETF | 24.95 | 24.95 | 24.57 | 24.6467 | 22200.0 |
> showing 50 of 96 rows — these rows as CSV