PREVIEW / etf_daily / 2005-03-28
file: by_date/etf_daily/2005/2005-03-28.parquet size: 15 KB rows: 263
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-03-28 | SPY | ETF | 117.42 | 117.94 | 117.31 | 117.31 | 46765500.0 |
| 2005-03-28 | QQQ | ETF | 36.41 | 36.611 | 36.31 | 36.34 | 59773984.0 |
| 2005-03-28 | IWM | ETF | 61.255 | 61.505 | 60.97 | 61.075 | 12566800.0 |
| 2005-03-28 | DIA | ETF | 104.6 | 105.23 | 104.56 | 104.76 | 4968200.0 |
| 2005-03-28 | GLD | ETF | 42.46 | 42.58 | 42.41 | 42.54 | 581100.0 |
| 2005-03-28 | TLT | ETF | 87.99 | 88.0 | 87.72 | 87.73 | 382200.0 |
| 2005-03-28 | AAA | ETF | 62.4 | 63.0 | 62.4 | 62.6 | 27400.0 |
| 2005-03-28 | ADRE | ETF | 82.46 | 84.63 | 82.46 | 84.09 | 3636.0 |
| 2005-03-28 | AFK | ETF | 25.4 | 25.5 | 25.32 | 25.37 | 28700.0 |
| 2005-03-28 | AGG | ETF | 100.72 | 100.72 | 100.41 | 100.64 | 83100.0 |
| 2005-03-28 | AIQ | ETF | 47.05 | 47.05 | 44.85 | 45.85 | 33360.0 |
| 2005-03-28 | ARB | ETF | 42.4 | 42.75 | 42.32 | 42.51 | 248500.0 |
| 2005-03-28 | BAB | ETF | 50.04 | 50.56 | 49.91 | 50.07 | 16000.0 |
| 2005-03-28 | BBH | ETF | 48.2333 | 48.3667 | 47.4 | 47.5 | 1391100.0 |
| 2005-03-28 | BCM | ETF | 58.53 | 58.81 | 58.09 | 58.58 | 19300.0 |
| 2005-03-28 | BIS | ETF | 704.0 | 704.0 | 704.0 | 704.0 | 1.875 |
| 2005-03-28 | BITS | ETF | 12.6 | 13.48 | 12.0 | 12.12 | 12955.0 |
| 2005-03-28 | BKF | ETF | 40.15 | 40.51 | 39.99 | 40.0 | 12900.0 |
| 2005-03-28 | BNE | ETF | 14.83 | 15.15 | 14.65 | 14.65 | 200300.0 |
| 2005-03-28 | BRF | ETF | 15.55 | 15.66 | 15.36 | 15.36 | 11100.0 |
| 2005-03-28 | BTF | ETF | 87.3 | 87.35 | 86.6 | 87.24999999999999 | 1680.0 |
| 2005-03-28 | CBON | ETF | 27.2 | 27.2 | 25.55 | 25.55 | 7645.0 |
| 2005-03-28 | CDC | ETF | 8.3 | 8.3 | 8.3 | 8.3 | 800.0 |
| 2005-03-28 | CDL | ETF | 13.73 | 14.07 | 13.7 | 13.93 | 245600.0 |
| 2005-03-28 | CEF | ETF | 5.34 | 5.43 | 5.29 | 5.29 | 309900.0 |
| 2005-03-28 | CEW | ETF | 26.69 | 26.69 | 26.69 | 26.69 | 400.0 |
| 2005-03-28 | CGW | ETF | 30.0 | 30.0 | 30.0 | 30.0 | 100.0 |
| 2005-03-28 | CHB | ETF | 9.6 | 9.76 | 9.54 | 9.61 | 407400.0 |
| 2005-03-28 | CHIC | ETF | 11.85 | 12.12 | 11.8 | 11.81 | 163402.0 |
| 2005-03-28 | CHIR | ETF | 35.7201 | 35.9301 | 35.31 | 35.3799 | 761256.0 |
| 2005-03-28 | CID | ETF | 9.2 | 9.28 | 9.17 | 9.28 | 8000.0 |
| 2005-03-28 | CIZ | ETF | 20.9 | 20.9 | 20.9 | 20.9 | 300.0 |
| 2005-03-28 | CN | ETF | 27.8 | 27.8 | 27.74 | 27.8 | 44900.0 |
| 2005-03-28 | CNXT | ETF | 1.45 | 1.47 | 1.36 | 1.38 | 7992645.0 |
| 2005-03-28 | CPI | ETF | 19.3 | 19.3 | 18.95 | 18.95 | 4500.0 |
| 2005-03-28 | CSB | ETF | 32.8 | 32.8 | 32.65 | 32.65 | 4300.0 |
| 2005-03-28 | CSM | ETF | 2.375 | 2.375 | 2.375 | 2.375 | 10400.0 |
| 2005-03-28 | CTEC | ETF | 49.74999999999999 | 51.25 | 49.74999999999999 | 49.9 | 8370.0 |
| 2005-03-28 | CURE | ETF | 0.3725 | 0.3837 | 0.3663 | 0.3713 | 1542992.0 |
| 2005-03-28 | CYA | ETF | 164.0 | 168.0 | 162.0 | 162.0 | 295.0 |
| 2005-03-28 | CYB | ETF | 4.03 | 4.08 | 3.97 | 4.0 | 16300.0 |
| 2005-03-28 | CZA | ETF | 10.43 | 10.43 | 10.43 | 10.43 | 1500.0 |
| 2005-03-28 | DGT | ETF | 62.98 | 63.29 | 62.98 | 63.14 | 9300.0 |
| 2005-03-28 | DIV | ETF | 12.6 | 12.64 | 12.48 | 12.56 | 28300.0 |
| 2005-03-28 | DJP | ETF | 27.03 | 27.03 | 27.03 | 27.03 | 600.0 |
| 2005-03-28 | DRIV | ETF | 30.6 | 31.37 | 30.2 | 31.07 | 644252.0 |
| 2005-03-28 | DSI | ETF | 5.875 | 5.875 | 5.875 | 5.875 | 400.0 |
| 2005-03-28 | DUSA | ETF | 9.65 | 9.65 | 9.33 | 9.37 | 50061.0 |
| 2005-03-28 | DVY | ETF | 59.4 | 59.58 | 59.3 | 59.4 | 501000.0 |
| 2005-03-28 | EDEN | ETF | 0.75 | 0.77 | 0.75 | 0.75 | 30327.0 |
> showing 50 of 263 rows — these rows as CSV