PREVIEW / etf_daily / 2008-03-07
file: by_date/etf_daily/2008/2008-03-07.parquet size: 26 KB rows: 576
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-07 | SPY | ETF | 129.77 | 131.74 | 128.58 | 129.71 | 326434600.0 |
| 2008-03-07 | QQQ | ETF | 41.91 | 42.64 | 41.38 | 42.07 | 242552368.0 |
| 2008-03-07 | IWM | ETF | 65.36 | 66.84 | 65.2 | 65.96 | 119085300.0 |
| 2008-03-07 | DIA | ETF | 119.47 | 121.04 | 118.3 | 118.93 | 20097400.0 |
| 2008-03-07 | GLD | ETF | 96.6 | 96.68 | 95.72 | 96.09 | 10066900.0 |
| 2008-03-07 | TLT | ETF | 93.29 | 93.35 | 91.74 | 92.23 | 3601300.0 |
| 2008-03-07 | ADRE | ETF | 50.0 | 50.84 | 49.36 | 49.77 | 1153209.0 |
| 2008-03-07 | AGG | ETF | 101.88 | 101.93 | 101.22 | 101.6 | 1087600.0 |
| 2008-03-07 | AIA | ETF | 42.99 | 42.99 | 42.55 | 42.5699 | 900.0 |
| 2008-03-07 | AIQ | ETF | 47.3 | 48.95 | 46.95 | 47.8 | 42936.0 |
| 2008-03-07 | AIS | ETF | 1.01 | 1.02 | 0.98 | 1.02 | 382400.0 |
| 2008-03-07 | AIVI | ETF | 60.99 | 61.56 | 60.13 | 60.35 | 164100.0 |
| 2008-03-07 | ARB | ETF | 41.2 | 42.5 | 40.3 | 41.94 | 399300.0 |
| 2008-03-07 | BBH | ETF | 56.3167 | 56.8533 | 55.91 | 56.8533 | 1549200.0 |
| 2008-03-07 | BIL | ETF | 91.76 | 91.76 | 91.7 | 91.74 | 50300.0 |
| 2008-03-07 | BITS | ETF | 20.44 | 20.56 | 19.8 | 20.04 | 14029.0 |
| 2008-03-07 | BIV | ETF | 78.86 | 78.86 | 78.32 | 78.55 | 21600.0 |
| 2008-03-07 | BJK | ETF | 39.6 | 39.6 | 39.6 | 39.6 | 200.0 |
| 2008-03-07 | BKF | ETF | 50.24 | 51.4999 | 50.19 | 50.67 | 42600.0 |
| 2008-03-07 | BLV | ETF | 75.36 | 75.61 | 75.36 | 75.45 | 2600.0 |
| 2008-03-07 | BMVP | ETF | 15.35 | 15.5267 | 15.1433 | 15.3333 | 82683.0 |
| 2008-03-07 | BND | ETF | 76.94 | 77.13 | 76.5 | 76.92 | 142800.0 |
| 2008-03-07 | BNE | ETF | 12.97 | 13.51 | 12.87 | 13.14 | 133600.0 |
| 2008-03-07 | BRF | ETF | 14.62 | 14.67 | 14.59 | 14.64 | 20300.0 |
| 2008-03-07 | BSV | ETF | 79.03 | 79.03 | 78.59 | 78.6 | 69400.0 |
| 2008-03-07 | BTF | ETF | 101.99999999999999 | 103.1 | 101.14999999999999 | 101.99999999999999 | 7060.0 |
| 2008-03-07 | BWX | ETF | 28.45 | 28.5228 | 28.33 | 28.395 | 268818.0 |
| 2008-03-07 | CBON | ETF | 11.0 | 11.56 | 11.0 | 11.09 | 51586.0 |
| 2008-03-07 | CDL | ETF | 1.33 | 1.44 | 1.3 | 1.41 | 1421636.0 |
| 2008-03-07 | CEF | ETF | 13.89 | 13.98 | 13.64 | 13.66 | 712900.0 |
| 2008-03-07 | CGO | ETF | 15.97 | 16.024 | 15.94 | 15.99 | 9700.0 |
| 2008-03-07 | CGW | ETF | 23.0 | 23.42 | 22.85 | 23.05 | 70870.0 |
| 2008-03-07 | CHB | ETF | 8.03 | 8.62 | 7.94 | 8.27 | 2332908.0 |
| 2008-03-07 | CHI | ETF | 14.26 | 14.4199 | 14.2 | 14.39 | 110000.0 |
| 2008-03-07 | CHIC | ETF | 19.0 | 19.52 | 18.91 | 19.27 | 468386.0 |
| 2008-03-07 | CHW | ETF | 11.27 | 11.5 | 11.06 | 11.3 | 139113.0 |
| 2008-03-07 | CHY | ETF | 13.27 | 13.4 | 13.05 | 13.36 | 218253.0 |
| 2008-03-07 | CMF | ETF | 51.41 | 51.64 | 51.25 | 51.605 | 16400.0 |
| 2008-03-07 | CN | ETF | 58.99 | 60.1399 | 58.16 | 58.6 | 467222.0 |
| 2008-03-07 | CNXT | ETF | 0.455 | 0.4765 | 0.4492 | 0.45 | 2276484.0 |
| 2008-03-07 | COW | ETF | 43.03 | 43.05 | 42.58 | 42.91 | 58400.0 |
| 2008-03-07 | CPI | ETF | 19.0 | 19.0 | 19.0 | 19.0 | 200.0 |
| 2008-03-07 | CPST | ETF | 2.17 | 2.2 | 2.06 | 2.09 | 3061286.0 |
| 2008-03-07 | CSA | ETF | 15.11 | 15.31 | 14.9 | 14.97 | 167900.0 |
| 2008-03-07 | CSD | ETF | 22.1 | 22.54 | 22.03 | 22.27 | 60800.0 |
| 2008-03-07 | CSQ | ETF | 11.44 | 11.97 | 11.43 | 11.78 | 502853.0 |
| 2008-03-07 | CUT | ETF | 21.15 | 21.15 | 20.63 | 20.9 | 39300.0 |
| 2008-03-07 | CVY | ETF | 21.41 | 21.88 | 21.41 | 21.74 | 29100.0 |
| 2008-03-07 | CWI | ETF | 25.0267 | 25.0267 | 24.42 | 24.6267 | 43050.0 |
| 2008-03-07 | CZA | ETF | 23.06 | 23.06 | 23.06 | 23.06 | 1300.0 |
> showing 50 of 576 rows — these rows as CSV