PREVIEW / etf_daily / 2005-03-24
file: by_date/etf_daily/2005/2005-03-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-03-24 | SPY | ETF | 117.46 | 117.99 | 117.06 | 117.14 | 51932500.0 |
| 2005-03-24 | QQQ | ETF | 36.39 | 36.65 | 36.27 | 36.27 | 77711689.0 |
| 2005-03-24 | IWM | ETF | 61.15 | 61.625 | 61.005 | 61.05 | 14170800.0 |
| 2005-03-24 | DIA | ETF | 104.72 | 105.15 | 104.35 | 104.44 | 5058600.0 |
| 2005-03-24 | GLD | ETF | 42.51 | 42.54 | 42.37 | 42.39 | 1466300.0 |
| 2005-03-24 | TLT | ETF | 88.32 | 88.46 | 88.18 | 88.27 | 746800.0 |
| 2005-03-24 | AAA | ETF | 62.7 | 63.2 | 62.52 | 63.2 | 23300.0 |
| 2005-03-24 | ADRE | ETF | 83.0 | 84.734 | 82.06 | 84.49 | 10348.0 |
| 2005-03-24 | AFK | ETF | 25.32 | 25.44 | 25.31 | 25.38 | 13000.0 |
| 2005-03-24 | AGG | ETF | 100.65 | 100.99 | 100.55 | 100.84 | 101500.0 |
| 2005-03-24 | AIQ | ETF | 46.25 | 48.0 | 46.25 | 47.1 | 31640.0 |
| 2005-03-24 | ARB | ETF | 42.49 | 42.8 | 42.3 | 42.49 | 170700.0 |
| 2005-03-24 | BAB | ETF | 50.3 | 50.48 | 50.0 | 50.04 | 12000.0 |
| 2005-03-24 | BBH | ETF | 47.9 | 48.3933 | 47.7333 | 48.2 | 1274700.0 |
| 2005-03-24 | BCM | ETF | 58.7 | 58.85 | 58.49 | 58.61 | 17100.0 |
| 2005-03-24 | BIS | ETF | 720.0 | 720.0 | 720.0 | 720.0 | 1.875 |
| 2005-03-24 | BITS | ETF | 13.0 | 13.6 | 12.48 | 12.72 | 11921.0 |
| 2005-03-24 | BKF | ETF | 40.0 | 40.59 | 40.0 | 40.25 | 16400.0 |
| 2005-03-24 | BNE | ETF | 14.89 | 14.99 | 14.71 | 14.79 | 252200.0 |
| 2005-03-24 | BOSS | ETF | 23.82 | 23.82 | 23.82 | 23.82 | 200.0 |
| 2005-03-24 | BRF | ETF | 15.47 | 15.5 | 15.41 | 15.5 | 8100.0 |
| 2005-03-24 | BTF | ETF | 87.5 | 87.55 | 87.2 | 87.2 | 320.0 |
| 2005-03-24 | CBON | ETF | 26.789 | 26.789 | 25.65 | 25.76 | 12093.0 |
| 2005-03-24 | CDC | ETF | 8.4 | 8.4 | 8.27 | 8.3 | 3500.0 |
| 2005-03-24 | CDL | ETF | 13.86 | 13.88 | 13.55 | 13.65 | 134200.0 |
| 2005-03-24 | CEF | ETF | 5.35 | 5.46 | 5.31 | 5.35 | 430000.0 |
| 2005-03-24 | CEW | ETF | 26.66 | 26.66 | 26.52 | 26.52 | 2000.0 |
| 2005-03-24 | CGW | ETF | 30.0 | 30.0 | 30.0 | 30.0 | 600.0 |
| 2005-03-24 | CHB | ETF | 9.41 | 9.79 | 9.41 | 9.53 | 685500.0 |
| 2005-03-24 | CHIC | ETF | 12.1 | 12.13 | 11.86 | 11.87 | 77735.0 |
| 2005-03-24 | CHIR | ETF | 35.73 | 36.0999 | 35.31 | 35.6799 | 1263176.0 |
| 2005-03-24 | CID | ETF | 9.22 | 9.22 | 9.22 | 9.22 | 1500.0 |
| 2005-03-24 | CIL | ETF | 26.07 | 26.2 | 26.07 | 26.1 | 1700.0 |
| 2005-03-24 | CN | ETF | 28.0 | 28.0 | 27.7 | 27.8 | 7200.0 |
| 2005-03-24 | CNXT | ETF | 1.47 | 1.51 | 1.4 | 1.44 | 5834246.0 |
| 2005-03-24 | CPI | ETF | 19.22 | 19.75 | 19.22 | 19.75 | 1200.0 |
| 2005-03-24 | CSB | ETF | 32.78 | 33.15 | 32.53 | 33.08 | 6400.0 |
| 2005-03-24 | CSM | ETF | 2.375 | 2.375 | 2.375 | 2.375 | 800.0 |
| 2005-03-24 | CTEC | ETF | 51.199999999999996 | 51.449999999999996 | 50.0 | 50.0 | 4331.0 |
| 2005-03-24 | CURE | ETF | 0.35 | 0.365 | 0.35 | 0.365 | 1079240.0 |
| 2005-03-24 | CYA | ETF | 166.4 | 170.0 | 164.0 | 166.0 | 480.0 |
| 2005-03-24 | CYB | ETF | 3.88 | 3.99 | 3.88 | 3.99 | 10100.0 |
| 2005-03-24 | CZA | ETF | 10.41 | 10.49 | 10.41 | 10.49 | 1400.0 |
| 2005-03-24 | DGT | ETF | 63.3 | 63.35 | 63.02 | 63.02 | 4000.0 |
| 2005-03-24 | DIV | ETF | 12.5 | 12.6 | 12.44 | 12.6 | 26300.0 |
| 2005-03-24 | DJP | ETF | 27.03 | 27.03 | 27.03 | 27.03 | 200.0 |
| 2005-03-24 | DRIV | ETF | 30.3 | 31.38 | 30.3 | 30.53 | 1349636.0 |
| 2005-03-24 | DUSA | ETF | 9.17 | 9.8 | 9.17 | 9.47 | 75614.0 |
| 2005-03-24 | DVY | ETF | 59.27 | 59.6 | 59.2 | 59.25 | 649200.0 |
| 2005-03-24 | EDEN | ETF | 0.75 | 0.75 | 0.75 | 0.75 | 12177.0 |
> showing 50 of 264 rows — these rows as CSV