PREVIEW / etf_daily / 2005-09-08
file: by_date/etf_daily/2005/2005-09-08.parquet size: 15 KB rows: 273
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-09-08 | SPY | ETF | 123.66 | 124.0 | 123.31 | 123.5 | 39068700.0 |
| 2005-09-08 | QQQ | ETF | 39.29 | 39.57 | 39.27 | 39.4 | 73544572.0 |
| 2005-09-08 | IWM | ETF | 67.19 | 67.3 | 66.74 | 66.98 | 13027800.0 |
| 2005-09-08 | DIA | ETF | 105.98 | 106.29 | 105.67 | 105.91 | 5879000.0 |
| 2005-09-08 | GLD | ETF | 44.72 | 44.78 | 44.47 | 44.6 | 1061200.0 |
| 2005-09-08 | TLT | ETF | 93.89 | 93.98 | 93.6 | 93.7 | 373100.0 |
| 2005-09-08 | AAA | ETF | 58.41 | 58.41 | 57.98 | 58.0 | 62800.0 |
| 2005-09-08 | ADRE | ETF | 102.9 | 103.1 | 102.65 | 102.65 | 6932.0 |
| 2005-09-08 | AFK | ETF | 25.88 | 25.99 | 25.88 | 25.9 | 22200.0 |
| 2005-09-08 | AGG | ETF | 102.3 | 102.32 | 102.08 | 102.22 | 130900.0 |
| 2005-09-08 | AIQ | ETF | 44.35 | 44.5 | 43.8 | 44.1 | 13680.0 |
| 2005-09-08 | AIS | ETF | 0.91 | 0.92 | 0.88 | 0.9 | 75700.0 |
| 2005-09-08 | ARB | ETF | 42.33 | 42.33 | 41.64 | 42.07 | 126300.0 |
| 2005-09-08 | BAB | ETF | 53.02 | 53.13 | 52.75 | 52.8 | 14000.0 |
| 2005-09-08 | BBC | ETF | 6.95 | 7.01 | 6.86 | 6.86 | 22200.0 |
| 2005-09-08 | BBH | ETF | 65.8867 | 66.7567 | 65.4533 | 65.73 | 1626600.0 |
| 2005-09-08 | BCM | ETF | 60.16 | 60.35 | 60.01 | 60.2 | 267200.0 |
| 2005-09-08 | BITS | ETF | 12.4 | 12.72 | 12.12 | 12.52 | 2644.0 |
| 2005-09-08 | BKF | ETF | 33.5 | 33.9 | 32.99 | 33.1 | 25800.0 |
| 2005-09-08 | BNE | ETF | 14.7 | 14.81 | 14.5 | 14.6 | 49600.0 |
| 2005-09-08 | BRF | ETF | 15.46 | 15.53 | 15.46 | 15.49 | 3700.0 |
| 2005-09-08 | BTF | ETF | 86.1 | 86.1 | 85.35 | 85.55 | 2440.0 |
| 2005-09-08 | CBON | ETF | 33.18 | 33.18 | 32.0 | 32.43 | 2380.0 |
| 2005-09-08 | CDC | ETF | 3.4 | 3.5 | 3.4 | 3.5 | 1400.0 |
| 2005-09-08 | CDL | ETF | 13.11 | 13.12 | 12.95 | 13.01 | 319100.0 |
| 2005-09-08 | CEF | ETF | 5.43 | 5.44 | 5.36 | 5.37 | 402200.0 |
| 2005-09-08 | CEW | ETF | 25.75 | 25.76 | 25.75 | 25.76 | 1000.0 |
| 2005-09-08 | CHB | ETF | 13.1 | 13.16 | 12.66 | 13.0 | 663000.0 |
| 2005-09-08 | CHI | ETF | 20.7 | 20.7 | 20.47 | 20.64 | 65900.0 |
| 2005-09-08 | CHIC | ETF | 14.43 | 14.81 | 14.32 | 14.57 | 429086.0 |
| 2005-09-08 | CHIR | ETF | 44.0199 | 44.3199 | 43.98 | 44.1699 | 1437999.0 |
| 2005-09-08 | CHY | ETF | 16.55 | 16.7 | 16.55 | 16.67 | 88400.0 |
| 2005-09-08 | CIL | ETF | 25.95 | 25.95 | 25.95 | 25.95 | 100.0 |
| 2005-09-08 | CIZ | ETF | 22.65 | 22.65 | 22.65 | 22.65 | 200.0 |
| 2005-09-08 | CN | ETF | 33.5 | 33.5 | 33.36 | 33.45 | 9100.0 |
| 2005-09-08 | CNXT | ETF | 1.7 | 1.76 | 1.67 | 1.69 | 4998030.0 |
| 2005-09-08 | CPST | ETF | 4.85 | 5.01 | 4.75 | 4.93 | 7294797.0 |
| 2005-09-08 | CSB | ETF | 31.46 | 31.51 | 31.3 | 31.4 | 13000.0 |
| 2005-09-08 | CSM | ETF | 2.43 | 2.43 | 2.43 | 2.43 | 4800.0 |
| 2005-09-08 | CSQ | ETF | 14.28 | 14.43 | 14.27 | 14.41 | 300800.0 |
| 2005-09-08 | CTEC | ETF | 48.49999999999999 | 49.565 | 48.49999999999999 | 49.55 | 3983.6000000000004 |
| 2005-09-08 | CURE | ETF | 0.2888 | 0.2933 | 0.2825 | 0.2825 | 123856.0 |
| 2005-09-08 | CYA | ETF | 62.0 | 63.8 | 62.0 | 63.6 | 100.0 |
| 2005-09-08 | CYB | ETF | 3.63 | 3.67 | 3.63 | 3.67 | 4200.0 |
| 2005-09-08 | DGT | ETF | 65.54 | 65.54 | 65.37 | 65.47 | 1200.0 |
| 2005-09-08 | DIG | ETF | 13.425 | 13.5625 | 13.425 | 13.5625 | 4000.0 |
| 2005-09-08 | DIV | ETF | 13.75 | 13.83 | 13.63 | 13.76 | 14400.0 |
| 2005-09-08 | DRIV | ETF | 39.62 | 39.99 | 39.45 | 39.71 | 399378.0 |
| 2005-09-08 | DUSA | ETF | 10.53 | 10.59 | 10.28 | 10.36 | 76066.0 |
| 2005-09-08 | DVY | ETF | 63.51 | 63.7 | 63.36 | 63.49 | 257600.0 |
> showing 50 of 273 rows — these rows as CSV