PREVIEW / etf_daily / 2005-05-06
file: by_date/etf_daily/2005/2005-05-06.parquet size: 14 KB rows: 258
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-06 | SPY | ETF | 117.93 | 117.99 | 117.06 | 117.09 | 67415400.0 |
| 2005-05-06 | QQQ | ETF | 35.97 | 36.02 | 35.723 | 35.857 | 77397625.0 |
| 2005-05-06 | IWM | ETF | 59.645 | 59.725 | 59.08 | 59.35 | 23372200.0 |
| 2005-05-06 | DIA | ETF | 103.92 | 104.05 | 103.4 | 103.43 | 5379900.0 |
| 2005-05-06 | GLD | ETF | 42.43 | 42.63 | 42.34 | 42.52 | 3722700.0 |
| 2005-05-06 | TLT | ETF | 90.93 | 91.2 | 90.81 | 91.06 | 850600.0 |
| 2005-05-06 | AAA | ETF | 61.6 | 61.76 | 61.5 | 61.6 | 7000.0 |
| 2005-05-06 | ADRE | ETF | 85.9 | 85.91 | 85.446 | 85.63 | 3020.0 |
| 2005-05-06 | AFK | ETF | 26.0 | 26.09 | 25.9 | 25.9 | 1900.0 |
| 2005-05-06 | AGG | ETF | 101.83 | 101.85 | 101.53 | 101.72 | 70000.0 |
| 2005-05-06 | AIQ | ETF | 52.95 | 54.225 | 52.25 | 53.45 | 32280.0 |
| 2005-05-06 | ARB | ETF | 39.9 | 39.97 | 39.13 | 39.6 | 280800.0 |
| 2005-05-06 | BAB | ETF | 48.02 | 48.48 | 47.83 | 48.17 | 18400.0 |
| 2005-05-06 | BBH | ETF | 53.6133 | 53.6167 | 52.9133 | 53.25 | 1373100.0 |
| 2005-05-06 | BCM | ETF | 59.8 | 60.52 | 59.8 | 60.52 | 17400.0 |
| 2005-05-06 | BIS | ETF | 611.2 | 611.2 | 611.2 | 611.2 | 1.25 |
| 2005-05-06 | BITS | ETF | 10.396 | 12.0 | 10.04 | 11.6 | 14551.0 |
| 2005-05-06 | BKF | ETF | 34.35 | 34.38 | 33.9 | 34.1 | 13800.0 |
| 2005-05-06 | BNE | ETF | 12.74 | 12.88 | 12.61 | 12.85 | 158200.0 |
| 2005-05-06 | BOSS | ETF | 22.82 | 23.1 | 22.82 | 23.1 | 100.0 |
| 2005-05-06 | BRF | ETF | 15.43 | 15.43 | 15.4 | 15.4 | 8100.0 |
| 2005-05-06 | BTF | ETF | 84.60000000000001 | 85.6 | 84.60000000000001 | 85.39999999999999 | 1020.0 |
| 2005-05-06 | CBON | ETF | 25.5 | 27.1 | 25.01 | 26.42 | 61086.0 |
| 2005-05-06 | CDC | ETF | 8.15 | 8.15 | 8.05 | 8.05 | 600.0 |
| 2005-05-06 | CDL | ETF | 12.65 | 12.7 | 12.25 | 12.28 | 408200.0 |
| 2005-05-06 | CEF | ETF | 5.31 | 5.36 | 5.25 | 5.3 | 345900.0 |
| 2005-05-06 | CGW | ETF | 28.0 | 28.02 | 28.0 | 28.02 | 7100.0 |
| 2005-05-06 | CHB | ETF | 10.08 | 10.13 | 9.87 | 9.9 | 303400.0 |
| 2005-05-06 | CHIC | ETF | 11.03 | 11.17 | 11.0 | 11.08 | 86997.0 |
| 2005-05-06 | CHIR | ETF | 35.5599 | 35.88 | 35.4801 | 35.7801 | 957412.0 |
| 2005-05-06 | CIZ | ETF | 20.85 | 20.9 | 20.85 | 20.9 | 700.0 |
| 2005-05-06 | CN | ETF | 27.33 | 27.35 | 27.0 | 27.33 | 2500.0 |
| 2005-05-06 | CNXT | ETF | 1.1 | 1.15 | 1.09 | 1.14 | 4952516.0 |
| 2005-05-06 | CPI | ETF | 22.9 | 22.9 | 22.25 | 22.25 | 7500.0 |
| 2005-05-06 | CSB | ETF | 31.43 | 31.8 | 31.43 | 31.8 | 14300.0 |
| 2005-05-06 | CTEC | ETF | 55.199999999999996 | 55.449999999999996 | 53.099999999999994 | 53.65 | 2877.0 |
| 2005-05-06 | CURE | ETF | 0.2288 | 0.2662 | 0.2288 | 0.2562 | 5622600.0 |
| 2005-05-06 | CYA | ETF | 167.8 | 171.0 | 167.8 | 169.0 | 650.0 |
| 2005-05-06 | CYB | ETF | 3.44 | 3.55 | 3.36 | 3.46 | 13900.0 |
| 2005-05-06 | CZA | ETF | 10.2 | 10.28 | 10.2 | 10.28 | 3800.0 |
| 2005-05-06 | DIG | ETF | 11.525 | 11.525 | 11.525 | 11.525 | 240.0 |
| 2005-05-06 | DIV | ETF | 13.25 | 13.25 | 13.16 | 13.16 | 8300.0 |
| 2005-05-06 | DRIV | ETF | 26.44 | 26.69 | 25.79 | 26.5 | 979769.0 |
| 2005-05-06 | DSI | ETF | 5.925 | 5.98 | 5.925 | 5.97 | 5200.0 |
| 2005-05-06 | DUSA | ETF | 9.8 | 10.0 | 9.75 | 9.81 | 51337.0 |
| 2005-05-06 | DVY | ETF | 60.95 | 60.98 | 60.35 | 60.45 | 534300.0 |
| 2005-05-06 | EDEN | ETF | 0.81 | 0.88 | 0.761 | 0.819 | 26555.0 |
| 2005-05-06 | EDV | ETF | 26.01 | 26.08 | 25.95 | 26.08 | 16500.0 |
| 2005-05-06 | EEM | ETF | 23.0778 | 23.2611 | 23.0778 | 23.1722 | 5188500.0 |
| 2005-05-06 | EFA | ETF | 52.8833 | 52.9167 | 52.6033 | 52.6633 | 1951500.0 |
> showing 50 of 258 rows — these rows as CSV