PREVIEW / etf_daily / 2008-08-19
file: by_date/etf_daily/2008/2008-08-19.parquet size: 27 KB rows: 613
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-19 | SPY | ETF | 127.42 | 127.69 | 126.53 | 126.99 | 194673700.0 |
| 2008-08-19 | QQQ | ETF | 47.36 | 47.59 | 46.75 | 47.01 | 155418537.0 |
| 2008-08-19 | IWM | ETF | 73.63 | 73.83 | 72.44 | 72.9 | 105131600.0 |
| 2008-08-19 | DIA | ETF | 114.11 | 114.21 | 113.15 | 113.49 | 19249200.0 |
| 2008-08-19 | GLD | ETF | 77.92 | 80.52 | 77.7 | 80.43 | 16757100.0 |
| 2008-08-19 | TLT | ETF | 93.44 | 93.53 | 92.89 | 93.05 | 1944700.0 |
| 2008-08-19 | AAXJ | ETF | 48.34 | 48.34 | 48.34 | 48.34 | 100.0 |
| 2008-08-19 | ACWI | ETF | 46.13 | 46.19 | 45.91 | 46.04 | 28500.0 |
| 2008-08-19 | ACWX | ETF | 44.83 | 44.91 | 44.59 | 44.73 | 4935.0 |
| 2008-08-19 | ADRE | ETF | 43.01 | 43.81 | 42.9 | 43.76 | 452038.0 |
| 2008-08-19 | AFK | ETF | 36.2501 | 36.3399 | 35.3401 | 35.45 | 1539.0 |
| 2008-08-19 | AGG | ETF | 100.38 | 100.38 | 100.1 | 100.31 | 284400.0 |
| 2008-08-19 | AIA | ETF | 38.29 | 38.29 | 37.6 | 37.83 | 8150.0 |
| 2008-08-19 | AIQ | ETF | 56.2 | 56.75 | 55.35 | 55.75 | 21370.0 |
| 2008-08-19 | AIS | ETF | 0.73 | 0.75 | 0.7202 | 0.75 | 33049.0 |
| 2008-08-19 | AIVI | ETF | 55.89 | 56.03 | 55.64 | 55.8 | 52900.0 |
| 2008-08-19 | ARB | ETF | 49.49 | 50.24 | 48.76 | 49.03 | 241210.0 |
| 2008-08-19 | BAL | ETF | 41.87 | 41.87 | 41.87 | 41.87 | 500.0 |
| 2008-08-19 | BBH | ETF | 67.4667 | 68.0267 | 67.2533 | 67.6333 | 500100.0 |
| 2008-08-19 | BIL | ETF | 91.74 | 91.8 | 91.74 | 91.8 | 34100.0 |
| 2008-08-19 | BITS | ETF | 23.48 | 23.6 | 22.72 | 23.28 | 900.0 |
| 2008-08-19 | BIV | ETF | 76.64 | 76.7 | 76.36 | 76.57 | 40000.0 |
| 2008-08-19 | BJK | ETF | 29.93 | 29.93 | 29.6 | 29.6 | 1500.0 |
| 2008-08-19 | BKF | ETF | 42.0 | 43.17 | 42.0 | 42.65 | 25987.0 |
| 2008-08-19 | BLV | ETF | 74.69 | 74.69 | 74.1 | 74.12 | 9500.0 |
| 2008-08-19 | BMVP | ETF | 15.0 | 15.23 | 14.77 | 15.14 | 19989.0 |
| 2008-08-19 | BND | ETF | 76.06 | 76.06 | 75.86 | 76.01 | 109600.0 |
| 2008-08-19 | BNE | ETF | 13.48 | 13.53 | 13.11 | 13.2 | 172471.0 |
| 2008-08-19 | BOSS | ETF | 23.25 | 23.25 | 23.12 | 23.12 | 100.0 |
| 2008-08-19 | BRF | ETF | 14.75 | 14.78 | 14.75 | 14.75 | 9300.0 |
| 2008-08-19 | BSV | ETF | 77.58 | 77.59 | 77.46 | 77.54 | 75000.0 |
| 2008-08-19 | BTF | ETF | 85.99999999999999 | 86.89999999999999 | 84.60000000000001 | 84.85 | 6909.200000000001 |
| 2008-08-19 | BWX | ETF | 26.76 | 26.85 | 26.66 | 26.8172 | 232100.0 |
| 2008-08-19 | CBON | ETF | 6.74 | 6.98 | 6.37 | 6.8 | 107267.0 |
| 2008-08-19 | CDL | ETF | 0.92 | 0.95 | 0.92 | 0.94 | 460650.0 |
| 2008-08-19 | CEF | ETF | 10.07 | 10.41 | 9.94 | 10.41 | 930200.0 |
| 2008-08-19 | CGO | ETF | 14.33 | 14.44 | 14.0 | 14.37 | 13780.0 |
| 2008-08-19 | CGW | ETF | 23.3 | 23.4 | 23.0101 | 23.15 | 51306.0 |
| 2008-08-19 | CHB | ETF | 5.0 | 5.0 | 4.37 | 4.55 | 1252007.0 |
| 2008-08-19 | CHI | ETF | 13.35 | 13.35 | 13.07 | 13.21 | 91316.0 |
| 2008-08-19 | CHIC | ETF | 12.51 | 12.76 | 12.32 | 12.47 | 388636.0 |
| 2008-08-19 | CHW | ETF | 10.52 | 10.52 | 10.22 | 10.49 | 147132.0 |
| 2008-08-19 | CHY | ETF | 12.84 | 12.9 | 12.76 | 12.89 | 71335.0 |
| 2008-08-19 | CMF | ETF | 51.745 | 51.89 | 51.745 | 51.875 | 3900.0 |
| 2008-08-19 | CN | ETF | 51.74 | 52.83 | 51.74 | 52.42 | 303281.0 |
| 2008-08-19 | CNXT | ETF | 5.88 | 5.99 | 5.86 | 5.88 | 275588.0 |
| 2008-08-19 | COW | ETF | 44.2 | 44.2 | 43.54 | 43.54 | 45409.0 |
| 2008-08-19 | CPI | ETF | 24.53 | 25.0 | 24.45 | 24.49 | 1880.0 |
| 2008-08-19 | CPST | ETF | 2.51 | 2.52 | 2.4 | 2.44 | 2515088.0 |
| 2008-08-19 | CSA | ETF | 18.29 | 18.34 | 17.83 | 17.87 | 69420.0 |
> showing 50 of 613 rows — these rows as CSV