PREVIEW / etf_daily / 2005-12-13
file: by_date/etf_daily/2005/2005-12-13.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-13 | SPY | ETF | 126.42 | 127.7 | 126.29 | 127.31 | 88630900.0 |
| 2005-12-13 | QQQ | ETF | 41.82 | 42.211 | 41.76 | 42.045 | 76611599.0 |
| 2005-12-13 | IWM | ETF | 68.67 | 69.03 | 68.31 | 68.86 | 24765500.0 |
| 2005-12-13 | DIA | ETF | 107.76 | 108.79 | 107.58 | 108.39 | 7727900.0 |
| 2005-12-13 | GLD | ETF | 52.2 | 53.23 | 51.56 | 51.65 | 6162100.0 |
| 2005-12-13 | TLT | ETF | 89.72 | 89.82 | 89.38 | 89.7 | 598700.0 |
| 2005-12-13 | AAA | ETF | 54.77 | 55.28 | 54.77 | 55.23 | 3000.0 |
| 2005-12-13 | ADRE | ETF | 116.19 | 116.19 | 114.59 | 115.75 | 31368.0 |
| 2005-12-13 | AFK | ETF | 25.22 | 25.22 | 25.11 | 25.13 | 5000.0 |
| 2005-12-13 | AGG | ETF | 99.75 | 100.13 | 99.69 | 100.13 | 152200.0 |
| 2005-12-13 | AIQ | ETF | 29.55 | 30.0 | 28.15 | 28.85 | 22900.0 |
| 2005-12-13 | AIS | ETF | 1.49 | 1.49 | 1.36 | 1.41 | 240900.0 |
| 2005-12-13 | AOM | ETF | 3.45 | 3.5 | 3.35 | 3.45 | 7300.0 |
| 2005-12-13 | ARB | ETF | 39.59 | 40.27 | 39.53 | 40.03 | 128500.0 |
| 2005-12-13 | BAB | ETF | 59.32 | 59.69 | 59.25 | 59.51 | 29900.0 |
| 2005-12-13 | BBC | ETF | 12.9 | 12.93 | 12.28 | 12.335 | 263300.0 |
| 2005-12-13 | BBH | ETF | 67.3333 | 68.17 | 67.3333 | 68.1 | 1406100.0 |
| 2005-12-13 | BCM | ETF | 64.81 | 65.34 | 64.65 | 65.09 | 35700.0 |
| 2005-12-13 | BITS | ETF | 13.2 | 13.6 | 12.84 | 13.2 | 3746.0 |
| 2005-12-13 | BKF | ETF | 20.12 | 20.8 | 20.1 | 20.6 | 50700.0 |
| 2005-12-13 | BNE | ETF | 15.26 | 15.32 | 14.82 | 14.83 | 147900.0 |
| 2005-12-13 | BRF | ETF | 15.05 | 15.1 | 15.0 | 15.04 | 15000.0 |
| 2005-12-13 | BTF | ETF | 88.39949999999999 | 88.39949999999999 | 87.24999999999999 | 88.1 | 4600.0 |
| 2005-12-13 | CBON | ETF | 31.2 | 31.3501 | 31.1 | 31.25 | 52222.0 |
| 2005-12-13 | CDL | ETF | 13.38 | 13.57 | 13.3175 | 13.45 | 238300.0 |
| 2005-12-13 | CEF | ETF | 6.22 | 6.32 | 6.14 | 6.27 | 958500.0 |
| 2005-12-13 | CEW | ETF | 25.92 | 26.0 | 25.92 | 26.0 | 1300.0 |
| 2005-12-13 | CGO | ETF | 13.53 | 13.6 | 13.25 | 13.58 | 55800.0 |
| 2005-12-13 | CHB | ETF | 14.42 | 14.61 | 14.3 | 14.31 | 603900.0 |
| 2005-12-13 | CHI | ETF | 20.5 | 20.58 | 20.5 | 20.51 | 93900.0 |
| 2005-12-13 | CHIC | ETF | 19.7 | 20.21 | 19.69 | 20.01 | 155371.0 |
| 2005-12-13 | CHIR | ETF | 44.5101 | 44.7099 | 44.49 | 44.5701 | 1085075.0 |
| 2005-12-13 | CHY | ETF | 15.95 | 15.95 | 15.76 | 15.89 | 104800.0 |
| 2005-12-13 | CIL | ETF | 25.19 | 25.19 | 25.19 | 25.19 | 1800.0 |
| 2005-12-13 | CN | ETF | 30.75 | 31.55 | 30.73 | 31.3 | 49900.0 |
| 2005-12-13 | CNXT | ETF | 2.6 | 2.64 | 2.57 | 2.59 | 7153432.0 |
| 2005-12-13 | CPI | ETF | 27.5 | 27.5 | 27.5 | 27.5 | 400.0 |
| 2005-12-13 | CPST | ETF | 3.68 | 3.68 | 3.52 | 3.53 | 1970401.0 |
| 2005-12-13 | CSA | ETF | 16.19 | 16.3 | 15.8 | 16.18 | 52900.0 |
| 2005-12-13 | CSB | ETF | 31.2 | 31.5 | 31.11 | 31.42 | 31000.0 |
| 2005-12-13 | CSQ | ETF | 12.86 | 12.98 | 12.79 | 12.96 | 746800.0 |
| 2005-12-13 | CTEC | ETF | 51.199999999999996 | 51.5 | 50.449999999999996 | 50.65 | 3908.0 |
| 2005-12-13 | CURE | ETF | 0.025 | 0.025 | 0.0213 | 0.0213 | 2958136.0 |
| 2005-12-13 | CYB | ETF | 3.5 | 3.5 | 3.5 | 3.5 | 2700.0 |
| 2005-12-13 | DGT | ETF | 65.88 | 65.88 | 65.88 | 65.88 | 100.0 |
| 2005-12-13 | DIG | ETF | 15.575 | 15.6625 | 15.5 | 15.6625 | 3280.0 |
| 2005-12-13 | DIV | ETF | 11.97 | 11.99 | 11.9 | 11.95 | 27700.0 |
| 2005-12-13 | DRIV | ETF | 28.71 | 29.7 | 28.07 | 29.55 | 1255250.0 |
| 2005-12-13 | DUSA | ETF | 9.6 | 9.82 | 9.52 | 9.63 | 98451.0 |
| 2005-12-13 | DVY | ETF | 62.02 | 62.74 | 62.02 | 62.6 | 329000.0 |
> showing 50 of 295 rows — these rows as CSV