PREVIEW / etf_daily / 2010-12-30
file: by_date/etf_daily/2010/2010-12-30.parquet size: 35 KB rows: 815
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-30 | SPY | ETF | 125.8 | 126.13 | 125.53 | 125.72 | 76616900.0 |
| 2010-12-30 | QQQ | ETF | 54.79 | 54.8 | 54.55 | 54.66 | 27562166.0 |
| 2010-12-30 | IWM | ETF | 78.84 | 79.22 | 78.76 | 78.76 | 37997400.0 |
| 2010-12-30 | DIA | ETF | 115.53 | 115.71 | 115.26 | 115.45 | 6599100.0 |
| 2010-12-30 | GLD | ETF | 137.58 | 137.71 | 136.94 | 137.03 | 5749400.0 |
| 2010-12-30 | TLT | ETF | 92.88 | 93.28 | 92.41 | 93.09 | 7029900.0 |
| 2010-12-30 | AADR | ETF | 29.84 | 29.84 | 29.65 | 29.73 | 9400.0 |
| 2010-12-30 | AAXJ | ETF | 63.46 | 63.67 | 63.44 | 63.55 | 155500.0 |
| 2010-12-30 | ACWI | ETF | 46.69 | 46.69 | 46.44 | 46.66 | 451900.0 |
| 2010-12-30 | ACWX | ETF | 43.85 | 43.96 | 43.67 | 43.84 | 76546.0 |
| 2010-12-30 | ADRE | ETF | 47.61 | 47.91 | 47.61 | 47.84 | 31661.0 |
| 2010-12-30 | AFK | ETF | 34.84 | 35.15 | 34.6 | 35.0 | 53541.0 |
| 2010-12-30 | AGG | ETF | 105.28 | 105.39 | 105.1 | 105.32 | 780500.0 |
| 2010-12-30 | AGQ | ETF | 313.74 | 315.26 | 306.14 | 308.54 | 328100.0 |
| 2010-12-30 | AGZ | ETF | 109.29 | 109.51 | 109.29 | 109.418 | 24061.0 |
| 2010-12-30 | AIA | ETF | 46.66 | 46.69 | 46.51 | 46.69 | 31973.0 |
| 2010-12-30 | AIQ | ETF | 21.7 | 21.75 | 21.2 | 21.5 | 38451.0 |
| 2010-12-30 | AIS | ETF | 1.73 | 1.74 | 1.7 | 1.71 | 279645.0 |
| 2010-12-30 | AIVI | ETF | 43.8 | 43.98 | 43.59 | 43.76 | 16100.0 |
| 2010-12-30 | AMJ | ETF | 36.11 | 36.449 | 36.01 | 36.27 | 515064.0 |
| 2010-12-30 | AMLP | ETF | 80.05 | 80.45 | 79.75 | 80.25 | 433960.0 |
| 2010-12-30 | AOA | ETF | 34.38 | 34.45 | 34.34 | 34.38 | 16900.0 |
| 2010-12-30 | AOK | ETF | 28.68 | 28.74 | 28.6601 | 28.68 | 3899.0 |
| 2010-12-30 | AOM | ETF | 29.88 | 29.9 | 29.81 | 29.87 | 18979.0 |
| 2010-12-30 | AOR | ETF | 31.48 | 31.89 | 31.41 | 31.5 | 15011.0 |
| 2010-12-30 | ARB | ETF | 41.77 | 42.05 | 41.54 | 41.66 | 125312.0 |
| 2010-12-30 | BAB | ETF | 24.85 | 24.94 | 24.78 | 24.88 | 213685.0 |
| 2010-12-30 | BAL | ETF | 70.0 | 73.165 | 69.82 | 72.75 | 63222.0 |
| 2010-12-30 | BALT | ETF | 10.22 | 10.32 | 10.19 | 10.19 | 288330.0 |
| 2010-12-30 | BBH | ETF | 33.3433 | 33.53 | 33.3067 | 33.3767 | 25800.0 |
| 2010-12-30 | BIB | ETF | 7.595 | 7.6625 | 7.5512 | 7.5785 | 17040.0 |
| 2010-12-30 | BICK | ETF | 32.53 | 32.759 | 32.53 | 32.74 | 30385.0 |
| 2010-12-30 | BIL | ETF | 91.7 | 91.72 | 91.7 | 91.72 | 217650.0 |
| 2010-12-30 | BIS | ETF | 8043.2 | 8043.2 | 8043.2 | 8043.2 | 16.9 |
| 2010-12-30 | BITS | ETF | 28.72 | 29.04 | 28.48 | 28.9196 | 1031.0 |
| 2010-12-30 | BIV | ETF | 82.12 | 82.27 | 81.9 | 82.12 | 109200.0 |
| 2010-12-30 | BJK | ETF | 31.31 | 31.31 | 31.07 | 31.16 | 9600.0 |
| 2010-12-30 | BKF | ETF | 48.96 | 49.058 | 48.77 | 48.85 | 100778.0 |
| 2010-12-30 | BLV | ETF | 78.45 | 78.61 | 78.09 | 78.55 | 67100.0 |
| 2010-12-30 | BMVP | ETF | 14.7 | 14.73 | 14.67 | 14.68 | 6292.0 |
| 2010-12-30 | BND | ETF | 79.97 | 80.02 | 79.78 | 80.0 | 670800.0 |
| 2010-12-30 | BNO | ETF | 31.12 | 31.12 | 30.855 | 30.855 | 15000.0 |
| 2010-12-30 | BRF | ETF | 56.12 | 57.2 | 56.08 | 57.09 | 571043.0 |
| 2010-12-30 | BSCE | ETF | 20.66 | 20.66 | 20.57 | 20.66 | 14050.0 |
| 2010-12-30 | BSV | ETF | 80.35 | 80.37 | 80.24 | 80.31 | 384900.0 |
| 2010-12-30 | BTF | ETF | 77.35 | 77.64999999999999 | 76.85 | 77.35 | 3219.8 |
| 2010-12-30 | BWX | ETF | 28.86 | 29.035 | 28.86 | 28.975 | 106268.0 |
| 2010-12-30 | BWZ | ETF | 37.25 | 37.25 | 36.62 | 36.86 | 11782.0 |
| 2010-12-30 | BZQ | ETF | 2478.4 | 2480.0 | 2435.2 | 2438.4 | 1244.5 |
| 2010-12-30 | CEF | ETF | 20.58 | 20.65 | 20.38 | 20.62 | 645600.0 |
> showing 50 of 815 rows — these rows as CSV