PREVIEW / etf_daily / 2006-04-25
file: by_date/etf_daily/2006/2006-04-25.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-25 | SPY | ETF | 131.04 | 131.12 | 129.92 | 130.37 | 84359800.0 |
| 2006-04-25 | QQQ | ETF | 42.08 | 42.1 | 41.65 | 41.87 | 77660788.0 |
| 2006-04-25 | IWM | ETF | 76.1 | 76.21 | 75.48 | 76.12 | 42940300.0 |
| 2006-04-25 | DIA | ETF | 113.44 | 113.47 | 112.5 | 112.84 | 8235400.0 |
| 2006-04-25 | GLD | ETF | 62.86 | 63.18 | 62.18 | 62.78 | 5611200.0 |
| 2006-04-25 | TLT | ETF | 85.04 | 85.1 | 84.06 | 84.13 | 2067400.0 |
| 2006-04-25 | AAA | ETF | 62.84 | 62.86 | 62.39 | 62.45 | 12600.0 |
| 2006-04-25 | ADRE | ETF | 138.61 | 138.61 | 136.75 | 137.0 | 32304.0 |
| 2006-04-25 | AFK | ETF | 25.1 | 25.1 | 25.011 | 25.02 | 12200.0 |
| 2006-04-25 | AGG | ETF | 98.55 | 98.55 | 98.03 | 98.27 | 110000.0 |
| 2006-04-25 | AIQ | ETF | 25.1 | 26.5 | 24.5505 | 25.9 | 20540.0 |
| 2006-04-25 | AIS | ETF | 1.61 | 1.65 | 1.55 | 1.6 | 205100.0 |
| 2006-04-25 | AOM | ETF | 7.15 | 7.242 | 7.0 | 7.04 | 25000.0 |
| 2006-04-25 | ARB | ETF | 34.19 | 34.41 | 33.72 | 34.41 | 358100.0 |
| 2006-04-25 | BAB | ETF | 61.47 | 61.56 | 60.59 | 61.19 | 23400.0 |
| 2006-04-25 | BBC | ETF | 14.67 | 14.9 | 14.53 | 14.8 | 153300.0 |
| 2006-04-25 | BBH | ETF | 61.1067 | 61.1067 | 59.8833 | 60.4667 | 1274400.0 |
| 2006-04-25 | BCM | ETF | 73.91 | 74.28 | 73.87 | 74.08 | 13100.0 |
| 2006-04-25 | BITS | ETF | 38.6 | 39.0 | 36.96 | 37.68 | 27822.0 |
| 2006-04-25 | BKF | ETF | 8.5 | 8.9 | 8.5 | 8.75 | 100100.0 |
| 2006-04-25 | BNE | ETF | 16.09 | 16.16 | 15.63 | 16.02 | 75800.0 |
| 2006-04-25 | BRF | ETF | 13.9 | 13.91 | 13.83 | 13.88 | 17000.0 |
| 2006-04-25 | BTF | ETF | 87.10000000000001 | 87.44999999999999 | 87.10000000000001 | 87.44999999999999 | 5840.0 |
| 2006-04-25 | CBON | ETF | 33.54 | 33.97 | 32.8 | 33.5199 | 12155.0 |
| 2006-04-25 | CDL | ETF | 9.56 | 9.56 | 9.4 | 9.44 | 736000.0 |
| 2006-04-25 | CEF | ETF | 9.58 | 9.64 | 9.41 | 9.49 | 877600.0 |
| 2006-04-25 | CEW | ETF | 25.75 | 25.8 | 25.75 | 25.8 | 500.0 |
| 2006-04-25 | CFO | ETF | 10.35 | 10.35 | 10.3 | 10.33 | 15600.0 |
| 2006-04-25 | CGO | ETF | 14.44 | 14.44 | 14.25 | 14.3 | 71900.0 |
| 2006-04-25 | CHB | ETF | 15.2 | 15.24 | 14.76 | 14.95 | 666700.0 |
| 2006-04-25 | CHI | ETF | 20.2 | 20.36 | 20.06 | 20.06 | 84800.0 |
| 2006-04-25 | CHIC | ETF | 20.3 | 20.93 | 20.3 | 20.59 | 657183.0 |
| 2006-04-25 | CHY | ETF | 16.05 | 16.06 | 15.9 | 15.93 | 86200.0 |
| 2006-04-25 | CIL | ETF | 25.72 | 25.72 | 25.72 | 25.72 | 1300.0 |
| 2006-04-25 | CN | ETF | 35.94 | 36.1 | 35.49 | 35.5 | 66900.0 |
| 2006-04-25 | CNXT | ETF | 3.71 | 3.7401 | 3.62 | 3.7 | 24482731.0 |
| 2006-04-25 | COMB | ETF | 9.93 | 10.0 | 9.92 | 9.92 | 2268.0 |
| 2006-04-25 | CPI | ETF | 30.75 | 30.76 | 30.75 | 30.76 | 200.0 |
| 2006-04-25 | CPST | ETF | 4.19 | 4.23 | 4.04 | 4.05 | 3104011.0 |
| 2006-04-25 | CSA | ETF | 19.55 | 20.29 | 19.55 | 19.67 | 10800.0 |
| 2006-04-25 | CSB | ETF | 31.54 | 31.54 | 31.17 | 31.34 | 7100.0 |
| 2006-04-25 | CSQ | ETF | 14.07 | 14.1 | 13.95 | 14.05 | 364200.0 |
| 2006-04-25 | CTEC | ETF | 64.0 | 64.0 | 62.099999999999994 | 63.449999999999996 | 9517.2 |
| 2006-04-25 | CYB | ETF | 6.27 | 6.55 | 6.02 | 6.45 | 50000.0 |
| 2006-04-25 | DBC | ETF | 25.83 | 25.9 | 25.52 | 25.7 | 550700.0 |
| 2006-04-25 | DGT | ETF | 68.3 | 68.3 | 68.02 | 68.15 | 2000.0 |
| 2006-04-25 | DIG | ETF | 17.9875 | 17.9875 | 17.9875 | 17.9875 | 80.0 |
| 2006-04-25 | DIV | ETF | 11.99 | 12.06 | 11.9 | 12.05 | 21200.0 |
| 2006-04-25 | DRIV | ETF | 46.55 | 47.8 | 46.1 | 47.15 | 1683403.0 |
| 2006-04-25 | DUSA | ETF | 6.86 | 6.86 | 6.57 | 6.58 | 198420.0 |
> showing 50 of 310 rows — these rows as CSV