PREVIEW / etf_daily / 2008-10-24
file: by_date/etf_daily/2008/2008-10-24.parquet size: 27 KB rows: 609
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-10-24 | SPY | ETF | 84.06 | 89.92 | 84.0 | 87.04 | 545812600.0 |
| 2008-10-24 | QQQ | ETF | 28.13 | 30.25 | 28.09 | 29.51 | 322129446.0 |
| 2008-10-24 | IWM | ETF | 44.95 | 48.2 | 44.89 | 47.17 | 105748800.0 |
| 2008-10-24 | DIA | ETF | 80.54 | 85.85 | 80.15 | 83.09 | 49331600.0 |
| 2008-10-24 | GLD | ETF | 69.3 | 73.93 | 69.07 | 72.21 | 22471800.0 |
| 2008-10-24 | TLT | ETF | 98.82 | 99.05 | 96.45 | 96.73 | 1495400.0 |
| 2008-10-24 | AAXJ | ETF | 28.13 | 28.49 | 27.33 | 27.65 | 235800.0 |
| 2008-10-24 | ACWI | ETF | 29.64 | 30.11 | 26.64 | 29.61 | 72500.0 |
| 2008-10-24 | ACWX | ETF | 26.61 | 27.58 | 26.25 | 27.09 | 72033.0 |
| 2008-10-24 | ADRE | ETF | 21.12 | 22.84 | 20.94 | 22.17 | 489046.0 |
| 2008-10-24 | AFK | ETF | 22.5 | 22.5 | 22.5 | 22.5 | 200.0 |
| 2008-10-24 | AGG | ETF | 96.15 | 96.35 | 94.89 | 95.2 | 400100.0 |
| 2008-10-24 | AIA | ETF | 22.25 | 22.34 | 21.616 | 22.34 | 6375.0 |
| 2008-10-24 | AIQ | ETF | 35.95 | 37.15 | 35.0 | 36.5 | 26473.0 |
| 2008-10-24 | AIS | ETF | 0.4 | 0.48 | 0.4 | 0.48 | 18100.0 |
| 2008-10-24 | AIVI | ETF | 34.2 | 35.31 | 34.0 | 35.12 | 18000.0 |
| 2008-10-24 | ARB | ETF | 28.76 | 29.18 | 27.03 | 28.75 | 624954.0 |
| 2008-10-24 | BAL | ETF | 29.14 | 29.42 | 29.14 | 29.31 | 300.0 |
| 2008-10-24 | BBH | ETF | 53.3333 | 55.9667 | 53.1667 | 54.8733 | 693300.0 |
| 2008-10-24 | BIL | ETF | 91.74 | 92.04 | 91.74 | 91.76 | 168150.0 |
| 2008-10-24 | BITS | ETF | 16.0 | 16.92 | 14.76 | 16.0 | 5825.0 |
| 2008-10-24 | BIV | ETF | 72.11 | 72.11 | 70.83 | 70.83 | 37500.0 |
| 2008-10-24 | BJK | ETF | 16.0 | 16.0 | 14.63 | 14.63 | 4600.0 |
| 2008-10-24 | BKF | ETF | 18.82 | 20.2 | 18.76 | 19.71 | 91410.0 |
| 2008-10-24 | BLV | ETF | 68.29 | 68.77 | 67.54 | 68.3 | 18000.0 |
| 2008-10-24 | BMVP | ETF | 9.437 | 10.282 | 9.247 | 10.124 | 38882.0 |
| 2008-10-24 | BND | ETF | 75.12 | 75.12 | 73.19 | 74.1 | 283800.0 |
| 2008-10-24 | BNE | ETF | 5.97 | 6.58 | 5.97 | 6.09 | 137698.0 |
| 2008-10-24 | BRF | ETF | 14.79 | 14.79 | 14.77 | 14.77 | 6700.0 |
| 2008-10-24 | BSV | ETF | 76.2 | 76.35 | 74.73 | 74.75 | 130800.0 |
| 2008-10-24 | BTF | ETF | 61.95 | 64.95 | 60.05 | 63.49999999999999 | 42303.0 |
| 2008-10-24 | BWX | ETF | 24.7 | 24.7 | 23.84 | 24.275 | 200648.0 |
| 2008-10-24 | CBON | ETF | 3.01 | 3.02 | 2.75 | 2.75 | 249307.0 |
| 2008-10-24 | CDL | ETF | 0.24 | 0.32 | 0.22 | 0.305 | 1372856.0 |
| 2008-10-24 | CEF | ETF | 8.0 | 8.88 | 7.76 | 8.72 | 1780500.0 |
| 2008-10-24 | CGO | ETF | 8.8 | 9.02 | 8.55 | 8.8799 | 19234.0 |
| 2008-10-24 | CGW | ETF | 13.81 | 14.078 | 13.1101 | 13.834 | 140473.0 |
| 2008-10-24 | CHB | ETF | 2.07 | 2.5 | 1.855 | 2.17 | 1713952.0 |
| 2008-10-24 | CHI | ETF | 8.79 | 8.99 | 8.59 | 8.79 | 176081.0 |
| 2008-10-24 | CHIC | ETF | 7.03 | 7.44 | 6.99 | 7.13 | 516194.0 |
| 2008-10-24 | CHW | ETF | 5.61 | 5.87 | 5.56 | 5.81 | 127697.0 |
| 2008-10-24 | CHY | ETF | 8.49 | 8.5 | 8.18 | 8.4 | 104817.0 |
| 2008-10-24 | CMF | ETF | 49.625 | 49.625 | 48.745 | 48.745 | 1346.0 |
| 2008-10-24 | CNXT | ETF | 1.75 | 1.98 | 1.5 | 1.75 | 559773.0 |
| 2008-10-24 | COW | ETF | 34.97 | 35.4899 | 34.25 | 35.14 | 65271.0 |
| 2008-10-24 | CPI | ETF | 23.25 | 23.25 | 23.25 | 23.25 | 100.0 |
| 2008-10-24 | CPST | ETF | 1.1 | 1.21 | 1.01 | 1.17 | 1469470.0 |
| 2008-10-24 | CSA | ETF | 9.97 | 10.47 | 9.8 | 10.12 | 91421.0 |
| 2008-10-24 | CSB | ETF | 12.0 | 15.48 | 11.89 | 13.6 | 63700.0 |
| 2008-10-24 | CSD | ETF | 11.51 | 12.05 | 11.51 | 12.05 | 6500.0 |
> showing 50 of 609 rows — these rows as CSV