PREVIEW / etf_daily / 2008-10-20
file: by_date/etf_daily/2008/2008-10-20.parquet size: 27 KB rows: 606
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-10-20 | SPY | ETF | 95.35 | 99.1 | 94.09 | 98.81 | 321294200.0 |
| 2008-10-20 | QQQ | ETF | 32.79 | 33.26 | 31.7 | 33.2 | 232783304.0 |
| 2008-10-20 | IWM | ETF | 53.25 | 54.71 | 52.46 | 54.69 | 82673400.0 |
| 2008-10-20 | DIA | ETF | 89.48 | 93.28 | 88.74 | 93.28 | 34524100.0 |
| 2008-10-20 | GLD | ETF | 77.77 | 78.56 | 77.27 | 78.5 | 9331900.0 |
| 2008-10-20 | TLT | ETF | 93.44 | 94.94 | 93.36 | 94.62 | 1146800.0 |
| 2008-10-20 | AAXJ | ETF | 33.6 | 34.58 | 33.4 | 34.5 | 127200.0 |
| 2008-10-20 | ACWI | ETF | 33.19 | 34.67 | 33.19 | 34.67 | 65600.0 |
| 2008-10-20 | ACWX | ETF | 31.4 | 32.601 | 31.39 | 32.601 | 47823.0 |
| 2008-10-20 | ADRE | ETF | 28.75 | 29.31 | 27.42 | 29.31 | 338583.0 |
| 2008-10-20 | AFK | ETF | 25.16 | 25.3 | 25.16 | 25.3 | 400.0 |
| 2008-10-20 | AGG | ETF | 94.89 | 96.16 | 94.41 | 95.77 | 537600.0 |
| 2008-10-20 | AIA | ETF | 27.09 | 28.12 | 26.65 | 28.12 | 58778.0 |
| 2008-10-20 | AIQ | ETF | 40.9 | 42.5 | 39.75 | 42.15 | 37925.0 |
| 2008-10-20 | AIS | ETF | 0.47 | 0.52 | 0.47 | 0.5 | 32100.0 |
| 2008-10-20 | AIVI | ETF | 39.58 | 41.14 | 39.58 | 41.14 | 29900.0 |
| 2008-10-20 | ARB | ETF | 36.24 | 37.32 | 35.92 | 37.0 | 338708.0 |
| 2008-10-20 | BAL | ETF | 32.76 | 32.76 | 30.6199 | 30.62 | 2300.0 |
| 2008-10-20 | BBH | ETF | 55.3367 | 57.25 | 54.73 | 57.25 | 541800.0 |
| 2008-10-20 | BIL | ETF | 91.64 | 91.88 | 91.64 | 91.86 | 145050.0 |
| 2008-10-20 | BITS | ETF | 17.0 | 17.12 | 16.2 | 17.12 | 796.0 |
| 2008-10-20 | BIV | ETF | 71.18 | 71.19 | 70.27 | 71.19 | 35300.0 |
| 2008-10-20 | BJK | ETF | 17.21 | 18.75 | 17.21 | 18.01 | 2900.0 |
| 2008-10-20 | BKF | ETF | 25.22 | 26.7 | 25.22 | 26.7 | 58099.0 |
| 2008-10-20 | BLV | ETF | 66.5 | 66.96 | 66.3 | 66.82 | 10400.0 |
| 2008-10-20 | BMVP | ETF | 10.75 | 11.14 | 10.65 | 11.14 | 10148.0 |
| 2008-10-20 | BND | ETF | 73.24 | 74.19 | 73.2 | 73.71 | 219900.0 |
| 2008-10-20 | BNE | ETF | 6.48 | 6.64 | 6.0 | 6.63 | 87848.0 |
| 2008-10-20 | BOSS | ETF | 14.4 | 14.4 | 14.4 | 14.4 | 100.0 |
| 2008-10-20 | BRF | ETF | 14.79 | 14.79 | 14.75 | 14.79 | 11385.0 |
| 2008-10-20 | BSV | ETF | 74.02 | 74.6 | 73.87 | 74.6 | 105700.0 |
| 2008-10-20 | BTF | ETF | 71.85 | 72.35 | 66.64999999999999 | 70.323 | 73037.8 |
| 2008-10-20 | BWX | ETF | 25.25 | 25.84 | 24.685 | 25.095 | 125624.0 |
| 2008-10-20 | CBON | ETF | 3.57 | 3.93 | 3.57 | 3.86 | 57055.0 |
| 2008-10-20 | CDL | ETF | 0.28 | 0.28 | 0.23 | 0.24 | 975558.0 |
| 2008-10-20 | CEF | ETF | 9.2 | 9.49 | 9.15 | 9.37 | 958400.0 |
| 2008-10-20 | CGO | ETF | 9.8 | 10.15 | 9.79 | 10.13 | 43556.0 |
| 2008-10-20 | CGW | ETF | 18.12 | 18.12 | 16.06 | 16.62 | 72909.0 |
| 2008-10-20 | CHB | ETF | 3.5 | 3.72 | 3.39 | 3.67 | 876188.0 |
| 2008-10-20 | CHI | ETF | 9.14 | 9.52 | 8.89 | 9.46 | 274949.0 |
| 2008-10-20 | CHIC | ETF | 8.17 | 8.84 | 7.64 | 7.87 | 410984.0 |
| 2008-10-20 | CHW | ETF | 6.51 | 6.51 | 6.21 | 6.45 | 164036.0 |
| 2008-10-20 | CHY | ETF | 8.71 | 9.04 | 8.71 | 8.85 | 330614.0 |
| 2008-10-20 | CMF | ETF | 46.27 | 47.0 | 46.27 | 47.0 | 25782.0 |
| 2008-10-20 | CNXT | ETF | 2.7 | 2.78 | 2.58 | 2.6 | 293214.0 |
| 2008-10-20 | COW | ETF | 36.07 | 36.19 | 35.85 | 35.92 | 49990.0 |
| 2008-10-20 | CPI | ETF | 22.5 | 23.5 | 22.5 | 23.5 | 1100.0 |
| 2008-10-20 | CPST | ETF | 1.4 | 1.42 | 1.35 | 1.39 | 1434195.0 |
| 2008-10-20 | CSA | ETF | 13.28 | 13.28 | 12.62 | 13.14 | 82713.0 |
| 2008-10-20 | CSB | ETF | 15.09 | 15.2 | 14.5 | 14.75 | 28898.0 |
> showing 50 of 606 rows — these rows as CSV