PREVIEW / etf_daily / 2009-05-05
file: by_date/etf_daily/2009/2009-05-05.parquet size: 29 KB rows: 650
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-05-05 | SPY | ETF | 90.57 | 90.93 | 89.84 | 90.57 | 243036300.0 |
| 2009-05-05 | QQQ | ETF | 34.99 | 35.06 | 34.63 | 35.02 | 113638114.0 |
| 2009-05-05 | IWM | ETF | 50.38 | 50.61 | 49.63 | 50.35 | 58364200.0 |
| 2009-05-05 | DIA | ETF | 84.06 | 84.56 | 83.61 | 84.16 | 11985000.0 |
| 2009-05-05 | GLD | ETF | 89.71 | 89.73 | 87.88 | 88.25 | 9953800.0 |
| 2009-05-05 | TLT | ETF | 97.46 | 97.83 | 96.76 | 97.31 | 1369000.0 |
| 2009-05-05 | AAXJ | ETF | 41.87 | 42.32 | 41.24 | 41.64 | 116200.0 |
| 2009-05-05 | ACWI | ETF | 33.39 | 33.59 | 33.18 | 33.36 | 457900.0 |
| 2009-05-05 | ACWX | ETF | 32.05 | 32.05 | 31.65 | 31.81 | 48415.0 |
| 2009-05-05 | ADRE | ETF | 33.43 | 33.7199 | 33.153 | 33.62 | 561072.0 |
| 2009-05-05 | AFK | ETF | 23.75 | 24.2 | 22.85 | 23.12 | 1623.0 |
| 2009-05-05 | AGG | ETF | 101.32 | 101.58 | 101.01 | 101.21 | 886600.0 |
| 2009-05-05 | AGQ | ETF | 82.54 | 83.14 | 79.48 | 80.76 | 174250.0 |
| 2009-05-05 | AGZ | ETF | 107.21 | 108.044 | 107.21 | 107.83 | 5468.0 |
| 2009-05-05 | AIA | ETF | 31.53 | 31.53 | 30.75 | 30.89 | 36184.0 |
| 2009-05-05 | AIQ | ETF | 39.75 | 39.9 | 38.35 | 39.25 | 45648.0 |
| 2009-05-05 | AIS | ETF | 0.44 | 0.4401 | 0.42 | 0.43 | 33424.0 |
| 2009-05-05 | AIVI | ETF | 34.0 | 34.0 | 33.11 | 33.42 | 10000.0 |
| 2009-05-05 | AMJ | ETF | 21.92 | 21.92 | 21.7 | 21.8 | 38769.0 |
| 2009-05-05 | AOA | ETF | 24.76 | 25.39 | 24.57 | 24.63 | 11700.0 |
| 2009-05-05 | AOK | ETF | 25.5 | 25.5 | 25.48 | 25.48 | 5499.0 |
| 2009-05-05 | AOM | ETF | 25.3 | 25.3499 | 25.278 | 25.3499 | 2255.0 |
| 2009-05-05 | AOR | ETF | 25.05 | 25.09 | 24.99 | 25.05 | 4186.0 |
| 2009-05-05 | ARB | ETF | 21.0 | 21.37 | 20.33 | 20.9 | 411667.0 |
| 2009-05-05 | BAL | ETF | 32.35 | 33.1799 | 32.27 | 32.278 | 2891.0 |
| 2009-05-05 | BBH | ETF | 29.2333 | 29.3333 | 28.8767 | 29.06 | 609300.0 |
| 2009-05-05 | BIL | ETF | 91.7 | 91.72 | 91.66 | 91.68 | 199150.0 |
| 2009-05-05 | BITS | ETF | 17.8 | 19.0 | 17.8 | 18.32 | 1272.0 |
| 2009-05-05 | BIV | ETF | 76.37 | 76.55 | 76.18 | 76.42 | 255200.0 |
| 2009-05-05 | BJK | ETF | 22.13 | 22.4 | 21.34 | 22.17 | 25600.0 |
| 2009-05-05 | BKF | ETF | 32.17 | 32.18 | 31.53 | 32.15 | 234529.0 |
| 2009-05-05 | BLV | ETF | 71.92 | 72.65 | 71.71 | 71.88 | 10300.0 |
| 2009-05-05 | BMVP | ETF | 10.69 | 10.7 | 10.6 | 10.67 | 20046.0 |
| 2009-05-05 | BND | ETF | 77.02 | 77.09 | 76.88 | 76.88 | 341000.0 |
| 2009-05-05 | BNE | ETF | 5.91 | 6.02 | 5.43 | 5.92 | 165867.0 |
| 2009-05-05 | BOSS | ETF | 15.6 | 15.97 | 15.6 | 15.97 | 400.0 |
| 2009-05-05 | BSV | ETF | 78.88 | 78.95 | 78.8 | 78.94 | 175700.0 |
| 2009-05-05 | BTF | ETF | 47.9 | 48.2 | 47.56999999999999 | 48.2 | 18255.0 |
| 2009-05-05 | BWX | ETF | 26.19 | 26.21 | 25.985 | 26.1 | 163246.0 |
| 2009-05-05 | BWZ | ETF | 33.68 | 33.68 | 33.68 | 33.68 | 450.0 |
| 2009-05-05 | CBON | ETF | 2.23 | 2.23 | 1.78 | 1.89 | 121775.0 |
| 2009-05-05 | CEF | ETF | 11.72 | 11.85 | 11.6 | 11.66 | 858500.0 |
| 2009-05-05 | CGO | ETF | 10.17 | 10.2488 | 10.08 | 10.2 | 63365.0 |
| 2009-05-05 | CGW | ETF | 14.32 | 14.46 | 14.28 | 14.45 | 34033.0 |
| 2009-05-05 | CHB | ETF | 0.57 | 0.6 | 0.56 | 0.56 | 553204.0 |
| 2009-05-05 | CHI | ETF | 9.68 | 9.91 | 9.64 | 9.85 | 189733.0 |
| 2009-05-05 | CHIC | ETF | 12.72 | 12.72 | 11.84 | 12.39 | 483339.0 |
| 2009-05-05 | CHW | ETF | 6.7 | 6.77 | 6.59 | 6.64 | 154161.0 |
| 2009-05-05 | CHY | ETF | 9.38 | 9.6 | 9.28 | 9.6 | 172916.0 |
| 2009-05-05 | CMF | ETF | 52.615 | 52.615 | 52.305 | 52.35 | 10664.0 |
> showing 50 of 650 rows — these rows as CSV