PREVIEW / etf_daily / 2008-08-06
file: by_date/etf_daily/2008/2008-08-06.parquet size: 27 KB rows: 606
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-08-06 | SPY | ETF | 128.02 | 129.3 | 127.48 | 128.93 | 209555400.0 |
| 2008-08-06 | QQQ | ETF | 45.93 | 46.81 | 45.58 | 46.63 | 133463695.0 |
| 2008-08-06 | IWM | ETF | 71.7 | 72.66 | 71.2 | 72.32 | 79587900.0 |
| 2008-08-06 | DIA | ETF | 115.53 | 116.88 | 115.24 | 116.49 | 17770900.0 |
| 2008-08-06 | GLD | ETF | 86.8 | 87.0 | 86.01 | 86.64 | 12404200.0 |
| 2008-08-06 | TLT | ETF | 90.41 | 90.41 | 89.82 | 90.28 | 3139500.0 |
| 2008-08-06 | ACWI | ETF | 47.79 | 48.12 | 47.65 | 48.12 | 8200.0 |
| 2008-08-06 | ACWX | ETF | 47.49 | 48.07 | 47.39 | 47.95 | 4656.0 |
| 2008-08-06 | ADRE | ETF | 46.08 | 47.098 | 46.08 | 46.99 | 406747.0 |
| 2008-08-06 | AFK | ETF | 38.75 | 39.47 | 38.75 | 39.4699 | 53548.0 |
| 2008-08-06 | AGG | ETF | 99.45 | 99.45 | 98.98 | 99.32 | 463000.0 |
| 2008-08-06 | AIA | ETF | 40.72 | 41.08 | 40.62 | 41.065 | 29522.0 |
| 2008-08-06 | AIQ | ETF | 53.95 | 54.85 | 53.3 | 53.45 | 78145.0 |
| 2008-08-06 | AIS | ETF | 0.77 | 0.81 | 0.77 | 0.8 | 33750.0 |
| 2008-08-06 | AIVI | ETF | 59.77 | 60.58 | 59.76 | 60.5 | 39600.0 |
| 2008-08-06 | ARB | ETF | 47.5 | 48.5 | 46.82 | 48.04 | 199050.0 |
| 2008-08-06 | BAL | ETF | 43.55 | 43.55 | 43.25 | 43.41 | 3800.0 |
| 2008-08-06 | BBH | ETF | 66.0033 | 66.8 | 66.0 | 66.6 | 655200.0 |
| 2008-08-06 | BIL | ETF | 91.7 | 91.76 | 91.68 | 91.7 | 75400.0 |
| 2008-08-06 | BITS | ETF | 21.56 | 22.92 | 21.56 | 22.72 | 2322.0 |
| 2008-08-06 | BIV | ETF | 75.96 | 75.96 | 75.51 | 75.92 | 22000.0 |
| 2008-08-06 | BJK | ETF | 32.35 | 32.35 | 31.0 | 31.92 | 4900.0 |
| 2008-08-06 | BKF | ETF | 47.04 | 47.29 | 46.52 | 47.14 | 72006.0 |
| 2008-08-06 | BLV | ETF | 73.11 | 73.11 | 72.62 | 72.7 | 4900.0 |
| 2008-08-06 | BMVP | ETF | 14.973 | 15.214 | 14.973 | 15.193 | 26708.0 |
| 2008-08-06 | BND | ETF | 75.2 | 75.3 | 75.0 | 75.25 | 233300.0 |
| 2008-08-06 | BNE | ETF | 12.79 | 12.86 | 12.64 | 12.76 | 125490.0 |
| 2008-08-06 | BRF | ETF | 14.74 | 14.74 | 14.73 | 14.74 | 13600.0 |
| 2008-08-06 | BSV | ETF | 77.13 | 77.13 | 76.96 | 77.1 | 82000.0 |
| 2008-08-06 | BTF | ETF | 85.99999999999999 | 86.8 | 85.5 | 86.14999999999999 | 9305.0 |
| 2008-08-06 | BWX | ETF | 27.61 | 27.63 | 27.4095 | 27.47 | 328576.0 |
| 2008-08-06 | CBON | ETF | 4.61 | 5.19 | 4.5101 | 4.92 | 110342.0 |
| 2008-08-06 | CDL | ETF | 0.86 | 0.9 | 0.77 | 0.86 | 876493.0 |
| 2008-08-06 | CEF | ETF | 12.17 | 12.32 | 12.11 | 12.24 | 485000.0 |
| 2008-08-06 | CGO | ETF | 15.24 | 15.26 | 15.1 | 15.26 | 12868.0 |
| 2008-08-06 | CGW | ETF | 23.37 | 23.55 | 23.2 | 23.55 | 41164.0 |
| 2008-08-06 | CHB | ETF | 3.92 | 4.21 | 3.86 | 4.08 | 969459.0 |
| 2008-08-06 | CHI | ETF | 13.51 | 13.51 | 13.38 | 13.45 | 120880.0 |
| 2008-08-06 | CHIC | ETF | 11.19 | 11.76 | 11.03 | 11.44 | 821451.0 |
| 2008-08-06 | CHW | ETF | 11.06 | 11.19 | 10.97 | 11.19 | 80836.0 |
| 2008-08-06 | CHY | ETF | 13.2 | 13.2 | 12.95 | 13.04 | 98909.0 |
| 2008-08-06 | CMF | ETF | 50.75 | 50.89 | 50.67 | 50.89 | 15000.0 |
| 2008-08-06 | CN | ETF | 61.2 | 62.36 | 61.07 | 62.03 | 192218.0 |
| 2008-08-06 | CNXT | ETF | 5.31 | 5.59 | 5.31 | 5.5 | 751731.0 |
| 2008-08-06 | COW | ETF | 43.94 | 44.99 | 43.94 | 44.85 | 81016.0 |
| 2008-08-06 | CPI | ETF | 22.85 | 23.15 | 22.85 | 23.1 | 2476.0 |
| 2008-08-06 | CPST | ETF | 2.6 | 2.78 | 2.56 | 2.76 | 3147385.0 |
| 2008-08-06 | CSA | ETF | 18.54 | 19.01 | 18.31 | 18.99 | 30019.0 |
| 2008-08-06 | CSB | ETF | 19.08 | 19.6799 | 18.78 | 19.22 | 41087.0 |
| 2008-08-06 | CSD | ETF | 21.06 | 21.25 | 21.05 | 21.25 | 2800.0 |
> showing 50 of 606 rows — these rows as CSV