PREVIEW / etf_daily / 2008-10-02
file: by_date/etf_daily/2008/2008-10-02.parquet size: 27 KB rows: 613
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-02 | SPY | ETF | 114.95 | 115.11 | 111.06 | 111.85 | 365337800.0 |
| 2008-10-02 | QQQ | ETF | 38.25 | 38.25 | 36.64 | 36.75 | 192185789.0 |
| 2008-10-02 | IWM | ETF | 66.63 | 67.03 | 63.42 | 63.58 | 116143300.0 |
| 2008-10-02 | DIA | ETF | 107.5 | 107.65 | 104.38 | 105.27 | 19546500.0 |
| 2008-10-02 | GLD | ETF | 84.56 | 84.66 | 81.62 | 82.33 | 22651000.0 |
| 2008-10-02 | TLT | ETF | 96.57 | 96.85 | 96.07 | 96.55 | 931900.0 |
| 2008-10-02 | AAXJ | ETF | 41.06 | 41.09 | 40.7 | 40.7 | 19500.0 |
| 2008-10-02 | ACWI | ETF | 41.2 | 41.2 | 39.67 | 39.72 | 25300.0 |
| 2008-10-02 | ACWX | ETF | 38.81 | 38.82 | 37.72 | 37.72 | 47618.0 |
| 2008-10-02 | ADRE | ETF | 36.64 | 36.64 | 34.19 | 34.446 | 422807.0 |
| 2008-10-02 | AFK | ETF | 31.1 | 31.1 | 30.49 | 30.49 | 1050.0 |
| 2008-10-02 | AGG | ETF | 97.45 | 98.42 | 96.92 | 97.88 | 400400.0 |
| 2008-10-02 | AIA | ETF | 32.71 | 32.71 | 31.74 | 31.8 | 7427.0 |
| 2008-10-02 | AIQ | ETF | 49.25 | 50.25 | 49.25 | 50.05 | 46960.0 |
| 2008-10-02 | AIS | ETF | 0.67 | 0.69 | 0.63 | 0.63 | 30600.0 |
| 2008-10-02 | AIVI | ETF | 50.13 | 50.14 | 48.19 | 48.37 | 88000.0 |
| 2008-10-02 | ARB | ETF | 43.64 | 44.39 | 41.82 | 42.55 | 486795.0 |
| 2008-10-02 | BAL | ETF | 35.97 | 36.63 | 35.97 | 36.63 | 2322.0 |
| 2008-10-02 | BBH | ETF | 60.0 | 60.75 | 59.59 | 59.8733 | 126000.0 |
| 2008-10-02 | BIL | ETF | 91.98 | 92.0 | 91.86 | 91.96 | 193650.0 |
| 2008-10-02 | BITS | ETF | 20.92 | 21.0 | 19.92 | 20.96 | 1625.0 |
| 2008-10-02 | BIV | ETF | 73.57 | 74.21 | 73.5 | 74.21 | 35600.0 |
| 2008-10-02 | BJK | ETF | 23.83 | 23.83 | 22.81 | 23.1 | 500.0 |
| 2008-10-02 | BKF | ETF | 34.63 | 34.63 | 32.2854 | 32.32 | 98770.0 |
| 2008-10-02 | BLV | ETF | 71.0 | 71.72 | 70.7 | 71.25 | 5100.0 |
| 2008-10-02 | BMVP | ETF | 13.26 | 13.26 | 12.76 | 12.81 | 55780.0 |
| 2008-10-02 | BND | ETF | 75.66 | 76.74 | 75.06 | 76.41 | 300800.0 |
| 2008-10-02 | BNE | ETF | 11.02 | 11.13 | 10.65 | 10.97 | 414868.0 |
| 2008-10-02 | BRF | ETF | 14.62 | 14.752 | 14.56 | 14.67 | 16100.0 |
| 2008-10-02 | BSV | ETF | 76.34 | 76.55 | 75.73 | 76.38 | 115300.0 |
| 2008-10-02 | BTF | ETF | 75.25 | 75.3 | 74.1 | 74.89999999999999 | 4120.0 |
| 2008-10-02 | BWX | ETF | 25.56 | 26.105 | 25.41 | 25.995 | 141124.0 |
| 2008-10-02 | CBON | ETF | 7.43 | 7.44 | 6.27 | 6.75 | 101418.0 |
| 2008-10-02 | CDL | ETF | 0.75 | 0.83 | 0.7 | 0.7 | 5132366.0 |
| 2008-10-02 | CEF | ETF | 10.69 | 10.69 | 10.0 | 10.11 | 1939200.0 |
| 2008-10-02 | CGO | ETF | 11.4 | 11.4 | 10.71 | 10.886 | 17802.0 |
| 2008-10-02 | CGW | ETF | 19.75 | 19.75 | 18.46 | 18.53 | 79366.0 |
| 2008-10-02 | CHB | ETF | 5.85 | 5.99 | 5.38 | 5.53 | 1081740.0 |
| 2008-10-02 | CHI | ETF | 10.89 | 10.89 | 9.78 | 10.01 | 199455.0 |
| 2008-10-02 | CHIC | ETF | 10.2 | 10.59 | 9.88 | 9.93 | 494743.0 |
| 2008-10-02 | CHW | ETF | 7.91 | 7.97 | 7.5 | 7.72 | 216731.0 |
| 2008-10-02 | CHY | ETF | 10.22 | 10.2699 | 10.0 | 10.15 | 182862.0 |
| 2008-10-02 | CMF | ETF | 49.86 | 50.84 | 49.855 | 50.495 | 10626.0 |
| 2008-10-02 | CN | ETF | 43.95 | 43.95 | 40.86 | 41.17 | 162405.0 |
| 2008-10-02 | CNXT | ETF | 3.73 | 3.73 | 3.45 | 3.5 | 557820.0 |
| 2008-10-02 | COW | ETF | 39.2 | 39.2601 | 38.13 | 38.39 | 133249.0 |
| 2008-10-02 | CPST | ETF | 1.28 | 1.39 | 1.25 | 1.27 | 4798937.0 |
| 2008-10-02 | CSA | ETF | 16.24 | 16.46 | 15.0 | 15.64 | 170774.0 |
| 2008-10-02 | CSB | ETF | 14.25 | 14.25 | 13.5 | 13.5 | 13040.0 |
| 2008-10-02 | CSD | ETF | 17.45 | 17.46 | 16.78 | 16.78 | 5700.0 |
> showing 50 of 613 rows — these rows as CSV