PREVIEW / etf_daily / 2006-01-05
file: by_date/etf_daily/2006/2006-01-05.parquet size: 16 KB rows: 298
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-01-05 | SPY | ETF | 127.15 | 127.59 | 126.88 | 127.38 | 47307500.0 |
| 2006-01-05 | QQQ | ETF | 41.75 | 42.0 | 41.7065 | 41.92 | 77692071.0 |
| 2006-01-05 | IWM | ETF | 68.43 | 68.79 | 68.25 | 68.79 | 23712300.0 |
| 2006-01-05 | DIA | ETF | 108.51 | 109.02 | 108.36 | 108.88 | 4843600.0 |
| 2006-01-05 | GLD | ETF | 52.56 | 52.72 | 52.1 | 52.34 | 7661800.0 |
| 2006-01-05 | TLT | ETF | 91.88 | 92.14 | 91.7 | 91.89 | 453400.0 |
| 2006-01-05 | AAA | ETF | 56.27 | 56.3 | 56.0 | 56.07 | 2700.0 |
| 2006-01-05 | ADRE | ETF | 121.4 | 122.95 | 120.17 | 120.43 | 50584.0 |
| 2006-01-05 | AFK | ETF | 25.2 | 25.29 | 25.2 | 25.29 | 8200.0 |
| 2006-01-05 | AGG | ETF | 100.82 | 100.91 | 100.61 | 100.88 | 203100.0 |
| 2006-01-05 | AIQ | ETF | 29.1 | 29.45 | 28.45 | 28.95 | 6580.0 |
| 2006-01-05 | AIS | ETF | 1.63 | 1.63 | 1.51 | 1.53 | 234200.0 |
| 2006-01-05 | AOM | ETF | 4.39 | 4.39 | 4.25 | 4.32 | 19000.0 |
| 2006-01-05 | ARB | ETF | 38.39 | 38.65 | 38.2 | 38.38 | 76600.0 |
| 2006-01-05 | BAB | ETF | 59.51 | 59.51 | 58.66 | 58.97 | 12600.0 |
| 2006-01-05 | BBC | ETF | 15.7 | 15.9 | 15.25 | 15.45 | 277200.0 |
| 2006-01-05 | BBH | ETF | 68.3333 | 68.55 | 68.0833 | 68.22 | 1107300.0 |
| 2006-01-05 | BCM | ETF | 67.39 | 67.75 | 67.24 | 67.47 | 61200.0 |
| 2006-01-05 | BITS | ETF | 14.8 | 14.88 | 14.24 | 14.4 | 6325.0 |
| 2006-01-05 | BKF | ETF | 18.82 | 19.17 | 18.75 | 19.01 | 20600.0 |
| 2006-01-05 | BNE | ETF | 14.75 | 14.93 | 14.57 | 14.85 | 122100.0 |
| 2006-01-05 | BRF | ETF | 15.42 | 15.42 | 15.37 | 15.38 | 3000.0 |
| 2006-01-05 | BTF | ETF | 84.49999999999999 | 85.1 | 84.14999999999999 | 84.14999999999999 | 2400.0 |
| 2006-01-05 | CBON | ETF | 32.13 | 32.34 | 31.87 | 32.22 | 10037.0 |
| 2006-01-05 | CDL | ETF | 13.5 | 13.55 | 13.37 | 13.43 | 347200.0 |
| 2006-01-05 | CEF | ETF | 7.1 | 7.1 | 6.87 | 6.88 | 747300.0 |
| 2006-01-05 | CEW | ETF | 26.11 | 26.12 | 26.11 | 26.12 | 200.0 |
| 2006-01-05 | CFO | ETF | 9.85 | 9.9 | 9.85 | 9.85 | 8900.0 |
| 2006-01-05 | CGO | ETF | 14.21 | 14.25 | 14.1 | 14.14 | 18700.0 |
| 2006-01-05 | CHB | ETF | 13.49 | 13.57 | 13.4 | 13.45 | 681100.0 |
| 2006-01-05 | CHI | ETF | 20.14 | 20.36 | 20.13 | 20.23 | 69400.0 |
| 2006-01-05 | CHIC | ETF | 21.3 | 21.5 | 21.12 | 21.39 | 268323.0 |
| 2006-01-05 | CHIR | ETF | 44.7099 | 44.73 | 44.5899 | 44.7099 | 619942.0 |
| 2006-01-05 | CHY | ETF | 16.1 | 16.14 | 15.93 | 15.95 | 113000.0 |
| 2006-01-05 | CIL | ETF | 25.3 | 25.3 | 25.3 | 25.3 | 1000.0 |
| 2006-01-05 | CN | ETF | 33.03 | 33.2 | 33.03 | 33.06 | 25900.0 |
| 2006-01-05 | CNXT | ETF | 2.67 | 2.68 | 2.54 | 2.6 | 25791862.0 |
| 2006-01-05 | COMB | ETF | 8.21 | 8.21 | 8.21 | 8.21 | 500.0 |
| 2006-01-05 | CPI | ETF | 27.75 | 27.75 | 27.75 | 27.75 | 200.0 |
| 2006-01-05 | CPST | ETF | 3.27 | 3.28 | 3.1 | 3.15 | 2883992.0 |
| 2006-01-05 | CSA | ETF | 17.45 | 17.49 | 17.15 | 17.3 | 51300.0 |
| 2006-01-05 | CSB | ETF | 32.61 | 32.65 | 32.43 | 32.56 | 27800.0 |
| 2006-01-05 | CSM | ETF | 2.4625 | 2.4625 | 2.45 | 2.45 | 46400.0 |
| 2006-01-05 | CSQ | ETF | 13.81 | 13.85 | 13.7 | 13.71 | 351900.0 |
| 2006-01-05 | CTEC | ETF | 52.099999999999994 | 52.099999999999994 | 50.613499999999995 | 51.3 | 7533.0 |
| 2006-01-05 | CURE | ETF | 0.0288 | 0.0312 | 0.0288 | 0.03 | 2730456.0 |
| 2006-01-05 | CYB | ETF | 3.62 | 3.62 | 3.5 | 3.54 | 6500.0 |
| 2006-01-05 | DGT | ETF | 66.8 | 66.87 | 66.63 | 66.73 | 3200.0 |
| 2006-01-05 | DIG | ETF | 16.775 | 16.875 | 16.65 | 16.65 | 10480.0 |
| 2006-01-05 | DIV | ETF | 12.31 | 12.42 | 12.31 | 12.39 | 19400.0 |
> showing 50 of 298 rows — these rows as CSV