PREVIEW / etf_daily / 2009-02-06
file: by_date/etf_daily/2009/2009-02-06.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-06 | SPY | ETF | 84.86 | 87.34 | 84.68 | 86.98 | 366101700.0 |
| 2009-02-06 | QQQ | ETF | 30.71 | 31.51 | 30.58 | 31.37 | 164509610.0 |
| 2009-02-06 | IWM | ETF | 45.42 | 47.17 | 45.21 | 46.96 | 53776100.0 |
| 2009-02-06 | DIA | ETF | 80.87 | 83.27 | 80.72 | 82.86 | 30049700.0 |
| 2009-02-06 | GLD | ETF | 89.15 | 90.14 | 89.15 | 89.59 | 12554300.0 |
| 2009-02-06 | TLT | ETF | 102.25 | 102.86 | 101.9 | 102.29 | 1667500.0 |
| 2009-02-06 | AAXJ | ETF | 32.78 | 33.29 | 32.74 | 33.29 | 100300.0 |
| 2009-02-06 | ACWI | ETF | 29.93 | 30.62 | 29.77 | 30.48 | 99000.0 |
| 2009-02-06 | ACWX | ETF | 27.68 | 28.433 | 27.62 | 28.31 | 92540.0 |
| 2009-02-06 | ADRE | ETF | 27.22 | 28.8797 | 27.22 | 28.72 | 268994.0 |
| 2009-02-06 | AFK | ETF | 18.59 | 18.59 | 18.59 | 18.59 | 100.0 |
| 2009-02-06 | AGG | ETF | 100.92 | 101.18 | 99.97 | 100.95 | 1936800.0 |
| 2009-02-06 | AGQ | ETF | 80.56 | 83.1 | 80.08 | 82.3 | 61600.0 |
| 2009-02-06 | AGZ | ETF | 107.18 | 107.18 | 106.7 | 106.74 | 43118.0 |
| 2009-02-06 | AIA | ETF | 25.06 | 25.56 | 25.06 | 25.34 | 4522.0 |
| 2009-02-06 | AIQ | ETF | 46.75 | 47.5 | 46.15 | 47.1 | 32883.0 |
| 2009-02-06 | AIS | ETF | 0.42 | 0.44 | 0.4 | 0.44 | 130428.0 |
| 2009-02-06 | AIVI | ETF | 29.96 | 30.5 | 29.95 | 30.35 | 12800.0 |
| 2009-02-06 | AOA | ETF | 23.0 | 23.0 | 23.0 | 23.0 | 500.0 |
| 2009-02-06 | AOK | ETF | 25.02 | 25.12 | 25.02 | 25.03 | 9140.0 |
| 2009-02-06 | AOM | ETF | 24.44 | 24.76 | 24.44 | 24.57 | 2806.0 |
| 2009-02-06 | AOR | ETF | 23.85 | 23.85 | 23.85 | 23.85 | 115.0 |
| 2009-02-06 | ARB | ETF | 13.47 | 14.8496 | 13.47 | 14.55 | 221465.0 |
| 2009-02-06 | BAL | ETF | 29.1999 | 29.4099 | 29.07 | 29.17 | 1300.0 |
| 2009-02-06 | BBH | ETF | 58.2967 | 58.81 | 57.9733 | 58.5633 | 192600.0 |
| 2009-02-06 | BIL | ETF | 91.6 | 91.72 | 91.58 | 91.6 | 1654150.0 |
| 2009-02-06 | BITS | ETF | 20.0 | 20.8 | 19.16 | 20.08 | 6664.0 |
| 2009-02-06 | BIV | ETF | 76.58 | 76.58 | 76.32 | 76.45 | 70700.0 |
| 2009-02-06 | BJK | ETF | 15.87 | 15.97 | 15.85 | 15.97 | 400.0 |
| 2009-02-06 | BKF | ETF | 24.0 | 25.14 | 24.0 | 25.0 | 34526.0 |
| 2009-02-06 | BLV | ETF | 74.8 | 74.87 | 73.68 | 73.85 | 49400.0 |
| 2009-02-06 | BMVP | ETF | 10.49 | 10.6567 | 10.4733 | 10.6352 | 27689.0 |
| 2009-02-06 | BND | ETF | 76.85 | 76.85 | 76.45 | 76.8 | 344000.0 |
| 2009-02-06 | BNE | ETF | 3.0 | 3.04 | 2.76 | 3.0 | 305841.0 |
| 2009-02-06 | BSV | ETF | 79.45 | 79.49 | 79.01 | 79.42 | 250800.0 |
| 2009-02-06 | BTF | ETF | 48.099999999999994 | 48.449999999999996 | 47.0 | 48.4 | 9040.6 |
| 2009-02-06 | BWX | ETF | 25.28 | 25.425 | 25.165 | 25.275 | 489900.0 |
| 2009-02-06 | BWZ | ETF | 32.88 | 32.88 | 32.88 | 32.88 | 230.0 |
| 2009-02-06 | CBON | ETF | 1.75 | 1.75 | 1.4 | 1.47 | 46357.0 |
| 2009-02-06 | CDL | ETF | 0.18 | 0.18 | 0.16 | 0.18 | 524844.0 |
| 2009-02-06 | CEF | ETF | 11.37 | 11.42 | 11.15 | 11.24 | 786700.0 |
| 2009-02-06 | CGO | ETF | 10.01 | 10.1891 | 9.9 | 10.06 | 30588.0 |
| 2009-02-06 | CGW | ETF | 13.31 | 13.69 | 13.31 | 13.58 | 68461.0 |
| 2009-02-06 | CHB | ETF | 0.4 | 0.41 | 0.39 | 0.4 | 436902.0 |
| 2009-02-06 | CHI | ETF | 9.04 | 9.13 | 8.93 | 9.04 | 108963.0 |
| 2009-02-06 | CHIC | ETF | 5.04 | 5.9 | 5.04 | 5.78 | 236953.0 |
| 2009-02-06 | CHW | ETF | 6.39 | 6.44 | 6.3 | 6.44 | 149373.0 |
| 2009-02-06 | CHY | ETF | 8.9 | 9.09 | 8.85 | 8.954 | 226713.0 |
| 2009-02-06 | CMF | ETF | 51.78 | 51.78 | 51.685 | 51.695 | 6460.0 |
| 2009-02-06 | CNXT | ETF | 0.61 | 0.64 | 0.61 | 0.63 | 263189.0 |
> showing 50 of 640 rows — these rows as CSV