PREVIEW / etf_daily / 2010-05-11
file: by_date/etf_daily/2010/2010-05-11.parquet size: 33 KB rows: 761
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-11 | SPY | ETF | 115.07 | 117.36 | 114.91 | 115.83 | 317849800.0 |
| 2010-05-11 | QQQ | ETF | 47.31 | 48.39 | 47.2 | 47.72 | 113196968.0 |
| 2010-05-11 | IWM | ETF | 68.21 | 70.52 | 67.98 | 69.49 | 100027800.0 |
| 2010-05-11 | DIA | ETF | 107.14 | 108.93 | 106.98 | 107.67 | 16440600.0 |
| 2010-05-11 | GLD | ETF | 119.46 | 120.87 | 118.97 | 120.66 | 36731800.0 |
| 2010-05-11 | TLT | ETF | 93.98 | 94.02 | 92.99 | 93.36 | 7729100.0 |
| 2010-05-11 | AAXJ | ETF | 55.74 | 55.74 | 54.41 | 54.87 | 1171800.0 |
| 2010-05-11 | ACWI | ETF | 41.12 | 42.22 | 41.12 | 41.66 | 237800.0 |
| 2010-05-11 | ACWX | ETF | 39.02 | 39.39 | 38.469 | 38.81 | 219922.0 |
| 2010-05-11 | ADRE | ETF | 42.13 | 42.604 | 41.6 | 42.02 | 216445.0 |
| 2010-05-11 | AFK | ETF | 30.5 | 31.035 | 30.5 | 30.6245 | 15945.0 |
| 2010-05-11 | AGG | ETF | 104.8 | 104.8 | 104.45 | 104.79 | 417500.0 |
| 2010-05-11 | AGQ | ETF | 134.94 | 139.48 | 134.58 | 138.42 | 414100.0 |
| 2010-05-11 | AGZ | ETF | 108.71 | 108.71 | 108.31 | 108.42 | 31458.0 |
| 2010-05-11 | AIA | ETF | 38.51 | 39.49 | 38.51 | 39.078 | 14808.0 |
| 2010-05-11 | AIQ | ETF | 26.45 | 27.975 | 26.15 | 27.45 | 31977.0 |
| 2010-05-11 | AIS | ETF | 1.6 | 1.64 | 1.57 | 1.64 | 497559.0 |
| 2010-05-11 | AIVI | ETF | 39.13 | 40.06 | 39.13 | 39.96 | 27100.0 |
| 2010-05-11 | AMJ | ETF | 29.79 | 30.66 | 29.25 | 30.37 | 1107304.0 |
| 2010-05-11 | AOA | ETF | 30.65 | 31.15 | 30.53 | 30.93 | 14000.0 |
| 2010-05-11 | AOK | ETF | 27.86 | 27.95 | 27.842 | 27.8975 | 6134.0 |
| 2010-05-11 | AOM | ETF | 28.4899 | 28.6354 | 28.4899 | 28.542 | 11075.0 |
| 2010-05-11 | AOR | ETF | 29.34 | 29.65 | 29.34 | 29.489 | 23620.0 |
| 2010-05-11 | ARB | ETF | 31.23 | 32.02 | 31.14 | 31.7 | 205266.0 |
| 2010-05-11 | BAB | ETF | 26.07 | 26.125 | 25.9 | 25.97 | 161783.0 |
| 2010-05-11 | BAL | ETF | 38.13 | 38.28 | 38.06 | 38.12 | 1324.0 |
| 2010-05-11 | BALT | ETF | 12.53 | 12.96 | 12.39 | 12.8 | 234015.0 |
| 2010-05-11 | BBH | ETF | 31.2067 | 31.8933 | 30.9967 | 31.5367 | 127200.0 |
| 2010-05-11 | BIB | ETF | 6.2825 | 6.555 | 6.2825 | 6.555 | 34240.0 |
| 2010-05-11 | BICK | ETF | 28.8 | 28.8 | 28.44 | 28.56 | 3080.0 |
| 2010-05-11 | BIL | ETF | 91.7 | 91.72 | 91.7 | 91.72 | 176250.0 |
| 2010-05-11 | BIS | ETF | 10788.8 | 10788.8 | 10497.6 | 10684.8 | 5.0 |
| 2010-05-11 | BITS | ETF | 30.6 | 31.0 | 30.4 | 30.8 | 1556.0 |
| 2010-05-11 | BIV | ETF | 81.38 | 81.42 | 81.06 | 81.37 | 93500.0 |
| 2010-05-11 | BJK | ETF | 25.18 | 25.83 | 25.08 | 25.4 | 22900.0 |
| 2010-05-11 | BKF | ETF | 43.11 | 43.88 | 42.42 | 43.14 | 271515.0 |
| 2010-05-11 | BLV | ETF | 78.59 | 78.82 | 78.22 | 78.58 | 22100.0 |
| 2010-05-11 | BMVP | ETF | 13.01 | 13.25 | 13.0 | 13.08 | 69774.0 |
| 2010-05-11 | BND | ETF | 79.91 | 79.93 | 79.73 | 79.92 | 568700.0 |
| 2010-05-11 | BNE | ETF | 11.19 | 11.21 | 11.19 | 11.2 | 495333.0 |
| 2010-05-11 | BRF | ETF | 43.54 | 44.43 | 43.44 | 43.73 | 294264.0 |
| 2010-05-11 | BSV | ETF | 80.29 | 80.32 | 80.17 | 80.26 | 595200.0 |
| 2010-05-11 | BTF | ETF | 69.05 | 70.6 | 67.64999999999999 | 69.85 | 5225.6 |
| 2010-05-11 | BWX | ETF | 26.905 | 27.225 | 26.85 | 26.955 | 425966.0 |
| 2010-05-11 | BWZ | ETF | 34.25 | 34.37 | 34.25 | 34.299 | 16485.0 |
| 2010-05-11 | BZQ | ETF | 3990.4 | 4020.8 | 3830.4 | 4017.6 | 2871.0 |
| 2010-05-11 | CEF | ETF | 14.9 | 15.27 | 14.87 | 15.25 | 10913700.0 |
| 2010-05-11 | CEW | ETF | 21.9 | 21.97 | 21.84 | 21.94 | 76797.0 |
| 2010-05-11 | CGO | ETF | 13.6 | 13.85 | 13.54 | 13.85 | 22327.0 |
| 2010-05-11 | CGW | ETF | 17.46 | 17.8399 | 17.45 | 17.52 | 100433.0 |
> showing 50 of 761 rows — these rows as CSV