PREVIEW / etf_daily / 2008-03-04
file: by_date/etf_daily/2008/2008-03-04.parquet size: 26 KB rows: 571
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-03-04 | SPY | ETF | 132.23 | 133.4 | 130.99 | 132.99 | 282513100.0 |
| 2008-03-04 | QQQ | ETF | 42.41 | 43.04 | 42.02 | 42.91 | 183850962.0 |
| 2008-03-04 | IWM | ETF | 67.57 | 68.43 | 66.78 | 67.8 | 90523200.0 |
| 2008-03-04 | DIA | ETF | 121.51 | 122.42 | 120.36 | 122.4 | 20448800.0 |
| 2008-03-04 | GLD | ETF | 97.28 | 97.45 | 94.39 | 95.18 | 21356500.0 |
| 2008-03-04 | TLT | ETF | 93.94 | 94.12 | 92.53 | 92.73 | 3401100.0 |
| 2008-03-04 | ADRE | ETF | 51.85 | 51.93 | 50.15 | 51.13 | 609121.0 |
| 2008-03-04 | AGG | ETF | 102.41 | 102.57 | 101.78 | 102.09 | 385300.0 |
| 2008-03-04 | AIA | ETF | 44.19 | 44.19 | 42.35 | 42.88 | 13400.0 |
| 2008-03-04 | AIQ | ETF | 48.55 | 48.9 | 47.55 | 48.75 | 42900.0 |
| 2008-03-04 | AIS | ETF | 0.99 | 1.02 | 0.87 | 1.02 | 197700.0 |
| 2008-03-04 | AIVI | ETF | 62.2 | 62.33 | 61.35 | 61.97 | 48600.0 |
| 2008-03-04 | ARB | ETF | 41.86 | 42.8 | 41.06 | 42.65 | 347000.0 |
| 2008-03-04 | BBH | ETF | 56.7067 | 58.1667 | 56.5933 | 58.0233 | 552600.0 |
| 2008-03-04 | BIL | ETF | 91.66 | 91.72 | 91.64 | 91.72 | 73450.0 |
| 2008-03-04 | BITS | ETF | 21.4 | 21.88 | 20.68 | 20.76 | 16726.0 |
| 2008-03-04 | BIV | ETF | 78.97 | 79.24 | 78.61 | 78.75 | 98600.0 |
| 2008-03-04 | BJK | ETF | 40.99 | 40.99 | 39.01 | 40.05 | 4100.0 |
| 2008-03-04 | BKF | ETF | 52.99 | 53.04 | 51.5 | 52.17 | 28100.0 |
| 2008-03-04 | BLV | ETF | 76.57 | 76.75 | 75.82 | 75.87 | 34700.0 |
| 2008-03-04 | BMVP | ETF | 15.7033 | 15.7766 | 15.54 | 15.7067 | 32000.0 |
| 2008-03-04 | BND | ETF | 77.61 | 77.63 | 77.13 | 77.27 | 229800.0 |
| 2008-03-04 | BNE | ETF | 13.22 | 13.35 | 13.03 | 13.23 | 150500.0 |
| 2008-03-04 | BRF | ETF | 14.65 | 14.66 | 14.64 | 14.66 | 23900.0 |
| 2008-03-04 | BSV | ETF | 78.96 | 79.08 | 78.78 | 78.8 | 53600.0 |
| 2008-03-04 | BTF | ETF | 105.0 | 105.5495 | 103.1 | 104.25 | 12900.0 |
| 2008-03-04 | BWX | ETF | 28.22 | 28.27 | 28.105 | 28.195 | 917300.0 |
| 2008-03-04 | CBON | ETF | 11.5 | 12.05 | 11.16 | 11.34 | 117476.0 |
| 2008-03-04 | CDL | ETF | 1.39 | 1.54 | 1.19 | 1.5 | 1613249.0 |
| 2008-03-04 | CEF | ETF | 13.57 | 13.65 | 13.13 | 13.42 | 1382700.0 |
| 2008-03-04 | CGO | ETF | 16.03 | 16.26 | 16.03 | 16.21 | 21086.0 |
| 2008-03-04 | CGW | ETF | 23.37 | 23.72 | 23.14 | 23.72 | 48746.0 |
| 2008-03-04 | CHB | ETF | 8.58 | 8.72 | 8.28 | 8.61 | 1791267.0 |
| 2008-03-04 | CHI | ETF | 14.16 | 14.64 | 14.16 | 14.55 | 171400.0 |
| 2008-03-04 | CHIC | ETF | 19.45 | 20.16 | 19.45 | 20.0 | 1137057.0 |
| 2008-03-04 | CHW | ETF | 11.55 | 11.7 | 11.31 | 11.52 | 166790.0 |
| 2008-03-04 | CHY | ETF | 13.02 | 13.41 | 13.02 | 13.41 | 167800.0 |
| 2008-03-04 | CMF | ETF | 50.55 | 50.745 | 50.395 | 50.585 | 29800.0 |
| 2008-03-04 | CN | ETF | 59.11 | 59.15 | 57.3 | 58.24 | 482283.0 |
| 2008-03-04 | CNXT | ETF | 0.5 | 0.51 | 0.45 | 0.48 | 3841797.0 |
| 2008-03-04 | COW | ETF | 43.9 | 43.9 | 42.68 | 42.82 | 39700.0 |
| 2008-03-04 | CPST | ETF | 1.88 | 1.88 | 1.73 | 1.85 | 2237016.0 |
| 2008-03-04 | CSA | ETF | 15.9 | 16.31 | 15.58 | 15.58 | 64610.0 |
| 2008-03-04 | CSD | ETF | 22.8 | 22.9 | 22.49 | 22.86 | 13400.0 |
| 2008-03-04 | CSQ | ETF | 12.11 | 12.21 | 11.92 | 12.19 | 391040.0 |
| 2008-03-04 | CUT | ETF | 21.98 | 21.98 | 21.3 | 21.57 | 56500.0 |
| 2008-03-04 | CVY | ETF | 22.29 | 22.32 | 22.08 | 22.29 | 25900.0 |
| 2008-03-04 | CWI | ETF | 24.9333 | 25.0667 | 24.6867 | 24.9733 | 78300.0 |
| 2008-03-04 | DBA | ETF | 42.5 | 42.74 | 40.5 | 41.45 | 7128900.0 |
| 2008-03-04 | DBB | ETF | 27.69 | 27.69 | 26.61 | 26.96 | 233200.0 |
> showing 50 of 571 rows — these rows as CSV