PREVIEW / etf_daily / 2009-02-10
file: by_date/etf_daily/2009/2009-02-10.parquet size: 28 KB rows: 640
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-10 | SPY | ETF | 86.27 | 87.03 | 82.45 | 83.11 | 536212800.0 |
| 2009-02-10 | QQQ | ETF | 31.3 | 31.68 | 30.1 | 30.34 | 232790536.0 |
| 2009-02-10 | IWM | ETF | 46.39 | 47.1 | 44.45 | 44.59 | 83914300.0 |
| 2009-02-10 | DIA | ETF | 82.23 | 82.73 | 78.61 | 79.19 | 49006600.0 |
| 2009-02-10 | GLD | ETF | 89.66 | 90.37 | 89.18 | 90.21 | 25445100.0 |
| 2009-02-10 | TLT | ETF | 104.11 | 104.96 | 103.45 | 104.85 | 3782800.0 |
| 2009-02-10 | AAXJ | ETF | 33.05 | 33.05 | 30.89 | 31.08 | 94100.0 |
| 2009-02-10 | ACWI | ETF | 30.18 | 30.42 | 28.88 | 29.1 | 164300.0 |
| 2009-02-10 | ACWX | ETF | 28.16 | 28.24 | 26.7 | 26.83 | 83985.0 |
| 2009-02-10 | ADRE | ETF | 28.37 | 28.78 | 26.93 | 27.18 | 286634.0 |
| 2009-02-10 | AFK | ETF | 18.9507 | 18.9507 | 18.22 | 18.22 | 21981.0 |
| 2009-02-10 | AGG | ETF | 101.15 | 101.8 | 100.85 | 101.58 | 524800.0 |
| 2009-02-10 | AGQ | ETF | 81.8 | 83.88 | 81.8 | 82.54 | 46250.0 |
| 2009-02-10 | AGZ | ETF | 107.77 | 108.02 | 107.7036 | 107.94 | 7126.0 |
| 2009-02-10 | AIA | ETF | 25.01 | 25.09 | 23.8247 | 23.8247 | 17778.0 |
| 2009-02-10 | AIQ | ETF | 46.8 | 47.7 | 45.1 | 45.4 | 29500.0 |
| 2009-02-10 | AIS | ETF | 0.4014 | 0.43 | 0.4014 | 0.42 | 20564.0 |
| 2009-02-10 | AIVI | ETF | 30.49 | 30.49 | 28.76 | 28.76 | 25900.0 |
| 2009-02-10 | AOA | ETF | 22.37 | 22.85 | 22.37 | 22.52 | 4600.0 |
| 2009-02-10 | AOK | ETF | 25.79 | 25.79 | 25.21 | 25.21 | 2296.0 |
| 2009-02-10 | AOM | ETF | 25.71 | 25.71 | 24.24 | 24.36 | 5100.0 |
| 2009-02-10 | AOR | ETF | 23.4975 | 23.6 | 22.28 | 23.6 | 7847.0 |
| 2009-02-10 | ARB | ETF | 14.44 | 14.75 | 13.47 | 13.59 | 229956.0 |
| 2009-02-10 | BAL | ETF | 28.9501 | 29.145 | 27.55 | 27.65 | 4522.0 |
| 2009-02-10 | BBH | ETF | 58.1733 | 59.0 | 57.4733 | 57.8133 | 222600.0 |
| 2009-02-10 | BIL | ETF | 91.66 | 91.76 | 91.66 | 91.7 | 198100.0 |
| 2009-02-10 | BITS | ETF | 19.68 | 19.68 | 19.4 | 19.4 | 100.0 |
| 2009-02-10 | BIV | ETF | 77.12 | 77.27 | 76.0 | 76.48 | 191900.0 |
| 2009-02-10 | BJK | ETF | 15.95 | 15.95 | 15.95 | 15.95 | 100.0 |
| 2009-02-10 | BKF | ETF | 25.31 | 25.368 | 23.7 | 24.16 | 26576.0 |
| 2009-02-10 | BLV | ETF | 75.38 | 75.38 | 74.34 | 74.53 | 62000.0 |
| 2009-02-10 | BMVP | ETF | 10.5533 | 10.6318 | 10.1733 | 10.2367 | 38555.0 |
| 2009-02-10 | BND | ETF | 77.12 | 77.3 | 76.75 | 77.24 | 291900.0 |
| 2009-02-10 | BNE | ETF | 2.97 | 3.25 | 2.85 | 2.87 | 316420.0 |
| 2009-02-10 | BSV | ETF | 79.05 | 79.39 | 78.7 | 78.77 | 301200.0 |
| 2009-02-10 | BTF | ETF | 48.49999999999999 | 48.65 | 46.39999999999999 | 47.05 | 10643.800000000001 |
| 2009-02-10 | BWX | ETF | 25.565 | 25.6 | 25.33 | 25.45 | 125584.0 |
| 2009-02-10 | BWZ | ETF | 32.79 | 32.79 | 32.79 | 32.79 | 460.0 |
| 2009-02-10 | CBON | ETF | 1.85 | 1.85 | 1.62 | 1.62 | 42345.0 |
| 2009-02-10 | CDL | ETF | 0.16 | 0.17 | 0.16 | 0.16 | 380011.0 |
| 2009-02-10 | CEF | ETF | 11.35 | 11.42 | 11.23 | 11.4 | 1040300.0 |
| 2009-02-10 | CGO | ETF | 9.97 | 10.366 | 9.782 | 10.05 | 37512.0 |
| 2009-02-10 | CGW | ETF | 13.61 | 13.7099 | 13.02 | 13.17 | 53255.0 |
| 2009-02-10 | CHB | ETF | 0.386 | 0.41 | 0.31 | 0.31 | 894793.0 |
| 2009-02-10 | CHI | ETF | 8.83 | 8.97 | 8.8 | 8.93 | 162155.0 |
| 2009-02-10 | CHIC | ETF | 6.42 | 6.49 | 5.8 | 5.81 | 222370.0 |
| 2009-02-10 | CHW | ETF | 6.59 | 6.59 | 6.25 | 6.47 | 199316.0 |
| 2009-02-10 | CHY | ETF | 9.17 | 9.17 | 8.8 | 9.03 | 272384.0 |
| 2009-02-10 | CMF | ETF | 52.1075 | 52.18 | 51.7725 | 51.905 | 5242.0 |
| 2009-02-10 | CNXT | ETF | 0.64 | 0.65 | 0.6 | 0.62 | 317630.0 |
> showing 50 of 640 rows — these rows as CSV