PREVIEW / etf_daily / 2005-04-26
file: by_date/etf_daily/2005/2005-04-26.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-04-26 | SPY | ETF | 115.96 | 116.77 | 115.15 | 115.2 | 72626000.0 |
| 2005-04-26 | QQQ | ETF | 35.29 | 35.7 | 35.04 | 35.05 | 108099464.0 |
| 2005-04-26 | IWM | ETF | 58.98 | 59.565 | 58.025 | 58.39 | 30991400.0 |
| 2005-04-26 | DIA | ETF | 102.06 | 102.62 | 101.43 | 101.51 | 6071100.0 |
| 2005-04-26 | GLD | ETF | 43.69 | 43.7 | 43.5 | 43.64 | 1531400.0 |
| 2005-04-26 | TLT | ETF | 91.99 | 92.05 | 91.34 | 91.6 | 549300.0 |
| 2005-04-26 | AAA | ETF | 65.35 | 65.35 | 65.22 | 65.35 | 1200.0 |
| 2005-04-26 | ADRE | ETF | 83.9 | 84.34 | 83.51 | 83.859 | 9984.0 |
| 2005-04-26 | AFK | ETF | 25.75 | 25.8 | 25.68 | 25.72 | 1700.0 |
| 2005-04-26 | AGG | ETF | 102.12 | 102.12 | 101.81 | 101.81 | 68800.0 |
| 2005-04-26 | AIQ | ETF | 48.5 | 48.5 | 46.8 | 47.5 | 24580.0 |
| 2005-04-26 | ARB | ETF | 42.25 | 42.45 | 40.93 | 41.04 | 372500.0 |
| 2005-04-26 | BAB | ETF | 47.31 | 47.36 | 46.6 | 46.6 | 17300.0 |
| 2005-04-26 | BBH | ETF | 52.75 | 53.1667 | 51.3333 | 52.0533 | 4331700.0 |
| 2005-04-26 | BCM | ETF | 59.7 | 59.7 | 59.0 | 59.24 | 14900.0 |
| 2005-04-26 | BIS | ETF | 598.4 | 598.4 | 587.2 | 598.4 | 25.0 |
| 2005-04-26 | BITS | ETF | 10.8 | 11.6 | 10.8 | 11.6 | 4533.0 |
| 2005-04-26 | BKF | ETF | 36.6 | 36.64 | 35.0 | 35.2 | 71400.0 |
| 2005-04-26 | BNE | ETF | 13.95 | 14.11 | 13.75 | 13.98 | 141900.0 |
| 2005-04-26 | BRF | ETF | 15.3 | 15.32 | 15.24 | 15.29 | 5900.0 |
| 2005-04-26 | BTF | ETF | 84.60000000000001 | 85.005 | 84.35 | 84.74999999999999 | 2420.0 |
| 2005-04-26 | CBON | ETF | 23.75 | 23.8 | 23.35 | 23.55 | 18668.0 |
| 2005-04-26 | CDC | ETF | 8.3 | 8.3 | 7.85 | 7.95 | 15700.0 |
| 2005-04-26 | CDL | ETF | 12.64 | 12.74 | 12.55 | 12.61 | 181700.0 |
| 2005-04-26 | CEF | ETF | 5.43 | 5.44 | 5.4 | 5.41 | 343200.0 |
| 2005-04-26 | CEW | ETF | 26.6 | 26.64 | 26.41 | 26.41 | 2600.0 |
| 2005-04-26 | CGW | ETF | 28.0 | 28.15 | 26.5 | 27.95 | 7300.0 |
| 2005-04-26 | CHB | ETF | 10.12 | 10.12 | 9.5 | 9.54 | 993900.0 |
| 2005-04-26 | CHIC | ETF | 11.1 | 11.1 | 10.94 | 10.97 | 182170.0 |
| 2005-04-26 | CHIR | ETF | 34.6299 | 34.86 | 33.8499 | 33.9501 | 1068868.0 |
| 2005-04-26 | CID | ETF | 9.41 | 9.52 | 9.41 | 9.42 | 3000.0 |
| 2005-04-26 | CIL | ETF | 26.02 | 26.02 | 26.02 | 26.02 | 600.0 |
| 2005-04-26 | CIZ | ETF | 20.05 | 20.05 | 20.0 | 20.0 | 200.0 |
| 2005-04-26 | CN | ETF | 26.75 | 27.0 | 26.62 | 27.0 | 14600.0 |
| 2005-04-26 | CNXT | ETF | 1.3 | 1.34 | 1.22 | 1.26 | 4102860.0 |
| 2005-04-26 | CSB | ETF | 31.92 | 32.11 | 31.8 | 32.03 | 25500.0 |
| 2005-04-26 | CSM | ETF | 2.3825 | 2.3825 | 2.3825 | 2.3825 | 2400.0 |
| 2005-04-26 | CTEC | ETF | 52.8 | 54.65 | 52.5 | 52.5 | 14509.800000000001 |
| 2005-04-26 | CURE | ETF | 0.2313 | 0.245 | 0.22 | 0.2225 | 999176.0 |
| 2005-04-26 | CYA | ETF | 168.8 | 170.0 | 160.0 | 162.0 | 1045.0 |
| 2005-04-26 | CYB | ETF | 4.19 | 4.25 | 4.12 | 4.12 | 44700.0 |
| 2005-04-26 | CZA | ETF | 10.1 | 10.12 | 10.1 | 10.12 | 12500.0 |
| 2005-04-26 | DGT | ETF | 63.0 | 63.12 | 63.0 | 63.12 | 400.0 |
| 2005-04-26 | DIV | ETF | 13.0 | 13.03 | 12.9 | 12.94 | 17300.0 |
| 2005-04-26 | DRIV | ETF | 29.76 | 30.49 | 29.39 | 29.56 | 773514.0 |
| 2005-04-26 | DSI | ETF | 5.855 | 5.91 | 5.855 | 5.91 | 7600.0 |
| 2005-04-26 | DUSA | ETF | 9.84 | 10.15 | 9.81 | 10.07 | 98674.0 |
| 2005-04-26 | DVY | ETF | 59.66 | 59.69 | 59.05 | 59.1 | 377100.0 |
| 2005-04-26 | EDEN | ETF | 0.59 | 0.59 | 0.52 | 0.56 | 62381.0 |
| 2005-04-26 | EDV | ETF | 26.2 | 26.25 | 26.12 | 26.22 | 12300.0 |
> showing 50 of 257 rows — these rows as CSV