PREVIEW / etf_daily / 2007-08-02
file: by_date/etf_daily/2007/2007-08-02.parquet size: 23 KB rows: 498
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-02 | SPY | ETF | 146.76 | 147.76 | 145.26 | 147.6 | 294758400.0 |
| 2007-08-02 | QQQ | ETF | 47.94 | 48.43 | 47.79 | 48.34 | 177795538.0 |
| 2007-08-02 | IWM | ETF | 77.94 | 78.5 | 77.3 | 78.13 | 105762800.0 |
| 2007-08-02 | DIA | ETF | 133.51 | 135.0 | 132.98 | 134.78 | 22635400.0 |
| 2007-08-02 | GLD | ETF | 65.96 | 66.01 | 65.55 | 65.89 | 5331500.0 |
| 2007-08-02 | TLT | ETF | 87.21 | 87.45 | 86.99 | 87.35 | 2079400.0 |
| 2007-08-02 | ADRE | ETF | 46.13 | 46.21 | 45.6 | 46.05 | 129243.0 |
| 2007-08-02 | AGG | ETF | 98.32 | 98.48 | 98.16 | 98.28 | 566300.0 |
| 2007-08-02 | AIQ | ETF | 43.1 | 45.0 | 43.05 | 43.25 | 72100.0 |
| 2007-08-02 | AIS | ETF | 1.55 | 1.6 | 1.52 | 1.57 | 309200.0 |
| 2007-08-02 | ARB | ETF | 51.28 | 52.09 | 50.5 | 51.91 | 415700.0 |
| 2007-08-02 | BBH | ETF | 54.4467 | 54.86 | 54.27 | 54.66 | 416100.0 |
| 2007-08-02 | BIL | ETF | 91.5 | 91.58 | 91.48 | 91.58 | 49750.0 |
| 2007-08-02 | BITS | ETF | 25.96 | 26.0 | 25.34 | 25.36 | 8034.0 |
| 2007-08-02 | BIV | ETF | 74.18 | 74.3 | 74.11 | 74.26 | 12100.0 |
| 2007-08-02 | BLV | ETF | 73.59 | 73.66 | 73.48 | 73.65 | 8000.0 |
| 2007-08-02 | BMVP | ETF | 17.13 | 17.1633 | 16.966 | 17.0933 | 45600.0 |
| 2007-08-02 | BND | ETF | 74.41 | 74.54 | 74.23 | 74.52 | 40600.0 |
| 2007-08-02 | BNE | ETF | 17.43 | 17.51 | 17.08 | 17.51 | 329500.0 |
| 2007-08-02 | BRF | ETF | 14.55 | 14.59 | 14.49 | 14.53 | 2600.0 |
| 2007-08-02 | BSV | ETF | 75.06 | 75.15 | 74.95 | 75.14 | 79800.0 |
| 2007-08-02 | BTF | ETF | 102.6 | 103.52799999999999 | 102.6 | 103.52799999999999 | 280.0 |
| 2007-08-02 | CBON | ETF | 23.92 | 24.34 | 23.08 | 23.45 | 155171.0 |
| 2007-08-02 | CDL | ETF | 4.81 | 4.92 | 4.78 | 4.83 | 2805901.0 |
| 2007-08-02 | CEF | ETF | 9.1 | 9.19 | 9.1 | 9.14 | 144200.0 |
| 2007-08-02 | CGO | ETF | 17.1 | 17.1 | 16.83 | 17.0399 | 26700.0 |
| 2007-08-02 | CGW | ETF | 25.03 | 25.15 | 24.9 | 25.13 | 103300.0 |
| 2007-08-02 | CHB | ETF | 11.72 | 12.07 | 11.52 | 12.0 | 2423500.0 |
| 2007-08-02 | CHI | ETF | 17.05 | 17.39 | 17.04 | 17.36 | 107600.0 |
| 2007-08-02 | CHIC | ETF | 17.46 | 17.82 | 17.04 | 17.16 | 943188.0 |
| 2007-08-02 | CHW | ETF | 14.05 | 14.38 | 14.04 | 14.1 | 66500.0 |
| 2007-08-02 | CHY | ETF | 14.92 | 15.3265 | 14.92 | 15.3265 | 107500.0 |
| 2007-08-02 | CN | ETF | 50.2 | 51.29 | 50.2 | 51.05 | 76500.0 |
| 2007-08-02 | CNXT | ETF | 1.29 | 1.3 | 1.25 | 1.28 | 10081096.0 |
| 2007-08-02 | CPI | ETF | 28.0 | 28.03 | 28.0 | 28.03 | 500.0 |
| 2007-08-02 | CPST | ETF | 1.07 | 1.09 | 1.04 | 1.06 | 1631370.0 |
| 2007-08-02 | CSA | ETF | 17.39 | 17.49 | 16.93 | 17.34 | 280100.0 |
| 2007-08-02 | CSD | ETF | 29.11 | 29.2 | 28.93 | 29.04 | 23400.0 |
| 2007-08-02 | CSQ | ETF | 14.15 | 14.48 | 14.07 | 14.26 | 276900.0 |
| 2007-08-02 | CTEC | ETF | 98.45 | 103.0 | 97.2 | 103.0 | 19379.600000000002 |
| 2007-08-02 | CVY | ETF | 26.01 | 26.12 | 25.89 | 26.05 | 41700.0 |
| 2007-08-02 | CWI | ETF | 26.8867 | 27.0133 | 26.7933 | 26.9933 | 16800.0 |
| 2007-08-02 | CZA | ETF | 25.84 | 25.95 | 25.77 | 25.85 | 400.0 |
| 2007-08-02 | DBA | ETF | 26.29 | 26.29 | 26.04 | 26.15 | 100500.0 |
| 2007-08-02 | DBB | ETF | 27.76 | 27.76 | 27.37 | 27.56 | 29200.0 |
| 2007-08-02 | DBC | ETF | 26.15 | 26.3 | 26.04 | 26.19 | 188500.0 |
| 2007-08-02 | DBE | ETF | 29.14 | 29.34 | 29.01 | 29.34 | 9400.0 |
| 2007-08-02 | DBO | ETF | 27.72 | 27.99 | 27.7 | 27.95 | 23300.0 |
| 2007-08-02 | DBP | ETF | 26.07 | 26.08 | 25.94 | 26.05 | 8300.0 |
| 2007-08-02 | DBS | ETF | 25.5 | 25.5 | 25.4435 | 25.452 | 1900.0 |
> showing 50 of 498 rows — these rows as CSV