PREVIEW / etf_daily / 2004-12-20
file: by_date/etf_daily/2004/2004-12-20.parquet size: 11 KB rows: 171
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-20 | SPY | ETF | 119.75 | 120.29 | 119.17 | 119.47 | 47187400.0 |
| 2004-12-20 | QQQ | ETF | 39.58 | 39.771 | 39.09 | 39.2 | 106719878.0 |
| 2004-12-20 | IWM | ETF | 64.045 | 64.47 | 63.51 | 63.83 | 11991600.0 |
| 2004-12-20 | DIA | ETF | 106.76 | 107.15 | 106.35 | 106.62 | 6136000.0 |
| 2004-12-20 | GLD | ETF | 44.33 | 44.37 | 44.13 | 44.34 | 1942100.0 |
| 2004-12-20 | TLT | ETF | 88.87 | 89.1 | 88.82 | 88.91 | 230500.0 |
| 2004-12-20 | AAA | ETF | 57.2 | 57.2 | 56.76 | 56.82 | 4200.0 |
| 2004-12-20 | ADRE | ETF | 81.0 | 81.999 | 80.99 | 81.16 | 4880.0 |
| 2004-12-20 | AGG | ETF | 102.69 | 102.72 | 102.46 | 102.55 | 57800.0 |
| 2004-12-20 | ARB | ETF | 38.03 | 38.23 | 37.24 | 37.3 | 114000.0 |
| 2004-12-20 | BBH | ETF | 49.7 | 49.9267 | 49.2133 | 49.3267 | 1660800.0 |
| 2004-12-20 | BITS | ETF | 14.0 | 14.24 | 12.92 | 13.52 | 36872.0 |
| 2004-12-20 | BNE | ETF | 15.49 | 15.5 | 15.4 | 15.4 | 158100.0 |
| 2004-12-20 | CEF | ETF | 5.48 | 5.55 | 5.42 | 5.43 | 280000.0 |
| 2004-12-20 | CHB | ETF | 11.88 | 12.01 | 11.8 | 11.81 | 230900.0 |
| 2004-12-20 | CNXT | ETF | 1.94 | 2.01 | 1.94 | 1.96 | 7687920.0 |
| 2004-12-20 | CSB | ETF | 33.5499992370605 | 33.5499992370605 | 33.5 | 33.5 | 7700.0 |
| 2004-12-20 | DGT | ETF | 63.75 | 63.94 | 63.37 | 63.46 | 4200.0 |
| 2004-12-20 | DVY | ETF | 60.92 | 61.28 | 60.82 | 60.95 | 512300.0 |
| 2004-12-20 | EEM | ETF | 21.9444 | 21.9967 | 21.7278 | 21.9944 | 1858500.0 |
| 2004-12-20 | EFA | ETF | 52.88 | 53.0333 | 52.2 | 52.61 | 2919000.0 |
| 2004-12-20 | ELV | ETF | 57.925 | 58.055 | 56.9 | 57.3 | 1455900.0 |
| 2004-12-20 | EPP | ETF | 30.01 | 30.1933 | 30.01 | 30.1833 | 307200.0 |
| 2004-12-20 | EWA | ETF | 16.67 | 16.7 | 16.56 | 16.58 | 303900.0 |
| 2004-12-20 | EWC | ETF | 16.6 | 16.84 | 16.6 | 16.84 | 71200.0 |
| 2004-12-20 | EWD | ETF | 20.7 | 20.81 | 20.69 | 20.8 | 23800.0 |
| 2004-12-20 | EWG | ETF | 18.43 | 18.44 | 18.15 | 18.33 | 259900.0 |
| 2004-12-20 | EWH | ETF | 12.23 | 12.35 | 12.23 | 12.29 | 5822100.0 |
| 2004-12-20 | EWI | ETF | 50.8 | 51.24 | 50.7 | 51.12 | 6600.0 |
| 2004-12-20 | EWJ | ETF | 41.52 | 41.8 | 41.52 | 41.56 | 1378525.0 |
| 2004-12-20 | EWK | ETF | 18.4 | 18.56 | 18.34 | 18.49 | 24600.0 |
| 2004-12-20 | EWL | ETF | 16.89 | 17.01 | 16.72 | 16.95 | 21300.0 |
| 2004-12-20 | EWM | ETF | 29.08 | 29.2 | 29.0 | 29.12 | 151275.0 |
| 2004-12-20 | EWN | ETF | 18.15 | 18.28 | 18.07 | 18.17 | 16500.0 |
| 2004-12-20 | EWO | ETF | 22.5 | 22.58 | 22.31 | 22.49 | 143300.0 |
| 2004-12-20 | EWP | ETF | 34.77 | 34.93 | 34.65 | 34.75 | 16700.0 |
| 2004-12-20 | EWQ | ETF | 23.42 | 23.5 | 23.32 | 23.35 | 46400.0 |
| 2004-12-20 | EWS | ETF | 14.6 | 14.68 | 14.5 | 14.58 | 77200.0 |
| 2004-12-20 | EWT | ETF | 23.5 | 23.5 | 23.1 | 23.36 | 3273050.0 |
| 2004-12-20 | EWU | ETF | 36.68 | 36.76 | 36.46 | 36.56 | 77650.0 |
| 2004-12-20 | EWW | ETF | 24.31 | 24.39 | 24.25 | 24.35 | 93700.0 |
| 2004-12-20 | EWY | ETF | 28.06 | 28.39 | 28.05 | 28.26 | 3250700.0 |
| 2004-12-20 | EWZ | ETF | 21.48 | 21.71 | 21.47 | 21.7 | 474400.0 |
| 2004-12-20 | EZA | ETF | 38.75 | 39.035 | 38.75 | 38.945 | 39800.0 |
| 2004-12-20 | EZU | ETF | 35.92 | 35.95 | 35.705 | 35.875 | 66400.0 |
| 2004-12-20 | FCTR | ETF | 26.06 | 26.55 | 26.06 | 26.5 | 37847.0 |
| 2004-12-20 | FEZ | ETF | 39.12 | 39.14 | 38.88 | 38.9 | 12100.0 |
| 2004-12-20 | FMAR | ETF | 17.3 | 17.49 | 17.3 | 17.31 | 4580.0 |
| 2004-12-20 | FVD | ETF | 14.65 | 14.75 | 14.5 | 14.58 | 256700.0 |
| 2004-12-20 | FXI | ETF | 18.6333 | 18.64 | 18.55 | 18.59 | 3759000.0 |
> showing 50 of 171 rows — these rows as CSV