PREVIEW / etf_daily / 2008-11-14
file: by_date/etf_daily/2008/2008-11-14.parquet size: 27 KB rows: 615
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-11-14 | SPY | ETF | 89.41 | 92.06 | 86.52 | 86.62 | 540352300.0 |
| 2008-11-14 | QQQ | ETF | 29.8 | 30.42 | 28.87 | 28.98 | 259407099.0 |
| 2008-11-14 | IWM | ETF | 48.23 | 49.31 | 45.5 | 45.64 | 98697500.0 |
| 2008-11-14 | DIA | ETF | 86.99 | 89.49 | 84.22 | 84.22 | 45085800.0 |
| 2008-11-14 | GLD | ETF | 73.39 | 74.26 | 72.76 | 73.3 | 12808600.0 |
| 2008-11-14 | TLT | ETF | 95.11 | 95.46 | 94.79 | 95.17 | 1059300.0 |
| 2008-11-14 | AAXJ | ETF | 31.2 | 32.9 | 30.2 | 30.45 | 575100.0 |
| 2008-11-14 | ACWI | ETF | 30.76 | 31.61 | 30.22 | 30.34 | 103400.0 |
| 2008-11-14 | ACWX | ETF | 28.74 | 29.008 | 27.43 | 27.86 | 47079.0 |
| 2008-11-14 | ADRE | ETF | 27.23 | 27.23 | 24.714 | 24.75 | 421624.0 |
| 2008-11-14 | AFK | ETF | 22.16 | 22.3 | 21.99 | 22.26 | 18110.0 |
| 2008-11-14 | AGG | ETF | 97.0 | 97.0 | 96.32 | 96.98 | 546100.0 |
| 2008-11-14 | AGZ | ETF | 103.37 | 103.37 | 102.88 | 102.88 | 300.0 |
| 2008-11-14 | AIA | ETF | 23.88 | 24.4799 | 23.2201 | 24.22 | 9639.0 |
| 2008-11-14 | AIQ | ETF | 43.45 | 45.0 | 42.65 | 43.6 | 43555.0 |
| 2008-11-14 | AIS | ETF | 0.48 | 0.51 | 0.43 | 0.48 | 41300.0 |
| 2008-11-14 | AIVI | ETF | 35.01 | 35.41 | 34.0 | 35.0 | 9200.0 |
| 2008-11-14 | AOA | ETF | 23.01 | 23.15 | 23.01 | 23.01 | 2000.0 |
| 2008-11-14 | AOK | ETF | 25.09 | 25.09 | 25.09 | 25.09 | 134.0 |
| 2008-11-14 | AOR | ETF | 23.8 | 23.86 | 23.73 | 23.86 | 1220.0 |
| 2008-11-14 | ARB | ETF | 27.21 | 27.21 | 25.09 | 25.11 | 316940.0 |
| 2008-11-14 | BAL | ETF | 24.64 | 24.64 | 24.64 | 24.64 | 200.0 |
| 2008-11-14 | BBH | ETF | 57.7 | 58.2767 | 56.84 | 56.9033 | 687000.0 |
| 2008-11-14 | BIL | ETF | 91.94 | 91.94 | 91.84 | 91.9 | 132200.0 |
| 2008-11-14 | BITS | ETF | 14.68 | 15.76 | 14.2 | 14.76 | 29749.0 |
| 2008-11-14 | BIV | ETF | 72.31 | 72.61 | 72.23 | 72.61 | 33000.0 |
| 2008-11-14 | BJK | ETF | 16.58 | 16.58 | 15.73 | 15.73 | 800.0 |
| 2008-11-14 | BKF | ETF | 23.44 | 24.22 | 22.65 | 22.65 | 109328.0 |
| 2008-11-14 | BLV | ETF | 68.03 | 68.26 | 67.91 | 68.21 | 10600.0 |
| 2008-11-14 | BMVP | ETF | 10.4 | 10.67 | 10.18 | 10.18 | 25962.0 |
| 2008-11-14 | BND | ETF | 74.68 | 74.9 | 74.31 | 74.81 | 297400.0 |
| 2008-11-14 | BNE | ETF | 3.42 | 3.5 | 2.6 | 2.96 | 443836.0 |
| 2008-11-14 | BRF | ETF | 14.91 | 14.93 | 14.9 | 14.9 | 5400.0 |
| 2008-11-14 | BSV | ETF | 77.45 | 77.45 | 76.75 | 77.34 | 63800.0 |
| 2008-11-14 | BTF | ETF | 52.5 | 52.949999999999996 | 48.205499999999994 | 48.75 | 63872.4 |
| 2008-11-14 | BWX | ETF | 24.73 | 24.745 | 24.45 | 24.675 | 131430.0 |
| 2008-11-14 | CBON | ETF | 2.89 | 3.37 | 2.8 | 2.8 | 85116.0 |
| 2008-11-14 | CDL | ETF | 0.22 | 0.22 | 0.17 | 0.18 | 694867.0 |
| 2008-11-14 | CEF | ETF | 8.81 | 9.24 | 8.61 | 9.05 | 793400.0 |
| 2008-11-14 | CGO | ETF | 8.62 | 9.11 | 8.3 | 8.78 | 54703.0 |
| 2008-11-14 | CGW | ETF | 14.16 | 15.184 | 14.16 | 14.5 | 54276.0 |
| 2008-11-14 | CHB | ETF | 0.79 | 0.91 | 0.4798 | 0.6 | 5003030.0 |
| 2008-11-14 | CHI | ETF | 7.51 | 7.5181 | 7.13 | 7.25 | 185934.0 |
| 2008-11-14 | CHIC | ETF | 7.86 | 8.09 | 5.84 | 6.36 | 796114.0 |
| 2008-11-14 | CHW | ETF | 5.42 | 5.67 | 5.31 | 5.63 | 228960.0 |
| 2008-11-14 | CHY | ETF | 7.1 | 7.28 | 6.9 | 6.96 | 330763.0 |
| 2008-11-14 | CMF | ETF | 51.0 | 51.04 | 50.6155 | 50.9675 | 10952.0 |
| 2008-11-14 | CNXT | ETF | 1.14 | 1.15 | 1.1 | 1.14 | 252342.0 |
| 2008-11-14 | COW | ETF | 35.7 | 35.7 | 35.0 | 35.13 | 11575.0 |
| 2008-11-14 | CPST | ETF | 1.08 | 1.08 | 0.96 | 1.0 | 1714800.0 |
> showing 50 of 615 rows — these rows as CSV