PREVIEW / etf_daily / 2005-07-19
file: by_date/etf_daily/2005/2005-07-19.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-19 | SPY | ETF | 122.71 | 123.11 | 122.41 | 123.02 | 59165700.0 |
| 2005-07-19 | QQQ | ETF | 38.91 | 39.196 | 38.84 | 39.18 | 78687487.0 |
| 2005-07-19 | IWM | ETF | 65.89 | 66.65 | 65.75 | 66.54 | 14000400.0 |
| 2005-07-19 | DIA | ETF | 106.45 | 106.59 | 106.11 | 106.5 | 3829200.0 |
| 2005-07-19 | GLD | ETF | 41.88 | 42.0 | 41.81 | 41.89 | 1132600.0 |
| 2005-07-19 | TLT | ETF | 93.23 | 93.72 | 93.12 | 93.6 | 1226900.0 |
| 2005-07-19 | AAA | ETF | 50.46 | 50.51 | 50.15 | 50.2 | 23600.0 |
| 2005-07-19 | ADRE | ETF | 97.0 | 97.0 | 93.27 | 94.23 | 6256.0 |
| 2005-07-19 | AFK | ETF | 25.75 | 25.9 | 25.75 | 25.87 | 11400.0 |
| 2005-07-19 | AGG | ETF | 102.11 | 102.29 | 102.09 | 102.16 | 127300.0 |
| 2005-07-19 | AIQ | ETF | 55.0 | 55.5 | 54.0 | 54.5 | 49480.0 |
| 2005-07-19 | AIS | ETF | 1.06 | 1.06 | 0.99 | 1.04 | 36500.0 |
| 2005-07-19 | ARB | ETF | 43.0 | 43.33 | 42.89 | 42.89 | 128800.0 |
| 2005-07-19 | BAB | ETF | 47.8 | 48.18 | 47.65 | 47.9 | 39900.0 |
| 2005-07-19 | BBH | ETF | 61.6333 | 62.27 | 61.4067 | 61.48 | 2245500.0 |
| 2005-07-19 | BCM | ETF | 63.4 | 64.03 | 63.3 | 63.66 | 8700.0 |
| 2005-07-19 | BIS | ETF | 648.0 | 676.8 | 648.0 | 676.8 | 29.4 |
| 2005-07-19 | BITS | ETF | 13.88 | 14.08 | 13.8 | 14.08 | 1912.0 |
| 2005-07-19 | BKF | ETF | 35.15 | 35.15 | 34.5 | 34.81 | 43200.0 |
| 2005-07-19 | BNE | ETF | 13.98 | 14.22 | 13.96 | 14.16 | 185500.0 |
| 2005-07-19 | BRF | ETF | 15.41 | 15.45 | 15.36 | 15.45 | 17600.0 |
| 2005-07-19 | BTF | ETF | 86.8 | 87.14999999999999 | 86.5 | 87.14999999999999 | 3560.0 |
| 2005-07-19 | CBON | ETF | 32.4 | 32.4 | 31.03 | 31.73 | 6920.0 |
| 2005-07-19 | CDC | ETF | 7.0 | 7.0 | 6.81 | 6.95 | 6700.0 |
| 2005-07-19 | CDL | ETF | 11.34 | 11.48 | 11.23 | 11.48 | 468500.0 |
| 2005-07-19 | CEF | ETF | 5.19 | 5.2 | 5.14 | 5.14 | 213100.0 |
| 2005-07-19 | CEW | ETF | 26.79 | 26.79 | 26.79 | 26.79 | 500.0 |
| 2005-07-19 | CHB | ETF | 10.5 | 10.64 | 10.45 | 10.46 | 295200.0 |
| 2005-07-19 | CHI | ETF | 19.78 | 19.999 | 19.74 | 19.96 | 85100.0 |
| 2005-07-19 | CHIC | ETF | 14.47 | 14.65 | 14.26 | 14.5 | 952496.0 |
| 2005-07-19 | CHIR | ETF | 36.2601 | 36.2799 | 35.7201 | 35.8899 | 627246.0 |
| 2005-07-19 | CHY | ETF | 16.5 | 16.55 | 16.45 | 16.55 | 131700.0 |
| 2005-07-19 | CIL | ETF | 25.74 | 25.75 | 25.67 | 25.72 | 3800.0 |
| 2005-07-19 | CN | ETF | 30.19 | 30.75 | 30.19 | 30.71 | 45800.0 |
| 2005-07-19 | CNXT | ETF | 1.9 | 1.94 | 1.85 | 1.85 | 5535570.0 |
| 2005-07-19 | CPST | ETF | 1.84 | 1.89 | 1.8 | 1.81 | 676332.0 |
| 2005-07-19 | CSB | ETF | 29.65 | 29.75 | 29.5 | 29.65 | 9600.0 |
| 2005-07-19 | CSM | ETF | 2.4125 | 2.4125 | 2.41 | 2.41 | 4000.0 |
| 2005-07-19 | CSQ | ETF | 14.25 | 14.38 | 14.22 | 14.35 | 420800.0 |
| 2005-07-19 | CTEC | ETF | 52.64999999999999 | 52.85 | 51.95 | 52.4 | 9695.0 |
| 2005-07-19 | CURE | ETF | 0.325 | 0.3325 | 0.3088 | 0.3125 | 711464.0 |
| 2005-07-19 | CYA | ETF | 140.2 | 141.2 | 138.2 | 140.6 | 145.0 |
| 2005-07-19 | CYB | ETF | 2.9 | 2.95 | 2.83 | 2.95 | 7900.0 |
| 2005-07-19 | DGT | ETF | 64.24 | 64.57 | 64.15 | 64.4 | 1900.0 |
| 2005-07-19 | DIG | ETF | 12.0625 | 12.0625 | 11.95 | 11.95 | 1440.0 |
| 2005-07-19 | DIV | ETF | 13.95 | 13.95 | 13.78 | 13.82 | 22800.0 |
| 2005-07-19 | DRIV | ETF | 35.28 | 36.51 | 35.25 | 36.38 | 892843.0 |
| 2005-07-19 | DSI | ETF | 5.8 | 5.8 | 5.8 | 5.8 | 2400.0 |
| 2005-07-19 | DUSA | ETF | 8.54 | 8.94 | 8.5 | 8.73 | 140037.0 |
| 2005-07-19 | DVY | ETF | 63.49 | 63.56 | 63.28 | 63.5 | 625000.0 |
> showing 50 of 274 rows — these rows as CSV