PREVIEW / etf_daily / 2007-08-01
file: by_date/etf_daily/2007/2007-08-01.parquet size: 23 KB rows: 502
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-08-01 | SPY | ETF | 145.18 | 147.01 | 143.95 | 146.43 | 467670000.0 |
| 2007-08-01 | QQQ | ETF | 47.39 | 47.93 | 46.98 | 47.9 | 301212594.0 |
| 2007-08-01 | IWM | ETF | 76.87 | 77.96 | 76.11 | 77.52 | 185942500.0 |
| 2007-08-01 | DIA | ETF | 131.89 | 133.79 | 131.2 | 133.41 | 42193500.0 |
| 2007-08-01 | GLD | ETF | 65.5 | 66.06 | 65.38 | 65.93 | 6364400.0 |
| 2007-08-01 | TLT | ETF | 87.26 | 87.54 | 87.09 | 87.13 | 2154700.0 |
| 2007-08-01 | ADRE | ETF | 45.22 | 45.99 | 44.81 | 45.736 | 388944.0 |
| 2007-08-01 | AGG | ETF | 98.52 | 98.6 | 98.33 | 98.33 | 814500.0 |
| 2007-08-01 | AIQ | ETF | 44.4 | 45.25 | 42.75 | 43.85 | 47000.0 |
| 2007-08-01 | AIS | ETF | 1.6 | 1.6 | 1.54 | 1.57 | 141200.0 |
| 2007-08-01 | ARB | ETF | 49.8 | 51.38 | 49.14 | 51.3 | 482400.0 |
| 2007-08-01 | BBH | ETF | 54.64 | 55.0033 | 52.65 | 54.5467 | 1254000.0 |
| 2007-08-01 | BIL | ETF | 91.58 | 91.6 | 91.5 | 91.56 | 18650.0 |
| 2007-08-01 | BITS | ETF | 26.0 | 26.1604 | 25.4 | 25.84 | 11564.0 |
| 2007-08-01 | BIV | ETF | 74.36 | 74.43 | 74.24 | 74.26 | 7300.0 |
| 2007-08-01 | BLV | ETF | 73.65 | 73.68 | 73.32 | 73.5 | 25600.0 |
| 2007-08-01 | BMVP | ETF | 17.0 | 17.06 | 16.42 | 17.02 | 342500.0 |
| 2007-08-01 | BND | ETF | 74.46 | 74.49 | 74.26 | 74.39 | 32600.0 |
| 2007-08-01 | BNE | ETF | 17.34 | 17.52 | 17.0 | 17.36 | 288300.0 |
| 2007-08-01 | BRF | ETF | 14.46 | 14.54 | 14.46 | 14.5 | 7500.0 |
| 2007-08-01 | BSV | ETF | 75.13 | 75.19 | 75.06 | 75.1 | 30100.0 |
| 2007-08-01 | BTF | ETF | 102.85 | 102.85 | 101.64999999999999 | 102.3 | 1740.0 |
| 2007-08-01 | CBON | ETF | 23.52 | 24.03 | 23.28 | 23.88 | 82914.0 |
| 2007-08-01 | CDL | ETF | 4.99 | 5.0 | 4.74 | 4.81 | 2916711.0 |
| 2007-08-01 | CEF | ETF | 9.15 | 9.25 | 8.96 | 9.1 | 503500.0 |
| 2007-08-01 | CGO | ETF | 17.05 | 17.23 | 16.75 | 17.01 | 36900.0 |
| 2007-08-01 | CGW | ETF | 24.6 | 25.1 | 24.5 | 25.05 | 213400.0 |
| 2007-08-01 | CHB | ETF | 11.71 | 12.01 | 10.73 | 11.65 | 2591250.0 |
| 2007-08-01 | CHI | ETF | 17.4 | 17.5 | 17.01 | 17.21 | 148900.0 |
| 2007-08-01 | CHIC | ETF | 17.72 | 17.79 | 17.1 | 17.53 | 1480997.0 |
| 2007-08-01 | CHW | ETF | 14.03 | 14.15 | 14.0 | 14.02 | 88200.0 |
| 2007-08-01 | CHY | ETF | 15.13 | 15.22 | 14.75 | 15.0 | 192400.0 |
| 2007-08-01 | CN | ETF | 50.27 | 51.0 | 49.59 | 50.41 | 127900.0 |
| 2007-08-01 | CNXT | ETF | 1.29 | 1.3 | 1.26 | 1.29 | 6879355.0 |
| 2007-08-01 | CPI | ETF | 26.7101 | 27.8 | 26.7101 | 27.8 | 1800.0 |
| 2007-08-01 | CPST | ETF | 1.15 | 1.16 | 1.04 | 1.07 | 3418290.0 |
| 2007-08-01 | CSA | ETF | 17.4 | 17.6 | 17.08 | 17.17 | 53800.0 |
| 2007-08-01 | CSD | ETF | 29.16 | 29.18 | 28.54 | 29.0 | 93600.0 |
| 2007-08-01 | CSQ | ETF | 14.03 | 14.16 | 13.81 | 14.03 | 370400.0 |
| 2007-08-01 | CTEC | ETF | 104.04999999999998 | 104.04999999999998 | 100.95 | 101.69999999999999 | 10495.0 |
| 2007-08-01 | CVY | ETF | 25.99 | 26.06 | 25.53 | 25.97 | 71200.0 |
| 2007-08-01 | CWI | ETF | 26.76 | 26.88 | 26.4733 | 26.7133 | 15450.0 |
| 2007-08-01 | CZA | ETF | 25.69 | 25.69 | 25.69 | 25.69 | 100.0 |
| 2007-08-01 | DBA | ETF | 26.13 | 26.26 | 25.81 | 25.91 | 91300.0 |
| 2007-08-01 | DBB | ETF | 27.54 | 27.73 | 27.28 | 27.71 | 31000.0 |
| 2007-08-01 | DBC | ETF | 26.19 | 26.31 | 25.82 | 26.15 | 465000.0 |
| 2007-08-01 | DBE | ETF | 29.32 | 29.55 | 28.8 | 29.26 | 35900.0 |
| 2007-08-01 | DBO | ETF | 27.65 | 27.9 | 27.23 | 27.71 | 24600.0 |
| 2007-08-01 | DBP | ETF | 25.99 | 26.04 | 25.91 | 25.91 | 3900.0 |
| 2007-08-01 | DBS | ETF | 25.57 | 25.57 | 25.37 | 25.37 | 1800.0 |
> showing 50 of 502 rows — these rows as CSV