PREVIEW / etf_daily / 2004-11-19
file: by_date/etf_daily/2004/2004-11-19.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-19 | SPY | ETF | 118.7 | 118.72 | 117.14 | 117.42 | 54276500.0 |
| 2004-11-19 | QQQ | ETF | 39.24 | 39.29 | 38.59 | 38.68 | 118573900.0 |
| 2004-11-19 | IWM | ETF | 61.94 | 61.975 | 61.06 | 61.3 | 11445000.0 |
| 2004-11-19 | DIA | ETF | 105.66 | 105.7 | 104.29 | 104.57 | 6968500.0 |
| 2004-11-19 | GLD | ETF | 44.49 | 44.92 | 44.47 | 44.78 | 11655300.0 |
| 2004-11-19 | TLT | ETF | 88.9 | 89.03 | 88.09 | 88.26 | 1244500.0 |
| 2004-11-19 | AAA | ETF | 54.6 | 54.6 | 54.15 | 54.15 | 3300.0 |
| 2004-11-19 | ADRE | ETF | 80.6 | 80.6 | 78.441 | 78.55 | 7772.0 |
| 2004-11-19 | AGG | ETF | 102.58 | 102.7 | 102.35 | 102.53 | 43500.0 |
| 2004-11-19 | ARB | ETF | 37.45 | 37.45 | 36.36 | 36.39 | 219500.0 |
| 2004-11-19 | BBH | ETF | 46.9167 | 46.9167 | 46.37 | 46.6733 | 2751300.0 |
| 2004-11-19 | BITS | ETF | 7.32 | 7.32 | 7.004 | 7.16 | 1475.0 |
| 2004-11-19 | BNE | ETF | 14.0 | 14.91 | 13.99 | 14.84 | 984400.0 |
| 2004-11-19 | CEF | ETF | 5.74 | 5.78 | 5.67 | 5.68 | 1117600.0 |
| 2004-11-19 | CHB | ETF | 11.6 | 11.65 | 11.11 | 11.27 | 355100.0 |
| 2004-11-19 | CNXT | ETF | 2.18 | 2.23 | 2.03 | 2.12 | 22677110.0 |
| 2004-11-19 | CSB | ETF | 35.0 | 35.5 | 35.0 | 35.5 | 43200.0 |
| 2004-11-19 | DGT | ETF | 63.78 | 63.78 | 63.0 | 63.12 | 18100.0 |
| 2004-11-19 | DVY | ETF | 60.82 | 60.97 | 60.31 | 60.46 | 682400.0 |
| 2004-11-19 | EEM | ETF | 21.3389 | 21.3444 | 21.0667 | 21.0667 | 1489500.0 |
| 2004-11-19 | EFA | ETF | 51.7133 | 51.7167 | 51.0267 | 51.15 | 2092800.0 |
| 2004-11-19 | ELV | ETF | 48.805 | 48.85 | 48.205 | 48.41 | 1966500.0 |
| 2004-11-19 | EPP | ETF | 29.7167 | 29.7433 | 29.4667 | 29.4667 | 188100.0 |
| 2004-11-19 | EWA | ETF | 16.53 | 16.66 | 16.47 | 16.52 | 286500.0 |
| 2004-11-19 | EWC | ETF | 16.76 | 16.98 | 16.76 | 16.92 | 334900.0 |
| 2004-11-19 | EWD | ETF | 20.5 | 20.57 | 20.1 | 20.11 | 44100.0 |
| 2004-11-19 | EWG | ETF | 17.7 | 17.7 | 17.37 | 17.45 | 61400.0 |
| 2004-11-19 | EWH | ETF | 11.76 | 11.8 | 11.6 | 11.65 | 345300.0 |
| 2004-11-19 | EWI | ETF | 48.44 | 48.52 | 47.92 | 48.1 | 15400.0 |
| 2004-11-19 | EWJ | ETF | 41.84 | 41.96 | 41.2 | 41.24 | 2536125.0 |
| 2004-11-19 | EWK | ETF | 17.62 | 17.67 | 17.51 | 17.63 | 39200.0 |
| 2004-11-19 | EWL | ETF | 16.74 | 16.86 | 16.62 | 16.74 | 45700.0 |
| 2004-11-19 | EWM | ETF | 28.96 | 28.96 | 28.56 | 28.72 | 41575.0 |
| 2004-11-19 | EWN | ETF | 17.79 | 17.83 | 17.61 | 17.7 | 12400.0 |
| 2004-11-19 | EWO | ETF | 20.85 | 20.9 | 20.57 | 20.84 | 132600.0 |
| 2004-11-19 | EWP | ETF | 32.86 | 33.01 | 32.79 | 32.81 | 27900.0 |
| 2004-11-19 | EWQ | ETF | 23.14 | 23.14 | 22.96 | 22.96 | 8400.0 |
| 2004-11-19 | EWS | ETF | 14.4 | 14.4 | 14.12 | 14.16 | 99250.0 |
| 2004-11-19 | EWT | ETF | 23.64 | 23.66 | 23.14 | 23.24 | 311600.0 |
| 2004-11-19 | EWU | ETF | 35.12 | 35.32 | 34.82 | 34.88 | 98900.0 |
| 2004-11-19 | EWW | ETF | 22.85 | 22.85 | 22.29 | 22.29 | 485300.0 |
| 2004-11-19 | EWY | ETF | 27.75 | 27.79 | 27.38 | 27.44 | 484000.0 |
| 2004-11-19 | EWZ | ETF | 19.74 | 19.76 | 19.44 | 19.65 | 786500.0 |
| 2004-11-19 | EZA | ETF | 36.55 | 36.575 | 36.45 | 36.5 | 52000.0 |
| 2004-11-19 | EZU | ETF | 34.995 | 34.995 | 34.5 | 34.595 | 82800.0 |
| 2004-11-19 | FCTR | ETF | 26.15 | 26.66 | 25.75 | 25.75 | 28743.0 |
| 2004-11-19 | FEZ | ETF | 38.24 | 38.24 | 37.66 | 37.66 | 48300.0 |
| 2004-11-19 | FMAR | ETF | 17.16 | 17.39 | 17.16 | 17.29 | 2710.0 |
| 2004-11-19 | FVD | ETF | 15.2 | 15.2 | 15.0 | 15.05 | 199400.0 |
| 2004-11-19 | FXI | ETF | 18.3033 | 18.3167 | 18.1067 | 18.1367 | 1370700.0 |
> showing 50 of 169 rows — these rows as CSV