PREVIEW / etf_daily / 2008-10-03
file: by_date/etf_daily/2008/2008-10-03.parquet size: 27 KB rows: 608
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-03 | SPY | ETF | 112.86 | 115.45 | 109.68 | 110.34 | 461798000.0 |
| 2008-10-03 | QQQ | ETF | 37.26 | 38.18 | 36.1 | 36.18 | 272144023.0 |
| 2008-10-03 | IWM | ETF | 64.36 | 65.64 | 61.73 | 62.7 | 118870500.0 |
| 2008-10-03 | DIA | ETF | 105.75 | 107.94 | 103.09 | 103.2 | 30183100.0 |
| 2008-10-03 | GLD | ETF | 81.23 | 83.44 | 81.05 | 82.59 | 24055400.0 |
| 2008-10-03 | TLT | ETF | 97.38 | 97.79 | 95.49 | 97.4 | 1903100.0 |
| 2008-10-03 | AAXJ | ETF | 40.62 | 40.63 | 40.17 | 40.17 | 3000.0 |
| 2008-10-03 | ACWI | ETF | 39.7 | 41.24 | 38.81 | 39.0 | 124600.0 |
| 2008-10-03 | ACWX | ETF | 38.42 | 38.82 | 37.37 | 37.386 | 13827.0 |
| 2008-10-03 | ADRE | ETF | 34.77 | 35.9999 | 33.45 | 33.48 | 552163.0 |
| 2008-10-03 | AFK | ETF | 30.1 | 30.1 | 28.75 | 29.27 | 3260.0 |
| 2008-10-03 | AGG | ETF | 98.22 | 98.62 | 96.86 | 98.62 | 501200.0 |
| 2008-10-03 | AIA | ETF | 32.2 | 32.9 | 31.724 | 31.724 | 5798.0 |
| 2008-10-03 | AIQ | ETF | 50.7 | 50.9 | 49.35 | 49.5 | 67061.0 |
| 2008-10-03 | AIS | ETF | 0.65 | 0.69 | 0.6 | 0.69 | 37099.0 |
| 2008-10-03 | AIVI | ETF | 49.5 | 51.0 | 48.84 | 48.95 | 38400.0 |
| 2008-10-03 | ARB | ETF | 42.77 | 42.97 | 40.07 | 40.33 | 500952.0 |
| 2008-10-03 | BBH | ETF | 60.5 | 61.74 | 60.04 | 60.2667 | 387900.0 |
| 2008-10-03 | BIL | ETF | 91.82 | 92.0 | 91.8 | 91.96 | 201500.0 |
| 2008-10-03 | BITS | ETF | 21.88 | 21.88 | 20.0404 | 20.68 | 2112.0 |
| 2008-10-03 | BIV | ETF | 73.72 | 74.51 | 73.11 | 73.94 | 32400.0 |
| 2008-10-03 | BJK | ETF | 23.34 | 23.34 | 22.05 | 22.26 | 2300.0 |
| 2008-10-03 | BKF | ETF | 32.31 | 33.4782 | 31.17 | 31.2201 | 44135.0 |
| 2008-10-03 | BLV | ETF | 71.33 | 71.67 | 70.2 | 71.41 | 8100.0 |
| 2008-10-03 | BMVP | ETF | 13.007 | 13.151 | 12.643 | 12.647 | 21452.0 |
| 2008-10-03 | BND | ETF | 76.19 | 76.19 | 75.21 | 75.99 | 209600.0 |
| 2008-10-03 | BNE | ETF | 11.11 | 11.19 | 9.38 | 9.39 | 219738.0 |
| 2008-10-03 | BOSS | ETF | 17.8 | 18.2 | 17.8 | 18.2 | 100.0 |
| 2008-10-03 | BRF | ETF | 14.65 | 14.7001 | 14.65 | 14.66 | 5600.0 |
| 2008-10-03 | BSV | ETF | 76.95 | 77.41 | 76.18 | 76.44 | 86000.0 |
| 2008-10-03 | BTF | ETF | 76.35 | 78.0 | 75.6 | 75.94999999999999 | 6920.0 |
| 2008-10-03 | BWX | ETF | 26.025 | 26.265 | 25.7175 | 26.041 | 132692.0 |
| 2008-10-03 | CBON | ETF | 6.12 | 7.0 | 6.12 | 6.87 | 15638.0 |
| 2008-10-03 | CDL | ETF | 0.7 | 0.76 | 0.66 | 0.67 | 993486.0 |
| 2008-10-03 | CEF | ETF | 10.37 | 10.51 | 9.98 | 10.22 | 1605600.0 |
| 2008-10-03 | CGO | ETF | 11.05 | 11.53 | 10.46 | 10.61 | 19612.0 |
| 2008-10-03 | CGW | ETF | 17.97 | 18.96 | 17.79 | 18.85 | 136674.0 |
| 2008-10-03 | CHB | ETF | 5.62 | 6.0 | 4.42 | 5.09 | 3034485.0 |
| 2008-10-03 | CHI | ETF | 10.05 | 10.98 | 9.92 | 9.99 | 152472.0 |
| 2008-10-03 | CHIC | ETF | 10.06 | 10.33 | 9.67 | 9.74 | 422049.0 |
| 2008-10-03 | CHW | ETF | 7.82 | 8.03 | 7.41 | 7.61 | 122131.0 |
| 2008-10-03 | CHY | ETF | 10.03 | 10.44 | 9.56 | 9.69 | 182084.0 |
| 2008-10-03 | CMF | ETF | 50.3775 | 50.455 | 50.0251 | 50.0251 | 1550.0 |
| 2008-10-03 | CN | ETF | 42.95 | 44.09 | 41.61 | 43.1 | 278055.0 |
| 2008-10-03 | CNXT | ETF | 3.51 | 3.7 | 3.25 | 3.35 | 523758.0 |
| 2008-10-03 | COW | ETF | 38.31 | 38.9808 | 38.31 | 38.37 | 62551.0 |
| 2008-10-03 | CPST | ETF | 1.33 | 1.45 | 1.28 | 1.28 | 4836215.0 |
| 2008-10-03 | CSA | ETF | 15.91 | 16.64 | 15.8 | 15.84 | 293301.0 |
| 2008-10-03 | CSB | ETF | 14.4 | 15.49 | 14.0 | 14.05 | 22050.0 |
| 2008-10-03 | CSD | ETF | 16.51 | 17.05 | 16.51 | 16.63 | 8200.0 |
> showing 50 of 608 rows — these rows as CSV