PREVIEW / etf_daily / 2009-06-02
file: by_date/etf_daily/2009/2009-06-02.parquet size: 29 KB rows: 649
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-06-02 | SPY | ETF | 94.4 | 95.37 | 94.23 | 94.85 | 230874500.0 |
| 2009-06-02 | QQQ | ETF | 36.19 | 36.79 | 36.11 | 36.44 | 126858554.0 |
| 2009-06-02 | IWM | ETF | 51.96 | 53.0 | 51.68 | 52.78 | 56794100.0 |
| 2009-06-02 | DIA | ETF | 87.14 | 87.97 | 86.93 | 87.5 | 10553900.0 |
| 2009-06-02 | GLD | ETF | 96.19 | 96.97 | 96.1 | 96.36 | 14532700.0 |
| 2009-06-02 | TLT | ETF | 91.61 | 91.77 | 90.78 | 91.58 | 5063600.0 |
| 2009-06-02 | AAXJ | ETF | 45.79 | 46.14 | 45.5 | 45.5 | 1174900.0 |
| 2009-06-02 | ACWI | ETF | 36.19 | 36.36 | 35.95 | 36.14 | 154600.0 |
| 2009-06-02 | ACWX | ETF | 35.3 | 35.64 | 35.18 | 35.61 | 92788.0 |
| 2009-06-02 | ADRE | ETF | 36.93 | 37.23 | 36.73 | 36.83 | 1032085.0 |
| 2009-06-02 | AFK | ETF | 29.5 | 29.5 | 28.82 | 28.9299 | 34880.0 |
| 2009-06-02 | AGG | ETF | 101.06 | 101.23 | 100.56 | 101.15 | 618100.0 |
| 2009-06-02 | AGQ | ETF | 110.74 | 114.64 | 110.54 | 114.1 | 175700.0 |
| 2009-06-02 | AGZ | ETF | 106.6 | 107.04 | 106.485 | 106.54 | 11908.0 |
| 2009-06-02 | AIA | ETF | 33.81 | 35.0 | 33.45 | 33.45 | 30703.0 |
| 2009-06-02 | AIQ | ETF | 35.0 | 36.45 | 34.5 | 36.2 | 101583.0 |
| 2009-06-02 | AIS | ETF | 0.56 | 0.58 | 0.5599 | 0.56 | 22283.0 |
| 2009-06-02 | AIVI | ETF | 37.46 | 37.98 | 37.41 | 37.8 | 11200.0 |
| 2009-06-02 | AMJ | ETF | 23.34 | 23.34 | 23.0999 | 23.3 | 73544.0 |
| 2009-06-02 | AOA | ETF | 26.03 | 26.59 | 25.94 | 26.02 | 5100.0 |
| 2009-06-02 | AOK | ETF | 26.97 | 26.97 | 25.9 | 25.9 | 6182.0 |
| 2009-06-02 | AOM | ETF | 26.07 | 26.22 | 26.0248 | 26.15 | 10457.0 |
| 2009-06-02 | AOR | ETF | 26.1 | 26.2 | 26.07 | 26.18 | 2432.0 |
| 2009-06-02 | ARB | ETF | 21.0 | 21.17 | 20.48 | 21.04 | 224835.0 |
| 2009-06-02 | BAL | ETF | 32.36 | 33.27 | 32.36 | 33.27 | 4560.0 |
| 2009-06-02 | BBH | ETF | 30.0 | 30.6667 | 29.8733 | 30.45 | 665700.0 |
| 2009-06-02 | BIL | ETF | 91.7 | 91.74 | 91.68 | 91.68 | 912000.0 |
| 2009-06-02 | BITS | ETF | 19.44 | 19.44 | 19.0 | 19.04 | 2582.0 |
| 2009-06-02 | BIV | ETF | 75.95 | 76.11 | 75.6 | 76.1 | 107000.0 |
| 2009-06-02 | BJK | ETF | 22.65 | 25.27 | 21.82 | 22.32 | 18200.0 |
| 2009-06-02 | BKF | ETF | 38.32 | 38.32 | 37.08 | 37.77 | 1036151.0 |
| 2009-06-02 | BLV | ETF | 71.78 | 72.28 | 71.74 | 72.28 | 12200.0 |
| 2009-06-02 | BMVP | ETF | 11.1167 | 11.2756 | 11.1167 | 11.2233 | 41895.0 |
| 2009-06-02 | BND | ETF | 76.89 | 76.98 | 76.67 | 76.98 | 417500.0 |
| 2009-06-02 | BNE | ETF | 6.0 | 6.488 | 5.85 | 6.27 | 142498.0 |
| 2009-06-02 | BOSS | ETF | 16.23 | 16.24 | 16.23 | 16.24 | 100.0 |
| 2009-06-02 | BRF | ETF | 28.68 | 28.9163 | 28.21 | 28.777 | 115673.0 |
| 2009-06-02 | BSV | ETF | 78.94 | 79.01 | 78.7 | 78.88 | 178800.0 |
| 2009-06-02 | BTF | ETF | 48.4 | 48.81 | 48.2 | 48.65 | 12498.800000000001 |
| 2009-06-02 | BWX | ETF | 27.195 | 27.605 | 27.19 | 27.355 | 624340.0 |
| 2009-06-02 | BWZ | ETF | 35.62 | 35.67 | 35.615 | 35.67 | 3000.0 |
| 2009-06-02 | CBON | ETF | 1.11 | 1.25 | 1.11 | 1.18 | 25410.0 |
| 2009-06-02 | CEF | ETF | 12.5 | 12.56 | 12.43 | 12.5 | 1611200.0 |
| 2009-06-02 | CEW | ETF | 20.8 | 20.9 | 20.76 | 20.9 | 72733.0 |
| 2009-06-02 | CGO | ETF | 11.39 | 11.69 | 11.38 | 11.6 | 30737.0 |
| 2009-06-02 | CGW | ETF | 15.5 | 15.97 | 15.5 | 15.93 | 80965.0 |
| 2009-06-02 | CHB | ETF | 0.42 | 0.44 | 0.4001 | 0.43 | 529570.0 |
| 2009-06-02 | CHI | ETF | 10.6 | 10.75 | 9.68 | 10.7 | 164180.0 |
| 2009-06-02 | CHIC | ETF | 11.05 | 11.43 | 10.92 | 11.3 | 223574.0 |
| 2009-06-02 | CHW | ETF | 7.3 | 7.7 | 7.19 | 7.24 | 225072.0 |
> showing 50 of 649 rows — these rows as CSV