PREVIEW / etf_daily / 2009-01-06
file: by_date/etf_daily/2009/2009-01-06.parquet size: 28 KB rows: 631
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-01-06 | SPY | ETF | 93.64 | 94.45 | 92.68 | 93.47 | 328260900.0 |
| 2009-01-06 | QQQ | ETF | 31.28 | 31.63 | 31.11 | 31.33 | 136819993.0 |
| 2009-01-06 | IWM | ETF | 50.82 | 51.91 | 50.38 | 51.25 | 77980800.0 |
| 2009-01-06 | DIA | ETF | 90.18 | 90.9 | 89.38 | 90.15 | 37258400.0 |
| 2009-01-06 | GLD | ETF | 83.37 | 85.7 | 83.0 | 85.13 | 12864600.0 |
| 2009-01-06 | TLT | ETF | 111.62 | 113.26 | 111.0 | 112.21 | 4109300.0 |
| 2009-01-06 | AAXJ | ETF | 35.66 | 36.28 | 35.66 | 36.09 | 145100.0 |
| 2009-01-06 | ACWI | ETF | 33.34 | 33.63 | 33.03 | 33.4 | 252900.0 |
| 2009-01-06 | ACWX | ETF | 31.36 | 31.81 | 31.15 | 31.57 | 274772.0 |
| 2009-01-06 | ADRE | ETF | 29.95 | 30.306 | 29.6 | 30.19 | 259835.0 |
| 2009-01-06 | AFK | ETF | 22.21 | 22.21 | 22.21 | 22.21 | 200.0 |
| 2009-01-06 | AGG | ETF | 104.74 | 104.87 | 103.41 | 104.61 | 670200.0 |
| 2009-01-06 | AGQ | ETF | 61.62 | 65.52 | 60.66 | 64.6 | 61700.0 |
| 2009-01-06 | AGZ | ETF | 107.46 | 107.6 | 107.24 | 107.6 | 832.0 |
| 2009-01-06 | AIA | ETF | 26.5 | 27.65 | 26.5 | 27.05 | 23689.0 |
| 2009-01-06 | AIQ | ETF | 40.5 | 42.1 | 40.25 | 41.25 | 102925.0 |
| 2009-01-06 | AIS | ETF | 0.47 | 0.47 | 0.41 | 0.41 | 54699.0 |
| 2009-01-06 | AIVI | ETF | 34.68 | 34.74 | 34.03 | 34.55 | 39100.0 |
| 2009-01-06 | AOA | ETF | 24.1 | 24.98 | 24.1 | 24.84 | 7400.0 |
| 2009-01-06 | AOK | ETF | 25.66 | 25.74 | 25.533 | 25.533 | 2290.0 |
| 2009-01-06 | AOM | ETF | 25.59 | 25.67 | 25.39 | 25.67 | 7559.0 |
| 2009-01-06 | AOR | ETF | 25.12 | 25.17 | 24.11 | 25.1 | 2800.0 |
| 2009-01-06 | ARB | ETF | 14.05 | 14.41 | 13.66 | 14.24 | 290754.0 |
| 2009-01-06 | BBH | ETF | 58.3467 | 58.4733 | 57.23 | 57.47 | 123000.0 |
| 2009-01-06 | BIL | ETF | 91.6 | 91.68 | 91.6 | 91.62 | 94200.0 |
| 2009-01-06 | BITS | ETF | 19.84 | 19.88 | 19.0 | 19.84 | 1475.0 |
| 2009-01-06 | BIV | ETF | 78.15 | 78.3 | 77.44 | 78.13 | 78700.0 |
| 2009-01-06 | BJK | ETF | 18.83 | 19.76 | 18.5 | 18.5 | 3900.0 |
| 2009-01-06 | BKF | ETF | 27.62 | 27.9099 | 26.8981 | 27.52 | 74062.0 |
| 2009-01-06 | BLV | ETF | 77.25 | 77.25 | 75.99 | 76.85 | 35800.0 |
| 2009-01-06 | BMVP | ETF | 11.177 | 11.29 | 11.096 | 11.14 | 72463.0 |
| 2009-01-06 | BND | ETF | 78.23 | 78.23 | 77.49 | 77.85 | 449700.0 |
| 2009-01-06 | BNE | ETF | 5.87 | 6.74 | 5.79 | 6.47 | 144863.0 |
| 2009-01-06 | BSV | ETF | 79.8 | 80.3 | 79.5 | 80.28 | 143900.0 |
| 2009-01-06 | BTF | ETF | 54.24999999999999 | 55.65 | 54.199999999999996 | 55.519999999999996 | 13725.2 |
| 2009-01-06 | BWX | ETF | 26.3 | 26.325 | 26.035 | 26.15 | 439336.0 |
| 2009-01-06 | CBON | ETF | 3.06 | 3.2175 | 3.06 | 3.15 | 104719.0 |
| 2009-01-06 | CDL | ETF | 0.19 | 0.22 | 0.18 | 0.2 | 893593.0 |
| 2009-01-06 | CEF | ETF | 10.4 | 10.78 | 10.4 | 10.7 | 775400.0 |
| 2009-01-06 | CGO | ETF | 10.48 | 11.05 | 10.2228 | 10.6 | 71655.0 |
| 2009-01-06 | CGW | ETF | 14.82 | 14.93 | 14.48 | 14.77 | 42733.0 |
| 2009-01-06 | CHB | ETF | 0.67 | 0.78 | 0.67 | 0.72 | 560192.0 |
| 2009-01-06 | CHI | ETF | 9.1 | 9.2 | 8.84 | 9.0 | 485746.0 |
| 2009-01-06 | CHIC | ETF | 6.27 | 6.74 | 6.23 | 6.59 | 328270.0 |
| 2009-01-06 | CHW | ETF | 6.35 | 6.35 | 6.17 | 6.26 | 274372.0 |
| 2009-01-06 | CHY | ETF | 8.9 | 9.16 | 8.75 | 9.08 | 450460.0 |
| 2009-01-06 | CMF | ETF | 51.085 | 51.485 | 50.775 | 51.355 | 12044.0 |
| 2009-01-06 | CNXT | ETF | 0.79 | 0.84 | 0.77 | 0.83 | 949118.0 |
| 2009-01-06 | COW | ETF | 34.53 | 34.91 | 34.48 | 34.91 | 6415.0 |
| 2009-01-06 | CPST | ETF | 1.1 | 1.1 | 1.05 | 1.06 | 2059465.0 |
> showing 50 of 631 rows — these rows as CSV