PREVIEW / etf_daily / 2008-08-14
file: by_date/etf_daily/2008/2008-08-14.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-08-14 | SPY | ETF | 127.84 | 130.28 | 127.75 | 129.54 | 239555300.0 |
| 2008-08-14 | QQQ | ETF | 47.54 | 48.46 | 47.49 | 48.25 | 158069122.0 |
| 2008-08-14 | IWM | ETF | 74.17 | 75.64 | 74.06 | 75.3 | 118194800.0 |
| 2008-08-14 | DIA | ETF | 114.85 | 117.34 | 114.69 | 116.41 | 24661900.0 |
| 2008-08-14 | GLD | ETF | 80.71 | 81.1 | 79.28 | 79.35 | 15542600.0 |
| 2008-08-14 | TLT | ETF | 92.26 | 92.6 | 92.07 | 92.24 | 2605300.0 |
| 2008-08-14 | ACWI | ETF | 47.0 | 47.3 | 47.0 | 47.24 | 2600.0 |
| 2008-08-14 | ACWX | ETF | 46.0 | 46.22 | 45.99 | 46.1 | 9553.0 |
| 2008-08-14 | ADRE | ETF | 44.9 | 45.538 | 44.83 | 45.24 | 264809.0 |
| 2008-08-14 | AFK | ETF | 37.94 | 38.28 | 37.79 | 37.9 | 1000.0 |
| 2008-08-14 | AGG | ETF | 99.88 | 100.0 | 99.69 | 99.93 | 417900.0 |
| 2008-08-14 | AIA | ETF | 39.64 | 40.22 | 39.3 | 40.16 | 36853.0 |
| 2008-08-14 | AIQ | ETF | 55.0 | 57.35 | 55.0 | 56.75 | 49205.0 |
| 2008-08-14 | AIS | ETF | 0.82 | 0.88 | 0.8 | 0.85 | 203769.0 |
| 2008-08-14 | AIVI | ETF | 57.29 | 57.9 | 57.26 | 57.38 | 37600.0 |
| 2008-08-14 | ARB | ETF | 49.62 | 50.32 | 49.59 | 50.07 | 320073.0 |
| 2008-08-14 | BAL | ETF | 43.11 | 43.28 | 42.77 | 43.28 | 2600.0 |
| 2008-08-14 | BBH | ETF | 67.5167 | 68.4 | 67.5167 | 68.1833 | 665100.0 |
| 2008-08-14 | BIL | ETF | 91.74 | 91.78 | 91.74 | 91.76 | 73000.0 |
| 2008-08-14 | BITS | ETF | 22.44 | 23.04 | 21.72 | 22.88 | 3925.0 |
| 2008-08-14 | BIV | ETF | 76.47 | 76.54 | 76.22 | 76.47 | 64100.0 |
| 2008-08-14 | BJK | ETF | 32.11 | 32.11 | 30.0 | 31.5 | 5900.0 |
| 2008-08-14 | BKF | ETF | 44.3901 | 45.1904 | 44.3901 | 44.848 | 23683.0 |
| 2008-08-14 | BLV | ETF | 74.34 | 74.34 | 74.02 | 74.17 | 2400.0 |
| 2008-08-14 | BMVP | ETF | 15.233 | 15.429 | 15.217 | 15.377 | 71277.0 |
| 2008-08-14 | BND | ETF | 75.69 | 75.75 | 75.52 | 75.71 | 151600.0 |
| 2008-08-14 | BNE | ETF | 12.56 | 13.62 | 12.56 | 13.43 | 253060.0 |
| 2008-08-14 | BRF | ETF | 14.75 | 14.75 | 14.75 | 14.75 | 6600.0 |
| 2008-08-14 | BSV | ETF | 77.4 | 77.47 | 76.95 | 77.43 | 204400.0 |
| 2008-08-14 | BTF | ETF | 84.55 | 85.99999999999999 | 84.39999999999999 | 85.99999999999999 | 8723.4 |
| 2008-08-14 | BWX | ETF | 26.94 | 26.94 | 26.67 | 26.83 | 161020.0 |
| 2008-08-14 | CBON | ETF | 5.98 | 7.05 | 5.98 | 6.93 | 160356.0 |
| 2008-08-14 | CDL | ETF | 1.01 | 1.01 | 0.97 | 0.99 | 664669.0 |
| 2008-08-14 | CEF | ETF | 11.15 | 11.25 | 10.51 | 10.61 | 1479900.0 |
| 2008-08-14 | CGO | ETF | 14.5 | 14.69 | 14.458 | 14.48 | 22238.0 |
| 2008-08-14 | CGW | ETF | 23.57 | 23.71 | 23.37 | 23.594 | 26589.0 |
| 2008-08-14 | CHB | ETF | 4.14 | 4.63 | 4.11 | 4.24 | 1569096.0 |
| 2008-08-14 | CHI | ETF | 13.24 | 13.5 | 13.16 | 13.36 | 147221.0 |
| 2008-08-14 | CHIC | ETF | 11.95 | 12.59 | 11.95 | 12.51 | 306867.0 |
| 2008-08-14 | CHW | ETF | 10.68 | 10.68 | 10.46 | 10.58 | 148080.0 |
| 2008-08-14 | CHY | ETF | 12.88 | 13.25 | 12.78 | 13.02 | 232964.0 |
| 2008-08-14 | CMF | ETF | 51.329 | 51.45 | 51.329 | 51.45 | 1688.0 |
| 2008-08-14 | CN | ETF | 55.51 | 56.37 | 54.9 | 56.04 | 258982.0 |
| 2008-08-14 | CNXT | ETF | 6.27 | 6.38 | 6.1 | 6.25 | 354457.0 |
| 2008-08-14 | COW | ETF | 44.73 | 44.8 | 44.48 | 44.69 | 434838.0 |
| 2008-08-14 | CPI | ETF | 25.75 | 25.772 | 25.618 | 25.75 | 16669.0 |
| 2008-08-14 | CPST | ETF | 2.65 | 2.71 | 2.59 | 2.71 | 1861913.0 |
| 2008-08-14 | CSA | ETF | 18.58 | 19.13 | 18.58 | 18.85 | 52806.0 |
| 2008-08-14 | CSB | ETF | 20.1 | 20.38 | 19.84 | 20.0 | 28650.0 |
| 2008-08-14 | CSD | ETF | 21.32 | 21.65 | 21.32 | 21.65 | 4300.0 |
> showing 50 of 606 rows — these rows as CSV