PREVIEW / etf_daily / 2004-12-27
file: by_date/etf_daily/2004/2004-12-27.parquet size: 11 KB rows: 170
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-27 | SPY | ETF | 121.2 | 121.36 | 120.39 | 120.52 | 29944100.0 |
| 2004-12-27 | QQQ | ETF | 39.98 | 40.02 | 39.4 | 39.59 | 67278365.0 |
| 2004-12-27 | IWM | ETF | 65.0 | 65.0 | 63.825 | 64.175 | 10330200.0 |
| 2004-12-27 | DIA | ETF | 108.43 | 108.56 | 107.72 | 107.76 | 5591200.0 |
| 2004-12-27 | GLD | ETF | 44.29 | 44.56 | 44.27 | 44.48 | 2643500.0 |
| 2004-12-27 | TLT | ETF | 88.33 | 88.37 | 87.7 | 87.9 | 1322600.0 |
| 2004-12-27 | AAA | ETF | 62.01 | 62.31 | 62.0 | 62.23 | 3200.0 |
| 2004-12-27 | ADRE | ETF | 84.8 | 84.8 | 82.41 | 82.459 | 2732.0 |
| 2004-12-27 | AGG | ETF | 102.4 | 102.5 | 102.3 | 102.43 | 145200.0 |
| 2004-12-27 | ARB | ETF | 38.91 | 39.41 | 38.3 | 39.17 | 193000.0 |
| 2004-12-27 | BBH | ETF | 50.6 | 50.6 | 49.7833 | 50.3 | 1519500.0 |
| 2004-12-27 | BITS | ETF | 12.2 | 12.2 | 11.32 | 12.0 | 51098.0 |
| 2004-12-27 | BNE | ETF | 15.93 | 16.06 | 15.82 | 15.88 | 270400.0 |
| 2004-12-27 | BOSS | ETF | 23.46 | 23.84 | 23.46 | 23.5 | 400.0 |
| 2004-12-27 | CEF | ETF | 5.4 | 5.47 | 5.39 | 5.45 | 374300.0 |
| 2004-12-27 | CHB | ETF | 11.93 | 12.07 | 11.67 | 11.85 | 263600.0 |
| 2004-12-27 | CNXT | ETF | 1.935 | 1.9561 | 1.8749 | 1.905 | 8798060.0 |
| 2004-12-27 | DGT | ETF | 64.45 | 64.57 | 64.3 | 64.35 | 46900.0 |
| 2004-12-27 | DVY | ETF | 61.35 | 61.5 | 60.97 | 61.07 | 378100.0 |
| 2004-12-27 | EEM | ETF | 22.1444 | 22.1622 | 22.0289 | 22.0644 | 1151100.0 |
| 2004-12-27 | EFA | ETF | 52.8967 | 53.3267 | 52.8133 | 53.0133 | 1929300.0 |
| 2004-12-27 | ELV | ETF | 57.05 | 57.25 | 56.375 | 56.42 | 1389800.0 |
| 2004-12-27 | EPP | ETF | 29.6333 | 29.7967 | 29.6333 | 29.7733 | 414000.0 |
| 2004-12-27 | EWA | ETF | 16.55 | 16.7 | 16.5 | 16.63 | 610500.0 |
| 2004-12-27 | EWC | ETF | 16.85 | 17.06 | 16.78 | 17.06 | 104500.0 |
| 2004-12-27 | EWD | ETF | 20.97 | 21.13 | 20.97 | 21.13 | 14100.0 |
| 2004-12-27 | EWG | ETF | 18.56 | 18.58 | 18.46 | 18.55 | 143700.0 |
| 2004-12-27 | EWH | ETF | 12.03 | 12.09 | 11.93 | 11.95 | 213400.0 |
| 2004-12-27 | EWI | ETF | 51.1 | 51.42 | 51.04 | 51.4 | 56750.0 |
| 2004-12-27 | EWJ | ETF | 42.44 | 42.6 | 42.36 | 42.44 | 1163375.0 |
| 2004-12-27 | EWK | ETF | 18.5 | 18.59 | 18.42 | 18.45 | 32900.0 |
| 2004-12-27 | EWL | ETF | 17.0 | 17.11 | 17.0 | 17.1 | 31300.0 |
| 2004-12-27 | EWM | ETF | 28.16 | 28.44 | 28.0 | 28.24 | 100425.0 |
| 2004-12-27 | EWN | ETF | 18.48 | 18.48 | 18.31 | 18.4 | 20400.0 |
| 2004-12-27 | EWO | ETF | 22.85 | 22.97 | 22.7 | 22.97 | 233700.0 |
| 2004-12-27 | EWP | ETF | 35.32 | 35.48 | 35.25 | 35.34 | 129000.0 |
| 2004-12-27 | EWQ | ETF | 23.88 | 23.96 | 23.8 | 23.96 | 23700.0 |
| 2004-12-27 | EWS | ETF | 14.18 | 14.2 | 14.04 | 14.1 | 51450.0 |
| 2004-12-27 | EWT | ETF | 23.06 | 23.22 | 23.0 | 23.06 | 175650.0 |
| 2004-12-27 | EWU | ETF | 35.98 | 36.24 | 35.82 | 36.16 | 40350.0 |
| 2004-12-27 | EWW | ETF | 24.68 | 24.86 | 24.68 | 24.86 | 224700.0 |
| 2004-12-27 | EWY | ETF | 28.29 | 28.3 | 28.05 | 28.24 | 120700.0 |
| 2004-12-27 | EWZ | ETF | 21.68 | 21.8 | 21.65 | 21.72 | 412500.0 |
| 2004-12-27 | EZA | ETF | 39.2 | 39.315 | 39.13 | 39.315 | 27400.0 |
| 2004-12-27 | EZU | ETF | 36.195 | 36.4 | 36.055 | 36.37 | 101600.0 |
| 2004-12-27 | FCTR | ETF | 26.89 | 26.93 | 26.26 | 26.6 | 46917.0 |
| 2004-12-27 | FEZ | ETF | 40.19 | 40.32 | 40.18 | 40.2 | 31100.0 |
| 2004-12-27 | FMAR | ETF | 17.475 | 17.515 | 17.475 | 17.515 | 2270.0 |
| 2004-12-27 | FVD | ETF | 14.78 | 14.79 | 14.68 | 14.7 | 104400.0 |
| 2004-12-27 | FXI | ETF | 18.5833 | 18.6 | 18.4833 | 18.49 | 647400.0 |
> showing 50 of 170 rows — these rows as CSV