PREVIEW / etf_daily / 2009-04-02
file: by_date/etf_daily/2009/2009-04-02.parquet size: 28 KB rows: 648
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-02 | SPY | ETF | 83.08 | 84.61 | 81.13 | 83.43 | 476230700.0 |
| 2009-04-02 | QQQ | ETF | 31.34 | 32.27 | 31.23 | 31.76 | 212272326.0 |
| 2009-04-02 | IWM | ETF | 44.12 | 45.57 | 43.82 | 44.92 | 92895500.0 |
| 2009-04-02 | DIA | ETF | 79.38 | 80.76 | 78.98 | 79.71 | 30176700.0 |
| 2009-04-02 | GLD | ETF | 88.75 | 89.36 | 87.92 | 88.8 | 24829000.0 |
| 2009-04-02 | TLT | ETF | 105.89 | 106.07 | 104.84 | 105.07 | 1766300.0 |
| 2009-04-02 | AAXJ | ETF | 35.1 | 36.68 | 34.52 | 36.18 | 77000.0 |
| 2009-04-02 | ACWI | ETF | 28.69 | 30.64 | 28.69 | 30.16 | 56900.0 |
| 2009-04-02 | ACWX | ETF | 28.35 | 28.9948 | 28.27 | 28.55 | 32718.0 |
| 2009-04-02 | ADRE | ETF | 29.27 | 30.08 | 29.27 | 29.81 | 195722.0 |
| 2009-04-02 | AFK | ETF | 21.41 | 22.03 | 20.75 | 20.7947 | 4900.0 |
| 2009-04-02 | AGG | ETF | 101.11 | 101.12 | 100.54 | 100.75 | 960500.0 |
| 2009-04-02 | AGQ | ETF | 74.7 | 80.12 | 73.6 | 77.92 | 156000.0 |
| 2009-04-02 | AGZ | ETF | 108.03 | 108.03 | 107.1301 | 107.7 | 17798.0 |
| 2009-04-02 | AIA | ETF | 26.7 | 27.573 | 26.51 | 27.35 | 24414.0 |
| 2009-04-02 | AIQ | ETF | 34.65 | 35.4 | 34.35 | 34.55 | 34886.0 |
| 2009-04-02 | AIS | ETF | 0.41 | 0.43 | 0.41 | 0.43 | 47190.0 |
| 2009-04-02 | AIVI | ETF | 30.04 | 30.8 | 30.04 | 30.38 | 15700.0 |
| 2009-04-02 | AMJ | ETF | 19.69 | 19.8 | 19.56 | 19.59 | 19300.0 |
| 2009-04-02 | AOA | ETF | 22.73 | 23.12 | 22.71 | 22.82 | 34700.0 |
| 2009-04-02 | AOK | ETF | 25.0394 | 25.99 | 24.61 | 25.04 | 7963.0 |
| 2009-04-02 | AOM | ETF | 24.32 | 24.6299 | 24.32 | 24.39 | 10357.0 |
| 2009-04-02 | AOR | ETF | 24.19 | 24.19 | 23.4 | 23.61 | 38629.0 |
| 2009-04-02 | ARB | ETF | 15.58 | 16.35 | 15.33 | 15.99 | 451142.0 |
| 2009-04-02 | BAL | ETF | 26.55 | 26.7112 | 26.55 | 26.7112 | 1150.0 |
| 2009-04-02 | BBH | ETF | 30.25 | 30.25 | 29.2333 | 29.3867 | 848400.0 |
| 2009-04-02 | BIL | ETF | 91.7 | 91.74 | 91.66 | 91.66 | 1172500.0 |
| 2009-04-02 | BITS | ETF | 18.0 | 18.96 | 18.0 | 18.56 | 2488.0 |
| 2009-04-02 | BIV | ETF | 76.43 | 76.49 | 75.79 | 76.2 | 89800.0 |
| 2009-04-02 | BJK | ETF | 15.37 | 17.8 | 14.71 | 16.2 | 8100.0 |
| 2009-04-02 | BKF | ETF | 27.0 | 27.7 | 26.98 | 27.26 | 76637.0 |
| 2009-04-02 | BLV | ETF | 73.42 | 73.84 | 72.88 | 73.06 | 10900.0 |
| 2009-04-02 | BMVP | ETF | 10.15 | 10.35 | 10.14 | 10.19 | 68095.0 |
| 2009-04-02 | BND | ETF | 77.06 | 77.11 | 76.66 | 76.88 | 567900.0 |
| 2009-04-02 | BNE | ETF | 3.17 | 3.74 | 3.14 | 3.5 | 463849.0 |
| 2009-04-02 | BOSS | ETF | 10.85 | 11.3 | 10.85 | 11.3 | 100.0 |
| 2009-04-02 | BSV | ETF | 78.61 | 78.61 | 78.4 | 78.45 | 237100.0 |
| 2009-04-02 | BTF | ETF | 41.95 | 43.25 | 41.74999999999999 | 42.85 | 13537.6 |
| 2009-04-02 | BWX | ETF | 25.66 | 25.805 | 25.66 | 25.725 | 238114.0 |
| 2009-04-02 | BWZ | ETF | 32.9889 | 33.08 | 32.9889 | 33.08 | 653.0 |
| 2009-04-02 | CBON | ETF | 1.84 | 2.69 | 1.71 | 2.55 | 64884.0 |
| 2009-04-02 | CEF | ETF | 11.85 | 12.0 | 11.7 | 11.88 | 1251300.0 |
| 2009-04-02 | CGO | ETF | 9.52 | 9.595 | 9.34 | 9.41 | 20916.0 |
| 2009-04-02 | CGW | ETF | 12.63 | 12.84 | 12.454 | 12.67 | 44120.0 |
| 2009-04-02 | CHB | ETF | 0.52 | 0.55 | 0.5 | 0.52 | 815947.0 |
| 2009-04-02 | CHI | ETF | 8.7 | 9.0 | 8.68 | 8.74 | 178982.0 |
| 2009-04-02 | CHIC | ETF | 8.66 | 9.18 | 8.55 | 8.84 | 329169.0 |
| 2009-04-02 | CHW | ETF | 5.6 | 5.71 | 5.55 | 5.7 | 150065.0 |
| 2009-04-02 | CHY | ETF | 8.48 | 8.578 | 8.33 | 8.49 | 138200.0 |
| 2009-04-02 | CMF | ETF | 51.98 | 51.98 | 51.87 | 51.965 | 17584.0 |
> showing 50 of 648 rows — these rows as CSV