PREVIEW / etf_daily / 2009-03-30
file: by_date/etf_daily/2009/2009-03-30.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-30 | SPY | ETF | 79.8 | 79.87 | 77.96 | 78.79 | 324108500.0 |
| 2009-03-30 | QQQ | ETF | 30.29 | 30.32 | 29.62 | 30.06 | 162919640.0 |
| 2009-03-30 | IWM | ETF | 41.65 | 41.81 | 40.78 | 41.66 | 59094200.0 |
| 2009-03-30 | DIA | ETF | 76.09 | 76.12 | 74.37 | 75.25 | 25811800.0 |
| 2009-03-30 | GLD | ETF | 89.97 | 91.81 | 89.75 | 89.98 | 16425900.0 |
| 2009-03-30 | TLT | ETF | 105.44 | 105.87 | 103.94 | 104.96 | 2300100.0 |
| 2009-03-30 | AAXJ | ETF | 32.7 | 33.57 | 32.18 | 32.36 | 90800.0 |
| 2009-03-30 | ACWI | ETF | 28.49 | 28.49 | 27.55 | 27.8 | 57500.0 |
| 2009-03-30 | ACWX | ETF | 26.1 | 26.18 | 25.68 | 25.93 | 48240.0 |
| 2009-03-30 | ADRE | ETF | 27.5 | 27.5 | 26.75 | 26.97 | 235853.0 |
| 2009-03-30 | AFK | ETF | 19.29 | 19.39 | 19.29 | 19.39 | 1700.0 |
| 2009-03-30 | AGG | ETF | 100.41 | 101.09 | 100.41 | 100.95 | 616300.0 |
| 2009-03-30 | AGQ | ETF | 79.5 | 82.68 | 78.5 | 78.86 | 97550.0 |
| 2009-03-30 | AGZ | ETF | 107.99 | 108.04 | 107.6825 | 108.03 | 17772.0 |
| 2009-03-30 | AIA | ETF | 25.25 | 27.0 | 24.4726 | 24.57 | 15317.0 |
| 2009-03-30 | AIQ | ETF | 34.45 | 34.5 | 33.35 | 33.95 | 23876.0 |
| 2009-03-30 | AIS | ETF | 0.43 | 0.43 | 0.37 | 0.39 | 122287.0 |
| 2009-03-30 | AIVI | ETF | 27.71 | 27.71 | 27.15 | 27.27 | 8200.0 |
| 2009-03-30 | AOA | ETF | 21.5 | 21.5 | 21.34 | 21.4 | 3600.0 |
| 2009-03-30 | AOK | ETF | 25.44 | 25.44 | 24.7594 | 24.77 | 8421.0 |
| 2009-03-30 | AOM | ETF | 23.6706 | 23.7052 | 23.66 | 23.7052 | 1603.0 |
| 2009-03-30 | AOR | ETF | 23.74 | 23.74 | 22.71 | 22.78 | 26718.0 |
| 2009-03-30 | ARB | ETF | 14.9 | 15.06 | 14.44 | 14.88 | 458728.0 |
| 2009-03-30 | BAL | ETF | 24.61 | 25.13 | 24.57 | 25.13 | 3950.0 |
| 2009-03-30 | BBH | ETF | 58.1633 | 58.27 | 57.6167 | 58.19 | 219900.0 |
| 2009-03-30 | BIL | ETF | 91.78 | 91.78 | 91.74 | 91.76 | 173650.0 |
| 2009-03-30 | BITS | ETF | 17.6 | 17.96 | 17.2 | 17.96 | 827.0 |
| 2009-03-30 | BIV | ETF | 76.45 | 76.51 | 76.01 | 76.33 | 57900.0 |
| 2009-03-30 | BJK | ETF | 14.0 | 15.41 | 14.0 | 14.59 | 7200.0 |
| 2009-03-30 | BKF | ETF | 26.15 | 26.15 | 24.35 | 24.5048 | 61869.0 |
| 2009-03-30 | BLV | ETF | 74.13 | 74.16 | 73.35 | 73.72 | 13700.0 |
| 2009-03-30 | BMVP | ETF | 9.743 | 9.757 | 9.653 | 9.737 | 27016.0 |
| 2009-03-30 | BND | ETF | 77.08 | 77.22 | 76.78 | 77.12 | 358200.0 |
| 2009-03-30 | BNE | ETF | 3.46 | 3.51 | 3.06 | 3.16 | 177745.0 |
| 2009-03-30 | BSV | ETF | 78.53 | 79.66 | 78.46 | 78.61 | 251800.0 |
| 2009-03-30 | BTF | ETF | 39.949999999999996 | 39.949999999999996 | 39.05 | 39.75 | 8758.4 |
| 2009-03-30 | BWX | ETF | 25.43 | 25.55 | 25.375 | 25.55 | 221444.0 |
| 2009-03-30 | BWZ | ETF | 32.7 | 32.7 | 32.7 | 32.7 | 611.0 |
| 2009-03-30 | CBON | ETF | 1.21 | 1.47 | 1.21 | 1.35 | 13600.0 |
| 2009-03-30 | CEF | ETF | 11.95 | 12.22 | 11.84 | 11.9 | 998500.0 |
| 2009-03-30 | CGO | ETF | 9.01 | 9.1 | 8.8 | 8.82 | 7803.0 |
| 2009-03-30 | CGW | ETF | 11.99 | 11.99 | 11.7 | 11.8 | 50942.0 |
| 2009-03-30 | CHB | ETF | 0.48 | 0.52 | 0.38 | 0.47 | 961125.0 |
| 2009-03-30 | CHI | ETF | 8.66 | 8.66 | 8.33 | 8.53 | 122938.0 |
| 2009-03-30 | CHIC | ETF | 7.77 | 8.06 | 7.56 | 8.02 | 249648.0 |
| 2009-03-30 | CHW | ETF | 5.34 | 5.35 | 5.16 | 5.26 | 167518.0 |
| 2009-03-30 | CHY | ETF | 8.0 | 8.27 | 8.0 | 8.13 | 81762.0 |
| 2009-03-30 | CMF | ETF | 51.965 | 51.965 | 51.945 | 51.945 | 4000.0 |
| 2009-03-30 | CNXT | ETF | 0.74 | 0.74 | 0.65 | 0.67 | 405462.0 |
| 2009-03-30 | COW | ETF | 30.5 | 30.63 | 30.2 | 30.3 | 24163.0 |
> showing 50 of 641 rows — these rows as CSV