PREVIEW / etf_daily / 2006-05-04
file: by_date/etf_daily/2006/2006-05-04.parquet size: 16 KB rows: 307
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-04 | SPY | ETF | 131.08 | 131.62 | 130.97 | 131.36 | 42921400.0 |
| 2006-05-04 | QQQ | ETF | 41.53 | 41.99 | 41.53 | 41.83 | 88713481.0 |
| 2006-05-04 | IWM | ETF | 76.25 | 77.09 | 76.25 | 77.09 | 30351900.0 |
| 2006-05-04 | DIA | ETF | 114.14 | 114.63 | 114.14 | 114.33 | 4126700.0 |
| 2006-05-04 | GLD | ETF | 66.76 | 67.67 | 66.22 | 67.48 | 14123500.0 |
| 2006-05-04 | TLT | ETF | 83.38 | 83.4 | 83.1 | 83.1 | 977800.0 |
| 2006-05-04 | AAA | ETF | 61.6 | 62.1 | 61.6 | 62.09 | 5800.0 |
| 2006-05-04 | ADRE | ETF | 143.49 | 143.8 | 142.83 | 143.73 | 41640.0 |
| 2006-05-04 | AFK | ETF | 25.15 | 25.1542 | 25.15 | 25.15 | 2300.0 |
| 2006-05-04 | AGG | ETF | 97.34 | 97.86 | 97.34 | 97.77 | 103100.0 |
| 2006-05-04 | AIQ | ETF | 28.55 | 30.5 | 28.5 | 30.1 | 37400.0 |
| 2006-05-04 | AIS | ETF | 1.55 | 1.55 | 1.47 | 1.5 | 340900.0 |
| 2006-05-04 | AOM | ETF | 6.82 | 6.93 | 6.82 | 6.9 | 8100.0 |
| 2006-05-04 | ARB | ETF | 35.33 | 35.46 | 34.99 | 35.25 | 216100.0 |
| 2006-05-04 | BAB | ETF | 61.71 | 61.87 | 60.89 | 61.41 | 22800.0 |
| 2006-05-04 | BBC | ETF | 13.0 | 13.36 | 12.99 | 13.05 | 367100.0 |
| 2006-05-04 | BBH | ETF | 57.5233 | 57.76 | 57.2333 | 57.35 | 1459500.0 |
| 2006-05-04 | BCM | ETF | 74.29 | 74.38 | 73.64 | 73.94 | 17100.0 |
| 2006-05-04 | BITS | ETF | 34.56 | 35.6 | 34.16 | 35.12 | 26373.0 |
| 2006-05-04 | BKF | ETF | 8.85 | 9.0 | 8.85 | 8.92 | 96800.0 |
| 2006-05-04 | BNE | ETF | 15.76 | 15.98 | 15.7 | 15.98 | 69300.0 |
| 2006-05-04 | BRF | ETF | 14.05 | 14.09 | 14.05 | 14.07 | 6700.0 |
| 2006-05-04 | BTF | ETF | 87.6 | 88.14999999999999 | 87.6 | 88.14999999999999 | 780.0 |
| 2006-05-04 | CBON | ETF | 32.2 | 32.66 | 31.86 | 32.17 | 14158.0 |
| 2006-05-04 | CDL | ETF | 10.06 | 10.06 | 9.73 | 9.96 | 759700.0 |
| 2006-05-04 | CEF | ETF | 9.84 | 10.1 | 9.81 | 10.1 | 1669000.0 |
| 2006-05-04 | CFO | ETF | 10.34 | 10.35 | 10.33 | 10.35 | 12200.0 |
| 2006-05-04 | CGO | ETF | 14.38 | 14.51 | 14.38 | 14.48 | 89200.0 |
| 2006-05-04 | CHB | ETF | 16.35 | 16.4 | 15.83 | 15.97 | 460800.0 |
| 2006-05-04 | CHI | ETF | 20.04 | 20.18 | 20.02 | 20.11 | 60000.0 |
| 2006-05-04 | CHIC | ETF | 22.86 | 23.0 | 22.67 | 22.9 | 448613.0 |
| 2006-05-04 | CHY | ETF | 15.92 | 16.03 | 15.91 | 16.0 | 92200.0 |
| 2006-05-04 | CIL | ETF | 25.78 | 25.8 | 25.78 | 25.8 | 1200.0 |
| 2006-05-04 | CIZ | ETF | 22.7 | 22.7 | 22.7 | 22.7 | 200.0 |
| 2006-05-04 | CN | ETF | 37.85 | 38.56 | 37.85 | 38.44 | 43300.0 |
| 2006-05-04 | CNXT | ETF | 3.55 | 3.6 | 3.52 | 3.54 | 15301351.0 |
| 2006-05-04 | COMB | ETF | 10.15 | 10.2 | 10.15 | 10.2 | 54166.0 |
| 2006-05-04 | CPI | ETF | 31.0 | 31.0 | 31.0 | 31.0 | 400.0 |
| 2006-05-04 | CPST | ETF | 3.98 | 3.98 | 3.83 | 3.94 | 1613518.0 |
| 2006-05-04 | CSA | ETF | 19.2 | 19.79 | 19.2 | 19.42 | 10000.0 |
| 2006-05-04 | CSB | ETF | 30.65 | 31.22 | 30.61 | 31.13 | 7100.0 |
| 2006-05-04 | CSQ | ETF | 13.9 | 13.98 | 13.87 | 13.98 | 338800.0 |
| 2006-05-04 | CTEC | ETF | 61.74999999999999 | 63.75 | 60.9 | 63.15 | 24450.2 |
| 2006-05-04 | CYB | ETF | 6.38 | 6.38 | 6.2901 | 6.37 | 6800.0 |
| 2006-05-04 | DBC | ETF | 25.59 | 25.8 | 25.25 | 25.42 | 445500.0 |
| 2006-05-04 | DGT | ETF | 69.22 | 69.22 | 68.96 | 69.18 | 1100.0 |
| 2006-05-04 | DIV | ETF | 12.04 | 12.08 | 12.03 | 12.08 | 5700.0 |
| 2006-05-04 | DRIV | ETF | 45.74 | 46.4 | 45.44 | 46.0 | 615532.0 |
| 2006-05-04 | DSI | ETF | 6.44 | 6.495 | 6.44 | 6.485 | 20000.0 |
| 2006-05-04 | DUSA | ETF | 6.87 | 6.99 | 6.8 | 6.92 | 56289.0 |
> showing 50 of 307 rows — these rows as CSV