PREVIEW / etf_daily / 2009-06-11
file: by_date/etf_daily/2009/2009-06-11.parquet size: 29 KB rows: 653
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-11 | SPY | ETF | 94.58 | 96.11 | 94.56 | 94.82 | 275414200.0 |
| 2009-06-11 | QQQ | ETF | 36.76 | 37.23 | 36.75 | 36.82 | 147909735.0 |
| 2009-06-11 | IWM | ETF | 52.65 | 53.46 | 52.58 | 52.62 | 62963200.0 |
| 2009-06-11 | DIA | ETF | 87.86 | 89.02 | 87.8 | 87.86 | 21696400.0 |
| 2009-06-11 | GLD | ETF | 93.13 | 94.53 | 93.0 | 93.7 | 14777600.0 |
| 2009-06-11 | TLT | ETF | 87.76 | 89.52 | 87.69 | 89.17 | 10692800.0 |
| 2009-06-11 | AAXJ | ETF | 46.16 | 46.88 | 45.89 | 46.48 | 1284200.0 |
| 2009-06-11 | ACWI | ETF | 36.05 | 36.66 | 36.02 | 36.27 | 2331700.0 |
| 2009-06-11 | ACWX | ETF | 35.21 | 35.82 | 35.21 | 35.47 | 21908.0 |
| 2009-06-11 | ADRE | ETF | 36.64 | 37.65 | 36.64 | 37.31 | 113850.0 |
| 2009-06-11 | AFK | ETF | 27.95 | 28.15 | 27.9 | 27.923 | 15458.0 |
| 2009-06-11 | AGG | ETF | 99.9 | 100.67 | 99.56 | 100.32 | 481900.0 |
| 2009-06-11 | AGQ | ETF | 100.5 | 106.96 | 100.5 | 104.44 | 118550.0 |
| 2009-06-11 | AGZ | ETF | 106.26 | 106.55 | 105.855 | 106.23 | 21339.0 |
| 2009-06-11 | AIA | ETF | 33.32 | 33.91 | 33.32 | 33.61 | 40318.0 |
| 2009-06-11 | AIQ | ETF | 35.95 | 36.4 | 35.65 | 36.05 | 71634.0 |
| 2009-06-11 | AIS | ETF | 0.8 | 0.8 | 0.7498 | 0.77 | 129378.0 |
| 2009-06-11 | AIVI | ETF | 36.37 | 37.09 | 36.37 | 36.81 | 8100.0 |
| 2009-06-11 | AMJ | ETF | 22.9 | 22.96 | 22.706 | 22.88 | 153520.0 |
| 2009-06-11 | AOA | ETF | 25.91 | 26.17 | 25.91 | 26.01 | 7300.0 |
| 2009-06-11 | AOK | ETF | 25.81 | 25.94 | 25.8096 | 25.8899 | 9709.0 |
| 2009-06-11 | AOM | ETF | 25.9899 | 26.15 | 25.86 | 25.9848 | 10979.0 |
| 2009-06-11 | AOR | ETF | 26.12 | 26.18 | 26.01 | 26.06 | 4513.0 |
| 2009-06-11 | ARB | ETF | 19.12 | 19.24 | 18.49 | 18.82 | 419011.0 |
| 2009-06-11 | BAL | ETF | 30.95 | 31.88 | 30.95 | 31.8 | 10172.0 |
| 2009-06-11 | BBH | ETF | 30.51 | 30.79 | 30.29 | 30.35 | 327600.0 |
| 2009-06-11 | BIL | ETF | 91.7 | 91.72 | 91.66 | 91.66 | 98050.0 |
| 2009-06-11 | BITS | ETF | 19.8 | 20.0 | 19.48 | 20.0 | 1864.0 |
| 2009-06-11 | BIV | ETF | 75.43 | 75.7 | 74.87 | 75.61 | 113100.0 |
| 2009-06-11 | BJK | ETF | 21.53 | 22.54 | 21.53 | 22.29 | 10100.0 |
| 2009-06-11 | BKF | ETF | 37.84 | 38.85 | 37.8 | 38.32 | 321185.0 |
| 2009-06-11 | BLV | ETF | 71.15 | 72.25 | 71.12 | 71.76 | 52000.0 |
| 2009-06-11 | BMVP | ETF | 11.2082 | 11.2635 | 11.1433 | 11.1433 | 8564.0 |
| 2009-06-11 | BND | ETF | 75.96 | 76.54 | 75.96 | 76.47 | 379200.0 |
| 2009-06-11 | BNE | ETF | 6.84 | 6.92 | 6.56 | 6.77 | 113014.0 |
| 2009-06-11 | BRF | ETF | 28.75 | 29.26 | 28.0 | 29.0 | 414152.0 |
| 2009-06-11 | BSV | ETF | 78.32 | 78.53 | 78.16 | 78.29 | 287700.0 |
| 2009-06-11 | BTF | ETF | 48.949999999999996 | 49.3 | 48.49999999999999 | 49.05 | 6164.400000000001 |
| 2009-06-11 | BWX | ETF | 26.76 | 27.1975 | 26.655 | 26.925 | 248234.0 |
| 2009-06-11 | BWZ | ETF | 35.07 | 35.11 | 35.02 | 35.11 | 8757.0 |
| 2009-06-11 | CBON | ETF | 1.45 | 1.6 | 1.37 | 1.47 | 13738.0 |
| 2009-06-11 | CEF | ETF | 12.48 | 12.81 | 12.43 | 12.62 | 1161700.0 |
| 2009-06-11 | CEW | ETF | 20.72 | 20.82 | 20.71 | 20.8 | 25578.0 |
| 2009-06-11 | CGO | ETF | 11.74 | 12.1299 | 11.5945 | 11.84 | 61835.0 |
| 2009-06-11 | CGW | ETF | 15.79 | 16.0704 | 15.6 | 15.9448 | 100182.0 |
| 2009-06-11 | CHB | ETF | 0.49 | 0.52 | 0.46 | 0.48 | 412581.0 |
| 2009-06-11 | CHI | ETF | 10.71 | 10.79 | 10.56 | 10.74 | 167578.0 |
| 2009-06-11 | CHIC | ETF | 11.62 | 11.96 | 11.33 | 11.77 | 224905.0 |
| 2009-06-11 | CHW | ETF | 7.07 | 7.22 | 7.0501 | 7.09 | 326091.0 |
| 2009-06-11 | CHY | ETF | 10.59 | 10.79 | 10.5899 | 10.72 | 133071.0 |
> showing 50 of 653 rows — these rows as CSV