PREVIEW / etf_daily / 2005-07-26
file: by_date/etf_daily/2005/2005-07-26.parquet size: 15 KB rows: 276
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-07-26 | SPY | ETF | 123.23 | 123.53 | 122.95 | 123.34 | 42758800.0 |
| 2005-07-26 | QQQ | ETF | 39.39 | 39.53 | 39.19 | 39.42 | 69662887.0 |
| 2005-07-26 | IWM | ETF | 66.91 | 67.37 | 66.59 | 67.08 | 21896800.0 |
| 2005-07-26 | DIA | ETF | 106.02 | 106.2 | 105.64 | 105.82 | 5627100.0 |
| 2005-07-26 | GLD | ETF | 42.28 | 42.37 | 42.14 | 42.25 | 637000.0 |
| 2005-07-26 | TLT | ETF | 93.27 | 93.41 | 93.17 | 93.36 | 340500.0 |
| 2005-07-26 | AAA | ETF | 51.5 | 51.71 | 51.31 | 51.71 | 16600.0 |
| 2005-07-26 | ADRE | ETF | 97.9 | 97.9 | 94.07 | 94.254 | 7056.0 |
| 2005-07-26 | AFK | ETF | 25.76 | 25.89 | 25.76 | 25.8 | 4700.0 |
| 2005-07-26 | AGG | ETF | 101.88 | 102.06 | 101.88 | 102.06 | 113000.0 |
| 2005-07-26 | AIQ | ETF | 51.35 | 51.45 | 50.2 | 50.75 | 22320.0 |
| 2005-07-26 | AIS | ETF | 1.14 | 1.15 | 1.08 | 1.08 | 95200.0 |
| 2005-07-26 | ARB | ETF | 42.01 | 42.4 | 41.79 | 41.91 | 261300.0 |
| 2005-07-26 | BAB | ETF | 47.74 | 47.93 | 47.456 | 47.89 | 34100.0 |
| 2005-07-26 | BBH | ETF | 62.5067 | 63.86 | 62.5067 | 63.62 | 1855500.0 |
| 2005-07-26 | BCM | ETF | 63.67 | 64.45 | 63.37 | 64.38 | 13100.0 |
| 2005-07-26 | BITS | ETF | 13.6 | 13.6 | 13.244 | 13.244 | 2318.0 |
| 2005-07-26 | BKF | ETF | 34.4 | 34.7 | 34.4 | 34.48 | 4600.0 |
| 2005-07-26 | BNE | ETF | 14.23 | 14.27 | 14.03 | 14.11 | 74200.0 |
| 2005-07-26 | BRF | ETF | 15.37 | 15.4 | 15.37 | 15.4 | 3000.0 |
| 2005-07-26 | BTF | ETF | 87.14999999999999 | 87.6 | 87.14999999999999 | 87.6 | 2420.0 |
| 2005-07-26 | CBON | ETF | 32.79 | 33.9 | 32.75 | 33.3 | 51277.0 |
| 2005-07-26 | CDC | ETF | 6.62 | 6.62 | 6.62 | 6.62 | 400.0 |
| 2005-07-26 | CDL | ETF | 12.5 | 12.59 | 12.32 | 12.49 | 813300.0 |
| 2005-07-26 | CEF | ETF | 5.24 | 5.24 | 5.17 | 5.2 | 301300.0 |
| 2005-07-26 | CEW | ETF | 26.77 | 26.77 | 26.75 | 26.75 | 2300.0 |
| 2005-07-26 | CHB | ETF | 12.15 | 12.64 | 12.0 | 12.16 | 410800.0 |
| 2005-07-26 | CHI | ETF | 20.01 | 20.06 | 19.93 | 19.97 | 107100.0 |
| 2005-07-26 | CHIC | ETF | 14.94 | 14.97 | 14.35 | 14.7 | 209089.0 |
| 2005-07-26 | CHIR | ETF | 35.5899 | 36.5001 | 35.2701 | 36.4101 | 1704030.0 |
| 2005-07-26 | CHY | ETF | 16.6 | 16.6 | 16.39 | 16.42 | 145600.0 |
| 2005-07-26 | CIL | ETF | 25.75 | 25.75 | 25.75 | 25.75 | 300.0 |
| 2005-07-26 | CIZ | ETF | 22.55 | 22.55 | 22.55 | 22.55 | 200.0 |
| 2005-07-26 | CN | ETF | 30.8 | 30.8 | 30.35 | 30.35 | 8000.0 |
| 2005-07-26 | CNXT | ETF | 1.94 | 1.95 | 1.9 | 1.92 | 3786453.0 |
| 2005-07-26 | CPST | ETF | 1.88 | 1.88 | 1.798 | 1.83 | 715972.0 |
| 2005-07-26 | CSB | ETF | 29.75 | 29.75 | 29.32 | 29.34 | 5500.0 |
| 2005-07-26 | CSM | ETF | 2.42 | 2.4225 | 2.42 | 2.4225 | 40000.0 |
| 2005-07-26 | CSQ | ETF | 14.19 | 14.3 | 14.13 | 14.29 | 461400.0 |
| 2005-07-26 | CTEC | ETF | 53.550000000000004 | 54.800000000000004 | 53.49999999999999 | 53.550000000000004 | 8052.8 |
| 2005-07-26 | CURE | ETF | 0.3088 | 0.3088 | 0.2838 | 0.3013 | 1129328.0 |
| 2005-07-26 | CYA | ETF | 130.0 | 132.0 | 128.2 | 131.0 | 210.0 |
| 2005-07-26 | CYB | ETF | 2.89 | 2.89 | 2.87 | 2.87 | 9800.0 |
| 2005-07-26 | DGT | ETF | 64.1 | 64.21 | 63.97 | 63.97 | 700.0 |
| 2005-07-26 | DIG | ETF | 12.375 | 12.375 | 12.375 | 12.375 | 160.0 |
| 2005-07-26 | DIV | ETF | 13.75 | 13.78 | 13.71 | 13.74 | 13800.0 |
| 2005-07-26 | DRIV | ETF | 36.56 | 36.8 | 35.66 | 36.24 | 598459.0 |
| 2005-07-26 | DSI | ETF | 5.785 | 5.785 | 5.78 | 5.78 | 1000.0 |
| 2005-07-26 | DUSA | ETF | 9.16 | 9.19 | 8.96 | 9.12 | 151059.0 |
| 2005-07-26 | DVY | ETF | 63.95 | 64.0 | 63.69 | 63.88 | 429500.0 |
> showing 50 of 276 rows — these rows as CSV