PREVIEW / etf_daily / 2002-01-23
file: by_date/etf_daily/2002/2002-01-23.parquet size: 9 KB rows: 118
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-23 | SPY | ETF | 112.63 | 113.55 | 112.02 | 113.23 | 12438900.0 |
| 2002-01-23 | QQQ | ETF | 37.65 | 38.69 | 37.35 | 38.43 | 74968800.0 |
| 2002-01-23 | IWM | ETF | 46.825 | 47.425 | 46.4 | 47.3 | 1752600.0 |
| 2002-01-23 | DIA | ETF | 97.45 | 97.83 | 96.88 | 97.4 | 3672900.0 |
| 2002-01-23 | ARB | ETF | 31.55 | 32.3 | 31.4 | 32.06 | 32800.0 |
| 2002-01-23 | BBH | ETF | 41.45 | 42.8 | 41.0067 | 42.5267 | 7222800.0 |
| 2002-01-23 | BITS | ETF | 19.6 | 20.2 | 17.6904 | 19.2 | 11725.0 |
| 2002-01-23 | CEF | ETF | 3.5 | 3.5 | 3.47 | 3.47 | 23900.0 |
| 2002-01-23 | CHB | ETF | 11.1 | 11.85 | 11.1 | 11.85 | 171400.0 |
| 2002-01-23 | CNXT | ETF | 11.845 | 12.235 | 11.835 | 12.145 | 4980230.0 |
| 2002-01-23 | CSB | ETF | 4.59999990463257 | 4.59999990463257 | 4.59999990463257 | 4.59999990463257 | 4200.0 |
| 2002-01-23 | DGT | ETF | 64.5 | 64.85 | 64.5 | 64.85 | 400.0 |
| 2002-01-23 | EFA | ETF | 38.2267 | 38.2333 | 38.04 | 38.15 | 757200.0 |
| 2002-01-23 | ELV | ETF | 25.7 | 26.435 | 25.7 | 26.13 | 812700.0 |
| 2002-01-23 | EPP | ETF | 18.38 | 18.4 | 18.3767 | 18.38 | 73500.0 |
| 2002-01-23 | EWA | ETF | 9.59 | 9.6 | 9.53 | 9.56 | 15800.0 |
| 2002-01-23 | EWC | ETF | 10.7 | 10.75 | 10.69 | 10.74 | 17000.0 |
| 2002-01-23 | EWD | ETF | 12.83 | 12.89 | 12.83 | 12.89 | 4600.0 |
| 2002-01-23 | EWG | ETF | 14.8 | 14.84 | 14.7 | 14.78 | 45400.0 |
| 2002-01-23 | EWH | ETF | 9.14 | 9.22 | 9.1 | 9.22 | 48600.0 |
| 2002-01-23 | EWI | ETF | 31.98 | 31.98 | 31.76 | 31.8 | 4750.0 |
| 2002-01-23 | EWJ | ETF | 29.0 | 29.12 | 28.84 | 29.12 | 85750.0 |
| 2002-01-23 | EWK | ETF | 10.84 | 11.03 | 10.84 | 11.03 | 8800.0 |
| 2002-01-23 | EWL | ETF | 12.5 | 12.55 | 12.5 | 12.53 | 26000.0 |
| 2002-01-23 | EWM | ETF | 20.6 | 20.68 | 20.32 | 20.4 | 2275.0 |
| 2002-01-23 | EWN | ETF | 16.78 | 16.78 | 16.46 | 16.48 | 5400.0 |
| 2002-01-23 | EWO | ETF | 7.44 | 7.44 | 7.43 | 7.43 | 2700.0 |
| 2002-01-23 | EWP | ETF | 19.98 | 20.04 | 19.95 | 20.04 | 8800.0 |
| 2002-01-23 | EWQ | ETF | 18.1 | 18.1 | 17.96 | 18.0 | 11700.0 |
| 2002-01-23 | EWS | ETF | 10.36 | 10.56 | 10.36 | 10.54 | 19800.0 |
| 2002-01-23 | EWT | ETF | 21.98 | 22.5 | 21.64 | 22.48 | 15800.0 |
| 2002-01-23 | EWU | ETF | 28.6 | 28.62 | 28.4 | 28.48 | 54400.0 |
| 2002-01-23 | EWW | ETF | 15.73 | 16.14 | 15.7 | 16.14 | 12500.0 |
| 2002-01-23 | EWY | ETF | 18.95 | 18.95 | 18.7 | 18.74 | 60500.0 |
| 2002-01-23 | EWZ | ETF | 12.0 | 12.0 | 11.94 | 11.97 | 8200.0 |
| 2002-01-23 | EZU | ETF | 26.85 | 26.885 | 26.75 | 26.75 | 8200.0 |
| 2002-01-23 | FCTR | ETF | 17.2501 | 17.48 | 17.25 | 17.45 | 49300.0 |
| 2002-01-23 | GLDB | ETF | 6.97 | 7.1 | 6.97 | 7.1 | 49900.0 |
| 2002-01-23 | GRNB | ETF | 17.6698 | 17.6698 | 17.6698 | 17.6698 | 101.0 |
| 2002-01-23 | GSIG | ETF | 9.65 | 9.97 | 9.65 | 9.87 | 27600.0 |
| 2002-01-23 | IBB | ETF | 26.9667 | 27.8667 | 26.6667 | 27.75 | 1107300.0 |
| 2002-01-23 | ICF | ETF | 20.9425 | 21.0175 | 20.9375 | 21.01 | 22000.0 |
| 2002-01-23 | IDU | ETF | 30.76 | 31.025 | 30.585 | 31.025 | 808600.0 |
| 2002-01-23 | IEV | ETF | 28.625 | 28.75 | 28.475 | 28.645 | 47400.0 |
| 2002-01-23 | IGLD | ETF | 138.0 | 141.0 | 113.0 | 124.0 | 1196.0 |
| 2002-01-23 | IGM | ETF | 8.17 | 8.2917 | 8.1 | 8.2717 | 39600.0 |
| 2002-01-23 | IGN | ETF | 29.15 | 30.01 | 28.75 | 29.81 | 513700.0 |
| 2002-01-23 | IGV | ETF | 9.14 | 9.352 | 9.024 | 9.312 | 531500.0 |
| 2002-01-23 | IJH | ETF | 9.88 | 10.01 | 9.86 | 10.01 | 571000.0 |
| 2002-01-23 | IJJ | ETF | 22.0375 | 22.31 | 21.9025 | 22.31 | 74400.0 |
> showing 50 of 118 rows — these rows as CSV