PREVIEW / etf_daily / 2006-05-02
file: by_date/etf_daily/2006/2006-05-02.parquet size: 16 KB rows: 317
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-02 | SPY | ETF | 131.01 | 131.46 | 130.74 | 131.38 | 49063500.0 |
| 2006-05-02 | QQQ | ETF | 41.61 | 41.73 | 41.4 | 41.55 | 85173540.0 |
| 2006-05-02 | IWM | ETF | 75.71 | 76.32 | 75.41 | 76.29 | 36131800.0 |
| 2006-05-02 | DIA | ETF | 113.72 | 114.2 | 113.53 | 114.15 | 6042300.0 |
| 2006-05-02 | GLD | ETF | 65.6 | 66.57 | 65.56 | 66.55 | 6194800.0 |
| 2006-05-02 | TLT | ETF | 83.26 | 83.54 | 83.26 | 83.42 | 1097900.0 |
| 2006-05-02 | AAA | ETF | 63.02 | 63.44 | 62.95 | 63.12 | 86200.0 |
| 2006-05-02 | ADRE | ETF | 141.3 | 142.98 | 140.5 | 142.98 | 31784.0 |
| 2006-05-02 | AFK | ETF | 25.13 | 25.18 | 25.12 | 25.18 | 7200.0 |
| 2006-05-02 | AGG | ETF | 97.83 | 97.96 | 97.7 | 97.89 | 123000.0 |
| 2006-05-02 | AIQ | ETF | 29.5 | 29.85 | 28.25 | 28.6 | 30160.0 |
| 2006-05-02 | AIS | ETF | 1.6 | 1.67 | 1.56 | 1.62 | 226600.0 |
| 2006-05-02 | AOM | ETF | 7.0 | 7.0 | 6.84 | 6.93 | 6300.0 |
| 2006-05-02 | ARB | ETF | 35.39 | 35.59 | 35.2 | 35.5 | 201400.0 |
| 2006-05-02 | BAB | ETF | 61.3 | 62.13 | 61.2 | 61.5 | 17100.0 |
| 2006-05-02 | BBC | ETF | 10.15 | 11.95 | 10.0 | 11.57 | 1328900.0 |
| 2006-05-02 | BBH | ETF | 57.6667 | 57.82 | 56.0467 | 56.5833 | 2310000.0 |
| 2006-05-02 | BCM | ETF | 74.35 | 74.66 | 74.18 | 74.66 | 17400.0 |
| 2006-05-02 | BITS | ETF | 34.64 | 35.56 | 34.0 | 34.4 | 34576.0 |
| 2006-05-02 | BKF | ETF | 9.0 | 9.09 | 8.95 | 9.05 | 75100.0 |
| 2006-05-02 | BNE | ETF | 15.7 | 15.9 | 15.45 | 15.81 | 67600.0 |
| 2006-05-02 | BOSS | ETF | 37.5 | 37.5 | 37.5 | 37.5 | 100.0 |
| 2006-05-02 | BRF | ETF | 13.87 | 13.97 | 13.8 | 13.97 | 15000.0 |
| 2006-05-02 | BTF | ETF | 87.6505 | 88.1 | 87.55 | 88.1 | 2020.0 |
| 2006-05-02 | CBON | ETF | 31.77 | 32.0 | 31.29 | 31.83 | 13172.0 |
| 2006-05-02 | CDL | ETF | 9.68 | 9.7 | 9.55 | 9.65 | 497300.0 |
| 2006-05-02 | CEF | ETF | 9.51 | 9.51 | 9.22 | 9.48 | 1098500.0 |
| 2006-05-02 | CEW | ETF | 25.65 | 25.65 | 25.65 | 25.65 | 300.0 |
| 2006-05-02 | CFO | ETF | 10.37 | 10.37 | 10.35 | 10.36 | 43600.0 |
| 2006-05-02 | CGO | ETF | 14.35 | 14.49 | 14.31 | 14.4 | 83600.0 |
| 2006-05-02 | CHB | ETF | 16.0 | 16.5 | 16.0 | 16.32 | 1452200.0 |
| 2006-05-02 | CHI | ETF | 20.09 | 20.15 | 20.01 | 20.04 | 67500.0 |
| 2006-05-02 | CHIC | ETF | 21.8 | 22.57 | 21.79 | 22.45 | 766402.0 |
| 2006-05-02 | CHY | ETF | 16.0 | 16.04 | 15.93 | 15.99 | 84100.0 |
| 2006-05-02 | CIL | ETF | 25.72 | 25.72 | 25.72 | 25.72 | 400.0 |
| 2006-05-02 | CN | ETF | 37.2 | 37.54 | 37.2 | 37.2 | 31100.0 |
| 2006-05-02 | CNXT | ETF | 3.695 | 3.7301 | 3.65 | 3.69 | 15062228.0 |
| 2006-05-02 | COMB | ETF | 10.05 | 10.15 | 10.05 | 10.15 | 106520.0 |
| 2006-05-02 | CPI | ETF | 31.0 | 31.0 | 31.0 | 31.0 | 100.0 |
| 2006-05-02 | CPST | ETF | 3.84 | 3.91 | 3.78 | 3.79 | 1684092.0 |
| 2006-05-02 | CSA | ETF | 19.78 | 19.78 | 19.7 | 19.7 | 1900.0 |
| 2006-05-02 | CSB | ETF | 30.82 | 31.2 | 30.81 | 31.02 | 7900.0 |
| 2006-05-02 | CSQ | ETF | 13.88 | 13.97 | 13.85 | 13.91 | 335400.0 |
| 2006-05-02 | CTEC | ETF | 63.2 | 63.949999999999996 | 57.5 | 60.99999999999999 | 28106.800000000003 |
| 2006-05-02 | CYB | ETF | 6.02 | 6.09 | 6.02 | 6.08 | 17900.0 |
| 2006-05-02 | DBC | ETF | 26.14 | 26.25 | 25.98 | 26.2 | 516300.0 |
| 2006-05-02 | DGT | ETF | 69.34 | 69.49 | 69.17 | 69.42 | 62500.0 |
| 2006-05-02 | DIG | ETF | 17.875 | 17.875 | 17.875 | 17.875 | 80.0 |
| 2006-05-02 | DIV | ETF | 12.03 | 12.15 | 12.03 | 12.1 | 15500.0 |
| 2006-05-02 | DRIV | ETF | 44.45 | 45.85 | 44.44 | 45.46 | 836168.0 |
> showing 50 of 317 rows — these rows as CSV