PREVIEW / etf_daily / 2005-07-13
file: by_date/etf_daily/2005/2005-07-13.parquet size: 15 KB rows: 274
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-13 | SPY | ETF | 122.27 | 122.52 | 121.99 | 122.43 | 41182300.0 |
| 2005-07-13 | QQQ | ETF | 38.32 | 38.43 | 38.17 | 38.39 | 72552503.0 |
| 2005-07-13 | IWM | ETF | 66.65 | 66.82 | 66.15 | 66.42 | 16978500.0 |
| 2005-07-13 | DIA | ETF | 105.31 | 105.66 | 105.15 | 105.63 | 6548000.0 |
| 2005-07-13 | GLD | ETF | 42.35 | 42.38 | 42.25 | 42.35 | 981300.0 |
| 2005-07-13 | TLT | ETF | 94.05 | 94.1 | 93.86 | 93.96 | 886600.0 |
| 2005-07-13 | AAA | ETF | 50.77 | 50.86 | 50.59 | 50.78 | 3400.0 |
| 2005-07-13 | ADRE | ETF | 94.07 | 94.33 | 94.06 | 94.21 | 3976.0 |
| 2005-07-13 | AFK | ETF | 25.8 | 25.93 | 25.77 | 25.87 | 6500.0 |
| 2005-07-13 | AGG | ETF | 102.3 | 102.3 | 102.07 | 102.24 | 251100.0 |
| 2005-07-13 | AIQ | ETF | 57.5 | 57.5 | 55.9 | 55.9 | 21060.0 |
| 2005-07-13 | AIS | ETF | 1.22 | 1.22 | 1.17 | 1.2 | 46200.0 |
| 2005-07-13 | ARB | ETF | 43.15 | 43.23 | 42.45 | 42.59 | 104000.0 |
| 2005-07-13 | BAB | ETF | 47.96 | 48.1 | 47.52 | 48.05 | 16700.0 |
| 2005-07-13 | BBH | ETF | 60.0 | 60.37 | 59.7833 | 60.0167 | 1125300.0 |
| 2005-07-13 | BCM | ETF | 63.37 | 63.37 | 63.01 | 63.03 | 6000.0 |
| 2005-07-13 | BIS | ETF | 640.0 | 641.6 | 640.0 | 640.0 | 70.0 |
| 2005-07-13 | BITS | ETF | 13.16 | 13.68 | 13.0 | 13.04 | 9024.0 |
| 2005-07-13 | BKF | ETF | 37.1 | 37.1 | 36.4 | 36.5 | 21800.0 |
| 2005-07-13 | BNE | ETF | 14.06 | 14.3 | 13.96 | 14.26 | 177500.0 |
| 2005-07-13 | BRF | ETF | 15.5 | 15.57 | 15.5 | 15.55 | 2800.0 |
| 2005-07-13 | BTF | ETF | 87.24999999999999 | 87.35 | 86.8 | 87.35 | 1440.0 |
| 2005-07-13 | CBON | ETF | 31.12 | 31.25 | 30.82 | 31.0 | 19327.0 |
| 2005-07-13 | CDC | ETF | 6.75 | 6.75 | 6.5 | 6.61 | 3500.0 |
| 2005-07-13 | CDL | ETF | 11.69 | 11.72 | 11.55 | 11.55 | 191800.0 |
| 2005-07-13 | CEF | ETF | 5.27 | 5.29 | 5.22 | 5.23 | 165200.0 |
| 2005-07-13 | CEW | ETF | 26.56 | 26.77 | 26.56 | 26.76 | 3000.0 |
| 2005-07-13 | CHB | ETF | 10.56 | 10.63 | 10.48 | 10.51 | 130800.0 |
| 2005-07-13 | CHI | ETF | 19.94 | 19.94 | 19.7 | 19.75 | 108000.0 |
| 2005-07-13 | CHIC | ETF | 14.15 | 14.25 | 13.84 | 13.865 | 372352.0 |
| 2005-07-13 | CHIR | ETF | 36.9099 | 36.9099 | 36.3699 | 36.81 | 749382.0 |
| 2005-07-13 | CHY | ETF | 16.75 | 16.75 | 16.48 | 16.54 | 130400.0 |
| 2005-07-13 | CIL | ETF | 25.66 | 25.66 | 25.65 | 25.65 | 1000.0 |
| 2005-07-13 | CIZ | ETF | 21.5 | 22.4 | 21.5 | 22.4 | 6400.0 |
| 2005-07-13 | CN | ETF | 29.96 | 30.12 | 29.78 | 30.1 | 25100.0 |
| 2005-07-13 | CNXT | ETF | 1.8 | 1.82 | 1.78 | 1.81 | 2717049.0 |
| 2005-07-13 | CPST | ETF | 1.63 | 1.76 | 1.6 | 1.76 | 1703259.0 |
| 2005-07-13 | CSB | ETF | 29.68 | 29.68 | 29.5 | 29.53 | 6100.0 |
| 2005-07-13 | CSQ | ETF | 14.2 | 14.32 | 14.17 | 14.23 | 442700.0 |
| 2005-07-13 | CTEC | ETF | 55.449999999999996 | 55.849999999999994 | 55.05 | 55.25 | 4520.0 |
| 2005-07-13 | CURE | ETF | 0.33 | 0.335 | 0.3125 | 0.3337 | 798168.0 |
| 2005-07-13 | CYA | ETF | 134.0 | 135.0 | 134.0 | 135.0 | 70.0 |
| 2005-07-13 | CYB | ETF | 3.02 | 3.05 | 2.874 | 3.05 | 24000.0 |
| 2005-07-13 | DGT | ETF | 64.29 | 64.5 | 64.17 | 64.46 | 2600.0 |
| 2005-07-13 | DIG | ETF | 12.6375 | 12.6375 | 12.625 | 12.625 | 1280.0 |
| 2005-07-13 | DIV | ETF | 13.75 | 13.89 | 13.75 | 13.85 | 12000.0 |
| 2005-07-13 | DRIV | ETF | 36.25 | 36.28 | 35.14 | 35.25 | 620554.0 |
| 2005-07-13 | DSI | ETF | 5.83 | 5.83 | 5.81 | 5.81 | 12400.0 |
| 2005-07-13 | DUSA | ETF | 9.68 | 9.93 | 9.62 | 9.73 | 52734.0 |
| 2005-07-13 | DVY | ETF | 63.45 | 63.57 | 63.32 | 63.44 | 635400.0 |
> showing 50 of 274 rows — these rows as CSV