PREVIEW / etf_daily / 2009-03-31
file: by_date/etf_daily/2009/2009-03-31.parquet size: 28 KB rows: 641
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-31 | SPY | ETF | 79.56 | 81.08 | 79.05 | 79.52 | 364238300.0 |
| 2009-03-31 | QQQ | ETF | 30.31 | 30.95 | 30.27 | 30.32 | 150243791.0 |
| 2009-03-31 | IWM | ETF | 42.17 | 43.31 | 41.61 | 42.05 | 66094400.0 |
| 2009-03-31 | DIA | ETF | 76.04 | 77.23 | 75.2 | 75.84 | 28187500.0 |
| 2009-03-31 | GLD | ETF | 90.38 | 90.85 | 89.58 | 90.28 | 14400500.0 |
| 2009-03-31 | TLT | ETF | 105.04 | 105.8 | 105.0 | 105.71 | 1094600.0 |
| 2009-03-31 | AAXJ | ETF | 32.81 | 33.57 | 32.81 | 33.1 | 114100.0 |
| 2009-03-31 | ACWI | ETF | 28.23 | 28.72 | 28.05 | 28.33 | 326100.0 |
| 2009-03-31 | ACWX | ETF | 26.36 | 26.81 | 26.25 | 26.55 | 118830.0 |
| 2009-03-31 | ADRE | ETF | 27.78 | 28.0 | 27.31 | 27.39 | 440866.0 |
| 2009-03-31 | AFK | ETF | 19.44 | 19.75 | 19.44 | 19.74 | 900.0 |
| 2009-03-31 | AGG | ETF | 101.0 | 101.47 | 100.73 | 101.47 | 638100.0 |
| 2009-03-31 | AGQ | ETF | 80.78 | 80.78 | 73.6 | 77.98 | 183500.0 |
| 2009-03-31 | AGZ | ETF | 107.77 | 108.26 | 107.75 | 107.83 | 9708.0 |
| 2009-03-31 | AIA | ETF | 25.39 | 25.39 | 25.06 | 25.36 | 22753.0 |
| 2009-03-31 | AIQ | ETF | 34.4 | 35.05 | 33.7 | 34.0 | 26331.0 |
| 2009-03-31 | AIS | ETF | 0.41 | 0.43 | 0.39 | 0.43 | 177031.0 |
| 2009-03-31 | AIVI | ETF | 27.93 | 28.61 | 27.93 | 28.31 | 7800.0 |
| 2009-03-31 | AOA | ETF | 21.63 | 22.08 | 21.57 | 21.79 | 10200.0 |
| 2009-03-31 | AOK | ETF | 24.89 | 24.89 | 24.89 | 24.89 | 100.0 |
| 2009-03-31 | AOM | ETF | 23.848 | 24.95 | 23.848 | 23.92 | 12435.0 |
| 2009-03-31 | AOR | ETF | 22.99 | 23.15 | 22.79 | 22.97 | 12845.0 |
| 2009-03-31 | ARB | ETF | 15.03 | 15.5625 | 14.8 | 15.01 | 387736.0 |
| 2009-03-31 | BAL | ETF | 26.0035 | 26.5499 | 26.0035 | 26.5499 | 800.0 |
| 2009-03-31 | BBH | ETF | 58.26 | 58.74 | 58.2333 | 58.3233 | 852900.0 |
| 2009-03-31 | BIL | ETF | 91.74 | 91.76 | 91.72 | 91.72 | 160650.0 |
| 2009-03-31 | BITS | ETF | 17.8 | 17.8 | 16.84 | 17.76 | 1399.0 |
| 2009-03-31 | BIV | ETF | 76.44 | 76.7 | 76.29 | 76.62 | 57500.0 |
| 2009-03-31 | BJK | ETF | 15.35 | 15.87 | 14.96 | 15.43 | 12500.0 |
| 2009-03-31 | BKF | ETF | 25.45 | 25.45 | 24.24 | 24.82 | 83803.0 |
| 2009-03-31 | BLV | ETF | 73.89 | 74.22 | 73.72 | 74.22 | 7200.0 |
| 2009-03-31 | BMVP | ETF | 9.8333 | 9.9966 | 9.7267 | 9.8167 | 76551.0 |
| 2009-03-31 | BND | ETF | 77.12 | 77.3 | 77.03 | 77.15 | 398700.0 |
| 2009-03-31 | BNE | ETF | 3.23 | 3.4 | 2.85 | 3.21 | 248835.0 |
| 2009-03-31 | BSV | ETF | 78.7 | 78.82 | 78.62 | 78.8 | 228300.0 |
| 2009-03-31 | BTF | ETF | 40.14999999999999 | 40.99999999999999 | 40.14999999999999 | 40.35 | 13178.400000000001 |
| 2009-03-31 | BWX | ETF | 25.62 | 25.65 | 25.45 | 25.575 | 170706.0 |
| 2009-03-31 | BWZ | ETF | 32.79 | 32.79 | 32.71 | 32.71 | 200.0 |
| 2009-03-31 | CBON | ETF | 1.45 | 1.95 | 1.4 | 1.95 | 31159.0 |
| 2009-03-31 | CEF | ETF | 12.11 | 12.11 | 11.79 | 11.92 | 916400.0 |
| 2009-03-31 | CGO | ETF | 8.86 | 9.32 | 8.86 | 9.1 | 17170.0 |
| 2009-03-31 | CGW | ETF | 12.14 | 12.3101 | 11.99 | 12.17 | 18730.0 |
| 2009-03-31 | CHB | ETF | 0.49 | 0.55 | 0.4702 | 0.48 | 1073570.0 |
| 2009-03-31 | CHI | ETF | 8.6 | 8.84 | 8.57 | 8.63 | 159939.0 |
| 2009-03-31 | CHIC | ETF | 8.13 | 8.24 | 7.9 | 8.15 | 201524.0 |
| 2009-03-31 | CHW | ETF | 5.39 | 5.47 | 5.3 | 5.45 | 161910.0 |
| 2009-03-31 | CHY | ETF | 8.17 | 8.4 | 8.05 | 8.15 | 119112.0 |
| 2009-03-31 | CMF | ETF | 52.065 | 52.065 | 51.7565 | 51.9 | 7180.0 |
| 2009-03-31 | CNXT | ETF | 0.67 | 0.6738 | 0.65 | 0.65 | 150086.0 |
| 2009-03-31 | COW | ETF | 30.29 | 30.9068 | 30.27 | 30.88 | 11423.0 |
> showing 50 of 641 rows — these rows as CSV