PREVIEW / etf_daily / 2005-10-06
file: by_date/etf_daily/2005/2005-10-06.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-06 | SPY | ETF | 119.78 | 120.26 | 118.17 | 119.2 | 140941800.0 |
| 2005-10-06 | QQQ | ETF | 38.73 | 38.86 | 37.92 | 38.25 | 162273346.0 |
| 2005-10-06 | IWM | ETF | 64.09 | 64.53 | 62.86 | 63.53 | 59096500.0 |
| 2005-10-06 | DIA | ETF | 103.34 | 103.71 | 102.19 | 102.9 | 11180100.0 |
| 2005-10-06 | GLD | ETF | 46.62 | 47.26 | 46.62 | 47.21 | 2009500.0 |
| 2005-10-06 | TLT | ETF | 91.7 | 91.74 | 91.44 | 91.47 | 340000.0 |
| 2005-10-06 | AAA | ETF | 56.47 | 56.7 | 56.0 | 56.0 | 7600.0 |
| 2005-10-06 | ADRE | ETF | 104.25 | 104.74 | 98.0 | 101.8299 | 73964.0 |
| 2005-10-06 | AFK | ETF | 25.46 | 25.64 | 25.45 | 25.45 | 7000.0 |
| 2005-10-06 | AGG | ETF | 101.22 | 101.22 | 100.95 | 101.1 | 129500.0 |
| 2005-10-06 | AIQ | ETF | 40.45 | 40.75 | 37.35 | 37.5 | 53080.0 |
| 2005-10-06 | AIS | ETF | 0.93 | 0.95 | 0.86 | 0.86 | 439800.0 |
| 2005-10-06 | ARB | ETF | 37.91 | 38.46 | 37.68 | 38.19 | 161100.0 |
| 2005-10-06 | BAB | ETF | 53.99 | 55.2 | 53.66 | 54.97 | 114300.0 |
| 2005-10-06 | BBC | ETF | 6.62 | 6.62 | 6.35 | 6.6 | 32400.0 |
| 2005-10-06 | BBH | ETF | 62.5233 | 62.5233 | 60.1733 | 60.95 | 4414500.0 |
| 2005-10-06 | BCM | ETF | 60.65 | 60.81 | 60.33 | 60.67 | 22800.0 |
| 2005-10-06 | BIS | ETF | 664.0 | 664.0 | 614.4 | 627.2 | 82.0 |
| 2005-10-06 | BITS | ETF | 11.076 | 11.44 | 10.12 | 10.16 | 5938.0 |
| 2005-10-06 | BKF | ETF | 28.72 | 28.75 | 28.42 | 28.42 | 40500.0 |
| 2005-10-06 | BNE | ETF | 14.0 | 14.11 | 13.89 | 13.96 | 163200.0 |
| 2005-10-06 | BRF | ETF | 15.55 | 15.55 | 15.44 | 15.55 | 5200.0 |
| 2005-10-06 | BTF | ETF | 85.8 | 85.89999999999999 | 85.1 | 85.1 | 3400.0 |
| 2005-10-06 | CBON | ETF | 33.0 | 33.52 | 32.4999 | 32.91 | 26327.0 |
| 2005-10-06 | CDC | ETF | 3.76 | 3.9499 | 3.76 | 3.9499 | 1800.0 |
| 2005-10-06 | CDL | ETF | 13.59 | 14.16 | 13.59 | 13.84 | 2620500.0 |
| 2005-10-06 | CEF | ETF | 5.59 | 5.73 | 5.59 | 5.7 | 517900.0 |
| 2005-10-06 | CHB | ETF | 13.65 | 13.84 | 12.84 | 13.11 | 773200.0 |
| 2005-10-06 | CHI | ETF | 20.0 | 20.0 | 19.9 | 19.95 | 72000.0 |
| 2005-10-06 | CHIC | ETF | 15.39 | 16.26 | 15.32 | 15.94 | 933078.0 |
| 2005-10-06 | CHIR | ETF | 43.35 | 43.5501 | 42.9801 | 43.2699 | 1644721.0 |
| 2005-10-06 | CHY | ETF | 16.21 | 16.29 | 16.12 | 16.21 | 73600.0 |
| 2005-10-06 | CIL | ETF | 26.0 | 26.0 | 26.0 | 26.0 | 300.0 |
| 2005-10-06 | CN | ETF | 33.11 | 33.68 | 33.1 | 33.12 | 16800.0 |
| 2005-10-06 | CNXT | ETF | 1.89 | 1.9 | 1.79 | 1.86 | 9882558.0 |
| 2005-10-06 | COMB | ETF | 8.16 | 8.16 | 7.9 | 8.16 | 2164.0 |
| 2005-10-06 | CPST | ETF | 3.55 | 3.63 | 3.21 | 3.29 | 4323983.0 |
| 2005-10-06 | CSB | ETF | 29.65 | 29.95 | 29.6 | 29.79 | 7700.0 |
| 2005-10-06 | CSQ | ETF | 13.84 | 13.84 | 13.6 | 13.65 | 212300.0 |
| 2005-10-06 | CTEC | ETF | 49.3 | 50.0 | 47.8 | 48.550000000000004 | 9195.6 |
| 2005-10-06 | CURE | ETF | 0.0988 | 0.105 | 0.0963 | 0.1013 | 4278032.0 |
| 2005-10-06 | CYA | ETF | 71.0 | 73.798 | 70.2 | 73.798 | 190.0 |
| 2005-10-06 | CYB | ETF | 3.4 | 3.4499 | 3.28 | 3.41 | 20100.0 |
| 2005-10-06 | DGT | ETF | 63.85 | 64.05 | 63.33 | 63.33 | 1500.0 |
| 2005-10-06 | DIG | ETF | 14.425 | 14.6625 | 14.425 | 14.6625 | 4480.0 |
| 2005-10-06 | DIV | ETF | 13.03 | 13.09 | 12.7 | 12.8 | 27300.0 |
| 2005-10-06 | DRIV | ETF | 32.25 | 32.8 | 31.6 | 31.86 | 911470.0 |
| 2005-10-06 | DSI | ETF | 5.655 | 5.655 | 5.645 | 5.645 | 3400.0 |
| 2005-10-06 | DUSA | ETF | 10.41 | 10.51 | 10.24 | 10.26 | 111430.0 |
| 2005-10-06 | DVY | ETF | 60.75 | 61.04 | 59.93 | 60.48 | 1032000.0 |
> showing 50 of 280 rows — these rows as CSV