PREVIEW / etf_daily / 2005-03-07
file: by_date/etf_daily/2005/2005-03-07.parquet size: 14 KB rows: 261
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-03-07 | SPY | ETF | 122.66 | 123.25 | 122.4 | 122.79 | 43442400.0 |
| 2005-03-07 | QQQ | ETF | 37.597 | 38.29 | 37.56 | 38.06 | 94886351.0 |
| 2005-03-07 | IWM | ETF | 64.45 | 64.64 | 64.13 | 64.185 | 13329800.0 |
| 2005-03-07 | DIA | ETF | 109.39 | 109.83 | 109.3 | 109.33 | 4124200.0 |
| 2005-03-07 | GLD | ETF | 43.32 | 43.51 | 43.26 | 43.47 | 1290100.0 |
| 2005-03-07 | TLT | ETF | 90.85 | 90.99 | 90.75 | 90.87 | 889800.0 |
| 2005-03-07 | AAA | ETF | 62.75 | 62.75 | 62.09 | 62.09 | 15700.0 |
| 2005-03-07 | ADRE | ETF | 93.25 | 94.76 | 91.31 | 91.54 | 16744.0 |
| 2005-03-07 | AFK | ETF | 26.3 | 26.32 | 26.22 | 26.32 | 11400.0 |
| 2005-03-07 | AGG | ETF | 102.14 | 102.27 | 101.91 | 102.12 | 203000.0 |
| 2005-03-07 | AIQ | ETF | 59.8 | 60.05 | 57.8 | 58.55 | 26940.0 |
| 2005-03-07 | ARB | ETF | 40.45 | 41.12 | 40.35 | 40.51 | 121100.0 |
| 2005-03-07 | BAB | ETF | 52.77 | 53.29 | 52.69 | 53.1 | 20600.0 |
| 2005-03-07 | BBH | ETF | 45.17 | 45.7533 | 45.0033 | 45.0633 | 1826400.0 |
| 2005-03-07 | BCM | ETF | 57.71 | 58.2 | 57.5 | 58.02 | 13500.0 |
| 2005-03-07 | BIS | ETF | 728.0 | 737.6 | 713.6 | 736.0 | 30.0 |
| 2005-03-07 | BITS | ETF | 10.8 | 11.04 | 10.4 | 10.8 | 14079.0 |
| 2005-03-07 | BKF | ETF | 41.8 | 42.9 | 41.79 | 42.89 | 20800.0 |
| 2005-03-07 | BNE | ETF | 15.86 | 16.0 | 15.8 | 15.97 | 247300.0 |
| 2005-03-07 | BRF | ETF | 15.89 | 15.89 | 15.78 | 15.81 | 4800.0 |
| 2005-03-07 | BTF | ETF | 90.8 | 91.19999999999999 | 90.55 | 91.19999999999999 | 3000.0 |
| 2005-03-07 | CBON | ETF | 26.85 | 27.2 | 26.75 | 27.2 | 22916.0 |
| 2005-03-07 | CDC | ETF | 10.5 | 10.79 | 10.46 | 10.46 | 10600.0 |
| 2005-03-07 | CDL | ETF | 14.52 | 14.7 | 14.4975 | 14.63 | 144300.0 |
| 2005-03-07 | CEF | ETF | 5.53 | 5.56 | 5.52 | 5.52 | 378500.0 |
| 2005-03-07 | CEW | ETF | 26.64 | 26.64 | 26.64 | 26.64 | 600.0 |
| 2005-03-07 | CGW | ETF | 30.5 | 30.75 | 30.5 | 30.5 | 1000.0 |
| 2005-03-07 | CHB | ETF | 10.73 | 10.75 | 10.54 | 10.58 | 570000.0 |
| 2005-03-07 | CHIC | ETF | 12.46 | 12.8 | 12.4 | 12.42 | 201754.0 |
| 2005-03-07 | CHIR | ETF | 37.83 | 38.9499 | 37.7499 | 38.6301 | 1872922.0 |
| 2005-03-07 | CID | ETF | 9.65 | 9.65 | 9.4 | 9.4 | 14600.0 |
| 2005-03-07 | CIL | ETF | 26.31 | 26.65 | 26.3 | 26.65 | 8200.0 |
| 2005-03-07 | CN | ETF | 28.45 | 28.58 | 28.25 | 28.5 | 17900.0 |
| 2005-03-07 | CNXT | ETF | 1.735 | 1.77 | 1.71 | 1.73 | 5185315.0 |
| 2005-03-07 | CPI | ETF | 18.6 | 18.6 | 18.6 | 18.6 | 100.0 |
| 2005-03-07 | CSB | ETF | 34.71 | 36.01 | 34.71 | 35.29 | 25600.0 |
| 2005-03-07 | CSM | ETF | 2.3775 | 2.3775 | 2.3775 | 2.3775 | 2000.0 |
| 2005-03-07 | CTEC | ETF | 55.75 | 56.5 | 55.05 | 55.949999999999996 | 11246.800000000001 |
| 2005-03-07 | CURE | ETF | 0.4775 | 0.4775 | 0.4562 | 0.4562 | 1019816.0 |
| 2005-03-07 | CYA | ETF | 211.0 | 217.2 | 210.8 | 210.8 | 160.0 |
| 2005-03-07 | CYB | ETF | 3.75 | 3.85 | 3.75 | 3.85 | 6900.0 |
| 2005-03-07 | CZA | ETF | 10.39 | 10.4 | 10.38 | 10.39 | 8600.0 |
| 2005-03-07 | DGT | ETF | 66.15 | 66.24 | 66.11 | 66.17 | 5000.0 |
| 2005-03-07 | DIG | ETF | 12.925 | 12.925 | 12.8125 | 12.9125 | 5200.0 |
| 2005-03-07 | DIV | ETF | 13.95 | 14.03 | 13.93 | 14.0 | 31400.0 |
| 2005-03-07 | DJP | ETF | 27.05 | 27.05 | 27.05 | 27.05 | 3000.0 |
| 2005-03-07 | DRIV | ETF | 31.09 | 31.09 | 30.02 | 30.47 | 998290.0 |
| 2005-03-07 | DSI | ETF | 6.06 | 6.06 | 6.035 | 6.035 | 5000.0 |
| 2005-03-07 | DUSA | ETF | 11.8 | 12.2 | 11.76 | 11.9 | 71619.0 |
| 2005-03-07 | DVY | ETF | 62.29 | 62.42 | 62.11 | 62.33 | 578900.0 |
> showing 50 of 261 rows — these rows as CSV