PREVIEW / etf_daily / 2008-06-25
file: by_date/etf_daily/2008/2008-06-25.parquet size: 27 KB rows: 605
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-06-25 | SPY | ETF | 131.72 | 133.4 | 131.24 | 131.81 | 287853900.0 |
| 2008-06-25 | QQQ | ETF | 47.01 | 48.0 | 46.94 | 47.57 | 179023355.0 |
| 2008-06-25 | IWM | ETF | 70.96 | 72.1 | 70.86 | 71.5 | 116515200.0 |
| 2008-06-25 | DIA | ETF | 118.2 | 119.13 | 117.78 | 117.91 | 18907600.0 |
| 2008-06-25 | GLD | ETF | 87.43 | 87.58 | 86.13 | 87.42 | 10897700.0 |
| 2008-06-25 | TLT | ETF | 90.65 | 90.76 | 89.81 | 90.64 | 3251600.0 |
| 2008-06-25 | ACWI | ETF | 50.16 | 50.49 | 50.16 | 50.4 | 1800.0 |
| 2008-06-25 | ACWX | ETF | 51.15 | 51.48 | 51.14 | 51.25 | 4012.0 |
| 2008-06-25 | ADRE | ETF | 50.75 | 52.42 | 50.2 | 51.96 | 782479.0 |
| 2008-06-25 | AGG | ETF | 100.04 | 100.05 | 99.39 | 99.98 | 487100.0 |
| 2008-06-25 | AIA | ETF | 43.25 | 43.29 | 42.79 | 42.9 | 5809.0 |
| 2008-06-25 | AIQ | ETF | 44.5 | 46.25 | 43.9505 | 45.85 | 33828.0 |
| 2008-06-25 | AIS | ETF | 0.712 | 0.72 | 0.7 | 0.72 | 29144.0 |
| 2008-06-25 | AIVI | ETF | 61.24 | 62.1 | 61.24 | 61.68 | 29300.0 |
| 2008-06-25 | ARB | ETF | 48.71 | 50.45 | 48.71 | 49.7 | 345813.0 |
| 2008-06-25 | BAL | ETF | 50.1 | 50.1 | 49.31 | 49.59 | 10500.0 |
| 2008-06-25 | BBH | ETF | 55.8833 | 56.69 | 55.8133 | 56.2267 | 206100.0 |
| 2008-06-25 | BIL | ETF | 91.78 | 91.82 | 91.76 | 91.82 | 44450.0 |
| 2008-06-25 | BITS | ETF | 24.24 | 26.52 | 24.24 | 25.52 | 2302.0 |
| 2008-06-25 | BIV | ETF | 76.35 | 76.35 | 75.64 | 76.1 | 28700.0 |
| 2008-06-25 | BJK | ETF | 34.09 | 34.09 | 32.75 | 32.75 | 2200.0 |
| 2008-06-25 | BKF | ETF | 53.27 | 53.72 | 51.43 | 53.22 | 19110.0 |
| 2008-06-25 | BLV | ETF | 74.2 | 74.2 | 73.36 | 74.16 | 24000.0 |
| 2008-06-25 | BMVP | ETF | 15.5467 | 15.7308 | 15.5467 | 15.61 | 31617.0 |
| 2008-06-25 | BND | ETF | 75.87 | 75.87 | 75.4 | 75.8 | 108900.0 |
| 2008-06-25 | BNE | ETF | 13.99 | 14.37 | 13.93 | 14.17 | 107442.0 |
| 2008-06-25 | BOSS | ETF | 24.03 | 24.03 | 24.03 | 24.03 | 100.0 |
| 2008-06-25 | BRF | ETF | 14.71 | 14.71 | 14.7 | 14.71 | 12100.0 |
| 2008-06-25 | BSV | ETF | 77.03 | 77.13 | 76.78 | 77.12 | 99600.0 |
| 2008-06-25 | BTF | ETF | 94.3 | 96.64999999999999 | 94.25 | 95.29999999999998 | 3488.6000000000004 |
| 2008-06-25 | BWX | ETF | 27.415 | 27.465 | 27.2875 | 27.45 | 335434.0 |
| 2008-06-25 | CBON | ETF | 6.0 | 6.44 | 6.0 | 6.19 | 103503.0 |
| 2008-06-25 | CDL | ETF | 1.29 | 1.42 | 1.29 | 1.39 | 980503.0 |
| 2008-06-25 | CEF | ETF | 12.47 | 12.47 | 12.16 | 12.32 | 299900.0 |
| 2008-06-25 | CGO | ETF | 15.49 | 15.75 | 15.48 | 15.75 | 10875.0 |
| 2008-06-25 | CGW | ETF | 23.57 | 23.97 | 23.5 | 23.91 | 90119.0 |
| 2008-06-25 | CHB | ETF | 6.29 | 6.53 | 6.06 | 6.16 | 1742841.0 |
| 2008-06-25 | CHI | ETF | 14.24 | 14.55 | 14.23 | 14.28 | 209680.0 |
| 2008-06-25 | CHIC | ETF | 17.43 | 18.92 | 17.43 | 18.34 | 290998.0 |
| 2008-06-25 | CHW | ETF | 11.7 | 11.8 | 11.44 | 11.77 | 167323.0 |
| 2008-06-25 | CHY | ETF | 13.55 | 13.7 | 13.4 | 13.52 | 160223.0 |
| 2008-06-25 | CMF | ETF | 50.955 | 50.96 | 50.92 | 50.92 | 600.0 |
| 2008-06-25 | CN | ETF | 54.99 | 56.36 | 54.61 | 55.86 | 252607.0 |
| 2008-06-25 | CNXT | ETF | 0.53 | 0.54 | 0.5 | 0.53 | 5604497.0 |
| 2008-06-25 | COW | ETF | 44.8 | 44.81 | 44.34 | 44.48 | 176925.0 |
| 2008-06-25 | CPI | ETF | 21.8 | 21.97 | 21.8 | 21.966 | 600.0 |
| 2008-06-25 | CPST | ETF | 4.19 | 4.23 | 3.96 | 3.96 | 4976565.0 |
| 2008-06-25 | CSA | ETF | 17.57 | 17.57 | 17.3 | 17.51 | 73183.0 |
| 2008-06-25 | CSB | ETF | 19.25 | 20.0 | 19.25 | 19.8 | 13175.0 |
| 2008-06-25 | CSD | ETF | 22.24 | 22.48 | 22.21 | 22.32 | 9000.0 |
> showing 50 of 605 rows — these rows as CSV