PREVIEW / etf_daily / 2008-10-21
file: by_date/etf_daily/2008/2008-10-21.parquet size: 27 KB rows: 608
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-21 | SPY | ETF | 96.97 | 98.64 | 95.22 | 95.86 | 356502000.0 |
| 2008-10-21 | QQQ | ETF | 32.66 | 33.2572 | 31.48 | 31.48 | 239932393.0 |
| 2008-10-21 | IWM | ETF | 53.95 | 54.59 | 52.82 | 53.18 | 83005200.0 |
| 2008-10-21 | DIA | ETF | 91.54 | 92.8 | 89.97 | 90.38 | 26527300.0 |
| 2008-10-21 | GLD | ETF | 75.9 | 76.94 | 74.89 | 76.03 | 10859600.0 |
| 2008-10-21 | TLT | ETF | 95.09 | 95.99 | 94.74 | 95.12 | 1243700.0 |
| 2008-10-21 | AAXJ | ETF | 33.9 | 33.9 | 32.67 | 32.67 | 131000.0 |
| 2008-10-21 | ACWI | ETF | 34.15 | 34.19 | 33.1 | 33.19 | 53900.0 |
| 2008-10-21 | ACWX | ETF | 31.75 | 31.99 | 30.75 | 30.88 | 103088.0 |
| 2008-10-21 | ADRE | ETF | 27.9 | 28.4 | 27.1201 | 27.18 | 280746.0 |
| 2008-10-21 | AFK | ETF | 25.5 | 25.5 | 25.05 | 25.05 | 1600.0 |
| 2008-10-21 | AGG | ETF | 96.41 | 97.22 | 94.6 | 96.61 | 571000.0 |
| 2008-10-21 | AIA | ETF | 27.0 | 27.0 | 25.93 | 25.93 | 49100.0 |
| 2008-10-21 | AIQ | ETF | 41.5 | 42.6 | 41.0 | 42.0 | 50444.0 |
| 2008-10-21 | AIS | ETF | 0.5 | 0.5 | 0.44 | 0.49 | 23474.0 |
| 2008-10-21 | AIVI | ETF | 39.99 | 40.49 | 39.0 | 39.0 | 20300.0 |
| 2008-10-21 | ARB | ETF | 34.98 | 36.73 | 32.9 | 33.72 | 732549.0 |
| 2008-10-21 | BAL | ETF | 30.26 | 30.26 | 30.26 | 30.26 | 100.0 |
| 2008-10-21 | BBH | ETF | 57.0 | 58.2467 | 56.66 | 56.66 | 1162800.0 |
| 2008-10-21 | BIL | ETF | 91.86 | 91.88 | 91.72 | 91.86 | 98050.0 |
| 2008-10-21 | BITS | ETF | 16.92 | 17.08 | 16.8 | 16.88 | 838.0 |
| 2008-10-21 | BIV | ETF | 71.56 | 71.83 | 71.14 | 71.72 | 50500.0 |
| 2008-10-21 | BJK | ETF | 18.7 | 18.7 | 18.1 | 18.1 | 1800.0 |
| 2008-10-21 | BKF | ETF | 25.48 | 26.6356 | 24.9799 | 24.98 | 44090.0 |
| 2008-10-21 | BLV | ETF | 67.09 | 67.94 | 67.09 | 67.45 | 11200.0 |
| 2008-10-21 | BMVP | ETF | 10.98 | 11.25 | 10.88 | 10.88 | 36163.0 |
| 2008-10-21 | BND | ETF | 74.59 | 75.05 | 73.9 | 74.97 | 582600.0 |
| 2008-10-21 | BNE | ETF | 6.56 | 6.75 | 6.34 | 6.35 | 84442.0 |
| 2008-10-21 | BOSS | ETF | 15.65 | 16.45 | 15.65 | 16.45 | 200.0 |
| 2008-10-21 | BRF | ETF | 14.7999 | 14.82 | 14.7999 | 14.8199 | 4725.0 |
| 2008-10-21 | BSV | ETF | 75.39 | 76.07 | 75.38 | 75.45 | 79500.0 |
| 2008-10-21 | BTF | ETF | 71.05 | 72.85 | 69.74999999999999 | 69.74999999999999 | 36279.8 |
| 2008-10-21 | BWX | ETF | 24.975 | 24.975 | 24.2 | 24.9175 | 744864.0 |
| 2008-10-21 | CBON | ETF | 4.0 | 4.24 | 4.0 | 4.11 | 34012.0 |
| 2008-10-21 | CDL | ETF | 0.25 | 0.27 | 0.2 | 0.2 | 1638198.0 |
| 2008-10-21 | CEF | ETF | 9.12 | 9.34 | 9.02 | 9.21 | 991700.0 |
| 2008-10-21 | CGO | ETF | 9.99 | 10.34 | 9.9 | 10.06 | 62389.0 |
| 2008-10-21 | CGW | ETF | 16.5 | 16.5 | 15.69 | 15.82 | 55685.0 |
| 2008-10-21 | CHB | ETF | 3.51 | 3.9 | 3.42 | 3.42 | 696047.0 |
| 2008-10-21 | CHI | ETF | 9.6 | 9.7 | 8.81 | 8.86 | 341748.0 |
| 2008-10-21 | CHIC | ETF | 7.73 | 7.98 | 7.28 | 7.52 | 511603.0 |
| 2008-10-21 | CHW | ETF | 6.35 | 6.6 | 6.35 | 6.5 | 158856.0 |
| 2008-10-21 | CHY | ETF | 8.79 | 8.91 | 8.7 | 8.8 | 284141.0 |
| 2008-10-21 | CMF | ETF | 46.72 | 47.6 | 46.4875 | 47.6 | 13822.0 |
| 2008-10-21 | CNXT | ETF | 2.5 | 2.6 | 2.46 | 2.48 | 322640.0 |
| 2008-10-21 | COW | ETF | 35.74 | 36.56 | 35.74 | 36.46 | 27745.0 |
| 2008-10-21 | CPST | ETF | 1.36 | 1.39 | 1.33 | 1.33 | 914499.0 |
| 2008-10-21 | CSA | ETF | 13.0 | 13.25 | 12.25 | 12.32 | 164440.0 |
| 2008-10-21 | CSB | ETF | 14.9 | 15.49 | 14.7 | 15.4 | 14977.0 |
| 2008-10-21 | CSD | ETF | 13.97 | 13.97 | 13.96 | 13.96 | 300.0 |
> showing 50 of 608 rows — these rows as CSV