PREVIEW / etf_daily / 2009-12-28
file: by_date/etf_daily/2009/2009-12-28.parquet size: 31 KB rows: 705
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-12-28 | SPY | ETF | 112.9 | 112.99 | 112.32 | 112.72 | 87508500.0 |
| 2009-12-28 | QQQ | ETF | 46.08 | 46.3 | 45.94 | 46.22 | 49381386.0 |
| 2009-12-28 | IWM | ETF | 63.59 | 63.61 | 62.97 | 63.26 | 35784500.0 |
| 2009-12-28 | DIA | ETF | 105.2 | 105.35 | 104.89 | 105.29 | 8116800.0 |
| 2009-12-28 | GLD | ETF | 108.64 | 108.78 | 107.91 | 108.55 | 9637500.0 |
| 2009-12-28 | TLT | ETF | 89.46 | 89.63 | 89.3 | 89.46 | 3170900.0 |
| 2009-12-28 | AAXJ | ETF | 55.8 | 55.8 | 55.21 | 55.45 | 172800.0 |
| 2009-12-28 | ACWI | ETF | 42.81 | 42.81 | 42.39 | 42.49 | 448300.0 |
| 2009-12-28 | ACWX | ETF | 41.11 | 41.199 | 40.98 | 41.05 | 300439.0 |
| 2009-12-28 | ADRE | ETF | 44.15 | 44.249 | 43.818 | 43.93 | 185682.0 |
| 2009-12-28 | AFK | ETF | 28.28 | 28.48 | 28.1501 | 28.31 | 18533.0 |
| 2009-12-28 | AGG | ETF | 103.77 | 103.9 | 103.2 | 103.24 | 3458400.0 |
| 2009-12-28 | AGQ | ETF | 122.36 | 122.92 | 120.5 | 121.74 | 128400.0 |
| 2009-12-28 | AGZ | ETF | 107.77 | 107.842 | 107.582 | 107.592 | 13553.0 |
| 2009-12-28 | AIA | ETF | 39.45 | 39.68 | 39.334 | 39.39 | 11751.0 |
| 2009-12-28 | AIQ | ETF | 28.7 | 29.33 | 28.095 | 28.95 | 31164.0 |
| 2009-12-28 | AIS | ETF | 1.09 | 1.11 | 1.08 | 1.09 | 199451.0 |
| 2009-12-28 | AIVI | ETF | 44.76 | 44.76 | 43.87 | 43.98 | 23600.0 |
| 2009-12-28 | AMJ | ETF | 29.21 | 29.365 | 28.556 | 28.66 | 438483.0 |
| 2009-12-28 | AOA | ETF | 30.35 | 30.35 | 30.17 | 30.23 | 19900.0 |
| 2009-12-28 | AOK | ETF | 27.59 | 27.59 | 27.47 | 27.47 | 7151.0 |
| 2009-12-28 | AOM | ETF | 28.42 | 28.42 | 28.31 | 28.31 | 28214.0 |
| 2009-12-28 | AOR | ETF | 29.23 | 29.23 | 29.08 | 29.1 | 10338.0 |
| 2009-12-28 | ARB | ETF | 24.27 | 24.6 | 24.1 | 24.49 | 75558.0 |
| 2009-12-28 | BAB | ETF | 24.28 | 24.28 | 24.09 | 24.22 | 109571.0 |
| 2009-12-28 | BAL | ETF | 36.61 | 37.49 | 36.61 | 37.04 | 7095.0 |
| 2009-12-28 | BBH | ETF | 32.4067 | 32.8033 | 32.4067 | 32.79 | 190500.0 |
| 2009-12-28 | BIL | ETF | 91.72 | 91.74 | 91.7 | 91.7 | 102850.0 |
| 2009-12-28 | BITS | ETF | 30.52 | 30.6 | 29.6 | 30.456 | 2242.0 |
| 2009-12-28 | BIV | ETF | 79.17 | 79.2 | 79.0 | 79.07 | 130900.0 |
| 2009-12-28 | BJK | ETF | 23.53 | 23.66 | 23.49 | 23.56 | 23600.0 |
| 2009-12-28 | BKF | ETF | 46.07 | 46.23 | 45.5 | 45.7383 | 199735.0 |
| 2009-12-28 | BLV | ETF | 75.26 | 75.57 | 75.2 | 75.37 | 23200.0 |
| 2009-12-28 | BMVP | ETF | 12.8433 | 12.8933 | 12.8033 | 12.8419 | 13669.0 |
| 2009-12-28 | BND | ETF | 78.43 | 78.61 | 78.36 | 78.49 | 2665700.0 |
| 2009-12-28 | BNE | ETF | 6.99 | 7.03 | 6.88 | 6.92 | 89041.0 |
| 2009-12-28 | BOSS | ETF | 19.79 | 19.95 | 19.65 | 19.77 | 2500.0 |
| 2009-12-28 | BRF | ETF | 48.7 | 48.7 | 48.25 | 48.5 | 297165.0 |
| 2009-12-28 | BSV | ETF | 79.69 | 79.69 | 79.58 | 79.6 | 529900.0 |
| 2009-12-28 | BTF | ETF | 63.75 | 64.0 | 63.05 | 63.49999999999999 | 3308.4 |
| 2009-12-28 | BWX | ETF | 28.68 | 28.9112 | 28.57 | 28.685 | 495982.0 |
| 2009-12-28 | BWZ | ETF | 36.79 | 36.81 | 36.62 | 36.65 | 53346.0 |
| 2009-12-28 | BZQ | ETF | 3712.0 | 3784.0 | 3712.0 | 3780.8 | 57.5 |
| 2009-12-28 | CEF | ETF | 14.05 | 14.12 | 13.88 | 13.97 | 733500.0 |
| 2009-12-28 | CEW | ETF | 21.86 | 21.9246 | 21.86 | 21.89 | 47920.0 |
| 2009-12-28 | CGO | ETF | 14.49 | 14.62 | 14.33 | 14.43 | 14897.0 |
| 2009-12-28 | CGW | ETF | 18.6 | 18.7 | 18.38 | 18.47 | 140224.0 |
| 2009-12-28 | CHI | ETF | 12.62 | 12.62 | 12.5 | 12.55 | 176886.0 |
| 2009-12-28 | CHIE | ETF | 15.1 | 15.1 | 14.91 | 14.91 | 9624.0 |
| 2009-12-28 | CHII | ETF | 15.57 | 15.57 | 15.341 | 15.3993 | 13466.0 |
> showing 50 of 705 rows — these rows as CSV