PREVIEW / etf_daily / 2008-02-01
file: by_date/etf_daily/2008/2008-02-01.parquet size: 26 KB rows: 567
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-01 | SPY | ETF | 137.94 | 139.61 | 137.52 | 139.58 | 206843600.0 |
| 2008-02-01 | QQQ | ETF | 45.52 | 45.88 | 44.88 | 45.5899 | 161920253.0 |
| 2008-02-01 | IWM | ETF | 71.33 | 72.88 | 71.0 | 72.61 | 100612100.0 |
| 2008-02-01 | DIA | ETF | 126.49 | 127.61 | 125.96 | 127.43 | 18098700.0 |
| 2008-02-01 | GLD | ETF | 91.75 | 91.87 | 89.22 | 89.35 | 19635600.0 |
| 2008-02-01 | TLT | ETF | 95.0 | 95.4 | 94.56 | 95.23 | 4163700.0 |
| 2008-02-01 | ADRE | ETF | 50.17 | 51.6 | 50.17 | 51.4401 | 594433.0 |
| 2008-02-01 | AGG | ETF | 103.27 | 103.32 | 102.99 | 102.99 | 610300.0 |
| 2008-02-01 | AIA | ETF | 44.16 | 44.16 | 43.65 | 43.65 | 2100.0 |
| 2008-02-01 | AIQ | ETF | 52.55 | 54.45 | 52.1 | 53.0 | 49079.0 |
| 2008-02-01 | AIS | ETF | 1.06 | 1.08 | 1.03 | 1.08 | 231600.0 |
| 2008-02-01 | AIVI | ETF | 65.29 | 66.21 | 64.86 | 65.81 | 86400.0 |
| 2008-02-01 | ARB | ETF | 40.06 | 41.13 | 39.97 | 41.0 | 302786.0 |
| 2008-02-01 | BBH | ETF | 54.7567 | 55.4333 | 54.5467 | 55.18 | 644100.0 |
| 2008-02-01 | BIL | ETF | 92.3 | 92.3 | 91.6 | 91.7 | 35500.0 |
| 2008-02-01 | BITS | ETF | 24.4 | 24.4 | 22.52 | 22.76 | 15884.0 |
| 2008-02-01 | BIV | ETF | 79.38 | 79.51 | 79.15 | 79.22 | 65400.0 |
| 2008-02-01 | BJK | ETF | 44.91 | 44.91 | 43.35 | 43.65 | 4200.0 |
| 2008-02-01 | BKF | ETF | 51.58 | 52.91 | 51.58 | 52.83 | 23300.0 |
| 2008-02-01 | BLV | ETF | 77.85 | 77.91 | 77.4 | 77.91 | 36700.0 |
| 2008-02-01 | BMVP | ETF | 16.0933 | 16.3566 | 16.0933 | 16.3543 | 62353.0 |
| 2008-02-01 | BND | ETF | 78.44 | 78.5 | 78.15 | 78.31 | 126500.0 |
| 2008-02-01 | BNE | ETF | 12.46 | 13.37 | 12.31 | 13.3 | 542600.0 |
| 2008-02-01 | BRF | ETF | 14.74 | 14.74 | 14.68 | 14.68 | 2300.0 |
| 2008-02-01 | BSV | ETF | 79.43 | 79.43 | 78.53 | 78.63 | 113500.0 |
| 2008-02-01 | BTF | ETF | 110.35 | 112.85 | 109.89999999999999 | 112.79999999999998 | 7580.0 |
| 2008-02-01 | BWX | ETF | 27.62 | 27.62 | 27.4 | 27.535 | 258384.0 |
| 2008-02-01 | CBON | ETF | 16.8 | 17.08 | 16.56 | 17.02 | 217199.0 |
| 2008-02-01 | CDL | ETF | 1.46 | 1.64 | 1.46 | 1.59 | 1940705.0 |
| 2008-02-01 | CEF | ETF | 12.8 | 12.8 | 12.22 | 12.29 | 1214900.0 |
| 2008-02-01 | CGO | ETF | 17.81 | 17.9999 | 17.8 | 17.85 | 15770.0 |
| 2008-02-01 | CGW | ETF | 23.86 | 24.2 | 23.5 | 24.2 | 58450.0 |
| 2008-02-01 | CHB | ETF | 9.75 | 9.8 | 9.07 | 9.63 | 1842834.0 |
| 2008-02-01 | CHI | ETF | 16.02 | 16.27 | 15.84 | 16.2 | 105800.0 |
| 2008-02-01 | CHIC | ETF | 18.04 | 18.37 | 17.59 | 18.0 | 580304.0 |
| 2008-02-01 | CHW | ETF | 12.54 | 12.89 | 12.54 | 12.89 | 102193.0 |
| 2008-02-01 | CHY | ETF | 14.38 | 14.52 | 14.25 | 14.43 | 124400.0 |
| 2008-02-01 | CMF | ETF | 53.03 | 53.03 | 52.84 | 53.005 | 21000.0 |
| 2008-02-01 | CN | ETF | 63.99 | 65.47 | 63.58 | 65.0 | 303516.0 |
| 2008-02-01 | CNXT | ETF | 0.69 | 0.702 | 0.65 | 0.6799 | 3197955.0 |
| 2008-02-01 | COW | ETF | 46.43 | 46.66 | 46.35 | 46.47 | 69300.0 |
| 2008-02-01 | CPI | ETF | 20.6 | 20.85 | 20.6 | 20.85 | 700.0 |
| 2008-02-01 | CPST | ETF | 1.48 | 1.53 | 1.46 | 1.46 | 1313498.0 |
| 2008-02-01 | CSA | ETF | 16.85 | 17.0 | 16.4 | 16.55 | 72500.0 |
| 2008-02-01 | CSD | ETF | 25.45 | 25.68 | 25.45 | 25.68 | 3200.0 |
| 2008-02-01 | CSQ | ETF | 13.73 | 14.05 | 13.73 | 13.96 | 238750.0 |
| 2008-02-01 | CUT | ETF | 21.82 | 22.25 | 21.81 | 22.25 | 13300.0 |
| 2008-02-01 | CVY | ETF | 23.95 | 24.1 | 23.8 | 24.1 | 7600.0 |
| 2008-02-01 | CWI | ETF | 25.1867 | 25.8067 | 25.1867 | 25.7933 | 76500.0 |
| 2008-02-01 | CZA | ETF | 24.43 | 24.49 | 24.43 | 24.47 | 1600.0 |
> showing 50 of 567 rows — these rows as CSV