PREVIEW / etf_daily / 2005-12-06
file: by_date/etf_daily/2005/2005-12-06.parquet size: 16 KB rows: 293
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-06 | SPY | ETF | 127.05 | 127.74 | 126.63 | 126.82 | 57935200.0 |
| 2005-12-06 | QQQ | ETF | 42.03 | 42.31 | 41.9 | 41.936 | 81509365.0 |
| 2005-12-06 | IWM | ETF | 68.61 | 69.08 | 68.35 | 68.54 | 26482100.0 |
| 2005-12-06 | DIA | ETF | 108.81 | 109.28 | 108.48 | 108.7 | 5144600.0 |
| 2005-12-06 | GLD | ETF | 50.38 | 50.95 | 50.21 | 50.89 | 2493600.0 |
| 2005-12-06 | TLT | ETF | 89.41 | 90.12 | 89.32 | 90.01 | 968800.0 |
| 2005-12-06 | AAA | ETF | 53.93 | 54.0 | 53.75 | 53.87 | 3600.0 |
| 2005-12-06 | ADRE | ETF | 115.39 | 115.77 | 114.6101 | 115.48 | 13724.0 |
| 2005-12-06 | AFK | ETF | 25.55 | 25.59 | 25.45 | 25.58 | 11500.0 |
| 2005-12-06 | AGG | ETF | 99.86 | 100.0 | 99.67 | 99.92 | 186000.0 |
| 2005-12-06 | AIQ | ETF | 27.75 | 28.75 | 27.3 | 28.35 | 20460.0 |
| 2005-12-06 | AIS | ETF | 1.38 | 1.4 | 1.32 | 1.36 | 477300.0 |
| 2005-12-06 | AOM | ETF | 3.35 | 3.43 | 3.35 | 3.4 | 1300.0 |
| 2005-12-06 | ARB | ETF | 39.7 | 40.78 | 39.7 | 39.97 | 223500.0 |
| 2005-12-06 | BAB | ETF | 56.53 | 57.38 | 56.26 | 56.78 | 52800.0 |
| 2005-12-06 | BBC | ETF | 12.3 | 13.65 | 11.95 | 12.68 | 1186300.0 |
| 2005-12-06 | BBH | ETF | 69.8633 | 69.9167 | 68.5033 | 68.5467 | 2376600.0 |
| 2005-12-06 | BCM | ETF | 65.69 | 65.91 | 65.47 | 65.74 | 31400.0 |
| 2005-12-06 | BITS | ETF | 13.6 | 14.0 | 13.04 | 13.44 | 9447.0 |
| 2005-12-06 | BKF | ETF | 21.2 | 21.41 | 20.5 | 20.5 | 43700.0 |
| 2005-12-06 | BNE | ETF | 15.28 | 15.46 | 15.08 | 15.08 | 81900.0 |
| 2005-12-06 | BRF | ETF | 15.17 | 15.27 | 15.04 | 15.07 | 27900.0 |
| 2005-12-06 | BTF | ETF | 88.49999999999999 | 88.49999999999999 | 87.55 | 88.0 | 3560.0 |
| 2005-12-06 | CBON | ETF | 31.11 | 31.26 | 31.0 | 31.06 | 37043.0 |
| 2005-12-06 | CDL | ETF | 13.75 | 13.76 | 13.55 | 13.61 | 1157900.0 |
| 2005-12-06 | CEF | ETF | 6.26 | 6.39 | 6.23 | 6.35 | 414900.0 |
| 2005-12-06 | CEW | ETF | 26.1 | 26.1 | 26.1 | 26.1 | 300.0 |
| 2005-12-06 | CGO | ETF | 13.37 | 13.47 | 13.22 | 13.37 | 53700.0 |
| 2005-12-06 | CHB | ETF | 14.74 | 14.99 | 14.53 | 14.54 | 562200.0 |
| 2005-12-06 | CHI | ETF | 20.5 | 20.5 | 20.31 | 20.44 | 76500.0 |
| 2005-12-06 | CHIC | ETF | 19.4 | 19.59 | 19.04 | 19.2 | 501204.0 |
| 2005-12-06 | CHIR | ETF | 44.31 | 44.7201 | 44.2899 | 44.46 | 1201564.0 |
| 2005-12-06 | CHY | ETF | 15.94 | 15.96 | 15.85 | 15.92 | 110600.0 |
| 2005-12-06 | CIL | ETF | 25.32 | 25.32 | 25.2 | 25.2 | 400.0 |
| 2005-12-06 | CN | ETF | 31.4 | 31.4 | 31.15 | 31.21 | 14600.0 |
| 2005-12-06 | CNXT | ETF | 2.66 | 2.72 | 2.5699 | 2.58 | 14841583.0 |
| 2005-12-06 | COMB | ETF | 8.55 | 8.55 | 8.25 | 8.55 | 9300.0 |
| 2005-12-06 | CPST | ETF | 3.65 | 3.78 | 3.61 | 3.66 | 8251913.0 |
| 2005-12-06 | CSA | ETF | 16.51 | 16.74 | 16.51 | 16.73 | 39500.0 |
| 2005-12-06 | CSB | ETF | 30.08 | 30.27 | 29.96 | 30.09 | 10100.0 |
| 2005-12-06 | CSM | ETF | 2.445 | 2.4475 | 2.445 | 2.4475 | 4400.0 |
| 2005-12-06 | CSQ | ETF | 13.06 | 13.12 | 13.03 | 13.07 | 610300.0 |
| 2005-12-06 | CTEC | ETF | 52.5 | 55.0 | 52.5 | 52.99999999999999 | 28603.600000000002 |
| 2005-12-06 | CURE | ETF | 0.0262 | 0.0338 | 0.0138 | 0.02 | 24708008.0 |
| 2005-12-06 | CYB | ETF | 3.62 | 3.62 | 3.62 | 3.62 | 900.0 |
| 2005-12-06 | DGT | ETF | 65.85 | 66.22 | 65.85 | 65.88 | 25200.0 |
| 2005-12-06 | DIG | ETF | 15.25 | 15.3125 | 15.025 | 15.0375 | 5440.0 |
| 2005-12-06 | DIV | ETF | 12.0 | 12.09 | 12.0 | 12.03 | 22400.0 |
| 2005-12-06 | DRIV | ETF | 29.4 | 29.61 | 29.08 | 29.21 | 1112537.0 |
| 2005-12-06 | DSI | ETF | 6.015 | 6.015 | 6.015 | 6.015 | 4800.0 |
> showing 50 of 293 rows — these rows as CSV