PREVIEW / etf_daily / 2005-11-15
file: by_date/etf_daily/2005/2005-11-15.parquet size: 16 KB rows: 292
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-11-15 | SPY | ETF | 123.55 | 124.09 | 122.86 | 123.24 | 69592500.0 |
| 2005-11-15 | QQQ | ETF | 40.73 | 40.9 | 40.38 | 40.52 | 79543420.0 |
| 2005-11-15 | IWM | ETF | 66.09 | 66.24 | 65.15 | 65.23 | 35159500.0 |
| 2005-11-15 | DIA | ETF | 107.18 | 107.57 | 106.77 | 107.12 | 7408600.0 |
| 2005-11-15 | GLD | ETF | 46.8 | 46.83 | 46.53 | 46.66 | 1325400.0 |
| 2005-11-15 | TLT | ETF | 88.75 | 89.65 | 88.75 | 89.4 | 839800.0 |
| 2005-11-15 | AAA | ETF | 53.92 | 53.92 | 51.84 | 53.01 | 34300.0 |
| 2005-11-15 | ADRE | ETF | 107.74 | 107.99 | 107.0 | 107.0 | 12480.0 |
| 2005-11-15 | AFK | ETF | 25.45 | 25.45 | 25.4 | 25.44 | 16500.0 |
| 2005-11-15 | AGG | ETF | 99.85 | 100.03 | 99.69 | 99.89 | 209100.0 |
| 2005-11-15 | AIQ | ETF | 27.5 | 28.2 | 26.4 | 27.5 | 33300.0 |
| 2005-11-15 | AIS | ETF | 1.25 | 1.25 | 1.16 | 1.16 | 80100.0 |
| 2005-11-15 | AOM | ETF | 3.39 | 3.45 | 3.36 | 3.45 | 4600.0 |
| 2005-11-15 | ARB | ETF | 37.54 | 37.9 | 37.05 | 37.13 | 132400.0 |
| 2005-11-15 | BAB | ETF | 54.88 | 55.33 | 54.73 | 54.73 | 24700.0 |
| 2005-11-15 | BBC | ETF | 6.65 | 6.7 | 6.58 | 6.64 | 32800.0 |
| 2005-11-15 | BBH | ETF | 68.9067 | 69.2467 | 68.1667 | 68.4133 | 1529400.0 |
| 2005-11-15 | BCM | ETF | 62.65 | 62.85 | 62.35 | 62.56 | 73500.0 |
| 2005-11-15 | BITS | ETF | 14.96 | 14.96 | 13.8 | 14.12 | 13242.0 |
| 2005-11-15 | BKF | ETF | 22.75 | 23.4 | 21.83 | 21.94 | 165800.0 |
| 2005-11-15 | BNE | ETF | 15.14 | 15.39 | 14.99 | 15.12 | 119500.0 |
| 2005-11-15 | BRF | ETF | 15.06 | 15.12 | 15.06 | 15.07 | 10500.0 |
| 2005-11-15 | BTF | ETF | 88.39999999999999 | 88.45 | 87.85 | 87.85 | 1100.0 |
| 2005-11-15 | CBON | ETF | 33.15 | 33.2 | 33.0 | 33.12 | 2067.0 |
| 2005-11-15 | CDL | ETF | 13.5 | 13.66 | 13.4018 | 13.53 | 309600.0 |
| 2005-11-15 | CEF | ETF | 5.78 | 5.78 | 5.72 | 5.74 | 163500.0 |
| 2005-11-15 | CGO | ETF | 15.02 | 15.02 | 15.0 | 15.01 | 52000.0 |
| 2005-11-15 | CHB | ETF | 14.75 | 14.86 | 13.99 | 14.3 | 497100.0 |
| 2005-11-15 | CHI | ETF | 20.22 | 20.41 | 20.21 | 20.31 | 90100.0 |
| 2005-11-15 | CHIC | ETF | 17.4 | 17.51 | 16.62 | 16.84 | 468826.0 |
| 2005-11-15 | CHIR | ETF | 44.1 | 44.22 | 44.1 | 44.2101 | 1285767.0 |
| 2005-11-15 | CHY | ETF | 16.0 | 16.03 | 15.87 | 15.95 | 87600.0 |
| 2005-11-15 | CIL | ETF | 26.02 | 26.16 | 26.02 | 26.16 | 2300.0 |
| 2005-11-15 | CN | ETF | 33.6 | 33.689 | 33.506 | 33.65 | 11600.0 |
| 2005-11-15 | CNXT | ETF | 2.2 | 2.21 | 2.08 | 2.08 | 8376480.0 |
| 2005-11-15 | CPST | ETF | 4.06 | 4.5 | 4.0 | 4.29 | 68985829.0 |
| 2005-11-15 | CSA | ETF | 17.06 | 17.06 | 17.0 | 17.0 | 15000.0 |
| 2005-11-15 | CSB | ETF | 28.43 | 28.68 | 28.32 | 28.37 | 10100.0 |
| 2005-11-15 | CSQ | ETF | 13.14 | 13.14 | 12.93 | 12.94 | 428200.0 |
| 2005-11-15 | CTEC | ETF | 45.49999999999999 | 45.49999999999999 | 44.55 | 44.74999999999999 | 6091.200000000001 |
| 2005-11-15 | CURE | ETF | 0.0575 | 0.0675 | 0.0563 | 0.0625 | 2920960.0 |
| 2005-11-15 | CYB | ETF | 3.66 | 3.689 | 3.57 | 3.57 | 9200.0 |
| 2005-11-15 | DGT | ETF | 64.59 | 64.77 | 64.26 | 64.26 | 2000.0 |
| 2005-11-15 | DIV | ETF | 11.94 | 11.94 | 11.84 | 11.86 | 41400.0 |
| 2005-11-15 | DRIV | ETF | 24.44 | 24.9012 | 24.11 | 24.4 | 1139660.0 |
| 2005-11-15 | DSI | ETF | 5.945 | 5.945 | 5.905 | 5.92 | 4400.0 |
| 2005-11-15 | DUSA | ETF | 9.34 | 9.75 | 9.34 | 9.62 | 82372.0 |
| 2005-11-15 | DVY | ETF | 61.6 | 61.78 | 61.19 | 61.32 | 349600.0 |
| 2005-11-15 | EDEN | ETF | 0.56 | 0.56 | 0.53 | 0.54 | 51887.0 |
| 2005-11-15 | EDV | ETF | 25.43 | 25.49 | 25.43 | 25.49 | 7900.0 |
> showing 50 of 292 rows — these rows as CSV