PREVIEW / etf_daily / 2005-05-31
file: by_date/etf_daily/2005/2005-05-31.parquet size: 15 KB rows: 262
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-05-31 | SPY | ETF | 120.08 | 120.17 | 119.4 | 119.48 | 43377200.0 |
| 2005-05-31 | QQQ | ETF | 38.19 | 38.24 | 37.92 | 38.08 | 75294958.0 |
| 2005-05-31 | IWM | ETF | 61.52 | 61.705 | 61.14 | 61.345 | 19278200.0 |
| 2005-05-31 | DIA | ETF | 105.32 | 105.35 | 104.57 | 104.63 | 5593300.0 |
| 2005-05-31 | GLD | ETF | 41.34 | 41.69 | 41.33 | 41.65 | 3198900.0 |
| 2005-05-31 | TLT | ETF | 94.22 | 95.05 | 94.22 | 95.0 | 1979000.0 |
| 2005-05-31 | AAA | ETF | 60.33 | 60.33 | 59.27 | 59.28 | 11200.0 |
| 2005-05-31 | ADRE | ETF | 88.7 | 89.292 | 87.579 | 88.024 | 6908.0 |
| 2005-05-31 | AFK | ETF | 26.04 | 26.41 | 26.04 | 26.34 | 3100.0 |
| 2005-05-31 | AGG | ETF | 102.8 | 102.9 | 102.6 | 102.83 | 65400.0 |
| 2005-05-31 | AIQ | ETF | 53.05 | 53.35 | 49.7 | 50.15 | 53940.0 |
| 2005-05-31 | ARB | ETF | 40.2 | 40.4 | 40.2 | 40.34 | 174900.0 |
| 2005-05-31 | BAB | ETF | 50.08 | 50.2 | 49.84 | 50.13 | 18300.0 |
| 2005-05-31 | BBH | ETF | 56.5133 | 56.5567 | 56.0733 | 56.2567 | 1428900.0 |
| 2005-05-31 | BCM | ETF | 57.71 | 58.54 | 57.71 | 58.23 | 50500.0 |
| 2005-05-31 | BIS | ETF | 660.8 | 660.8 | 660.8 | 660.8 | 1.25 |
| 2005-05-31 | BITS | ETF | 11.48 | 12.0 | 10.8 | 11.04 | 5195.0 |
| 2005-05-31 | BKF | ETF | 37.34 | 37.34 | 36.3 | 36.3 | 30200.0 |
| 2005-05-31 | BNE | ETF | 13.43 | 13.43 | 13.23 | 13.25 | 266700.0 |
| 2005-05-31 | BRF | ETF | 15.49 | 15.49 | 15.42 | 15.42 | 6300.0 |
| 2005-05-31 | BTF | ETF | 86.4 | 86.4 | 85.85000000000001 | 86.19999999999999 | 3380.0 |
| 2005-05-31 | CBON | ETF | 28.74 | 28.74 | 28.32 | 28.46 | 37700.0 |
| 2005-05-31 | CDC | ETF | 8.51 | 8.95 | 8.51 | 8.71 | 6300.0 |
| 2005-05-31 | CDL | ETF | 11.98 | 12.03 | 11.83 | 11.87 | 180600.0 |
| 2005-05-31 | CEF | ETF | 5.23 | 5.36 | 5.2 | 5.29 | 229400.0 |
| 2005-05-31 | CEW | ETF | 26.75 | 26.76 | 26.75 | 26.76 | 1500.0 |
| 2005-05-31 | CGW | ETF | 28.0 | 28.22 | 28.0 | 28.22 | 300.0 |
| 2005-05-31 | CHB | ETF | 9.7 | 9.81 | 9.62 | 9.73 | 478700.0 |
| 2005-05-31 | CHIC | ETF | 11.58 | 12.1 | 11.58 | 11.95 | 301588.0 |
| 2005-05-31 | CHIR | ETF | 38.25 | 38.2599 | 37.5 | 37.5399 | 1170872.0 |
| 2005-05-31 | CIL | ETF | 25.56 | 25.56 | 25.55 | 25.55 | 400.0 |
| 2005-05-31 | CIZ | ETF | 21.45 | 21.5 | 21.45 | 21.5 | 500.0 |
| 2005-05-31 | CN | ETF | 27.55 | 27.55 | 27.05 | 27.2 | 9100.0 |
| 2005-05-31 | CNXT | ETF | 1.415 | 1.44 | 1.38 | 1.43 | 4429103.0 |
| 2005-05-31 | CPI | ETF | 23.08 | 23.08 | 23.08 | 23.08 | 100.0 |
| 2005-05-31 | CSB | ETF | 30.25 | 30.29 | 29.88 | 29.89 | 27000.0 |
| 2005-05-31 | CTEC | ETF | 45.4 | 46.74999999999999 | 45.0 | 45.949999999999996 | 8018.0 |
| 2005-05-31 | CURE | ETF | 0.315 | 0.33 | 0.3125 | 0.3212 | 1127896.0 |
| 2005-05-31 | CYA | ETF | 173.6 | 176.0 | 173.0 | 174.0 | 80.0 |
| 2005-05-31 | CYB | ETF | 3.06 | 3.07 | 3.04 | 3.06 | 5000.0 |
| 2005-05-31 | CZA | ETF | 10.46 | 10.46 | 10.46 | 10.46 | 1100.0 |
| 2005-05-31 | DGT | ETF | 64.4 | 64.4 | 64.4 | 64.4 | 5600.0 |
| 2005-05-31 | DIG | ETF | 11.3125 | 11.375 | 11.3125 | 11.375 | 1040.0 |
| 2005-05-31 | DIV | ETF | 13.65 | 13.65 | 13.55 | 13.59 | 22900.0 |
| 2005-05-31 | DRIV | ETF | 26.56 | 27.74 | 26.35 | 27.52 | 1888045.0 |
| 2005-05-31 | DSI | ETF | 5.98 | 5.98 | 5.98 | 5.98 | 2000.0 |
| 2005-05-31 | DUSA | ETF | 11.66 | 11.68 | 11.12 | 11.19 | 96499.0 |
| 2005-05-31 | DVY | ETF | 61.45 | 61.53 | 61.2 | 61.3 | 409100.0 |
| 2005-05-31 | EDEN | ETF | 0.57 | 0.6 | 0.57 | 0.6 | 14125.0 |
| 2005-05-31 | EDV | ETF | 26.47 | 26.47 | 26.28 | 26.38 | 14200.0 |
> showing 50 of 262 rows — these rows as CSV