PREVIEW / etf_daily / 2006-04-18
file: by_date/etf_daily/2006/2006-04-18.parquet size: 16 KB rows: 311
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-04-18 | SPY | ETF | 128.93 | 130.94 | 128.93 | 130.7 | 92531800.0 |
| 2006-04-18 | QQQ | ETF | 41.78 | 42.56 | 41.77 | 42.46 | 124333392.0 |
| 2006-04-18 | IWM | ETF | 74.81 | 76.7 | 74.8 | 76.7 | 58648200.0 |
| 2006-04-18 | DIA | ETF | 111.03 | 112.79 | 111.03 | 112.64 | 10870700.0 |
| 2006-04-18 | GLD | ETF | 61.25 | 61.93 | 61.06 | 61.85 | 5130700.0 |
| 2006-04-18 | TLT | ETF | 84.95 | 85.27 | 84.74 | 84.9 | 2680300.0 |
| 2006-04-18 | AAA | ETF | 59.81 | 60.47 | 59.81 | 60.47 | 3200.0 |
| 2006-04-18 | ADRE | ETF | 135.48 | 138.15 | 135.0 | 137.5094 | 112488.0 |
| 2006-04-18 | AFK | ETF | 25.12 | 25.15 | 25.08 | 25.08 | 10400.0 |
| 2006-04-18 | AGG | ETF | 98.37 | 98.5 | 98.27 | 98.3 | 205900.0 |
| 2006-04-18 | AIQ | ETF | 28.0 | 28.0 | 25.25 | 25.9 | 51160.0 |
| 2006-04-18 | AIS | ETF | 1.56 | 1.69 | 1.56 | 1.69 | 410300.0 |
| 2006-04-18 | AOM | ETF | 6.75 | 6.8 | 6.63 | 6.78 | 40800.0 |
| 2006-04-18 | ARB | ETF | 33.09 | 33.3 | 32.98 | 33.3 | 383400.0 |
| 2006-04-18 | BAB | ETF | 60.35 | 61.16 | 60.35 | 61.05 | 25700.0 |
| 2006-04-18 | BBC | ETF | 16.72 | 16.72 | 15.1 | 15.14 | 1174600.0 |
| 2006-04-18 | BBH | ETF | 62.6833 | 62.9933 | 62.3567 | 62.7867 | 1097100.0 |
| 2006-04-18 | BCM | ETF | 72.5 | 72.87 | 72.39 | 72.73 | 22800.0 |
| 2006-04-18 | BITS | ETF | 36.64 | 36.956 | 35.04 | 35.8 | 52872.0 |
| 2006-04-18 | BKF | ETF | 9.32 | 9.59 | 8.98 | 8.98 | 187000.0 |
| 2006-04-18 | BNE | ETF | 16.04 | 16.5 | 15.99 | 16.45 | 139800.0 |
| 2006-04-18 | BRF | ETF | 13.9 | 13.95 | 13.78 | 13.78 | 23300.0 |
| 2006-04-18 | BTF | ETF | 85.95 | 86.5 | 85.89999999999999 | 86.5 | 1560.0 |
| 2006-04-18 | CBON | ETF | 29.93 | 31.42 | 29.93 | 31.39 | 9061.0 |
| 2006-04-18 | CDL | ETF | 10.73 | 10.75 | 10.37 | 10.37 | 512800.0 |
| 2006-04-18 | CEF | ETF | 9.47 | 9.57 | 9.31 | 9.55 | 898500.0 |
| 2006-04-18 | CEW | ETF | 25.5 | 25.5 | 25.5 | 25.5 | 400.0 |
| 2006-04-18 | CFO | ETF | 10.2 | 10.2 | 10.16 | 10.16 | 11900.0 |
| 2006-04-18 | CGO | ETF | 14.12 | 14.4865 | 14.12 | 14.42 | 39100.0 |
| 2006-04-18 | CHB | ETF | 15.2 | 15.45 | 14.9 | 15.24 | 1901700.0 |
| 2006-04-18 | CHI | ETF | 20.0 | 20.09 | 19.86 | 19.921 | 191100.0 |
| 2006-04-18 | CHIC | ETF | 20.5 | 20.8 | 20.02 | 20.38 | 608478.0 |
| 2006-04-18 | CHIR | ETF | 47.9601 | 48.0 | 47.9499 | 47.9499 | 1636270.0 |
| 2006-04-18 | CHY | ETF | 15.77 | 15.83 | 15.66 | 15.73 | 156100.0 |
| 2006-04-18 | CIL | ETF | 25.67 | 25.69 | 25.67 | 25.69 | 1600.0 |
| 2006-04-18 | CN | ETF | 37.61 | 38.85 | 37.61 | 38.85 | 47400.0 |
| 2006-04-18 | CNXT | ETF | 3.415 | 3.66 | 3.39 | 3.64 | 23579728.0 |
| 2006-04-18 | COMB | ETF | 8.49 | 8.49 | 8.49 | 8.49 | 630.0 |
| 2006-04-18 | CPST | ETF | 4.09 | 4.31 | 4.01 | 4.21 | 7066838.0 |
| 2006-04-18 | CSA | ETF | 19.84 | 19.93 | 19.66 | 19.67 | 287500.0 |
| 2006-04-18 | CSB | ETF | 30.1 | 30.43 | 30.06 | 30.3 | 10700.0 |
| 2006-04-18 | CSM | ETF | 2.495 | 2.495 | 2.495 | 2.495 | 800.0 |
| 2006-04-18 | CSQ | ETF | 13.79 | 13.88 | 13.75 | 13.88 | 291200.0 |
| 2006-04-18 | CTEC | ETF | 64.95 | 65.0 | 63.349999999999994 | 64.05 | 8783.0 |
| 2006-04-18 | CYB | ETF | 6.041 | 6.08 | 6.0 | 6.0 | 33900.0 |
| 2006-04-18 | DBC | ETF | 25.38 | 25.71 | 25.31 | 25.65 | 886800.0 |
| 2006-04-18 | DGT | ETF | 67.33 | 68.04 | 67.33 | 68.04 | 2200.0 |
| 2006-04-18 | DIG | ETF | 17.7375 | 17.75 | 17.7001 | 17.7001 | 4640.0 |
| 2006-04-18 | DIV | ETF | 11.85 | 12.09 | 11.85 | 12.09 | 23700.0 |
| 2006-04-18 | DRIV | ETF | 43.57 | 44.65 | 43.42 | 44.5 | 512231.0 |
> showing 50 of 311 rows — these rows as CSV