PREVIEW / etf_daily / 2004-01-27
file: by_date/etf_daily/2004/2004-01-27.parquet size: 10 KB rows: 141
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-01-27 | SPY | ETF | 115.75 | 116.5 | 114.65 | 114.68 | 35322800.0 |
| 2004-01-27 | QQQ | ETF | 38.51 | 38.63 | 37.69 | 37.74 | 97365800.0 |
| 2004-01-27 | IWM | ETF | 59.91 | 59.95 | 59.145 | 59.2 | 6646800.0 |
| 2004-01-27 | DIA | ETF | 107.17 | 107.22 | 106.25 | 106.29 | 5658700.0 |
| 2004-01-27 | TLT | ETF | 86.73 | 87.4 | 86.73 | 87.39 | 576100.0 |
| 2004-01-27 | AAA | ETF | 59.0 | 59.76 | 59.0 | 59.74 | 2800.0 |
| 2004-01-27 | ADRE | ETF | 77.74 | 77.74 | 77.59 | 77.59 | 2584.0 |
| 2004-01-27 | AGG | ETF | 102.88 | 103.15 | 102.8 | 102.85 | 20200.0 |
| 2004-01-27 | ARB | ETF | 45.0 | 45.9 | 44.3 | 44.8 | 320500.0 |
| 2004-01-27 | BBH | ETF | 47.6867 | 47.7 | 46.9433 | 47.0667 | 1834800.0 |
| 2004-01-27 | BITS | ETF | 14.04 | 14.32 | 13.6 | 13.76 | 1888.0 |
| 2004-01-27 | BNE | ETF | 14.58 | 14.73 | 14.45 | 14.63 | 92000.0 |
| 2004-01-27 | CEF | ETF | 5.31 | 5.42 | 5.27 | 5.42 | 375400.0 |
| 2004-01-27 | CHB | ETF | 7.16 | 7.24 | 6.9 | 7.16 | 187100.0 |
| 2004-01-27 | CNXT | ETF | 7.05 | 7.09 | 6.7003 | 6.7202 | 9612690.0 |
| 2004-01-27 | DGT | ETF | 63.5 | 63.5 | 62.9 | 62.98 | 7000.0 |
| 2004-01-27 | DVY | ETF | 55.3 | 55.31 | 55.06 | 55.09 | 772300.0 |
| 2004-01-27 | EEM | ETF | 19.3889 | 19.4478 | 19.2222 | 19.2522 | 2822400.0 |
| 2004-01-27 | EFA | ETF | 47.0567 | 47.0567 | 46.7133 | 46.7667 | 1978500.0 |
| 2004-01-27 | ELV | ETF | 39.935 | 39.945 | 39.1 | 39.25 | 1219500.0 |
| 2004-01-27 | EPP | ETF | 25.7167 | 25.8167 | 25.7167 | 25.7667 | 135900.0 |
| 2004-01-27 | EWA | ETF | 13.7 | 13.74 | 13.64 | 13.73 | 86800.0 |
| 2004-01-27 | EWC | ETF | 14.75 | 14.76 | 14.6 | 14.65 | 411700.0 |
| 2004-01-27 | EWD | ETF | 16.59 | 16.59 | 16.41 | 16.45 | 27000.0 |
| 2004-01-27 | EWG | ETF | 16.96 | 17.0 | 16.85 | 16.9 | 108400.0 |
| 2004-01-27 | EWH | ETF | 11.48 | 11.48 | 11.34 | 11.37 | 659900.0 |
| 2004-01-27 | EWI | ETF | 41.78 | 42.0 | 41.78 | 41.8 | 3350.0 |
| 2004-01-27 | EWJ | ETF | 39.56 | 39.56 | 39.12 | 39.16 | 1574150.0 |
| 2004-01-27 | EWK | ETF | 13.9 | 14.0 | 13.9 | 13.96 | 2000.0 |
| 2004-01-27 | EWL | ETF | 15.45 | 15.49 | 15.32 | 15.39 | 23100.0 |
| 2004-01-27 | EWM | ETF | 27.28 | 27.28 | 27.0 | 27.16 | 181950.0 |
| 2004-01-27 | EWN | ETF | 16.8 | 16.97 | 16.8 | 16.92 | 5800.0 |
| 2004-01-27 | EWO | ETF | 14.85 | 15.07 | 14.8 | 14.94 | 27100.0 |
| 2004-01-27 | EWP | ETF | 29.23 | 29.23 | 28.96 | 28.96 | 7600.0 |
| 2004-01-27 | EWQ | ETF | 21.23 | 21.29 | 21.17 | 21.29 | 13300.0 |
| 2004-01-27 | EWS | ETF | 13.16 | 13.16 | 12.84 | 12.98 | 80750.0 |
| 2004-01-27 | EWT | ETF | 24.78 | 24.78 | 24.12 | 24.3 | 573600.0 |
| 2004-01-27 | EWU | ETF | 31.4 | 31.44 | 31.0 | 31.34 | 43900.0 |
| 2004-01-27 | EWW | ETF | 19.12 | 19.17 | 19.01 | 19.01 | 40500.0 |
| 2004-01-27 | EWY | ETF | 27.34 | 27.43 | 26.61 | 26.79 | 310400.0 |
| 2004-01-27 | EWZ | ETF | 18.0 | 18.04 | 17.73 | 17.91 | 860600.0 |
| 2004-01-27 | EZA | ETF | 28.025 | 28.35 | 28.025 | 28.35 | 11400.0 |
| 2004-01-27 | EZU | ETF | 32.095 | 32.175 | 32.0 | 32.025 | 113000.0 |
| 2004-01-27 | FCTR | ETF | 20.48 | 20.71 | 20.01 | 20.68 | 48165.0 |
| 2004-01-27 | FEZ | ETF | 36.58 | 36.59 | 36.44 | 36.48 | 9000.0 |
| 2004-01-27 | FMAR | ETF | 18.545 | 18.645 | 18.495 | 18.545 | 44940.0 |
| 2004-01-27 | FVD | ETF | 14.65 | 14.69 | 14.5 | 14.56 | 239900.0 |
| 2004-01-27 | GLDB | ETF | 14.36 | 14.49 | 14.17 | 14.17 | 123951.0 |
| 2004-01-27 | GRNB | ETF | 22.9708 | 23.5205 | 22.9708 | 22.9806 | 707.0 |
| 2004-01-27 | GSIG | ETF | 12.55 | 12.7 | 12.2 | 12.34 | 33600.0 |
> showing 50 of 141 rows — these rows as CSV