PREVIEW / etf_daily / 2008-01-10
file: by_date/etf_daily/2008/2008-01-10.parquet size: 25 KB rows: 559
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-01-10 | SPY | ETF | 139.68 | 142.8 | 139.37 | 141.29 | 335701200.0 |
| 2008-01-10 | QQQ | ETF | 47.42 | 48.41 | 47.29 | 47.99 | 249963616.0 |
| 2008-01-10 | IWM | ETF | 70.11 | 72.32 | 69.86 | 71.7 | 153878400.0 |
| 2008-01-10 | DIA | ETF | 126.52 | 129.32 | 126.29 | 127.82 | 25310700.0 |
| 2008-01-10 | GLD | ETF | 86.42 | 88.46 | 86.41 | 88.25 | 12916300.0 |
| 2008-01-10 | TLT | ETF | 94.87 | 94.95 | 93.31 | 93.47 | 2681800.0 |
| 2008-01-10 | ADRE | ETF | 53.75 | 55.13 | 53.23 | 54.85 | 532315.0 |
| 2008-01-10 | AGG | ETF | 102.24 | 102.29 | 101.8 | 102.07 | 291900.0 |
| 2008-01-10 | AIA | ETF | 48.39 | 48.39 | 46.0 | 47.3 | 27400.0 |
| 2008-01-10 | AIQ | ETF | 47.3 | 49.25 | 47.25 | 48.75 | 34560.0 |
| 2008-01-10 | AIS | ETF | 1.02 | 1.02 | 0.96 | 0.98 | 143000.0 |
| 2008-01-10 | AIVI | ETF | 68.37 | 69.76 | 68.37 | 69.29 | 99900.0 |
| 2008-01-10 | ARB | ETF | 39.63 | 40.46 | 38.99 | 40.35 | 308500.0 |
| 2008-01-10 | BBH | ETF | 55.99 | 56.5267 | 53.3567 | 56.08 | 1220400.0 |
| 2008-01-10 | BIL | ETF | 91.62 | 91.64 | 91.54 | 91.58 | 12200.0 |
| 2008-01-10 | BITS | ETF | 21.52 | 22.8 | 21.44 | 22.8 | 10505.0 |
| 2008-01-10 | BIV | ETF | 79.18 | 79.18 | 77.88 | 78.06 | 44600.0 |
| 2008-01-10 | BKF | ETF | 58.66 | 60.452 | 58.18 | 60.452 | 37000.0 |
| 2008-01-10 | BLV | ETF | 77.6 | 77.6 | 76.72 | 76.95 | 5300.0 |
| 2008-01-10 | BMVP | ETF | 16.5367 | 16.7803 | 16.5133 | 16.69 | 42600.0 |
| 2008-01-10 | BND | ETF | 77.8 | 77.8 | 77.36 | 77.53 | 77400.0 |
| 2008-01-10 | BNE | ETF | 14.63 | 14.75 | 14.35 | 14.5 | 346400.0 |
| 2008-01-10 | BRF | ETF | 14.63 | 14.63 | 14.63 | 14.63 | 4600.0 |
| 2008-01-10 | BSV | ETF | 77.64 | 77.75 | 77.53 | 77.63 | 25700.0 |
| 2008-01-10 | BTF | ETF | 108.14999999999999 | 108.7495 | 107.14999999999999 | 108.7495 | 3280.0 |
| 2008-01-10 | BWX | ETF | 26.96 | 27.29 | 26.96 | 27.25 | 374600.0 |
| 2008-01-10 | CBON | ETF | 14.97 | 15.64 | 14.49 | 14.99 | 149373.0 |
| 2008-01-10 | CDL | ETF | 1.69 | 1.69 | 1.55 | 1.6 | 1857887.0 |
| 2008-01-10 | CEF | ETF | 11.01 | 11.43 | 10.92 | 11.38 | 811500.0 |
| 2008-01-10 | CGO | ETF | 18.78 | 19.1 | 18.65 | 19.1 | 20700.0 |
| 2008-01-10 | CGW | ETF | 25.3 | 25.3 | 24.7 | 25.13 | 54543.0 |
| 2008-01-10 | CHB | ETF | 7.9 | 8.45 | 7.8 | 8.1 | 1703000.0 |
| 2008-01-10 | CHI | ETF | 15.33 | 15.75 | 15.31 | 15.6001 | 214100.0 |
| 2008-01-10 | CHIC | ETF | 14.74 | 15.52 | 14.06 | 15.41 | 1199867.0 |
| 2008-01-10 | CHW | ETF | 12.78 | 13.14 | 12.66 | 13.02 | 197470.0 |
| 2008-01-10 | CHY | ETF | 13.82 | 14.08 | 13.75 | 14.0 | 192242.0 |
| 2008-01-10 | CMF | ETF | 52.75 | 52.755 | 52.65 | 52.65 | 65200.0 |
| 2008-01-10 | CN | ETF | 63.99 | 66.15 | 62.88 | 65.01 | 581590.0 |
| 2008-01-10 | CNXT | ETF | 0.58 | 0.63 | 0.56 | 0.59 | 7684264.0 |
| 2008-01-10 | COW | ETF | 46.1101 | 46.3 | 45.9 | 46.0 | 3600.0 |
| 2008-01-10 | CPST | ETF | 1.7 | 1.72 | 1.65 | 1.69 | 3057101.0 |
| 2008-01-10 | CSA | ETF | 15.56 | 15.97 | 15.56 | 15.83 | 29200.0 |
| 2008-01-10 | CSD | ETF | 24.46 | 25.15 | 24.46 | 25.08 | 35400.0 |
| 2008-01-10 | CSQ | ETF | 13.85 | 14.09 | 13.68 | 14.09 | 271700.0 |
| 2008-01-10 | CUT | ETF | 22.1 | 22.82 | 22.1 | 22.82 | 46400.0 |
| 2008-01-10 | CVY | ETF | 21.93 | 22.52 | 21.93 | 22.37 | 11400.0 |
| 2008-01-10 | CWI | ETF | 26.56 | 27.0067 | 26.5533 | 26.8933 | 61650.0 |
| 2008-01-10 | DBA | ETF | 34.71 | 34.71 | 34.08 | 34.5 | 1856200.0 |
| 2008-01-10 | DBB | ETF | 22.93 | 23.23 | 22.68 | 23.16 | 32400.0 |
| 2008-01-10 | DBC | ETF | 31.65 | 31.7599 | 31.4 | 31.72 | 453700.0 |
> showing 50 of 559 rows — these rows as CSV