PREVIEW / etf_daily / 2001-12-14
file: by_date/etf_daily/2001/2001-12-14.parquet size: 9 KB rows: 113
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-12-14 | SPY | ETF | 112.33 | 113.49 | 112.0 | 113.13 | 16721900.0 |
| 2001-12-14 | QQQ | ETF | 39.872 | 40.46 | 39.57 | 40.11 | 70007400.0 |
| 2001-12-14 | IWM | ETF | 46.65 | 46.95 | 46.365 | 46.95 | 1147400.0 |
| 2001-12-14 | DIA | ETF | 97.81 | 98.79 | 97.6 | 98.6 | 3638200.0 |
| 2001-12-14 | ARB | ETF | 30.45 | 31.0 | 30.42 | 30.91 | 28300.0 |
| 2001-12-14 | BBH | ETF | 43.3333 | 43.3333 | 42.5533 | 42.95 | 3188100.0 |
| 2001-12-14 | BITS | ETF | 26.6 | 28.44 | 26.36 | 27.72 | 39775.0 |
| 2001-12-14 | CEF | ETF | 3.35 | 3.4 | 3.3 | 3.39 | 32700.0 |
| 2001-12-14 | CHB | ETF | 12.5 | 13.4 | 12.35 | 13.4 | 350700.0 |
| 2001-12-14 | CNXT | ETF | 15.74 | 16.2 | 15.49 | 15.86 | 7185470.0 |
| 2001-12-14 | CSB | ETF | 3.79999995231628 | 3.84999990463257 | 3.79999995231628 | 3.84999990463257 | 27700.0 |
| 2001-12-14 | DGT | ETF | 64.79 | 65.01 | 64.79 | 65.01 | 1800.0 |
| 2001-12-14 | EFA | ETF | 39.0 | 39.0633 | 38.8633 | 38.9933 | 874800.0 |
| 2001-12-14 | ELV | ETF | 24.0 | 24.05 | 23.675 | 24.0 | 406800.0 |
| 2001-12-14 | EPP | ETF | 17.9 | 17.9 | 17.86 | 17.86 | 2400.0 |
| 2001-12-14 | EWA | ETF | 9.17 | 9.26 | 9.16 | 9.17 | 12400.0 |
| 2001-12-14 | EWC | ETF | 10.6 | 10.85 | 10.6 | 10.75 | 3800.0 |
| 2001-12-14 | EWD | ETF | 13.47 | 13.47 | 13.25 | 13.25 | 6300.0 |
| 2001-12-14 | EWG | ETF | 14.65 | 14.65 | 14.45 | 14.5 | 50000.0 |
| 2001-12-14 | EWH | ETF | 9.16 | 9.31 | 9.07 | 9.31 | 53400.0 |
| 2001-12-14 | EWI | ETF | 31.6 | 31.6 | 31.6 | 31.6 | 3500.0 |
| 2001-12-14 | EWJ | ETF | 31.4 | 31.72 | 31.24 | 31.64 | 547850.0 |
| 2001-12-14 | EWK | ETF | 10.3 | 10.3 | 10.3 | 10.3 | 800.0 |
| 2001-12-14 | EWL | ETF | 12.37 | 12.55 | 12.35 | 12.35 | 5100.0 |
| 2001-12-14 | EWM | ETF | 19.6 | 19.6 | 19.04 | 19.04 | 8275.0 |
| 2001-12-14 | EWN | ETF | 16.28 | 16.34 | 16.15 | 16.15 | 1700.0 |
| 2001-12-14 | EWO | ETF | 7.42 | 7.42 | 7.42 | 7.42 | 3200.0 |
| 2001-12-14 | EWP | ETF | 20.88 | 21.04 | 20.88 | 21.04 | 2500.0 |
| 2001-12-14 | EWQ | ETF | 18.07 | 18.07 | 17.94 | 17.94 | 11000.0 |
| 2001-12-14 | EWS | ETF | 9.9 | 9.98 | 9.78 | 9.8 | 30950.0 |
| 2001-12-14 | EWT | ETF | 21.1 | 22.1 | 21.1 | 22.1 | 98450.0 |
| 2001-12-14 | EWU | ETF | 28.66 | 28.94 | 28.62 | 28.8 | 10900.0 |
| 2001-12-14 | EWW | ETF | 14.83 | 14.84 | 14.6 | 14.8 | 4000.0 |
| 2001-12-14 | EWY | ETF | 16.75 | 17.24 | 16.75 | 17.01 | 40100.0 |
| 2001-12-14 | EWZ | ETF | 11.91 | 11.91 | 11.84 | 11.85 | 1800.0 |
| 2001-12-14 | EZU | ETF | 26.925 | 27.065 | 26.84 | 26.93 | 27000.0 |
| 2001-12-14 | FCTR | ETF | 17.45 | 17.9 | 17.45 | 17.9 | 19300.0 |
| 2001-12-14 | FMAR | ETF | 8.24 | 8.24 | 8.13 | 8.2 | 2400.0 |
| 2001-12-14 | GLDB | ETF | 7.23 | 7.35 | 7.21 | 7.35 | 33700.0 |
| 2001-12-14 | GSIG | ETF | 7.86 | 8.0 | 7.65 | 7.82 | 97500.0 |
| 2001-12-14 | IBB | ETF | 30.0833 | 30.13 | 29.6 | 30.0 | 484200.0 |
| 2001-12-14 | ICF | ETF | 21.0375 | 21.2125 | 21.0375 | 21.2125 | 20000.0 |
| 2001-12-14 | IDU | ETF | 29.875 | 30.195 | 29.795 | 30.165 | 68400.0 |
| 2001-12-14 | IEV | ETF | 28.75 | 28.925 | 28.72 | 28.825 | 71000.0 |
| 2001-12-14 | IGLD | ETF | 88.0 | 94.0 | 88.0 | 91.0 | 103.0 |
| 2001-12-14 | IGM | ETF | 8.5333 | 8.6167 | 8.5167 | 8.6117 | 66600.0 |
| 2001-12-14 | IGN | ETF | 31.3 | 31.3 | 30.58 | 31.07 | 409400.0 |
| 2001-12-14 | IGV | ETF | 9.056 | 9.1 | 8.924 | 9.098 | 19500.0 |
| 2001-12-14 | IJH | ETF | 9.805 | 9.855 | 9.744 | 9.833 | 348000.0 |
| 2001-12-14 | IJJ | ETF | 21.625 | 21.715 | 21.53 | 21.7075 | 50400.0 |
> showing 50 of 113 rows — these rows as CSV