PREVIEW / etf_daily / 2009-11-10
file: by_date/etf_daily/2009/2009-11-10.parquet size: 30 KB rows: 678
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-11-10 | SPY | ETF | 109.31 | 109.93 | 108.97 | 109.59 | 171899800.0 |
| 2009-11-10 | QQQ | ETF | 43.45 | 43.7714 | 43.4 | 43.62 | 72846448.0 |
| 2009-11-10 | IWM | ETF | 59.1 | 59.51 | 58.37 | 58.85 | 55864400.0 |
| 2009-11-10 | DIA | ETF | 102.27 | 102.8 | 102.15 | 102.69 | 9959100.0 |
| 2009-11-10 | GLD | ETF | 108.03 | 108.78 | 107.7 | 108.39 | 15973300.0 |
| 2009-11-10 | TLT | ETF | 94.05 | 94.1 | 92.91 | 93.27 | 2549900.0 |
| 2009-11-10 | AAXJ | ETF | 54.26 | 54.71 | 54.0 | 54.66 | 135000.0 |
| 2009-11-10 | ACWI | ETF | 42.17 | 42.34 | 41.85 | 42.28 | 73800.0 |
| 2009-11-10 | ACWX | ETF | 41.04 | 41.28 | 40.9365 | 41.23 | 124608.0 |
| 2009-11-10 | ADRE | ETF | 44.005 | 44.44 | 43.69 | 44.23 | 231565.0 |
| 2009-11-10 | AFK | ETF | 28.85 | 29.2899 | 28.85 | 29.0 | 32223.0 |
| 2009-11-10 | AGG | ETF | 104.6 | 104.68 | 104.41 | 104.54 | 464500.0 |
| 2009-11-10 | AGQ | ETF | 122.28 | 124.62 | 119.02 | 121.16 | 239850.0 |
| 2009-11-10 | AGZ | ETF | 108.06 | 108.59 | 108.06 | 108.47 | 14533.0 |
| 2009-11-10 | AIA | ETF | 39.19 | 39.43 | 39.0001 | 39.34 | 41941.0 |
| 2009-11-10 | AIQ | ETF | 26.85 | 27.375 | 26.2 | 27.05 | 66837.0 |
| 2009-11-10 | AIS | ETF | 1.12 | 1.14 | 1.07 | 1.08 | 263603.0 |
| 2009-11-10 | AIVI | ETF | 43.61 | 43.97 | 43.4 | 43.83 | 26600.0 |
| 2009-11-10 | AMJ | ETF | 26.57 | 26.57 | 26.36 | 26.46 | 161808.0 |
| 2009-11-10 | AOA | ETF | 29.63 | 29.63 | 29.46 | 29.55 | 7300.0 |
| 2009-11-10 | AOK | ETF | 27.2801 | 27.4695 | 27.16 | 27.35 | 24147.0 |
| 2009-11-10 | AOM | ETF | 28.4 | 28.42 | 28.0696 | 28.15 | 41995.0 |
| 2009-11-10 | AOR | ETF | 28.64 | 28.87 | 28.64 | 28.82 | 52520.0 |
| 2009-11-10 | ARB | ETF | 22.77 | 22.88 | 22.45 | 22.62 | 339419.0 |
| 2009-11-10 | BAL | ETF | 35.7 | 35.85 | 35.26 | 35.81 | 15625.0 |
| 2009-11-10 | BBH | ETF | 32.2433 | 32.2433 | 31.8633 | 31.9833 | 60600.0 |
| 2009-11-10 | BIL | ETF | 91.76 | 91.76 | 91.7 | 91.7 | 162900.0 |
| 2009-11-10 | BITS | ETF | 27.4 | 27.96 | 26.5 | 27.0804 | 2900.0 |
| 2009-11-10 | BIV | ETF | 80.28 | 80.42 | 80.14 | 80.31 | 118600.0 |
| 2009-11-10 | BJK | ETF | 25.44 | 25.45 | 25.0 | 25.29 | 20200.0 |
| 2009-11-10 | BKF | ETF | 46.3 | 46.9 | 45.9475 | 46.46 | 338208.0 |
| 2009-11-10 | BLV | ETF | 77.6 | 77.6 | 76.85 | 77.09 | 35700.0 |
| 2009-11-10 | BMVP | ETF | 12.2667 | 12.3336 | 12.2667 | 12.3133 | 8933.0 |
| 2009-11-10 | BND | ETF | 79.36 | 79.38 | 79.16 | 79.27 | 432700.0 |
| 2009-11-10 | BNE | ETF | 6.78 | 6.9 | 6.4 | 6.58 | 129451.0 |
| 2009-11-10 | BRF | ETF | 46.58 | 46.9046 | 45.84 | 46.56 | 474000.0 |
| 2009-11-10 | BSV | ETF | 80.11 | 80.14 | 79.95 | 79.95 | 620700.0 |
| 2009-11-10 | BTF | ETF | 62.199999999999996 | 63.25 | 61.984 | 62.99999999999999 | 6151.400000000001 |
| 2009-11-10 | BWX | ETF | 29.7 | 29.7 | 29.585 | 29.7 | 662832.0 |
| 2009-11-10 | BWZ | ETF | 37.74 | 37.77 | 37.69 | 37.69 | 26118.0 |
| 2009-11-10 | BZQ | ETF | 3894.4 | 4006.4 | 3800.0 | 3859.2 | 541.0 |
| 2009-11-10 | CEF | ETF | 13.57 | 13.86 | 13.51 | 13.8 | 7784100.0 |
| 2009-11-10 | CEW | ETF | 22.19 | 22.23 | 22.15 | 22.2 | 65602.0 |
| 2009-11-10 | CGO | ETF | 13.59 | 13.86 | 13.55 | 13.55 | 177291.0 |
| 2009-11-10 | CGW | ETF | 18.02 | 18.18 | 18.0 | 18.115 | 56134.0 |
| 2009-11-10 | CHB | ETF | 0.2 | 0.23 | 0.2 | 0.23 | 1576114.0 |
| 2009-11-10 | CHI | ETF | 12.01 | 12.127 | 11.92 | 12.07 | 191553.0 |
| 2009-11-10 | CHW | ETF | 7.45 | 7.6 | 7.45 | 7.52 | 172701.0 |
| 2009-11-10 | CHY | ETF | 11.55 | 11.64 | 11.39 | 11.47 | 114667.0 |
| 2009-11-10 | CMF | ETF | 52.78 | 52.79 | 52.469 | 52.79 | 5922.0 |
> showing 50 of 678 rows — these rows as CSV