PREVIEW / etf_daily / 2004-10-27
file: by_date/etf_daily/2004/2004-10-27.parquet size: 11 KB rows: 167
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-27 | SPY | ETF | 111.38 | 113.1 | 111.12 | 112.88 | 73896000.0 |
| 2004-10-27 | QQQ | ETF | 35.84 | 36.9 | 35.71 | 36.73 | 152660800.0 |
| 2004-10-27 | IWM | ETF | 57.68 | 58.59 | 57.59 | 58.415 | 18685600.0 |
| 2004-10-27 | DIA | ETF | 98.95 | 100.37 | 98.62 | 100.14 | 10346700.0 |
| 2004-10-27 | TLT | ETF | 89.87 | 90.05 | 88.72 | 88.74 | 2351800.0 |
| 2004-10-27 | AAA | ETF | 55.13 | 55.51 | 54.8 | 55.47 | 5600.0 |
| 2004-10-27 | ADRE | ETF | 73.65 | 74.21 | 73.65 | 74.21 | 2524.0 |
| 2004-10-27 | AGG | ETF | 103.37 | 103.39 | 102.69 | 102.85 | 29100.0 |
| 2004-10-27 | ARB | ETF | 36.13 | 36.35 | 35.92 | 36.33 | 288800.0 |
| 2004-10-27 | BBH | ETF | 43.5167 | 45.3333 | 42.8833 | 45.0333 | 5097900.0 |
| 2004-10-27 | BITS | ETF | 6.0 | 6.0 | 6.0 | 6.0 | 850.0 |
| 2004-10-27 | BNE | ETF | 14.21 | 14.6 | 14.13 | 14.6 | 217400.0 |
| 2004-10-27 | CEF | ETF | 5.91 | 5.94 | 5.79 | 5.82 | 375600.0 |
| 2004-10-27 | CHB | ETF | 10.73 | 10.97 | 10.69 | 10.95 | 519600.0 |
| 2004-10-27 | CNXT | ETF | 1.6925 | 1.7276 | 1.6774 | 1.7075 | 5414980.0 |
| 2004-10-27 | CSB | ETF | 29.75 | 29.75 | 29.7000007629395 | 29.75 | 1000.0 |
| 2004-10-27 | DGT | ETF | 59.96 | 60.59 | 59.92 | 60.59 | 800.0 |
| 2004-10-27 | DVY | ETF | 57.5 | 58.0 | 57.19 | 58.0 | 525800.0 |
| 2004-10-27 | EEM | ETF | 19.4967 | 19.7778 | 19.4578 | 19.7333 | 3141000.0 |
| 2004-10-27 | EFA | ETF | 48.2233 | 48.6667 | 48.2 | 48.65 | 1210200.0 |
| 2004-10-27 | ELV | ETF | 39.425 | 40.8 | 38.775 | 40.56 | 4632100.0 |
| 2004-10-27 | EPP | ETF | 27.4533 | 27.65 | 27.4333 | 27.6267 | 330600.0 |
| 2004-10-27 | EWA | ETF | 15.19 | 15.34 | 15.16 | 15.27 | 269200.0 |
| 2004-10-27 | EWC | ETF | 16.28 | 16.37 | 16.19 | 16.23 | 64200.0 |
| 2004-10-27 | EWD | ETF | 18.5 | 18.71 | 18.49 | 18.6 | 63200.0 |
| 2004-10-27 | EWG | ETF | 16.18 | 16.35 | 16.04 | 16.35 | 137000.0 |
| 2004-10-27 | EWH | ETF | 10.88 | 11.05 | 10.83 | 10.99 | 981700.0 |
| 2004-10-27 | EWI | ETF | 44.94 | 45.26 | 44.84 | 44.98 | 6050.0 |
| 2004-10-27 | EWJ | ETF | 39.16 | 39.76 | 39.0 | 39.72 | 2460150.0 |
| 2004-10-27 | EWK | ETF | 16.88 | 16.94 | 16.77 | 16.93 | 100100.0 |
| 2004-10-27 | EWL | ETF | 15.34 | 15.36 | 15.3 | 15.36 | 6700.0 |
| 2004-10-27 | EWM | ETF | 26.96 | 27.4 | 26.84 | 27.4 | 22150.0 |
| 2004-10-27 | EWN | ETF | 16.6 | 16.62 | 16.55 | 16.61 | 3800.0 |
| 2004-10-27 | EWO | ETF | 18.79 | 18.88 | 18.75 | 18.84 | 102200.0 |
| 2004-10-27 | EWP | ETF | 30.72 | 30.8 | 30.54 | 30.8 | 26400.0 |
| 2004-10-27 | EWQ | ETF | 21.76 | 21.99 | 21.76 | 21.98 | 2300.0 |
| 2004-10-27 | EWS | ETF | 13.68 | 13.9 | 13.66 | 13.88 | 30700.0 |
| 2004-10-27 | EWT | ETF | 20.96 | 21.58 | 20.88 | 21.56 | 901000.0 |
| 2004-10-27 | EWU | ETF | 33.44 | 33.64 | 33.38 | 33.6 | 49200.0 |
| 2004-10-27 | EWW | ETF | 21.0 | 21.45 | 20.92 | 21.33 | 428100.0 |
| 2004-10-27 | EWY | ETF | 24.59 | 25.2 | 24.4 | 25.2 | 775200.0 |
| 2004-10-27 | EWZ | ETF | 18.73 | 18.87 | 18.6 | 18.78 | 288400.0 |
| 2004-10-27 | EZA | ETF | 34.285 | 34.37 | 34.15 | 34.18 | 60200.0 |
| 2004-10-27 | EZU | ETF | 32.38 | 32.5 | 32.28 | 32.5 | 117600.0 |
| 2004-10-27 | FCTR | ETF | 25.46 | 26.18 | 25.46 | 26.0 | 54282.0 |
| 2004-10-27 | FEZ | ETF | 35.57 | 35.71 | 35.5 | 35.67 | 106500.0 |
| 2004-10-27 | FMAR | ETF | 17.3 | 17.3 | 17.15 | 17.15 | 5170.0 |
| 2004-10-27 | FVD | ETF | 14.48 | 14.69 | 14.44 | 14.65 | 147400.0 |
| 2004-10-27 | FXI | ETF | 17.1 | 17.1467 | 16.9667 | 17.1167 | 1058400.0 |
| 2004-10-27 | GLDB | ETF | 14.6 | 14.69 | 14.28 | 14.44 | 492952.0 |
> showing 50 of 167 rows — these rows as CSV