PREVIEW / etf_daily / 2007-06-11
file: by_date/etf_daily/2007/2007-06-11.parquet size: 22 KB rows: 479
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-11 | SPY | ETF | 150.93 | 151.95 | 150.7 | 151.3 | 102015600.0 |
| 2007-06-11 | QQQ | ETF | 46.89 | 47.19 | 46.76 | 46.82 | 97154490.0 |
| 2007-06-11 | IWM | ETF | 82.74 | 83.27 | 82.33 | 82.87 | 68082100.0 |
| 2007-06-11 | DIA | ETF | 134.07 | 134.75 | 133.77 | 134.24 | 10273100.0 |
| 2007-06-11 | GLD | ETF | 64.34 | 64.87 | 64.34 | 64.7 | 4606600.0 |
| 2007-06-11 | TLT | ETF | 83.49 | 83.89 | 83.26 | 83.56 | 2043800.0 |
| 2007-06-11 | ADRE | ETF | 44.161 | 44.8 | 44.04 | 44.53 | 333748.0 |
| 2007-06-11 | AGG | ETF | 97.58 | 97.89 | 97.57 | 97.78 | 261000.0 |
| 2007-06-11 | AIQ | ETF | 45.75 | 46.5 | 44.9 | 45.45 | 53040.0 |
| 2007-06-11 | AIS | ETF | 1.98 | 1.98 | 1.86 | 1.93 | 212800.0 |
| 2007-06-11 | ARB | ETF | 51.8 | 52.33 | 51.31 | 51.92 | 156900.0 |
| 2007-06-11 | BBH | ETF | 59.7267 | 60.1967 | 59.7 | 59.73 | 353700.0 |
| 2007-06-11 | BIL | ETF | 91.68 | 91.72 | 91.68 | 91.72 | 2400.0 |
| 2007-06-11 | BITS | ETF | 32.08 | 32.52 | 32.08 | 32.36 | 5229.0 |
| 2007-06-11 | BIV | ETF | 73.22 | 73.37 | 73.22 | 73.27 | 4700.0 |
| 2007-06-11 | BLV | ETF | 72.12 | 72.3 | 72.1 | 72.14 | 17100.0 |
| 2007-06-11 | BMVP | ETF | 17.88 | 18.04 | 17.88 | 17.96 | 30900.0 |
| 2007-06-11 | BND | ETF | 73.76 | 73.85 | 73.71 | 73.76 | 77100.0 |
| 2007-06-11 | BNE | ETF | 19.19 | 19.47 | 19.05 | 19.4 | 203700.0 |
| 2007-06-11 | BRF | ETF | 14.49 | 14.5 | 14.49 | 14.5 | 2900.0 |
| 2007-06-11 | BSV | ETF | 74.58 | 74.64 | 74.52 | 74.59 | 64300.0 |
| 2007-06-11 | BTF | ETF | 110.29999999999998 | 111.134 | 109.8 | 110.6 | 2920.0 |
| 2007-06-11 | CBON | ETF | 29.44 | 29.73 | 29.36 | 29.57 | 25031.0 |
| 2007-06-11 | CDL | ETF | 8.35 | 8.42 | 8.29 | 8.39 | 1494000.0 |
| 2007-06-11 | CEF | ETF | 8.99 | 9.17 | 8.9 | 9.07 | 377400.0 |
| 2007-06-11 | CGO | ETF | 17.97 | 18.0 | 17.8 | 17.91 | 43100.0 |
| 2007-06-11 | CGW | ETF | 24.93 | 25.15 | 24.83 | 25.08 | 157600.0 |
| 2007-06-11 | CHB | ETF | 10.35 | 10.36 | 10.01 | 10.1 | 1502600.0 |
| 2007-06-11 | CHI | ETF | 19.9 | 20.2201 | 19.8 | 20.22 | 82400.0 |
| 2007-06-11 | CHIC | ETF | 28.4 | 28.4 | 27.98 | 28.05 | 351776.0 |
| 2007-06-11 | CHY | ETF | 16.51 | 16.85 | 16.51 | 16.8 | 141200.0 |
| 2007-06-11 | CN | ETF | 52.0 | 53.49 | 52.0 | 53.15 | 92609.0 |
| 2007-06-11 | CNXT | ETF | 1.28 | 1.32 | 1.27 | 1.27 | 4973280.0 |
| 2007-06-11 | CPST | ETF | 1.02 | 1.1 | 1.01 | 1.08 | 4697874.0 |
| 2007-06-11 | CSA | ETF | 19.88 | 19.9 | 19.64 | 19.64 | 12200.0 |
| 2007-06-11 | CSB | ETF | 31.58 | 31.91 | 31.46 | 31.85 | 14700.0 |
| 2007-06-11 | CSD | ETF | 30.45 | 30.67 | 30.35 | 30.59 | 26000.0 |
| 2007-06-11 | CSM | ETF | 1.4075 | 1.4075 | 1.4075 | 1.4075 | 400.0 |
| 2007-06-11 | CSQ | ETF | 15.12 | 15.16 | 15.03 | 15.14 | 354700.0 |
| 2007-06-11 | CTEC | ETF | 102.05 | 106.25 | 101.6 | 104.1 | 155650.80000000002 |
| 2007-06-11 | CVY | ETF | 27.73 | 27.99 | 27.73 | 27.9 | 17200.0 |
| 2007-06-11 | CWI | ETF | 26.8067 | 27.04 | 26.7733 | 26.94 | 31200.0 |
| 2007-06-11 | CZA | ETF | 26.86 | 26.93 | 26.86 | 26.89 | 2900.0 |
| 2007-06-11 | DBA | ETF | 26.58 | 27.15 | 26.52 | 26.86 | 265500.0 |
| 2007-06-11 | DBB | ETF | 26.58 | 26.74 | 26.44 | 26.73 | 67600.0 |
| 2007-06-11 | DBC | ETF | 25.74 | 26.03 | 25.56 | 25.98 | 138100.0 |
| 2007-06-11 | DBE | ETF | 28.09 | 28.4 | 27.87 | 28.36 | 17600.0 |
| 2007-06-11 | DBO | ETF | 26.18 | 26.54 | 26.01 | 26.5 | 27300.0 |
| 2007-06-11 | DBP | ETF | 25.77 | 25.89 | 25.65 | 25.8 | 2600.0 |
| 2007-06-11 | DBS | ETF | 25.92 | 26.04 | 25.8 | 26.04 | 5800.0 |
> showing 50 of 479 rows — these rows as CSV