PREVIEW / etf_daily / 2004-10-18
file: by_date/etf_daily/2004/2004-10-18.parquet size: 11 KB rows: 166
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-18 | SPY | ETF | 110.89 | 111.9 | 110.7 | 111.68 | 43535100.0 |
| 2004-10-18 | QQQ | ETF | 35.51 | 36.25 | 35.4 | 36.14 | 109346000.0 |
| 2004-10-18 | IWM | ETF | 56.66 | 57.225 | 56.36 | 57.05 | 14040600.0 |
| 2004-10-18 | DIA | ETF | 99.04 | 99.8 | 98.75 | 99.63 | 9897800.0 |
| 2004-10-18 | TLT | ETF | 88.65 | 88.79 | 88.37 | 88.71 | 613600.0 |
| 2004-10-18 | AAA | ETF | 57.94 | 57.95 | 57.94 | 57.95 | 900.0 |
| 2004-10-18 | ADRE | ETF | 76.52 | 76.52 | 72.47 | 72.47 | 800.0 |
| 2004-10-18 | AGG | ETF | 102.99 | 102.99 | 102.7 | 102.86 | 39700.0 |
| 2004-10-18 | ARB | ETF | 37.01 | 37.25 | 36.62 | 36.95 | 151000.0 |
| 2004-10-18 | BBH | ETF | 45.45 | 46.39 | 45.35 | 46.25 | 2827800.0 |
| 2004-10-18 | BITS | ETF | 5.56 | 5.8 | 5.56 | 5.8 | 325.0 |
| 2004-10-18 | BNE | ETF | 14.25 | 14.4 | 14.13 | 14.24 | 103600.0 |
| 2004-10-18 | CEF | ETF | 5.96 | 6.05 | 5.87 | 5.94 | 183100.0 |
| 2004-10-18 | CHB | ETF | 9.55 | 9.7 | 9.29 | 9.54 | 347900.0 |
| 2004-10-18 | CNXT | ETF | 1.68 | 1.71 | 1.67 | 1.7 | 3013070.0 |
| 2004-10-18 | CSB | ETF | 27.5 | 28.0 | 27.5 | 28.0 | 42500.0 |
| 2004-10-18 | DGT | ETF | 60.0 | 60.25 | 60.0 | 60.23 | 8600.0 |
| 2004-10-18 | DVY | ETF | 57.75 | 57.75 | 57.27 | 57.68 | 282600.0 |
| 2004-10-18 | EEM | ETF | 19.2289 | 19.3822 | 19.2 | 19.3556 | 1413900.0 |
| 2004-10-18 | EFA | ETF | 47.6567 | 47.8667 | 47.48 | 47.86 | 1239600.0 |
| 2004-10-18 | ELV | ETF | 40.77 | 40.87 | 40.49 | 40.5 | 1627400.0 |
| 2004-10-18 | EPP | ETF | 26.9167 | 26.9167 | 26.75 | 26.85 | 30900.0 |
| 2004-10-18 | EWA | ETF | 14.81 | 14.81 | 14.6 | 14.7 | 128600.0 |
| 2004-10-18 | EWC | ETF | 15.89 | 15.94 | 15.75 | 15.75 | 36100.0 |
| 2004-10-18 | EWD | ETF | 18.6 | 18.6 | 18.45 | 18.6 | 11200.0 |
| 2004-10-18 | EWG | ETF | 15.99 | 16.03 | 15.9 | 16.03 | 37900.0 |
| 2004-10-18 | EWH | ETF | 10.96 | 11.11 | 10.96 | 11.07 | 273600.0 |
| 2004-10-18 | EWI | ETF | 43.8 | 44.3 | 43.8 | 44.3 | 2100.0 |
| 2004-10-18 | EWJ | ETF | 38.96 | 39.4 | 38.88 | 39.32 | 1024250.0 |
| 2004-10-18 | EWK | ETF | 16.45 | 16.48 | 16.32 | 16.4 | 36600.0 |
| 2004-10-18 | EWL | ETF | 15.01 | 15.03 | 14.96 | 15.0 | 4900.0 |
| 2004-10-18 | EWM | ETF | 26.6 | 26.92 | 26.6 | 26.92 | 27375.0 |
| 2004-10-18 | EWN | ETF | 16.36 | 16.36 | 16.25 | 16.32 | 24300.0 |
| 2004-10-18 | EWO | ETF | 18.44 | 18.5 | 18.35 | 18.47 | 31900.0 |
| 2004-10-18 | EWP | ETF | 29.98 | 30.0 | 29.88 | 30.0 | 31200.0 |
| 2004-10-18 | EWQ | ETF | 21.42 | 21.48 | 21.36 | 21.4 | 3800.0 |
| 2004-10-18 | EWS | ETF | 13.46 | 13.58 | 13.36 | 13.56 | 142600.0 |
| 2004-10-18 | EWT | ETF | 21.1 | 21.3 | 20.96 | 21.22 | 298700.0 |
| 2004-10-18 | EWU | ETF | 33.08 | 33.08 | 32.84 | 32.98 | 36800.0 |
| 2004-10-18 | EWW | ETF | 20.3 | 20.53 | 20.3 | 20.53 | 586200.0 |
| 2004-10-18 | EWY | ETF | 25.15 | 25.47 | 25.15 | 25.37 | 232200.0 |
| 2004-10-18 | EWZ | ETF | 18.82 | 18.89 | 18.6 | 18.87 | 327000.0 |
| 2004-10-18 | EZA | ETF | 33.065 | 33.115 | 32.875 | 33.07 | 12400.0 |
| 2004-10-18 | EZU | ETF | 31.795 | 31.88 | 31.685 | 31.88 | 153200.0 |
| 2004-10-18 | FCTR | ETF | 26.38 | 26.38 | 25.47 | 26.0 | 76151.0 |
| 2004-10-18 | FEZ | ETF | 34.85 | 34.92 | 34.69 | 34.81 | 104500.0 |
| 2004-10-18 | FMAR | ETF | 17.05 | 17.21 | 17.05 | 17.21 | 6100.0 |
| 2004-10-18 | FVD | ETF | 14.5 | 14.6 | 14.45 | 14.55 | 160500.0 |
| 2004-10-18 | FXI | ETF | 17.2967 | 17.3167 | 17.2067 | 17.25 | 560400.0 |
| 2004-10-18 | GLDB | ETF | 14.09 | 14.13 | 13.96 | 14.07 | 612061.0 |
> showing 50 of 166 rows — these rows as CSV