PREVIEW / etf_daily / 2004-12-21
file: by_date/etf_daily/2004/2004-12-21.parquet size: 11 KB rows: 171
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-21 | SPY | ETF | 119.6 | 120.48 | 119.46 | 120.39 | 33094200.0 |
| 2004-12-21 | QQQ | ETF | 39.39 | 39.71 | 39.278 | 39.68 | 83240677.0 |
| 2004-12-21 | IWM | ETF | 63.95 | 64.53 | 63.805 | 64.505 | 9142200.0 |
| 2004-12-21 | DIA | ETF | 106.75 | 107.47 | 106.61 | 107.42 | 8002500.0 |
| 2004-12-21 | GLD | ETF | 44.13 | 44.24 | 44.05 | 44.22 | 1373400.0 |
| 2004-12-21 | TLT | ETF | 89.06 | 89.24 | 88.9 | 89.18 | 245200.0 |
| 2004-12-21 | AAA | ETF | 58.21 | 58.54 | 57.9 | 58.5 | 7700.0 |
| 2004-12-21 | ADRE | ETF | 80.2 | 81.84 | 80.2 | 81.84 | 2272.0 |
| 2004-12-21 | AGG | ETF | 102.6 | 102.8 | 102.5 | 102.55 | 83100.0 |
| 2004-12-21 | ARB | ETF | 37.5 | 38.51 | 37.5 | 38.51 | 118500.0 |
| 2004-12-21 | BBH | ETF | 49.3267 | 49.72 | 49.2867 | 49.6333 | 1697700.0 |
| 2004-12-21 | BITS | ETF | 13.24 | 13.8 | 12.96 | 13.12 | 31036.0 |
| 2004-12-21 | BNE | ETF | 15.5 | 15.76 | 15.43 | 15.74 | 709800.0 |
| 2004-12-21 | CEF | ETF | 5.44 | 5.44 | 5.33 | 5.36 | 882800.0 |
| 2004-12-21 | CHB | ETF | 11.8 | 12.05 | 11.79 | 12.05 | 262600.0 |
| 2004-12-21 | CNXT | ETF | 1.96 | 2.07 | 1.9202 | 2.01 | 11342150.0 |
| 2004-12-21 | CSB | ETF | 33.0 | 33.75 | 33.0 | 33.75 | 6600.0 |
| 2004-12-21 | DGT | ETF | 63.51 | 63.84 | 63.49 | 63.84 | 4200.0 |
| 2004-12-21 | DVY | ETF | 61.19 | 61.56 | 61.0 | 61.56 | 617200.0 |
| 2004-12-21 | EEM | ETF | 22.0556 | 22.2078 | 21.9444 | 22.2056 | 2205900.0 |
| 2004-12-21 | EFA | ETF | 52.7467 | 52.98 | 52.4167 | 52.98 | 5990100.0 |
| 2004-12-21 | ELV | ETF | 57.425 | 58.4 | 56.875 | 58.4 | 2215000.0 |
| 2004-12-21 | EPP | ETF | 30.1833 | 30.4133 | 30.1833 | 30.41 | 568200.0 |
| 2004-12-21 | EWA | ETF | 16.83 | 16.83 | 16.66 | 16.75 | 532200.0 |
| 2004-12-21 | EWC | ETF | 16.86 | 16.98 | 16.81 | 16.93 | 149000.0 |
| 2004-12-21 | EWD | ETF | 20.85 | 20.89 | 20.75 | 20.88 | 62200.0 |
| 2004-12-21 | EWG | ETF | 18.41 | 18.45 | 18.3 | 18.41 | 143100.0 |
| 2004-12-21 | EWH | ETF | 12.26 | 12.3 | 12.18 | 12.28 | 355900.0 |
| 2004-12-21 | EWI | ETF | 51.22 | 51.5 | 51.1 | 51.48 | 38550.0 |
| 2004-12-21 | EWJ | ETF | 41.64 | 42.0 | 41.6 | 42.0 | 1501250.0 |
| 2004-12-21 | EWK | ETF | 18.59 | 18.59 | 18.39 | 18.56 | 37900.0 |
| 2004-12-21 | EWL | ETF | 16.85 | 16.98 | 16.73 | 16.98 | 58500.0 |
| 2004-12-21 | EWM | ETF | 29.0 | 29.16 | 28.64 | 28.8 | 99100.0 |
| 2004-12-21 | EWN | ETF | 18.3 | 18.36 | 18.15 | 18.34 | 16100.0 |
| 2004-12-21 | EWO | ETF | 22.65 | 22.75 | 22.54 | 22.75 | 158500.0 |
| 2004-12-21 | EWP | ETF | 34.95 | 35.0 | 34.88 | 35.0 | 61500.0 |
| 2004-12-21 | EWQ | ETF | 23.56 | 23.64 | 23.51 | 23.58 | 17300.0 |
| 2004-12-21 | EWS | ETF | 14.72 | 14.74 | 14.58 | 14.72 | 88350.0 |
| 2004-12-21 | EWT | ETF | 23.16 | 23.5 | 23.16 | 23.5 | 267600.0 |
| 2004-12-21 | EWU | ETF | 36.46 | 36.46 | 36.18 | 36.4 | 139500.0 |
| 2004-12-21 | EWW | ETF | 24.3 | 24.61 | 24.27 | 24.61 | 204000.0 |
| 2004-12-21 | EWY | ETF | 28.37 | 28.39 | 28.16 | 28.3 | 251500.0 |
| 2004-12-21 | EWZ | ETF | 21.61 | 22.0 | 21.6 | 21.99 | 399300.0 |
| 2004-12-21 | EZA | ETF | 39.25 | 39.665 | 39.175 | 39.61 | 70600.0 |
| 2004-12-21 | EZU | ETF | 36.07 | 36.17 | 35.9 | 36.0 | 83800.0 |
| 2004-12-21 | FCTR | ETF | 26.5 | 26.86 | 26.3 | 26.86 | 54664.0 |
| 2004-12-21 | FEZ | ETF | 39.14 | 39.27 | 38.91 | 39.21 | 100100.0 |
| 2004-12-21 | FMAR | ETF | 17.505 | 17.505 | 17.335 | 17.485 | 6560.0 |
| 2004-12-21 | FVD | ETF | 14.69 | 14.7 | 14.58 | 14.68 | 132000.0 |
| 2004-12-21 | FXI | ETF | 18.5933 | 18.6 | 18.5233 | 18.6 | 841800.0 |
> showing 50 of 171 rows — these rows as CSV