PREVIEW / etf_daily / 2005-07-05
file: by_date/etf_daily/2005/2005-07-05.parquet size: 15 KB rows: 275
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-07-05 | SPY | ETF | 119.25 | 120.65 | 119.19 | 120.49 | 51549000.0 |
| 2005-07-05 | QQQ | ETF | 36.63 | 37.19 | 36.6 | 37.11 | 79288691.0 |
| 2005-07-05 | IWM | ETF | 63.81 | 65.05 | 63.76 | 64.99 | 27172600.0 |
| 2005-07-05 | DIA | ETF | 102.85 | 103.87 | 102.8 | 103.63 | 4745900.0 |
| 2005-07-05 | GLD | ETF | 42.34 | 42.34 | 42.06 | 42.28 | 2582700.0 |
| 2005-07-05 | TLT | ETF | 94.35 | 94.74 | 94.27 | 94.3 | 1076100.0 |
| 2005-07-05 | AAA | ETF | 49.47 | 50.1 | 49.4 | 49.98 | 82100.0 |
| 2005-07-05 | ADRE | ETF | 92.75 | 92.75 | 91.17 | 91.8 | 5280.0 |
| 2005-07-05 | AFK | ETF | 26.2 | 26.2 | 26.01 | 26.1 | 12000.0 |
| 2005-07-05 | AGG | ETF | 102.34 | 102.5 | 102.18 | 102.3 | 141600.0 |
| 2005-07-05 | AIQ | ETF | 51.45 | 53.95 | 51.45 | 53.75 | 12940.0 |
| 2005-07-05 | AIS | ETF | 1.09 | 1.11 | 1.02 | 1.1 | 102200.0 |
| 2005-07-05 | ARB | ETF | 43.59 | 43.78 | 43.35 | 43.67 | 185700.0 |
| 2005-07-05 | BAB | ETF | 47.89 | 48.23 | 47.642 | 48.1 | 38400.0 |
| 2005-07-05 | BBH | ETF | 55.86 | 56.7433 | 55.86 | 56.71 | 837600.0 |
| 2005-07-05 | BCM | ETF | 60.94 | 61.7 | 60.81 | 61.45 | 11200.0 |
| 2005-07-05 | BITS | ETF | 15.64 | 15.64 | 15.04 | 15.44 | 5659.0 |
| 2005-07-05 | BKF | ETF | 37.7 | 37.98 | 37.55 | 37.98 | 14200.0 |
| 2005-07-05 | BNE | ETF | 14.25 | 14.31 | 14.1 | 14.2 | 336700.0 |
| 2005-07-05 | BRF | ETF | 15.46 | 15.64 | 15.46 | 15.58 | 9100.0 |
| 2005-07-05 | BTF | ETF | 85.05 | 85.99999999999999 | 85.05 | 85.99999999999999 | 2300.0 |
| 2005-07-05 | CBON | ETF | 30.73 | 32.34 | 30.73 | 32.16 | 19742.0 |
| 2005-07-05 | CDC | ETF | 6.99 | 7.2 | 6.99 | 7.0 | 3500.0 |
| 2005-07-05 | CDL | ETF | 11.72 | 11.95 | 11.2 | 11.88 | 398200.0 |
| 2005-07-05 | CEF | ETF | 5.2 | 5.24 | 5.16 | 5.2 | 285200.0 |
| 2005-07-05 | CEW | ETF | 26.9 | 26.9 | 26.9 | 26.9 | 100.0 |
| 2005-07-05 | CHB | ETF | 9.91 | 10.13 | 9.91 | 10.12 | 215000.0 |
| 2005-07-05 | CHI | ETF | 19.62 | 19.8 | 19.62 | 19.79 | 51500.0 |
| 2005-07-05 | CHIC | ETF | 12.59 | 12.97 | 12.55 | 12.85 | 147927.0 |
| 2005-07-05 | CHIR | ETF | 34.9101 | 35.8401 | 34.5399 | 35.7399 | 921617.0 |
| 2005-07-05 | CHY | ETF | 16.5 | 16.64 | 16.47 | 16.58 | 138000.0 |
| 2005-07-05 | CIL | ETF | 25.65 | 25.65 | 25.65 | 25.65 | 400.0 |
| 2005-07-05 | CN | ETF | 29.76 | 30.2 | 29.76 | 30.0 | 84000.0 |
| 2005-07-05 | CNXT | ETF | 1.67 | 1.72 | 1.62 | 1.68 | 6653429.0 |
| 2005-07-05 | CPI | ETF | 23.75 | 23.75 | 23.75 | 23.75 | 100.0 |
| 2005-07-05 | CPST | ETF | 1.32 | 1.37 | 1.3 | 1.36 | 418507.0 |
| 2005-07-05 | CSB | ETF | 28.35 | 28.66 | 28.35 | 28.5 | 8300.0 |
| 2005-07-05 | CSM | ETF | 2.4025 | 2.4025 | 2.4025 | 2.4025 | 2000.0 |
| 2005-07-05 | CSQ | ETF | 13.95 | 13.95 | 13.89 | 13.92 | 209500.0 |
| 2005-07-05 | CTEC | ETF | 56.050000000000004 | 56.25 | 55.55 | 55.65 | 3871.2000000000003 |
| 2005-07-05 | CURE | ETF | 0.2875 | 0.2975 | 0.2825 | 0.2913 | 593016.0 |
| 2005-07-05 | CYA | ETF | 142.0 | 143.8 | 138.0 | 138.0 | 430.0 |
| 2005-07-05 | CYB | ETF | 3.15 | 3.15 | 3.09 | 3.09 | 4700.0 |
| 2005-07-05 | DGT | ETF | 63.0 | 63.55 | 63.0 | 63.55 | 1600.0 |
| 2005-07-05 | DIG | ETF | 12.5125 | 12.5125 | 12.5 | 12.5 | 8800.0 |
| 2005-07-05 | DIV | ETF | 13.9 | 13.9 | 13.76 | 13.86 | 11600.0 |
| 2005-07-05 | DRIV | ETF | 31.81 | 32.35 | 31.53 | 32.16 | 523001.0 |
| 2005-07-05 | DSI | ETF | 5.735 | 5.775 | 5.735 | 5.775 | 5200.0 |
| 2005-07-05 | DUSA | ETF | 9.17 | 9.55 | 9.09 | 9.54 | 74603.0 |
| 2005-07-05 | DVY | ETF | 62.17 | 62.61 | 62.0 | 62.56 | 305600.0 |
> showing 50 of 275 rows — these rows as CSV