PREVIEW / etf_daily / 2005-01-12
file: by_date/etf_daily/2005/2005-01-12.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-12 | SPY | ETF | 118.4 | 118.84 | 117.52 | 118.57 | 72720500.0 |
| 2005-01-12 | QQQ | ETF | 38.44 | 38.6 | 38.01 | 38.58 | 127885823.0 |
| 2005-01-12 | IWM | ETF | 60.89 | 61.25 | 60.13 | 61.05 | 24791200.0 |
| 2005-01-12 | DIA | ETF | 105.58 | 106.23 | 104.96 | 106.03 | 10574200.0 |
| 2005-01-12 | GLD | ETF | 42.52 | 42.79 | 42.48 | 42.6 | 1738000.0 |
| 2005-01-12 | TLT | ETF | 88.87 | 89.44 | 88.8 | 89.32 | 722000.0 |
| 2005-01-12 | AAA | ETF | 59.0 | 59.12 | 58.82 | 58.87 | 4500.0 |
| 2005-01-12 | ADRE | ETF | 80.8 | 80.8 | 78.639 | 79.59 | 3980.0 |
| 2005-01-12 | AFK | ETF | 26.46 | 26.57 | 26.43 | 26.52 | 5300.0 |
| 2005-01-12 | AGG | ETF | 102.43 | 102.59 | 102.25 | 102.54 | 119100.0 |
| 2005-01-12 | AIQ | ETF | 67.0 | 69.2 | 66.8 | 67.75 | 171420.0 |
| 2005-01-12 | ARB | ETF | 37.0 | 37.42 | 36.67 | 37.3 | 232400.0 |
| 2005-01-12 | BAB | ETF | 47.18 | 47.35 | 47.03 | 47.3 | 30200.0 |
| 2005-01-12 | BBH | ETF | 49.4367 | 49.7 | 49.06 | 49.7 | 2445300.0 |
| 2005-01-12 | BCM | ETF | 59.03 | 59.3 | 58.88 | 59.27 | 30100.0 |
| 2005-01-12 | BIS | ETF | 960.0 | 968.0 | 960.0 | 968.0 | 15.6 |
| 2005-01-12 | BITS | ETF | 9.56 | 10.56 | 9.56 | 10.56 | 36236.0 |
| 2005-01-12 | BKF | ETF | 36.0 | 36.0 | 35.05 | 35.17 | 17300.0 |
| 2005-01-12 | BNE | ETF | 15.17 | 15.23 | 15.0 | 15.15 | 120600.0 |
| 2005-01-12 | BOSS | ETF | 24.0 | 24.64 | 24.0 | 24.64 | 200.0 |
| 2005-01-12 | BRF | ETF | 15.58 | 15.62 | 15.51 | 15.51 | 11700.0 |
| 2005-01-12 | BTF | ETF | 90.25 | 90.29999999999998 | 89.45 | 90.29999999999998 | 1500.0 |
| 2005-01-12 | CBON | ETF | 28.1 | 28.2 | 28.05 | 28.1 | 15345.0 |
| 2005-01-12 | CDC | ETF | 10.75 | 10.77 | 10.42 | 10.5 | 26700.0 |
| 2005-01-12 | CDL | ETF | 14.43 | 14.43 | 14.18 | 14.25 | 1223700.0 |
| 2005-01-12 | CEF | ETF | 5.34 | 5.39 | 5.34 | 5.38 | 223200.0 |
| 2005-01-12 | CEW | ETF | 27.42 | 27.42 | 27.42 | 27.42 | 300.0 |
| 2005-01-12 | CHB | ETF | 11.33 | 11.39 | 11.16 | 11.25 | 363400.0 |
| 2005-01-12 | CHIC | ETF | 10.16 | 10.16 | 9.96 | 10.14 | 585366.0 |
| 2005-01-12 | CHIR | ETF | 34.5999 | 35.2899 | 34.4199 | 35.2899 | 2313102.0 |
| 2005-01-12 | CID | ETF | 9.16 | 9.22 | 9.16 | 9.22 | 3100.0 |
| 2005-01-12 | CIL | ETF | 26.26 | 26.26 | 26.23 | 26.23 | 200.0 |
| 2005-01-12 | CIZ | ETF | 20.0 | 20.3 | 20.0 | 20.3 | 1200.0 |
| 2005-01-12 | CN | ETF | 28.05 | 28.25 | 27.85 | 28.05 | 289300.0 |
| 2005-01-12 | CNXT | ETF | 1.635 | 1.64 | 1.55 | 1.63 | 19343199.0 |
| 2005-01-12 | CSB | ETF | 36.03 | 36.08 | 35.8 | 36.07 | 5500.0 |
| 2005-01-12 | CSM | ETF | 2.375 | 2.375 | 2.375 | 2.375 | 3200.0 |
| 2005-01-12 | CTEC | ETF | 41.25 | 42.24999999999999 | 39.849999999999994 | 41.5 | 5329.8 |
| 2005-01-12 | CURE | ETF | 0.72 | 0.7538 | 0.7137 | 0.7238 | 1142120.0 |
| 2005-01-12 | CYA | ETF | 215.2 | 215.2 | 210.0 | 211.0 | 265.0 |
| 2005-01-12 | CYB | ETF | 4.55 | 4.59 | 4.4 | 4.45 | 8400.0 |
| 2005-01-12 | CZA | ETF | 10.4 | 10.4 | 10.4 | 10.4 | 1100.0 |
| 2005-01-12 | DGT | ETF | 63.21 | 63.4 | 63.06 | 63.4 | 1800.0 |
| 2005-01-12 | DIG | ETF | 12.1875 | 12.1875 | 12.125 | 12.125 | 880.0 |
| 2005-01-12 | DIV | ETF | 14.14 | 14.29 | 14.11 | 14.17 | 39000.0 |
| 2005-01-12 | DJP | ETF | 26.59 | 26.7 | 26.55 | 26.7 | 3700.0 |
| 2005-01-12 | DRIV | ETF | 32.5 | 34.11 | 32.3 | 33.91 | 1240310.0 |
| 2005-01-12 | DSI | ETF | 5.975 | 5.975 | 5.89 | 5.905 | 27600.0 |
| 2005-01-12 | DTH | ETF | 25.25 | 25.39 | 25.2 | 25.39 | 4400.0 |
| 2005-01-12 | DUSA | ETF | 14.01 | 14.14 | 13.89 | 14.05 | 142726.0 |
> showing 50 of 253 rows — these rows as CSV