PREVIEW / etf_daily / 2005-06-24
file: by_date/etf_daily/2005/2005-06-24.parquet size: 15 KB rows: 272
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-24 | SPY | ETF | 119.88 | 120.01 | 118.84 | 118.98 | 58572500.0 |
| 2005-06-24 | QQQ | ETF | 37.38 | 37.41 | 36.958 | 36.97 | 142329993.0 |
| 2005-06-24 | IWM | ETF | 62.94 | 63.02 | 62.07 | 62.21 | 25158200.0 |
| 2005-06-24 | DIA | ETF | 103.99 | 104.02 | 102.78 | 102.86 | 9810400.0 |
| 2005-06-24 | GLD | ETF | 43.96 | 44.06 | 43.68 | 43.9 | 473500.0 |
| 2005-06-24 | TLT | ETF | 96.24 | 96.45 | 96.02 | 96.39 | 928000.0 |
| 2005-06-24 | AAA | ETF | 56.85 | 57.23 | 56.85 | 57.15 | 15200.0 |
| 2005-06-24 | ADRE | ETF | 90.01 | 91.55 | 89.9 | 90.1 | 7864.0 |
| 2005-06-24 | AFK | ETF | 26.4 | 26.4 | 26.07 | 26.17 | 6400.0 |
| 2005-06-24 | AGG | ETF | 103.34 | 103.36 | 103.12 | 103.32 | 171000.0 |
| 2005-06-24 | AIQ | ETF | 50.8 | 52.4 | 50.8 | 51.25 | 41800.0 |
| 2005-06-24 | AIS | ETF | 1.08 | 1.09 | 1.0 | 1.05 | 108800.0 |
| 2005-06-24 | ARB | ETF | 42.8 | 42.86 | 42.06 | 42.28 | 164200.0 |
| 2005-06-24 | BAB | ETF | 50.04 | 50.31 | 49.884 | 50.05 | 19900.0 |
| 2005-06-24 | BBH | ETF | 55.57 | 56.0733 | 55.45 | 55.7667 | 1184700.0 |
| 2005-06-24 | BCM | ETF | 62.66 | 62.68 | 62.29 | 62.4 | 19900.0 |
| 2005-06-24 | BIS | ETF | 616.0 | 616.0 | 576.0 | 606.4 | 54.5 |
| 2005-06-24 | BITS | ETF | 12.96 | 12.96 | 12.36 | 12.36 | 6354.0 |
| 2005-06-24 | BKF | ETF | 38.1 | 38.15 | 37.65 | 38.05 | 35300.0 |
| 2005-06-24 | BNE | ETF | 14.23 | 14.23 | 13.9 | 14.17 | 880000.0 |
| 2005-06-24 | BRF | ETF | 15.51 | 15.51 | 15.41 | 15.46 | 10400.0 |
| 2005-06-24 | BTF | ETF | 85.74999999999999 | 86.14999999999999 | 85.55 | 85.55 | 2100.0 |
| 2005-06-24 | CBON | ETF | 29.25 | 29.74 | 29.06 | 29.48 | 383408.0 |
| 2005-06-24 | CDC | ETF | 7.15 | 7.15 | 6.8 | 6.82 | 11000.0 |
| 2005-06-24 | CDL | ETF | 11.99 | 12.14 | 11.77 | 12.0 | 1829000.0 |
| 2005-06-24 | CEF | ETF | 5.39 | 5.44 | 5.35 | 5.4 | 266100.0 |
| 2005-06-24 | CEW | ETF | 26.51 | 26.51 | 26.5 | 26.51 | 5200.0 |
| 2005-06-24 | CHB | ETF | 9.78 | 9.78 | 9.5 | 9.74 | 603500.0 |
| 2005-06-24 | CHI | ETF | 19.34 | 19.43 | 19.27 | 19.41 | 80400.0 |
| 2005-06-24 | CHIC | ETF | 12.49 | 12.53 | 11.91 | 12.1 | 346028.0 |
| 2005-06-24 | CHIR | ETF | 35.01 | 35.4999 | 34.89 | 35.2101 | 843481.0 |
| 2005-06-24 | CHY | ETF | 16.4 | 16.4 | 16.28 | 16.341 | 128900.0 |
| 2005-06-24 | CN | ETF | 28.74 | 28.9 | 28.74 | 28.85 | 13400.0 |
| 2005-06-24 | CNXT | ETF | 1.68 | 1.73 | 1.59 | 1.6 | 33396146.0 |
| 2005-06-24 | CPST | ETF | 1.28 | 1.32 | 1.21 | 1.29 | 4245081.0 |
| 2005-06-24 | CSB | ETF | 29.68 | 29.71 | 29.41 | 29.49 | 8800.0 |
| 2005-06-24 | CSQ | ETF | 13.78 | 13.8 | 13.62 | 13.65 | 380300.0 |
| 2005-06-24 | CTEC | ETF | 53.65 | 53.65 | 52.449999999999996 | 52.449999999999996 | 12883.6 |
| 2005-06-24 | CURE | ETF | 0.2437 | 0.25 | 0.2387 | 0.245 | 372648.0 |
| 2005-06-24 | CYA | ETF | 144.0 | 144.0 | 144.0 | 144.0 | 5.0 |
| 2005-06-24 | CYB | ETF | 3.3 | 3.32 | 3.23 | 3.32 | 14700.0 |
| 2005-06-24 | DGT | ETF | 63.77 | 63.77 | 63.21 | 63.21 | 700.0 |
| 2005-06-24 | DIG | ETF | 12.4 | 12.4 | 12.4 | 12.4 | 160.0 |
| 2005-06-24 | DIV | ETF | 13.84 | 13.84 | 13.63 | 13.65 | 10500.0 |
| 2005-06-24 | DRIV | ETF | 31.1 | 31.15 | 30.47 | 30.96 | 586687.0 |
| 2005-06-24 | DSI | ETF | 5.76 | 5.76 | 5.72 | 5.72 | 13400.0 |
| 2005-06-24 | DUSA | ETF | 8.92 | 9.06 | 8.75 | 8.99 | 317995.0 |
| 2005-06-24 | DVY | ETF | 61.93 | 61.94 | 61.37 | 61.41 | 440400.0 |
| 2005-06-24 | EDEN | ETF | 0.66 | 0.9 | 0.66 | 0.87 | 228807.0 |
| 2005-06-24 | EDV | ETF | 26.08 | 26.1 | 25.92 | 26.1 | 8700.0 |
> showing 50 of 272 rows — these rows as CSV