PREVIEW / etf_daily / 2009-08-11
file: by_date/etf_daily/2009/2009-08-11.parquet size: 29 KB rows: 670
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-08-11 | SPY | ETF | 100.54 | 100.61 | 99.46 | 99.73 | 157301000.0 |
| 2009-08-11 | QQQ | ETF | 39.42 | 39.5 | 39.05 | 39.26 | 91922694.0 |
| 2009-08-11 | IWM | ETF | 56.97 | 57.04 | 55.98 | 56.27 | 36077000.0 |
| 2009-08-11 | DIA | ETF | 93.19 | 93.23 | 92.3 | 92.58 | 9305200.0 |
| 2009-08-11 | GLD | ETF | 92.68 | 92.97 | 92.41 | 92.79 | 5029900.0 |
| 2009-08-11 | TLT | ETF | 92.39 | 92.87 | 91.99 | 92.68 | 3677800.0 |
| 2009-08-11 | AAXJ | ETF | 50.4 | 50.4 | 48.71 | 48.9 | 56500.0 |
| 2009-08-11 | ACWI | ETF | 38.12 | 38.12 | 37.69 | 37.84 | 351900.0 |
| 2009-08-11 | ACWX | ETF | 36.84 | 36.84 | 36.48 | 36.6 | 39997.0 |
| 2009-08-11 | ADRE | ETF | 38.66 | 38.66 | 37.87 | 38.1199 | 182917.0 |
| 2009-08-11 | AFK | ETF | 27.25 | 27.59 | 27.25 | 27.35 | 11368.0 |
| 2009-08-11 | AGG | ETF | 102.63 | 102.75 | 102.44 | 102.74 | 741400.0 |
| 2009-08-11 | AGQ | ETF | 87.7 | 88.82 | 86.98 | 88.14 | 49350.0 |
| 2009-08-11 | AGZ | ETF | 107.43 | 107.45 | 106.88 | 107.4 | 14472.0 |
| 2009-08-11 | AIA | ETF | 36.05 | 36.12 | 35.496 | 35.75 | 22330.0 |
| 2009-08-11 | AIQ | ETF | 25.4 | 25.9 | 25.1 | 25.65 | 109385.0 |
| 2009-08-11 | AIS | ETF | 1.03 | 1.06 | 0.881 | 0.96 | 993514.0 |
| 2009-08-11 | AIVI | ETF | 39.0 | 39.0 | 38.34 | 38.58 | 11300.0 |
| 2009-08-11 | AMJ | ETF | 24.86 | 24.86 | 24.2 | 24.36 | 212791.0 |
| 2009-08-11 | AOA | ETF | 27.3 | 27.3 | 27.17 | 27.23 | 6600.0 |
| 2009-08-11 | AOK | ETF | 26.33 | 26.38 | 26.24 | 26.3035 | 3523.0 |
| 2009-08-11 | AOM | ETF | 26.73 | 27.29 | 26.688 | 26.8 | 4071.0 |
| 2009-08-11 | AOR | ETF | 26.95 | 27.01 | 26.95 | 27.0 | 1025.0 |
| 2009-08-11 | ARB | ETF | 16.34 | 16.44 | 16.05 | 16.23 | 150186.0 |
| 2009-08-11 | BAL | ETF | 32.75 | 33.15 | 32.43 | 33.15 | 4088.0 |
| 2009-08-11 | BBH | ETF | 33.1367 | 33.5733 | 32.86 | 33.5733 | 689400.0 |
| 2009-08-11 | BIL | ETF | 91.72 | 91.72 | 91.7 | 91.7 | 88950.0 |
| 2009-08-11 | BITS | ETF | 22.08 | 22.08 | 21.6 | 21.76 | 2080.0 |
| 2009-08-11 | BIV | ETF | 78.05 | 78.22 | 77.71 | 78.19 | 94400.0 |
| 2009-08-11 | BJK | ETF | 23.0 | 23.25 | 22.66 | 23.25 | 24100.0 |
| 2009-08-11 | BKF | ETF | 39.02 | 39.04 | 38.13 | 38.51 | 164427.0 |
| 2009-08-11 | BLV | ETF | 75.86 | 76.26 | 75.58 | 76.23 | 36100.0 |
| 2009-08-11 | BMVP | ETF | 11.61 | 11.61 | 11.52 | 11.53 | 17028.0 |
| 2009-08-11 | BND | ETF | 77.97 | 78.02 | 77.77 | 77.97 | 444600.0 |
| 2009-08-11 | BNE | ETF | 6.03 | 6.05 | 5.92 | 5.95 | 762900.0 |
| 2009-08-11 | BOSS | ETF | 18.79 | 20.31 | 18.79 | 20.31 | 500.0 |
| 2009-08-11 | BRF | ETF | 35.51 | 35.64 | 34.96 | 35.254 | 224194.0 |
| 2009-08-11 | BSV | ETF | 79.25 | 79.27 | 79.02 | 79.07 | 241800.0 |
| 2009-08-11 | BTF | ETF | 54.5 | 57.0 | 54.5 | 56.65 | 10533.6 |
| 2009-08-11 | BWX | ETF | 27.66 | 27.8 | 27.6183 | 27.695 | 384090.0 |
| 2009-08-11 | BWZ | ETF | 35.5 | 35.5499 | 35.4782 | 35.532 | 3619.0 |
| 2009-08-11 | BZQ | ETF | 7153.6 | 7227.2 | 7049.6 | 7049.6 | 36.25 |
| 2009-08-11 | CBON | ETF | 1.14 | 1.14 | 1.02 | 1.07 | 47099.0 |
| 2009-08-11 | CEF | ETF | 11.7 | 11.9 | 11.7 | 11.88 | 1099800.0 |
| 2009-08-11 | CEW | ETF | 21.16 | 21.18 | 21.04 | 21.1 | 31736.0 |
| 2009-08-11 | CGO | ETF | 12.97 | 13.1 | 12.9001 | 12.9701 | 33523.0 |
| 2009-08-11 | CGW | ETF | 16.3 | 16.3 | 16.06 | 16.25 | 46485.0 |
| 2009-08-11 | CHB | ETF | 0.51 | 0.52 | 0.48 | 0.5 | 619525.0 |
| 2009-08-11 | CHI | ETF | 11.34 | 11.42 | 11.26 | 11.42 | 142264.0 |
| 2009-08-11 | CHIC | ETF | 15.19 | 15.39 | 14.59 | 14.75 | 174510.0 |
> showing 50 of 670 rows — these rows as CSV