PREVIEW / etf_daily / 2010-12-15
file: by_date/etf_daily/2010/2010-12-15.parquet size: 35 KB rows: 818
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-15 | SPY | ETF | 124.44 | 124.93 | 123.89 | 124.1 | 160823100.0 |
| 2010-12-15 | QQQ | ETF | 54.37 | 54.7 | 54.03 | 54.16 | 76951808.0 |
| 2010-12-15 | IWM | ETF | 77.25 | 78.06 | 76.92 | 77.07 | 52002400.0 |
| 2010-12-15 | DIA | ETF | 114.91 | 115.44 | 114.68 | 114.89 | 5851100.0 |
| 2010-12-15 | GLD | ETF | 135.34 | 135.93 | 134.68 | 134.7 | 15089500.0 |
| 2010-12-15 | TLT | ETF | 92.08 | 92.24 | 90.47 | 90.94 | 26084000.0 |
| 2010-12-15 | AADR | ETF | 29.64 | 29.69 | 29.39 | 29.4 | 7900.0 |
| 2010-12-15 | AAXJ | ETF | 62.97 | 62.97 | 62.29 | 62.44 | 433800.0 |
| 2010-12-15 | ACWI | ETF | 46.23 | 46.5 | 46.02 | 46.1 | 173000.0 |
| 2010-12-15 | ACWX | ETF | 43.77 | 43.9 | 43.39 | 43.52 | 91420.0 |
| 2010-12-15 | ADRE | ETF | 46.63 | 46.71 | 46.165 | 46.31 | 39095.0 |
| 2010-12-15 | AFK | ETF | 34.49 | 34.59 | 34.216 | 34.27 | 19745.0 |
| 2010-12-15 | AGG | ETF | 104.86 | 104.99 | 104.36 | 104.6 | 1357500.0 |
| 2010-12-15 | AGQ | ETF | 282.76 | 290.1 | 275.44 | 276.74 | 629550.0 |
| 2010-12-15 | AGZ | ETF | 109.34 | 109.35 | 109.02 | 109.15 | 26043.0 |
| 2010-12-15 | AIA | ETF | 45.97 | 46.01 | 45.56 | 45.65 | 27013.0 |
| 2010-12-15 | AIQ | ETF | 17.55 | 18.5 | 17.55 | 17.95 | 165786.0 |
| 2010-12-15 | AIS | ETF | 1.49 | 1.5 | 1.46 | 1.49 | 297396.0 |
| 2010-12-15 | AIVI | ETF | 43.75 | 43.9 | 43.35 | 43.41 | 37900.0 |
| 2010-12-15 | AMJ | ETF | 35.75 | 35.8599 | 35.22 | 35.28 | 1293775.0 |
| 2010-12-15 | AMLP | ETF | 79.7 | 79.85 | 78.7 | 79.0 | 256320.0 |
| 2010-12-15 | AOA | ETF | 34.01 | 34.17 | 33.82 | 33.82 | 26000.0 |
| 2010-12-15 | AOK | ETF | 28.59 | 28.64 | 28.4601 | 28.4601 | 4890.0 |
| 2010-12-15 | AOM | ETF | 29.77 | 29.83 | 29.684 | 29.684 | 5857.0 |
| 2010-12-15 | AOR | ETF | 31.28 | 31.36 | 31.18 | 31.19 | 9911.0 |
| 2010-12-15 | ARB | ETF | 39.63 | 40.72 | 39.52 | 40.52 | 769024.0 |
| 2010-12-15 | BAB | ETF | 24.75 | 24.9 | 24.56 | 24.7 | 698779.0 |
| 2010-12-15 | BAL | ETF | 72.36 | 73.3283 | 71.6701 | 72.19 | 41710.0 |
| 2010-12-15 | BALT | ETF | 11.02 | 11.146 | 10.91 | 10.99 | 155306.0 |
| 2010-12-15 | BBH | ETF | 33.3533 | 33.5433 | 33.3533 | 33.41 | 40800.0 |
| 2010-12-15 | BIB | ETF | 7.3388 | 7.3625 | 7.325 | 7.325 | 13600.0 |
| 2010-12-15 | BICK | ETF | 32.09 | 32.09 | 31.7232 | 31.7232 | 25975.0 |
| 2010-12-15 | BIL | ETF | 91.7 | 91.72 | 91.7 | 91.7 | 204550.0 |
| 2010-12-15 | BIS | ETF | 8307.2 | 8475.2 | 8307.2 | 8475.2 | 5.95 |
| 2010-12-15 | BITS | ETF | 28.76 | 29.0 | 28.004 | 29.0 | 3975.0 |
| 2010-12-15 | BIV | ETF | 82.27 | 82.52 | 81.79 | 81.95 | 257000.0 |
| 2010-12-15 | BJK | ETF | 31.1 | 31.3 | 30.84 | 30.93 | 22900.0 |
| 2010-12-15 | BKF | ETF | 48.94 | 48.94 | 48.27 | 48.38 | 146008.0 |
| 2010-12-15 | BLV | ETF | 78.1 | 78.31 | 77.1 | 77.43 | 81200.0 |
| 2010-12-15 | BMVP | ETF | 14.72 | 14.7467 | 14.63 | 14.6398 | 10239.0 |
| 2010-12-15 | BND | ETF | 80.09 | 80.17 | 79.71 | 79.77 | 926500.0 |
| 2010-12-15 | BNO | ETF | 30.3 | 30.65 | 30.3 | 30.565 | 9200.0 |
| 2010-12-15 | BRF | ETF | 58.81 | 58.81 | 57.65 | 57.75 | 489141.0 |
| 2010-12-15 | BSCE | ETF | 20.5683 | 20.5683 | 20.46 | 20.509 | 15512.0 |
| 2010-12-15 | BSV | ETF | 80.59 | 80.67 | 80.46 | 80.5 | 952100.0 |
| 2010-12-15 | BTF | ETF | 77.55 | 77.773 | 77.45 | 77.5 | 1332.4 |
| 2010-12-15 | BWX | ETF | 28.56 | 28.815 | 28.47 | 28.52 | 318230.0 |
| 2010-12-15 | BWZ | ETF | 36.55 | 36.58 | 36.09 | 36.09 | 37395.0 |
| 2010-12-15 | BZQ | ETF | 2681.6 | 2740.8 | 2667.2 | 2737.6 | 826.0 |
| 2010-12-15 | CEF | ETF | 20.07 | 20.18 | 19.9 | 19.92 | 857100.0 |
> showing 50 of 818 rows — these rows as CSV