PREVIEW / etf_daily / 2009-03-11
file: by_date/etf_daily/2009/2009-03-11.parquet size: 28 KB rows: 632
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-11 | SPY | ETF | 73.0 | 73.75 | 71.83 | 72.64 | 356648300.0 |
| 2009-03-11 | QQQ | ETF | 27.63 | 27.99 | 27.26 | 27.75 | 173147912.0 |
| 2009-03-11 | IWM | ETF | 37.08 | 37.8 | 36.36 | 36.68 | 82274800.0 |
| 2009-03-11 | DIA | ETF | 69.69 | 70.32 | 68.82 | 69.48 | 21875300.0 |
| 2009-03-11 | GLD | ETF | 88.49 | 89.83 | 87.78 | 89.22 | 16680500.0 |
| 2009-03-11 | TLT | ETF | 101.29 | 102.76 | 100.93 | 102.76 | 3101500.0 |
| 2009-03-11 | AAXJ | ETF | 29.84 | 29.99 | 29.2 | 29.43 | 37600.0 |
| 2009-03-11 | ACWI | ETF | 25.82 | 25.94 | 25.17 | 25.55 | 428400.0 |
| 2009-03-11 | ACWX | ETF | 24.05 | 24.15 | 23.59 | 23.83 | 252011.0 |
| 2009-03-11 | ADRE | ETF | 25.64 | 25.78 | 25.1 | 25.38 | 451277.0 |
| 2009-03-11 | AFK | ETF | 18.24 | 18.31 | 18.23 | 18.31 | 300.0 |
| 2009-03-11 | AGG | ETF | 100.33 | 100.57 | 99.85 | 100.48 | 607500.0 |
| 2009-03-11 | AGQ | ETF | 75.5 | 78.0 | 74.48 | 76.42 | 71100.0 |
| 2009-03-11 | AGZ | ETF | 107.49 | 107.79 | 106.82 | 107.76 | 19404.0 |
| 2009-03-11 | AIA | ETF | 23.07 | 23.21 | 22.525 | 22.66 | 17371.0 |
| 2009-03-11 | AIQ | ETF | 35.0 | 36.0 | 32.95 | 33.0 | 44737.0 |
| 2009-03-11 | AIS | ETF | 0.4 | 0.4 | 0.37 | 0.39 | 23854.0 |
| 2009-03-11 | AIVI | ETF | 25.5 | 25.5 | 24.7 | 24.92 | 33400.0 |
| 2009-03-11 | AOA | ETF | 20.17 | 20.17 | 19.9 | 19.93 | 2700.0 |
| 2009-03-11 | AOK | ETF | 24.0268 | 24.14 | 23.75 | 23.75 | 2258.0 |
| 2009-03-11 | AOM | ETF | 23.84 | 23.84 | 22.8694 | 23.04 | 8035.0 |
| 2009-03-11 | AOR | ETF | 21.6794 | 21.68 | 21.61 | 21.61 | 9800.0 |
| 2009-03-11 | ARB | ETF | 12.97 | 12.97 | 12.49 | 12.62 | 220353.0 |
| 2009-03-11 | BAL | ETF | 24.11 | 24.11 | 23.8436 | 23.8436 | 947.0 |
| 2009-03-11 | BBH | ETF | 55.8333 | 56.17 | 55.17 | 55.2467 | 1053600.0 |
| 2009-03-11 | BIL | ETF | 91.72 | 91.76 | 91.66 | 91.76 | 281650.0 |
| 2009-03-11 | BITS | ETF | 17.32 | 17.92 | 16.4 | 16.4 | 2231.0 |
| 2009-03-11 | BIV | ETF | 74.51 | 75.05 | 74.26 | 74.57 | 110100.0 |
| 2009-03-11 | BJK | ETF | 15.11 | 15.11 | 13.62 | 13.62 | 2200.0 |
| 2009-03-11 | BKF | ETF | 22.96 | 23.31 | 22.33 | 22.5596 | 39430.0 |
| 2009-03-11 | BLV | ETF | 71.35 | 72.11 | 71.35 | 72.11 | 14600.0 |
| 2009-03-11 | BMVP | ETF | 8.94 | 9.152 | 8.91 | 8.97 | 59408.0 |
| 2009-03-11 | BND | ETF | 76.14 | 76.29 | 75.95 | 76.16 | 545900.0 |
| 2009-03-11 | BNE | ETF | 1.83 | 2.59 | 1.75 | 2.01 | 1953319.0 |
| 2009-03-11 | BSV | ETF | 78.19 | 78.19 | 77.91 | 78.02 | 257700.0 |
| 2009-03-11 | BTF | ETF | 34.849999999999994 | 36.4495 | 34.849999999999994 | 35.4 | 20482.600000000002 |
| 2009-03-11 | BWX | ETF | 24.505 | 24.72 | 24.505 | 24.71 | 284462.0 |
| 2009-03-11 | BWZ | ETF | 31.67 | 31.67 | 31.67 | 31.67 | 133.0 |
| 2009-03-11 | CBON | ETF | 0.9985 | 1.026 | 0.89 | 0.97 | 18364.0 |
| 2009-03-11 | CEF | ETF | 11.4 | 11.67 | 11.25 | 11.55 | 1143200.0 |
| 2009-03-11 | CGO | ETF | 7.59 | 8.18 | 7.59 | 8.02 | 43425.0 |
| 2009-03-11 | CGW | ETF | 10.89 | 11.1 | 10.7548 | 10.8701 | 33479.0 |
| 2009-03-11 | CHB | ETF | 0.22 | 0.2201 | 0.19 | 0.21 | 424631.0 |
| 2009-03-11 | CHI | ETF | 7.13 | 7.45 | 7.12 | 7.33 | 230242.0 |
| 2009-03-11 | CHIC | ETF | 6.49 | 6.74 | 6.21 | 6.49 | 297424.0 |
| 2009-03-11 | CHW | ETF | 4.6 | 4.64 | 4.43 | 4.54 | 192527.0 |
| 2009-03-11 | CHY | ETF | 7.26 | 7.56 | 7.21 | 7.37 | 425871.0 |
| 2009-03-11 | CMF | ETF | 50.972 | 50.972 | 50.972 | 50.972 | 200.0 |
| 2009-03-11 | CNXT | ETF | 0.39 | 0.42 | 0.39 | 0.39 | 93725.0 |
| 2009-03-11 | COW | ETF | 30.79 | 30.8044 | 30.66 | 30.66 | 13019.0 |
> showing 50 of 632 rows — these rows as CSV