PREVIEW / etf_daily / 2009-09-24
file: by_date/etf_daily/2009/2009-09-24.parquet size: 30 KB rows: 677
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-09-24 | SPY | ETF | 106.41 | 106.64 | 104.55 | 105.01 | 228636800.0 |
| 2009-09-24 | QQQ | ETF | 42.61 | 42.69 | 41.77 | 42.07 | 111016320.0 |
| 2009-09-24 | IWM | ETF | 61.53 | 61.76 | 59.76 | 60.2 | 60639600.0 |
| 2009-09-24 | DIA | ETF | 97.75 | 98.02 | 96.62 | 96.99 | 16702600.0 |
| 2009-09-24 | GLD | ETF | 99.36 | 99.44 | 97.14 | 97.55 | 23350200.0 |
| 2009-09-24 | TLT | ETF | 96.5 | 97.09 | 96.17 | 96.75 | 4658400.0 |
| 2009-09-24 | AAXJ | ETF | 52.54 | 52.56 | 51.28 | 51.82 | 148900.0 |
| 2009-09-24 | ACWI | ETF | 41.07 | 41.26 | 40.25 | 40.46 | 218300.0 |
| 2009-09-24 | ACWX | ETF | 40.33 | 40.33 | 39.148 | 39.35 | 78813.0 |
| 2009-09-24 | ADRE | ETF | 40.88 | 40.89 | 39.62 | 39.95 | 131362.0 |
| 2009-09-24 | AFK | ETF | 29.17 | 29.22 | 28.75 | 28.84 | 9520.0 |
| 2009-09-24 | AGG | ETF | 104.39 | 104.59 | 104.33 | 104.48 | 459200.0 |
| 2009-09-24 | AGQ | ETF | 117.96 | 118.18 | 108.3 | 109.8 | 325150.0 |
| 2009-09-24 | AGZ | ETF | 108.4 | 108.45 | 108.11 | 108.45 | 11292.0 |
| 2009-09-24 | AIA | ETF | 38.59 | 38.59 | 37.51 | 37.75 | 32209.0 |
| 2009-09-24 | AIQ | ETF | 27.4 | 27.5 | 26.0 | 27.4 | 51780.0 |
| 2009-09-24 | AIS | ETF | 1.2 | 1.2 | 1.1 | 1.13 | 563875.0 |
| 2009-09-24 | AIVI | ETF | 42.78 | 43.09 | 41.81 | 42.01 | 27200.0 |
| 2009-09-24 | AMJ | ETF | 25.04 | 25.05 | 24.6455 | 24.79 | 715285.0 |
| 2009-09-24 | AOA | ETF | 29.17 | 29.18 | 28.66 | 28.71 | 47800.0 |
| 2009-09-24 | AOK | ETF | 27.02 | 27.1 | 26.99 | 27.1 | 7151.0 |
| 2009-09-24 | AOM | ETF | 28.02 | 28.02 | 27.5201 | 27.62 | 10330.0 |
| 2009-09-24 | AOR | ETF | 28.55 | 28.55 | 28.0 | 28.17 | 16648.0 |
| 2009-09-24 | ARB | ETF | 19.84 | 20.24 | 19.39 | 19.39 | 289945.0 |
| 2009-09-24 | BAL | ETF | 32.92 | 33.68 | 32.92 | 33.68 | 15800.0 |
| 2009-09-24 | BBH | ETF | 33.7967 | 34.0133 | 33.6433 | 33.9033 | 251700.0 |
| 2009-09-24 | BIL | ETF | 91.74 | 91.74 | 91.7 | 91.7 | 98950.0 |
| 2009-09-24 | BITS | ETF | 21.0404 | 22.08 | 21.0404 | 22.08 | 1800.0 |
| 2009-09-24 | BIV | ETF | 80.13 | 80.19 | 79.92 | 80.19 | 140900.0 |
| 2009-09-24 | BJK | ETF | 26.27 | 26.27 | 25.36 | 25.63 | 15800.0 |
| 2009-09-24 | BKF | ETF | 41.51 | 41.642 | 40.3 | 40.7 | 790588.0 |
| 2009-09-24 | BLV | ETF | 78.91 | 79.35 | 78.4 | 79.09 | 74500.0 |
| 2009-09-24 | BMVP | ETF | 12.05 | 12.05 | 11.87 | 11.91 | 37400.0 |
| 2009-09-24 | BND | ETF | 79.24 | 79.29 | 79.12 | 79.21 | 781200.0 |
| 2009-09-24 | BNE | ETF | 7.15 | 7.26 | 6.92 | 7.14 | 250465.0 |
| 2009-09-24 | BOSS | ETF | 20.21 | 20.21 | 19.89 | 20.21 | 100.0 |
| 2009-09-24 | BRF | ETF | 39.55 | 39.55 | 38.45 | 38.71 | 201529.0 |
| 2009-09-24 | BSV | ETF | 80.04 | 80.11 | 79.83 | 80.02 | 455800.0 |
| 2009-09-24 | BTF | ETF | 61.25 | 61.25 | 60.099999999999994 | 60.25 | 15068.800000000001 |
| 2009-09-24 | BWX | ETF | 29.23 | 29.2875 | 28.915 | 28.925 | 396982.0 |
| 2009-09-24 | BWZ | ETF | 37.39 | 37.4 | 37.135 | 37.15 | 30038.0 |
| 2009-09-24 | BZQ | ETF | 5752.0 | 5859.2 | 5752.0 | 5822.4 | 15.75 |
| 2009-09-24 | CEF | ETF | 13.06 | 13.1 | 12.56 | 12.68 | 1155300.0 |
| 2009-09-24 | CEW | ETF | 21.78 | 21.8 | 21.63 | 21.68 | 60099.0 |
| 2009-09-24 | CGO | ETF | 13.9 | 13.96 | 13.68 | 13.83 | 27166.0 |
| 2009-09-24 | CGW | ETF | 18.0 | 18.036 | 17.51 | 17.6863 | 61178.0 |
| 2009-09-24 | CHB | ETF | 0.57 | 0.58 | 0.4985 | 0.53 | 4743016.0 |
| 2009-09-24 | CHI | ETF | 11.81 | 11.9173 | 11.6 | 11.6 | 184378.0 |
| 2009-09-24 | CHIC | ETF | 17.48 | 17.48 | 17.47 | 17.47 | 250910.0 |
| 2009-09-24 | CHW | ETF | 7.79 | 7.855 | 7.6 | 7.67 | 138954.0 |
> showing 50 of 677 rows — these rows as CSV