PREVIEW / etf_daily / 2005-10-04
file: by_date/etf_daily/2005/2005-10-04.parquet size: 15 KB rows: 280
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-10-04 | SPY | ETF | 122.79 | 123.03 | 121.16 | 121.22 | 60776300.0 |
| 2005-10-04 | QQQ | ETF | 39.6 | 39.88 | 39.29 | 39.3 | 85379643.0 |
| 2005-10-04 | IWM | ETF | 66.88 | 67.1 | 65.72 | 65.78 | 17037600.0 |
| 2005-10-04 | DIA | ETF | 105.46 | 105.64 | 104.17 | 104.17 | 6459100.0 |
| 2005-10-04 | GLD | ETF | 46.67 | 46.73 | 46.3 | 46.45 | 1764500.0 |
| 2005-10-04 | TLT | ETF | 91.37 | 91.54 | 91.21 | 91.42 | 783200.0 |
| 2005-10-04 | AAA | ETF | 56.58 | 56.99 | 56.21 | 56.21 | 3200.0 |
| 2005-10-04 | ADRE | ETF | 111.19 | 111.19 | 108.51 | 108.59 | 36616.0 |
| 2005-10-04 | AFK | ETF | 25.43 | 25.64 | 25.43 | 25.5 | 3400.0 |
| 2005-10-04 | AGG | ETF | 101.03 | 101.08 | 100.83 | 101.01 | 136500.0 |
| 2005-10-04 | AIQ | ETF | 42.9 | 43.0 | 40.6 | 41.25 | 23900.0 |
| 2005-10-04 | AIS | ETF | 1.02 | 1.04 | 0.98 | 0.98 | 197200.0 |
| 2005-10-04 | ARB | ETF | 40.02 | 40.02 | 38.7 | 39.02 | 191200.0 |
| 2005-10-04 | BAB | ETF | 51.7 | 52.26 | 51.7 | 51.85 | 22200.0 |
| 2005-10-04 | BBC | ETF | 6.9 | 7.0 | 6.7 | 6.72 | 41400.0 |
| 2005-10-04 | BBH | ETF | 64.5 | 65.43 | 64.0667 | 64.13 | 2163300.0 |
| 2005-10-04 | BCM | ETF | 62.0 | 62.06 | 61.21 | 61.42 | 25400.0 |
| 2005-10-04 | BIS | ETF | 656.0 | 656.0 | 656.0 | 656.0 | 1.25 |
| 2005-10-04 | BITS | ETF | 11.28 | 11.32 | 11.0 | 11.2 | 5384.0 |
| 2005-10-04 | BKF | ETF | 31.0 | 31.01 | 29.87 | 30.02 | 22300.0 |
| 2005-10-04 | BNE | ETF | 14.8 | 14.87 | 14.28 | 14.28 | 126900.0 |
| 2005-10-04 | BRF | ETF | 15.44 | 15.45 | 15.35 | 15.36 | 5200.0 |
| 2005-10-04 | BTF | ETF | 86.4 | 86.54999999999998 | 85.74999999999999 | 85.99999999999999 | 9900.0 |
| 2005-10-04 | CBON | ETF | 33.75 | 33.99 | 33.74 | 33.95 | 11786.0 |
| 2005-10-04 | CDC | ETF | 3.8 | 3.8 | 3.8 | 3.8 | 1500.0 |
| 2005-10-04 | CDL | ETF | 14.06 | 14.19 | 13.94 | 13.94 | 168400.0 |
| 2005-10-04 | CEF | ETF | 5.57 | 5.63 | 5.54 | 5.63 | 342000.0 |
| 2005-10-04 | CEW | ETF | 25.9 | 25.9 | 25.9 | 25.9 | 1400.0 |
| 2005-10-04 | CHB | ETF | 14.98 | 15.0 | 14.35 | 14.36 | 752800.0 |
| 2005-10-04 | CHI | ETF | 20.01 | 20.2 | 19.98 | 19.98 | 105900.0 |
| 2005-10-04 | CHIC | ETF | 15.13 | 16.29 | 15.13 | 15.93 | 1268068.0 |
| 2005-10-04 | CHIR | ETF | 43.9899 | 44.0499 | 43.5 | 43.53 | 778067.0 |
| 2005-10-04 | CHY | ETF | 16.43 | 16.55 | 16.35 | 16.43 | 76600.0 |
| 2005-10-04 | CIL | ETF | 25.97 | 26.06 | 25.97 | 26.06 | 700.0 |
| 2005-10-04 | CN | ETF | 35.05 | 35.6 | 35.05 | 35.3 | 7800.0 |
| 2005-10-04 | CNXT | ETF | 1.86 | 1.95 | 1.85 | 1.88 | 13261973.0 |
| 2005-10-04 | CPI | ETF | 23.9 | 24.0 | 23.9 | 24.0 | 300.0 |
| 2005-10-04 | CPST | ETF | 3.98 | 3.98 | 3.62 | 3.68 | 5821542.0 |
| 2005-10-04 | CSB | ETF | 29.65 | 29.79 | 29.45 | 29.45 | 11600.0 |
| 2005-10-04 | CSM | ETF | 2.4375 | 2.4375 | 2.4375 | 2.4375 | 6800.0 |
| 2005-10-04 | CSQ | ETF | 13.97 | 14.0 | 13.9 | 13.94 | 215700.0 |
| 2005-10-04 | CTEC | ETF | 49.55 | 51.699999999999996 | 49.15 | 50.25 | 7397.400000000001 |
| 2005-10-04 | CURE | ETF | 0.115 | 0.1187 | 0.1025 | 0.105 | 4289640.0 |
| 2005-10-04 | CYA | ETF | 71.2 | 74.0 | 71.2 | 74.0 | 665.0 |
| 2005-10-04 | CYB | ETF | 3.69 | 3.74 | 3.5 | 3.5 | 14500.0 |
| 2005-10-04 | DGT | ETF | 64.94 | 64.94 | 64.27 | 64.27 | 2400.0 |
| 2005-10-04 | DIG | ETF | 14.625 | 14.625 | 14.5875 | 14.5875 | 2720.0 |
| 2005-10-04 | DIV | ETF | 13.28 | 13.28 | 13.11 | 13.17 | 40600.0 |
| 2005-10-04 | DRIV | ETF | 35.35 | 35.85 | 34.53 | 34.53 | 881084.0 |
| 2005-10-04 | DUSA | ETF | 10.41 | 10.64 | 10.39 | 10.64 | 35469.0 |
> showing 50 of 280 rows — these rows as CSV