PREVIEW / etf_daily / 2008-11-24
file: by_date/etf_daily/2008/2008-11-24.parquet size: 28 KB rows: 627
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-11-24 | SPY | ETF | 81.92 | 86.99 | 80.36 | 85.03 | 523305300.0 |
| 2008-11-24 | QQQ | ETF | 27.22 | 28.64 | 26.98 | 28.3 | 225212492.0 |
| 2008-11-24 | IWM | ETF | 41.2 | 44.04 | 40.73 | 43.5 | 97052300.0 |
| 2008-11-24 | DIA | ETF | 81.96 | 85.97 | 81.03 | 83.9 | 48461300.0 |
| 2008-11-24 | GLD | ETF | 80.45 | 81.72 | 80.38 | 80.91 | 19885200.0 |
| 2008-11-24 | TLT | ETF | 102.15 | 102.29 | 101.0 | 101.31 | 1587300.0 |
| 2008-11-24 | AAXJ | ETF | 28.59 | 30.05 | 27.81 | 29.46 | 207600.0 |
| 2008-11-24 | ACWI | ETF | 28.22 | 30.42 | 28.22 | 29.86 | 106300.0 |
| 2008-11-24 | ACWX | ETF | 26.13 | 27.99 | 26.13 | 27.69 | 278300.0 |
| 2008-11-24 | ADRE | ETF | 22.98 | 24.65 | 22.87 | 24.08 | 776614.0 |
| 2008-11-24 | AFK | ETF | 20.68 | 21.4322 | 20.68 | 21.4322 | 340.0 |
| 2008-11-24 | AGG | ETF | 97.11 | 97.76 | 96.04 | 96.61 | 1524000.0 |
| 2008-11-24 | AGZ | ETF | 102.61 | 102.61 | 102.04 | 102.04 | 1143.0 |
| 2008-11-24 | AIA | ETF | 21.96 | 23.22 | 21.96 | 23.22 | 37212.0 |
| 2008-11-24 | AIQ | ETF | 37.5 | 37.8 | 36.05 | 37.4 | 61098.0 |
| 2008-11-24 | AIS | ETF | 0.32 | 0.4 | 0.32 | 0.4 | 30056.0 |
| 2008-11-24 | AIVI | ETF | 32.32 | 34.01 | 32.22 | 34.0 | 32000.0 |
| 2008-11-24 | AOA | ETF | 18.64 | 22.51 | 18.64 | 22.51 | 10700.0 |
| 2008-11-24 | AOM | ETF | 23.7 | 25.1301 | 23.7 | 25.1301 | 1700.0 |
| 2008-11-24 | ARB | ETF | 14.12 | 14.54 | 13.59 | 14.36 | 669287.0 |
| 2008-11-24 | BBH | ETF | 52.1267 | 54.2433 | 52.0767 | 53.49 | 848700.0 |
| 2008-11-24 | BIL | ETF | 91.94 | 92.2 | 91.86 | 91.88 | 253450.0 |
| 2008-11-24 | BITS | ETF | 16.0 | 16.88 | 16.0 | 16.0 | 2388.0 |
| 2008-11-24 | BIV | ETF | 73.59 | 73.59 | 73.03 | 73.16 | 103600.0 |
| 2008-11-24 | BJK | ETF | 14.88 | 15.76 | 14.13 | 15.24 | 4600.0 |
| 2008-11-24 | BKF | ETF | 20.59 | 23.01 | 20.59 | 22.6 | 84787.0 |
| 2008-11-24 | BLV | ETF | 70.26 | 70.86 | 70.11 | 70.42 | 12600.0 |
| 2008-11-24 | BMVP | ETF | 9.4533 | 10.0805 | 9.4267 | 9.8767 | 292577.0 |
| 2008-11-24 | BND | ETF | 74.0 | 74.9 | 73.76 | 74.18 | 410200.0 |
| 2008-11-24 | BNE | ETF | 2.0 | 2.23 | 1.94 | 2.16 | 382613.0 |
| 2008-11-24 | BRF | ETF | 14.91 | 14.93 | 14.9 | 14.926 | 15400.0 |
| 2008-11-24 | BSV | ETF | 77.98 | 78.04 | 77.5 | 77.8 | 154700.0 |
| 2008-11-24 | BTF | ETF | 38.25 | 42.99999999999999 | 38.25 | 41.105999999999995 | 32912.0 |
| 2008-11-24 | BWX | ETF | 24.78 | 24.975 | 24.725 | 24.975 | 669552.0 |
| 2008-11-24 | CBON | ETF | 2.43 | 2.99 | 2.35 | 2.37 | 60926.0 |
| 2008-11-24 | CDL | ETF | 0.24 | 0.24 | 0.1713 | 0.19 | 1536398.0 |
| 2008-11-24 | CEF | ETF | 9.94 | 10.27 | 9.76 | 10.02 | 1283800.0 |
| 2008-11-24 | CGO | ETF | 7.58 | 8.45 | 7.52 | 8.2999 | 36817.0 |
| 2008-11-24 | CGW | ETF | 13.15 | 14.1755 | 13.15 | 14.03 | 47114.0 |
| 2008-11-24 | CHB | ETF | 0.71 | 0.76 | 0.61 | 0.7 | 1128799.0 |
| 2008-11-24 | CHI | ETF | 6.18 | 6.75 | 6.18 | 6.62 | 279342.0 |
| 2008-11-24 | CHIC | ETF | 4.67 | 4.86 | 4.42 | 4.69 | 555708.0 |
| 2008-11-24 | CHW | ETF | 4.3 | 4.68 | 4.3 | 4.68 | 247598.0 |
| 2008-11-24 | CHY | ETF | 5.9 | 6.29 | 5.9 | 6.25 | 358509.0 |
| 2008-11-24 | CMF | ETF | 49.475 | 49.48 | 48.405 | 49.36 | 18594.0 |
| 2008-11-24 | CNXT | ETF | 0.6925 | 0.74 | 0.64 | 0.71 | 502886.0 |
| 2008-11-24 | COW | ETF | 34.24 | 34.89 | 33.1 | 34.81 | 14113.0 |
| 2008-11-24 | CPI | ETF | 22.65 | 22.65 | 21.95 | 21.95 | 1300.0 |
| 2008-11-24 | CPST | ETF | 0.72 | 0.75 | 0.7 | 0.75 | 1482507.0 |
| 2008-11-24 | CSA | ETF | 8.14 | 9.09 | 8.05 | 8.47 | 150324.0 |
> showing 50 of 627 rows — these rows as CSV