PREVIEW / etf_daily / 2005-08-18
file: by_date/etf_daily/2005/2005-08-18.parquet size: 15 KB rows: 278
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-18 | SPY | ETF | 122.05 | 122.56 | 121.84 | 122.19 | 53388600.0 |
| 2005-08-18 | QQQ | ETF | 38.87 | 39.1 | 38.77 | 38.843 | 72727102.0 |
| 2005-08-18 | IWM | ETF | 64.77 | 65.15 | 64.47 | 64.77 | 23307000.0 |
| 2005-08-18 | DIA | ETF | 105.47 | 106.17 | 105.37 | 105.76 | 6723200.0 |
| 2005-08-18 | GLD | ETF | 43.94 | 44.14 | 43.82 | 43.83 | 1093500.0 |
| 2005-08-18 | TLT | ETF | 93.45 | 93.81 | 93.27 | 93.79 | 833900.0 |
| 2005-08-18 | AAA | ETF | 55.86 | 56.13 | 55.75 | 56.13 | 3000.0 |
| 2005-08-18 | ADRE | ETF | 98.61 | 100.2 | 97.94 | 98.088 | 11788.0 |
| 2005-08-18 | AFK | ETF | 25.73 | 25.78 | 25.72 | 25.756 | 8000.0 |
| 2005-08-18 | AGG | ETF | 101.9 | 102.05 | 101.82 | 102.05 | 85600.0 |
| 2005-08-18 | AIQ | ETF | 46.35 | 46.4 | 45.05 | 45.25 | 27780.0 |
| 2005-08-18 | AIS | ETF | 0.9115 | 0.9115 | 0.86 | 0.87 | 108700.0 |
| 2005-08-18 | ARB | ETF | 42.59 | 42.78 | 42.22 | 42.41 | 214600.0 |
| 2005-08-18 | BAB | ETF | 51.45 | 51.8 | 51.4 | 51.75 | 10700.0 |
| 2005-08-18 | BBH | ETF | 62.6667 | 63.4933 | 62.4267 | 62.9367 | 1625100.0 |
| 2005-08-18 | BCM | ETF | 57.55 | 57.57 | 57.33 | 57.45 | 25200.0 |
| 2005-08-18 | BIS | ETF | 704.0 | 704.0 | 704.0 | 704.0 | 3.125 |
| 2005-08-18 | BITS | ETF | 13.2 | 13.2 | 12.2 | 12.28 | 9232.0 |
| 2005-08-18 | BKF | ETF | 31.65 | 31.65 | 30.75 | 30.99 | 38100.0 |
| 2005-08-18 | BNE | ETF | 13.85 | 14.0 | 13.69 | 13.87 | 100000.0 |
| 2005-08-18 | BRF | ETF | 15.58 | 15.6 | 15.56 | 15.58 | 12800.0 |
| 2005-08-18 | BTF | ETF | 85.85000000000001 | 85.99999999999999 | 85.74999999999999 | 85.99999999999999 | 360.0 |
| 2005-08-18 | CBON | ETF | 32.5 | 32.6 | 32.5 | 32.6 | 9807.0 |
| 2005-08-18 | CDC | ETF | 3.3 | 3.4 | 3.1 | 3.4 | 24300.0 |
| 2005-08-18 | CDL | ETF | 13.48 | 13.57 | 13.3 | 13.48 | 183900.0 |
| 2005-08-18 | CEF | ETF | 5.38 | 5.4 | 5.37 | 5.39 | 419300.0 |
| 2005-08-18 | CHB | ETF | 11.86 | 11.9 | 11.45 | 11.58 | 436600.0 |
| 2005-08-18 | CHI | ETF | 20.3 | 20.34 | 20.1 | 20.11 | 66100.0 |
| 2005-08-18 | CHIC | ETF | 14.14 | 14.19 | 13.88 | 13.88 | 117392.0 |
| 2005-08-18 | CHIR | ETF | 35.7201 | 36.5499 | 35.61 | 35.8899 | 601065.0 |
| 2005-08-18 | CHY | ETF | 16.27 | 16.3 | 16.2 | 16.22 | 92300.0 |
| 2005-08-18 | CIL | ETF | 25.83 | 25.83 | 25.83 | 25.83 | 700.0 |
| 2005-08-18 | CN | ETF | 34.25 | 34.25 | 33.6 | 33.95 | 23700.0 |
| 2005-08-18 | CNXT | ETF | 1.65 | 1.66 | 1.61 | 1.63 | 2130675.0 |
| 2005-08-18 | CPI | ETF | 23.34 | 23.34 | 23.34 | 23.34 | 400.0 |
| 2005-08-18 | CPST | ETF | 3.07 | 3.09 | 2.89 | 2.96 | 748727.0 |
| 2005-08-18 | CSB | ETF | 30.95 | 30.95 | 30.66 | 30.76 | 6700.0 |
| 2005-08-18 | CSM | ETF | 2.4175 | 2.4175 | 2.4175 | 2.4175 | 6000.0 |
| 2005-08-18 | CSQ | ETF | 14.15 | 14.17 | 14.05 | 14.1 | 276900.0 |
| 2005-08-18 | CTEC | ETF | 52.99999999999999 | 53.949999999999996 | 51.1 | 52.24999999999999 | 9007.4 |
| 2005-08-18 | CURE | ETF | 0.25 | 0.25 | 0.2375 | 0.2462 | 601808.0 |
| 2005-08-18 | CYA | ETF | 68.8 | 69.0 | 64.0 | 68.0 | 570.0 |
| 2005-08-18 | CYB | ETF | 3.54 | 3.54 | 3.49 | 3.49 | 8400.0 |
| 2005-08-18 | DGT | ETF | 64.41 | 64.5 | 64.38 | 64.48 | 7500.0 |
| 2005-08-18 | DIG | ETF | 13.0625 | 13.225 | 13.05 | 13.0625 | 6160.0 |
| 2005-08-18 | DIV | ETF | 13.6 | 13.6 | 13.57 | 13.58 | 4700.0 |
| 2005-08-18 | DRIV | ETF | 38.31 | 38.83 | 38.13 | 38.14 | 396071.0 |
| 2005-08-18 | DSI | ETF | 5.755 | 5.755 | 5.755 | 5.755 | 200.0 |
| 2005-08-18 | DUSA | ETF | 10.9 | 10.97 | 10.89 | 10.93 | 88709.0 |
| 2005-08-18 | DVY | ETF | 62.58 | 62.77 | 62.32 | 62.67 | 689100.0 |
> showing 50 of 278 rows — these rows as CSV