PREVIEW / etf_daily / 2008-07-28
file: by_date/etf_daily/2008/2008-07-28.parquet size: 27 KB rows: 602
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-07-28 | SPY | ETF | 125.51 | 126.06 | 123.42 | 123.64 | 205201300.0 |
| 2008-07-28 | QQQ | ETF | 45.27 | 45.52 | 44.21 | 44.42 | 124028416.0 |
| 2008-07-28 | IWM | ETF | 70.64 | 70.84 | 69.22 | 69.48 | 82119100.0 |
| 2008-07-28 | DIA | ETF | 113.27 | 113.52 | 111.17 | 111.34 | 16089700.0 |
| 2008-07-28 | GLD | ETF | 91.39 | 92.0 | 90.94 | 91.73 | 8809600.0 |
| 2008-07-28 | TLT | ETF | 90.95 | 91.47 | 90.7 | 91.05 | 1275900.0 |
| 2008-07-28 | ACWI | ETF | 47.69 | 47.89 | 47.17 | 47.17 | 43900.0 |
| 2008-07-28 | ACWX | ETF | 48.36 | 48.43 | 47.862 | 47.907 | 22193.0 |
| 2008-07-28 | ADRE | ETF | 46.25 | 46.94 | 46.01 | 46.01 | 562222.0 |
| 2008-07-28 | AFK | ETF | 40.74 | 40.74 | 39.69 | 39.69 | 1650.0 |
| 2008-07-28 | AGG | ETF | 99.95 | 100.01 | 99.71 | 99.91 | 458500.0 |
| 2008-07-28 | AIA | ETF | 41.49 | 41.49 | 40.745 | 40.745 | 24879.0 |
| 2008-07-28 | AIQ | ETF | 44.95 | 45.29 | 44.55 | 44.75 | 40097.0 |
| 2008-07-28 | AIS | ETF | 0.7 | 0.7 | 0.62 | 0.69 | 92877.0 |
| 2008-07-28 | AIVI | ETF | 59.33 | 59.42 | 58.21 | 58.25 | 29900.0 |
| 2008-07-28 | ARB | ETF | 45.42 | 45.73 | 44.88 | 45.2 | 257354.0 |
| 2008-07-28 | BAL | ETF | 45.92 | 45.92 | 45.92 | 45.92 | 108.0 |
| 2008-07-28 | BBH | ETF | 67.1 | 67.4867 | 66.2567 | 66.37 | 837000.0 |
| 2008-07-28 | BIL | ETF | 91.84 | 91.84 | 91.78 | 91.84 | 57100.0 |
| 2008-07-28 | BITS | ETF | 22.8 | 23.12 | 21.64 | 23.08 | 5812.0 |
| 2008-07-28 | BIV | ETF | 76.1 | 76.24 | 75.97 | 76.07 | 20700.0 |
| 2008-07-28 | BJK | ETF | 30.97 | 30.97 | 30.5 | 30.5 | 400.0 |
| 2008-07-28 | BKF | ETF | 47.5 | 47.8 | 46.68 | 46.68 | 30683.0 |
| 2008-07-28 | BLV | ETF | 73.33 | 73.84 | 73.33 | 73.51 | 6600.0 |
| 2008-07-28 | BMVP | ETF | 14.5867 | 14.8433 | 14.5867 | 14.6367 | 24742.0 |
| 2008-07-28 | BND | ETF | 75.79 | 75.89 | 75.57 | 75.81 | 111700.0 |
| 2008-07-28 | BNE | ETF | 12.19 | 12.57 | 12.14 | 12.37 | 91026.0 |
| 2008-07-28 | BOSS | ETF | 24.35 | 24.35 | 24.0 | 24.0 | 100.0 |
| 2008-07-28 | BRF | ETF | 14.75 | 14.75 | 14.72 | 14.73 | 6600.0 |
| 2008-07-28 | BSV | ETF | 77.2 | 77.32 | 77.18 | 77.29 | 71800.0 |
| 2008-07-28 | BTF | ETF | 82.44999999999999 | 82.5 | 80.74999999999999 | 80.8 | 6753.200000000001 |
| 2008-07-28 | BWX | ETF | 27.745 | 27.895 | 27.715 | 27.88 | 933070.0 |
| 2008-07-28 | CBON | ETF | 3.44 | 4.08 | 3.2 | 3.98 | 266863.0 |
| 2008-07-28 | CDL | ETF | 0.98 | 1.03 | 0.88 | 0.89 | 1539956.0 |
| 2008-07-28 | CEF | ETF | 12.85 | 12.95 | 12.73 | 12.95 | 529000.0 |
| 2008-07-28 | CGO | ETF | 15.04 | 15.0699 | 14.71 | 14.86 | 14853.0 |
| 2008-07-28 | CGW | ETF | 23.57 | 23.705 | 23.12 | 23.25 | 24796.0 |
| 2008-07-28 | CHB | ETF | 3.75 | 3.84 | 3.51 | 3.55 | 2322538.0 |
| 2008-07-28 | CHI | ETF | 13.34 | 13.48 | 13.28 | 13.34 | 104605.0 |
| 2008-07-28 | CHIC | ETF | 12.82 | 12.83 | 12.25 | 12.44 | 664971.0 |
| 2008-07-28 | CHW | ETF | 10.98 | 10.98 | 10.68 | 10.81 | 148603.0 |
| 2008-07-28 | CHY | ETF | 12.75 | 12.9 | 12.61 | 12.66 | 90740.0 |
| 2008-07-28 | CMF | ETF | 51.34 | 51.42 | 51.1925 | 51.1925 | 2350.0 |
| 2008-07-28 | CN | ETF | 58.35 | 59.1 | 57.52 | 57.68 | 116847.0 |
| 2008-07-28 | COW | ETF | 43.53 | 43.53 | 43.03 | 43.22 | 16096.0 |
| 2008-07-28 | CPI | ETF | 22.25 | 22.416 | 22.25 | 22.416 | 603.0 |
| 2008-07-28 | CPST | ETF | 2.97 | 3.14 | 2.97 | 3.05 | 3468371.0 |
| 2008-07-28 | CSA | ETF | 18.52 | 18.9 | 18.29 | 18.37 | 32395.0 |
| 2008-07-28 | CSB | ETF | 17.9 | 18.4799 | 17.9 | 18.4799 | 76254.0 |
| 2008-07-28 | CSQ | ETF | 10.98 | 11.03 | 10.75 | 10.8 | 278714.0 |
> showing 50 of 602 rows — these rows as CSV