PREVIEW / etf_daily / 2005-01-07
file: by_date/etf_daily/2005/2005-01-07.parquet size: 14 KB rows: 248
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-01-07 | SPY | ETF | 118.97 | 119.23 | 118.13 | 118.44 | 55847700.0 |
| 2005-01-07 | QQQ | ETF | 38.56 | 38.873 | 38.21 | 38.55 | 123159230.0 |
| 2005-01-07 | IWM | ETF | 61.755 | 61.95 | 60.895 | 60.93 | 20906200.0 |
| 2005-01-07 | DIA | ETF | 106.33 | 106.5 | 105.63 | 105.84 | 8555700.0 |
| 2005-01-07 | GLD | ETF | 42.09 | 42.39 | 41.7 | 41.84 | 4492700.0 |
| 2005-01-07 | TLT | ETF | 88.76 | 88.87 | 88.35 | 88.54 | 738700.0 |
| 2005-01-07 | AAA | ETF | 59.56 | 59.56 | 58.39 | 58.53 | 8800.0 |
| 2005-01-07 | ADRE | ETF | 80.4 | 80.4 | 78.738 | 79.11 | 29772.0 |
| 2005-01-07 | AFK | ETF | 26.44 | 26.5 | 26.43 | 26.442 | 3400.0 |
| 2005-01-07 | AGG | ETF | 102.39 | 102.44 | 102.11 | 102.3 | 137000.0 |
| 2005-01-07 | AIQ | ETF | 58.6 | 58.6 | 57.0 | 58.25 | 88620.0 |
| 2005-01-07 | ARB | ETF | 37.6 | 37.64 | 37.09 | 37.1 | 106400.0 |
| 2005-01-07 | BAB | ETF | 46.83 | 47.09 | 46.29 | 46.35 | 75700.0 |
| 2005-01-07 | BBH | ETF | 50.3333 | 50.65 | 49.6733 | 50.25 | 2506800.0 |
| 2005-01-07 | BCM | ETF | 58.4 | 58.4 | 57.44 | 57.54 | 69400.0 |
| 2005-01-07 | BITS | ETF | 10.2 | 10.2 | 9.2 | 9.26 | 27746.0 |
| 2005-01-07 | BKF | ETF | 36.39 | 36.4 | 36.1 | 36.15 | 319900.0 |
| 2005-01-07 | BNE | ETF | 15.29 | 15.3 | 14.9 | 15.0 | 195200.0 |
| 2005-01-07 | BRF | ETF | 15.89 | 15.89 | 15.66 | 15.67 | 15200.0 |
| 2005-01-07 | BTF | ETF | 90.25 | 90.5 | 90.19999999999999 | 90.44999999999999 | 960.0 |
| 2005-01-07 | CBON | ETF | 29.049 | 29.05 | 28.12 | 28.351 | 37360.0 |
| 2005-01-07 | CDC | ETF | 11.59 | 11.59 | 11.49 | 11.49 | 600.0 |
| 2005-01-07 | CDL | ETF | 15.0 | 15.0 | 14.83 | 14.92 | 116800.0 |
| 2005-01-07 | CEF | ETF | 5.29 | 5.29 | 5.1 | 5.16 | 861700.0 |
| 2005-01-07 | CHB | ETF | 11.44 | 11.64 | 11.39 | 11.46 | 681800.0 |
| 2005-01-07 | CHIC | ETF | 10.17 | 10.17 | 9.96 | 10.05 | 257440.0 |
| 2005-01-07 | CHIR | ETF | 36.3 | 36.39 | 35.1 | 35.6199 | 2223149.0 |
| 2005-01-07 | CID | ETF | 9.5 | 9.5 | 9.5 | 9.5 | 1600.0 |
| 2005-01-07 | CIZ | ETF | 20.75 | 20.75 | 20.75 | 20.75 | 500.0 |
| 2005-01-07 | CN | ETF | 27.39 | 27.65 | 27.36 | 27.5 | 229900.0 |
| 2005-01-07 | CNXT | ETF | 1.8 | 1.82 | 1.69 | 1.73 | 9658536.0 |
| 2005-01-07 | CPI | ETF | 18.2 | 18.2 | 18.2 | 18.2 | 200.0 |
| 2005-01-07 | CSB | ETF | 36.44 | 36.64 | 36.37 | 36.52 | 2800.0 |
| 2005-01-07 | CTEC | ETF | 40.8 | 42.4 | 39.35 | 40.949999999999996 | 8474.0 |
| 2005-01-07 | CURE | ETF | 0.755 | 0.7812 | 0.7425 | 0.7425 | 960008.0 |
| 2005-01-07 | CYA | ETF | 231.8 | 232.8 | 230.0 | 230.0 | 180.0 |
| 2005-01-07 | CYB | ETF | 4.35 | 4.39 | 4.31 | 4.34 | 4200.0 |
| 2005-01-07 | CZA | ETF | 10.4 | 10.46 | 10.4 | 10.46 | 1700.0 |
| 2005-01-07 | DGT | ETF | 63.52 | 63.54 | 63.06 | 63.38 | 1600.0 |
| 2005-01-07 | DIG | ETF | 12.3 | 12.3 | 12.3 | 12.3 | 1200.0 |
| 2005-01-07 | DIV | ETF | 14.08 | 14.3 | 14.08 | 14.3 | 22400.0 |
| 2005-01-07 | DJP | ETF | 26.62 | 26.62 | 26.62 | 26.62 | 500.0 |
| 2005-01-07 | DRIV | ETF | 34.62 | 34.98 | 31.87 | 32.6 | 1998438.0 |
| 2005-01-07 | DSI | ETF | 5.905 | 5.92 | 5.905 | 5.91 | 8600.0 |
| 2005-01-07 | DTH | ETF | 25.3 | 25.3 | 25.25 | 25.25 | 1200.0 |
| 2005-01-07 | DUSA | ETF | 14.7 | 14.7 | 14.15 | 14.27 | 62411.0 |
| 2005-01-07 | DVY | ETF | 60.09 | 60.15 | 59.48 | 59.67 | 3058700.0 |
| 2005-01-07 | EDEN | ETF | 1.25 | 1.26 | 1.11 | 1.19 | 175273.0 |
| 2005-01-07 | EDV | ETF | 26.26 | 26.35 | 26.26 | 26.34 | 8600.0 |
| 2005-01-07 | EEM | ETF | 21.3778 | 21.4178 | 21.1667 | 21.2744 | 4920300.0 |
> showing 50 of 248 rows — these rows as CSV