PREVIEW / etf_daily / 2009-04-06
file: by_date/etf_daily/2009/2009-04-06.parquet size: 28 KB rows: 644
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-04-06 | SPY | ETF | 83.34 | 84.28 | 82.29 | 83.6 | 264866600.0 |
| 2009-04-06 | QQQ | ETF | 31.97 | 32.33 | 31.65 | 32.27 | 160413612.0 |
| 2009-04-06 | IWM | ETF | 44.99 | 45.11 | 44.03 | 44.85 | 63427300.0 |
| 2009-04-06 | DIA | ETF | 79.46 | 79.93 | 78.6 | 79.76 | 17834000.0 |
| 2009-04-06 | GLD | ETF | 86.4 | 86.44 | 84.97 | 85.27 | 22909600.0 |
| 2009-04-06 | TLT | ETF | 103.54 | 103.59 | 102.22 | 102.48 | 1418100.0 |
| 2009-04-06 | AAXJ | ETF | 36.11 | 36.28 | 35.59 | 36.28 | 66900.0 |
| 2009-04-06 | ACWI | ETF | 30.02 | 30.15 | 29.7 | 30.11 | 438200.0 |
| 2009-04-06 | ACWX | ETF | 28.39 | 28.42 | 28.0 | 28.39 | 56518.0 |
| 2009-04-06 | ADRE | ETF | 29.6 | 29.65 | 29.108 | 29.62 | 165658.0 |
| 2009-04-06 | AFK | ETF | 20.48 | 20.535 | 20.29 | 20.535 | 1109.0 |
| 2009-04-06 | AGG | ETF | 100.66 | 100.68 | 100.1 | 100.4 | 495100.0 |
| 2009-04-06 | AGQ | ETF | 70.34 | 70.68 | 67.78 | 67.8 | 165650.0 |
| 2009-04-06 | AGZ | ETF | 108.07 | 108.1 | 107.485 | 107.98 | 16751.0 |
| 2009-04-06 | AIA | ETF | 27.0601 | 27.146 | 26.83 | 27.146 | 7049.0 |
| 2009-04-06 | AIQ | ETF | 34.1 | 35.7 | 33.75 | 34.25 | 24695.0 |
| 2009-04-06 | AIS | ETF | 0.41 | 0.42 | 0.4 | 0.42 | 72895.0 |
| 2009-04-06 | AIVI | ETF | 30.43 | 30.43 | 29.89 | 30.28 | 9100.0 |
| 2009-04-06 | AMJ | ETF | 19.639 | 19.65 | 19.5 | 19.53 | 57100.0 |
| 2009-04-06 | AOA | ETF | 22.8 | 22.8 | 22.48 | 22.74 | 4700.0 |
| 2009-04-06 | AOK | ETF | 24.98 | 25.59 | 24.3601 | 24.96 | 14922.0 |
| 2009-04-06 | AOM | ETF | 24.34 | 24.89 | 24.2 | 24.89 | 7773.0 |
| 2009-04-06 | AOR | ETF | 23.5862 | 23.72 | 23.5 | 23.66 | 13802.0 |
| 2009-04-06 | ARB | ETF | 16.0 | 16.26 | 15.73 | 16.19 | 533182.0 |
| 2009-04-06 | BAL | ETF | 27.05 | 27.22 | 26.76 | 26.76 | 4256.0 |
| 2009-04-06 | BBH | ETF | 29.4367 | 30.04 | 29.3833 | 30.04 | 262800.0 |
| 2009-04-06 | BIL | ETF | 91.68 | 91.74 | 91.66 | 91.7 | 242350.0 |
| 2009-04-06 | BITS | ETF | 18.6 | 18.6 | 17.36 | 18.6 | 1926.0 |
| 2009-04-06 | BIV | ETF | 75.74 | 75.83 | 75.25 | 75.28 | 147300.0 |
| 2009-04-06 | BJK | ETF | 18.44 | 18.56 | 16.82 | 17.74 | 11700.0 |
| 2009-04-06 | BKF | ETF | 27.73 | 27.73 | 27.1115 | 27.58 | 47416.0 |
| 2009-04-06 | BLV | ETF | 72.84 | 72.88 | 72.18 | 72.25 | 10700.0 |
| 2009-04-06 | BMVP | ETF | 10.1933 | 10.2333 | 10.0809 | 10.23 | 16411.0 |
| 2009-04-06 | BND | ETF | 76.71 | 76.79 | 76.52 | 76.55 | 541000.0 |
| 2009-04-06 | BNE | ETF | 3.47 | 3.47 | 3.25 | 3.39 | 152162.0 |
| 2009-04-06 | BSV | ETF | 78.34 | 78.4 | 78.1 | 78.15 | 130200.0 |
| 2009-04-06 | BTF | ETF | 42.9 | 43.25999999999999 | 42.85 | 43.15 | 7064.400000000001 |
| 2009-04-06 | BWX | ETF | 25.655 | 25.77 | 25.55 | 25.605 | 147516.0 |
| 2009-04-06 | BWZ | ETF | 32.96 | 32.975 | 32.9 | 32.95 | 27435.0 |
| 2009-04-06 | CBON | ETF | 2.0 | 2.55 | 2.0 | 2.27 | 45571.0 |
| 2009-04-06 | CEF | ETF | 11.41 | 11.47 | 11.2 | 11.25 | 1372200.0 |
| 2009-04-06 | CGO | ETF | 9.19 | 9.6 | 9.18 | 9.5 | 19162.0 |
| 2009-04-06 | CGW | ETF | 12.84 | 12.84 | 12.65 | 12.76 | 11354.0 |
| 2009-04-06 | CHB | ETF | 0.54 | 0.54 | 0.51 | 0.52 | 545924.0 |
| 2009-04-06 | CHI | ETF | 8.64 | 8.83 | 8.64 | 8.8 | 118356.0 |
| 2009-04-06 | CHIC | ETF | 9.36 | 9.53 | 9.17 | 9.43 | 414448.0 |
| 2009-04-06 | CHW | ETF | 5.74 | 5.82 | 5.6 | 5.78 | 218798.0 |
| 2009-04-06 | CHY | ETF | 8.39 | 8.43 | 8.32 | 8.38 | 136866.0 |
| 2009-04-06 | CMF | ETF | 51.78 | 51.9136 | 51.75 | 51.8625 | 10858.0 |
| 2009-04-06 | CNXT | ETF | 0.73 | 0.74 | 0.69 | 0.721 | 134468.0 |
> showing 50 of 644 rows — these rows as CSV