PREVIEW / etf_daily / 2008-04-02
file: by_date/etf_daily/2008/2008-04-02.parquet size: 26 KB rows: 585
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-04-02 | SPY | ETF | 137.05 | 137.67 | 135.98 | 136.7 | 210910800.0 |
| 2008-04-02 | QQQ | ETF | 45.69 | 46.02 | 45.17 | 45.49 | 132486770.0 |
| 2008-04-02 | IWM | ETF | 70.9 | 71.52 | 70.37 | 70.96 | 58947900.0 |
| 2008-04-02 | DIA | ETF | 126.36 | 126.87 | 125.45 | 126.19 | 13766400.0 |
| 2008-04-02 | GLD | ETF | 87.28 | 89.76 | 87.22 | 89.27 | 13537500.0 |
| 2008-04-02 | TLT | ETF | 93.99 | 94.86 | 93.99 | 94.13 | 3794200.0 |
| 2008-04-02 | ACWI | ETF | 51.12 | 51.4 | 51.05 | 51.21 | 10700.0 |
| 2008-04-02 | ACWX | ETF | 51.85 | 52.03 | 51.85 | 51.86 | 1994.0 |
| 2008-04-02 | ADRE | ETF | 50.73 | 51.2 | 50.29 | 50.83 | 315947.0 |
| 2008-04-02 | AGG | ETF | 101.78 | 101.97 | 101.42 | 101.62 | 499400.0 |
| 2008-04-02 | AIA | ETF | 45.97 | 45.97 | 44.51 | 45.04 | 6100.0 |
| 2008-04-02 | AIQ | ETF | 43.7 | 44.0 | 42.95 | 43.25 | 34420.0 |
| 2008-04-02 | AIS | ETF | 1.0 | 1.01 | 0.97 | 0.99 | 94400.0 |
| 2008-04-02 | AIVI | ETF | 66.13 | 66.55 | 65.74 | 66.22 | 14100.0 |
| 2008-04-02 | ARB | ETF | 44.65 | 44.92 | 44.04 | 44.5 | 160600.0 |
| 2008-04-02 | BBH | ETF | 58.61 | 58.6333 | 57.9767 | 58.07 | 179400.0 |
| 2008-04-02 | BIL | ETF | 91.7 | 91.74 | 91.7 | 91.7 | 65900.0 |
| 2008-04-02 | BITS | ETF | 22.96 | 23.16 | 22.6 | 23.16 | 3900.0 |
| 2008-04-02 | BIV | ETF | 78.83 | 78.83 | 78.38 | 78.53 | 41400.0 |
| 2008-04-02 | BJK | ETF | 40.64 | 40.75 | 40.64 | 40.75 | 700.0 |
| 2008-04-02 | BKF | ETF | 52.35 | 52.4 | 51.35 | 51.51 | 72200.0 |
| 2008-04-02 | BLV | ETF | 75.91 | 76.22 | 75.58 | 76.14 | 23500.0 |
| 2008-04-02 | BMVP | ETF | 15.8133 | 15.8885 | 15.7667 | 15.7667 | 22700.0 |
| 2008-04-02 | BND | ETF | 77.01 | 77.25 | 76.78 | 76.93 | 170100.0 |
| 2008-04-02 | BNE | ETF | 15.46 | 16.15 | 15.37 | 15.64 | 278900.0 |
| 2008-04-02 | BRF | ETF | 14.62 | 14.68 | 14.54 | 14.65 | 18100.0 |
| 2008-04-02 | BSV | ETF | 78.71 | 78.71 | 77.92 | 78.36 | 80700.0 |
| 2008-04-02 | BTF | ETF | 102.5 | 103.69999999999999 | 102.5 | 103.048 | 2560.0 |
| 2008-04-02 | BWX | ETF | 28.68 | 28.68 | 28.505 | 28.6475 | 194000.0 |
| 2008-04-02 | CBON | ETF | 13.5 | 13.75 | 13.12 | 13.68 | 121606.0 |
| 2008-04-02 | CDL | ETF | 1.64 | 1.89 | 1.63 | 1.81 | 3273621.0 |
| 2008-04-02 | CEF | ETF | 12.15 | 12.75 | 12.15 | 12.74 | 929000.0 |
| 2008-04-02 | CGO | ETF | 16.82 | 16.98 | 16.8045 | 16.98 | 14000.0 |
| 2008-04-02 | CGW | ETF | 25.3 | 25.3 | 24.0 | 24.3 | 99100.0 |
| 2008-04-02 | CHB | ETF | 11.04 | 11.42 | 10.87 | 11.05 | 2586454.0 |
| 2008-04-02 | CHI | ETF | 14.16 | 14.36 | 14.07 | 14.27 | 115500.0 |
| 2008-04-02 | CHIC | ETF | 17.84 | 18.12 | 17.71 | 18.01 | 1181694.0 |
| 2008-04-02 | CHW | ETF | 11.61 | 11.65 | 11.49 | 11.57 | 100900.0 |
| 2008-04-02 | CHY | ETF | 13.05 | 13.19 | 13.01 | 13.11 | 153300.0 |
| 2008-04-02 | CMF | ETF | 51.145 | 51.225 | 51.125 | 51.225 | 18730.0 |
| 2008-04-02 | CN | ETF | 61.48 | 62.38 | 60.57 | 61.56 | 547463.0 |
| 2008-04-02 | CNXT | ETF | 0.61 | 0.62 | 0.5854 | 0.6 | 2473695.0 |
| 2008-04-02 | COW | ETF | 39.77 | 39.99 | 39.6 | 39.62 | 23500.0 |
| 2008-04-02 | CPST | ETF | 2.41 | 2.44 | 2.33 | 2.38 | 6145327.0 |
| 2008-04-02 | CSA | ETF | 15.78 | 16.48 | 15.72 | 16.44 | 26700.0 |
| 2008-04-02 | CSB | ETF | 21.0 | 21.23 | 20.52 | 21.0 | 55900.0 |
| 2008-04-02 | CSD | ETF | 23.57 | 23.98 | 23.57 | 23.77 | 4300.0 |
| 2008-04-02 | CSQ | ETF | 12.4 | 12.57 | 12.36 | 12.5 | 276100.0 |
| 2008-04-02 | CUT | ETF | 21.54 | 22.0 | 21.54 | 22.0 | 58000.0 |
| 2008-04-02 | CVY | ETF | 22.46 | 22.75 | 22.46 | 22.75 | 9000.0 |
> showing 50 of 585 rows — these rows as CSV