PREVIEW / etf_daily / 2004-12-31
file: by_date/etf_daily/2004/2004-12-31.parquet size: 11 KB rows: 169
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-12-31 | SPY | ETF | 121.3 | 121.66 | 120.8 | 120.87 | 28648800.0 |
| 2004-12-31 | QQQ | ETF | 40.03 | 40.121 | 39.78 | 39.915 | 44145564.0 |
| 2004-12-31 | IWM | ETF | 64.94 | 65.33 | 64.68 | 64.75 | 15081800.0 |
| 2004-12-31 | DIA | ETF | 107.93 | 108.19 | 107.47 | 107.51 | 4262800.0 |
| 2004-12-31 | GLD | ETF | 43.85 | 43.94 | 43.73 | 43.8 | 531600.0 |
| 2004-12-31 | TLT | ETF | 88.37 | 88.65 | 88.3 | 88.55 | 1056400.0 |
| 2004-12-31 | AAA | ETF | 63.45 | 63.86 | 63.0 | 63.0 | 4000.0 |
| 2004-12-31 | ADRE | ETF | 84.8 | 84.8 | 83.612 | 83.72 | 5680.0 |
| 2004-12-31 | AGG | ETF | 102.36 | 102.59 | 102.25 | 102.4 | 135300.0 |
| 2004-12-31 | ARB | ETF | 39.3 | 39.32 | 38.86 | 39.08 | 285100.0 |
| 2004-12-31 | BBH | ETF | 51.2733 | 51.2733 | 50.8933 | 50.9733 | 1534800.0 |
| 2004-12-31 | BITS | ETF | 10.88 | 11.24 | 10.476 | 10.6 | 57386.0 |
| 2004-12-31 | BNE | ETF | 15.97 | 16.32 | 15.9 | 16.22 | 139600.0 |
| 2004-12-31 | CEF | ETF | 5.46 | 5.5 | 5.45 | 5.47 | 190900.0 |
| 2004-12-31 | CHB | ETF | 12.15 | 12.15 | 11.75 | 11.79 | 263800.0 |
| 2004-12-31 | CNXT | ETF | 2.06 | 2.09 | 1.9693 | 1.99 | 8536100.0 |
| 2004-12-31 | DGT | ETF | 64.5 | 64.55 | 64.42 | 64.43 | 1700.0 |
| 2004-12-31 | DVY | ETF | 61.65 | 61.7 | 61.34 | 61.4 | 375800.0 |
| 2004-12-31 | EEM | ETF | 22.4333 | 22.4333 | 22.33 | 22.4278 | 1507500.0 |
| 2004-12-31 | EFA | ETF | 53.3333 | 53.46 | 52.9667 | 53.4167 | 3647400.0 |
| 2004-12-31 | ELV | ETF | 57.6 | 58.225 | 57.38 | 57.5 | 693900.0 |
| 2004-12-31 | EPP | ETF | 29.96 | 30.06 | 29.9267 | 30.0567 | 454500.0 |
| 2004-12-31 | EWA | ETF | 16.66 | 16.74 | 16.57 | 16.7 | 675000.0 |
| 2004-12-31 | EWC | ETF | 17.19 | 17.3 | 17.15 | 17.29 | 52300.0 |
| 2004-12-31 | EWD | ETF | 21.11 | 21.14 | 20.96 | 20.96 | 8900.0 |
| 2004-12-31 | EWG | ETF | 18.64 | 18.67 | 18.53 | 18.63 | 87400.0 |
| 2004-12-31 | EWH | ETF | 12.06 | 12.1 | 12.05 | 12.09 | 265600.0 |
| 2004-12-31 | EWI | ETF | 51.46 | 51.46 | 51.0 | 51.2 | 53650.0 |
| 2004-12-31 | EWJ | ETF | 43.4 | 43.68 | 43.32 | 43.68 | 1477725.0 |
| 2004-12-31 | EWK | ETF | 18.52 | 18.66 | 18.45 | 18.56 | 43200.0 |
| 2004-12-31 | EWL | ETF | 17.12 | 17.23 | 17.12 | 17.2 | 8400.0 |
| 2004-12-31 | EWM | ETF | 28.68 | 28.68 | 28.36 | 28.6 | 19525.0 |
| 2004-12-31 | EWN | ETF | 18.5 | 18.52 | 18.39 | 18.41 | 13300.0 |
| 2004-12-31 | EWO | ETF | 23.1 | 23.17 | 22.9 | 23.02 | 280200.0 |
| 2004-12-31 | EWP | ETF | 35.6 | 35.82 | 35.3 | 35.3 | 111200.0 |
| 2004-12-31 | EWQ | ETF | 23.89 | 23.98 | 23.85 | 23.88 | 14000.0 |
| 2004-12-31 | EWS | ETF | 14.32 | 14.34 | 14.28 | 14.34 | 28450.0 |
| 2004-12-31 | EWT | ETF | 23.96 | 24.16 | 23.92 | 24.12 | 55100.0 |
| 2004-12-31 | EWU | ETF | 36.3 | 36.3 | 35.98 | 36.18 | 44800.0 |
| 2004-12-31 | EWW | ETF | 25.2 | 25.2 | 25.0 | 25.16 | 204300.0 |
| 2004-12-31 | EWY | ETF | 29.34 | 29.34 | 29.08 | 29.25 | 43400.0 |
| 2004-12-31 | EWZ | ETF | 22.21 | 22.35 | 22.19 | 22.24 | 596100.0 |
| 2004-12-31 | EZA | ETF | 39.6 | 39.825 | 39.6 | 39.8 | 17200.0 |
| 2004-12-31 | EZU | ETF | 36.445 | 36.445 | 36.18 | 36.3 | 59200.0 |
| 2004-12-31 | FCTR | ETF | 26.1 | 26.58 | 25.91 | 26.17 | 32683.0 |
| 2004-12-31 | FEZ | ETF | 40.25 | 40.25 | 40.06 | 40.07 | 17900.0 |
| 2004-12-31 | FMAR | ETF | 17.91 | 17.91 | 17.56 | 17.56 | 1800.0 |
| 2004-12-31 | FVD | ETF | 15.13 | 15.5 | 15.05 | 15.44 | 777300.0 |
| 2004-12-31 | FXI | ETF | 18.4667 | 18.4933 | 18.4167 | 18.49 | 532500.0 |
| 2004-12-31 | GLDB | ETF | 14.56 | 14.65 | 14.48 | 14.62 | 372271.0 |
> showing 50 of 169 rows — these rows as CSV