PREVIEW / etf_daily / 2008-12-12
file: by_date/etf_daily/2008/2008-12-12.parquet size: 28 KB rows: 638
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-12 | SPY | ETF | 85.55 | 89.07 | 85.2 | 88.99 | 415060400.0 |
| 2008-12-12 | QQQ | ETF | 28.69 | 29.86 | 28.47 | 29.68 | 158613787.0 |
| 2008-12-12 | IWM | ETF | 44.16 | 47.0 | 44.02 | 46.89 | 97291600.0 |
| 2008-12-12 | DIA | ETF | 83.51 | 87.03 | 83.23 | 86.36 | 34290400.0 |
| 2008-12-12 | GLD | ETF | 80.55 | 81.63 | 80.0 | 80.81 | 12538500.0 |
| 2008-12-12 | TLT | ETF | 112.54 | 112.56 | 110.34 | 112.37 | 2547100.0 |
| 2008-12-12 | AAXJ | ETF | 32.6 | 33.43 | 32.07 | 33.31 | 143600.0 |
| 2008-12-12 | ACWI | ETF | 30.6 | 31.51 | 30.13 | 31.32 | 607800.0 |
| 2008-12-12 | ACWX | ETF | 28.75 | 29.7 | 28.59 | 29.5 | 309402.0 |
| 2008-12-12 | ADRE | ETF | 26.41 | 27.4 | 26.18 | 27.35 | 350899.0 |
| 2008-12-12 | AFK | ETF | 21.0 | 21.0 | 21.0 | 21.0 | 100.0 |
| 2008-12-12 | AGG | ETF | 100.6 | 100.65 | 99.7 | 100.49 | 679800.0 |
| 2008-12-12 | AGQ | ETF | 51.74 | 53.72 | 51.16 | 52.76 | 5600.0 |
| 2008-12-12 | AGZ | ETF | 107.46 | 107.46 | 106.65 | 107.25 | 1735.0 |
| 2008-12-12 | AIA | ETF | 25.48 | 26.16 | 25.34 | 25.98 | 10709.0 |
| 2008-12-12 | AIQ | ETF | 31.45 | 33.15 | 30.9 | 33.15 | 27483.0 |
| 2008-12-12 | AIS | ETF | 0.36 | 0.37 | 0.34 | 0.37 | 26200.0 |
| 2008-12-12 | AIVI | ETF | 35.57 | 36.46 | 35.44 | 36.07 | 56300.0 |
| 2008-12-12 | AOA | ETF | 22.92 | 23.5 | 22.92 | 23.23 | 10000.0 |
| 2008-12-12 | AOK | ETF | 25.49 | 25.49 | 24.87 | 25.157 | 2578.0 |
| 2008-12-12 | AOM | ETF | 24.5 | 24.81 | 24.5 | 24.81 | 3902.0 |
| 2008-12-12 | AOR | ETF | 23.8 | 24.0 | 23.8 | 24.0 | 572.0 |
| 2008-12-12 | ARB | ETF | 10.94 | 11.45 | 10.77 | 11.02 | 475924.0 |
| 2008-12-12 | BAL | ETF | 25.66 | 25.66 | 25.5 | 25.5 | 2100.0 |
| 2008-12-12 | BBH | ETF | 53.0 | 54.4667 | 52.1133 | 54.4667 | 205200.0 |
| 2008-12-12 | BIL | ETF | 91.74 | 91.84 | 91.74 | 91.74 | 171400.0 |
| 2008-12-12 | BITS | ETF | 17.12 | 17.48 | 16.4 | 17.36 | 1486.0 |
| 2008-12-12 | BIV | ETF | 75.59 | 75.99 | 74.8 | 75.99 | 103900.0 |
| 2008-12-12 | BJK | ETF | 16.28 | 16.28 | 16.28 | 16.28 | 100.0 |
| 2008-12-12 | BKF | ETF | 24.55 | 25.57 | 23.82 | 25.443 | 38655.0 |
| 2008-12-12 | BLV | ETF | 75.13 | 75.15 | 73.92 | 74.84 | 13300.0 |
| 2008-12-12 | BMVP | ETF | 10.0167 | 10.3628 | 9.8667 | 10.31 | 97178.0 |
| 2008-12-12 | BND | ETF | 76.19 | 76.72 | 75.76 | 76.06 | 542800.0 |
| 2008-12-12 | BNE | ETF | 3.51 | 3.75 | 3.38 | 3.6 | 171905.0 |
| 2008-12-12 | BOSS | ETF | 12.75 | 12.79 | 12.75 | 12.79 | 400.0 |
| 2008-12-12 | BSV | ETF | 78.7 | 78.98 | 78.11 | 78.85 | 103800.0 |
| 2008-12-12 | BTF | ETF | 45.449999999999996 | 47.85 | 45.05 | 47.5 | 8912.4 |
| 2008-12-12 | BWX | ETF | 26.0 | 26.0042 | 25.75 | 25.885 | 306524.0 |
| 2008-12-12 | CBON | ETF | 2.35 | 2.35 | 2.13 | 2.25 | 139754.0 |
| 2008-12-12 | CDL | ETF | 0.1601 | 0.18 | 0.15 | 0.17 | 735126.0 |
| 2008-12-12 | CEF | ETF | 9.86 | 10.2 | 9.8 | 9.97 | 590800.0 |
| 2008-12-12 | CGO | ETF | 8.23 | 8.63 | 8.19 | 8.4 | 32965.0 |
| 2008-12-12 | CGW | ETF | 14.0 | 14.78 | 14.0 | 14.4132 | 52364.0 |
| 2008-12-12 | CHB | ETF | 1.01 | 1.1 | 0.83 | 0.85 | 994693.0 |
| 2008-12-12 | CHI | ETF | 7.2 | 7.63 | 7.06 | 7.37 | 204837.0 |
| 2008-12-12 | CHIC | ETF | 5.01 | 5.46 | 5.01 | 5.46 | 193483.0 |
| 2008-12-12 | CHW | ETF | 4.74 | 4.97 | 4.65 | 4.86 | 183971.0 |
| 2008-12-12 | CHY | ETF | 6.65 | 6.78 | 6.54 | 6.76 | 280999.0 |
| 2008-12-12 | CMF | ETF | 48.274 | 48.995 | 48.035 | 48.9775 | 32174.0 |
| 2008-12-12 | CNXT | ETF | 1.37 | 1.4 | 1.35 | 1.4 | 316577.0 |
> showing 50 of 638 rows — these rows as CSV