PREVIEW / etf_daily / 2009-02-03
file: by_date/etf_daily/2009/2009-02-03.parquet size: 28 KB rows: 635
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-02-03 | SPY | ETF | 83.1 | 84.36 | 82.22 | 83.74 | 278385800.0 |
| 2009-02-03 | QQQ | ETF | 29.46 | 30.4271 | 29.03 | 29.87 | 120609316.0 |
| 2009-02-03 | IWM | ETF | 45.28 | 45.58 | 44.45 | 45.16 | 57452200.0 |
| 2009-02-03 | DIA | ETF | 79.78 | 81.1 | 79.02 | 80.63 | 24065100.0 |
| 2009-02-03 | GLD | ETF | 89.34 | 89.73 | 86.0 | 88.47 | 17521400.0 |
| 2009-02-03 | TLT | ETF | 104.3 | 104.83 | 102.75 | 102.88 | 2846400.0 |
| 2009-02-03 | AAXJ | ETF | 30.86 | 31.11 | 30.31 | 30.9 | 47900.0 |
| 2009-02-03 | ACWI | ETF | 28.94 | 29.45 | 28.64 | 29.27 | 148500.0 |
| 2009-02-03 | ACWX | ETF | 26.69 | 27.256 | 26.5 | 27.19 | 85877.0 |
| 2009-02-03 | ADRE | ETF | 25.81 | 26.38 | 25.59 | 26.2 | 612118.0 |
| 2009-02-03 | AFK | ETF | 17.52 | 17.52 | 17.46 | 17.46 | 704.0 |
| 2009-02-03 | AGG | ETF | 101.76 | 102.0 | 101.14 | 101.14 | 575200.0 |
| 2009-02-03 | AGQ | ETF | 72.42 | 74.4 | 71.04 | 74.4 | 55600.0 |
| 2009-02-03 | AGZ | ETF | 107.23 | 107.23 | 106.6108 | 106.68 | 10700.0 |
| 2009-02-03 | AIA | ETF | 23.12 | 23.59 | 23.11 | 23.54 | 8112.0 |
| 2009-02-03 | AIQ | ETF | 46.15 | 47.2 | 45.35 | 46.15 | 44011.0 |
| 2009-02-03 | AIS | ETF | 0.48 | 0.48 | 0.46 | 0.48 | 16715.0 |
| 2009-02-03 | AIVI | ETF | 28.6 | 29.55 | 28.6 | 29.27 | 18600.0 |
| 2009-02-03 | AOA | ETF | 22.51 | 22.52 | 22.51 | 22.52 | 1300.0 |
| 2009-02-03 | AOK | ETF | 24.99 | 25.09 | 24.99 | 25.0 | 500.0 |
| 2009-02-03 | AOM | ETF | 24.2806 | 24.63 | 24.22 | 24.48 | 9090.0 |
| 2009-02-03 | AOR | ETF | 23.44 | 23.66 | 23.39 | 23.62 | 16416.0 |
| 2009-02-03 | ARB | ETF | 14.05 | 14.18 | 13.46 | 13.72 | 406664.0 |
| 2009-02-03 | BAL | ETF | 29.18 | 29.18 | 28.58 | 28.72 | 10339.0 |
| 2009-02-03 | BBH | ETF | 57.5733 | 58.4067 | 57.1933 | 58.2967 | 377100.0 |
| 2009-02-03 | BIL | ETF | 91.76 | 91.78 | 91.7 | 91.72 | 121850.0 |
| 2009-02-03 | BITS | ETF | 20.12 | 20.792 | 19.92 | 19.96 | 525.0 |
| 2009-02-03 | BIV | ETF | 77.45 | 77.66 | 76.35 | 76.54 | 80600.0 |
| 2009-02-03 | BJK | ETF | 15.5 | 15.5 | 15.5 | 15.5 | 100.0 |
| 2009-02-03 | BKF | ETF | 22.11 | 23.01 | 22.11 | 23.01 | 17305.0 |
| 2009-02-03 | BLV | ETF | 75.29 | 75.29 | 74.48 | 74.54 | 12700.0 |
| 2009-02-03 | BMVP | ETF | 10.2067 | 10.3632 | 10.1133 | 10.3067 | 52011.0 |
| 2009-02-03 | BND | ETF | 77.33 | 77.33 | 76.32 | 76.5 | 391300.0 |
| 2009-02-03 | BNE | ETF | 3.05 | 3.16 | 2.8601 | 2.96 | 272327.0 |
| 2009-02-03 | BSV | ETF | 79.49 | 79.49 | 79.12 | 79.28 | 167000.0 |
| 2009-02-03 | BTF | ETF | 46.95 | 48.349999999999994 | 46.199999999999996 | 48.349999999999994 | 11791.0 |
| 2009-02-03 | BWX | ETF | 25.38 | 25.515 | 25.325 | 25.475 | 262936.0 |
| 2009-02-03 | BWZ | ETF | 32.97 | 32.99 | 32.95 | 32.95 | 1300.0 |
| 2009-02-03 | CBON | ETF | 2.37 | 2.48 | 2.17 | 2.17 | 22174.0 |
| 2009-02-03 | CDL | ETF | 0.21 | 0.21 | 0.18 | 0.19 | 468620.0 |
| 2009-02-03 | CEF | ETF | 11.11 | 11.11 | 10.8 | 10.97 | 740700.0 |
| 2009-02-03 | CGO | ETF | 9.75 | 9.95 | 9.61 | 9.81 | 28990.0 |
| 2009-02-03 | CGW | ETF | 12.9 | 13.127 | 12.69 | 13.06 | 53307.0 |
| 2009-02-03 | CHB | ETF | 0.49 | 0.51 | 0.44 | 0.45 | 419259.0 |
| 2009-02-03 | CHI | ETF | 9.03 | 9.04 | 8.77 | 8.91 | 315554.0 |
| 2009-02-03 | CHIC | ETF | 5.04 | 5.32 | 4.99 | 5.01 | 207855.0 |
| 2009-02-03 | CHW | ETF | 6.17 | 6.17 | 5.99 | 6.15 | 193171.0 |
| 2009-02-03 | CHY | ETF | 8.9 | 9.0 | 8.81 | 9.0 | 171419.0 |
| 2009-02-03 | CMF | ETF | 51.665 | 51.665 | 50.985 | 51.22 | 6284.0 |
| 2009-02-03 | CNXT | ETF | 0.62 | 0.64 | 0.61 | 0.61 | 224678.0 |
> showing 50 of 635 rows — these rows as CSV