PREVIEW / etf_daily / 2008-12-02
file: by_date/etf_daily/2008/2008-12-02.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-12-02 | SPY | ETF | 83.47 | 85.49 | 82.04 | 85.27 | 469508400.0 |
| 2008-12-02 | QQQ | ETF | 27.28 | 27.89 | 26.8404 | 27.83 | 181779303.0 |
| 2008-12-02 | IWM | ETF | 42.71 | 44.33 | 41.96 | 44.23 | 81228000.0 |
| 2008-12-02 | DIA | ETF | 82.63 | 84.42 | 81.5 | 84.36 | 29383100.0 |
| 2008-12-02 | GLD | ETF | 76.9 | 77.32 | 76.26 | 76.95 | 6944000.0 |
| 2008-12-02 | TLT | ETF | 108.56 | 110.37 | 108.19 | 109.82 | 3289300.0 |
| 2008-12-02 | AAXJ | ETF | 28.96 | 29.55 | 28.54 | 29.55 | 253300.0 |
| 2008-12-02 | ACWI | ETF | 28.97 | 29.51 | 28.52 | 29.5 | 318200.0 |
| 2008-12-02 | ACWX | ETF | 27.07 | 27.6 | 26.74 | 27.4 | 329480.0 |
| 2008-12-02 | ADRE | ETF | 23.86 | 24.29 | 23.47 | 24.29 | 211662.0 |
| 2008-12-02 | AFK | ETF | 20.0 | 21.32 | 19.95 | 20.55 | 3800.0 |
| 2008-12-02 | AGG | ETF | 99.01 | 99.68 | 98.86 | 99.53 | 641600.0 |
| 2008-12-02 | AGZ | ETF | 105.75 | 105.75 | 105.7363 | 105.7363 | 662.0 |
| 2008-12-02 | AIA | ETF | 22.74 | 23.48 | 22.546 | 23.48 | 20010.0 |
| 2008-12-02 | AIQ | ETF | 35.1 | 35.8 | 33.75 | 34.55 | 81745.0 |
| 2008-12-02 | AIS | ETF | 0.37 | 0.37 | 0.3501 | 0.37 | 67942.0 |
| 2008-12-02 | AIVI | ETF | 33.16 | 34.07 | 32.97 | 33.82 | 23600.0 |
| 2008-12-02 | AOA | ETF | 23.5 | 23.5 | 21.84 | 22.58 | 9000.0 |
| 2008-12-02 | AOK | ETF | 25.23 | 25.23 | 24.66 | 24.74 | 1750.0 |
| 2008-12-02 | AOM | ETF | 24.04 | 24.08 | 24.0 | 24.08 | 600.0 |
| 2008-12-02 | AOR | ETF | 23.1 | 26.8 | 23.05 | 23.79 | 43170.0 |
| 2008-12-02 | ARB | ETF | 13.2 | 13.39 | 12.57 | 13.2 | 817682.0 |
| 2008-12-02 | BAL | ETF | 27.5 | 27.5 | 27.13 | 27.13 | 1750.0 |
| 2008-12-02 | BBH | ETF | 52.1767 | 52.49 | 51.32 | 52.1033 | 380400.0 |
| 2008-12-02 | BIL | ETF | 91.88 | 91.94 | 91.8 | 91.94 | 114650.0 |
| 2008-12-02 | BITS | ETF | 16.44 | 16.76 | 16.24 | 16.6 | 3800.0 |
| 2008-12-02 | BIV | ETF | 75.09 | 75.32 | 74.69 | 75.15 | 155700.0 |
| 2008-12-02 | BJK | ETF | 14.6 | 15.39 | 14.48 | 14.85 | 4500.0 |
| 2008-12-02 | BKF | ETF | 22.32 | 22.6 | 21.88 | 22.56 | 74116.0 |
| 2008-12-02 | BLV | ETF | 72.78 | 73.55 | 72.65 | 73.38 | 8300.0 |
| 2008-12-02 | BMVP | ETF | 9.75 | 9.9433 | 9.6467 | 9.7534 | 46952.0 |
| 2008-12-02 | BND | ETF | 75.83 | 76.41 | 75.53 | 76.3 | 259600.0 |
| 2008-12-02 | BNE | ETF | 3.19 | 3.19 | 2.76 | 2.92 | 208280.0 |
| 2008-12-02 | BOSS | ETF | 13.19 | 13.19 | 12.88 | 12.88 | 300.0 |
| 2008-12-02 | BRF | ETF | 15.0 | 15.0001 | 14.99 | 14.99 | 11000.0 |
| 2008-12-02 | BSV | ETF | 78.55 | 78.67 | 78.2 | 78.62 | 109300.0 |
| 2008-12-02 | BTF | ETF | 43.75 | 45.0 | 43.65 | 44.05 | 22682.0 |
| 2008-12-02 | BWX | ETF | 25.275 | 25.325 | 25.09 | 25.315 | 219828.0 |
| 2008-12-02 | CBON | ETF | 1.95 | 2.0 | 1.86 | 1.88 | 35348.0 |
| 2008-12-02 | CDL | ETF | 0.15 | 0.2 | 0.15 | 0.17 | 603024.0 |
| 2008-12-02 | CEF | ETF | 9.62 | 9.62 | 9.19 | 9.35 | 939000.0 |
| 2008-12-02 | CGO | ETF | 8.36 | 8.36 | 7.82 | 7.91 | 31449.0 |
| 2008-12-02 | CGW | ETF | 13.34 | 13.942 | 13.32 | 13.71 | 70380.0 |
| 2008-12-02 | CHB | ETF | 0.58 | 0.7299 | 0.58 | 0.64 | 1843991.0 |
| 2008-12-02 | CHI | ETF | 7.44 | 7.6 | 7.05 | 7.14 | 193209.0 |
| 2008-12-02 | CHIC | ETF | 4.15 | 4.55 | 4.02 | 4.53 | 261395.0 |
| 2008-12-02 | CHW | ETF | 4.51 | 4.7686 | 4.35 | 4.49 | 241611.0 |
| 2008-12-02 | CHY | ETF | 6.55 | 6.816 | 6.39 | 6.65 | 188809.0 |
| 2008-12-02 | CMF | ETF | 47.75 | 48.45 | 47.725 | 48.375 | 21170.0 |
| 2008-12-02 | CNXT | ETF | 0.97 | 1.09 | 0.9612 | 1.02 | 494155.0 |
> showing 50 of 627 rows — these rows as CSV