PREVIEW / etf_daily / 2005-06-30
file: by_date/etf_daily/2005/2005-06-30.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-30 | SPY | ETF | 120.22 | 120.32 | 118.95 | 119.18 | 62288800.0 |
| 2005-06-30 | QQQ | ETF | 37.14 | 37.21 | 36.75 | 36.78 | 87963270.0 |
| 2005-06-30 | IWM | ETF | 64.07 | 64.29 | 63.4 | 63.7 | 28369700.0 |
| 2005-06-30 | DIA | ETF | 103.94 | 104.07 | 102.56 | 102.75 | 9964300.0 |
| 2005-06-30 | GLD | ETF | 43.63 | 43.77 | 43.36 | 43.44 | 1087500.0 |
| 2005-06-30 | TLT | ETF | 95.86 | 96.72 | 95.81 | 96.7 | 2159400.0 |
| 2005-06-30 | AAA | ETF | 57.03 | 57.6 | 57.03 | 57.37 | 50700.0 |
| 2005-06-30 | ADRE | ETF | 93.5 | 93.5 | 91.519 | 91.519 | 5596.0 |
| 2005-06-30 | AFK | ETF | 26.25 | 26.36 | 26.25 | 26.36 | 1900.0 |
| 2005-06-30 | AGG | ETF | 103.19 | 103.38 | 102.99 | 103.38 | 123000.0 |
| 2005-06-30 | AIQ | ETF | 52.25 | 53.7 | 52.15 | 52.3 | 17760.0 |
| 2005-06-30 | AIS | ETF | 1.05 | 1.09 | 0.97 | 1.08 | 154300.0 |
| 2005-06-30 | ARB | ETF | 42.84 | 43.42 | 42.55 | 42.9 | 292400.0 |
| 2005-06-30 | BAB | ETF | 47.45 | 47.62 | 46.8 | 46.8 | 42300.0 |
| 2005-06-30 | BBH | ETF | 55.7767 | 56.1033 | 55.6767 | 55.7667 | 528600.0 |
| 2005-06-30 | BCM | ETF | 62.41 | 62.6 | 61.92 | 61.97 | 10300.0 |
| 2005-06-30 | BIS | ETF | 625.6 | 625.6 | 625.6 | 625.6 | 12.5 |
| 2005-06-30 | BITS | ETF | 14.8 | 15.6 | 14.4 | 15.084 | 35134.0 |
| 2005-06-30 | BKF | ETF | 37.72 | 38.4 | 37.72 | 37.91 | 12000.0 |
| 2005-06-30 | BNE | ETF | 14.65 | 14.7 | 14.38 | 14.46 | 287900.0 |
| 2005-06-30 | BRF | ETF | 15.48 | 15.5 | 15.45 | 15.46 | 7800.0 |
| 2005-06-30 | BTF | ETF | 85.5 | 85.95 | 84.49999999999999 | 85.19999999999999 | 8120.0 |
| 2005-06-30 | CBON | ETF | 31.0 | 31.4 | 31.0 | 31.02 | 64606.0 |
| 2005-06-30 | CDC | ETF | 6.85 | 6.9 | 6.85 | 6.9 | 1100.0 |
| 2005-06-30 | CDL | ETF | 11.5 | 11.65 | 11.28 | 11.45 | 1216000.0 |
| 2005-06-30 | CEF | ETF | 5.35 | 5.37 | 5.29 | 5.3 | 159000.0 |
| 2005-06-30 | CHB | ETF | 10.0 | 10.08 | 9.85 | 9.94 | 273000.0 |
| 2005-06-30 | CHI | ETF | 19.44 | 19.54 | 19.4 | 19.45 | 78300.0 |
| 2005-06-30 | CHIC | ETF | 12.75 | 12.81 | 12.45 | 12.46 | 244190.0 |
| 2005-06-30 | CHIR | ETF | 35.0199 | 35.3499 | 34.8099 | 34.89 | 816518.0 |
| 2005-06-30 | CHY | ETF | 16.32 | 16.39 | 16.29 | 16.38 | 98700.0 |
| 2005-06-30 | CIL | ETF | 25.75 | 25.75 | 25.74 | 25.75 | 1200.0 |
| 2005-06-30 | CIZ | ETF | 22.4 | 23.2 | 22.4 | 23.05 | 2900.0 |
| 2005-06-30 | CN | ETF | 28.85 | 29.05 | 28.85 | 28.95 | 18600.0 |
| 2005-06-30 | CNXT | ETF | 1.54 | 1.62 | 1.54 | 1.61 | 4492049.0 |
| 2005-06-30 | CPST | ETF | 1.35 | 1.39 | 1.26 | 1.27 | 698752.0 |
| 2005-06-30 | CSB | ETF | 29.25 | 29.55 | 29.05 | 29.25 | 29200.0 |
| 2005-06-30 | CSM | ETF | 2.4025 | 2.4025 | 2.395 | 2.4025 | 42000.0 |
| 2005-06-30 | CSQ | ETF | 13.92 | 13.99 | 13.91 | 13.95 | 361900.0 |
| 2005-06-30 | CTEC | ETF | 55.949999999999996 | 56.349999999999994 | 55.49999999999999 | 56.349999999999994 | 8418.0 |
| 2005-06-30 | CURE | ETF | 0.2938 | 0.3038 | 0.2812 | 0.285 | 496520.0 |
| 2005-06-30 | CYA | ETF | 142.2 | 142.2 | 133.0 | 141.0 | 480.0 |
| 2005-06-30 | CYB | ETF | 3.21 | 3.26 | 3.1 | 3.22 | 13200.0 |
| 2005-06-30 | DGT | ETF | 63.6 | 63.6 | 63.18 | 63.32 | 1500.0 |
| 2005-06-30 | DIG | ETF | 12.625 | 12.6375 | 12.625 | 12.6375 | 1040.0 |
| 2005-06-30 | DIV | ETF | 13.79 | 13.79 | 13.7 | 13.79 | 12900.0 |
| 2005-06-30 | DRIV | ETF | 33.2 | 33.22 | 31.52 | 31.75 | 1111263.0 |
| 2005-06-30 | DUSA | ETF | 9.45 | 9.53 | 9.27 | 9.3 | 141593.0 |
| 2005-06-30 | DVY | ETF | 62.21 | 62.33 | 61.69 | 61.73 | 349200.0 |
| 2005-06-30 | EDEN | ETF | 0.77 | 0.83 | 0.77 | 0.83 | 14949.0 |
> showing 50 of 271 rows — these rows as CSV