PREVIEW / etf_daily / 2005-06-16
file: by_date/etf_daily/2005/2005-06-16.parquet size: 15 KB rows: 267
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-16 | SPY | ETF | 121.06 | 121.64 | 120.92 | 121.4 | 46564500.0 |
| 2005-06-16 | QQQ | ETF | 37.74 | 38.0 | 37.66 | 37.9 | 90509327.0 |
| 2005-06-16 | IWM | ETF | 63.48 | 64.14 | 63.33 | 64.06 | 21612000.0 |
| 2005-06-16 | DIA | ETF | 105.7 | 106.02 | 105.46 | 105.78 | 6817800.0 |
| 2005-06-16 | GLD | ETF | 43.3 | 43.55 | 43.17 | 43.46 | 1809200.0 |
| 2005-06-16 | TLT | ETF | 93.8 | 94.42 | 93.57 | 94.34 | 1370300.0 |
| 2005-06-16 | AAA | ETF | 57.46 | 57.72 | 57.16 | 57.25 | 15100.0 |
| 2005-06-16 | ADRE | ETF | 90.99 | 92.04 | 90.99 | 92.04 | 3688.0 |
| 2005-06-16 | AFK | ETF | 26.0 | 26.08 | 25.95 | 26.05 | 14200.0 |
| 2005-06-16 | AGG | ETF | 102.5 | 102.66 | 102.35 | 102.63 | 89500.0 |
| 2005-06-16 | AIQ | ETF | 51.0 | 51.9 | 50.4 | 51.5 | 33820.0 |
| 2005-06-16 | AIS | ETF | 0.95 | 1.05 | 0.91 | 1.02 | 272500.0 |
| 2005-06-16 | ARB | ETF | 43.6 | 44.65 | 43.6 | 44.26 | 377100.0 |
| 2005-06-16 | BAB | ETF | 50.36 | 50.65 | 50.18 | 50.6 | 15800.0 |
| 2005-06-16 | BBH | ETF | 55.6167 | 56.5367 | 55.6167 | 56.3333 | 1061400.0 |
| 2005-06-16 | BCM | ETF | 60.55 | 60.88 | 60.3 | 60.82 | 9000.0 |
| 2005-06-16 | BIS | ETF | 601.6 | 624.0 | 601.6 | 622.4 | 91.0 |
| 2005-06-16 | BITS | ETF | 13.36 | 13.4 | 12.48 | 12.52 | 6951.0 |
| 2005-06-16 | BKF | ETF | 38.27 | 38.45 | 37.95 | 38.45 | 49100.0 |
| 2005-06-16 | BNE | ETF | 13.95 | 14.02 | 13.94 | 13.99 | 129900.0 |
| 2005-06-16 | BRF | ETF | 15.39 | 15.52 | 15.39 | 15.48 | 8700.0 |
| 2005-06-16 | BTF | ETF | 86.05 | 86.35 | 85.64999999999999 | 86.1 | 4020.0 |
| 2005-06-16 | CBON | ETF | 29.15 | 30.0 | 29.15 | 29.84 | 25311.0 |
| 2005-06-16 | CDC | ETF | 7.1 | 7.2 | 7.04 | 7.08 | 1800.0 |
| 2005-06-16 | CDL | ETF | 12.0 | 12.05 | 11.95 | 12.04 | 222700.0 |
| 2005-06-16 | CEF | ETF | 5.39 | 5.42 | 5.35 | 5.36 | 402200.0 |
| 2005-06-16 | CEW | ETF | 26.5 | 26.56 | 26.5 | 26.55 | 800.0 |
| 2005-06-16 | CGW | ETF | 27.95 | 28.36 | 27.95 | 28.05 | 10900.0 |
| 2005-06-16 | CHB | ETF | 10.3 | 10.55 | 10.21 | 10.55 | 454200.0 |
| 2005-06-16 | CHI | ETF | 19.33 | 19.45 | 19.31 | 19.44 | 85000.0 |
| 2005-06-16 | CHIC | ETF | 12.42 | 12.45 | 12.1 | 12.35 | 215536.0 |
| 2005-06-16 | CHIR | ETF | 35.2899 | 35.7699 | 34.8699 | 35.6901 | 1749734.0 |
| 2005-06-16 | CHY | ETF | 15.95 | 16.06 | 15.9436 | 16.06 | 101500.0 |
| 2005-06-16 | CIL | ETF | 25.56 | 25.56 | 25.56 | 25.56 | 100.0 |
| 2005-06-16 | CN | ETF | 26.79 | 26.79 | 26.56 | 26.61 | 54200.0 |
| 2005-06-16 | CNXT | ETF | 1.45 | 1.53 | 1.45 | 1.5 | 2811283.0 |
| 2005-06-16 | CPI | ETF | 23.86 | 24.6 | 23.86 | 24.0 | 4700.0 |
| 2005-06-16 | CPST | ETF | 1.11 | 1.12 | 1.08 | 1.12 | 636868.0 |
| 2005-06-16 | CSB | ETF | 30.24 | 30.49 | 30.05 | 30.33 | 6200.0 |
| 2005-06-16 | CSQ | ETF | 13.84 | 13.92 | 13.75 | 13.83 | 335100.0 |
| 2005-06-16 | CTEC | ETF | 49.1 | 49.74999999999999 | 48.949999999999996 | 49.349999999999994 | 2330.4 |
| 2005-06-16 | CURE | ETF | 0.265 | 0.2675 | 0.2525 | 0.2575 | 1027048.0 |
| 2005-06-16 | CYA | ETF | 156.0 | 156.0 | 152.0 | 154.8 | 300.0 |
| 2005-06-16 | CYB | ETF | 2.94 | 3.0 | 2.94 | 3.0 | 27000.0 |
| 2005-06-16 | DGT | ETF | 64.4 | 64.47 | 64.28 | 64.47 | 9800.0 |
| 2005-06-16 | DIG | ETF | 12.1875 | 12.325 | 12.1875 | 12.325 | 2560.0 |
| 2005-06-16 | DIV | ETF | 13.79 | 13.98 | 13.71 | 13.84 | 30600.0 |
| 2005-06-16 | DRIV | ETF | 28.99 | 29.2 | 28.46 | 29.2 | 478954.0 |
| 2005-06-16 | DSI | ETF | 5.98 | 5.98 | 5.965 | 5.965 | 1800.0 |
| 2005-06-16 | DUSA | ETF | 10.11 | 10.2 | 10.0 | 10.16 | 106047.0 |
> showing 50 of 267 rows — these rows as CSV