PREVIEW / etf_daily / 2009-04-15
file: by_date/etf_daily/2009/2009-04-15.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-04-15 | SPY | ETF | 83.84 | 85.42 | 83.61 | 85.25 | 250726100.0 |
| 2009-04-15 | QQQ | ETF | 32.24 | 32.43 | 31.85 | 32.4 | 124808143.0 |
| 2009-04-15 | IWM | ETF | 45.01 | 46.15 | 44.89 | 46.0 | 48436100.0 |
| 2009-04-15 | DIA | ETF | 79.04 | 80.46 | 78.74 | 80.3 | 18263400.0 |
| 2009-04-15 | GLD | ETF | 87.42 | 87.94 | 87.23 | 87.5 | 6857000.0 |
| 2009-04-15 | TLT | ETF | 104.13 | 104.3 | 102.88 | 103.65 | 1152500.0 |
| 2009-04-15 | AAXJ | ETF | 37.36 | 37.58 | 37.04 | 37.58 | 67500.0 |
| 2009-04-15 | ACWI | ETF | 30.43 | 30.97 | 30.43 | 30.96 | 101700.0 |
| 2009-04-15 | ACWX | ETF | 28.93 | 29.25 | 28.85 | 29.15 | 784919.0 |
| 2009-04-15 | ADRE | ETF | 30.09 | 30.41 | 30.0 | 30.36 | 100138.0 |
| 2009-04-15 | AFK | ETF | 20.33 | 20.44 | 20.315 | 20.44 | 1994.0 |
| 2009-04-15 | AGG | ETF | 101.21 | 101.41 | 101.0 | 101.41 | 534500.0 |
| 2009-04-15 | AGQ | ETF | 75.4 | 76.0 | 74.38 | 74.48 | 47150.0 |
| 2009-04-15 | AGZ | ETF | 108.252 | 108.39 | 107.866 | 108.39 | 4175.0 |
| 2009-04-15 | AIA | ETF | 27.46 | 28.2 | 27.46 | 28.2 | 30922.0 |
| 2009-04-15 | AIQ | ETF | 37.75 | 38.7 | 37.5 | 38.65 | 32730.0 |
| 2009-04-15 | AIS | ETF | 0.47 | 0.47 | 0.4499 | 0.47 | 43200.0 |
| 2009-04-15 | AIVI | ETF | 30.56 | 31.32 | 30.56 | 31.3 | 8200.0 |
| 2009-04-15 | AMJ | ETF | 20.0 | 20.13 | 20.0 | 20.13 | 6722.0 |
| 2009-04-15 | AOA | ETF | 23.19 | 24.46 | 22.1 | 23.26 | 53600.0 |
| 2009-04-15 | AOK | ETF | 25.1494 | 25.36 | 25.148 | 25.26 | 2189.0 |
| 2009-04-15 | AOM | ETF | 25.09 | 26.4 | 24.426 | 24.67 | 10234.0 |
| 2009-04-15 | AOR | ETF | 23.91 | 24.05 | 23.85 | 24.05 | 9656.0 |
| 2009-04-15 | ARB | ETF | 17.57 | 18.18 | 17.54 | 18.09 | 242857.0 |
| 2009-04-15 | BAL | ETF | 27.14 | 27.5 | 27.14 | 27.5 | 200.0 |
| 2009-04-15 | BBH | ETF | 29.64 | 29.6833 | 29.0 | 29.3367 | 581400.0 |
| 2009-04-15 | BIL | ETF | 91.72 | 91.74 | 91.68 | 91.7 | 158950.0 |
| 2009-04-15 | BITS | ETF | 18.0 | 18.0 | 17.4 | 17.8 | 844.0 |
| 2009-04-15 | BIV | ETF | 76.59 | 77.02 | 76.36 | 76.95 | 86200.0 |
| 2009-04-15 | BJK | ETF | 17.7 | 18.8 | 17.69 | 17.8 | 2600.0 |
| 2009-04-15 | BKF | ETF | 29.4 | 29.4 | 28.536 | 29.07 | 78409.0 |
| 2009-04-15 | BLV | ETF | 73.83 | 73.95 | 73.25 | 73.95 | 10800.0 |
| 2009-04-15 | BMVP | ETF | 10.25 | 10.39 | 10.24 | 10.38 | 23942.0 |
| 2009-04-15 | BND | ETF | 77.31 | 77.45 | 77.1 | 77.4 | 639000.0 |
| 2009-04-15 | BNE | ETF | 3.95 | 4.4 | 3.95 | 4.4 | 166826.0 |
| 2009-04-15 | BOSS | ETF | 12.15 | 12.4 | 12.15 | 12.4 | 2200.0 |
| 2009-04-15 | BSV | ETF | 78.84 | 78.87 | 78.67 | 78.83 | 155400.0 |
| 2009-04-15 | BTF | ETF | 45.7 | 46.36999999999999 | 45.0025 | 46.15 | 6953.400000000001 |
| 2009-04-15 | BWX | ETF | 25.67 | 25.765 | 25.615 | 25.75 | 170414.0 |
| 2009-04-15 | BWZ | ETF | 32.9486 | 32.9486 | 32.9486 | 32.9486 | 200.0 |
| 2009-04-15 | CBON | ETF | 2.36 | 2.44 | 2.31 | 2.33 | 8900.0 |
| 2009-04-15 | CEF | ETF | 10.97 | 11.14 | 10.9 | 11.0 | 1272600.0 |
| 2009-04-15 | CGO | ETF | 9.22 | 9.45 | 9.22 | 9.4 | 18452.0 |
| 2009-04-15 | CGW | ETF | 12.97 | 13.09 | 12.57 | 13.09 | 20501.0 |
| 2009-04-15 | CHB | ETF | 0.6092 | 0.63 | 0.5 | 0.57 | 717720.0 |
| 2009-04-15 | CHI | ETF | 8.76 | 9.24 | 8.74 | 9.15 | 270861.0 |
| 2009-04-15 | CHIC | ETF | 11.39 | 12.2 | 11.21 | 12.16 | 541125.0 |
| 2009-04-15 | CHW | ETF | 5.9 | 6.02 | 5.8734 | 6.0 | 158256.0 |
| 2009-04-15 | CHY | ETF | 8.56 | 8.77 | 8.55 | 8.7 | 160333.0 |
| 2009-04-15 | CMF | ETF | 52.06 | 52.1 | 51.7274 | 52.1 | 21730.0 |
> showing 50 of 642 rows — these rows as CSV