PREVIEW / etf_daily / 2005-06-23
file: by_date/etf_daily/2005/2005-06-23.parquet size: 15 KB rows: 268
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-06-23 | SPY | ETF | 121.32 | 121.6 | 119.83 | 119.86 | 62185600.0 |
| 2005-06-23 | QQQ | ETF | 37.87 | 38.18 | 37.33 | 37.39 | 122223734.0 |
| 2005-06-23 | IWM | ETF | 63.91 | 64.11 | 62.88 | 62.88 | 19600900.0 |
| 2005-06-23 | DIA | ETF | 105.79 | 105.87 | 104.03 | 104.05 | 12891900.0 |
| 2005-06-23 | GLD | ETF | 43.84 | 44.13 | 43.78 | 44.02 | 1576600.0 |
| 2005-06-23 | TLT | ETF | 95.8 | 95.98 | 95.54 | 95.91 | 996300.0 |
| 2005-06-23 | AAA | ETF | 57.12 | 57.12 | 56.81 | 56.98 | 7400.0 |
| 2005-06-23 | ADRE | ETF | 93.75 | 93.75 | 88.0 | 90.74 | 7080.0 |
| 2005-06-23 | AFK | ETF | 26.32 | 26.32 | 26.16 | 26.16 | 10600.0 |
| 2005-06-23 | AGG | ETF | 103.14 | 103.23 | 103.01 | 103.16 | 113400.0 |
| 2005-06-23 | AIQ | ETF | 51.15 | 52.0 | 50.75 | 51.0 | 44960.0 |
| 2005-06-23 | AIS | ETF | 1.06 | 1.13 | 0.98 | 1.09 | 320700.0 |
| 2005-06-23 | ARB | ETF | 43.07 | 43.45 | 42.83 | 42.88 | 139100.0 |
| 2005-06-23 | BAB | ETF | 50.93 | 50.95 | 50.18 | 50.18 | 11700.0 |
| 2005-06-23 | BBH | ETF | 55.9733 | 56.46 | 55.28 | 55.4 | 1870800.0 |
| 2005-06-23 | BCM | ETF | 62.3 | 62.93 | 62.3 | 62.9 | 16200.0 |
| 2005-06-23 | BIS | ETF | 592.0 | 632.0 | 582.4 | 632.0 | 102.5 |
| 2005-06-23 | BITS | ETF | 12.84 | 12.84 | 12.36 | 12.52 | 2912.0 |
| 2005-06-23 | BKF | ETF | 37.9 | 39.25 | 37.9 | 38.25 | 138600.0 |
| 2005-06-23 | BNE | ETF | 14.27 | 14.29 | 14.15 | 14.2 | 178300.0 |
| 2005-06-23 | BRF | ETF | 15.59 | 15.59 | 15.48 | 15.51 | 6600.0 |
| 2005-06-23 | BTF | ETF | 86.5 | 86.5 | 85.1 | 85.7 | 4220.0 |
| 2005-06-23 | CBON | ETF | 30.49 | 30.57 | 29.3 | 29.3 | 17106.0 |
| 2005-06-23 | CDC | ETF | 7.04 | 7.19 | 6.92 | 7.19 | 900.0 |
| 2005-06-23 | CDL | ETF | 12.03 | 12.1 | 11.98 | 12.02 | 398200.0 |
| 2005-06-23 | CEF | ETF | 5.4 | 5.41 | 5.36 | 5.37 | 217900.0 |
| 2005-06-23 | CEW | ETF | 26.51 | 26.52 | 26.51 | 26.51 | 6000.0 |
| 2005-06-23 | CHB | ETF | 9.92 | 10.02 | 9.75 | 9.75 | 292800.0 |
| 2005-06-23 | CHI | ETF | 19.42 | 19.44 | 19.24 | 19.32 | 149600.0 |
| 2005-06-23 | CHIC | ETF | 12.65 | 12.75 | 12.45 | 12.49 | 136946.0 |
| 2005-06-23 | CHIR | ETF | 35.5299 | 35.5599 | 34.74 | 34.9299 | 1177071.0 |
| 2005-06-23 | CHY | ETF | 16.25 | 16.45 | 16.19 | 16.36 | 188000.0 |
| 2005-06-23 | CIL | ETF | 25.6 | 25.63 | 25.6 | 25.63 | 600.0 |
| 2005-06-23 | CN | ETF | 28.79 | 28.85 | 28.67 | 28.73 | 30200.0 |
| 2005-06-23 | CNXT | ETF | 1.69 | 1.75 | 1.66 | 1.68 | 8979801.0 |
| 2005-06-23 | CPST | ETF | 1.39 | 1.4 | 1.29 | 1.29 | 759192.0 |
| 2005-06-23 | CSB | ETF | 30.39 | 30.55 | 30.39 | 30.45 | 2700.0 |
| 2005-06-23 | CSM | ETF | 2.4025 | 2.4025 | 2.4025 | 2.4025 | 8000.0 |
| 2005-06-23 | CSQ | ETF | 13.76 | 13.79 | 13.69 | 13.74 | 418700.0 |
| 2005-06-23 | CTEC | ETF | 52.5 | 53.5995 | 51.8 | 52.99999999999999 | 14100.0 |
| 2005-06-23 | CURE | ETF | 0.2549 | 0.2549 | 0.2462 | 0.25 | 331136.0 |
| 2005-06-23 | CYA | ETF | 142.0 | 142.0 | 142.0 | 142.0 | 5.0 |
| 2005-06-23 | CYB | ETF | 3.16 | 3.39 | 3.15 | 3.36 | 22300.0 |
| 2005-06-23 | DGT | ETF | 64.1 | 64.42 | 63.76 | 63.95 | 1700.0 |
| 2005-06-23 | DIG | ETF | 12.4375 | 12.4375 | 12.425 | 12.425 | 2000.0 |
| 2005-06-23 | DIV | ETF | 13.83 | 13.83 | 13.73 | 13.78 | 11000.0 |
| 2005-06-23 | DRIV | ETF | 31.2 | 31.78 | 30.95 | 31.1 | 691414.0 |
| 2005-06-23 | DSI | ETF | 5.85 | 5.85 | 5.83 | 5.83 | 12400.0 |
| 2005-06-23 | DUSA | ETF | 8.93 | 9.0 | 8.87 | 8.92 | 173363.0 |
| 2005-06-23 | DVY | ETF | 62.54 | 62.54 | 61.82 | 61.83 | 536000.0 |
> showing 50 of 268 rows — these rows as CSV