PREVIEW / etf_daily / 2005-05-09
file: by_date/etf_daily/2005/2005-05-09.parquet size: 14 KB rows: 255
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-09 | SPY | ETF | 117.21 | 118.08 | 117.05 | 117.82 | 43750500.0 |
| 2005-05-09 | QQQ | ETF | 35.87 | 36.06 | 35.657 | 36.03 | 66371706.0 |
| 2005-05-09 | IWM | ETF | 59.33 | 60.0 | 59.035 | 59.92 | 19355600.0 |
| 2005-05-09 | DIA | ETF | 103.46 | 103.88 | 103.21 | 103.75 | 3912600.0 |
| 2005-05-09 | GLD | ETF | 42.54 | 42.61 | 42.48 | 42.55 | 600000.0 |
| 2005-05-09 | TLT | ETF | 91.01 | 91.24 | 91.0 | 91.15 | 327800.0 |
| 2005-05-09 | AAA | ETF | 60.25 | 60.3 | 59.0 | 60.0 | 22700.0 |
| 2005-05-09 | ADRE | ETF | 86.07 | 86.07 | 85.42 | 85.96 | 12392.0 |
| 2005-05-09 | AFK | ETF | 25.95 | 26.1 | 25.9 | 25.95 | 3000.0 |
| 2005-05-09 | AGG | ETF | 101.63 | 101.66 | 101.51 | 101.64 | 70300.0 |
| 2005-05-09 | AIQ | ETF | 52.95 | 54.5 | 52.05 | 53.75 | 19320.0 |
| 2005-05-09 | ARB | ETF | 39.45 | 39.79 | 38.88 | 39.53 | 270200.0 |
| 2005-05-09 | BAB | ETF | 47.81 | 47.97 | 47.47 | 47.65 | 19200.0 |
| 2005-05-09 | BBH | ETF | 53.58 | 53.8467 | 53.15 | 53.75 | 1906200.0 |
| 2005-05-09 | BCM | ETF | 60.58 | 61.41 | 60.58 | 61.322 | 12400.0 |
| 2005-05-09 | BIS | ETF | 638.4 | 638.4 | 638.4 | 638.4 | 3.125 |
| 2005-05-09 | BITS | ETF | 12.4 | 13.0 | 11.896 | 12.444 | 22500.0 |
| 2005-05-09 | BKF | ETF | 34.11 | 34.11 | 33.8 | 33.8 | 6800.0 |
| 2005-05-09 | BNE | ETF | 12.85 | 12.85 | 12.5 | 12.7 | 154700.0 |
| 2005-05-09 | BRF | ETF | 15.38 | 15.4 | 15.35 | 15.35 | 2100.0 |
| 2005-05-09 | BTF | ETF | 85.1 | 85.39999999999999 | 84.85 | 85.0 | 4420.0 |
| 2005-05-09 | CBON | ETF | 26.02 | 27.0 | 26.02 | 26.72 | 13837.0 |
| 2005-05-09 | CDC | ETF | 8.01 | 8.2 | 8.0 | 8.2 | 5500.0 |
| 2005-05-09 | CDL | ETF | 12.29 | 12.3 | 12.0 | 12.1 | 423800.0 |
| 2005-05-09 | CEF | ETF | 5.3 | 5.37 | 5.28 | 5.28 | 220200.0 |
| 2005-05-09 | CHB | ETF | 9.9 | 10.18 | 9.9 | 10.15 | 616700.0 |
| 2005-05-09 | CHIC | ETF | 11.02 | 11.21 | 11.0 | 11.16 | 97849.0 |
| 2005-05-09 | CHIR | ETF | 35.7201 | 35.8899 | 35.3799 | 35.8899 | 743523.0 |
| 2005-05-09 | CIL | ETF | 26.3 | 26.3 | 26.3 | 26.3 | 200.0 |
| 2005-05-09 | CN | ETF | 27.28 | 27.63 | 27.26 | 27.62 | 12000.0 |
| 2005-05-09 | CNXT | ETF | 1.14 | 1.15 | 1.1 | 1.12 | 3692757.0 |
| 2005-05-09 | CPI | ETF | 22.35 | 22.35 | 22.25 | 22.25 | 600.0 |
| 2005-05-09 | CSB | ETF | 31.63 | 31.69 | 31.3 | 31.52 | 13100.0 |
| 2005-05-09 | CSM | ETF | 2.385 | 2.3875 | 2.385 | 2.3875 | 10000.0 |
| 2005-05-09 | CTEC | ETF | 53.75 | 54.85 | 49.199999999999996 | 49.65 | 16803.600000000002 |
| 2005-05-09 | CURE | ETF | 0.2662 | 0.2888 | 0.2537 | 0.2775 | 3674752.0 |
| 2005-05-09 | CYA | ETF | 168.0 | 168.0 | 168.0 | 168.0 | 45.0 |
| 2005-05-09 | CYB | ETF | 3.41 | 3.47 | 3.28 | 3.4 | 7700.0 |
| 2005-05-09 | CZA | ETF | 10.27 | 10.32 | 10.26 | 10.32 | 6200.0 |
| 2005-05-09 | DGT | ETF | 63.65 | 63.79 | 63.62 | 63.62 | 3400.0 |
| 2005-05-09 | DIV | ETF | 13.19 | 13.23 | 13.15 | 13.22 | 11400.0 |
| 2005-05-09 | DRIV | ETF | 26.43 | 26.59 | 25.87 | 26.1 | 786886.0 |
| 2005-05-09 | DSI | ETF | 5.945 | 5.945 | 5.94 | 5.94 | 1600.0 |
| 2005-05-09 | DUSA | ETF | 10.06 | 10.38 | 9.9 | 10.28 | 292799.0 |
| 2005-05-09 | DVY | ETF | 60.59 | 60.83 | 60.3 | 60.83 | 345100.0 |
| 2005-05-09 | EDEN | ETF | 0.71 | 0.8 | 0.71 | 0.8 | 11450.0 |
| 2005-05-09 | EDV | ETF | 26.12 | 26.13 | 26.01 | 26.06 | 8200.0 |
| 2005-05-09 | EEM | ETF | 23.0 | 23.2589 | 23.0 | 23.1933 | 2353500.0 |
| 2005-05-09 | EFA | ETF | 52.5833 | 52.7967 | 52.4833 | 52.7833 | 2148900.0 |
| 2005-05-09 | ELV | ETF | 67.0 | 68.25 | 66.76 | 68.0 | 2725400.0 |
> showing 50 of 255 rows — these rows as CSV