PREVIEW / etf_daily / 2004-11-18
file: by_date/etf_daily/2004/2004-11-18.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-11-18 | SPY | ETF | 118.53 | 118.8 | 118.23 | 118.74 | 31854300.0 |
| 2004-11-18 | QQQ | ETF | 38.98 | 39.36 | 38.887 | 39.29 | 95009100.0 |
| 2004-11-18 | IWM | ETF | 62.07 | 62.195 | 61.63 | 61.96 | 12526000.0 |
| 2004-11-18 | DIA | ETF | 105.92 | 106.1 | 105.73 | 106.0 | 4714100.0 |
| 2004-11-18 | GLD | ETF | 44.43 | 44.49 | 44.07 | 44.38 | 5940200.0 |
| 2004-11-18 | TLT | ETF | 88.55 | 89.06 | 88.41 | 88.97 | 891500.0 |
| 2004-11-18 | AAA | ETF | 55.0 | 55.0 | 54.74 | 54.74 | 300.0 |
| 2004-11-18 | ADRE | ETF | 80.63 | 80.63 | 79.29 | 79.56 | 7984.0 |
| 2004-11-18 | AGG | ETF | 102.74 | 102.89 | 102.47 | 102.74 | 50300.0 |
| 2004-11-18 | ARB | ETF | 37.7 | 37.85 | 36.8 | 37.2 | 208900.0 |
| 2004-11-18 | BBH | ETF | 47.5 | 47.75 | 47.22 | 47.4 | 2826300.0 |
| 2004-11-18 | BITS | ETF | 6.44 | 7.16 | 6.44 | 6.8 | 3385.0 |
| 2004-11-18 | BNE | ETF | 14.1 | 14.26 | 14.05 | 14.12 | 228900.0 |
| 2004-11-18 | CEF | ETF | 5.87 | 5.87 | 5.67 | 5.71 | 990900.0 |
| 2004-11-18 | CHB | ETF | 11.8 | 11.8 | 11.45 | 11.59 | 400800.0 |
| 2004-11-18 | CNXT | ETF | 1.8114 | 2.1 | 1.8114 | 2.1 | 30423280.0 |
| 2004-11-18 | CSB | ETF | 34.0 | 36.0 | 34.0 | 35.0 | 17500.0 |
| 2004-11-18 | DGT | ETF | 63.81 | 63.83 | 63.62 | 63.74 | 20700.0 |
| 2004-11-18 | DVY | ETF | 61.1 | 61.21 | 60.83 | 61.0 | 543700.0 |
| 2004-11-18 | EEM | ETF | 21.2078 | 21.5122 | 21.2078 | 21.3722 | 1527300.0 |
| 2004-11-18 | EFA | ETF | 51.48 | 51.5367 | 51.2933 | 51.4833 | 1743600.0 |
| 2004-11-18 | ELV | ETF | 48.225 | 48.925 | 48.175 | 48.8 | 1823500.0 |
| 2004-11-18 | EPP | ETF | 29.5833 | 29.5833 | 29.4567 | 29.5133 | 262800.0 |
| 2004-11-18 | EWA | ETF | 16.55 | 16.58 | 16.43 | 16.53 | 296600.0 |
| 2004-11-18 | EWC | ETF | 16.82 | 16.9 | 16.76 | 16.78 | 188200.0 |
| 2004-11-18 | EWD | ETF | 20.42 | 20.45 | 20.23 | 20.29 | 20400.0 |
| 2004-11-18 | EWG | ETF | 17.5 | 17.6 | 17.5 | 17.56 | 44200.0 |
| 2004-11-18 | EWH | ETF | 11.8 | 11.87 | 11.77 | 11.81 | 264600.0 |
| 2004-11-18 | EWI | ETF | 47.86 | 48.12 | 47.84 | 48.12 | 5150.0 |
| 2004-11-18 | EWJ | ETF | 41.56 | 41.72 | 41.32 | 41.68 | 1409925.0 |
| 2004-11-18 | EWK | ETF | 17.61 | 17.7 | 17.45 | 17.5 | 57000.0 |
| 2004-11-18 | EWL | ETF | 16.73 | 16.88 | 16.53 | 16.71 | 44300.0 |
| 2004-11-18 | EWM | ETF | 28.88 | 29.28 | 28.68 | 29.04 | 103125.0 |
| 2004-11-18 | EWN | ETF | 17.55 | 17.77 | 17.55 | 17.77 | 11500.0 |
| 2004-11-18 | EWO | ETF | 20.62 | 20.8 | 20.58 | 20.78 | 186800.0 |
| 2004-11-18 | EWP | ETF | 32.78 | 32.82 | 32.64 | 32.79 | 16000.0 |
| 2004-11-18 | EWQ | ETF | 23.2 | 23.22 | 23.14 | 23.14 | 8400.0 |
| 2004-11-18 | EWS | ETF | 14.3 | 14.42 | 14.2 | 14.36 | 120050.0 |
| 2004-11-18 | EWT | ETF | 23.78 | 23.8 | 22.94 | 23.76 | 256800.0 |
| 2004-11-18 | EWU | ETF | 35.28 | 35.3 | 35.08 | 35.1 | 102400.0 |
| 2004-11-18 | EWW | ETF | 22.8 | 22.85 | 22.73 | 22.77 | 82700.0 |
| 2004-11-18 | EWY | ETF | 27.85 | 28.08 | 27.8 | 27.98 | 344100.0 |
| 2004-11-18 | EWZ | ETF | 19.92 | 19.92 | 19.51 | 19.79 | 192500.0 |
| 2004-11-18 | EZA | ETF | 36.35 | 36.55 | 36.275 | 36.49 | 45000.0 |
| 2004-11-18 | EZU | ETF | 34.745 | 34.75 | 34.55 | 34.725 | 168800.0 |
| 2004-11-18 | FCTR | ETF | 26.6 | 26.85 | 26.32 | 26.49 | 21088.0 |
| 2004-11-18 | FEZ | ETF | 38.0 | 38.04 | 37.85 | 37.96 | 64300.0 |
| 2004-11-18 | FMAR | ETF | 17.16 | 17.24 | 17.12 | 17.21 | 4150.0 |
| 2004-11-18 | FVD | ETF | 15.07 | 15.21 | 15.07 | 15.18 | 165700.0 |
| 2004-11-18 | FXI | ETF | 18.3833 | 18.4033 | 18.3267 | 18.3767 | 649500.0 |
> showing 50 of 169 rows — these rows as CSV