PREVIEW / etf_daily / 2009-08-21
file: by_date/etf_daily/2009/2009-08-21.parquet size: 29 KB rows: 671
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-08-21 | SPY | ETF | 101.82 | 103.13 | 101.62 | 102.97 | 224605000.0 |
| 2009-08-21 | QQQ | ETF | 40.01 | 40.36 | 39.74 | 40.29 | 114660175.0 |
| 2009-08-21 | IWM | ETF | 57.44 | 58.39 | 57.37 | 58.15 | 38321700.0 |
| 2009-08-21 | DIA | ETF | 93.98 | 95.21 | 93.9 | 95.03 | 11866500.0 |
| 2009-08-21 | GLD | ETF | 93.63 | 93.8 | 93.4 | 93.65 | 7285300.0 |
| 2009-08-21 | TLT | ETF | 95.64 | 95.73 | 93.75 | 93.77 | 6258300.0 |
| 2009-08-21 | AAXJ | ETF | 49.24 | 49.25 | 48.74 | 49.23 | 121400.0 |
| 2009-08-21 | ACWI | ETF | 38.75 | 39.2 | 38.75 | 39.14 | 76100.0 |
| 2009-08-21 | ACWX | ETF | 37.71 | 38.04 | 37.698 | 37.97 | 51270.0 |
| 2009-08-21 | ADRE | ETF | 38.75 | 38.994 | 38.568 | 38.8005 | 122857.0 |
| 2009-08-21 | AFK | ETF | 27.34 | 27.5599 | 27.32 | 27.5 | 10096.0 |
| 2009-08-21 | AGG | ETF | 103.63 | 103.66 | 103.0 | 103.0 | 504900.0 |
| 2009-08-21 | AGQ | ETF | 85.7 | 86.26 | 84.34 | 85.16 | 106350.0 |
| 2009-08-21 | AGZ | ETF | 107.5 | 107.5 | 107.03 | 107.17 | 42189.0 |
| 2009-08-21 | AIA | ETF | 36.0 | 36.26 | 35.83 | 36.26 | 52108.0 |
| 2009-08-21 | AIQ | ETF | 25.95 | 26.0 | 25.65 | 25.9 | 125896.0 |
| 2009-08-21 | AIS | ETF | 0.97 | 1.0 | 0.9301 | 0.96 | 260497.0 |
| 2009-08-21 | AIVI | ETF | 40.19 | 40.71 | 40.19 | 40.52 | 30700.0 |
| 2009-08-21 | AMJ | ETF | 24.48 | 24.65 | 24.3995 | 24.6 | 101053.0 |
| 2009-08-21 | AOA | ETF | 28.0 | 28.0 | 27.79 | 27.98 | 6200.0 |
| 2009-08-21 | AOK | ETF | 26.7 | 26.7 | 26.52 | 26.68 | 4968.0 |
| 2009-08-21 | AOM | ETF | 27.12 | 27.79 | 26.99 | 27.17 | 9587.0 |
| 2009-08-21 | AOR | ETF | 27.61 | 27.61 | 27.5439 | 27.59 | 5152.0 |
| 2009-08-21 | ARB | ETF | 17.61 | 17.97 | 17.48 | 17.53 | 276365.0 |
| 2009-08-21 | BAL | ETF | 30.84 | 30.84 | 30.5 | 30.5 | 1700.0 |
| 2009-08-21 | BBH | ETF | 33.59 | 33.8567 | 33.3867 | 33.52 | 438600.0 |
| 2009-08-21 | BIL | ETF | 91.7 | 91.72 | 91.7 | 91.7 | 176100.0 |
| 2009-08-21 | BITS | ETF | 21.4 | 21.8 | 20.84 | 21.64 | 2675.0 |
| 2009-08-21 | BIV | ETF | 79.14 | 79.17 | 78.51 | 78.56 | 141800.0 |
| 2009-08-21 | BJK | ETF | 23.48 | 25.12 | 23.44 | 23.71 | 34800.0 |
| 2009-08-21 | BKF | ETF | 38.64 | 39.0 | 38.4239 | 38.97 | 191295.0 |
| 2009-08-21 | BLV | ETF | 77.4 | 77.4 | 76.4 | 76.4 | 22700.0 |
| 2009-08-21 | BMVP | ETF | 11.7 | 11.833 | 11.687 | 11.819 | 22174.0 |
| 2009-08-21 | BND | ETF | 78.6 | 78.73 | 78.29 | 78.42 | 705500.0 |
| 2009-08-21 | BNE | ETF | 6.0 | 6.15 | 6.0 | 6.09 | 301327.0 |
| 2009-08-21 | BOSS | ETF | 19.5 | 19.5 | 19.5 | 19.5 | 100.0 |
| 2009-08-21 | BRF | ETF | 36.68 | 38.12 | 36.62 | 37.27 | 257453.0 |
| 2009-08-21 | BSV | ETF | 79.65 | 79.65 | 79.36 | 79.47 | 336300.0 |
| 2009-08-21 | BTF | ETF | 57.99999999999999 | 58.65 | 57.72 | 58.49999999999999 | 5281.8 |
| 2009-08-21 | BWX | ETF | 28.35 | 28.45 | 28.095 | 28.295 | 600806.0 |
| 2009-08-21 | BWZ | ETF | 36.17 | 36.17 | 36.035 | 36.13 | 10795.0 |
| 2009-08-21 | BZQ | ETF | 6737.6 | 6737.6 | 6571.2 | 6600.0 | 44.5 |
| 2009-08-21 | CEF | ETF | 12.1 | 12.18 | 12.06 | 12.15 | 775100.0 |
| 2009-08-21 | CEW | ETF | 21.42 | 21.47 | 21.388 | 21.4455 | 31201.0 |
| 2009-08-21 | CGO | ETF | 12.98 | 13.2 | 12.98 | 13.08 | 46787.0 |
| 2009-08-21 | CGW | ETF | 16.6 | 16.92 | 16.59 | 16.89 | 94504.0 |
| 2009-08-21 | CHB | ETF | 0.42 | 0.5789 | 0.4 | 0.49 | 5667277.0 |
| 2009-08-21 | CHI | ETF | 11.22 | 11.31 | 11.08 | 11.2101 | 134893.0 |
| 2009-08-21 | CHIC | ETF | 14.17 | 14.17 | 13.38 | 13.79 | 446111.0 |
| 2009-08-21 | CHW | ETF | 7.4 | 7.49 | 7.37 | 7.39 | 146024.0 |
> showing 50 of 671 rows — these rows as CSV