PREVIEW / etf_daily / 2009-08-10
file: by_date/etf_daily/2009/2009-08-10.parquet size: 29 KB rows: 669
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-08-10 | SPY | ETF | 100.74 | 101.22 | 100.27 | 100.99 | 130898700.0 |
| 2009-08-10 | QQQ | ETF | 39.73 | 39.85 | 39.34 | 39.6 | 87163150.0 |
| 2009-08-10 | IWM | ETF | 56.93 | 57.55 | 56.71 | 57.19 | 44780600.0 |
| 2009-08-10 | DIA | ETF | 93.49 | 93.81 | 93.0 | 93.5 | 13051400.0 |
| 2009-08-10 | GLD | ETF | 92.91 | 93.14 | 92.6 | 92.93 | 6420500.0 |
| 2009-08-10 | TLT | ETF | 90.51 | 91.64 | 90.41 | 91.62 | 3150100.0 |
| 2009-08-10 | AAXJ | ETF | 50.12 | 50.12 | 49.38 | 49.71 | 124500.0 |
| 2009-08-10 | ACWI | ETF | 38.34 | 38.39 | 38.0 | 38.18 | 154300.0 |
| 2009-08-10 | ACWX | ETF | 37.12 | 37.17 | 36.73 | 37.01 | 69700.0 |
| 2009-08-10 | ADRE | ETF | 39.01 | 39.03 | 38.5 | 38.83 | 119899.0 |
| 2009-08-10 | AFK | ETF | 27.89 | 27.912 | 27.4 | 27.4776 | 18800.0 |
| 2009-08-10 | AGG | ETF | 102.04 | 102.43 | 101.66 | 102.38 | 920700.0 |
| 2009-08-10 | AGQ | ETF | 89.42 | 90.54 | 87.96 | 88.88 | 74900.0 |
| 2009-08-10 | AGZ | ETF | 106.9499 | 107.28 | 106.625 | 107.25 | 27480.0 |
| 2009-08-10 | AIA | ETF | 36.37 | 36.37 | 35.92 | 36.1999 | 32939.0 |
| 2009-08-10 | AIQ | ETF | 25.7 | 26.2 | 25.1 | 25.55 | 91071.0 |
| 2009-08-10 | AIS | ETF | 1.03 | 1.04 | 0.99 | 1.02 | 319954.0 |
| 2009-08-10 | AIVI | ETF | 39.0 | 39.0 | 38.71 | 38.87 | 19800.0 |
| 2009-08-10 | AMJ | ETF | 24.83 | 24.88 | 24.68 | 24.81 | 112463.0 |
| 2009-08-10 | AOA | ETF | 27.44 | 28.04 | 27.4 | 27.47 | 39200.0 |
| 2009-08-10 | AOK | ETF | 26.79 | 26.79 | 26.37 | 26.43 | 16293.0 |
| 2009-08-10 | AOM | ETF | 27.11 | 27.34 | 26.7397 | 26.83 | 33221.0 |
| 2009-08-10 | AOR | ETF | 27.16 | 27.72 | 27.07 | 27.14 | 25411.0 |
| 2009-08-10 | ARB | ETF | 16.38 | 16.39 | 16.06 | 16.35 | 232017.0 |
| 2009-08-10 | BAL | ETF | 32.82 | 33.218 | 32.82 | 33.16 | 6270.0 |
| 2009-08-10 | BBH | ETF | 32.8067 | 33.2033 | 32.6733 | 33.1833 | 681000.0 |
| 2009-08-10 | BIL | ETF | 91.72 | 91.72 | 91.68 | 91.7 | 134500.0 |
| 2009-08-10 | BITS | ETF | 22.44 | 22.88 | 21.8 | 22.16 | 1380.0 |
| 2009-08-10 | BIV | ETF | 77.48 | 77.84 | 77.2 | 77.74 | 66700.0 |
| 2009-08-10 | BJK | ETF | 23.87 | 24.0 | 23.01 | 23.32 | 12500.0 |
| 2009-08-10 | BKF | ETF | 39.38 | 39.63 | 38.96 | 39.33 | 223380.0 |
| 2009-08-10 | BLV | ETF | 75.08 | 75.51 | 74.47 | 75.44 | 14500.0 |
| 2009-08-10 | BMVP | ETF | 11.6067 | 11.6519 | 11.5768 | 11.64 | 22493.0 |
| 2009-08-10 | BND | ETF | 77.46 | 77.84 | 77.33 | 77.82 | 482000.0 |
| 2009-08-10 | BNE | ETF | 5.98 | 6.05 | 5.9 | 6.02 | 987001.0 |
| 2009-08-10 | BOSS | ETF | 20.06 | 20.06 | 19.27 | 19.39 | 200.0 |
| 2009-08-10 | BRF | ETF | 35.92 | 36.01 | 35.492 | 35.956 | 184737.0 |
| 2009-08-10 | BSV | ETF | 79.12 | 79.21 | 78.9 | 79.21 | 262100.0 |
| 2009-08-10 | BTF | ETF | 61.74999999999999 | 61.74999999999999 | 51.95 | 56.95 | 56548.8 |
| 2009-08-10 | BWX | ETF | 27.79 | 27.815 | 27.53 | 27.715 | 334352.0 |
| 2009-08-10 | BWZ | ETF | 35.51 | 35.55 | 35.284 | 35.5 | 16029.0 |
| 2009-08-10 | BZQ | ETF | 6788.8 | 6964.8 | 6788.8 | 6819.2 | 28.75 |
| 2009-08-10 | CBON | ETF | 1.12 | 1.28 | 1.01 | 1.14 | 128995.0 |
| 2009-08-10 | CEF | ETF | 11.96 | 11.96 | 11.79 | 11.83 | 991800.0 |
| 2009-08-10 | CEW | ETF | 21.24 | 21.38 | 21.17 | 21.2 | 76417.0 |
| 2009-08-10 | CGO | ETF | 12.9 | 12.9799 | 12.7536 | 12.969 | 30019.0 |
| 2009-08-10 | CGW | ETF | 16.16 | 16.32 | 16.12 | 16.28 | 43212.0 |
| 2009-08-10 | CHB | ETF | 0.52 | 0.53 | 0.4899 | 0.5 | 1418900.0 |
| 2009-08-10 | CHI | ETF | 11.34 | 11.51 | 11.32 | 11.35 | 116782.0 |
| 2009-08-10 | CHIC | ETF | 15.57 | 15.67 | 14.93 | 15.18 | 111961.0 |
> showing 50 of 669 rows — these rows as CSV