PREVIEW / etf_daily / 2005-12-05
file: by_date/etf_daily/2005/2005-12-05.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-12-05 | SPY | ETF | 126.7 | 126.73 | 126.18 | 126.58 | 59273400.0 |
| 2005-12-05 | QQQ | ETF | 42.05 | 42.06 | 41.629 | 41.8 | 61585506.0 |
| 2005-12-05 | IWM | ETF | 68.71 | 68.76 | 67.92 | 68.33 | 25918100.0 |
| 2005-12-05 | DIA | ETF | 108.59 | 108.76 | 108.14 | 108.39 | 4607400.0 |
| 2005-12-05 | GLD | ETF | 50.43 | 50.8 | 50.29 | 50.78 | 1847500.0 |
| 2005-12-05 | TLT | ETF | 89.35 | 89.35 | 88.85 | 89.1 | 431100.0 |
| 2005-12-05 | AAA | ETF | 53.65 | 53.72 | 53.36 | 53.68 | 3800.0 |
| 2005-12-05 | ADRE | ETF | 115.39 | 115.39 | 113.844 | 114.2475 | 41488.0 |
| 2005-12-05 | AFK | ETF | 25.55 | 25.58 | 25.45 | 25.45 | 1200.0 |
| 2005-12-05 | AGG | ETF | 99.8 | 99.86 | 99.36 | 99.75 | 308600.0 |
| 2005-12-05 | AIQ | ETF | 28.7 | 29.4 | 27.3 | 27.65 | 15320.0 |
| 2005-12-05 | AIS | ETF | 1.2 | 1.33 | 1.18 | 1.31 | 197500.0 |
| 2005-12-05 | AOM | ETF | 3.47 | 3.47 | 3.35 | 3.41 | 5600.0 |
| 2005-12-05 | ARB | ETF | 39.6 | 39.65 | 38.87 | 39.16 | 134600.0 |
| 2005-12-05 | BAB | ETF | 56.86 | 56.94 | 55.78 | 56.04 | 28500.0 |
| 2005-12-05 | BBC | ETF | 10.1 | 10.72 | 10.05 | 10.7 | 341900.0 |
| 2005-12-05 | BBH | ETF | 69.0133 | 69.77 | 68.6967 | 69.7167 | 1056600.0 |
| 2005-12-05 | BCM | ETF | 65.29 | 65.76 | 65.2 | 65.53 | 18200.0 |
| 2005-12-05 | BITS | ETF | 13.28 | 13.64 | 13.16 | 13.64 | 3178.0 |
| 2005-12-05 | BKF | ETF | 21.5 | 21.72 | 21.01 | 21.15 | 42600.0 |
| 2005-12-05 | BNE | ETF | 15.24 | 15.3 | 14.91 | 15.21 | 60100.0 |
| 2005-12-05 | BOSS | ETF | 30.74 | 30.74 | 30.74 | 30.74 | 200.0 |
| 2005-12-05 | BRF | ETF | 15.14 | 15.29 | 15.14 | 15.27 | 5000.0 |
| 2005-12-05 | BTF | ETF | 88.35000000000001 | 88.75 | 88.24999999999999 | 88.69999999999999 | 3380.0 |
| 2005-12-05 | CBON | ETF | 31.38 | 31.45 | 31.0 | 31.25 | 17530.0 |
| 2005-12-05 | CDL | ETF | 13.75 | 13.75 | 13.5 | 13.65 | 545400.0 |
| 2005-12-05 | CEF | ETF | 6.25 | 6.31 | 6.22 | 6.3 | 315900.0 |
| 2005-12-05 | CEW | ETF | 26.13 | 26.13 | 26.0 | 26.1 | 2700.0 |
| 2005-12-05 | CGO | ETF | 13.3 | 13.45 | 13.3 | 13.36 | 32600.0 |
| 2005-12-05 | CHB | ETF | 15.07 | 15.08 | 14.45 | 14.69 | 324500.0 |
| 2005-12-05 | CHI | ETF | 20.55 | 20.64 | 20.4 | 20.56 | 117100.0 |
| 2005-12-05 | CHIC | ETF | 18.92 | 20.01 | 18.9 | 19.33 | 888144.0 |
| 2005-12-05 | CHIR | ETF | 44.28 | 44.4201 | 44.2599 | 44.34 | 886215.0 |
| 2005-12-05 | CHY | ETF | 15.9 | 15.99 | 15.84 | 15.99 | 100500.0 |
| 2005-12-05 | CIL | ETF | 25.2 | 25.2 | 25.2 | 25.2 | 100.0 |
| 2005-12-05 | CN | ETF | 31.8 | 32.0 | 31.46 | 31.55 | 18800.0 |
| 2005-12-05 | CNXT | ETF | 2.7 | 2.7101 | 2.6 | 2.63 | 13407504.0 |
| 2005-12-05 | CPI | ETF | 27.45 | 27.45 | 27.45 | 27.45 | 800.0 |
| 2005-12-05 | CPST | ETF | 3.37 | 3.54 | 3.32 | 3.48 | 4694629.0 |
| 2005-12-05 | CSA | ETF | 16.7 | 16.74 | 16.61 | 16.61 | 31600.0 |
| 2005-12-05 | CSB | ETF | 29.89 | 30.06 | 29.84 | 29.9 | 26000.0 |
| 2005-12-05 | CSQ | ETF | 13.16 | 13.23 | 13.06 | 13.1 | 416400.0 |
| 2005-12-05 | CTEC | ETF | 49.45 | 52.15 | 49.45 | 51.95 | 30370.0 |
| 2005-12-05 | CURE | ETF | 0.085 | 0.095 | 0.025 | 0.025 | 25207576.0 |
| 2005-12-05 | CYB | ETF | 3.61 | 3.62 | 3.61 | 3.62 | 2800.0 |
| 2005-12-05 | DGT | ETF | 65.9 | 65.9 | 65.77 | 65.82 | 2000.0 |
| 2005-12-05 | DIG | ETF | 14.9375 | 15.1125 | 14.9375 | 15.0125 | 9360.0 |
| 2005-12-05 | DIV | ETF | 12.0 | 12.02 | 11.96 | 12.02 | 26000.0 |
| 2005-12-05 | DRIV | ETF | 29.45 | 29.7 | 28.613 | 29.1 | 2201359.0 |
| 2005-12-05 | DSI | ETF | 6.04 | 6.045 | 6.0 | 6.0 | 800.0 |
> showing 50 of 292 rows — these rows as CSV