PREVIEW / etf_daily / 2004-10-19
file: by_date/etf_daily/2004/2004-10-19.parquet size: 11 KB rows: 168
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-19 | SPY | ETF | 112.02 | 112.23 | 110.59 | 110.74 | 55851900.0 |
| 2004-10-19 | QQQ | ETF | 36.38 | 36.57 | 35.79 | 35.88 | 130149600.0 |
| 2004-10-19 | IWM | ETF | 57.265 | 57.54 | 56.4 | 56.46 | 14654200.0 |
| 2004-10-19 | DIA | ETF | 99.98 | 100.37 | 99.02 | 99.1 | 9483600.0 |
| 2004-10-19 | TLT | ETF | 88.33 | 88.99 | 88.27 | 88.94 | 505400.0 |
| 2004-10-19 | AAA | ETF | 58.17 | 58.26 | 57.96 | 57.96 | 3700.0 |
| 2004-10-19 | ADRE | ETF | 73.45 | 73.45 | 72.711 | 72.711 | 1712.0 |
| 2004-10-19 | AGG | ETF | 102.65 | 103.04 | 102.65 | 102.91 | 32200.0 |
| 2004-10-19 | ARB | ETF | 38.25 | 38.25 | 36.58 | 36.81 | 306200.0 |
| 2004-10-19 | BBH | ETF | 46.5233 | 46.6033 | 45.85 | 45.9067 | 2025000.0 |
| 2004-10-19 | BITS | ETF | 5.8 | 6.08 | 5.8 | 6.08 | 1125.0 |
| 2004-10-19 | BNE | ETF | 14.26 | 14.39 | 14.0 | 14.02 | 122800.0 |
| 2004-10-19 | CEF | ETF | 5.92 | 5.98 | 5.9 | 5.97 | 156500.0 |
| 2004-10-19 | CHB | ETF | 9.61 | 9.95 | 9.53 | 9.55 | 461700.0 |
| 2004-10-19 | CNXT | ETF | 1.74 | 1.77 | 1.67 | 1.69 | 5228040.0 |
| 2004-10-19 | CSB | ETF | 28.0 | 28.0 | 28.0 | 28.0 | 3100.0 |
| 2004-10-19 | DGT | ETF | 60.5 | 60.68 | 60.21 | 60.21 | 1000.0 |
| 2004-10-19 | DVY | ETF | 57.85 | 57.89 | 56.89 | 56.95 | 427400.0 |
| 2004-10-19 | EEM | ETF | 19.5167 | 19.6033 | 19.2622 | 19.2622 | 1402200.0 |
| 2004-10-19 | EFA | ETF | 48.1333 | 48.1933 | 47.7333 | 47.7667 | 2419200.0 |
| 2004-10-19 | ELV | ETF | 39.675 | 39.68 | 36.1 | 36.85 | 13446100.0 |
| 2004-10-19 | EPP | ETF | 26.9067 | 27.0933 | 26.85 | 26.8633 | 315300.0 |
| 2004-10-19 | EWA | ETF | 14.72 | 14.82 | 14.65 | 14.65 | 104000.0 |
| 2004-10-19 | EWC | ETF | 15.75 | 15.86 | 15.6 | 15.65 | 69500.0 |
| 2004-10-19 | EWD | ETF | 18.63 | 18.8 | 18.61 | 18.72 | 16100.0 |
| 2004-10-19 | EWG | ETF | 16.1 | 16.17 | 16.01 | 16.03 | 41000.0 |
| 2004-10-19 | EWH | ETF | 11.13 | 11.19 | 11.05 | 11.07 | 442900.0 |
| 2004-10-19 | EWI | ETF | 44.28 | 44.28 | 44.08 | 44.1 | 3500.0 |
| 2004-10-19 | EWJ | ETF | 39.64 | 39.76 | 39.32 | 39.36 | 1243800.0 |
| 2004-10-19 | EWK | ETF | 16.44 | 16.53 | 16.31 | 16.33 | 59200.0 |
| 2004-10-19 | EWL | ETF | 15.07 | 15.11 | 14.99 | 14.99 | 12300.0 |
| 2004-10-19 | EWM | ETF | 26.88 | 27.08 | 26.76 | 26.8 | 11500.0 |
| 2004-10-19 | EWN | ETF | 16.39 | 16.39 | 16.33 | 16.35 | 4500.0 |
| 2004-10-19 | EWO | ETF | 18.49 | 18.53 | 18.4 | 18.45 | 43000.0 |
| 2004-10-19 | EWP | ETF | 30.19 | 30.28 | 30.0 | 30.0 | 5800.0 |
| 2004-10-19 | EWQ | ETF | 21.59 | 21.64 | 21.53 | 21.58 | 2300.0 |
| 2004-10-19 | EWS | ETF | 13.54 | 13.68 | 13.52 | 13.52 | 50600.0 |
| 2004-10-19 | EWT | ETF | 21.42 | 21.5 | 21.2 | 21.28 | 334300.0 |
| 2004-10-19 | EWU | ETF | 33.08 | 33.32 | 32.96 | 32.98 | 49700.0 |
| 2004-10-19 | EWW | ETF | 20.62 | 20.81 | 20.52 | 20.52 | 162900.0 |
| 2004-10-19 | EWY | ETF | 25.4 | 25.64 | 25.3 | 25.38 | 128200.0 |
| 2004-10-19 | EWZ | ETF | 18.82 | 18.98 | 18.23 | 18.33 | 315500.0 |
| 2004-10-19 | EZA | ETF | 33.07 | 33.085 | 32.92 | 33.02 | 40400.0 |
| 2004-10-19 | EZU | ETF | 32.09 | 32.12 | 31.75 | 31.87 | 86000.0 |
| 2004-10-19 | FCTR | ETF | 26.1 | 26.1 | 25.4 | 25.58 | 36590.0 |
| 2004-10-19 | FEZ | ETF | 35.15 | 35.23 | 34.93 | 34.93 | 80700.0 |
| 2004-10-19 | FMAR | ETF | 17.05 | 17.05 | 17.05 | 17.05 | 1100.0 |
| 2004-10-19 | FVD | ETF | 14.55 | 14.55 | 14.41 | 14.44 | 77700.0 |
| 2004-10-19 | FXI | ETF | 17.4633 | 17.4867 | 17.3367 | 17.3533 | 475200.0 |
| 2004-10-19 | GLDB | ETF | 14.17 | 14.17 | 13.97 | 14.09 | 253032.0 |
> showing 50 of 168 rows — these rows as CSV