PREVIEW / etf_daily / 2005-05-24
file: by_date/etf_daily/2005/2005-05-24.parquet size: 15 KB rows: 264
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-24 | SPY | ETF | 119.44 | 119.83 | 119.2 | 119.5 | 50654100.0 |
| 2005-05-24 | QQQ | ETF | 37.76 | 38.0 | 37.7 | 37.97 | 100988450.0 |
| 2005-05-24 | IWM | ETF | 60.78 | 61.125 | 60.63 | 60.75 | 21963200.0 |
| 2005-05-24 | DIA | ETF | 104.92 | 105.13 | 104.63 | 104.83 | 5147900.0 |
| 2005-05-24 | GLD | ETF | 41.83 | 41.83 | 41.65 | 41.73 | 1684600.0 |
| 2005-05-24 | TLT | ETF | 94.53 | 94.65 | 94.18 | 94.43 | 1695400.0 |
| 2005-05-24 | AAA | ETF | 59.24 | 59.24 | 58.8 | 59.09 | 86500.0 |
| 2005-05-24 | ADRE | ETF | 86.3 | 86.83 | 86.1 | 86.83 | 2716.0 |
| 2005-05-24 | AFK | ETF | 26.25 | 26.47 | 26.24 | 26.33 | 4600.0 |
| 2005-05-24 | AGG | ETF | 102.63 | 102.7 | 102.41 | 102.65 | 81500.0 |
| 2005-05-24 | AIQ | ETF | 54.95 | 54.95 | 52.8 | 53.25 | 13680.0 |
| 2005-05-24 | ARB | ETF | 40.94 | 41.13 | 40.81 | 41.02 | 127100.0 |
| 2005-05-24 | BAB | ETF | 50.11 | 50.19 | 49.85 | 49.99 | 11100.0 |
| 2005-05-24 | BBH | ETF | 56.1333 | 56.2967 | 55.5567 | 55.7533 | 2434200.0 |
| 2005-05-24 | BCM | ETF | 59.82 | 60.05 | 59.47 | 59.47 | 8000.0 |
| 2005-05-24 | BIS | ETF | 648.0 | 649.6 | 648.0 | 648.0 | 42.5 |
| 2005-05-24 | BITS | ETF | 10.7204 | 11.2 | 10.0 | 11.2 | 13382.0 |
| 2005-05-24 | BKF | ETF | 33.0 | 33.0 | 32.18 | 32.53 | 46400.0 |
| 2005-05-24 | BNE | ETF | 12.66 | 12.72 | 12.52 | 12.71 | 124800.0 |
| 2005-05-24 | BRF | ETF | 15.35 | 15.41 | 15.35 | 15.4 | 7400.0 |
| 2005-05-24 | BTF | ETF | 85.55 | 86.44999999999999 | 85.5 | 86.25 | 3560.0 |
| 2005-05-24 | CBON | ETF | 27.392 | 27.392 | 27.02 | 27.3 | 3800.0 |
| 2005-05-24 | CDC | ETF | 7.59 | 7.59 | 7.59 | 7.59 | 1000.0 |
| 2005-05-24 | CDL | ETF | 12.02 | 12.31 | 12.0 | 12.14 | 192000.0 |
| 2005-05-24 | CEF | ETF | 5.19 | 5.26 | 5.16 | 5.26 | 258300.0 |
| 2005-05-24 | CEW | ETF | 26.6 | 26.68 | 26.5 | 26.68 | 2200.0 |
| 2005-05-24 | CGW | ETF | 28.0 | 28.0 | 28.0 | 28.0 | 400.0 |
| 2005-05-24 | CHB | ETF | 9.96 | 10.02 | 9.87 | 10.01 | 260300.0 |
| 2005-05-24 | CHIC | ETF | 11.2 | 11.41 | 11.2 | 11.335 | 117623.0 |
| 2005-05-24 | CHIR | ETF | 36.1899 | 36.6501 | 36.03 | 36.5799 | 687685.0 |
| 2005-05-24 | CIL | ETF | 26.5 | 26.53 | 26.5 | 26.53 | 300.0 |
| 2005-05-24 | CN | ETF | 27.35 | 27.39 | 27.2 | 27.39 | 5800.0 |
| 2005-05-24 | CNXT | ETF | 1.39 | 1.4194 | 1.35 | 1.41 | 9418776.0 |
| 2005-05-24 | CPI | ETF | 23.0 | 23.17 | 23.0 | 23.17 | 4800.0 |
| 2005-05-24 | CSB | ETF | 30.28 | 30.53 | 30.15 | 30.5 | 5300.0 |
| 2005-05-24 | CSM | ETF | 2.405 | 2.405 | 2.405 | 2.405 | 8800.0 |
| 2005-05-24 | CTEC | ETF | 42.949999999999996 | 44.65 | 39.75 | 44.0 | 49646.8 |
| 2005-05-24 | CURE | ETF | 0.3113 | 0.3362 | 0.3088 | 0.3175 | 2565784.0 |
| 2005-05-24 | CYA | ETF | 161.0 | 161.0 | 158.0 | 159.0 | 140.0 |
| 2005-05-24 | CYB | ETF | 3.1 | 3.1 | 3.09 | 3.09 | 2800.0 |
| 2005-05-24 | DGT | ETF | 63.96 | 64.14 | 63.96 | 64.09 | 3100.0 |
| 2005-05-24 | DIG | ETF | 10.9125 | 11.0625 | 10.9125 | 11.0625 | 3520.0 |
| 2005-05-24 | DIV | ETF | 13.54 | 13.66 | 13.48 | 13.61 | 19800.0 |
| 2005-05-24 | DRIV | ETF | 26.42 | 26.44 | 25.65 | 25.69 | 1291168.0 |
| 2005-05-24 | DSI | ETF | 6.03 | 6.03 | 6.025 | 6.025 | 1400.0 |
| 2005-05-24 | DUSA | ETF | 10.77 | 11.04 | 10.77 | 10.93 | 120029.0 |
| 2005-05-24 | DVY | ETF | 61.35 | 61.37 | 61.08 | 61.3 | 385000.0 |
| 2005-05-24 | EDEN | ETF | 0.64 | 0.7 | 0.59 | 0.66 | 86499.0 |
| 2005-05-24 | EDV | ETF | 26.36 | 26.6 | 26.32 | 26.35 | 11900.0 |
| 2005-05-24 | EEM | ETF | 22.8633 | 22.9089 | 22.8222 | 22.9089 | 2808000.0 |
> showing 50 of 264 rows — these rows as CSV