PREVIEW / etf_daily / 2008-01-09
file: by_date/etf_daily/2008/2008-01-09.parquet size: 26 KB rows: 564
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-01-09 | SPY | ETF | 139.09 | 140.79 | 137.7 | 140.37 | 301824900.0 |
| 2008-01-09 | QQQ | ETF | 47.09 | 47.96 | 46.46 | 47.92 | 254110742.0 |
| 2008-01-09 | IWM | ETF | 69.93 | 71.0 | 68.62 | 70.73 | 140191600.0 |
| 2008-01-09 | DIA | ETF | 126.12 | 127.39 | 125.01 | 126.96 | 24161600.0 |
| 2008-01-09 | GLD | ETF | 86.56 | 87.2 | 86.3 | 86.55 | 10080200.0 |
| 2008-01-09 | TLT | ETF | 94.79 | 95.3 | 94.62 | 94.75 | 2203500.0 |
| 2008-01-09 | ADRE | ETF | 53.01 | 54.22 | 52.6601 | 54.2 | 394078.0 |
| 2008-01-09 | AGG | ETF | 102.44 | 102.5 | 102.11 | 102.28 | 437700.0 |
| 2008-01-09 | AIA | ETF | 47.72 | 47.72 | 46.41 | 47.28 | 1400.0 |
| 2008-01-09 | AIQ | ETF | 47.5 | 48.1 | 47.3 | 47.9 | 70000.0 |
| 2008-01-09 | AIS | ETF | 1.0 | 1.02 | 0.98 | 1.0 | 178600.0 |
| 2008-01-09 | AIVI | ETF | 68.46 | 69.69 | 67.93 | 68.85 | 73200.0 |
| 2008-01-09 | ARB | ETF | 39.19 | 40.15 | 38.49 | 40.0 | 304200.0 |
| 2008-01-09 | BBH | ETF | 54.7867 | 56.08 | 54.6667 | 56.08 | 1076400.0 |
| 2008-01-09 | BIL | ETF | 91.68 | 91.68 | 91.54 | 91.54 | 168500.0 |
| 2008-01-09 | BITS | ETF | 21.0 | 21.52 | 20.96 | 21.28 | 12837.0 |
| 2008-01-09 | BIV | ETF | 78.55 | 78.55 | 78.19 | 78.22 | 18000.0 |
| 2008-01-09 | BKF | ETF | 58.22 | 58.94 | 57.8 | 58.72 | 29500.0 |
| 2008-01-09 | BLV | ETF | 77.7 | 77.87 | 77.46 | 77.46 | 11000.0 |
| 2008-01-09 | BMVP | ETF | 16.41 | 16.65 | 16.33 | 16.65 | 102036.0 |
| 2008-01-09 | BND | ETF | 77.4 | 77.82 | 77.4 | 77.56 | 195500.0 |
| 2008-01-09 | BNE | ETF | 15.08 | 15.08 | 14.35 | 14.67 | 412581.0 |
| 2008-01-09 | BRF | ETF | 14.63 | 14.67 | 14.61 | 14.64 | 29430.0 |
| 2008-01-09 | BSV | ETF | 77.41 | 77.78 | 77.41 | 77.61 | 57600.0 |
| 2008-01-09 | BTF | ETF | 108.39999999999999 | 108.8 | 106.6 | 108.55 | 3020.0 |
| 2008-01-09 | BWX | ETF | 27.205 | 27.205 | 26.905 | 27.02 | 263594.0 |
| 2008-01-09 | CBON | ETF | 14.79 | 15.21 | 14.58 | 14.76 | 114603.0 |
| 2008-01-09 | CDL | ETF | 1.57 | 1.71 | 1.54 | 1.69 | 1684344.0 |
| 2008-01-09 | CEF | ETF | 11.58 | 11.58 | 10.95 | 11.12 | 859400.0 |
| 2008-01-09 | CGO | ETF | 18.71 | 19.04 | 18.58 | 19.04 | 9098.0 |
| 2008-01-09 | CGW | ETF | 24.68 | 25.292 | 24.39 | 24.82 | 77489.0 |
| 2008-01-09 | CHB | ETF | 7.87 | 8.02 | 7.15 | 7.98 | 2267816.0 |
| 2008-01-09 | CHI | ETF | 15.37 | 15.4 | 15.12 | 15.26 | 147935.0 |
| 2008-01-09 | CHIC | ETF | 14.49 | 14.85 | 14.18 | 14.69 | 474165.0 |
| 2008-01-09 | CHW | ETF | 12.79 | 12.8 | 12.55 | 12.78 | 138468.0 |
| 2008-01-09 | CHY | ETF | 13.82 | 13.82 | 13.55 | 13.82 | 199133.0 |
| 2008-01-09 | CMF | ETF | 52.765 | 52.815 | 52.655 | 52.655 | 7200.0 |
| 2008-01-09 | CN | ETF | 61.25 | 62.9 | 60.1 | 62.45 | 422445.0 |
| 2008-01-09 | CNXT | ETF | 0.63 | 0.6499 | 0.56 | 0.57 | 8732496.0 |
| 2008-01-09 | COW | ETF | 46.33 | 46.33 | 46.1 | 46.22 | 4600.0 |
| 2008-01-09 | CPI | ETF | 23.1 | 23.1 | 21.81 | 22.5 | 3701.0 |
| 2008-01-09 | CPST | ETF | 1.8 | 1.8 | 1.56 | 1.73 | 5398624.0 |
| 2008-01-09 | CSA | ETF | 15.8499 | 15.8499 | 15.56 | 15.59 | 21000.0 |
| 2008-01-09 | CSD | ETF | 24.48 | 24.61 | 24.05 | 24.61 | 17600.0 |
| 2008-01-09 | CSQ | ETF | 13.77 | 13.95 | 13.67 | 13.9 | 347478.0 |
| 2008-01-09 | CUT | ETF | 24.6 | 24.6 | 21.0 | 22.4 | 41900.0 |
| 2008-01-09 | CVY | ETF | 21.91 | 22.09 | 21.6 | 22.09 | 10000.0 |
| 2008-01-09 | CWI | ETF | 26.9067 | 26.9067 | 26.5133 | 26.8867 | 49350.0 |
| 2008-01-09 | DBA | ETF | 35.02 | 35.02 | 34.25 | 34.36 | 2200300.0 |
| 2008-01-09 | DBB | ETF | 23.5 | 23.54 | 23.11 | 23.21 | 71700.0 |
> showing 50 of 564 rows — these rows as CSV