PREVIEW / etf_daily / 2009-03-24
file: by_date/etf_daily/2009/2009-03-24.parquet size: 28 KB rows: 642
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-03-24 | SPY | ETF | 81.24 | 82.36 | 80.51 | 80.6 | 330271000.0 |
| 2009-03-24 | QQQ | ETF | 30.65 | 30.88 | 30.31 | 30.331 | 120849455.0 |
| 2009-03-24 | IWM | ETF | 42.7 | 43.11 | 41.51 | 41.56 | 70562700.0 |
| 2009-03-24 | DIA | ETF | 76.91 | 77.95 | 76.44 | 76.7 | 20383500.0 |
| 2009-03-24 | GLD | ETF | 90.76 | 91.66 | 90.25 | 90.95 | 16979800.0 |
| 2009-03-24 | TLT | ETF | 102.19 | 105.16 | 101.93 | 104.0 | 5477100.0 |
| 2009-03-24 | AAXJ | ETF | 34.95 | 34.95 | 33.52 | 33.54 | 144400.0 |
| 2009-03-24 | ACWI | ETF | 28.82 | 29.36 | 28.74 | 28.79 | 94500.0 |
| 2009-03-24 | ACWX | ETF | 27.14 | 27.55 | 27.01 | 27.02 | 54491.0 |
| 2009-03-24 | ADRE | ETF | 28.62 | 28.79 | 28.25 | 28.34 | 306201.0 |
| 2009-03-24 | AFK | ETF | 20.0 | 20.35 | 20.0 | 20.28 | 145400.0 |
| 2009-03-24 | AGG | ETF | 100.83 | 101.18 | 100.64 | 100.64 | 934100.0 |
| 2009-03-24 | AGQ | ETF | 84.44 | 84.94 | 82.18 | 84.6 | 112650.0 |
| 2009-03-24 | AGZ | ETF | 107.575 | 108.22 | 107.52 | 107.61 | 15159.0 |
| 2009-03-24 | AIA | ETF | 26.0 | 26.09 | 25.5 | 25.5 | 45032.0 |
| 2009-03-24 | AIQ | ETF | 35.0 | 35.7 | 33.85 | 33.95 | 25304.0 |
| 2009-03-24 | AIS | ETF | 0.43 | 0.43 | 0.39 | 0.43 | 56792.0 |
| 2009-03-24 | AIVI | ETF | 29.3 | 29.36 | 28.62 | 28.7 | 27200.0 |
| 2009-03-24 | AOA | ETF | 22.09 | 22.4 | 21.9 | 21.95 | 21900.0 |
| 2009-03-24 | AOK | ETF | 24.9 | 25.0 | 24.8 | 24.8 | 21373.0 |
| 2009-03-24 | AOM | ETF | 24.14 | 24.25 | 24.14 | 24.25 | 17698.0 |
| 2009-03-24 | AOR | ETF | 23.86 | 23.86 | 22.76 | 23.1101 | 104599.0 |
| 2009-03-24 | ARB | ETF | 13.31 | 13.41 | 12.4803 | 12.62 | 309461.0 |
| 2009-03-24 | BAL | ETF | 25.62 | 25.69 | 25.37 | 25.51 | 6000.0 |
| 2009-03-24 | BBH | ETF | 57.81 | 58.06 | 57.28 | 57.36 | 878400.0 |
| 2009-03-24 | BIL | ETF | 91.72 | 91.76 | 91.72 | 91.74 | 133750.0 |
| 2009-03-24 | BITS | ETF | 18.2 | 18.2 | 16.08 | 17.988 | 2132.0 |
| 2009-03-24 | BIV | ETF | 76.06 | 76.58 | 75.94 | 75.94 | 144500.0 |
| 2009-03-24 | BJK | ETF | 15.07 | 16.59 | 15.07 | 16.0 | 6000.0 |
| 2009-03-24 | BKF | ETF | 26.37 | 26.38 | 25.01 | 25.51 | 75549.0 |
| 2009-03-24 | BLV | ETF | 72.89 | 73.8 | 72.5 | 73.46 | 12000.0 |
| 2009-03-24 | BMVP | ETF | 9.837 | 10.033 | 9.837 | 9.837 | 16716.0 |
| 2009-03-24 | BND | ETF | 76.62 | 77.03 | 76.52 | 76.78 | 475500.0 |
| 2009-03-24 | BNE | ETF | 3.67 | 3.6874 | 3.28 | 3.46 | 429118.0 |
| 2009-03-24 | BOSS | ETF | 11.1 | 11.37 | 11.1 | 11.37 | 100.0 |
| 2009-03-24 | BSV | ETF | 78.55 | 78.55 | 78.21 | 78.37 | 167200.0 |
| 2009-03-24 | BTF | ETF | 40.449999999999996 | 40.8 | 39.849999999999994 | 40.65 | 11036.0 |
| 2009-03-24 | BWX | ETF | 25.85 | 25.93 | 25.705 | 25.75 | 220076.0 |
| 2009-03-24 | BWZ | ETF | 33.2183 | 33.25 | 33.15 | 33.15 | 1360.0 |
| 2009-03-24 | CBON | ETF | 1.29 | 1.32 | 1.15 | 1.16 | 12105.0 |
| 2009-03-24 | CEF | ETF | 12.19 | 12.25 | 11.97 | 12.08 | 1282500.0 |
| 2009-03-24 | CGO | ETF | 9.0 | 9.29 | 8.85 | 9.15 | 27374.0 |
| 2009-03-24 | CGW | ETF | 12.47 | 12.5 | 12.062 | 12.2 | 93772.0 |
| 2009-03-24 | CHB | ETF | 0.38 | 0.54 | 0.35 | 0.4 | 2863746.0 |
| 2009-03-24 | CHI | ETF | 8.58 | 8.73 | 8.44 | 8.68 | 143138.0 |
| 2009-03-24 | CHIC | ETF | 7.45 | 7.58 | 7.03 | 7.08 | 89971.0 |
| 2009-03-24 | CHW | ETF | 5.55 | 5.61 | 5.43 | 5.53 | 243425.0 |
| 2009-03-24 | CHY | ETF | 8.2 | 8.34 | 8.11 | 8.29 | 154029.0 |
| 2009-03-24 | CMF | ETF | 51.685 | 52.15 | 51.685 | 52.12 | 10364.0 |
| 2009-03-24 | CNXT | ETF | 0.7 | 0.702 | 0.65 | 0.69 | 164383.0 |
> showing 50 of 642 rows — these rows as CSV