PREVIEW / etf_daily / 2005-06-02
file: by_date/etf_daily/2005/2005-06-02.parquet size: 15 KB rows: 269
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-02 | SPY | ETF | 120.23 | 120.84 | 120.1 | 120.76 | 39704500.0 |
| 2005-06-02 | QQQ | ETF | 38.33 | 38.66 | 38.3 | 38.66 | 76148728.0 |
| 2005-06-02 | IWM | ETF | 62.04 | 62.34 | 61.845 | 62.21 | 14395000.0 |
| 2005-06-02 | DIA | ETF | 105.11 | 105.56 | 105.04 | 105.47 | 3463700.0 |
| 2005-06-02 | GLD | ETF | 41.92 | 42.28 | 41.91 | 42.1 | 5752600.0 |
| 2005-06-02 | TLT | ETF | 95.73 | 96.19 | 95.73 | 96.04 | 1703400.0 |
| 2005-06-02 | AAA | ETF | 58.45 | 59.09 | 58.45 | 58.9 | 8800.0 |
| 2005-06-02 | ADRE | ETF | 88.83 | 89.31 | 88.83 | 89.2694 | 7876.0 |
| 2005-06-02 | AFK | ETF | 26.6 | 26.61 | 26.24 | 26.24 | 5800.0 |
| 2005-06-02 | AGG | ETF | 103.2 | 103.21 | 103.03 | 103.17 | 269800.0 |
| 2005-06-02 | AIQ | ETF | 53.7 | 53.7 | 51.0 | 51.0 | 27560.0 |
| 2005-06-02 | AIS | ETF | 0.83 | 0.85 | 0.8 | 0.8 | 80700.0 |
| 2005-06-02 | ARB | ETF | 41.35 | 42.71 | 41.34 | 42.05 | 509800.0 |
| 2005-06-02 | BAB | ETF | 49.0 | 49.85 | 49.0 | 49.85 | 23400.0 |
| 2005-06-02 | BBH | ETF | 57.1 | 57.4533 | 56.9667 | 57.4433 | 966600.0 |
| 2005-06-02 | BCM | ETF | 58.04 | 58.2 | 57.86 | 57.86 | 11300.0 |
| 2005-06-02 | BIS | ETF | 644.8 | 649.6 | 644.8 | 648.0 | 9.4 |
| 2005-06-02 | BITS | ETF | 10.8404 | 11.36 | 10.8 | 11.04 | 5135.0 |
| 2005-06-02 | BKF | ETF | 36.5 | 38.84 | 36.5 | 38.61 | 53800.0 |
| 2005-06-02 | BNE | ETF | 13.5 | 13.55 | 13.42 | 13.48 | 109000.0 |
| 2005-06-02 | BRF | ETF | 15.41 | 15.49 | 15.4 | 15.47 | 10100.0 |
| 2005-06-02 | BTF | ETF | 85.85000000000001 | 85.85000000000001 | 85.6 | 85.7 | 2280.0 |
| 2005-06-02 | CBON | ETF | 28.95 | 28.95 | 28.0 | 28.19 | 209457.0 |
| 2005-06-02 | CDC | ETF | 8.72 | 9.25 | 8.72 | 8.9 | 12100.0 |
| 2005-06-02 | CDL | ETF | 11.96 | 12.03 | 11.88 | 11.94 | 164200.0 |
| 2005-06-02 | CEF | ETF | 5.35 | 5.42 | 5.34 | 5.35 | 426700.0 |
| 2005-06-02 | CGW | ETF | 28.4 | 28.4 | 28.18 | 28.18 | 900.0 |
| 2005-06-02 | CHB | ETF | 9.72 | 9.82 | 9.65 | 9.8 | 735600.0 |
| 2005-06-02 | CHI | ETF | 19.6 | 19.6 | 19.43 | 19.439 | 98700.0 |
| 2005-06-02 | CHIC | ETF | 12.31 | 12.9 | 12.31 | 12.76 | 585941.0 |
| 2005-06-02 | CHIR | ETF | 37.83 | 38.1399 | 37.8099 | 38.0301 | 700210.0 |
| 2005-06-02 | CHY | ETF | 15.99 | 16.01 | 15.9 | 15.92 | 119200.0 |
| 2005-06-02 | CIL | ETF | 25.65 | 25.74 | 25.52 | 25.65 | 1400.0 |
| 2005-06-02 | CIZ | ETF | 22.1 | 22.1 | 22.1 | 22.1 | 100.0 |
| 2005-06-02 | CN | ETF | 27.15 | 27.45 | 27.11 | 27.17 | 8500.0 |
| 2005-06-02 | CNXT | ETF | 1.49 | 1.521 | 1.48 | 1.52 | 3761546.0 |
| 2005-06-02 | CPI | ETF | 23.08 | 23.08 | 22.9 | 22.9 | 6300.0 |
| 2005-06-02 | CPST | ETF | 0.96 | 1.05 | 0.92 | 1.02 | 3849643.0 |
| 2005-06-02 | CSB | ETF | 30.7 | 31.09 | 30.7 | 30.98 | 10100.0 |
| 2005-06-02 | CSQ | ETF | 13.88 | 14.0 | 13.83 | 13.99 | 373500.0 |
| 2005-06-02 | CTEC | ETF | 46.25 | 49.74999999999999 | 45.75 | 48.89999999999999 | 25644.600000000002 |
| 2005-06-02 | CURE | ETF | 0.3137 | 0.3175 | 0.3063 | 0.3125 | 658224.0 |
| 2005-06-02 | CYA | ETF | 176.0 | 186.0 | 176.0 | 184.8 | 590.0 |
| 2005-06-02 | CYB | ETF | 3.0 | 3.09 | 2.99 | 3.09 | 106700.0 |
| 2005-06-02 | DGT | ETF | 64.2 | 64.34 | 64.18 | 64.26 | 31000.0 |
| 2005-06-02 | DIG | ETF | 11.875 | 11.875 | 11.775 | 11.775 | 1600.0 |
| 2005-06-02 | DIV | ETF | 13.8 | 13.9 | 13.602 | 13.84 | 31200.0 |
| 2005-06-02 | DRIV | ETF | 27.78 | 28.31 | 27.36 | 28.25 | 997004.0 |
| 2005-06-02 | DSI | ETF | 5.98 | 5.98 | 5.98 | 5.98 | 1200.0 |
| 2005-06-02 | DUSA | ETF | 11.03 | 11.11 | 10.67 | 10.71 | 83726.0 |
> showing 50 of 269 rows — these rows as CSV