PREVIEW / etf_daily / 2005-05-02
file: by_date/etf_daily/2005/2005-05-02.parquet size: 14 KB rows: 259
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-02 | SPY | ETF | 116.07 | 116.41 | 115.52 | 116.4 | 56026400.0 |
| 2005-05-02 | QQQ | ETF | 35.1 | 35.2636 | 34.886 | 35.12 | 68205394.0 |
| 2005-05-02 | IWM | ETF | 57.78 | 58.24 | 57.535 | 58.21 | 25063400.0 |
| 2005-05-02 | DIA | ETF | 102.24 | 102.6 | 101.86 | 102.58 | 5349200.0 |
| 2005-05-02 | GLD | ETF | 43.13 | 43.17 | 42.81 | 42.88 | 1707400.0 |
| 2005-05-02 | TLT | ETF | 92.15 | 92.26 | 91.71 | 92.09 | 1358200.0 |
| 2005-05-02 | AAA | ETF | 62.45 | 62.55 | 61.79 | 61.89 | 23400.0 |
| 2005-05-02 | ADRE | ETF | 82.95 | 82.95 | 81.96 | 82.47 | 5224.0 |
| 2005-05-02 | AFK | ETF | 25.85 | 26.27 | 25.85 | 26.27 | 11100.0 |
| 2005-05-02 | AGG | ETF | 102.09 | 102.1 | 101.85 | 101.99 | 54800.0 |
| 2005-05-02 | AIQ | ETF | 55.0 | 55.45 | 54.0 | 54.5 | 50620.0 |
| 2005-05-02 | ARB | ETF | 42.0 | 42.87 | 42.0 | 42.8 | 266600.0 |
| 2005-05-02 | BAB | ETF | 45.73 | 46.09 | 45.59 | 46.0 | 43200.0 |
| 2005-05-02 | BBH | ETF | 51.85 | 51.97 | 51.63 | 51.8267 | 1334700.0 |
| 2005-05-02 | BCM | ETF | 59.56 | 60.19 | 59.55 | 59.86 | 20400.0 |
| 2005-05-02 | BITS | ETF | 10.64 | 10.8 | 10.0 | 10.36 | 11787.0 |
| 2005-05-02 | BKF | ETF | 33.56 | 35.47 | 33.56 | 34.24 | 65300.0 |
| 2005-05-02 | BNE | ETF | 13.05 | 13.12 | 12.71 | 13.07 | 468300.0 |
| 2005-05-02 | BOSS | ETF | 23.0 | 23.0 | 23.0 | 23.0 | 200.0 |
| 2005-05-02 | BRF | ETF | 15.37 | 15.5 | 15.37 | 15.49 | 11000.0 |
| 2005-05-02 | BTF | ETF | 84.39999999999999 | 84.7 | 84.39999999999999 | 84.55 | 2380.0 |
| 2005-05-02 | CBON | ETF | 23.85 | 24.29 | 23.85 | 24.0 | 6095.0 |
| 2005-05-02 | CDC | ETF | 6.7 | 7.59 | 6.7 | 7.59 | 5100.0 |
| 2005-05-02 | CDL | ETF | 12.65 | 12.72 | 12.45 | 12.55 | 269200.0 |
| 2005-05-02 | CEF | ETF | 5.35 | 5.36 | 5.25 | 5.35 | 319400.0 |
| 2005-05-02 | CEW | ETF | 26.25 | 26.26 | 26.25 | 26.25 | 1100.0 |
| 2005-05-02 | CGW | ETF | 27.3 | 27.69 | 27.3 | 27.64 | 44800.0 |
| 2005-05-02 | CHB | ETF | 9.46 | 9.72 | 9.38 | 9.63 | 339600.0 |
| 2005-05-02 | CHIC | ETF | 10.66 | 10.86 | 10.31 | 10.44 | 226352.0 |
| 2005-05-02 | CHIR | ETF | 34.2099 | 34.4799 | 34.0599 | 34.4301 | 1063459.0 |
| 2005-05-02 | CIL | ETF | 26.26 | 26.26 | 26.17 | 26.17 | 2600.0 |
| 2005-05-02 | CIZ | ETF | 20.6 | 20.8 | 20.6 | 20.8 | 800.0 |
| 2005-05-02 | CN | ETF | 26.85 | 26.99 | 26.8 | 26.99 | 20600.0 |
| 2005-05-02 | CNXT | ETF | 1.14 | 1.15 | 1.09 | 1.11 | 6841637.0 |
| 2005-05-02 | CPI | ETF | 18.85 | 22.2 | 18.85 | 22.0 | 21500.0 |
| 2005-05-02 | CSB | ETF | 31.5 | 31.7 | 31.41 | 31.54 | 4800.0 |
| 2005-05-02 | CTEC | ETF | 52.0 | 54.05 | 51.5 | 53.49999999999999 | 11800.0 |
| 2005-05-02 | CURE | ETF | 0.2087 | 0.26 | 0.1975 | 0.2537 | 7517656.0 |
| 2005-05-02 | CYA | ETF | 144.8 | 150.0 | 144.8 | 150.0 | 450.0 |
| 2005-05-02 | CYB | ETF | 3.5 | 3.59 | 3.4 | 3.53 | 3900.0 |
| 2005-05-02 | DGT | ETF | 62.88 | 63.03 | 62.82 | 62.94 | 56500.0 |
| 2005-05-02 | DIG | ETF | 11.0875 | 11.0875 | 11.0625 | 11.0625 | 1840.0 |
| 2005-05-02 | DIV | ETF | 12.99 | 13.2 | 12.99 | 13.0 | 64300.0 |
| 2005-05-02 | DRIV | ETF | 26.8 | 26.91 | 25.56 | 26.21 | 1123883.0 |
| 2005-05-02 | DUSA | ETF | 10.45 | 10.49 | 10.12 | 10.37 | 66380.0 |
| 2005-05-02 | DVY | ETF | 59.61 | 60.05 | 59.55 | 60.05 | 332000.0 |
| 2005-05-02 | EDEN | ETF | 0.7 | 0.78 | 0.7 | 0.7 | 37652.0 |
| 2005-05-02 | EDV | ETF | 26.07 | 26.22 | 26.07 | 26.19 | 13900.0 |
| 2005-05-02 | EEM | ETF | 22.3611 | 22.6667 | 22.2222 | 22.4 | 8076600.0 |
| 2005-05-02 | EFA | ETF | 52.0167 | 52.16 | 51.9167 | 52.0833 | 6243000.0 |
> showing 50 of 259 rows — these rows as CSV