PREVIEW / etf_daily / 2009-11-06
file: by_date/etf_daily/2009/2009-11-06.parquet size: 30 KB rows: 674
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-11-06 | SPY | ETF | 106.26 | 107.4 | 106.05 | 107.13 | 170954100.0 |
| 2009-11-06 | QQQ | ETF | 42.16 | 42.65 | 42.08 | 42.6 | 96312206.0 |
| 2009-11-06 | IWM | ETF | 57.43 | 58.58 | 57.27 | 58.08 | 56216700.0 |
| 2009-11-06 | DIA | ETF | 99.65 | 100.6 | 99.43 | 100.37 | 10786100.0 |
| 2009-11-06 | GLD | ETF | 107.38 | 108.04 | 107.06 | 107.43 | 14789000.0 |
| 2009-11-06 | TLT | ETF | 93.38 | 93.45 | 92.46 | 93.33 | 3381100.0 |
| 2009-11-06 | AAXJ | ETF | 52.99 | 53.46 | 52.82 | 53.25 | 196400.0 |
| 2009-11-06 | ACWI | ETF | 41.06 | 41.36 | 40.89 | 41.28 | 46000.0 |
| 2009-11-06 | ACWX | ETF | 39.8 | 40.1976 | 39.8 | 40.16 | 121718.0 |
| 2009-11-06 | ADRE | ETF | 42.66 | 43.19 | 42.5238 | 42.91 | 109501.0 |
| 2009-11-06 | AFK | ETF | 27.81 | 28.56 | 27.81 | 28.5 | 20624.0 |
| 2009-11-06 | AGG | ETF | 104.24 | 104.46 | 104.18 | 104.37 | 435500.0 |
| 2009-11-06 | AGQ | ETF | 122.88 | 125.76 | 121.1 | 122.42 | 281750.0 |
| 2009-11-06 | AGZ | ETF | 108.38 | 108.66 | 108.2592 | 108.38 | 12060.0 |
| 2009-11-06 | AIA | ETF | 38.22 | 38.55 | 38.14 | 38.395 | 17036.0 |
| 2009-11-06 | AIQ | ETF | 26.1 | 26.65 | 25.7 | 26.55 | 90923.0 |
| 2009-11-06 | AIS | ETF | 1.15 | 1.17 | 1.12 | 1.1374 | 362107.0 |
| 2009-11-06 | AIVI | ETF | 42.19 | 42.96 | 42.19 | 42.78 | 38000.0 |
| 2009-11-06 | AMJ | ETF | 26.2 | 26.54 | 26.1175 | 26.54 | 182075.0 |
| 2009-11-06 | AOA | ETF | 28.89 | 28.99 | 28.84 | 28.91 | 1300.0 |
| 2009-11-06 | AOK | ETF | 27.07 | 27.13 | 27.04 | 27.13 | 3049.0 |
| 2009-11-06 | AOM | ETF | 27.79 | 27.81 | 27.75 | 27.807 | 9546.0 |
| 2009-11-06 | AOR | ETF | 28.35 | 28.41 | 28.3199 | 28.39 | 14835.0 |
| 2009-11-06 | ARB | ETF | 21.85 | 22.52 | 21.75 | 22.5 | 224233.0 |
| 2009-11-06 | BAL | ETF | 34.95 | 34.95 | 34.52 | 34.52 | 6854.0 |
| 2009-11-06 | BBH | ETF | 31.29 | 32.05 | 31.29 | 31.9167 | 564900.0 |
| 2009-11-06 | BIL | ETF | 91.74 | 91.76 | 91.74 | 91.76 | 78850.0 |
| 2009-11-06 | BITS | ETF | 27.52 | 27.67 | 27.432 | 27.56 | 1190.0 |
| 2009-11-06 | BIV | ETF | 79.95 | 80.19 | 79.85 | 79.96 | 63700.0 |
| 2009-11-06 | BJK | ETF | 24.15 | 24.72 | 24.15 | 24.55 | 7300.0 |
| 2009-11-06 | BKF | ETF | 44.69 | 45.09 | 44.42 | 44.75 | 152582.0 |
| 2009-11-06 | BLV | ETF | 76.99 | 77.59 | 76.8 | 77.12 | 25100.0 |
| 2009-11-06 | BMVP | ETF | 11.96 | 12.0716 | 11.96 | 12.0467 | 4768.0 |
| 2009-11-06 | BND | ETF | 79.14 | 79.19 | 78.98 | 79.08 | 413500.0 |
| 2009-11-06 | BNE | ETF | 6.83 | 7.11 | 6.72 | 7.02 | 165034.0 |
| 2009-11-06 | BOSS | ETF | 18.58 | 18.8 | 18.58 | 18.58 | 100.0 |
| 2009-11-06 | BRF | ETF | 44.99 | 45.42 | 44.5 | 45.18 | 438131.0 |
| 2009-11-06 | BSV | ETF | 79.91 | 79.99 | 79.79 | 79.98 | 415400.0 |
| 2009-11-06 | BTF | ETF | 61.55 | 62.5 | 61.55 | 62.05 | 6056.200000000001 |
| 2009-11-06 | BWX | ETF | 29.41 | 29.41 | 29.255 | 29.36 | 221432.0 |
| 2009-11-06 | BWZ | ETF | 37.4 | 37.45 | 37.2901 | 37.36 | 7260.0 |
| 2009-11-06 | BZQ | ETF | 4228.8 | 4228.8 | 4097.6 | 4118.4 | 117.0 |
| 2009-11-06 | CEF | ETF | 14.01 | 14.17 | 13.94 | 14.03 | 817900.0 |
| 2009-11-06 | CEW | ETF | 22.0 | 22.0373 | 21.9 | 21.96 | 72927.0 |
| 2009-11-06 | CGO | ETF | 13.35 | 13.44 | 13.2523 | 13.4099 | 21355.0 |
| 2009-11-06 | CGW | ETF | 17.59 | 17.74 | 17.51 | 17.7 | 68758.0 |
| 2009-11-06 | CHB | ETF | 0.225 | 0.225 | 0.2043 | 0.21 | 719864.0 |
| 2009-11-06 | CHI | ETF | 11.79 | 12.04 | 11.79 | 12.04 | 141894.0 |
| 2009-11-06 | CHW | ETF | 7.56 | 7.56 | 7.4 | 7.53 | 216828.0 |
| 2009-11-06 | CHY | ETF | 11.32 | 11.6 | 11.3 | 11.58 | 179781.0 |
> showing 50 of 674 rows — these rows as CSV