PREVIEW / etf_daily / 2009-11-13
file: by_date/etf_daily/2009/2009-11-13.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-13 | SPY | ETF | 109.31 | 110.09 | 108.75 | 109.62 | 150963000.0 |
| 2009-11-13 | QQQ | ETF | 43.78 | 44.14 | 43.63 | 44.01 | 87959492.0 |
| 2009-11-13 | IWM | ETF | 58.35 | 58.96 | 57.63 | 58.73 | 69258000.0 |
| 2009-11-13 | DIA | ETF | 102.35 | 103.25 | 102.1 | 102.91 | 11677800.0 |
| 2009-11-13 | GLD | ETF | 108.32 | 109.8 | 108.14 | 109.74 | 17246000.0 |
| 2009-11-13 | TLT | ETF | 93.83 | 94.06 | 93.45 | 93.92 | 1594200.0 |
| 2009-11-13 | AAXJ | ETF | 54.74 | 55.47 | 54.73 | 55.28 | 142400.0 |
| 2009-11-13 | ACWI | ETF | 42.02 | 42.4 | 41.79 | 42.3 | 181200.0 |
| 2009-11-13 | ACWX | ETF | 41.03 | 41.39 | 40.74 | 41.3 | 66197.0 |
| 2009-11-13 | ADRE | ETF | 43.54 | 44.26 | 43.36 | 44.15 | 167554.0 |
| 2009-11-13 | AFK | ETF | 27.98 | 28.5 | 27.96 | 28.5 | 1710.0 |
| 2009-11-13 | AGG | ETF | 104.77 | 104.9 | 104.58 | 104.9 | 408000.0 |
| 2009-11-13 | AGQ | ETF | 118.4 | 122.92 | 117.0 | 122.74 | 212650.0 |
| 2009-11-13 | AGZ | ETF | 108.38 | 108.61 | 108.32 | 108.6 | 15350.0 |
| 2009-11-13 | AIA | ETF | 39.37 | 39.57 | 39.122 | 39.37 | 65751.0 |
| 2009-11-13 | AIQ | ETF | 26.0 | 26.95 | 25.3 | 26.15 | 36845.0 |
| 2009-11-13 | AIS | ETF | 1.08 | 1.1 | 1.07 | 1.08 | 182270.0 |
| 2009-11-13 | AIVI | ETF | 43.79 | 44.4 | 43.55 | 44.25 | 26400.0 |
| 2009-11-13 | AMJ | ETF | 26.49 | 26.64 | 26.4 | 26.64 | 118478.0 |
| 2009-11-13 | AOA | ETF | 29.43 | 29.63 | 29.38 | 29.59 | 2800.0 |
| 2009-11-13 | AOK | ETF | 27.29 | 27.41 | 27.11 | 27.38 | 9893.0 |
| 2009-11-13 | AOM | ETF | 28.06 | 28.2164 | 28.06 | 28.16 | 15607.0 |
| 2009-11-13 | AOR | ETF | 28.78 | 28.9 | 28.7 | 28.86 | 13144.0 |
| 2009-11-13 | ARB | ETF | 21.5 | 21.75 | 21.01 | 21.75 | 329765.0 |
| 2009-11-13 | BAL | ETF | 34.67 | 35.16 | 34.67 | 34.958 | 20127.0 |
| 2009-11-13 | BBH | ETF | 32.23 | 32.63 | 32.2133 | 32.3133 | 187500.0 |
| 2009-11-13 | BIL | ETF | 91.7 | 91.74 | 91.7 | 91.7 | 177350.0 |
| 2009-11-13 | BITS | ETF | 27.4 | 28.0 | 27.4 | 27.64 | 4050.0 |
| 2009-11-13 | BIV | ETF | 80.41 | 80.58 | 80.29 | 80.58 | 138300.0 |
| 2009-11-13 | BJK | ETF | 25.4 | 25.69 | 25.28 | 25.51 | 7500.0 |
| 2009-11-13 | BKF | ETF | 45.78 | 46.44 | 45.47 | 46.25 | 134180.0 |
| 2009-11-13 | BLV | ETF | 77.57 | 77.6 | 77.17 | 77.6 | 28300.0 |
| 2009-11-13 | BMVP | ETF | 12.2367 | 12.3472 | 12.2067 | 12.32 | 20160.0 |
| 2009-11-13 | BND | ETF | 79.49 | 79.51 | 79.35 | 79.51 | 398000.0 |
| 2009-11-13 | BNE | ETF | 6.39 | 6.55 | 6.28 | 6.36 | 113255.0 |
| 2009-11-13 | BOSS | ETF | 19.9 | 20.01 | 19.6 | 19.9 | 100.0 |
| 2009-11-13 | BRF | ETF | 45.11 | 46.27 | 44.89 | 46.25 | 277362.0 |
| 2009-11-13 | BSV | ETF | 80.12 | 80.17 | 80.06 | 80.06 | 325700.0 |
| 2009-11-13 | BTF | ETF | 62.599999999999994 | 63.550000000000004 | 62.5 | 63.3 | 3266.4 |
| 2009-11-13 | BWX | ETF | 29.58 | 29.74 | 29.48 | 29.735 | 399684.0 |
| 2009-11-13 | BWZ | ETF | 37.62 | 37.74 | 37.62 | 37.68 | 41765.0 |
| 2009-11-13 | BZQ | ETF | 4209.6 | 4209.6 | 3971.2 | 4024.0 | 202.5 |
| 2009-11-13 | CEF | ETF | 13.7 | 14.08 | 13.59 | 13.88 | 1281200.0 |
| 2009-11-13 | CEW | ETF | 22.18 | 22.3 | 22.15 | 22.295 | 72145.0 |
| 2009-11-13 | CGO | ETF | 13.65 | 13.87 | 13.37 | 13.8 | 129185.0 |
| 2009-11-13 | CGW | ETF | 18.09 | 18.283 | 18.02 | 18.239 | 61713.0 |
| 2009-11-13 | CHB | ETF | 0.22 | 0.22 | 0.2 | 0.2 | 1255350.0 |
| 2009-11-13 | CHI | ETF | 12.25 | 12.28 | 12.07 | 12.071 | 157130.0 |
| 2009-11-13 | CHW | ETF | 7.51 | 7.65 | 7.51 | 7.65 | 129302.0 |
| 2009-11-13 | CHY | ETF | 11.65 | 11.67 | 11.56 | 11.63 | 121987.0 |
> showing 50 of 680 rows — these rows as CSV