PREVIEW / etf_daily / 2005-12-14
file: by_date/etf_daily/2005/2005-12-14.parquet size: 16 KB rows: 295
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-14 | SPY | ETF | 127.19 | 128.09 | 127.14 | 127.81 | 64375000.0 |
| 2005-12-14 | QQQ | ETF | 41.95 | 42.096 | 41.708 | 41.899 | 73581550.0 |
| 2005-12-14 | IWM | ETF | 68.76 | 69.16 | 68.42 | 68.78 | 26972600.0 |
| 2005-12-14 | DIA | ETF | 108.42 | 109.29 | 108.42 | 109.0 | 7047400.0 |
| 2005-12-14 | GLD | ETF | 50.95 | 51.2 | 50.25 | 50.35 | 6994000.0 |
| 2005-12-14 | TLT | ETF | 90.2 | 90.82 | 90.14 | 90.62 | 635000.0 |
| 2005-12-14 | AAA | ETF | 55.42 | 55.52 | 55.16 | 55.4 | 1500.0 |
| 2005-12-14 | ADRE | ETF | 116.29 | 116.6145 | 114.75 | 115.37 | 15960.0 |
| 2005-12-14 | AFK | ETF | 25.14 | 25.43 | 25.14 | 25.18 | 10500.0 |
| 2005-12-14 | AGG | ETF | 100.24 | 100.49 | 100.14 | 100.4 | 202200.0 |
| 2005-12-14 | AIQ | ETF | 28.85 | 29.35 | 27.0 | 27.35 | 19900.0 |
| 2005-12-14 | AIS | ETF | 1.44 | 1.45 | 1.34 | 1.4 | 140800.0 |
| 2005-12-14 | AOM | ETF | 3.4 | 3.94 | 3.4 | 3.87 | 36200.0 |
| 2005-12-14 | ARB | ETF | 40.08 | 40.46 | 40.01 | 40.05 | 73000.0 |
| 2005-12-14 | BAB | ETF | 59.79 | 60.43 | 59.68 | 60.0 | 39800.0 |
| 2005-12-14 | BBC | ETF | 12.34 | 14.45 | 12.34 | 14.42 | 1153700.0 |
| 2005-12-14 | BBH | ETF | 68.1833 | 68.2067 | 67.0333 | 67.0933 | 1578600.0 |
| 2005-12-14 | BCM | ETF | 65.29 | 65.53 | 64.94 | 65.23 | 31100.0 |
| 2005-12-14 | BITS | ETF | 12.72 | 13.48 | 12.6 | 13.2 | 3653.0 |
| 2005-12-14 | BKF | ETF | 20.5 | 20.65 | 20.01 | 20.04 | 50600.0 |
| 2005-12-14 | BNE | ETF | 14.93 | 15.03 | 14.56 | 14.82 | 158200.0 |
| 2005-12-14 | BRF | ETF | 15.04 | 15.2 | 15.0 | 15.2 | 26600.0 |
| 2005-12-14 | BTF | ETF | 87.75 | 88.1 | 86.6 | 88.1 | 2720.0 |
| 2005-12-14 | CBON | ETF | 31.37 | 31.75 | 31.37 | 31.75 | 7449.0 |
| 2005-12-14 | CDL | ETF | 13.46 | 13.59 | 13.4 | 13.5 | 240700.0 |
| 2005-12-14 | CEF | ETF | 6.24 | 6.25 | 6.16 | 6.17 | 667600.0 |
| 2005-12-14 | CEW | ETF | 25.87 | 25.96 | 25.87 | 25.96 | 300.0 |
| 2005-12-14 | CGO | ETF | 13.57 | 13.57 | 13.32 | 13.45 | 39100.0 |
| 2005-12-14 | CHB | ETF | 14.4 | 15.05 | 14.39 | 14.96 | 384400.0 |
| 2005-12-14 | CHI | ETF | 20.52 | 20.57 | 20.28 | 20.39 | 131100.0 |
| 2005-12-14 | CHIC | ETF | 20.05 | 20.37 | 19.51 | 19.97 | 235557.0 |
| 2005-12-14 | CHIR | ETF | 44.5701 | 44.7 | 44.52 | 44.6799 | 2501538.0 |
| 2005-12-14 | CHY | ETF | 15.83 | 15.8899 | 15.75 | 15.82 | 123300.0 |
| 2005-12-14 | CIL | ETF | 25.2 | 25.2 | 25.2 | 25.2 | 1000.0 |
| 2005-12-14 | CIZ | ETF | 21.78 | 21.78 | 21.78 | 21.78 | 400.0 |
| 2005-12-14 | CN | ETF | 32.7 | 32.97 | 32.7 | 32.97 | 13300.0 |
| 2005-12-14 | CNXT | ETF | 2.58 | 2.58 | 2.47 | 2.53 | 12788365.0 |
| 2005-12-14 | CPI | ETF | 27.6 | 27.8 | 27.6 | 27.8 | 400.0 |
| 2005-12-14 | CPST | ETF | 3.53 | 3.63 | 3.48 | 3.5 | 1778352.0 |
| 2005-12-14 | CSA | ETF | 16.18 | 16.18 | 15.95 | 16.1 | 30100.0 |
| 2005-12-14 | CSB | ETF | 31.3 | 31.53 | 31.3 | 31.47 | 5000.0 |
| 2005-12-14 | CSQ | ETF | 12.91 | 12.94 | 12.82 | 12.88 | 826900.0 |
| 2005-12-14 | CTEC | ETF | 50.099999999999994 | 50.599999999999994 | 49.1 | 49.800000000000004 | 5991.400000000001 |
| 2005-12-14 | CURE | ETF | 0.0225 | 0.0225 | 0.015 | 0.02 | 3881528.0 |
| 2005-12-14 | CYB | ETF | 3.5 | 3.5 | 3.4 | 3.45 | 9200.0 |
| 2005-12-14 | DGT | ETF | 65.88 | 66.35 | 65.88 | 66.28 | 16800.0 |
| 2005-12-14 | DIG | ETF | 15.5 | 15.625 | 15.5 | 15.6125 | 3360.0 |
| 2005-12-14 | DIV | ETF | 11.9 | 11.96 | 11.88 | 11.92 | 48500.0 |
| 2005-12-14 | DRIV | ETF | 29.44 | 29.7 | 29.01 | 29.65 | 748810.0 |
| 2005-12-14 | DSI | ETF | 6.095 | 6.1 | 6.095 | 6.095 | 10600.0 |
> showing 50 of 295 rows — these rows as CSV