PREVIEW / etf_daily / 2009-06-30
file: by_date/etf_daily/2009/2009-06-30.parquet size: 29 KB rows: 661
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-30 | SPY | ETF | 92.72 | 93.06 | 91.27 | 91.95 | 228888200.0 |
| 2009-06-30 | QQQ | ETF | 36.55 | 36.73 | 36.11 | 36.38 | 97843001.0 |
| 2009-06-30 | IWM | ETF | 51.24 | 51.61 | 50.77 | 51.08 | 44575900.0 |
| 2009-06-30 | DIA | ETF | 85.33 | 85.64 | 83.96 | 84.66 | 13421400.0 |
| 2009-06-30 | GLD | ETF | 91.85 | 91.96 | 90.53 | 91.18 | 24189500.0 |
| 2009-06-30 | TLT | ETF | 94.19 | 95.11 | 93.81 | 94.57 | 3743700.0 |
| 2009-06-30 | AAXJ | ETF | 44.3 | 44.44 | 43.62 | 43.78 | 194000.0 |
| 2009-06-30 | ACWI | ETF | 34.94 | 34.94 | 34.29 | 34.49 | 157400.0 |
| 2009-06-30 | ACWX | ETF | 33.61 | 33.65 | 33.0 | 33.21 | 67660.0 |
| 2009-06-30 | ADRE | ETF | 35.0 | 35.07 | 34.28 | 34.57 | 140756.0 |
| 2009-06-30 | AFK | ETF | 27.29 | 27.29 | 26.8101 | 26.8101 | 6900.0 |
| 2009-06-30 | AGG | ETF | 101.98 | 102.3 | 101.92 | 102.15 | 805500.0 |
| 2009-06-30 | AGQ | ETF | 85.42 | 85.8 | 79.62 | 80.98 | 141850.0 |
| 2009-06-30 | AGZ | ETF | 107.41 | 107.63 | 107.09 | 107.44 | 12104.0 |
| 2009-06-30 | AIA | ETF | 32.18 | 32.21 | 31.6 | 31.85 | 8105.0 |
| 2009-06-30 | AIQ | ETF | 36.7 | 37.05 | 36.3 | 36.65 | 43329.0 |
| 2009-06-30 | AIS | ETF | 1.07 | 1.07 | 0.89 | 0.89 | 2181074.0 |
| 2009-06-30 | AIVI | ETF | 35.53 | 35.53 | 34.77 | 35.0 | 6400.0 |
| 2009-06-30 | AMJ | ETF | 22.3 | 22.4 | 22.0615 | 22.29 | 115179.0 |
| 2009-06-30 | AOA | ETF | 25.32 | 25.33 | 25.0 | 25.14 | 6600.0 |
| 2009-06-30 | AOK | ETF | 25.76 | 25.8199 | 25.74 | 25.8199 | 1920.0 |
| 2009-06-30 | AOM | ETF | 26.0 | 26.0 | 25.56 | 25.62 | 13161.0 |
| 2009-06-30 | AOR | ETF | 25.65 | 25.65 | 25.35 | 25.43 | 4742.0 |
| 2009-06-30 | ARB | ETF | 16.25 | 16.42 | 15.87 | 15.89 | 492514.0 |
| 2009-06-30 | BAL | ETF | 29.04 | 29.48 | 29.04 | 29.48 | 10500.0 |
| 2009-06-30 | BBH | ETF | 31.16 | 31.34 | 30.8333 | 31.02 | 553500.0 |
| 2009-06-30 | BIL | ETF | 91.76 | 91.76 | 91.74 | 91.74 | 189550.0 |
| 2009-06-30 | BITS | ETF | 19.56 | 20.8 | 19.52 | 20.8 | 2250.0 |
| 2009-06-30 | BIV | ETF | 77.12 | 77.32 | 76.86 | 77.27 | 108900.0 |
| 2009-06-30 | BJK | ETF | 20.86 | 20.86 | 20.52 | 20.56 | 3000.0 |
| 2009-06-30 | BKF | ETF | 35.98 | 36.02 | 35.1 | 35.53 | 421313.0 |
| 2009-06-30 | BLV | ETF | 74.54 | 74.86 | 74.09 | 74.78 | 40200.0 |
| 2009-06-30 | BMVP | ETF | 11.0333 | 11.0612 | 10.9033 | 10.9867 | 19134.0 |
| 2009-06-30 | BND | ETF | 77.68 | 77.81 | 77.5 | 77.69 | 439600.0 |
| 2009-06-30 | BNE | ETF | 6.55 | 6.75 | 6.45 | 6.51 | 117156.0 |
| 2009-06-30 | BRF | ETF | 28.88 | 28.88 | 27.45 | 27.75 | 70266.0 |
| 2009-06-30 | BSV | ETF | 79.04 | 79.19 | 78.88 | 79.07 | 263100.0 |
| 2009-06-30 | BTF | ETF | 46.74999999999999 | 47.099999999999994 | 46.3135 | 47.099999999999994 | 8187.6 |
| 2009-06-30 | BWX | ETF | 27.34 | 27.35 | 27.2188 | 27.33 | 217522.0 |
| 2009-06-30 | BWZ | ETF | 35.25 | 35.25 | 35.1368 | 35.18 | 7550.0 |
| 2009-06-30 | CBON | ETF | 0.93 | 0.95 | 0.9 | 0.93 | 29667.0 |
| 2009-06-30 | CEF | ETF | 11.71 | 11.92 | 11.69 | 11.74 | 585400.0 |
| 2009-06-30 | CEW | ETF | 20.98 | 20.98 | 20.82 | 20.89 | 19880.0 |
| 2009-06-30 | CGO | ETF | 11.63 | 11.7 | 11.5 | 11.51 | 19088.0 |
| 2009-06-30 | CGW | ETF | 15.75 | 15.8599 | 15.5 | 15.67 | 37741.0 |
| 2009-06-30 | CHB | ETF | 0.32 | 0.33 | 0.3 | 0.32 | 1387786.0 |
| 2009-06-30 | CHI | ETF | 10.46 | 10.55 | 10.19 | 10.42 | 91118.0 |
| 2009-06-30 | CHIC | ETF | 12.78 | 13.39 | 12.75 | 12.78 | 271573.0 |
| 2009-06-30 | CHW | ETF | 7.0 | 7.0189 | 6.8 | 6.99 | 156745.0 |
| 2009-06-30 | CHY | ETF | 10.25 | 10.26 | 9.92 | 10.2199 | 167212.0 |
> showing 50 of 661 rows — these rows as CSV