PREVIEW / etf_daily / 2005-11-28
file: by_date/etf_daily/2005/2005-11-28.parquet size: 16 KB rows: 295
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-28 | SPY | ETF | 127.25 | 127.27 | 126.04 | 126.23 | 54498500.0 |
| 2005-11-28 | QQQ | ETF | 41.97 | 42.0 | 41.5 | 41.54 | 74716175.0 |
| 2005-11-28 | IWM | ETF | 68.12 | 68.15 | 66.81 | 67.06 | 24596300.0 |
| 2005-11-28 | DIA | ETF | 109.42 | 109.49 | 108.76 | 109.04 | 7201700.0 |
| 2005-11-28 | GLD | ETF | 49.3 | 49.75 | 49.26 | 49.74 | 2192000.0 |
| 2005-11-28 | TLT | ETF | 90.52 | 91.14 | 90.52 | 90.96 | 883400.0 |
| 2005-11-28 | AAA | ETF | 52.9 | 53.34 | 52.75 | 53.24 | 6600.0 |
| 2005-11-28 | ADRE | ETF | 113.0 | 113.3799 | 111.05 | 111.06 | 28792.0 |
| 2005-11-28 | AFK | ETF | 25.56 | 25.56 | 25.4 | 25.4 | 1600.0 |
| 2005-11-28 | AGG | ETF | 100.5 | 100.85 | 100.49 | 100.57 | 211400.0 |
| 2005-11-28 | AIQ | ETF | 27.4 | 28.5 | 26.85 | 27.65 | 10380.0 |
| 2005-11-28 | AIS | ETF | 1.25 | 1.25 | 1.17 | 1.24 | 175700.0 |
| 2005-11-28 | AOM | ETF | 3.5 | 3.5 | 3.38 | 3.42 | 21700.0 |
| 2005-11-28 | ARB | ETF | 38.94 | 39.01 | 38.3 | 38.5 | 159500.0 |
| 2005-11-28 | BAB | ETF | 53.74 | 53.87 | 53.25 | 53.5 | 42700.0 |
| 2005-11-28 | BBC | ETF | 10.08 | 10.8 | 9.99 | 10.34 | 452200.0 |
| 2005-11-28 | BBH | ETF | 69.6 | 69.6 | 68.2433 | 68.4367 | 2273100.0 |
| 2005-11-28 | BCM | ETF | 65.6 | 66.05 | 64.85 | 65.14 | 28200.0 |
| 2005-11-28 | BITS | ETF | 13.76 | 13.76 | 13.0 | 13.37 | 6852.0 |
| 2005-11-28 | BKF | ETF | 22.65 | 22.65 | 21.96 | 22.06 | 68800.0 |
| 2005-11-28 | BNE | ETF | 15.57 | 15.63 | 14.85 | 14.89 | 130000.0 |
| 2005-11-28 | BOSS | ETF | 30.76 | 30.97 | 30.76 | 30.97 | 100.0 |
| 2005-11-28 | BRF | ETF | 15.09 | 15.12 | 15.09 | 15.11 | 4400.0 |
| 2005-11-28 | BTF | ETF | 88.39999999999999 | 88.39999999999999 | 88.39999999999999 | 88.39999999999999 | 1020.0 |
| 2005-11-28 | CBON | ETF | 32.65 | 32.931 | 32.5 | 32.5 | 2500.0 |
| 2005-11-28 | CDL | ETF | 13.75 | 13.75 | 13.43 | 13.46 | 222400.0 |
| 2005-11-28 | CEF | ETF | 6.14 | 6.28 | 6.14 | 6.28 | 544400.0 |
| 2005-11-28 | CEW | ETF | 25.82 | 25.82 | 25.81 | 25.81 | 700.0 |
| 2005-11-28 | CGO | ETF | 13.3 | 13.65 | 13.25 | 13.43 | 45100.0 |
| 2005-11-28 | CHB | ETF | 14.66 | 14.71 | 14.3902 | 14.44 | 529800.0 |
| 2005-11-28 | CHI | ETF | 19.95 | 20.09 | 19.901 | 20.0699 | 74100.0 |
| 2005-11-28 | CHIC | ETF | 17.5 | 17.88 | 17.5 | 17.67 | 266253.0 |
| 2005-11-28 | CHIR | ETF | 44.37 | 44.37 | 44.1999 | 44.22 | 902371.0 |
| 2005-11-28 | CHY | ETF | 15.48 | 15.6299 | 15.48 | 15.61 | 104600.0 |
| 2005-11-28 | CIL | ETF | 25.05 | 25.14 | 25.05 | 25.14 | 1100.0 |
| 2005-11-28 | CIZ | ETF | 21.6 | 21.6 | 21.6 | 21.6 | 300.0 |
| 2005-11-28 | CN | ETF | 32.5 | 32.62 | 32.33 | 32.45 | 11100.0 |
| 2005-11-28 | CNXT | ETF | 2.49 | 2.53 | 2.45 | 2.5 | 15407500.0 |
| 2005-11-28 | COMB | ETF | 8.65 | 8.65 | 8.65 | 8.65 | 600.0 |
| 2005-11-28 | CPI | ETF | 26.3 | 26.3 | 26.3 | 26.3 | 700.0 |
| 2005-11-28 | CPST | ETF | 3.76 | 3.81 | 3.55 | 3.55 | 5647953.0 |
| 2005-11-28 | CSA | ETF | 16.85 | 16.99 | 16.75 | 16.91 | 113800.0 |
| 2005-11-28 | CSB | ETF | 29.51 | 29.55 | 29.25 | 29.28 | 20800.0 |
| 2005-11-28 | CSM | ETF | 2.445 | 2.445 | 2.445 | 2.445 | 800.0 |
| 2005-11-28 | CSQ | ETF | 13.2 | 13.28 | 13.11 | 13.16 | 448200.0 |
| 2005-11-28 | CTEC | ETF | 46.050000000000004 | 47.5 | 46.050000000000004 | 46.3 | 7301.200000000001 |
| 2005-11-28 | CURE | ETF | 0.0875 | 0.09 | 0.085 | 0.0875 | 1413600.0 |
| 2005-11-28 | CYB | ETF | 3.72 | 3.74 | 3.72 | 3.74 | 1100.0 |
| 2005-11-28 | DGT | ETF | 65.8 | 65.82 | 65.54 | 65.54 | 7000.0 |
| 2005-11-28 | DIG | ETF | 15.0375 | 15.2 | 15.0125 | 15.0125 | 1920.0 |
> showing 50 of 295 rows — these rows as CSV