PREVIEW / etf_daily / 2008-12-04
file: by_date/etf_daily/2008/2008-12-04.parquet size: 27 KB rows: 623
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-04 | SPY | ETF | 86.06 | 88.05 | 83.74 | 85.3 | 444173800.0 |
| 2008-12-04 | QQQ | ETF | 28.15 | 28.78 | 27.32 | 27.81 | 188924185.0 |
| 2008-12-04 | IWM | ETF | 44.82 | 46.45 | 43.26 | 44.06 | 101436300.0 |
| 2008-12-04 | DIA | ETF | 84.74 | 86.46 | 82.73 | 83.74 | 40456000.0 |
| 2008-12-04 | GLD | ETF | 75.59 | 77.63 | 75.07 | 75.5 | 11827500.0 |
| 2008-12-04 | TLT | ETF | 111.13 | 112.49 | 110.37 | 112.3 | 2825400.0 |
| 2008-12-04 | AAXJ | ETF | 29.42 | 29.7 | 28.11 | 28.98 | 105100.0 |
| 2008-12-04 | ACWI | ETF | 29.28 | 29.8 | 28.62 | 29.29 | 265800.0 |
| 2008-12-04 | ACWX | ETF | 27.13 | 27.35 | 26.18 | 26.64 | 290443.0 |
| 2008-12-04 | ADRE | ETF | 24.01 | 24.55 | 23.22 | 23.6 | 170602.0 |
| 2008-12-04 | AFK | ETF | 20.2 | 20.2 | 19.88 | 19.88 | 300.0 |
| 2008-12-04 | AGG | ETF | 99.62 | 99.87 | 99.02 | 99.87 | 713900.0 |
| 2008-12-04 | AGQ | ETF | 45.78 | 46.2 | 45.6 | 45.6 | 1912.0 |
| 2008-12-04 | AGZ | ETF | 106.45 | 106.45 | 106.098 | 106.27 | 910.0 |
| 2008-12-04 | AIA | ETF | 22.9 | 23.25 | 22.36 | 22.72 | 55087.0 |
| 2008-12-04 | AIQ | ETF | 35.35 | 35.65 | 33.55 | 34.2 | 51125.0 |
| 2008-12-04 | AIS | ETF | 0.36 | 0.36 | 0.34 | 0.36 | 66228.0 |
| 2008-12-04 | AIVI | ETF | 33.6 | 34.46 | 33.02 | 33.32 | 115600.0 |
| 2008-12-04 | AOA | ETF | 22.99 | 24.77 | 22.0 | 22.02 | 373200.0 |
| 2008-12-04 | AOK | ETF | 24.98 | 25.85 | 24.7 | 24.85 | 4000.0 |
| 2008-12-04 | AOM | ETF | 24.41 | 24.48 | 24.168 | 24.168 | 12207.0 |
| 2008-12-04 | AOR | ETF | 23.99 | 25.5 | 23.26 | 23.3 | 34809.0 |
| 2008-12-04 | ARB | ETF | 12.78 | 13.33 | 12.21 | 12.33 | 399953.0 |
| 2008-12-04 | BAL | ETF | 26.0 | 26.0 | 26.0 | 26.0 | 2000.0 |
| 2008-12-04 | BBH | ETF | 52.5133 | 53.07 | 51.84 | 52.5 | 266700.0 |
| 2008-12-04 | BIL | ETF | 91.8 | 91.86 | 91.76 | 91.76 | 106250.0 |
| 2008-12-04 | BITS | ETF | 16.4 | 16.68 | 15.36 | 16.68 | 2925.0 |
| 2008-12-04 | BIV | ETF | 75.48 | 76.31 | 75.0 | 76.31 | 66100.0 |
| 2008-12-04 | BKF | ETF | 22.74 | 22.74 | 21.56 | 21.56 | 21920.0 |
| 2008-12-04 | BLV | ETF | 74.11 | 74.86 | 73.57 | 74.85 | 18600.0 |
| 2008-12-04 | BMVP | ETF | 10.03 | 10.21 | 9.72 | 9.83 | 36881.0 |
| 2008-12-04 | BND | ETF | 76.0 | 76.4 | 75.67 | 76.27 | 261300.0 |
| 2008-12-04 | BNE | ETF | 3.05 | 3.27 | 2.91 | 3.13 | 196722.0 |
| 2008-12-04 | BRF | ETF | 15.0 | 15.01 | 14.99 | 15.01 | 9500.0 |
| 2008-12-04 | BSV | ETF | 78.73 | 78.85 | 78.21 | 78.81 | 140300.0 |
| 2008-12-04 | BTF | ETF | 45.75 | 46.95 | 44.599999999999994 | 45.14999999999999 | 37366.8 |
| 2008-12-04 | BWX | ETF | 25.35 | 25.39 | 25.2255 | 25.2407 | 243736.0 |
| 2008-12-04 | CBON | ETF | 2.0 | 2.25 | 1.97 | 2.1 | 35032.0 |
| 2008-12-04 | CDL | ETF | 0.17 | 0.18 | 0.16 | 0.17 | 611266.0 |
| 2008-12-04 | CEF | ETF | 9.35 | 9.48 | 9.2 | 9.29 | 428800.0 |
| 2008-12-04 | CGO | ETF | 7.85 | 8.0956 | 7.75 | 7.99 | 28679.0 |
| 2008-12-04 | CGW | ETF | 13.92 | 13.93 | 13.32 | 13.41 | 104903.0 |
| 2008-12-04 | CHB | ETF | 0.63 | 0.75 | 0.54 | 0.57 | 2829454.0 |
| 2008-12-04 | CHI | ETF | 7.46 | 7.46 | 7.0 | 7.0999 | 225716.0 |
| 2008-12-04 | CHIC | ETF | 4.97 | 6.0 | 4.97 | 5.71 | 345442.0 |
| 2008-12-04 | CHW | ETF | 4.75 | 4.8 | 4.51 | 4.58 | 195690.0 |
| 2008-12-04 | CHY | ETF | 7.0 | 7.0 | 6.38 | 6.6 | 207573.0 |
| 2008-12-04 | CMF | ETF | 48.345 | 49.02 | 48.1 | 48.975 | 149682.0 |
| 2008-12-04 | CNXT | ETF | 1.0 | 1.12 | 0.98 | 0.99 | 615891.0 |
| 2008-12-04 | COW | ETF | 33.61 | 33.8288 | 33.24 | 33.3 | 29001.0 |
> showing 50 of 623 rows — these rows as CSV