PREVIEW / etf_daily / 2006-05-18
file: by_date/etf_daily/2006/2006-05-18.parquet size: 17 KB rows: 319
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-18 | SPY | ETF | 127.35 | 127.75 | 126.11 | 126.21 | 87906300.0 |
| 2006-05-18 | QQQ | ETF | 39.49 | 39.66 | 39.0 | 39.05 | 139722870.0 |
| 2006-05-18 | IWM | ETF | 72.42 | 72.86 | 71.13 | 71.27 | 54127300.0 |
| 2006-05-18 | DIA | ETF | 112.47 | 113.61 | 111.3 | 111.42 | 10613500.0 |
| 2006-05-18 | GLD | ETF | 68.69 | 69.1 | 67.36 | 67.46 | 12720700.0 |
| 2006-05-18 | TLT | ETF | 83.55 | 84.23 | 83.53 | 84.21 | 2177700.0 |
| 2006-05-18 | AAA | ETF | 60.44 | 60.57 | 59.84 | 60.43 | 6200.0 |
| 2006-05-18 | ADRE | ETF | 130.65 | 132.05 | 128.73 | 128.77 | 136008.0 |
| 2006-05-18 | AFK | ETF | 25.14 | 25.18 | 25.11 | 25.15 | 11100.0 |
| 2006-05-18 | AGG | ETF | 98.07 | 98.26 | 98.04 | 98.26 | 224200.0 |
| 2006-05-18 | AIQ | ETF | 33.4 | 33.5 | 32.5 | 33.15 | 28140.0 |
| 2006-05-18 | AIS | ETF | 1.41 | 1.45 | 1.3701 | 1.45 | 77500.0 |
| 2006-05-18 | AOM | ETF | 7.25 | 7.43 | 7.25 | 7.42 | 284300.0 |
| 2006-05-18 | ARB | ETF | 37.9 | 40.35 | 37.71 | 39.73 | 1367700.0 |
| 2006-05-18 | BAB | ETF | 61.48 | 61.52 | 60.24 | 60.55 | 63500.0 |
| 2006-05-18 | BBC | ETF | 11.56 | 11.7799 | 11.05 | 11.05 | 157900.0 |
| 2006-05-18 | BBH | ETF | 57.8467 | 58.0 | 56.21 | 56.2833 | 2853900.0 |
| 2006-05-18 | BCM | ETF | 74.0 | 74.32 | 72.13 | 72.38 | 29300.0 |
| 2006-05-18 | BITS | ETF | 27.04 | 27.8 | 25.6 | 26.2 | 31971.0 |
| 2006-05-18 | BKF | ETF | 7.82 | 7.9 | 7.78 | 7.85 | 74600.0 |
| 2006-05-18 | BNE | ETF | 14.05 | 14.17 | 13.73 | 13.88 | 120600.0 |
| 2006-05-18 | BOSS | ETF | 31.99 | 31.99 | 31.99 | 31.99 | 100.0 |
| 2006-05-18 | BRF | ETF | 13.98 | 14.07 | 13.98 | 14.07 | 20400.0 |
| 2006-05-18 | BTF | ETF | 89.1 | 89.49999999999999 | 88.94999999999999 | 89.0 | 1400.0 |
| 2006-05-18 | CBON | ETF | 31.38 | 32.05 | 31.18 | 31.4 | 18898.0 |
| 2006-05-18 | CDL | ETF | 10.61 | 10.65 | 10.44 | 10.44 | 194500.0 |
| 2006-05-18 | CEF | ETF | 9.31 | 9.49 | 9.1 | 9.22 | 969800.0 |
| 2006-05-18 | CGO | ETF | 14.65 | 14.92 | 14.56 | 14.79 | 54400.0 |
| 2006-05-18 | CHB | ETF | 13.99 | 14.87 | 13.9 | 14.01 | 841300.0 |
| 2006-05-18 | CHI | ETF | 19.72 | 19.79 | 19.7 | 19.77 | 50700.0 |
| 2006-05-18 | CHIC | ETF | 21.59 | 21.96 | 21.41 | 21.68 | 272762.0 |
| 2006-05-18 | CHY | ETF | 15.89 | 16.05 | 15.89 | 16.05 | 142800.0 |
| 2006-05-18 | CIL | ETF | 25.91 | 25.91 | 25.91 | 25.91 | 100.0 |
| 2006-05-18 | CN | ETF | 34.4 | 34.44 | 33.77 | 33.96 | 81500.0 |
| 2006-05-18 | CNXT | ETF | 3.245 | 3.27 | 3.08 | 3.12 | 8893540.0 |
| 2006-05-18 | COMB | ETF | 9.74 | 9.89 | 9.74 | 9.75 | 18977.0 |
| 2006-05-18 | CPST | ETF | 3.24 | 3.31 | 3.08 | 3.12 | 1130415.0 |
| 2006-05-18 | CSA | ETF | 19.35 | 19.35 | 19.15 | 19.25 | 1900.0 |
| 2006-05-18 | CSB | ETF | 29.01 | 29.21 | 29.01 | 29.05 | 8300.0 |
| 2006-05-18 | CSQ | ETF | 13.87 | 13.88 | 13.8 | 13.88 | 303800.0 |
| 2006-05-18 | CTEC | ETF | 62.699999999999996 | 64.74999999999999 | 62.599999999999994 | 63.49999999999999 | 11115.2 |
| 2006-05-18 | CYB | ETF | 5.85 | 5.89 | 5.71 | 5.82 | 192000.0 |
| 2006-05-18 | DBC | ETF | 25.89 | 26.0 | 25.73 | 25.99 | 263100.0 |
| 2006-05-18 | DGT | ETF | 67.61 | 67.61 | 67.01 | 67.04 | 2700.0 |
| 2006-05-18 | DIG | ETF | 17.775 | 17.775 | 17.775 | 17.775 | 160.0 |
| 2006-05-18 | DIV | ETF | 11.8 | 11.89 | 11.67 | 11.82 | 23800.0 |
| 2006-05-18 | DRIV | ETF | 46.53 | 47.17 | 44.36 | 44.48 | 903019.0 |
| 2006-05-18 | DSI | ETF | 6.375 | 6.375 | 6.35 | 6.35 | 4400.0 |
| 2006-05-18 | DUSA | ETF | 6.48 | 6.67 | 6.48 | 6.65 | 171984.0 |
| 2006-05-18 | DVY | ETF | 62.51 | 62.84 | 62.06 | 62.06 | 372000.0 |
> showing 50 of 319 rows — these rows as CSV