PREVIEW / etf_daily / 2006-04-07
file: by_date/etf_daily/2006/2006-04-07.parquet size: 16 KB rows: 310
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-07 | SPY | ETF | 131.06 | 131.4 | 129.35 | 129.54 | 80180900.0 |
| 2006-04-07 | QQQ | ETF | 42.89 | 43.05 | 42.3 | 42.32 | 116609375.0 |
| 2006-04-07 | IWM | ETF | 76.37 | 76.69 | 74.86 | 75.01 | 51457700.0 |
| 2006-04-07 | DIA | ETF | 112.46 | 112.7 | 111.09 | 111.24 | 7292800.0 |
| 2006-04-07 | GLD | ETF | 58.67 | 58.82 | 58.22 | 58.59 | 3427000.0 |
| 2006-04-07 | TLT | ETF | 85.43 | 85.63 | 84.9 | 85.1 | 1956500.0 |
| 2006-04-07 | AAA | ETF | 61.7 | 61.71 | 60.5276 | 60.53 | 3200.0 |
| 2006-04-07 | ADRE | ETF | 134.8 | 134.87 | 132.3 | 132.359 | 34624.0 |
| 2006-04-07 | AFK | ETF | 25.12 | 25.17 | 25.11 | 25.11 | 5400.0 |
| 2006-04-07 | AGG | ETF | 98.57 | 98.57 | 98.17 | 98.39 | 250100.0 |
| 2006-04-07 | AIQ | ETF | 30.2 | 30.25 | 29.5 | 29.75 | 14540.0 |
| 2006-04-07 | AIS | ETF | 1.58 | 1.58 | 1.45 | 1.55 | 259800.0 |
| 2006-04-07 | AOM | ETF | 6.86 | 6.86 | 6.7 | 6.79 | 15500.0 |
| 2006-04-07 | ARB | ETF | 33.2 | 33.62 | 32.8 | 33.09 | 320600.0 |
| 2006-04-07 | BAB | ETF | 61.23 | 61.32 | 60.28 | 60.29 | 21500.0 |
| 2006-04-07 | BBC | ETF | 16.65 | 16.89 | 16.65 | 16.79 | 149400.0 |
| 2006-04-07 | BBH | ETF | 62.8433 | 63.0833 | 61.8333 | 61.9833 | 1681800.0 |
| 2006-04-07 | BCM | ETF | 74.36 | 74.68 | 73.64 | 73.78 | 22600.0 |
| 2006-04-07 | BITS | ETF | 31.6 | 31.72 | 30.4 | 30.56 | 13964.0 |
| 2006-04-07 | BKF | ETF | 10.41 | 10.5 | 10.15 | 10.17 | 171000.0 |
| 2006-04-07 | BNE | ETF | 16.36 | 16.66 | 15.97 | 16.09 | 108100.0 |
| 2006-04-07 | BRF | ETF | 14.0 | 14.13 | 14.0 | 14.11 | 56700.0 |
| 2006-04-07 | BTF | ETF | 88.69999999999999 | 88.85 | 88.1 | 88.24999999999999 | 2940.0 |
| 2006-04-07 | CBON | ETF | 31.68 | 31.79 | 30.6 | 30.97 | 26118.0 |
| 2006-04-07 | CDL | ETF | 10.74 | 10.82 | 10.62 | 10.68 | 240300.0 |
| 2006-04-07 | CEF | ETF | 8.65 | 8.74 | 8.59 | 8.72 | 895600.0 |
| 2006-04-07 | CEW | ETF | 25.52 | 25.52 | 25.52 | 25.52 | 300.0 |
| 2006-04-07 | CFO | ETF | 10.2 | 10.2 | 10.15 | 10.19 | 6000.0 |
| 2006-04-07 | CGO | ETF | 14.55 | 14.55 | 14.35 | 14.36 | 74700.0 |
| 2006-04-07 | CHB | ETF | 15.28 | 15.45 | 15.16 | 15.33 | 446800.0 |
| 2006-04-07 | CHI | ETF | 20.91 | 20.91 | 20.7 | 20.75 | 74900.0 |
| 2006-04-07 | CHIC | ETF | 21.31 | 21.39 | 20.78 | 20.94 | 170249.0 |
| 2006-04-07 | CHIR | ETF | 47.9199 | 47.9301 | 47.8701 | 47.9199 | 812601.0 |
| 2006-04-07 | CHY | ETF | 16.39 | 16.4 | 16.28 | 16.32 | 94600.0 |
| 2006-04-07 | CN | ETF | 36.35 | 36.44 | 35.96 | 36.0 | 27400.0 |
| 2006-04-07 | CNXT | ETF | 3.79 | 3.81 | 3.68 | 3.78 | 22353257.0 |
| 2006-04-07 | CPI | ETF | 30.5 | 30.5 | 30.5 | 30.5 | 2000.0 |
| 2006-04-07 | CPST | ETF | 3.74 | 3.8 | 3.71 | 3.77 | 2784301.0 |
| 2006-04-07 | CSA | ETF | 20.67 | 20.67 | 20.45 | 20.46 | 10400.0 |
| 2006-04-07 | CSB | ETF | 30.8 | 30.8 | 30.23 | 30.23 | 9400.0 |
| 2006-04-07 | CSM | ETF | 2.495 | 2.495 | 2.495 | 2.495 | 1600.0 |
| 2006-04-07 | CSQ | ETF | 14.09 | 14.14 | 14.05 | 14.08 | 331600.0 |
| 2006-04-07 | CTEC | ETF | 65.55 | 66.2 | 64.5 | 64.89999999999999 | 3717.2000000000003 |
| 2006-04-07 | CYB | ETF | 6.13 | 6.2 | 6.01 | 6.09 | 15900.0 |
| 2006-04-07 | DBC | ETF | 24.35 | 24.43 | 24.15 | 24.39 | 415600.0 |
| 2006-04-07 | DGT | ETF | 67.85 | 67.85 | 67.24 | 67.28 | 3100.0 |
| 2006-04-07 | DIG | ETF | 17.6125 | 17.6875 | 17.5625 | 17.5625 | 9600.0 |
| 2006-04-07 | DIV | ETF | 12.4 | 12.4 | 12.22 | 12.23 | 10700.0 |
| 2006-04-07 | DRIV | ETF | 45.53 | 45.53 | 43.75 | 44.02 | 953958.0 |
| 2006-04-07 | DSI | ETF | 6.295 | 6.3 | 6.27 | 6.27 | 5200.0 |
> showing 50 of 310 rows — these rows as CSV