PREVIEW / etf_daily / 2009-06-03
file: by_date/etf_daily/2009/2009-06-03.parquet size: 29 KB rows: 656
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-06-03 | SPY | ETF | 94.04 | 94.13 | 92.76 | 93.65 | 235310500.0 |
| 2009-06-03 | QQQ | ETF | 36.28 | 36.37 | 35.93 | 36.33 | 93329716.0 |
| 2009-06-03 | IWM | ETF | 52.31 | 52.51 | 51.74 | 52.43 | 44068400.0 |
| 2009-06-03 | DIA | ETF | 87.02 | 87.11 | 86.08 | 86.95 | 9488600.0 |
| 2009-06-03 | GLD | ETF | 95.9 | 96.21 | 94.31 | 94.41 | 18204700.0 |
| 2009-06-03 | TLT | ETF | 91.96 | 92.61 | 91.33 | 92.44 | 6727200.0 |
| 2009-06-03 | AAXJ | ETF | 45.61 | 45.61 | 44.42 | 45.02 | 262800.0 |
| 2009-06-03 | ACWI | ETF | 35.89 | 35.89 | 35.09 | 35.44 | 133000.0 |
| 2009-06-03 | ACWX | ETF | 34.97 | 34.97 | 34.128 | 34.47 | 53785.0 |
| 2009-06-03 | ADRE | ETF | 36.54 | 36.54 | 35.17 | 35.39 | 255717.0 |
| 2009-06-03 | AFK | ETF | 28.15 | 28.2 | 27.5 | 27.5 | 57910.0 |
| 2009-06-03 | AGG | ETF | 101.0 | 101.48 | 101.0 | 101.43 | 797700.0 |
| 2009-06-03 | AGQ | ETF | 111.98 | 112.72 | 103.7 | 105.0 | 327950.0 |
| 2009-06-03 | AGZ | ETF | 106.86 | 107.59 | 106.81 | 107.1001 | 112985.0 |
| 2009-06-03 | AIA | ETF | 33.79 | 33.79 | 32.45 | 32.78 | 34811.0 |
| 2009-06-03 | AIQ | ETF | 36.05 | 37.45 | 35.75 | 37.25 | 45715.0 |
| 2009-06-03 | AIS | ETF | 0.5699 | 0.6 | 0.5601 | 0.6 | 119860.0 |
| 2009-06-03 | AIVI | ETF | 37.22 | 37.22 | 36.3 | 36.66 | 13200.0 |
| 2009-06-03 | AMJ | ETF | 23.51 | 23.51 | 22.5505 | 22.78 | 57223.0 |
| 2009-06-03 | AOA | ETF | 25.65 | 25.72 | 25.5 | 25.68 | 7800.0 |
| 2009-06-03 | AOK | ETF | 26.42 | 26.42 | 25.38 | 25.73 | 8055.0 |
| 2009-06-03 | AOM | ETF | 26.09 | 26.15 | 25.88 | 26.1403 | 7514.0 |
| 2009-06-03 | AOR | ETF | 26.0 | 26.0 | 25.84 | 25.9 | 4989.0 |
| 2009-06-03 | ARB | ETF | 20.85 | 20.85 | 20.09 | 20.78 | 207553.0 |
| 2009-06-03 | BAL | ETF | 32.73 | 32.73 | 31.54 | 31.54 | 8350.0 |
| 2009-06-03 | BBH | ETF | 30.38 | 31.4933 | 30.2867 | 31.2533 | 1088100.0 |
| 2009-06-03 | BIL | ETF | 91.68 | 91.76 | 91.68 | 91.72 | 76500.0 |
| 2009-06-03 | BITS | ETF | 18.7692 | 19.32 | 18.76 | 19.0 | 2375.0 |
| 2009-06-03 | BIV | ETF | 76.3 | 76.59 | 76.02 | 76.29 | 159500.0 |
| 2009-06-03 | BJK | ETF | 22.25 | 22.25 | 21.0 | 21.06 | 10900.0 |
| 2009-06-03 | BKF | ETF | 37.23 | 37.23 | 35.83 | 36.28 | 644502.0 |
| 2009-06-03 | BLV | ETF | 71.97 | 72.81 | 71.97 | 72.43 | 9900.0 |
| 2009-06-03 | BMVP | ETF | 11.1133 | 11.1133 | 10.9972 | 11.0467 | 12751.0 |
| 2009-06-03 | BND | ETF | 77.13 | 77.29 | 76.94 | 77.24 | 420100.0 |
| 2009-06-03 | BNE | ETF | 6.21 | 6.48 | 5.87 | 6.47 | 148718.0 |
| 2009-06-03 | BRF | ETF | 28.32 | 28.32 | 27.05 | 27.37 | 87206.0 |
| 2009-06-03 | BSV | ETF | 79.07 | 79.2 | 78.86 | 79.1 | 268000.0 |
| 2009-06-03 | BTF | ETF | 48.15 | 48.349999999999994 | 47.599999999999994 | 48.2 | 9061.800000000001 |
| 2009-06-03 | BWX | ETF | 27.375 | 27.385 | 27.11 | 27.11 | 626842.0 |
| 2009-06-03 | BWZ | ETF | 35.45 | 35.45 | 35.3 | 35.3 | 1125.0 |
| 2009-06-03 | CBON | ETF | 1.27 | 1.27 | 1.12 | 1.15 | 20646.0 |
| 2009-06-03 | CEF | ETF | 12.35 | 12.47 | 12.01 | 12.04 | 1402800.0 |
| 2009-06-03 | CEW | ETF | 20.76 | 20.77 | 20.6153 | 20.6899 | 31811.0 |
| 2009-06-03 | CGO | ETF | 11.47 | 11.57 | 11.45 | 11.5 | 28430.0 |
| 2009-06-03 | CGW | ETF | 15.56 | 15.7 | 15.27 | 15.47 | 98246.0 |
| 2009-06-03 | CHB | ETF | 0.43 | 0.44 | 0.4 | 0.41 | 704913.0 |
| 2009-06-03 | CHI | ETF | 10.61 | 10.81 | 10.61 | 10.74 | 155105.0 |
| 2009-06-03 | CHIC | ETF | 11.28 | 11.38 | 11.02 | 11.26 | 187837.0 |
| 2009-06-03 | CHW | ETF | 7.3 | 7.45 | 7.23 | 7.31 | 235624.0 |
| 2009-06-03 | CHY | ETF | 10.61 | 10.73 | 10.51 | 10.72 | 236889.0 |
> showing 50 of 656 rows — these rows as CSV