PREVIEW / etf_daily / 2005-08-05
file: by_date/etf_daily/2005/2005-08-05.parquet size: 15 KB rows: 279
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-08-05 | SPY | ETF | 123.45 | 123.98 | 122.67 | 122.88 | 53595500.0 |
| 2005-08-05 | QQQ | ETF | 39.61 | 39.79 | 39.427 | 39.48 | 71262794.0 |
| 2005-08-05 | IWM | ETF | 66.76 | 66.82 | 65.66 | 65.97 | 33135200.0 |
| 2005-08-05 | DIA | ETF | 105.94 | 106.09 | 105.54 | 105.65 | 7191400.0 |
| 2005-08-05 | GLD | ETF | 43.71 | 43.75 | 43.56 | 43.6 | 1100600.0 |
| 2005-08-05 | TLT | ETF | 91.7 | 91.87 | 91.55 | 91.66 | 1041600.0 |
| 2005-08-05 | AAA | ETF | 56.9 | 56.93 | 56.78 | 56.87 | 2600.0 |
| 2005-08-05 | ADRE | ETF | 98.03 | 99.05 | 97.621 | 97.922 | 9236.0 |
| 2005-08-05 | AFK | ETF | 25.76 | 25.82 | 25.73 | 25.73 | 7600.0 |
| 2005-08-05 | AGG | ETF | 101.23 | 101.29 | 101.1 | 101.1 | 86100.0 |
| 2005-08-05 | AIQ | ETF | 48.95 | 49.2 | 46.75 | 48.15 | 27960.0 |
| 2005-08-05 | AIS | ETF | 1.0 | 1.05 | 0.98 | 1.04 | 48900.0 |
| 2005-08-05 | ARB | ETF | 41.6 | 41.88 | 41.26 | 41.5 | 261000.0 |
| 2005-08-05 | BAB | ETF | 50.69 | 50.92 | 50.66 | 50.79 | 29900.0 |
| 2005-08-05 | BBH | ETF | 64.75 | 64.8033 | 63.6667 | 63.7333 | 1577400.0 |
| 2005-08-05 | BCM | ETF | 58.28 | 59.7 | 57.99 | 58.9 | 133600.0 |
| 2005-08-05 | BIS | ETF | 672.0 | 672.0 | 672.0 | 672.0 | 3.125 |
| 2005-08-05 | BITS | ETF | 14.16 | 14.44 | 14.056 | 14.4 | 1922.0 |
| 2005-08-05 | BKF | ETF | 33.75 | 33.75 | 32.9 | 32.94 | 18500.0 |
| 2005-08-05 | BNE | ETF | 12.93 | 13.84 | 12.93 | 13.76 | 245100.0 |
| 2005-08-05 | BRF | ETF | 15.39 | 15.39 | 15.38 | 15.38 | 2500.0 |
| 2005-08-05 | BTF | ETF | 86.85 | 86.85 | 85.89999999999999 | 86.44999999999999 | 1100.0 |
| 2005-08-05 | CBON | ETF | 32.5 | 33.25 | 32.28 | 32.89 | 10949.0 |
| 2005-08-05 | CDC | ETF | 4.9 | 5.0 | 4.7 | 4.7 | 6400.0 |
| 2005-08-05 | CDL | ETF | 12.73 | 12.77 | 12.384 | 12.44 | 791400.0 |
| 2005-08-05 | CEF | ETF | 5.43 | 5.43 | 5.34 | 5.34 | 314100.0 |
| 2005-08-05 | CEW | ETF | 26.7 | 26.7 | 26.7 | 26.7 | 200.0 |
| 2005-08-05 | CHB | ETF | 11.95 | 12.01 | 11.75 | 11.97 | 423900.0 |
| 2005-08-05 | CHI | ETF | 20.62 | 20.65 | 20.39 | 20.41 | 72800.0 |
| 2005-08-05 | CHIC | ETF | 14.73 | 14.8 | 14.39 | 14.41 | 171758.0 |
| 2005-08-05 | CHIR | ETF | 36.6 | 36.7401 | 36.1899 | 36.1899 | 912944.0 |
| 2005-08-05 | CHY | ETF | 16.53 | 16.56 | 16.35 | 16.37 | 119900.0 |
| 2005-08-05 | CIZ | ETF | 23.5 | 23.5 | 23.3 | 23.4 | 2200.0 |
| 2005-08-05 | CN | ETF | 32.29 | 32.41 | 32.15 | 32.3 | 8700.0 |
| 2005-08-05 | CNXT | ETF | 1.735 | 1.78 | 1.67 | 1.69 | 6196617.0 |
| 2005-08-05 | CPI | ETF | 23.65 | 23.7 | 23.65 | 23.7 | 1200.0 |
| 2005-08-05 | CPST | ETF | 2.53 | 2.78 | 2.5 | 2.66 | 1518964.0 |
| 2005-08-05 | CSB | ETF | 31.57 | 31.58 | 31.25 | 31.33 | 18100.0 |
| 2005-08-05 | CSQ | ETF | 14.34 | 14.46 | 14.3 | 14.35 | 284000.0 |
| 2005-08-05 | CTEC | ETF | 56.699999999999996 | 58.2 | 56.1 | 56.55 | 3145.6000000000004 |
| 2005-08-05 | CURE | ETF | 0.4175 | 0.4175 | 0.3875 | 0.3987 | 2226400.0 |
| 2005-08-05 | CYA | ETF | 98.0 | 98.0 | 91.0 | 91.0 | 1115.0 |
| 2005-08-05 | CYB | ETF | 3.74 | 3.83 | 3.68 | 3.83 | 16200.0 |
| 2005-08-05 | DGT | ETF | 64.72 | 64.73 | 64.55 | 64.73 | 4500.0 |
| 2005-08-05 | DIG | ETF | 13.0375 | 13.0375 | 13.0 | 13.0 | 12480.0 |
| 2005-08-05 | DIV | ETF | 13.86 | 13.92 | 13.76 | 13.76 | 30300.0 |
| 2005-08-05 | DRIV | ETF | 38.05 | 38.4 | 36.86 | 37.06 | 808957.0 |
| 2005-08-05 | DSI | ETF | 5.805 | 5.805 | 5.805 | 5.805 | 2000.0 |
| 2005-08-05 | DUSA | ETF | 10.65 | 10.85 | 10.4 | 10.46 | 158909.0 |
| 2005-08-05 | DVY | ETF | 63.77 | 63.84 | 63.11 | 63.26 | 398200.0 |
> showing 50 of 279 rows — these rows as CSV