PREVIEW / etf_daily / 2005-07-06
file: by_date/etf_daily/2005/2005-07-06.parquet size: 15 KB rows: 274
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-07-06 | SPY | ETF | 120.39 | 120.65 | 119.41 | 119.48 | 52363600.0 |
| 2005-07-06 | QQQ | ETF | 37.03 | 37.28 | 36.864 | 36.93 | 79331938.0 |
| 2005-07-06 | IWM | ETF | 65.01 | 65.14 | 64.38 | 64.4 | 21094100.0 |
| 2005-07-06 | DIA | ETF | 103.63 | 103.85 | 102.61 | 102.67 | 8956200.0 |
| 2005-07-06 | GLD | ETF | 42.36 | 42.38 | 42.24 | 42.25 | 1254600.0 |
| 2005-07-06 | TLT | ETF | 94.63 | 94.83 | 94.43 | 94.82 | 854100.0 |
| 2005-07-06 | AAA | ETF | 50.26 | 50.39 | 49.94 | 50.11 | 22300.0 |
| 2005-07-06 | ADRE | ETF | 90.54 | 92.04 | 90.54 | 91.81 | 2536.0 |
| 2005-07-06 | AFK | ETF | 26.21 | 26.21 | 25.9 | 25.95 | 6600.0 |
| 2005-07-06 | AGG | ETF | 102.49 | 102.56 | 102.34 | 102.46 | 228700.0 |
| 2005-07-06 | AIQ | ETF | 52.5 | 53.3 | 51.7 | 53.05 | 20480.0 |
| 2005-07-06 | AIS | ETF | 1.1 | 1.18 | 1.1 | 1.15 | 417400.0 |
| 2005-07-06 | ARB | ETF | 43.75 | 43.75 | 42.82 | 42.95 | 171500.0 |
| 2005-07-06 | BAB | ETF | 48.02 | 48.29 | 47.76 | 47.87 | 19100.0 |
| 2005-07-06 | BBH | ETF | 56.7167 | 57.33 | 56.62 | 56.6833 | 979800.0 |
| 2005-07-06 | BCM | ETF | 61.52 | 61.532 | 61.33 | 61.41 | 4800.0 |
| 2005-07-06 | BIS | ETF | 593.6 | 608.0 | 593.6 | 608.0 | 15.6 |
| 2005-07-06 | BITS | ETF | 15.32 | 15.44 | 14.92 | 15.2 | 5512.0 |
| 2005-07-06 | BKF | ETF | 37.85 | 38.0 | 37.3 | 37.3 | 7700.0 |
| 2005-07-06 | BNE | ETF | 14.2 | 14.36 | 14.16 | 14.31 | 557500.0 |
| 2005-07-06 | BRF | ETF | 15.55 | 15.55 | 15.55 | 15.55 | 1500.0 |
| 2005-07-06 | BTF | ETF | 85.99999999999999 | 85.99999999999999 | 85.5 | 85.95 | 2600.0 |
| 2005-07-06 | CBON | ETF | 32.0 | 32.52 | 31.48 | 31.84 | 55758.0 |
| 2005-07-06 | CDC | ETF | 7.0 | 7.0 | 6.85 | 6.85 | 2500.0 |
| 2005-07-06 | CDL | ETF | 11.86 | 11.99 | 11.75 | 11.79 | 510400.0 |
| 2005-07-06 | CEF | ETF | 5.2 | 5.23 | 5.15 | 5.19 | 388300.0 |
| 2005-07-06 | CHB | ETF | 10.04 | 10.12 | 9.82 | 9.83 | 137400.0 |
| 2005-07-06 | CHI | ETF | 19.72 | 19.96 | 19.68 | 19.89 | 80300.0 |
| 2005-07-06 | CHIC | ETF | 12.8 | 12.91 | 12.65 | 12.8 | 91237.0 |
| 2005-07-06 | CHIR | ETF | 35.7699 | 35.8299 | 35.0001 | 35.01 | 1076105.0 |
| 2005-07-06 | CHY | ETF | 16.5 | 16.67 | 16.5 | 16.67 | 116100.0 |
| 2005-07-06 | CIZ | ETF | 22.95 | 22.95 | 22.85 | 22.85 | 400.0 |
| 2005-07-06 | CN | ETF | 29.3 | 29.3 | 28.85 | 29.08 | 15800.0 |
| 2005-07-06 | CNXT | ETF | 1.69 | 1.7 | 1.65 | 1.67 | 4275325.0 |
| 2005-07-06 | CPST | ETF | 1.55 | 1.59 | 1.45 | 1.58 | 3234421.0 |
| 2005-07-06 | CSB | ETF | 28.56 | 28.6 | 28.4 | 28.53 | 12600.0 |
| 2005-07-06 | CSQ | ETF | 13.9 | 13.98 | 13.9 | 13.98 | 336600.0 |
| 2005-07-06 | CTEC | ETF | 55.3 | 56.15 | 55.0 | 55.949999999999996 | 9786.0 |
| 2005-07-06 | CURE | ETF | 0.2938 | 0.3063 | 0.2913 | 0.3063 | 636720.0 |
| 2005-07-06 | CYA | ETF | 137.8 | 137.8 | 136.0 | 136.0 | 15.0 |
| 2005-07-06 | CYB | ETF | 3.09 | 3.1 | 3.02 | 3.02 | 24600.0 |
| 2005-07-06 | DGT | ETF | 63.57 | 63.7 | 63.11 | 63.27 | 4600.0 |
| 2005-07-06 | DIG | ETF | 12.3125 | 12.3125 | 12.3125 | 12.3125 | 640.0 |
| 2005-07-06 | DIV | ETF | 13.89 | 13.95 | 13.83 | 13.86 | 18700.0 |
| 2005-07-06 | DRIV | ETF | 32.13 | 32.54 | 31.91 | 32.4 | 445018.0 |
| 2005-07-06 | DSI | ETF | 5.77 | 5.775 | 5.77 | 5.77 | 2200.0 |
| 2005-07-06 | DUSA | ETF | 9.56 | 9.601 | 9.12 | 9.47 | 60493.0 |
| 2005-07-06 | DVY | ETF | 62.51 | 62.59 | 61.97 | 62.03 | 332900.0 |
| 2005-07-06 | EDEN | ETF | 0.84 | 0.92 | 0.84 | 0.92 | 115814.0 |
| 2005-07-06 | EDV | ETF | 26.08 | 26.08 | 26.02 | 26.02 | 7500.0 |
> showing 50 of 274 rows — these rows as CSV