PREVIEW / etf_daily / 2008-08-12
file: by_date/etf_daily/2008/2008-08-12.parquet size: 27 KB rows: 609
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-12 | SPY | ETF | 130.28 | 130.7 | 128.73 | 129.35 | 213200800.0 |
| 2008-08-12 | QQQ | ETF | 47.76 | 48.16 | 47.51 | 47.8 | 140596918.0 |
| 2008-08-12 | IWM | ETF | 74.64 | 74.89 | 74.06 | 74.31 | 128837600.0 |
| 2008-08-12 | DIA | ETF | 117.46 | 117.52 | 116.08 | 116.57 | 22492600.0 |
| 2008-08-12 | GLD | ETF | 80.74 | 81.01 | 79.55 | 80.52 | 20131800.0 |
| 2008-08-12 | TLT | ETF | 91.81 | 92.03 | 91.7 | 91.97 | 1315000.0 |
| 2008-08-12 | ACWI | ETF | 47.79 | 47.84 | 47.37 | 47.43 | 76400.0 |
| 2008-08-12 | ACWX | ETF | 46.9 | 46.9 | 46.5 | 46.5 | 13651.0 |
| 2008-08-12 | ADRE | ETF | 44.6 | 44.79 | 44.12 | 44.2799 | 544907.0 |
| 2008-08-12 | AFK | ETF | 38.5 | 38.77 | 37.15 | 37.15 | 2450.0 |
| 2008-08-12 | AGG | ETF | 99.69 | 99.88 | 99.64 | 99.86 | 392600.0 |
| 2008-08-12 | AIA | ETF | 40.3 | 41.03 | 39.68 | 39.79 | 24027.0 |
| 2008-08-12 | AIQ | ETF | 55.0 | 55.85 | 54.15 | 54.5 | 41886.0 |
| 2008-08-12 | AIS | ETF | 0.79 | 0.9 | 0.7701 | 0.88 | 468648.0 |
| 2008-08-12 | AIVI | ETF | 59.85 | 59.85 | 59.27 | 59.44 | 30500.0 |
| 2008-08-12 | ARB | ETF | 49.9 | 50.2 | 49.52 | 49.91 | 369937.0 |
| 2008-08-12 | BAL | ETF | 43.8899 | 43.99 | 43.7 | 43.7 | 6100.0 |
| 2008-08-12 | BBH | ETF | 67.32 | 67.8933 | 67.1433 | 67.6133 | 580500.0 |
| 2008-08-12 | BIL | ETF | 91.76 | 91.78 | 91.7 | 91.7 | 68100.0 |
| 2008-08-12 | BITS | ETF | 22.4 | 22.72 | 22.24 | 22.4 | 7311.0 |
| 2008-08-12 | BIV | ETF | 76.38 | 76.53 | 76.29 | 76.53 | 52300.0 |
| 2008-08-12 | BJK | ETF | 31.55 | 31.65 | 31.09 | 31.24 | 2000.0 |
| 2008-08-12 | BKF | ETF | 45.99 | 46.85 | 44.385 | 44.69 | 38136.0 |
| 2008-08-12 | BLV | ETF | 73.94 | 73.98 | 73.69 | 73.96 | 6400.0 |
| 2008-08-12 | BMVP | ETF | 15.383 | 15.432 | 15.3 | 15.327 | 41936.0 |
| 2008-08-12 | BND | ETF | 75.46 | 75.76 | 75.46 | 75.72 | 196300.0 |
| 2008-08-12 | BNE | ETF | 11.83 | 12.65 | 11.28 | 11.81 | 386159.0 |
| 2008-08-12 | BRF | ETF | 14.73 | 14.76 | 14.73 | 14.75 | 1600.0 |
| 2008-08-12 | BSV | ETF | 77.36 | 77.46 | 77.3 | 77.45 | 82700.0 |
| 2008-08-12 | BTF | ETF | 88.1 | 88.1 | 85.55 | 85.74999999999999 | 11678.800000000001 |
| 2008-08-12 | BWX | ETF | 26.895 | 26.985 | 26.805 | 26.975 | 393370.0 |
| 2008-08-12 | CBON | ETF | 6.06 | 6.61 | 6.02 | 6.24 | 148837.0 |
| 2008-08-12 | CDL | ETF | 1.1 | 1.1 | 0.9 | 0.9 | 1094275.0 |
| 2008-08-12 | CEF | ETF | 10.82 | 11.19 | 10.82 | 10.99 | 1343400.0 |
| 2008-08-12 | CGO | ETF | 14.95 | 14.97 | 14.59 | 14.67 | 12869.0 |
| 2008-08-12 | CGW | ETF | 23.99 | 23.99 | 23.62 | 23.74 | 34195.0 |
| 2008-08-12 | CHB | ETF | 4.36 | 4.57 | 4.1 | 4.26 | 1369678.0 |
| 2008-08-12 | CHI | ETF | 13.25 | 13.2634 | 13.08 | 13.08 | 58859.0 |
| 2008-08-12 | CHIC | ETF | 12.94 | 12.94 | 12.34 | 12.52 | 474105.0 |
| 2008-08-12 | CHW | ETF | 10.86 | 10.86 | 10.56 | 10.68 | 82987.0 |
| 2008-08-12 | CHY | ETF | 12.88 | 12.88 | 12.75 | 12.76 | 79304.0 |
| 2008-08-12 | CMF | ETF | 51.24 | 51.24 | 51.11 | 51.115 | 1536.0 |
| 2008-08-12 | CN | ETF | 62.0 | 62.0 | 58.07 | 58.32 | 273461.0 |
| 2008-08-12 | CNXT | ETF | 6.05 | 6.28 | 6.01 | 6.25 | 800462.0 |
| 2008-08-12 | COW | ETF | 44.18 | 44.7 | 43.62 | 44.47 | 76571.0 |
| 2008-08-12 | CPI | ETF | 25.75 | 26.0 | 25.55 | 25.65 | 7000.0 |
| 2008-08-12 | CPST | ETF | 2.35 | 2.82 | 2.28 | 2.73 | 7057431.0 |
| 2008-08-12 | CSA | ETF | 19.78 | 19.87 | 19.38 | 19.48 | 41288.0 |
| 2008-08-12 | CSB | ETF | 20.0001 | 20.47 | 19.85 | 19.97 | 39725.0 |
| 2008-08-12 | CSD | ETF | 21.45 | 21.46 | 21.34 | 21.34 | 1400.0 |
> showing 50 of 609 rows — these rows as CSV