PREVIEW / etf_daily / 2009-04-03
file: by_date/etf_daily/2009/2009-04-03.parquet size: 28 KB rows: 641
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-04-03 | SPY | ETF | 83.49 | 84.28 | 82.67 | 84.26 | 284646300.0 |
| 2009-04-03 | QQQ | ETF | 32.05 | 32.4 | 31.83 | 32.35 | 134577245.0 |
| 2009-04-03 | IWM | ETF | 44.86 | 45.64 | 44.36 | 45.63 | 50763600.0 |
| 2009-04-03 | DIA | ETF | 79.76 | 80.19 | 78.96 | 80.16 | 20617100.0 |
| 2009-04-03 | GLD | ETF | 88.96 | 89.44 | 87.52 | 87.59 | 16343600.0 |
| 2009-04-03 | TLT | ETF | 104.91 | 105.16 | 102.66 | 102.92 | 3316800.0 |
| 2009-04-03 | AAXJ | ETF | 36.28 | 36.42 | 35.79 | 36.38 | 90800.0 |
| 2009-04-03 | ACWI | ETF | 30.13 | 30.44 | 29.97 | 30.42 | 210000.0 |
| 2009-04-03 | ACWX | ETF | 28.58 | 28.84 | 28.33 | 28.82 | 115773.0 |
| 2009-04-03 | ADRE | ETF | 29.56 | 30.0399 | 29.3901 | 29.977 | 299223.0 |
| 2009-04-03 | AFK | ETF | 20.47 | 20.76 | 20.47 | 20.55 | 4900.0 |
| 2009-04-03 | AGG | ETF | 100.9 | 100.9 | 100.01 | 100.42 | 3081500.0 |
| 2009-04-03 | AGQ | ETF | 76.86 | 77.32 | 74.94 | 75.8 | 67600.0 |
| 2009-04-03 | AGZ | ETF | 107.46 | 107.84 | 107.28 | 107.35 | 16866.0 |
| 2009-04-03 | AIA | ETF | 27.49 | 27.49 | 26.88 | 27.31 | 8428.0 |
| 2009-04-03 | AIQ | ETF | 34.5 | 34.75 | 34.05 | 34.6 | 31733.0 |
| 2009-04-03 | AIS | ETF | 0.43 | 0.43 | 0.3999 | 0.43 | 133668.0 |
| 2009-04-03 | AIVI | ETF | 30.54 | 30.85 | 30.17 | 30.75 | 13600.0 |
| 2009-04-03 | AMJ | ETF | 19.67 | 19.82 | 19.4 | 19.64 | 50525.0 |
| 2009-04-03 | AOA | ETF | 22.75 | 22.9 | 22.65 | 22.89 | 14100.0 |
| 2009-04-03 | AOK | ETF | 25.03 | 25.03 | 24.96 | 25.028 | 1936.0 |
| 2009-04-03 | AOM | ETF | 24.2744 | 24.65 | 23.41 | 23.41 | 4820.0 |
| 2009-04-03 | AOR | ETF | 23.99 | 23.99 | 23.6061 | 23.84 | 10892.0 |
| 2009-04-03 | ARB | ETF | 15.8 | 16.3 | 15.69 | 16.22 | 567441.0 |
| 2009-04-03 | BAL | ETF | 26.3028 | 26.86 | 26.3028 | 26.86 | 4440.0 |
| 2009-04-03 | BBH | ETF | 30.2633 | 30.4133 | 29.28 | 29.5533 | 539400.0 |
| 2009-04-03 | BIL | ETF | 91.66 | 91.72 | 91.66 | 91.72 | 274350.0 |
| 2009-04-03 | BITS | ETF | 18.4 | 18.96 | 17.84 | 18.96 | 300.0 |
| 2009-04-03 | BIV | ETF | 76.04 | 76.21 | 75.55 | 75.6 | 129700.0 |
| 2009-04-03 | BJK | ETF | 16.97 | 17.76 | 16.64 | 17.12 | 9900.0 |
| 2009-04-03 | BKF | ETF | 27.58 | 27.82 | 27.2772 | 27.75 | 26005.0 |
| 2009-04-03 | BLV | ETF | 72.84 | 73.06 | 71.7 | 72.11 | 29700.0 |
| 2009-04-03 | BMVP | ETF | 10.18 | 10.3 | 10.15 | 10.3 | 51207.0 |
| 2009-04-03 | BND | ETF | 76.85 | 76.96 | 76.46 | 76.47 | 546800.0 |
| 2009-04-03 | BNE | ETF | 3.54 | 3.54 | 3.18 | 3.53 | 97328.0 |
| 2009-04-03 | BSV | ETF | 78.48 | 78.52 | 78.15 | 78.32 | 177600.0 |
| 2009-04-03 | BTF | ETF | 42.75 | 44.0 | 42.15 | 43.49999999999999 | 21023.800000000003 |
| 2009-04-03 | BWX | ETF | 25.72 | 25.8 | 25.65 | 25.8 | 156694.0 |
| 2009-04-03 | BWZ | ETF | 33.0935 | 33.18 | 33.0935 | 33.18 | 740.0 |
| 2009-04-03 | CBON | ETF | 2.82 | 2.82 | 2.07 | 2.4001 | 84360.0 |
| 2009-04-03 | CEF | ETF | 11.87 | 11.87 | 11.57 | 11.65 | 1816200.0 |
| 2009-04-03 | CGO | ETF | 9.25 | 9.5 | 9.03 | 9.41 | 17185.0 |
| 2009-04-03 | CGW | ETF | 12.82 | 12.88 | 12.612 | 12.84 | 101089.0 |
| 2009-04-03 | CHB | ETF | 0.53 | 0.54 | 0.49 | 0.53 | 895863.0 |
| 2009-04-03 | CHI | ETF | 8.7 | 8.89 | 8.6304 | 8.8 | 207475.0 |
| 2009-04-03 | CHIC | ETF | 8.8 | 9.77 | 8.77 | 9.59 | 710337.0 |
| 2009-04-03 | CHW | ETF | 5.7 | 5.77 | 5.61 | 5.74 | 140276.0 |
| 2009-04-03 | CHY | ETF | 8.35 | 8.45 | 8.3 | 8.43 | 117876.0 |
| 2009-04-03 | CMF | ETF | 51.9525 | 51.965 | 51.785 | 51.875 | 28760.0 |
| 2009-04-03 | CNXT | ETF | 0.72 | 0.74 | 0.7 | 0.74 | 137586.0 |
> showing 50 of 641 rows — these rows as CSV