PREVIEW / etf_daily / 2008-03-10
file: by_date/etf_daily/2008/2008-03-10.parquet size: 26 KB rows: 575
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-10 | SPY | ETF | 129.84 | 129.93 | 127.59 | 128.0 | 235683600.0 |
| 2008-03-10 | QQQ | ETF | 42.01 | 42.14 | 41.17 | 41.26 | 146964132.0 |
| 2008-03-10 | IWM | ETF | 66.02 | 66.06 | 64.1 | 64.5 | 82737100.0 |
| 2008-03-10 | DIA | ETF | 119.29 | 119.31 | 117.46 | 117.98 | 17788000.0 |
| 2008-03-10 | GLD | ETF | 95.0 | 96.34 | 94.88 | 95.87 | 10868400.0 |
| 2008-03-10 | TLT | ETF | 92.71 | 94.13 | 92.61 | 93.59 | 3579000.0 |
| 2008-03-10 | ADRE | ETF | 49.86 | 50.13 | 48.35 | 48.62 | 443076.0 |
| 2008-03-10 | AGG | ETF | 101.89 | 102.2 | 101.74 | 102.14 | 444500.0 |
| 2008-03-10 | AIA | ETF | 42.62 | 42.62 | 42.0 | 42.13 | 7000.0 |
| 2008-03-10 | AIQ | ETF | 48.05 | 48.25 | 44.3 | 44.6 | 69860.0 |
| 2008-03-10 | AIS | ETF | 1.05 | 1.05 | 0.97 | 1.0 | 109700.0 |
| 2008-03-10 | AIVI | ETF | 61.08 | 61.33 | 59.95 | 60.04 | 444100.0 |
| 2008-03-10 | ARB | ETF | 42.16 | 42.93 | 41.65 | 42.2 | 312404.0 |
| 2008-03-10 | BBH | ETF | 56.6 | 56.7467 | 55.4233 | 55.5333 | 240300.0 |
| 2008-03-10 | BIL | ETF | 91.74 | 91.8 | 91.68 | 91.74 | 22300.0 |
| 2008-03-10 | BITS | ETF | 20.2 | 20.2 | 19.4 | 19.56 | 6062.0 |
| 2008-03-10 | BIV | ETF | 78.62 | 79.26 | 78.62 | 78.95 | 25700.0 |
| 2008-03-10 | BKF | ETF | 50.8 | 51.26 | 49.1001 | 49.453 | 30700.0 |
| 2008-03-10 | BLV | ETF | 75.61 | 76.22 | 75.34 | 75.95 | 13200.0 |
| 2008-03-10 | BMVP | ETF | 15.337 | 15.375 | 15.163 | 15.177 | 82300.0 |
| 2008-03-10 | BND | ETF | 77.1 | 77.24 | 76.88 | 77.15 | 71100.0 |
| 2008-03-10 | BNE | ETF | 13.2 | 13.21 | 12.94 | 12.97 | 129400.0 |
| 2008-03-10 | BRF | ETF | 14.64 | 14.6699 | 14.63 | 14.6699 | 7500.0 |
| 2008-03-10 | BSV | ETF | 78.89 | 79.06 | 78.72 | 78.89 | 65000.0 |
| 2008-03-10 | BTF | ETF | 102.05 | 102.05 | 99.25 | 99.64999999999999 | 10120.0 |
| 2008-03-10 | BWX | ETF | 28.44 | 28.47 | 28.37 | 28.445 | 462022.0 |
| 2008-03-10 | CBON | ETF | 11.11 | 11.5 | 11.07 | 11.18 | 75795.0 |
| 2008-03-10 | CDL | ETF | 1.42 | 1.6 | 1.36 | 1.46 | 1925769.0 |
| 2008-03-10 | CEF | ETF | 13.5 | 13.61 | 13.23 | 13.49 | 790900.0 |
| 2008-03-10 | CGO | ETF | 16.0 | 16.0699 | 15.5 | 15.57 | 20800.0 |
| 2008-03-10 | CGW | ETF | 22.95 | 23.34 | 22.7 | 22.71 | 110399.0 |
| 2008-03-10 | CHB | ETF | 8.11 | 8.54 | 8.02 | 8.16 | 1792495.0 |
| 2008-03-10 | CHI | ETF | 14.2 | 14.3538 | 13.564 | 13.5999 | 205857.0 |
| 2008-03-10 | CHIC | ETF | 19.3 | 19.44 | 18.62 | 18.71 | 433998.0 |
| 2008-03-10 | CHW | ETF | 11.25 | 11.27 | 10.72 | 10.9 | 228372.0 |
| 2008-03-10 | CHY | ETF | 13.31 | 13.31 | 12.31 | 12.3799 | 265686.0 |
| 2008-03-10 | CMF | ETF | 51.65 | 51.75 | 51.6401 | 51.695 | 9000.0 |
| 2008-03-10 | CN | ETF | 61.0 | 61.96 | 59.62 | 59.78 | 464430.0 |
| 2008-03-10 | CNXT | ETF | 0.45 | 0.468 | 0.4 | 0.42 | 3673722.0 |
| 2008-03-10 | COW | ETF | 43.17 | 43.17 | 42.57 | 42.8 | 220300.0 |
| 2008-03-10 | CPI | ETF | 19.4 | 19.4 | 19.24 | 19.24 | 800.0 |
| 2008-03-10 | CPST | ETF | 2.05 | 2.11 | 1.87 | 1.88 | 4671189.0 |
| 2008-03-10 | CSA | ETF | 15.04 | 15.17 | 14.95 | 15.07 | 105900.0 |
| 2008-03-10 | CSD | ETF | 22.09 | 22.25 | 21.8 | 21.8 | 31500.0 |
| 2008-03-10 | CSQ | ETF | 11.67 | 11.75 | 11.42 | 11.56 | 380779.0 |
| 2008-03-10 | CUT | ETF | 20.5 | 21.09 | 20.2 | 20.32 | 37500.0 |
| 2008-03-10 | CVY | ETF | 21.69 | 21.74 | 21.08 | 21.08 | 22000.0 |
| 2008-03-10 | CWI | ETF | 24.4333 | 24.6867 | 24.2267 | 24.28 | 97500.0 |
| 2008-03-10 | DBA | ETF | 39.24 | 40.85 | 38.56 | 40.48 | 5076100.0 |
| 2008-03-10 | DBB | ETF | 26.5 | 26.59 | 24.8 | 26.05 | 523600.0 |
> showing 50 of 575 rows — these rows as CSV