PREVIEW / etf_daily / 2015-01-28

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-28.parquet
  size:    47 KB
  rows:    1,163

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
2015-01-28	SPY	ETF	204.17	204.29	199.91	200.14	168514300.0
2015-01-28	QQQ	ETF	103.07	103.18	100.9	100.92	43591675.0
2015-01-28	IWM	ETF	119.18	119.45	116.32	116.69	38086100.0
2015-01-28	DIA	ETF	174.55	174.61	171.59	171.72	9673200.0
2015-01-28	GLD	ETF	123.52	123.89	122.94	123.42	8470600.0
2015-01-28	TLT	ETF	134.75	137.41	134.7	136.77	12230300.0
2015-01-28	AADR	ETF	36.91	37.01	36.91	37.01	1200.0
2015-01-28	AAXJ	ETF	63.67	63.81	62.99	63.09	806200.0
2015-01-28	ACWI	ETF	59.02	59.02	57.94	57.97	3868100.0
2015-01-28	ACWV	ETF	71.28	71.34	70.29	70.43	77100.0
2015-01-28	ACWX	ETF	43.82	43.82	43.09	43.13	594086.0
2015-01-28	ADRE	ETF	37.0	37.0	36.35	36.35	15662.0
2015-01-28	AFK	ETF	25.67	25.67	25.27	25.42	25611.0
2015-01-28	AGG	ETF	111.7	112.22	111.67	112.07	1327800.0
2015-01-28	AGQ	ETF	49.53	50.43	49.22	49.45	141600.0
2015-01-28	AGZ	ETF	114.7399	114.7399	114.155	114.5153	20963.0
2015-01-28	AGZD	ETF	24.525	24.54	24.415	24.43	12000.0
2015-01-28	AIA	ETF	49.08	49.1	48.789	48.8649	52219.0
2015-01-28	AIQ	ETF	24.4	24.75	23.03	23.13	17821.0
2015-01-28	AIRR	ETF	17.28	17.28	16.72	16.75	30800.0
2015-01-28	AIVI	ETF	44.04	44.05	43.31	43.31	16900.0
2015-01-28	AMJ	ETF	45.12	45.22	43.881	44.0499	1183117.0
2015-01-28	AMLP	ETF	86.35	86.6	84.9	85.1	1065860.0
2015-01-28	AMZA	ETF	216.0	216.0	214.5	214.5	70.0
2015-01-28	ANGL	ETF	26.53	26.91	26.53	26.91	2500.0
2015-01-28	AOA	ETF	46.94	46.94	46.18	46.21	55400.0
2015-01-28	AOK	ETF	32.9	32.9	32.71	32.71	32855.0
2015-01-28	AOM	ETF	35.54	35.54	35.2399	35.26	133803.0
2015-01-28	AOR	ETF	40.57	40.57	40.055	40.078	304893.0
2015-01-28	ARGT	ETF	18.8	18.89	18.36	18.36	35200.0
2015-01-28	ARKG	ETF	22.72	22.72	22.27	22.27	2100.0
2015-01-28	ARKK	ETF	20.44	20.44	20.35	20.35	300.0
2015-01-28	ARKQ	ETF	19.198	19.198	18.93	18.93	8700.0
2015-01-28	ARKW	ETF	20.88	20.88	20.45	20.45	3600.0
2015-01-28	ASEA	ETF	15.79	15.79	15.65	15.65	7600.0
2015-01-28	ASHR	ETF	35.7	35.88	35.3	35.43	1438900.0
2015-01-28	ASHS	ETF	37.24	37.26	36.81	36.81	9300.0
2015-01-28	ATMP	ETF	29.59	29.59	29.11	29.11	23200.0
2015-01-28	AVIV	ETF	39.66	40.21	39.44	39.89	294105.0
2015-01-28	AWAY	ETF	27.13	27.459	26.56	26.64	1444256.0
2015-01-28	BAB	ETF	31.02	31.26	30.9801	31.215	252981.0
2015-01-28	BAL	ETF	39.93	40.42	39.88	40.33	4274.0
2015-01-28	BALT	ETF	1.69	1.7	1.49	1.5	1136412.0
2015-01-28	BAR	ETF	3.5	3.5	3.425	3.425	22160.0
2015-01-28	BBC	ETF	30.5	30.5	28.9752	29.0	37838.0
2015-01-28	BBH	ETF	125.55	125.68	121.94	121.96	232900.0
2015-01-28	BBP	ETF	28.782	28.782	28.0	28.0	13000.0
2015-01-28	BCM	ETF	30.392	30.392	30.38	30.38	753.0
2015-01-28	BFOR	ETF	7.8475	7.8475	7.6975	7.7075	100000.0
2015-01-28	BIB	ETF	72.85	73.125	68.755	68.945	774830.0

> showing 50 of 1,163 rows — these rows as CSV

> unlock the full archive -- $79 one-time