PREVIEW / etf_daily / 2005-10-11
file: by_date/etf_daily/2005/2005-10-11.parquet size: 15 KB rows: 280
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-10-11 | SPY | ETF | 118.99 | 119.39 | 118.32 | 118.43 | 75629800.0 |
| 2005-10-11 | QQQ | ETF | 38.21 | 38.24 | 37.8 | 37.94 | 114769611.0 |
| 2005-10-11 | IWM | ETF | 63.69 | 63.91 | 62.5 | 62.5 | 34321100.0 |
| 2005-10-11 | DIA | ETF | 102.69 | 103.18 | 102.35 | 102.53 | 7939900.0 |
| 2005-10-11 | GLD | ETF | 47.4 | 47.72 | 47.36 | 47.39 | 2826900.0 |
| 2005-10-11 | TLT | ETF | 91.84 | 91.92 | 91.45 | 91.59 | 679100.0 |
| 2005-10-11 | AAA | ETF | 55.91 | 56.26 | 55.8 | 55.8 | 800.0 |
| 2005-10-11 | ADRE | ETF | 105.09 | 105.99 | 101.15 | 105.12 | 19284.0 |
| 2005-10-11 | AFK | ETF | 25.46 | 25.46 | 25.46 | 25.46 | 1000.0 |
| 2005-10-11 | AGG | ETF | 101.14 | 101.19 | 100.82 | 100.83 | 128600.0 |
| 2005-10-11 | AIQ | ETF | 37.65 | 40.0 | 37.65 | 38.75 | 28280.0 |
| 2005-10-11 | AIS | ETF | 0.96 | 1.0 | 0.91 | 0.98 | 95800.0 |
| 2005-10-11 | ARB | ETF | 39.12 | 39.17 | 38.05 | 38.05 | 207200.0 |
| 2005-10-11 | BAB | ETF | 55.34 | 55.39 | 54.57 | 54.64 | 9800.0 |
| 2005-10-11 | BBC | ETF | 7.3 | 7.3 | 7.0 | 7.02 | 14700.0 |
| 2005-10-11 | BBH | ETF | 63.2967 | 63.3 | 61.7267 | 61.95 | 3338400.0 |
| 2005-10-11 | BCM | ETF | 61.2 | 61.21 | 60.34 | 60.85 | 13100.0 |
| 2005-10-11 | BIS | ETF | 600.0 | 600.0 | 596.8 | 596.8 | 15.6 |
| 2005-10-11 | BITS | ETF | 10.76 | 11.24 | 10.68 | 10.76 | 825.0 |
| 2005-10-11 | BKF | ETF | 27.49 | 27.49 | 25.01 | 25.6 | 204600.0 |
| 2005-10-11 | BNE | ETF | 13.83 | 13.83 | 13.32 | 13.32 | 109500.0 |
| 2005-10-11 | BRF | ETF | 15.42 | 15.46 | 15.39 | 15.46 | 3700.0 |
| 2005-10-11 | BTF | ETF | 86.4 | 86.5 | 85.99999999999999 | 86.5 | 420.0 |
| 2005-10-11 | CBON | ETF | 33.0 | 33.0 | 32.5 | 32.51 | 2989.0 |
| 2005-10-11 | CDC | ETF | 3.96 | 4.04 | 3.96 | 4.04 | 7200.0 |
| 2005-10-11 | CDL | ETF | 14.11 | 14.36 | 14.09 | 14.14 | 677700.0 |
| 2005-10-11 | CEF | ETF | 5.8 | 5.85 | 5.78 | 5.8 | 577100.0 |
| 2005-10-11 | CEW | ETF | 25.91 | 25.91 | 25.91 | 25.91 | 800.0 |
| 2005-10-11 | CHB | ETF | 13.65 | 13.71 | 12.9 | 13.1 | 796000.0 |
| 2005-10-11 | CHI | ETF | 20.04 | 20.06 | 19.944 | 19.97 | 105600.0 |
| 2005-10-11 | CHIC | ETF | 15.49 | 15.78 | 14.86 | 15.11 | 452481.0 |
| 2005-10-11 | CHIR | ETF | 43.0299 | 43.4001 | 42.8001 | 43.1001 | 962221.0 |
| 2005-10-11 | CHY | ETF | 16.25 | 16.27 | 16.12 | 16.18 | 91000.0 |
| 2005-10-11 | CIL | ETF | 25.92 | 25.92 | 25.92 | 25.92 | 200.0 |
| 2005-10-11 | CN | ETF | 32.75 | 32.99 | 32.73 | 32.97 | 13100.0 |
| 2005-10-11 | CNXT | ETF | 1.82 | 1.85 | 1.78 | 1.8 | 10996047.0 |
| 2005-10-11 | CPST | ETF | 2.82 | 2.87 | 2.56 | 2.73 | 6358957.0 |
| 2005-10-11 | CSB | ETF | 29.5 | 29.64 | 29.45 | 29.55 | 8900.0 |
| 2005-10-11 | CSQ | ETF | 13.74 | 13.86 | 13.73 | 13.78 | 303600.0 |
| 2005-10-11 | CTEC | ETF | 48.25 | 48.550000000000004 | 47.05 | 47.24999999999999 | 6160.200000000001 |
| 2005-10-11 | CURE | ETF | 0.0975 | 0.1 | 0.0938 | 0.0938 | 859040.0 |
| 2005-10-11 | CYA | ETF | 71.8 | 71.8 | 66.0 | 70.2 | 1035.0 |
| 2005-10-11 | CYB | ETF | 3.3 | 3.3 | 3.25 | 3.27 | 88400.0 |
| 2005-10-11 | DGT | ETF | 63.55 | 63.65 | 63.49 | 63.65 | 2700.0 |
| 2005-10-11 | DIG | ETF | 14.7375 | 14.95 | 14.7375 | 14.75 | 1760.0 |
| 2005-10-11 | DIV | ETF | 12.54 | 12.6 | 12.41 | 12.5 | 23300.0 |
| 2005-10-11 | DRIV | ETF | 33.56 | 34.06 | 33.12 | 33.32 | 803814.0 |
| 2005-10-11 | DSI | ETF | 5.635 | 5.635 | 5.625 | 5.635 | 8800.0 |
| 2005-10-11 | DUSA | ETF | 10.37 | 10.4 | 10.15 | 10.16 | 85060.0 |
| 2005-10-11 | DVY | ETF | 60.11 | 60.26 | 59.69 | 59.74 | 582700.0 |
> showing 50 of 280 rows — these rows as CSV