PREVIEW / etf_daily / 2005-05-20
file: by_date/etf_daily/2005/2005-05-20.parquet size: 14 KB rows: 257
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-05-20 | SPY | ETF | 119.34 | 119.39 | 118.74 | 119.12 | 46345500.0 |
| 2005-05-20 | QQQ | ETF | 37.45 | 37.69 | 37.35 | 37.66 | 66708477.0 |
| 2005-05-20 | IWM | ETF | 60.65 | 60.72 | 60.185 | 60.6 | 23165000.0 |
| 2005-05-20 | DIA | ETF | 104.83 | 104.85 | 104.12 | 104.63 | 6342600.0 |
| 2005-05-20 | GLD | ETF | 41.76 | 41.83 | 41.61 | 41.65 | 932800.0 |
| 2005-05-20 | TLT | ETF | 93.25 | 93.51 | 93.21 | 93.44 | 806800.0 |
| 2005-05-20 | AAA | ETF | 58.53 | 58.95 | 58.49 | 58.65 | 120900.0 |
| 2005-05-20 | ADRE | ETF | 86.5 | 86.5 | 85.7 | 86.24 | 5124.0 |
| 2005-05-20 | AFK | ETF | 26.55 | 26.55 | 26.29 | 26.31 | 1500.0 |
| 2005-05-20 | AGG | ETF | 102.31 | 102.31 | 102.01 | 102.13 | 113600.0 |
| 2005-05-20 | AIQ | ETF | 55.2 | 55.2 | 52.5 | 54.3 | 21060.0 |
| 2005-05-20 | ARB | ETF | 41.37 | 41.37 | 40.77 | 41.1 | 113200.0 |
| 2005-05-20 | BAB | ETF | 49.94 | 50.14 | 49.54 | 50.14 | 39300.0 |
| 2005-05-20 | BBH | ETF | 54.7433 | 55.0333 | 54.5067 | 55.0033 | 2490600.0 |
| 2005-05-20 | BCM | ETF | 59.65 | 59.65 | 59.41 | 59.53 | 14500.0 |
| 2005-05-20 | BIS | ETF | 659.2 | 660.8 | 632.0 | 640.0 | 118.0 |
| 2005-05-20 | BITS | ETF | 10.52 | 10.96 | 10.52 | 10.8 | 31762.0 |
| 2005-05-20 | BKF | ETF | 33.72 | 34.0 | 33.41 | 33.45 | 18000.0 |
| 2005-05-20 | BNE | ETF | 12.73 | 12.73 | 12.32 | 12.44 | 100400.0 |
| 2005-05-20 | BRF | ETF | 15.33 | 15.34 | 15.33 | 15.34 | 800.0 |
| 2005-05-20 | BTF | ETF | 84.3 | 85.1 | 84.3 | 85.1 | 1720.0 |
| 2005-05-20 | CBON | ETF | 27.099 | 27.099 | 26.59 | 26.59 | 3759.0 |
| 2005-05-20 | CDC | ETF | 7.14 | 7.34 | 7.0 | 7.34 | 3000.0 |
| 2005-05-20 | CDL | ETF | 11.85 | 12.05 | 11.81 | 12.0 | 147500.0 |
| 2005-05-20 | CEF | ETF | 5.16 | 5.16 | 5.1 | 5.16 | 199200.0 |
| 2005-05-20 | CHB | ETF | 10.09 | 10.09 | 9.92 | 10.03 | 288200.0 |
| 2005-05-20 | CHIC | ETF | 10.94 | 10.94 | 10.71 | 10.77 | 352947.0 |
| 2005-05-20 | CHIR | ETF | 36.8901 | 37.0401 | 36.5499 | 36.8301 | 822044.0 |
| 2005-05-20 | CIL | ETF | 26.55 | 26.55 | 26.55 | 26.55 | 700.0 |
| 2005-05-20 | CIZ | ETF | 21.05 | 21.15 | 21.05 | 21.15 | 500.0 |
| 2005-05-20 | CN | ETF | 27.3 | 27.3 | 27.01 | 27.16 | 24200.0 |
| 2005-05-20 | CNXT | ETF | 1.21 | 1.27 | 1.2 | 1.27 | 4793166.0 |
| 2005-05-20 | CPI | ETF | 22.8 | 22.85 | 22.7 | 22.85 | 6200.0 |
| 2005-05-20 | CSB | ETF | 30.0 | 30.43 | 30.0 | 30.2 | 5900.0 |
| 2005-05-20 | CSM | ETF | 2.4075 | 2.4075 | 2.4075 | 2.4075 | 4000.0 |
| 2005-05-20 | CTEC | ETF | 47.75 | 49.5 | 46.8 | 47.099999999999994 | 9163.0 |
| 2005-05-20 | CURE | ETF | 0.2687 | 0.2875 | 0.2562 | 0.2875 | 3677736.0 |
| 2005-05-20 | CYA | ETF | 153.8 | 156.0 | 153.8 | 155.0 | 55.0 |
| 2005-05-20 | CYB | ETF | 3.2 | 3.2 | 3.15 | 3.15 | 1300.0 |
| 2005-05-20 | DGT | ETF | 63.96 | 63.97 | 63.73 | 63.96 | 3500.0 |
| 2005-05-20 | DIG | ETF | 10.9875 | 10.9875 | 10.9875 | 10.9875 | 800.0 |
| 2005-05-20 | DIV | ETF | 13.26 | 13.37 | 13.26 | 13.37 | 9100.0 |
| 2005-05-20 | DRIV | ETF | 26.38 | 26.38 | 25.78 | 26.15 | 1722788.0 |
| 2005-05-20 | DUSA | ETF | 10.81 | 10.95 | 10.69 | 10.84 | 58196.0 |
| 2005-05-20 | DVY | ETF | 61.27 | 61.3 | 60.92 | 61.24 | 333600.0 |
| 2005-05-20 | EDEN | ETF | 0.67 | 0.77 | 0.65 | 0.7 | 105817.0 |
| 2005-05-20 | EDV | ETF | 26.3 | 26.4 | 26.24 | 26.34 | 15400.0 |
| 2005-05-20 | EEM | ETF | 22.8711 | 22.9111 | 22.73 | 22.9 | 3003300.0 |
| 2005-05-20 | EFA | ETF | 51.8333 | 51.96 | 51.64 | 51.9333 | 2433900.0 |
| 2005-05-20 | ELV | ETF | 66.5 | 66.675 | 66.02 | 66.545 | 1363700.0 |
> showing 50 of 257 rows — these rows as CSV