PREVIEW / etf_daily / 2009-12-10
file: by_date/etf_daily/2009/2009-12-10.parquet size: 31 KB rows: 703
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-12-10 | SPY | ETF | 110.7 | 111.12 | 110.45 | 110.64 | 138014600.0 |
| 2009-12-10 | QQQ | ETF | 44.25 | 44.54 | 44.24 | 44.3 | 76722313.0 |
| 2009-12-10 | IWM | ETF | 60.12 | 60.44 | 59.36 | 59.61 | 54319700.0 |
| 2009-12-10 | DIA | ETF | 103.99 | 104.62 | 103.95 | 104.18 | 8039500.0 |
| 2009-12-10 | GLD | ETF | 110.66 | 111.03 | 110.04 | 110.82 | 20531800.0 |
| 2009-12-10 | TLT | ETF | 92.69 | 92.8 | 91.95 | 92.1 | 4446300.0 |
| 2009-12-10 | AAXJ | ETF | 55.64 | 55.79 | 55.33 | 55.79 | 157000.0 |
| 2009-12-10 | ACWI | ETF | 42.24 | 42.27 | 41.98 | 42.12 | 75700.0 |
| 2009-12-10 | ACWX | ETF | 40.89 | 40.92 | 40.62 | 40.75 | 51601.0 |
| 2009-12-10 | ADRE | ETF | 44.24 | 44.32 | 43.9 | 44.18 | 65666.0 |
| 2009-12-10 | AFK | ETF | 28.184 | 28.29 | 27.973 | 28.19 | 21483.0 |
| 2009-12-10 | AGG | ETF | 104.87 | 104.95 | 104.71 | 104.87 | 533100.0 |
| 2009-12-10 | AGQ | ETF | 120.26 | 121.58 | 116.88 | 120.72 | 242700.0 |
| 2009-12-10 | AGZ | ETF | 108.64 | 108.82 | 108.46 | 108.771 | 17303.0 |
| 2009-12-10 | AIA | ETF | 39.58 | 39.74 | 39.37 | 39.58 | 58927.0 |
| 2009-12-10 | AIQ | ETF | 30.1 | 30.85 | 30.1 | 30.7 | 31420.0 |
| 2009-12-10 | AIS | ETF | 1.08 | 1.1 | 1.07 | 1.1 | 119541.0 |
| 2009-12-10 | AIVI | ETF | 43.74 | 43.88 | 43.54 | 43.54 | 16500.0 |
| 2009-12-10 | AMJ | ETF | 27.22 | 27.45 | 27.01 | 27.45 | 255620.0 |
| 2009-12-10 | AOA | ETF | 29.6 | 29.67 | 29.57 | 29.62 | 1600.0 |
| 2009-12-10 | AOK | ETF | 27.33 | 27.42 | 27.33 | 27.4 | 10120.0 |
| 2009-12-10 | AOM | ETF | 28.28 | 28.28 | 28.21 | 28.21 | 15132.0 |
| 2009-12-10 | AOR | ETF | 28.81 | 28.91 | 28.81 | 28.88 | 11504.0 |
| 2009-12-10 | ARB | ETF | 21.63 | 21.789 | 21.25 | 21.43 | 155514.0 |
| 2009-12-10 | BAB | ETF | 24.63 | 24.72 | 24.55 | 24.68 | 131613.0 |
| 2009-12-10 | BAL | ETF | 36.36 | 36.6585 | 36.36 | 36.48 | 19979.0 |
| 2009-12-10 | BBH | ETF | 32.1967 | 32.6833 | 32.1967 | 32.4233 | 90900.0 |
| 2009-12-10 | BIL | ETF | 91.74 | 91.74 | 91.7 | 91.7 | 55600.0 |
| 2009-12-10 | BITS | ETF | 27.28 | 27.76 | 27.28 | 27.52 | 1512.0 |
| 2009-12-10 | BIV | ETF | 80.69 | 80.77 | 80.31 | 80.62 | 200400.0 |
| 2009-12-10 | BJK | ETF | 24.21 | 24.29 | 23.95 | 23.99 | 11400.0 |
| 2009-12-10 | BKF | ETF | 46.0 | 46.07 | 45.6 | 45.84 | 241356.0 |
| 2009-12-10 | BLV | ETF | 77.3 | 77.52 | 77.12 | 77.15 | 28700.0 |
| 2009-12-10 | BMVP | ETF | 12.3 | 12.41 | 12.3 | 12.38 | 23789.0 |
| 2009-12-10 | BND | ETF | 79.61 | 79.61 | 79.39 | 79.52 | 624500.0 |
| 2009-12-10 | BNE | ETF | 6.57 | 6.57 | 6.32 | 6.44 | 191893.0 |
| 2009-12-10 | BOSS | ETF | 19.1 | 19.42 | 19.1 | 19.42 | 200.0 |
| 2009-12-10 | BRF | ETF | 48.5 | 48.76 | 48.0 | 48.58 | 281757.0 |
| 2009-12-10 | BSV | ETF | 80.31 | 80.35 | 80.2 | 80.3 | 507000.0 |
| 2009-12-10 | BTF | ETF | 63.49999999999999 | 63.65 | 63.05 | 63.550000000000004 | 2783.0 |
| 2009-12-10 | BWX | ETF | 29.625 | 29.7225 | 29.46 | 29.54 | 504508.0 |
| 2009-12-10 | BWZ | ETF | 37.55 | 37.578 | 37.39 | 37.51 | 22281.0 |
| 2009-12-10 | BZQ | ETF | 3761.6 | 3844.8 | 3729.6 | 3766.4 | 379.0 |
| 2009-12-10 | CEF | ETF | 13.95 | 14.1 | 13.9 | 14.07 | 1071300.0 |
| 2009-12-10 | CEW | ETF | 22.1 | 22.18 | 22.0508 | 22.15 | 53990.0 |
| 2009-12-10 | CGO | ETF | 13.95 | 14.09 | 13.88 | 14.09 | 19913.0 |
| 2009-12-10 | CGW | ETF | 18.39 | 18.44 | 18.28 | 18.35 | 85075.0 |
| 2009-12-10 | CHI | ETF | 12.43 | 12.43 | 12.26 | 12.36 | 157764.0 |
| 2009-12-10 | CHII | ETF | 16.05 | 16.05 | 15.93 | 15.99 | 14268.0 |
| 2009-12-10 | CHIQ | ETF | 16.44 | 16.44 | 16.2 | 16.28 | 144660.0 |
> showing 50 of 703 rows — these rows as CSV