PREVIEW / etf_daily / 2006-05-19
file: by_date/etf_daily/2006/2006-05-19.parquet size: 17 KB rows: 322
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-19 | SPY | ETF | 126.87 | 127.49 | 125.8 | 127.1 | 124309400.0 |
| 2006-05-19 | QQQ | ETF | 39.17 | 39.47 | 38.75 | 39.35 | 194311800.0 |
| 2006-05-19 | IWM | ETF | 71.39 | 72.18 | 70.59 | 71.9 | 79031200.0 |
| 2006-05-19 | DIA | ETF | 111.61 | 111.71 | 110.63 | 111.47 | 22180500.0 |
| 2006-05-19 | GLD | ETF | 65.76 | 66.05 | 64.7 | 65.58 | 18687500.0 |
| 2006-05-19 | TLT | ETF | 84.12 | 84.86 | 84.08 | 84.43 | 2619500.0 |
| 2006-05-19 | AAA | ETF | 59.63 | 59.65 | 59.29 | 59.57 | 15900.0 |
| 2006-05-19 | ADRE | ETF | 129.24 | 130.48 | 126.654 | 129.5 | 150528.0 |
| 2006-05-19 | AFK | ETF | 25.19 | 25.2 | 25.19 | 25.1999 | 1200.0 |
| 2006-05-19 | AGG | ETF | 98.17 | 98.41 | 98.13 | 98.24 | 316800.0 |
| 2006-05-19 | AIQ | ETF | 32.7 | 33.35 | 32.1 | 33.1 | 17120.0 |
| 2006-05-19 | AIS | ETF | 1.45 | 1.45 | 1.22 | 1.32 | 775400.0 |
| 2006-05-19 | AOM | ETF | 7.42 | 7.45 | 7.3 | 7.43 | 22200.0 |
| 2006-05-19 | ARB | ETF | 40.01 | 40.5 | 39.75 | 39.81 | 1023700.0 |
| 2006-05-19 | BAB | ETF | 64.7 | 66.6 | 64.39 | 66.16 | 141600.0 |
| 2006-05-19 | BBC | ETF | 11.15 | 11.5399 | 11.05 | 11.18 | 249300.0 |
| 2006-05-19 | BBH | ETF | 56.7633 | 57.88 | 56.34 | 57.8167 | 2875500.0 |
| 2006-05-19 | BCM | ETF | 72.38 | 72.51 | 71.37 | 72.1 | 30400.0 |
| 2006-05-19 | BITS | ETF | 26.24 | 27.12 | 25.04 | 26.2 | 32999.0 |
| 2006-05-19 | BKF | ETF | 7.85 | 7.9 | 7.75 | 7.76 | 115900.0 |
| 2006-05-19 | BNE | ETF | 13.75 | 14.56 | 13.75 | 14.45 | 181400.0 |
| 2006-05-19 | BOSS | ETF | 32.71 | 33.39 | 32.71 | 33.39 | 300.0 |
| 2006-05-19 | BRF | ETF | 14.1 | 14.1 | 13.99 | 13.99 | 2300.0 |
| 2006-05-19 | BTF | ETF | 89.0 | 89.35 | 88.8 | 89.35 | 3400.0 |
| 2006-05-19 | CBON | ETF | 31.11 | 31.94 | 31.11 | 31.31 | 18427.0 |
| 2006-05-19 | CDL | ETF | 10.45 | 10.56 | 10.3301 | 10.46 | 130600.0 |
| 2006-05-19 | CEF | ETF | 9.0 | 9.13 | 8.62 | 9.03 | 2061500.0 |
| 2006-05-19 | CEW | ETF | 25.85 | 25.85 | 25.8 | 25.8 | 300.0 |
| 2006-05-19 | CGO | ETF | 14.8 | 14.85 | 14.56 | 14.63 | 30100.0 |
| 2006-05-19 | CHB | ETF | 13.88 | 14.15 | 13.54 | 14.01 | 569600.0 |
| 2006-05-19 | CHI | ETF | 19.76 | 19.82 | 19.6 | 19.66 | 110800.0 |
| 2006-05-19 | CHIC | ETF | 21.66 | 22.22 | 21.61 | 22.03 | 384476.0 |
| 2006-05-19 | CHY | ETF | 16.07 | 16.17 | 16.05 | 16.14 | 174700.0 |
| 2006-05-19 | CN | ETF | 34.2 | 34.25 | 33.63 | 34.0 | 60300.0 |
| 2006-05-19 | CNXT | ETF | 3.175 | 3.31 | 3.11 | 3.28 | 16784222.0 |
| 2006-05-19 | COMB | ETF | 9.75 | 9.8 | 9.71 | 9.75 | 111935.0 |
| 2006-05-19 | CPST | ETF | 3.125 | 3.14 | 3.03 | 3.09 | 1245000.0 |
| 2006-05-19 | CSA | ETF | 19.25 | 19.25 | 18.74 | 18.74 | 12400.0 |
| 2006-05-19 | CSB | ETF | 29.18 | 29.23 | 28.91 | 29.15 | 10600.0 |
| 2006-05-19 | CSQ | ETF | 13.86 | 13.87 | 13.8 | 13.85 | 238700.0 |
| 2006-05-19 | CTEC | ETF | 63.4 | 64.35 | 62.599999999999994 | 63.699999999999996 | 13909.2 |
| 2006-05-19 | CYB | ETF | 5.85 | 5.9 | 5.76 | 5.9 | 57800.0 |
| 2006-05-19 | DBC | ETF | 25.55 | 25.6 | 25.2 | 25.42 | 724900.0 |
| 2006-05-19 | DGT | ETF | 66.98 | 67.07 | 66.85 | 67.07 | 1500.0 |
| 2006-05-19 | DIG | ETF | 17.7375 | 17.9625 | 17.6875 | 17.6875 | 38000.0 |
| 2006-05-19 | DIV | ETF | 11.8 | 11.8199 | 11.68 | 11.81 | 12200.0 |
| 2006-05-19 | DRIV | ETF | 44.56 | 45.39 | 43.61 | 44.77 | 1341489.0 |
| 2006-05-19 | DSI | ETF | 6.355 | 6.355 | 6.355 | 6.355 | 10000.0 |
| 2006-05-19 | DUSA | ETF | 6.64 | 6.64 | 6.07 | 6.16 | 155587.0 |
| 2006-05-19 | DVY | ETF | 62.21 | 62.84 | 62.09 | 62.46 | 455500.0 |
> showing 50 of 322 rows — these rows as CSV