PREVIEW / etf_daily / 2007-06-29
file: by_date/etf_daily/2007/2007-06-29.parquet size: 23 KB rows: 497
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-29 | SPY | ETF | 150.9 | 151.65 | 149.15 | 150.43 | 199701800.0 |
| 2007-06-29 | QQQ | ETF | 47.79 | 47.88 | 47.21 | 47.6 | 124794650.0 |
| 2007-06-29 | IWM | ETF | 83.78 | 84.19 | 82.66 | 82.9 | 110203200.0 |
| 2007-06-29 | DIA | ETF | 134.36 | 135.12 | 132.85 | 134.2 | 19466600.0 |
| 2007-06-29 | GLD | ETF | 64.29 | 64.64 | 64.15 | 64.27 | 2756400.0 |
| 2007-06-29 | TLT | ETF | 84.85 | 85.3 | 84.64 | 85.17 | 1962200.0 |
| 2007-06-29 | ADRE | ETF | 45.55 | 45.73 | 45.06 | 45.23 | 100909.0 |
| 2007-06-29 | AGG | ETF | 98.31 | 98.46 | 98.18 | 98.36 | 506700.0 |
| 2007-06-29 | AIQ | ETF | 47.75 | 48.05 | 46.95 | 46.95 | 53020.0 |
| 2007-06-29 | AIS | ETF | 1.77 | 1.77 | 1.55 | 1.58 | 2472300.0 |
| 2007-06-29 | ARB | ETF | 52.38 | 52.55 | 51.32 | 51.53 | 273400.0 |
| 2007-06-29 | BBH | ETF | 56.4167 | 56.4167 | 55.6667 | 56.0333 | 629700.0 |
| 2007-06-29 | BIL | ETF | 91.96 | 92.0 | 91.94 | 92.0 | 5650.0 |
| 2007-06-29 | BITS | ETF | 28.56 | 29.1596 | 27.56 | 27.64 | 14366.0 |
| 2007-06-29 | BIV | ETF | 73.69 | 73.86 | 73.59 | 73.86 | 58700.0 |
| 2007-06-29 | BLV | ETF | 72.89 | 73.18 | 72.85 | 73.15 | 99100.0 |
| 2007-06-29 | BMVP | ETF | 17.88 | 17.96 | 17.72 | 17.78 | 78200.0 |
| 2007-06-29 | BND | ETF | 74.16 | 74.28 | 74.13 | 74.28 | 389200.0 |
| 2007-06-29 | BNE | ETF | 19.93 | 19.93 | 19.5 | 19.51 | 210200.0 |
| 2007-06-29 | BRF | ETF | 14.49 | 14.53 | 14.49 | 14.49 | 15600.0 |
| 2007-06-29 | BSV | ETF | 74.92 | 74.98 | 74.9 | 74.97 | 28000.0 |
| 2007-06-29 | BTF | ETF | 107.69999999999999 | 107.69999999999999 | 106.69999999999999 | 106.69999999999999 | 520.0 |
| 2007-06-29 | CBON | ETF | 28.21 | 28.69 | 27.79 | 27.79 | 51595.0 |
| 2007-06-29 | CDL | ETF | 6.43 | 6.5 | 6.32 | 6.45 | 5252052.0 |
| 2007-06-29 | CEF | ETF | 9.15 | 9.15 | 9.06 | 9.11 | 137400.0 |
| 2007-06-29 | CGO | ETF | 18.04 | 18.0752 | 18.0 | 18.02 | 11700.0 |
| 2007-06-29 | CGW | ETF | 25.44 | 25.6 | 25.4 | 25.57 | 73800.0 |
| 2007-06-29 | CHB | ETF | 10.11 | 10.23 | 9.79 | 9.83 | 1055200.0 |
| 2007-06-29 | CHI | ETF | 19.5 | 19.62 | 19.35 | 19.4 | 92400.0 |
| 2007-06-29 | CHIC | ETF | 26.39 | 27.11 | 26.12 | 26.86 | 686144.0 |
| 2007-06-29 | CHY | ETF | 16.17 | 16.35 | 16.17 | 16.26 | 133300.0 |
| 2007-06-29 | CN | ETF | 55.95 | 56.07 | 55.29 | 55.75 | 73700.0 |
| 2007-06-29 | CNXT | ETF | 1.39 | 1.42 | 1.35 | 1.38 | 9820883.0 |
| 2007-06-29 | CPI | ETF | 24.2 | 24.2 | 24.0 | 24.0 | 2200.0 |
| 2007-06-29 | CPST | ETF | 1.11 | 1.15 | 1.07 | 1.07 | 2480179.0 |
| 2007-06-29 | CSA | ETF | 20.0 | 21.04 | 19.56 | 20.59 | 120800.0 |
| 2007-06-29 | CSB | ETF | 32.45 | 32.86 | 32.17 | 32.51 | 24700.0 |
| 2007-06-29 | CSD | ETF | 30.85 | 31.0 | 30.58 | 30.65 | 47700.0 |
| 2007-06-29 | CSM | ETF | 1.425 | 1.425 | 1.425 | 1.425 | 2000.0 |
| 2007-06-29 | CSQ | ETF | 15.3 | 15.34 | 15.02 | 15.13 | 254900.0 |
| 2007-06-29 | CTEC | ETF | 111.1 | 111.64999999999999 | 109.3 | 109.74999999999999 | 19960.4 |
| 2007-06-29 | CVY | ETF | 27.63 | 27.69 | 27.38 | 27.5 | 17200.0 |
| 2007-06-29 | CWI | ETF | 27.3333 | 27.4467 | 27.2067 | 27.2933 | 7950.0 |
| 2007-06-29 | DBA | ETF | 26.9 | 27.1 | 26.2 | 26.4 | 496600.0 |
| 2007-06-29 | DBB | ETF | 26.54 | 26.61 | 26.37 | 26.58 | 31500.0 |
| 2007-06-29 | DBC | ETF | 25.75 | 26.06 | 25.65 | 25.7 | 258100.0 |
| 2007-06-29 | DBE | ETF | 28.8 | 28.87 | 28.66 | 28.87 | 36400.0 |
| 2007-06-29 | DBO | ETF | 27.01 | 27.17 | 27.0 | 27.1 | 9900.0 |
| 2007-06-29 | DBP | ETF | 25.49 | 25.49 | 25.29 | 25.32 | 22100.0 |
| 2007-06-29 | DBS | ETF | 24.58 | 24.65 | 24.25 | 24.39 | 23800.0 |
> showing 50 of 497 rows — these rows as CSV