PREVIEW / etf_daily / 2005-06-06
file: by_date/etf_daily/2005/2005-06-06.parquet size: 15 KB rows: 271
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-06-06 | SPY | ETF | 119.95 | 120.2 | 119.55 | 120.04 | 36046400.0 |
| 2005-06-06 | QQQ | ETF | 38.12 | 38.19 | 37.96 | 38.11 | 53078551.0 |
| 2005-06-06 | IWM | ETF | 61.73 | 62.06 | 61.525 | 61.985 | 16974800.0 |
| 2005-06-06 | DIA | ETF | 104.66 | 104.99 | 104.25 | 104.63 | 2761400.0 |
| 2005-06-06 | GLD | ETF | 42.56 | 42.65 | 42.45 | 42.48 | 2470800.0 |
| 2005-06-06 | TLT | ETF | 95.5 | 95.88 | 95.35 | 95.75 | 1088700.0 |
| 2005-06-06 | AAA | ETF | 58.41 | 58.41 | 58.06 | 58.31 | 2200.0 |
| 2005-06-06 | ADRE | ETF | 89.9 | 89.9 | 88.0 | 89.07 | 3816.0 |
| 2005-06-06 | AFK | ETF | 26.51 | 26.59 | 26.5 | 26.5 | 9300.0 |
| 2005-06-06 | AGG | ETF | 102.94 | 103.03 | 102.8 | 102.93 | 104200.0 |
| 2005-06-06 | AIQ | ETF | 51.0 | 52.15 | 50.4 | 51.85 | 19880.0 |
| 2005-06-06 | AIS | ETF | 0.79 | 0.82 | 0.79 | 0.82 | 37700.0 |
| 2005-06-06 | ARB | ETF | 41.96 | 42.4 | 41.71 | 42.15 | 126800.0 |
| 2005-06-06 | BAB | ETF | 48.95 | 49.06 | 48.64 | 49.05 | 31000.0 |
| 2005-06-06 | BBH | ETF | 56.3167 | 56.4767 | 55.52 | 55.8433 | 1662900.0 |
| 2005-06-06 | BCM | ETF | 58.45 | 58.86 | 58.25 | 58.8 | 8200.0 |
| 2005-06-06 | BIS | ETF | 572.8 | 614.4 | 572.8 | 614.4 | 49.4 |
| 2005-06-06 | BITS | ETF | 11.6 | 12.0 | 11.2 | 11.8 | 10435.0 |
| 2005-06-06 | BKF | ETF | 38.65 | 39.2 | 38.65 | 38.98 | 38600.0 |
| 2005-06-06 | BNE | ETF | 13.28 | 13.28 | 13.06 | 13.12 | 110100.0 |
| 2005-06-06 | BOSS | ETF | 24.65 | 24.65 | 24.65 | 24.65 | 100.0 |
| 2005-06-06 | BRF | ETF | 15.52 | 15.52 | 15.46 | 15.46 | 3500.0 |
| 2005-06-06 | BTF | ETF | 85.5 | 85.64999999999999 | 85.25 | 85.64999999999999 | 2600.0 |
| 2005-06-06 | CBON | ETF | 28.02 | 28.92 | 27.89 | 28.87 | 46456.0 |
| 2005-06-06 | CDC | ETF | 8.9 | 9.0 | 8.71 | 8.95 | 11900.0 |
| 2005-06-06 | CDL | ETF | 12.0 | 12.22 | 11.97 | 12.17 | 425200.0 |
| 2005-06-06 | CEF | ETF | 5.4 | 5.48 | 5.4 | 5.44 | 275100.0 |
| 2005-06-06 | CEW | ETF | 26.65 | 26.65 | 26.51 | 26.51 | 6700.0 |
| 2005-06-06 | CHB | ETF | 9.64 | 9.8 | 9.58 | 9.8 | 420200.0 |
| 2005-06-06 | CHI | ETF | 19.65 | 19.7 | 19.54 | 19.67 | 72100.0 |
| 2005-06-06 | CHIC | ETF | 12.6 | 12.66 | 12.391 | 12.48 | 251928.0 |
| 2005-06-06 | CHIR | ETF | 37.5201 | 38.0001 | 37.1601 | 37.65 | 913719.0 |
| 2005-06-06 | CHY | ETF | 16.07 | 16.17 | 16.06 | 16.15 | 102600.0 |
| 2005-06-06 | CIL | ETF | 25.55 | 25.6 | 25.5 | 25.6 | 3100.0 |
| 2005-06-06 | CIZ | ETF | 22.0 | 22.34 | 21.9 | 22.34 | 1200.0 |
| 2005-06-06 | CN | ETF | 27.21 | 27.26 | 27.2 | 27.22 | 9700.0 |
| 2005-06-06 | CNXT | ETF | 1.59 | 1.64 | 1.58 | 1.61 | 7672725.0 |
| 2005-06-06 | CPI | ETF | 23.06 | 23.06 | 23.06 | 23.06 | 100.0 |
| 2005-06-06 | CPST | ETF | 1.01 | 1.02 | 0.97 | 0.98 | 459978.0 |
| 2005-06-06 | CSB | ETF | 30.77 | 30.95 | 30.6 | 30.7 | 18000.0 |
| 2005-06-06 | CSM | ETF | 2.405 | 2.405 | 2.405 | 2.405 | 4000.0 |
| 2005-06-06 | CSQ | ETF | 13.99 | 13.99 | 13.82 | 13.92 | 309900.0 |
| 2005-06-06 | CTEC | ETF | 47.300000000000004 | 48.15 | 46.25 | 47.599999999999994 | 5392.0 |
| 2005-06-06 | CURE | ETF | 0.3175 | 0.3287 | 0.3175 | 0.325 | 409920.0 |
| 2005-06-06 | CYA | ETF | 179.2 | 181.8 | 179.2 | 181.8 | 555.0 |
| 2005-06-06 | CYB | ETF | 3.0 | 3.01 | 3.0 | 3.0 | 23100.0 |
| 2005-06-06 | DGT | ETF | 63.95 | 63.95 | 63.76 | 63.77 | 1600.0 |
| 2005-06-06 | DIG | ETF | 11.775 | 11.775 | 11.775 | 11.775 | 80.0 |
| 2005-06-06 | DIV | ETF | 13.85 | 13.85 | 13.75 | 13.75 | 7400.0 |
| 2005-06-06 | DRIV | ETF | 27.51 | 28.18 | 27.45 | 27.8 | 697291.0 |
> showing 50 of 271 rows — these rows as CSV