PREVIEW / etf_daily / 2005-07-15
file: by_date/etf_daily/2005/2005-07-15.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-15 | SPY | ETF | 122.79 | 123.04 | 122.36 | 122.84 | 56075900.0 |
| 2005-07-15 | QQQ | ETF | 38.84 | 39.0 | 38.649 | 38.89 | 67732850.0 |
| 2005-07-15 | IWM | ETF | 65.95 | 66.2 | 65.42 | 66.0 | 15694300.0 |
| 2005-07-15 | DIA | ETF | 106.35 | 106.46 | 105.91 | 106.29 | 4914200.0 |
| 2005-07-15 | GLD | ETF | 41.76 | 42.07 | 41.7 | 42.05 | 1104800.0 |
| 2005-07-15 | TLT | ETF | 93.5 | 94.03 | 93.5 | 93.97 | 1064700.0 |
| 2005-07-15 | AAA | ETF | 50.73 | 50.73 | 50.55 | 50.55 | 6400.0 |
| 2005-07-15 | ADRE | ETF | 95.49 | 95.49 | 93.48 | 93.51 | 5128.0 |
| 2005-07-15 | AFK | ETF | 25.93 | 25.97 | 25.85 | 25.85 | 5200.0 |
| 2005-07-15 | AGG | ETF | 102.19 | 102.29 | 102.13 | 102.29 | 111600.0 |
| 2005-07-15 | AIQ | ETF | 55.75 | 56.15 | 55.5 | 55.75 | 15840.0 |
| 2005-07-15 | AIS | ETF | 1.16 | 1.17 | 1.088 | 1.14 | 87700.0 |
| 2005-07-15 | ARB | ETF | 42.56 | 43.43 | 42.54 | 43.42 | 96700.0 |
| 2005-07-15 | BAB | ETF | 48.99 | 48.99 | 48.7 | 48.89 | 22500.0 |
| 2005-07-15 | BBH | ETF | 61.6 | 62.3633 | 61.2267 | 61.98 | 2253600.0 |
| 2005-07-15 | BCM | ETF | 62.44 | 62.63 | 62.35 | 62.57 | 7600.0 |
| 2005-07-15 | BIS | ETF | 646.4 | 657.6 | 646.4 | 657.6 | 26.25 |
| 2005-07-15 | BITS | ETF | 13.44 | 13.92 | 13.44 | 13.84 | 2452.0 |
| 2005-07-15 | BKF | ETF | 35.7 | 35.7 | 35.1 | 35.25 | 15600.0 |
| 2005-07-15 | BNE | ETF | 14.25 | 14.38 | 14.19 | 14.26 | 137300.0 |
| 2005-07-15 | BRF | ETF | 15.39 | 15.49 | 15.39 | 15.49 | 9600.0 |
| 2005-07-15 | BTF | ETF | 86.99999999999999 | 87.39999999999999 | 86.75 | 87.10000000000001 | 3280.0 |
| 2005-07-15 | CBON | ETF | 31.49 | 32.34 | 31.49 | 32.1 | 18608.0 |
| 2005-07-15 | CDC | ETF | 6.95 | 6.95 | 6.86 | 6.86 | 1700.0 |
| 2005-07-15 | CDL | ETF | 11.45 | 11.49 | 11.34 | 11.34 | 149500.0 |
| 2005-07-15 | CEF | ETF | 5.2 | 5.23 | 5.15 | 5.17 | 229500.0 |
| 2005-07-15 | CEW | ETF | 26.78 | 26.78 | 26.55 | 26.55 | 2500.0 |
| 2005-07-15 | CHB | ETF | 10.37 | 10.59 | 10.3 | 10.51 | 185000.0 |
| 2005-07-15 | CHI | ETF | 19.85 | 19.9 | 19.72 | 19.84 | 73900.0 |
| 2005-07-15 | CHIC | ETF | 13.84 | 14.1 | 13.84 | 13.9 | 128817.0 |
| 2005-07-15 | CHIR | ETF | 36.0 | 36.5001 | 35.3601 | 36.03 | 2327328.0 |
| 2005-07-15 | CHY | ETF | 16.59 | 16.59 | 16.45 | 16.56 | 100400.0 |
| 2005-07-15 | CIZ | ETF | 22.7 | 22.7 | 22.7 | 22.7 | 100.0 |
| 2005-07-15 | CN | ETF | 30.36 | 30.39 | 30.15 | 30.39 | 12500.0 |
| 2005-07-15 | CNXT | ETF | 1.86 | 1.98 | 1.85 | 1.93 | 13489846.0 |
| 2005-07-15 | CPST | ETF | 1.9 | 1.9 | 1.82 | 1.88 | 1256217.0 |
| 2005-07-15 | CSB | ETF | 29.45 | 29.45 | 29.26 | 29.26 | 800.0 |
| 2005-07-15 | CSM | ETF | 2.4075 | 2.4075 | 2.4075 | 2.4075 | 24000.0 |
| 2005-07-15 | CSQ | ETF | 14.27 | 14.32 | 14.21 | 14.27 | 348400.0 |
| 2005-07-15 | CTEC | ETF | 54.3 | 54.3 | 51.8 | 52.24999999999999 | 10055.2 |
| 2005-07-15 | CURE | ETF | 0.3225 | 0.3325 | 0.3225 | 0.33 | 465624.0 |
| 2005-07-15 | CYA | ETF | 140.6 | 140.8 | 138.2 | 138.2 | 55.0 |
| 2005-07-15 | CYB | ETF | 2.95 | 3.0 | 2.9 | 2.98 | 12100.0 |
| 2005-07-15 | DGT | ETF | 64.45 | 64.72 | 64.4 | 64.63 | 7500.0 |
| 2005-07-15 | DIV | ETF | 13.94 | 13.95 | 13.84 | 13.91 | 15800.0 |
| 2005-07-15 | DRIV | ETF | 35.27 | 36.05 | 35.18 | 35.89 | 347219.0 |
| 2005-07-15 | DSI | ETF | 5.85 | 5.85 | 5.85 | 5.85 | 4000.0 |
| 2005-07-15 | DUSA | ETF | 9.96 | 10.1 | 9.03 | 9.05 | 279708.0 |
| 2005-07-15 | DVY | ETF | 63.54 | 63.55 | 63.25 | 63.41 | 347600.0 |
| 2005-07-15 | EDEN | ETF | 0.97 | 1.0 | 0.91 | 0.91 | 66831.0 |
> showing 50 of 274 rows — these rows as CSV