PREVIEW / etf_daily / 2009-06-01
file: by_date/etf_daily/2009/2009-06-01.parquet size: 29 KB rows: 655
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-06-01 | SPY | ETF | 93.67 | 95.17 | 93.43 | 94.77 | 276246800.0 |
| 2009-06-01 | QQQ | ETF | 35.73 | 36.5 | 35.61 | 36.39 | 119192163.0 |
| 2009-06-01 | IWM | ETF | 51.36 | 52.37 | 51.1 | 52.13 | 70173300.0 |
| 2009-06-01 | DIA | ETF | 86.28 | 87.67 | 86.05 | 87.35 | 12952000.0 |
| 2009-06-01 | GLD | ETF | 96.47 | 96.76 | 95.63 | 95.73 | 17921200.0 |
| 2009-06-01 | TLT | ETF | 92.34 | 92.38 | 90.57 | 91.09 | 6987000.0 |
| 2009-06-01 | AAXJ | ETF | 45.77 | 46.97 | 45.77 | 46.86 | 310500.0 |
| 2009-06-01 | ACWI | ETF | 36.07 | 36.33 | 35.9 | 36.11 | 211100.0 |
| 2009-06-01 | ACWX | ETF | 35.39 | 35.67 | 35.224 | 35.42 | 59670.0 |
| 2009-06-01 | ADRE | ETF | 37.15 | 37.54 | 36.83 | 37.37 | 391019.0 |
| 2009-06-01 | AFK | ETF | 28.75 | 28.94 | 28.43 | 28.9399 | 13433.0 |
| 2009-06-01 | AGG | ETF | 101.23 | 101.35 | 100.39 | 100.46 | 1111000.0 |
| 2009-06-01 | AGQ | ETF | 112.08 | 112.6 | 107.8 | 108.72 | 186350.0 |
| 2009-06-01 | AGZ | ETF | 107.05 | 107.05 | 106.21 | 106.21 | 4661.0 |
| 2009-06-01 | AIA | ETF | 34.0 | 34.54 | 33.835 | 34.34 | 74212.0 |
| 2009-06-01 | AIQ | ETF | 35.1 | 35.95 | 34.8 | 35.05 | 63542.0 |
| 2009-06-01 | AIS | ETF | 0.56 | 0.58 | 0.5404 | 0.56 | 38876.0 |
| 2009-06-01 | AIVI | ETF | 36.74 | 37.5 | 36.74 | 37.31 | 10100.0 |
| 2009-06-01 | AMJ | ETF | 23.0 | 23.17 | 22.937 | 23.1 | 61988.0 |
| 2009-06-01 | AOA | ETF | 25.57 | 26.04 | 25.57 | 25.97 | 8000.0 |
| 2009-06-01 | AOK | ETF | 25.99 | 25.99 | 25.675 | 25.95 | 3205.0 |
| 2009-06-01 | AOM | ETF | 25.9 | 26.4904 | 25.9 | 26.0399 | 15697.0 |
| 2009-06-01 | AOR | ETF | 25.2 | 26.12 | 25.2 | 26.03 | 21346.0 |
| 2009-06-01 | ARB | ETF | 20.11 | 21.2 | 20.11 | 21.17 | 245132.0 |
| 2009-06-01 | BAL | ETF | 32.3048 | 32.66 | 32.12 | 32.66 | 6946.0 |
| 2009-06-01 | BBH | ETF | 30.1967 | 30.3267 | 29.8733 | 30.03 | 571200.0 |
| 2009-06-01 | BIL | ETF | 91.76 | 91.76 | 91.68 | 91.68 | 348100.0 |
| 2009-06-01 | BITS | ETF | 19.32 | 19.4 | 19.0804 | 19.4 | 4552.0 |
| 2009-06-01 | BIV | ETF | 76.03 | 76.03 | 75.31 | 75.57 | 136700.0 |
| 2009-06-01 | BJK | ETF | 22.0 | 23.16 | 21.66 | 22.19 | 38600.0 |
| 2009-06-01 | BKF | ETF | 37.66 | 39.14 | 37.66 | 38.3 | 875078.0 |
| 2009-06-01 | BLV | ETF | 71.94 | 72.49 | 71.0 | 71.65 | 20500.0 |
| 2009-06-01 | BMVP | ETF | 11.01 | 11.16 | 10.98 | 11.11 | 15414.0 |
| 2009-06-01 | BND | ETF | 77.13 | 77.31 | 76.62 | 76.69 | 510500.0 |
| 2009-06-01 | BNE | ETF | 5.54 | 6.05 | 5.3701 | 6.03 | 170354.0 |
| 2009-06-01 | BRF | ETF | 28.64 | 28.97 | 28.5 | 28.75 | 282774.0 |
| 2009-06-01 | BSV | ETF | 79.05 | 79.05 | 78.77 | 79.0 | 188400.0 |
| 2009-06-01 | BTF | ETF | 48.3 | 49.05 | 48.3 | 48.699999999999996 | 14991.6 |
| 2009-06-01 | BWX | ETF | 27.27 | 27.29 | 27.145 | 27.18 | 569262.0 |
| 2009-06-01 | BWZ | ETF | 35.49 | 35.49 | 35.15 | 35.35 | 5875.0 |
| 2009-06-01 | CBON | ETF | 1.34 | 1.34 | 1.11 | 1.11 | 24738.0 |
| 2009-06-01 | CEF | ETF | 12.64 | 12.79 | 12.4 | 12.41 | 1296500.0 |
| 2009-06-01 | CEW | ETF | 20.92 | 20.92 | 20.81 | 20.85 | 66565.0 |
| 2009-06-01 | CGO | ETF | 11.12 | 11.84 | 11.1199 | 11.37 | 92629.0 |
| 2009-06-01 | CGW | ETF | 15.41 | 15.62 | 15.17 | 15.55 | 33442.0 |
| 2009-06-01 | CHB | ETF | 0.42 | 0.45 | 0.34 | 0.42 | 1065718.0 |
| 2009-06-01 | CHI | ETF | 10.5 | 10.69 | 10.41 | 10.62 | 277119.0 |
| 2009-06-01 | CHIC | ETF | 10.28 | 11.12 | 10.19 | 11.05 | 226452.0 |
| 2009-06-01 | CHW | ETF | 7.22 | 7.62 | 7.17 | 7.2054 | 285765.0 |
| 2009-06-01 | CHY | ETF | 10.61 | 10.7 | 10.5 | 10.54 | 287561.0 |
> showing 50 of 655 rows — these rows as CSV