PREVIEW / etf_daily / 2009-05-11
file: by_date/etf_daily/2009/2009-05-11.parquet size: 29 KB rows: 656
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-11 | SPY | ETF | 91.7 | 92.11 | 91.04 | 91.24 | 247923600.0 |
| 2009-05-11 | QQQ | ETF | 33.78 | 34.72 | 33.68 | 34.35 | 142775884.0 |
| 2009-05-11 | IWM | ETF | 50.05 | 50.66 | 49.79 | 50.26 | 40051600.0 |
| 2009-05-11 | DIA | ETF | 84.76 | 84.99 | 84.2 | 84.43 | 13335600.0 |
| 2009-05-11 | GLD | ETF | 89.64 | 90.01 | 89.5 | 89.69 | 12211600.0 |
| 2009-05-11 | TLT | ETF | 96.05 | 96.45 | 95.79 | 96.29 | 2167400.0 |
| 2009-05-11 | AAXJ | ETF | 42.4 | 42.4 | 41.13 | 41.41 | 208700.0 |
| 2009-05-11 | ACWI | ETF | 34.05 | 34.07 | 33.72 | 33.81 | 73000.0 |
| 2009-05-11 | ACWX | ETF | 32.64 | 32.72 | 32.41 | 32.49 | 22431.0 |
| 2009-05-11 | ADRE | ETF | 33.77 | 33.98 | 33.26 | 33.76 | 150797.0 |
| 2009-05-11 | AFK | ETF | 25.5 | 25.5 | 23.73 | 24.2 | 6130.0 |
| 2009-05-11 | AGG | ETF | 101.14 | 101.57 | 101.14 | 101.25 | 431900.0 |
| 2009-05-11 | AGQ | ETF | 86.46 | 88.4 | 86.28 | 88.1 | 76450.0 |
| 2009-05-11 | AGZ | ETF | 108.39 | 108.41 | 107.9 | 108.3016 | 4673.0 |
| 2009-05-11 | AIA | ETF | 31.94 | 32.5 | 31.25 | 31.38 | 39964.0 |
| 2009-05-11 | AIQ | ETF | 39.05 | 39.6 | 38.45 | 38.75 | 30931.0 |
| 2009-05-11 | AIS | ETF | 0.57 | 0.6 | 0.5603 | 0.58 | 125602.0 |
| 2009-05-11 | AIVI | ETF | 34.23 | 34.28 | 33.86 | 34.08 | 7700.0 |
| 2009-05-11 | AMJ | ETF | 21.86 | 22.124 | 21.21 | 22.0151 | 45005.0 |
| 2009-05-11 | AOA | ETF | 25.29 | 25.29 | 24.83 | 24.83 | 6500.0 |
| 2009-05-11 | AOK | ETF | 26.39 | 26.39 | 25.16 | 25.56 | 18105.0 |
| 2009-05-11 | AOM | ETF | 25.66 | 26.19 | 25.44 | 25.5132 | 15187.0 |
| 2009-05-11 | AOR | ETF | 25.17 | 25.99 | 25.14 | 25.19 | 17825.0 |
| 2009-05-11 | ARB | ETF | 20.42 | 20.54 | 20.21 | 20.34 | 216353.0 |
| 2009-05-11 | BAL | ETF | 33.46 | 34.15 | 33.46 | 33.95 | 12259.0 |
| 2009-05-11 | BBH | ETF | 28.9567 | 29.8267 | 28.8333 | 29.6333 | 925500.0 |
| 2009-05-11 | BIL | ETF | 91.66 | 91.76 | 91.66 | 91.66 | 220050.0 |
| 2009-05-11 | BITS | ETF | 18.0 | 18.52 | 18.0 | 18.4 | 5932.0 |
| 2009-05-11 | BIV | ETF | 76.99 | 77.01 | 76.65 | 76.9 | 96600.0 |
| 2009-05-11 | BJK | ETF | 22.14 | 23.08 | 21.25 | 21.5 | 58800.0 |
| 2009-05-11 | BKF | ETF | 33.34 | 33.34 | 32.1 | 32.671 | 414573.0 |
| 2009-05-11 | BLV | ETF | 72.9 | 73.03 | 72.12 | 72.62 | 11300.0 |
| 2009-05-11 | BMVP | ETF | 10.74 | 10.8 | 10.67 | 10.74 | 25128.0 |
| 2009-05-11 | BND | ETF | 77.12 | 77.49 | 77.06 | 77.45 | 336100.0 |
| 2009-05-11 | BNE | ETF | 5.66 | 6.09 | 5.25 | 5.85 | 335555.0 |
| 2009-05-11 | BOSS | ETF | 18.1 | 18.1 | 17.74 | 17.74 | 1000.0 |
| 2009-05-11 | BSV | ETF | 79.05 | 79.11 | 78.89 | 78.96 | 123600.0 |
| 2009-05-11 | BTF | ETF | 48.49999999999999 | 48.8 | 47.699999999999996 | 48.75 | 11953.0 |
| 2009-05-11 | BWX | ETF | 26.45 | 26.475 | 26.3601 | 26.43 | 155706.0 |
| 2009-05-11 | BWZ | ETF | 34.2 | 34.25 | 34.2 | 34.23 | 8205.0 |
| 2009-05-11 | CBON | ETF | 1.49 | 1.57 | 1.48 | 1.54 | 27800.0 |
| 2009-05-11 | CEF | ETF | 11.59 | 11.65 | 11.47 | 11.52 | 580600.0 |
| 2009-05-11 | CEW | ETF | 20.45 | 20.45 | 20.31 | 20.33 | 25580.0 |
| 2009-05-11 | CGO | ETF | 10.25 | 10.41 | 10.16 | 10.2976 | 27603.0 |
| 2009-05-11 | CGW | ETF | 14.67 | 14.71 | 14.43 | 14.4828 | 36088.0 |
| 2009-05-11 | CHB | ETF | 0.59 | 0.6 | 0.56 | 0.57 | 453879.0 |
| 2009-05-11 | CHI | ETF | 10.04 | 10.3 | 9.97 | 10.14 | 199159.0 |
| 2009-05-11 | CHIC | ETF | 11.93 | 12.26 | 11.76 | 11.97 | 202386.0 |
| 2009-05-11 | CHW | ETF | 6.6 | 6.66 | 6.45 | 6.5 | 200760.0 |
| 2009-05-11 | CHY | ETF | 9.6 | 9.71 | 9.52 | 9.67 | 191697.0 |
> showing 50 of 656 rows — these rows as CSV