PREVIEW / etf_daily / 2009-04-01
file: by_date/etf_daily/2009/2009-04-01.parquet size: 28 KB rows: 640
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-01 | SPY | ETF | 78.53 | 81.42 | 78.33 | 81.06 | 377018300.0 |
| 2009-04-01 | QQQ | ETF | 29.94 | 30.88 | 29.79 | 30.77 | 137949921.0 |
| 2009-04-01 | IWM | ETF | 41.34 | 43.0 | 41.11 | 42.78 | 66464100.0 |
| 2009-04-01 | DIA | ETF | 74.88 | 77.87 | 74.8 | 77.53 | 25416600.0 |
| 2009-04-01 | GLD | ETF | 91.34 | 91.38 | 90.21 | 91.03 | 12298700.0 |
| 2009-04-01 | TLT | ETF | 106.12 | 106.56 | 105.53 | 106.37 | 2383400.0 |
| 2009-04-01 | AAXJ | ETF | 33.37 | 34.31 | 33.26 | 34.25 | 71200.0 |
| 2009-04-01 | ACWI | ETF | 28.18 | 29.11 | 28.03 | 29.0 | 1575300.0 |
| 2009-04-01 | ACWX | ETF | 26.51 | 27.39 | 26.38 | 27.32 | 35443.0 |
| 2009-04-01 | ADRE | ETF | 27.62 | 28.45 | 27.25 | 28.42 | 568629.0 |
| 2009-04-01 | AFK | ETF | 19.93 | 20.04 | 19.91 | 20.04 | 800.0 |
| 2009-04-01 | AGG | ETF | 101.19 | 101.28 | 100.61 | 101.07 | 579100.0 |
| 2009-04-01 | AGQ | ETF | 79.76 | 80.02 | 77.06 | 78.52 | 44350.0 |
| 2009-04-01 | AGZ | ETF | 107.824 | 108.3 | 107.806 | 108.3 | 39865.0 |
| 2009-04-01 | AIA | ETF | 25.17 | 25.9 | 25.17 | 25.83 | 23336.0 |
| 2009-04-01 | AIQ | ETF | 33.85 | 34.4 | 33.45 | 34.05 | 18880.0 |
| 2009-04-01 | AIS | ETF | 0.461 | 0.461 | 0.39 | 0.42 | 56750.0 |
| 2009-04-01 | AIVI | ETF | 28.29 | 29.09 | 28.29 | 29.01 | 113400.0 |
| 2009-04-01 | AOA | ETF | 21.68 | 22.1 | 21.52 | 22.1 | 5800.0 |
| 2009-04-01 | AOK | ETF | 24.92 | 24.93 | 24.914 | 24.9284 | 1312.0 |
| 2009-04-01 | AOM | ETF | 23.8868 | 24.0576 | 23.8868 | 24.0099 | 3978.0 |
| 2009-04-01 | AOR | ETF | 22.98 | 23.1868 | 22.98 | 23.1768 | 2910.0 |
| 2009-04-01 | ARB | ETF | 14.91 | 15.58 | 14.89 | 15.31 | 288370.0 |
| 2009-04-01 | BAL | ETF | 26.6 | 26.84 | 26.6 | 26.84 | 1392.0 |
| 2009-04-01 | BBH | ETF | 30.0167 | 30.12 | 29.22 | 29.7967 | 1054200.0 |
| 2009-04-01 | BIL | ETF | 91.72 | 91.78 | 91.7 | 91.72 | 218500.0 |
| 2009-04-01 | BITS | ETF | 16.52 | 18.6 | 16.52 | 18.04 | 2872.0 |
| 2009-04-01 | BIV | ETF | 76.43 | 76.59 | 76.17 | 76.55 | 72500.0 |
| 2009-04-01 | BJK | ETF | 15.57 | 16.0 | 15.4 | 15.46 | 5000.0 |
| 2009-04-01 | BKF | ETF | 24.79 | 25.88 | 24.77 | 25.79 | 138528.0 |
| 2009-04-01 | BLV | ETF | 74.07 | 74.1 | 73.34 | 73.35 | 24600.0 |
| 2009-04-01 | BMVP | ETF | 9.7767 | 9.9967 | 9.6711 | 9.9567 | 23646.0 |
| 2009-04-01 | BND | ETF | 77.08 | 77.15 | 76.86 | 77.03 | 521700.0 |
| 2009-04-01 | BNE | ETF | 3.09 | 3.11 | 2.85 | 3.06 | 334714.0 |
| 2009-04-01 | BSV | ETF | 78.63 | 78.67 | 78.5 | 78.55 | 250700.0 |
| 2009-04-01 | BTF | ETF | 39.949999999999996 | 41.15 | 39.8505 | 41.1 | 10700.800000000001 |
| 2009-04-01 | BWX | ETF | 25.57 | 25.625 | 25.49 | 25.625 | 155546.0 |
| 2009-04-01 | BWZ | ETF | 32.7358 | 32.7358 | 32.73 | 32.73 | 445.0 |
| 2009-04-01 | CBON | ETF | 1.96 | 1.96 | 1.39 | 1.75 | 71203.0 |
| 2009-04-01 | CEF | ETF | 12.05 | 12.08 | 11.95 | 12.03 | 746100.0 |
| 2009-04-01 | CGO | ETF | 8.84 | 9.3 | 8.71 | 9.18 | 19911.0 |
| 2009-04-01 | CGW | ETF | 12.32 | 12.362 | 11.98 | 12.33 | 81613.0 |
| 2009-04-01 | CHB | ETF | 0.48 | 0.5142 | 0.45 | 0.5 | 610973.0 |
| 2009-04-01 | CHI | ETF | 8.42 | 8.62 | 8.42 | 8.54 | 159128.0 |
| 2009-04-01 | CHIC | ETF | 8.0 | 8.64 | 7.95 | 8.62 | 224839.0 |
| 2009-04-01 | CHW | ETF | 5.43 | 5.52 | 5.3476 | 5.49 | 136888.0 |
| 2009-04-01 | CHY | ETF | 8.04 | 8.25 | 8.03 | 8.21 | 108074.0 |
| 2009-04-01 | CMF | ETF | 51.795 | 52.04 | 51.617 | 51.617 | 27608.0 |
| 2009-04-01 | CNXT | ETF | 0.67 | 0.68 | 0.65 | 0.68 | 92555.0 |
| 2009-04-01 | COW | ETF | 30.8592 | 30.8599 | 30.5801 | 30.76 | 3185.0 |
> showing 50 of 640 rows — these rows as CSV