PREVIEW / etf_daily / 2009-11-05
file: by_date/etf_daily/2009/2009-11-05.parquet size: 30 KB rows: 680
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-11-05 | SPY | ETF | 105.66 | 106.88 | 105.44 | 106.85 | 180015300.0 |
| 2009-11-05 | QQQ | ETF | 41.81 | 42.4 | 41.78 | 42.35 | 135204788.0 |
| 2009-11-05 | IWM | ETF | 56.99 | 58.17 | 56.77 | 58.04 | 67422600.0 |
| 2009-11-05 | DIA | ETF | 98.86 | 100.23 | 98.81 | 100.16 | 9811600.0 |
| 2009-11-05 | GLD | ETF | 106.81 | 107.2 | 106.6 | 106.98 | 10189000.0 |
| 2009-11-05 | TLT | ETF | 92.87 | 93.24 | 92.8 | 93.24 | 2852000.0 |
| 2009-11-05 | AAXJ | ETF | 52.89 | 53.29 | 52.62 | 53.28 | 68100.0 |
| 2009-11-05 | ACWI | ETF | 40.65 | 41.2 | 40.65 | 41.2 | 40300.0 |
| 2009-11-05 | ACWX | ETF | 39.73 | 40.13 | 39.73 | 40.11 | 288397.0 |
| 2009-11-05 | ADRE | ETF | 42.33 | 42.93 | 42.19 | 42.93 | 128536.0 |
| 2009-11-05 | AFK | ETF | 28.33 | 28.33 | 27.62 | 27.68 | 54119.0 |
| 2009-11-05 | AGG | ETF | 104.0 | 104.33 | 103.7 | 104.28 | 899100.0 |
| 2009-11-05 | AGQ | ETF | 123.44 | 124.24 | 121.98 | 122.9 | 250500.0 |
| 2009-11-05 | AGZ | ETF | 108.18 | 108.31 | 108.036 | 108.29 | 10006.0 |
| 2009-11-05 | AIA | ETF | 37.96 | 38.36 | 37.92 | 38.34 | 18111.0 |
| 2009-11-05 | AIQ | ETF | 26.65 | 27.15 | 25.5 | 26.35 | 115226.0 |
| 2009-11-05 | AIS | ETF | 1.11 | 1.15 | 1.09 | 1.15 | 404560.0 |
| 2009-11-05 | AIVI | ETF | 42.51 | 42.9 | 42.42 | 42.58 | 93100.0 |
| 2009-11-05 | AMJ | ETF | 26.1 | 26.31 | 25.71 | 26.31 | 156641.0 |
| 2009-11-05 | AOA | ETF | 28.68 | 28.92 | 28.61 | 28.92 | 5600.0 |
| 2009-11-05 | AOK | ETF | 27.09 | 27.12 | 26.9916 | 27.12 | 34348.0 |
| 2009-11-05 | AOM | ETF | 27.67 | 27.79 | 27.67 | 27.79 | 4998.0 |
| 2009-11-05 | AOR | ETF | 28.2 | 28.36 | 28.13 | 28.36 | 16736.0 |
| 2009-11-05 | ARB | ETF | 21.64 | 22.39 | 21.64 | 22.09 | 225909.0 |
| 2009-11-05 | BAL | ETF | 35.16 | 35.48 | 34.88 | 35.1 | 14771.0 |
| 2009-11-05 | BBH | ETF | 30.4833 | 31.55 | 30.48 | 31.4333 | 395400.0 |
| 2009-11-05 | BIL | ETF | 91.76 | 91.76 | 91.74 | 91.74 | 158650.0 |
| 2009-11-05 | BITS | ETF | 27.72 | 27.72 | 27.0 | 27.72 | 2756.0 |
| 2009-11-05 | BIV | ETF | 79.82 | 79.99 | 79.74 | 79.91 | 190500.0 |
| 2009-11-05 | BJK | ETF | 24.24 | 24.53 | 24.18 | 24.3 | 6000.0 |
| 2009-11-05 | BKF | ETF | 44.6 | 45.31 | 44.318 | 45.31 | 255846.0 |
| 2009-11-05 | BLV | ETF | 77.03 | 77.19 | 76.85 | 76.97 | 71100.0 |
| 2009-11-05 | BMVP | ETF | 11.9 | 12.05 | 11.9 | 12.04 | 10814.0 |
| 2009-11-05 | BND | ETF | 78.99 | 79.11 | 78.89 | 79.06 | 454300.0 |
| 2009-11-05 | BNE | ETF | 6.41 | 7.06 | 5.99 | 6.97 | 313496.0 |
| 2009-11-05 | BOSS | ETF | 17.96 | 18.15 | 17.96 | 17.96 | 100.0 |
| 2009-11-05 | BRF | ETF | 44.37 | 45.38 | 44.23 | 45.38 | 536873.0 |
| 2009-11-05 | BSV | ETF | 79.89 | 79.92 | 79.75 | 79.87 | 445900.0 |
| 2009-11-05 | BTF | ETF | 61.39999999999999 | 61.849999999999994 | 61.39999999999999 | 61.699999999999996 | 7562.400000000001 |
| 2009-11-05 | BWX | ETF | 29.25 | 29.365 | 29.24 | 29.34 | 247244.0 |
| 2009-11-05 | BWZ | ETF | 37.35 | 37.39 | 37.1601 | 37.19 | 29763.0 |
| 2009-11-05 | BZQ | ETF | 4296.0 | 4321.6 | 4099.2 | 4099.2 | 1127.5 |
| 2009-11-05 | CEF | ETF | 14.06 | 14.08 | 13.94 | 13.96 | 619500.0 |
| 2009-11-05 | CEW | ETF | 21.93 | 21.96 | 21.854 | 21.94 | 83569.0 |
| 2009-11-05 | CGO | ETF | 13.4 | 13.56 | 13.4 | 13.45 | 96635.0 |
| 2009-11-05 | CGW | ETF | 17.39 | 17.76 | 17.39 | 17.7 | 106201.0 |
| 2009-11-05 | CHB | ETF | 0.21 | 0.23 | 0.21 | 0.22 | 864752.0 |
| 2009-11-05 | CHI | ETF | 11.91 | 12.08 | 11.88 | 11.994 | 212315.0 |
| 2009-11-05 | CHW | ETF | 7.58 | 7.58 | 7.48 | 7.55 | 190781.0 |
| 2009-11-05 | CHY | ETF | 11.62 | 11.62 | 11.48 | 11.506 | 160869.0 |
> showing 50 of 680 rows — these rows as CSV