PREVIEW / etf_daily / 2009-08-03
file: by_date/etf_daily/2009/2009-08-03.parquet size: 30 KB rows: 671
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-03 | SPY | ETF | 99.85 | 100.53 | 99.31 | 100.44 | 175776900.0 |
| 2009-08-03 | QQQ | ETF | 39.85 | 40.06 | 39.64 | 40.04 | 111722709.0 |
| 2009-08-03 | IWM | ETF | 56.24 | 56.58 | 55.62 | 56.54 | 32392400.0 |
| 2009-08-03 | DIA | ETF | 92.47 | 93.0 | 91.97 | 92.86 | 9843400.0 |
| 2009-08-03 | GLD | ETF | 94.14 | 94.49 | 93.65 | 93.87 | 10007600.0 |
| 2009-08-03 | TLT | ETF | 93.81 | 93.87 | 92.61 | 93.06 | 4029300.0 |
| 2009-08-03 | AAXJ | ETF | 51.26 | 51.69 | 51.05 | 51.6 | 200000.0 |
| 2009-08-03 | ACWI | ETF | 38.43 | 38.69 | 38.21 | 38.64 | 743000.0 |
| 2009-08-03 | ACWX | ETF | 37.45 | 37.8599 | 37.4 | 37.75 | 108094.0 |
| 2009-08-03 | ADRE | ETF | 39.03 | 39.46 | 38.88 | 39.39 | 213189.0 |
| 2009-08-03 | AFK | ETF | 27.51 | 28.42 | 27.51 | 28.33 | 280055.0 |
| 2009-08-03 | AGG | ETF | 102.78 | 102.79 | 102.31 | 102.55 | 716600.0 |
| 2009-08-03 | AGQ | ETF | 89.48 | 90.1 | 87.28 | 87.52 | 123400.0 |
| 2009-08-03 | AGZ | ETF | 107.08 | 107.38 | 106.77 | 107.38 | 20306.0 |
| 2009-08-03 | AIA | ETF | 37.27 | 37.43 | 37.07 | 37.4 | 40207.0 |
| 2009-08-03 | AIQ | ETF | 25.35 | 27.05 | 25.0 | 26.8 | 427123.0 |
| 2009-08-03 | AIS | ETF | 0.88 | 0.9 | 0.85 | 0.89 | 334435.0 |
| 2009-08-03 | AIVI | ETF | 39.24 | 39.82 | 39.24 | 39.74 | 25400.0 |
| 2009-08-03 | AMJ | ETF | 25.13 | 25.45 | 25.13 | 25.4 | 180130.0 |
| 2009-08-03 | AOA | ETF | 27.5 | 34.74 | 26.87 | 27.32 | 130100.0 |
| 2009-08-03 | AOK | ETF | 26.02 | 26.37 | 26.02 | 26.36 | 5546.0 |
| 2009-08-03 | AOM | ETF | 26.71 | 26.75 | 26.71 | 26.7239 | 4978.0 |
| 2009-08-03 | AOR | ETF | 27.25 | 27.25 | 27.058 | 27.15 | 31334.0 |
| 2009-08-03 | ARB | ETF | 16.37 | 16.74 | 16.13 | 16.67 | 165400.0 |
| 2009-08-03 | BAL | ETF | 31.56 | 32.62 | 31.53 | 32.0344 | 10400.0 |
| 2009-08-03 | BBH | ETF | 34.1267 | 34.2433 | 33.7867 | 34.24 | 758700.0 |
| 2009-08-03 | BIL | ETF | 91.7 | 91.72 | 91.68 | 91.7 | 438050.0 |
| 2009-08-03 | BITS | ETF | 22.6 | 22.68 | 22.344 | 22.64 | 1500.0 |
| 2009-08-03 | BIV | ETF | 78.35 | 78.39 | 77.75 | 78.08 | 116300.0 |
| 2009-08-03 | BJK | ETF | 23.33 | 23.76 | 23.08 | 23.55 | 49300.0 |
| 2009-08-03 | BKF | ETF | 39.6 | 40.36 | 39.17 | 40.31 | 378854.0 |
| 2009-08-03 | BLV | ETF | 76.38 | 76.49 | 75.59 | 75.71 | 21300.0 |
| 2009-08-03 | BMVP | ETF | 11.59 | 11.69 | 11.54 | 11.67 | 17273.0 |
| 2009-08-03 | BND | ETF | 78.14 | 78.18 | 77.81 | 77.93 | 596900.0 |
| 2009-08-03 | BNE | ETF | 8.19 | 8.83 | 8.17 | 8.4 | 210261.0 |
| 2009-08-03 | BOSS | ETF | 16.93 | 17.22 | 16.93 | 16.93 | 300.0 |
| 2009-08-03 | BRF | ETF | 34.87 | 35.6 | 34.87 | 35.37 | 262656.0 |
| 2009-08-03 | BSV | ETF | 79.35 | 79.36 | 78.96 | 79.17 | 197400.0 |
| 2009-08-03 | BTF | ETF | 56.199999999999996 | 57.5 | 51.65 | 55.99999999999999 | 28136.800000000003 |
| 2009-08-03 | BWX | ETF | 28.2 | 28.5 | 28.08 | 28.2 | 586654.0 |
| 2009-08-03 | BWZ | ETF | 35.95 | 36.13 | 35.95 | 36.13 | 8375.0 |
| 2009-08-03 | BZQ | ETF | 7134.4 | 7134.4 | 6872.0 | 6920.0 | 10.75 |
| 2009-08-03 | CBON | ETF | 0.75 | 0.77 | 0.66 | 0.7501 | 70410.0 |
| 2009-08-03 | CEF | ETF | 12.06 | 12.26 | 12.06 | 12.16 | 749800.0 |
| 2009-08-03 | CEW | ETF | 21.59 | 21.59 | 21.43 | 21.55 | 61309.0 |
| 2009-08-03 | CGO | ETF | 12.96 | 13.081 | 12.62 | 12.9 | 22747.0 |
| 2009-08-03 | CGW | ETF | 16.59 | 16.95 | 16.55 | 16.74 | 89925.0 |
| 2009-08-03 | CHB | ETF | 0.5043 | 0.51 | 0.47 | 0.49 | 1168966.0 |
| 2009-08-03 | CHI | ETF | 11.19 | 11.42 | 11.19 | 11.21 | 179710.0 |
| 2009-08-03 | CHIC | ETF | 14.7 | 15.0 | 14.37 | 14.95 | 267060.0 |
> showing 50 of 671 rows — these rows as CSV