PREVIEW / etf_daily / 2008-09-24
file: by_date/etf_daily/2008/2008-09-24.parquet size: 27 KB rows: 606
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-09-24 | SPY | ETF | 119.35 | 120.0 | 117.79 | 118.93 | 311818400.0 |
| 2008-09-24 | QQQ | ETF | 40.85 | 41.26 | 40.52 | 40.85 | 159305214.0 |
| 2008-09-24 | IWM | ETF | 70.83 | 71.03 | 68.9 | 69.94 | 91760200.0 |
| 2008-09-24 | DIA | ETF | 108.93 | 109.23 | 107.46 | 108.3 | 20635600.0 |
| 2008-09-24 | GLD | ETF | 88.68 | 88.76 | 86.7 | 86.71 | 17238600.0 |
| 2008-09-24 | TLT | ETF | 93.97 | 94.75 | 93.6 | 94.01 | 1014900.0 |
| 2008-09-24 | AAXJ | ETF | 43.23 | 43.4 | 43.22 | 43.24 | 11500.0 |
| 2008-09-24 | ACWI | ETF | 43.35 | 43.56 | 42.98 | 43.15 | 71700.0 |
| 2008-09-24 | ACWX | ETF | 42.41 | 42.58 | 41.98 | 42.25 | 72883.0 |
| 2008-09-24 | ADRE | ETF | 38.11 | 39.13 | 38.11 | 38.8 | 352739.0 |
| 2008-09-24 | AFK | ETF | 35.18 | 35.32 | 33.4 | 33.842 | 3115.0 |
| 2008-09-24 | AGG | ETF | 99.0 | 99.45 | 98.75 | 99.39 | 2371500.0 |
| 2008-09-24 | AIA | ETF | 35.16 | 35.16 | 34.09 | 35.08 | 49162.0 |
| 2008-09-24 | AIQ | ETF | 56.0 | 56.0 | 54.55 | 54.55 | 30014.0 |
| 2008-09-24 | AIS | ETF | 0.65 | 0.73 | 0.65 | 0.7 | 43699.0 |
| 2008-09-24 | AIVI | ETF | 54.52 | 54.52 | 53.75 | 53.92 | 43700.0 |
| 2008-09-24 | ARB | ETF | 47.61 | 47.78 | 47.0 | 47.01 | 173324.0 |
| 2008-09-24 | BBH | ETF | 61.39 | 61.5567 | 60.67 | 61.5333 | 151800.0 |
| 2008-09-24 | BIL | ETF | 92.06 | 92.06 | 91.8 | 91.82 | 89300.0 |
| 2008-09-24 | BITS | ETF | 22.2 | 23.2 | 22.0804 | 23.16 | 4696.0 |
| 2008-09-24 | BIV | ETF | 74.88 | 75.76 | 74.7 | 75.08 | 81900.0 |
| 2008-09-24 | BJK | ETF | 26.42 | 26.42 | 26.42 | 26.42 | 200.0 |
| 2008-09-24 | BKF | ETF | 37.62 | 37.62 | 36.5 | 36.53 | 35124.0 |
| 2008-09-24 | BLV | ETF | 73.0 | 73.33 | 72.21 | 72.55 | 34600.0 |
| 2008-09-24 | BMVP | ETF | 13.8867 | 13.9733 | 13.8301 | 13.84 | 19636.0 |
| 2008-09-24 | BND | ETF | 76.82 | 77.1 | 76.08 | 76.64 | 3408100.0 |
| 2008-09-24 | BNE | ETF | 11.77 | 11.86 | 11.27 | 11.27 | 145630.0 |
| 2008-09-24 | BRF | ETF | 14.75 | 14.75 | 14.52 | 14.66 | 20514.0 |
| 2008-09-24 | BSV | ETF | 77.49 | 77.97 | 77.08 | 77.89 | 121100.0 |
| 2008-09-24 | BTF | ETF | 79.5 | 80.85000000000001 | 79.05 | 79.4 | 8049.8 |
| 2008-09-24 | BWX | ETF | 26.745 | 26.8925 | 26.309 | 26.695 | 187102.0 |
| 2008-09-24 | CBON | ETF | 6.61 | 7.16 | 6.6 | 7.05 | 113005.0 |
| 2008-09-24 | CDL | ETF | 0.85 | 0.85 | 0.71 | 0.71 | 2065063.0 |
| 2008-09-24 | CEF | ETF | 11.24 | 11.3 | 10.92 | 10.99 | 1202600.0 |
| 2008-09-24 | CGO | ETF | 11.59 | 11.96 | 11.42 | 11.93 | 17132.0 |
| 2008-09-24 | CGW | ETF | 21.01 | 21.33 | 21.0 | 21.01 | 129819.0 |
| 2008-09-24 | CHB | ETF | 5.74 | 5.87 | 5.36 | 5.56 | 920679.0 |
| 2008-09-24 | CHI | ETF | 10.52 | 10.55 | 10.1 | 10.46 | 181164.0 |
| 2008-09-24 | CHIC | ETF | 11.56 | 11.56 | 10.96 | 10.98 | 381073.0 |
| 2008-09-24 | CHW | ETF | 8.48 | 8.59 | 8.3 | 8.52 | 203330.0 |
| 2008-09-24 | CHY | ETF | 10.15 | 10.43 | 9.79 | 10.1 | 321547.0 |
| 2008-09-24 | CMF | ETF | 50.585 | 50.59 | 50.175 | 50.25 | 34680.0 |
| 2008-09-24 | CN | ETF | 45.23 | 45.23 | 43.73 | 44.4 | 254530.0 |
| 2008-09-24 | CNXT | ETF | 3.45 | 3.66 | 3.25 | 3.26 | 490206.0 |
| 2008-09-24 | COW | ETF | 40.94 | 41.3799 | 40.94 | 41.26 | 46054.0 |
| 2008-09-24 | CPI | ETF | 23.5 | 23.5 | 23.45 | 23.45 | 200.0 |
| 2008-09-24 | CPST | ETF | 1.38 | 1.4 | 1.3 | 1.3 | 2412647.0 |
| 2008-09-24 | CSA | ETF | 17.51 | 17.7599 | 17.02 | 17.08 | 148239.0 |
| 2008-09-24 | CSB | ETF | 13.9 | 17.0 | 13.52 | 15.15 | 17700.0 |
| 2008-09-24 | CSD | ETF | 19.01 | 19.27 | 19.01 | 19.07 | 6600.0 |
> showing 50 of 606 rows — these rows as CSV