PREVIEW / etf_daily / 2005-01-26
file: by_date/etf_daily/2005/2005-01-26.parquet size: 14 KB rows: 253
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-26 | SPY | ETF | 117.32 | 117.6 | 117.04 | 117.23 | 57195100.0 |
| 2005-01-26 | QQQ | ETF | 36.96 | 37.29 | 36.824 | 37.15 | 107711314.0 |
| 2005-01-26 | IWM | ETF | 60.71 | 61.45 | 60.56 | 61.275 | 18351600.0 |
| 2005-01-26 | DIA | ETF | 104.92 | 105.25 | 104.68 | 104.79 | 7851200.0 |
| 2005-01-26 | GLD | ETF | 42.59 | 42.78 | 42.56 | 42.69 | 541800.0 |
| 2005-01-26 | TLT | ETF | 90.85 | 90.92 | 90.63 | 90.71 | 709800.0 |
| 2005-01-26 | AAA | ETF | 58.43 | 59.83 | 58.43 | 59.0 | 3200.0 |
| 2005-01-26 | ADRE | ETF | 80.73 | 81.16 | 80.5 | 81.07 | 4240.0 |
| 2005-01-26 | AFK | ETF | 26.42 | 26.5 | 26.42 | 26.43 | 8000.0 |
| 2005-01-26 | AGG | ETF | 102.94 | 102.94 | 102.75 | 102.82 | 95100.0 |
| 2005-01-26 | AIQ | ETF | 65.0 | 66.25 | 63.96 | 65.95 | 23300.0 |
| 2005-01-26 | ARB | ETF | 40.15 | 41.97 | 40.15 | 41.21 | 541900.0 |
| 2005-01-26 | BAB | ETF | 48.17 | 48.74 | 47.98 | 48.58 | 65000.0 |
| 2005-01-26 | BBH | ETF | 48.0 | 48.4133 | 47.8733 | 48.1333 | 2990700.0 |
| 2005-01-26 | BCM | ETF | 55.46 | 55.93 | 55.46 | 55.84 | 22900.0 |
| 2005-01-26 | BIS | ETF | 929.6 | 929.6 | 929.6 | 929.6 | 3.125 |
| 2005-01-26 | BITS | ETF | 9.6 | 9.76 | 9.4 | 9.4 | 9132.0 |
| 2005-01-26 | BKF | ETF | 36.76 | 36.99 | 36.75 | 36.99 | 20600.0 |
| 2005-01-26 | BNE | ETF | 14.35 | 14.45 | 14.26 | 14.34 | 129500.0 |
| 2005-01-26 | BRF | ETF | 15.65 | 15.69 | 15.65 | 15.69 | 5400.0 |
| 2005-01-26 | BTF | ETF | 90.5 | 90.6 | 90.0 | 90.5 | 1100.0 |
| 2005-01-26 | CBON | ETF | 27.65 | 27.75 | 27.46 | 27.46 | 14370.0 |
| 2005-01-26 | CDC | ETF | 9.2 | 9.34 | 9.2 | 9.3 | 5400.0 |
| 2005-01-26 | CDL | ETF | 14.08 | 14.13 | 13.86 | 14.05 | 247600.0 |
| 2005-01-26 | CEF | ETF | 5.27 | 5.32 | 5.26 | 5.31 | 146200.0 |
| 2005-01-26 | CHB | ETF | 10.5 | 10.8 | 10.5 | 10.77 | 160400.0 |
| 2005-01-26 | CHIC | ETF | 9.5 | 10.1 | 9.5 | 10.035 | 692498.0 |
| 2005-01-26 | CHIR | ETF | 33.87 | 34.14 | 33.7299 | 33.9399 | 1304766.0 |
| 2005-01-26 | CID | ETF | 9.04 | 9.04 | 9.04 | 9.04 | 2000.0 |
| 2005-01-26 | CIL | ETF | 26.4 | 26.4 | 26.2 | 26.2 | 900.0 |
| 2005-01-26 | CIZ | ETF | 20.4 | 20.4 | 20.4 | 20.4 | 600.0 |
| 2005-01-26 | CN | ETF | 28.0 | 28.0 | 27.76 | 27.81 | 43700.0 |
| 2005-01-26 | CNXT | ETF | 1.54 | 1.68 | 1.48 | 1.6 | 8234802.0 |
| 2005-01-26 | CPI | ETF | 20.1 | 20.1 | 19.25 | 19.25 | 1600.0 |
| 2005-01-26 | CSB | ETF | 35.32 | 35.8 | 35.32 | 35.8 | 600.0 |
| 2005-01-26 | CSM | ETF | 2.3825 | 2.3825 | 2.3825 | 2.3825 | 1200.0 |
| 2005-01-26 | CTEC | ETF | 57.24999999999999 | 58.15 | 55.35 | 57.0 | 33652.6 |
| 2005-01-26 | CURE | ETF | 0.6262 | 0.645 | 0.5975 | 0.6112 | 1851008.0 |
| 2005-01-26 | CYA | ETF | 185.0 | 188.4 | 182.0 | 188.4 | 375.0 |
| 2005-01-26 | CYB | ETF | 3.92 | 4.09 | 3.92 | 4.09 | 9400.0 |
| 2005-01-26 | CZA | ETF | 10.35 | 10.43 | 10.35 | 10.43 | 1000.0 |
| 2005-01-26 | DGT | ETF | 63.15 | 63.15 | 63.02 | 63.11 | 1700.0 |
| 2005-01-26 | DIV | ETF | 14.14 | 14.19 | 14.11 | 14.19 | 13900.0 |
| 2005-01-26 | DJP | ETF | 26.7 | 26.8 | 26.7 | 26.8 | 700.0 |
| 2005-01-26 | DRIV | ETF | 34.5 | 36.55 | 33.82 | 36.26 | 2514146.0 |
| 2005-01-26 | DSI | ETF | 5.925 | 5.97 | 5.905 | 5.905 | 12200.0 |
| 2005-01-26 | DTH | ETF | 25.32 | 25.37 | 25.31 | 25.37 | 1100.0 |
| 2005-01-26 | DUSA | ETF | 13.69 | 13.9 | 13.5 | 13.645 | 83847.0 |
| 2005-01-26 | DVY | ETF | 59.09 | 59.32 | 58.95 | 59.26 | 495800.0 |
| 2005-01-26 | EDEN | ETF | 1.26 | 1.26 | 1.12 | 1.15 | 55181.0 |
> showing 50 of 253 rows — these rows as CSV