PREVIEW / etf_daily / 2005-11-30
file: by_date/etf_daily/2005/2005-11-30.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-11-30 | SPY | ETF | 126.16 | 126.52 | 125.29 | 125.41 | 56007200.0 |
| 2005-11-30 | QQQ | ETF | 41.29 | 41.49 | 41.189 | 41.24 | 88044400.0 |
| 2005-11-30 | IWM | ETF | 67.13 | 67.78 | 67.07 | 67.45 | 38323000.0 |
| 2005-11-30 | DIA | ETF | 108.98 | 109.28 | 108.07 | 108.22 | 6149900.0 |
| 2005-11-30 | GLD | ETF | 49.36 | 49.5 | 49.06 | 49.1 | 1833400.0 |
| 2005-11-30 | TLT | ETF | 90.3 | 90.3 | 89.82 | 90.0 | 1642800.0 |
| 2005-11-30 | AAA | ETF | 52.65 | 52.91 | 52.65 | 52.83 | 4100.0 |
| 2005-11-30 | ADRE | ETF | 111.85 | 111.85 | 110.95 | 111.399 | 102288.0 |
| 2005-11-30 | AFK | ETF | 25.41 | 25.5 | 25.41 | 25.44 | 5500.0 |
| 2005-11-30 | AGG | ETF | 100.52 | 100.53 | 100.08 | 100.22 | 158200.0 |
| 2005-11-30 | AIQ | ETF | 27.75 | 28.05 | 27.1 | 27.8 | 8520.0 |
| 2005-11-30 | AIS | ETF | 1.29 | 1.29 | 1.19 | 1.2 | 265600.0 |
| 2005-11-30 | AOM | ETF | 3.5 | 3.5 | 3.45 | 3.5 | 4000.0 |
| 2005-11-30 | ARB | ETF | 38.56 | 39.26 | 38.54 | 38.6 | 181000.0 |
| 2005-11-30 | BAB | ETF | 54.26 | 54.54 | 53.94 | 54.05 | 96800.0 |
| 2005-11-30 | BBC | ETF | 9.85 | 10.18 | 9.4 | 10.0 | 243800.0 |
| 2005-11-30 | BBH | ETF | 68.1167 | 68.5533 | 67.8633 | 68.1667 | 1286400.0 |
| 2005-11-30 | BCM | ETF | 65.19 | 65.37 | 64.76 | 64.76 | 23600.0 |
| 2005-11-30 | BITS | ETF | 13.6 | 13.88 | 13.4 | 13.6832 | 6246.0 |
| 2005-11-30 | BKF | ETF | 20.68 | 21.4 | 20.61 | 20.65 | 59700.0 |
| 2005-11-30 | BNE | ETF | 15.01 | 15.02 | 14.59 | 14.79 | 251800.0 |
| 2005-11-30 | BRF | ETF | 15.08 | 15.13 | 15.07 | 15.12 | 2800.0 |
| 2005-11-30 | BTF | ETF | 88.94999999999999 | 89.14999999999999 | 87.75 | 87.85 | 6040.0 |
| 2005-11-30 | CBON | ETF | 33.08 | 33.12 | 31.57 | 32.37 | 22981.0 |
| 2005-11-30 | CDL | ETF | 13.39 | 13.54 | 13.35 | 13.48 | 270600.0 |
| 2005-11-30 | CEF | ETF | 6.28 | 6.28 | 6.19 | 6.21 | 323000.0 |
| 2005-11-30 | CEW | ETF | 26.0 | 26.0 | 26.0 | 26.0 | 800.0 |
| 2005-11-30 | CGO | ETF | 13.45 | 13.45 | 13.25 | 13.35 | 45300.0 |
| 2005-11-30 | CHB | ETF | 14.38 | 14.79 | 14.34 | 14.47 | 497800.0 |
| 2005-11-30 | CHI | ETF | 20.0 | 20.29 | 19.9909 | 20.26 | 77400.0 |
| 2005-11-30 | CHIC | ETF | 18.61 | 18.85 | 18.55 | 18.7 | 319669.0 |
| 2005-11-30 | CHIR | ETF | 44.25 | 44.3499 | 44.1999 | 44.3001 | 980315.0 |
| 2005-11-30 | CHY | ETF | 15.67 | 15.79 | 15.59 | 15.74 | 111900.0 |
| 2005-11-30 | CIL | ETF | 25.14 | 25.14 | 25.14 | 25.14 | 500.0 |
| 2005-11-30 | CN | ETF | 32.41 | 32.75 | 32.41 | 32.45 | 4800.0 |
| 2005-11-30 | CNXT | ETF | 2.41 | 2.53 | 2.41 | 2.47 | 17544783.0 |
| 2005-11-30 | COMB | ETF | 8.65 | 8.65 | 8.5 | 8.65 | 4890.0 |
| 2005-11-30 | CPI | ETF | 26.59 | 26.949 | 26.59 | 26.75 | 700.0 |
| 2005-11-30 | CPST | ETF | 3.35 | 3.49 | 3.34 | 3.39 | 3978106.0 |
| 2005-11-30 | CSA | ETF | 16.88 | 16.9 | 16.6 | 16.75 | 113600.0 |
| 2005-11-30 | CSB | ETF | 29.26 | 29.36 | 29.18 | 29.21 | 12400.0 |
| 2005-11-30 | CSQ | ETF | 13.1 | 13.21 | 13.08 | 13.2 | 621800.0 |
| 2005-11-30 | CTEC | ETF | 46.25 | 47.99999999999999 | 46.25 | 47.4 | 15038.400000000001 |
| 2005-11-30 | CURE | ETF | 0.0825 | 0.0825 | 0.0813 | 0.0813 | 1476104.0 |
| 2005-11-30 | CYB | ETF | 3.64 | 3.68 | 3.64 | 3.68 | 1200.0 |
| 2005-11-30 | DGT | ETF | 65.25 | 65.49 | 64.98 | 64.98 | 4000.0 |
| 2005-11-30 | DIG | ETF | 15.1125 | 15.1125 | 14.6875 | 14.7375 | 4080.0 |
| 2005-11-30 | DIV | ETF | 12.03 | 12.08 | 12.01 | 12.04 | 24500.0 |
| 2005-11-30 | DRIV | ETF | 24.77 | 25.93 | 24.0 | 25.92 | 4285370.0 |
| 2005-11-30 | DSI | ETF | 5.995 | 5.995 | 5.995 | 5.995 | 1000.0 |
> showing 50 of 293 rows — these rows as CSV