PREVIEW / etf_daily / 2007-11-02
file: by_date/etf_daily/2007/2007-11-02.parquet size: 24 KB rows: 532
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-11-02 | SPY | ETF | 151.53 | 152.0 | 149.21 | 151.2 | 331228200.0 |
| 2007-11-02 | QQQ | ETF | 54.42 | 54.5501 | 53.6 | 54.42 | 217882894.0 |
| 2007-11-02 | IWM | ETF | 80.1 | 80.13 | 78.35 | 79.53 | 130182000.0 |
| 2007-11-02 | DIA | ETF | 136.19 | 136.23 | 134.38 | 136.05 | 20988000.0 |
| 2007-11-02 | GLD | ETF | 78.55 | 79.9 | 77.48 | 79.83 | 9911400.0 |
| 2007-11-02 | TLT | ETF | 90.45 | 91.54 | 90.21 | 91.04 | 1927700.0 |
| 2007-11-02 | ADRE | ETF | 58.0 | 58.55 | 56.75 | 57.76 | 571956.0 |
| 2007-11-02 | AGG | ETF | 100.46 | 100.9 | 100.43 | 100.55 | 401100.0 |
| 2007-11-02 | AIQ | ETF | 45.7 | 46.8 | 44.35 | 44.65 | 120240.0 |
| 2007-11-02 | AIS | ETF | 1.2 | 1.24 | 1.17 | 1.17 | 343700.0 |
| 2007-11-02 | AIVI | ETF | 76.28 | 76.28 | 75.44 | 76.12 | 70200.0 |
| 2007-11-02 | ARB | ETF | 49.65 | 50.42 | 49.24 | 49.98 | 258900.0 |
| 2007-11-02 | BBH | ETF | 59.6667 | 60.2933 | 59.66 | 60.2833 | 321000.0 |
| 2007-11-02 | BIL | ETF | 91.6 | 91.66 | 91.56 | 91.66 | 8750.0 |
| 2007-11-02 | BITS | ETF | 26.84 | 27.0 | 25.6 | 26.08 | 4522.0 |
| 2007-11-02 | BIV | ETF | 76.18 | 76.68 | 76.18 | 76.55 | 46000.0 |
| 2007-11-02 | BLV | ETF | 76.07 | 76.75 | 76.06 | 76.39 | 42500.0 |
| 2007-11-02 | BMVP | ETF | 17.28 | 17.36 | 17.19 | 17.3367 | 56200.0 |
| 2007-11-02 | BND | ETF | 76.09 | 76.41 | 76.09 | 76.34 | 105800.0 |
| 2007-11-02 | BNE | ETF | 16.57 | 16.72 | 16.32 | 16.62 | 122200.0 |
| 2007-11-02 | BRF | ETF | 14.6999 | 14.72 | 14.5 | 14.72 | 57600.0 |
| 2007-11-02 | BSV | ETF | 76.18 | 76.49 | 76.11 | 76.39 | 64600.0 |
| 2007-11-02 | BTF | ETF | 116.99999999999999 | 116.99999999999999 | 115.19999999999999 | 116.19999999999999 | 4080.0 |
| 2007-11-02 | BWX | ETF | 26.645 | 26.73 | 26.625 | 26.73 | 148600.0 |
| 2007-11-02 | CBON | ETF | 19.58 | 19.74 | 18.8001 | 19.34 | 113797.0 |
| 2007-11-02 | CDL | ETF | 4.32 | 4.32 | 4.15 | 4.27 | 1526500.0 |
| 2007-11-02 | CEF | ETF | 10.49 | 10.68 | 10.38 | 10.6 | 562600.0 |
| 2007-11-02 | CGO | ETF | 19.32 | 19.59 | 19.24 | 19.57 | 15300.0 |
| 2007-11-02 | CGW | ETF | 26.02 | 26.15 | 25.8101 | 26.15 | 64500.0 |
| 2007-11-02 | CHB | ETF | 11.66 | 11.8 | 11.18 | 11.41 | 2040200.0 |
| 2007-11-02 | CHI | ETF | 16.6 | 16.75 | 16.05 | 16.25 | 159400.0 |
| 2007-11-02 | CHIC | ETF | 13.87 | 14.03 | 13.17 | 14.02 | 1047019.0 |
| 2007-11-02 | CHW | ETF | 13.0 | 13.23 | 12.95 | 12.97 | 151900.0 |
| 2007-11-02 | CHY | ETF | 14.49 | 14.51 | 14.0 | 14.13 | 171000.0 |
| 2007-11-02 | CMF | ETF | 51.875 | 51.925 | 51.85 | 51.864 | 74600.0 |
| 2007-11-02 | CN | ETF | 57.84 | 58.28 | 56.64 | 58.25 | 217000.0 |
| 2007-11-02 | CNXT | ETF | 1.23 | 1.33 | 1.22 | 1.27 | 15830608.0 |
| 2007-11-02 | CPST | ETF | 1.18 | 1.2 | 1.16 | 1.19 | 1740528.0 |
| 2007-11-02 | CSA | ETF | 16.78 | 16.78 | 16.34 | 16.36 | 49400.0 |
| 2007-11-02 | CSD | ETF | 28.6 | 28.73 | 28.41 | 28.6 | 65200.0 |
| 2007-11-02 | CSM | ETF | 1.47 | 1.47 | 1.47 | 1.47 | 2000.0 |
| 2007-11-02 | CSQ | ETF | 14.45 | 14.4815 | 14.2 | 14.3 | 218000.0 |
| 2007-11-02 | CVY | ETF | 25.4 | 25.4 | 25.1 | 25.2 | 24600.0 |
| 2007-11-02 | CWI | ETF | 29.5067 | 29.56 | 29.2267 | 29.56 | 20700.0 |
| 2007-11-02 | CZA | ETF | 26.68 | 26.68 | 26.68 | 26.68 | 900.0 |
| 2007-11-02 | DBA | ETF | 29.1 | 29.49 | 29.04 | 29.49 | 288800.0 |
| 2007-11-02 | DBB | ETF | 25.49 | 25.64 | 25.27 | 25.46 | 23900.0 |
| 2007-11-02 | DBC | ETF | 30.32 | 30.76 | 30.2 | 30.76 | 205100.0 |
| 2007-11-02 | DBE | ETF | 34.45 | 35.02 | 34.29 | 34.95 | 32300.0 |
| 2007-11-02 | DBO | ETF | 34.35 | 34.55 | 33.83 | 34.44 | 12900.0 |
> showing 50 of 532 rows — these rows as CSV